top of page

How to Export the Snowflake DDLs for Tables, Views, Procedures, Sequences using

Updated: May 6, 2021 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, if you have any suggestions please email us at

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.

152 views0 comments
bottom of page