QuestionQ104

Data Collaboration

A data provider shares a database containing 5 TB of data with three consumer accounts. Each consumer creates a database from the share and queries the imported data using their own virtual warehouses.

Will the consumers incur costs for accessing this imported data?

Explanation

In Snowflake's Secure Data Sharing model, shared data is not copied or transferred to the consumer's account — the data continues to reside in the provider's storage, and consumers access it directly through read-only database objects created from the share. Because no data is duplicated into the consumer account, consumers are not charged for storage of the shared data, and there is no data transfer fee since sharing occurs via metadata pointers rather than physical movement. However, when a consumer runs queries against the shared data, they must use their own virtual warehouse to perform the compute, and that warehouse's usage is billed to the consumer's account. Thus consumers incur charges only for the compute resources they use to query the imported data.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!