CODEWITHSUNDEEP
snowflake-cloud-data-platformdata-sharing
HelloWorld
HelloWorld

Reputation: 171

Querying for Shares?

Is there a way to query/filter for data shares in a Snowflake account? I know that you can use below two queries to display information:

SHOW SHARES;

DESC SHARE my_share;

But I cannot use above to filter results (with a where clause). Is there any place like the information_schema where I can simply query about shares and filter on the output columns? For example, I would like to query for all outbound shares that are sharing a particular table.

Note: I did run into result_scan option, but I am looking for direct way to query. It feels a bit hacky to use this approach and also not sure if it will work from application code where there could be many queries running in parallel.

Upvotes: 0

Views: 357

Answers (0)

Related Questions