snowconvert-deploy-tool 0.0.1a1

Mobilize.Net Database Deploy tool for Snowflake

sc-deploy-db is a multi-platform command line tool for deploying scripts to Snowflake

Installation

$ pip install snowconvert-deploy

Usage

$ sc-deploy-db -h

For general help content, pass in the -h parameter:

SnowConvertStudio Deployment Script
===================================
usage: sc-deploy-db [-h] User Password Workspace InPath LogPath [Split] [SplitPattern] [ObjectType]
positional arguments:
User          User
Password      Password
Workspace     Path for workspace root
InPath        Path for SQL scripts
LogPath       Path for process logs
Split         Allow splitting file contents when several statements are detected
SplitPattern  Regex Pattern to use to split scripts. Use capture groups to keep separator
ObjectType    Object Type to deploy table,view,procedure,function,macro

optional arguments:

-h, --help

show this help message and exit

This tool assumes :

• that you have a collection of .sql files under a directory. It will then execute all those .sql files connecting to the specified database.

• that each file contains only one statement.

Note

If your files contains several statements you can use the Split and SplitPattern arguments, so the tool will try to split the statements prior to execution.

Examples

If you have a folder structure like:

+ code
   + procs
     proc1.sql
   + tables
     table1.sql
     + folder1
         table2.sql

You can deploy then by running:

sc-deploy-db -A my_sf_account -WH my_wh -U user -P password -I code

Reporting issues and feedback

If you encounter any bugs with the tool please file an issue in the Issues section of our GitHub repo.

License

sc-deploy-db is licensed under the MIT license.