'How can we create a stream on a shared database object in Snowflake
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.
Solution 1:[1]
It should be possible, see here:
- https://docs.snowflake.com/en/user-guide/streams.html#streams-on-shared-tables
- https://docs.snowflake.com/en/user-guide/data-sharing-provider.html#enabling-data-consumers-to-create-table-streams-on-shared-tables
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Marcel |