How to Export the Snowflake DDLs for Tables, Views, Procedures, Sequences using SnowHub.cloud
Updated: May 6, 2021
SnowHub.cloud was designed to facilitate the development of Snowflake Computing, the tool exports the DDLs from the following objects directly into GitHub branches to version control the code:
Tables
Views
Procedures
Sequences
User Defined Functions
File Formats
Stream
Tasks
Pipe
SnowHub has a new filter to select the desired objects:
To begin you will need to setup the Snowflake and GitHub connections as described on this post.
After setting up the connections, go to the Hub page and click on the plus icon near the list of branches.
Create a new branch and click on Save.
On the Hub page, select the desired Snowflake Role, Database, Schema and select all of the objects you want to export the DDL into GitHub. Click on Push To the new branch you just created, you should get a successful message at the end:
After exporting the content of the selected objects you should see to content exported directly into the GitHub branch. SnowHub exports the DDLs with the structure Database name / Schema / Object Type.
Open a desired exported file to analyse the content with the .DDL extension.
Conclusion: BRF Consulting development team is enhancing the SnowHub.cloud, if you have any suggestions please email us at snowhub@brfconsulting.com
About the author: Angelo Buss is a Solutions Architect and works for BRF Consulting - a Snowflake consulting partner with experience on BI and Big Data implementation.