Question

A data provider wants to share curated sales data with a small business partner. The partner does not have a Snowflake account and has no intention of purchasing one, but still needs to run SQL queries against the shared data. The provider wants to avoid copying or exporting any data. Which approach should the provider use?

Accepted Answer

Create a reader account for the partner and share the data into it; the provider bears the compute costs for the partner's queries

Answer

Create a direct share and grant it to the partner's account identifier, which the partner accesses using their own compute

Answer

Publish the data as a private listing on the Snowflake Marketplace and email the partner an access link

Answer

Use COPY INTO to unload the data to an external stage and give the partner temporary credentials to the cloud storage bucket