How can we create a stream on a shared database object in Snowflake

Question

I have a shared database in my snowflake account. using the shared database table i need to create my target table in scd type 2 format. generally in snowflake we use stream to create scd type 2 table, when i tried creating stream on shared table snowflake is throwing an error.

Kidly guide me how to create a stream on a shared table.

user_12480431 · Answer

It should be possible, see here:

One pre-requisite is that the provider enables change tracking on the tables (second link). If this was the case, it would be helpful if you could please provide some code + error message.

How can we create a stream on a shared database object in Snowflake

1 Answers