Which of the following objects can be included in a Snowflake share?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Which of the following objects can be included in a Snowflake share?

Explanation:
Snowflake data sharing publishes data objects to other accounts, exposing objects that actually provide data rather than executable code. An external table fits this model because it represents data located outside Snowflake (in external storage) that you can surface through the share along with the necessary access metadata. This lets the consumer query the external data via Snowflake without duplicating it. The other items are not data-access objects published by a share: stored procedures are executable code, tasks are scheduled jobs, and regular views depend on underlying data within your account and aren’t standalone data sources exposed through a share.

Snowflake data sharing publishes data objects to other accounts, exposing objects that actually provide data rather than executable code. An external table fits this model because it represents data located outside Snowflake (in external storage) that you can surface through the share along with the necessary access metadata. This lets the consumer query the external data via Snowflake without duplicating it. The other items are not data-access objects published by a share: stored procedures are executable code, tasks are scheduled jobs, and regular views depend on underlying data within your account and aren’t standalone data sources exposed through a share.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy