Creating and managing shares in Snowflake - Quick Revision & Summary

Recall & Review

beginner

What is a share in Snowflake?

A share in Snowflake is a way to securely share database objects like tables and views with other Snowflake accounts without copying data.

beginner

How do you create a share in Snowflake?

Use the SQL command: CREATE SHARE share_name; This creates an empty share to which you can add database objects.

intermediate

How do you add a table to a share?

Use ALTER SHARE share_name ADD TABLE database_name.schema_name.table_name; to add a table to the share.

intermediate

What is the difference between a share and a database clone in Snowflake?

A share allows data access without copying data, while a clone creates a full copy of the database or table.

beginner

How do you revoke access to a share?

Use DROP SHARE share_name; to remove the share and revoke access from all consumers.

Which command creates a new share in Snowflake?

A CREATE SHARE my_share;

B CREATE DATABASE my_share;

C CREATE TABLE my_share;

D CREATE SCHEMA my_share;

The correct command to create a share is CREATE SHARE followed by the share name.

How do you add a table named 'sales' in schema 'public' of database 'db1' to a share called 'share1'?

A CREATE SHARE share1 ADD TABLE sales;

B ALTER DATABASE db1 ADD TABLE sales TO share1;

C ALTER SHARE share1 ADD TABLE db1.public.sales;

D GRANT SELECT ON TABLE sales TO share1;

You add a table to a share using ALTER SHARE with ADD TABLE and the full table path.

What happens when you DROP a share in Snowflake?

A The share is paused but data remains accessible.

B The share is removed and all consumers lose access.

C The data in the share is deleted.

D The share is converted to a clone.

Dropping a share removes it and revokes access for all consumers, but does not delete the underlying data.

Which of the following is NOT a valid object to add to a share?

A Stored procedure

B Table

C File format

D View

Stored procedures cannot be shared; only tables, views, and some other objects can be added to shares.

What is the main benefit of using shares in Snowflake?

A Encrypting data automatically

B Creating backups of data

C Improving query speed

D Sharing data without copying it

Shares allow secure data sharing without duplicating data, saving storage and time.

Explain the steps to create a share and add a table to it in Snowflake.

Think about first creating an empty share, then adding objects to it.

Describe how Snowflake shares differ from cloning databases or tables.

Focus on data duplication and access differences.