Which of the below steps are required to create streams on shared tables?

Which of the below steps are required to create streams on shared tables?
A . Enable change tracking
B. Extend the data retention period for the table
C. Enable search virtualization on the table

View Answer

Answer: A, B

Explanation

This is an important topic, please read this section carefully https://docs.snowflake.com/en/user-guide/data-sharing-provider.html#enabling-data-consumers-to-create-tab le-streams-on-shared-tables

Enabling Data Consumers to Create Table Streams on Shared Tables

In order for data consumers to create streams on shared tables, you must enable change tracking on the tables. In addition, the data retention period should be extended for the tables. Enable change tracking

Currently, when the first stream for a local table is created, a pair of hidden columns are automatically added to the table and begin storing change tracking metadata. This change is not possible for shared tables, because a consumer of a share cannot modify the source database. Instead, to enable change tracking for tables intended for sharing, execute ALTER TABLE … CHANGE_TRACKING = TRUE on each of the tables. Extend the data retention period for the table

When a stream on a local table is not consumed regularly, Snowflake temporarily extends the data retention period for the source table to help avoid staleness. If the data retention period for the table is less than 14 days, then behind the scenes, the period is extended to the smaller of the stream transactional offset or 14 days (if the data retention period for the table is less than 14 days) regardless of the Snowflake edition for your account. When the stream is consumed, the extended data retention period is reduced to the default period for the table.

A stream on a shared table does not extend the data retention period for the table. To manually specify a longer data retention period for any shared table, set the DATA_RETENTION_TIME_IN_DAYS parameter. The CHANGE_TRACKING and DATA_RETENTION_TIME_IN_DAYS parameters can be set when creating a table (using CREATE TABLE) or later (using ALTER TABLE).