What permissions are required to fetch data from Snowflake?

This topic was automatically generated from Slack. You can find the original thread here.

Jeffrey Gu : Perhaps this is a somewhat obscure question, but I’m hoping to move data from mixpanel into Snowflake with mixpanel’s own data pipeline, so that I can ultimately use Snowflake as a source in Pipedream. However, they say this in their docs:
> Mixpanel exports data to its own Snowflake account and gives your Snowflake account access to read the data. As a result, you will need a Snowflake account to be able to use the exported data. For more information on how to use your shared data, see Sharing Data in Snowflake.
Do you guys foresee me having a problem using that shared table as a source inside my Pipedream account? I imagine that the permissions given for read-only might be problematic.

Jeffrey Gu : This line in the Snowflake docs makes me think it’ll be okay:
• On the consumer side, a read-only database is created from the share. Access to this database is configurable using the same, standard role-based access control that Snowflake provides for all objects in the system.
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

Dylan Sather (Pipedream) : our Snowflake sources only require read permissions on the target tables to run queries / fetch new records, so as long as you have Snowflake credentials that can read from those tables, this should work