Snowflake Database Script Generator
Quickly script thousands of SQL objects from Snowflake database using a single click.
Why to use Snowflake Script Generator?
Snowflake Script Generator makes Data Engineer’s life much easier. Using this tool, Data Engineer can focus more on development rather than dealing with nuances of script generation.
Speed
Generates thousands of scripts in seconds while you take a sip of coffee. No matter how complex your code is, your script will be accurately generated at a blazing fast speed.
Consistency
All the objects will consistently have schema name and human readable formatting for ease of reading and code migration
Ease of Use
Easy to use software comes with greater control of script generation.
Snowflake Script Generator Vs GET_DDL Command
Snowflake provides GET_DDL to generate database object script but it has lots of limitations. As you explore more, you will be frustrated to deal with nuances. For some objects you will have database name added and at some places you will not have schema name. It poses challenges for using this script to compare your environment or migrate code from one environment to another. Snowflake Script Generator solves all of these problems. You will always get a consistent script to make your life easier.
Here is a feature comparison matrix.
| Feature | Script Generator | GET_DDL |
|---|---|---|
| Fix single quote characters | ✅ | ❌ |
| Consistently add schema name | ✅ | ❌ |
| Remove hard-coded database name to ease code migration from one environment to another | ✅ | ❌ |
| Consistence script generation makes it easy for DEV, QA and PROD object comparison and identify difference | ✅ | ❌ |
System Requirement
This software requires .Net 4.7.2 framework which is pre-installed on any Windows Server or PC.
Contact Me
If you have additional question or need any help, please contact me by filling out the form and I will get back to you.
Frequently Asked Questions
What is the free trial limitation?
Free trial is a full featured software but it has a limit of generating 5 script. You may use it to evaluate the software.
Does this software phone home?
This software does not phone home.
Is the Connection String stored/saved?
Security is the top most priority. If you choose to save your settings, all the settings including connection string are encrypted and stored to your preferred location.
What type of authentications are supported?
This application uses Snowflake .Net driver. All the authentications supported by Snowflake .Net driver are also supported by this application including but not limited to external browser, key pair and username/password.