What can you share, clone or replicate in Snowflake?

Maybe you are preparing for your Snowflake certification and you are trying to learn what you can clone or share. Or maybe you are wondering during your daily work “can i clone this and that”? What about my new stream or task? Can I share it with my reader account? Of course all that can be found in documentation but it is scattered over multiple pages. During my certification preparation I was looking for some kind of overview which would combine all those features in one place and present it in some easy to read and easy to remember format. I haven’t found such page in documentation and I hope I am not only one who thinks that would be valuable to have something like that available.

I have collected all that information from different documentation pages and put them into single table listing all basics objects (tables, views, task & streams, etc.) with features (cloning, data sharing, replication) and information if particular feature is supported for given object or not. You can find the overview in table below. Please take into consideration that support of particular features is changing over time so what is valid today (April 2021) doest not have to be valid in couple of months. For instance I know that support for replication of certain objects which are currently not supported is planned for future versions of Snowflake. That’s why provided table can become outdated in the future.

List of objects and features and support status

Snowflake documentation has been used to collect information for this overview. Please find below particular documentation pages where you can find details for each feature:

I hope I haven’t done any mistake in defining what is supported and what is not. If you find any mistake, let me know and I will correct the table. 🙏🏻

If you would like to include the table into your application or web page, please find below a code to embed it.

<iframe class="airtable-embed" src="https://airtable.com/embed/shr03x0kCmFtF1dNB?backgroundColor=red&viewControls=on" frameborder="0" onmousewheel="" width="100%" height="533" style="background: transparent; border: 1px solid #ccc;"></iframe>

If you are looking for more tips how to become Snowflake certified, check out my another post called How to get Snowflake certified where I provide overview about available materials, personal tips and learning recommendations for both Snowflake Certifications (SnowPro Core Designer and Advanced Architect).

Lead data engineer @TietoEVRY. Currently obsessed by cloud technologies and solutions in relation to data & analytics. ☁️ ❄️