Mobilize.Net Database Deploy tool for Snowflake
Project description
sc-deploy-db is a multi-platform command line tool for deploying scripts to Snowflake
Installation
$ pip install snowconvert-deploy-tool --upgrade
Usage
$ sc-deploy-db -h
For general help content, pass in the -h parameter:
usage: sc-deploy-db [-h] [-A ACCOUNT] [-D DATABASE] [-WH WAREHOUSE] [-R ROLE]
-U USER -P PASSWORD [-W WORKSPACE] -I INPATH [-L LOGPATH]
[--SplitPattern SPLITPATTERN] [--ObjectType [OBJECTTYPE]]
SnowConvertStudio Deployment Script
===================================
This script helps you to deploy a collection of .sql files to a Snowflake Account.
The tool will look for settings like:
- Snowflake Account
- Snowflake Warehouse
- Snowflake Role
- Snowflake Database
If the tool can find a config_snowsql.ini file in the current directory or in the workspace\config_snowsql.ini location
it will read those parameters from there.
optional arguments: -h, --help show this help message and exit -A ACCOUNT, --Account ACCOUNT Snowflake Account -D DATABASE, --Database DATABASE Snowflake Database -WH WAREHOUSE, --Warehouse WAREHOUSE Snowflake Warehouse -R ROLE, --Role ROLE Snowflake Role -U USER, --User USER Snowflake User -P PASSWORD, --Password PASSWORD Password -W WORKSPACE, --Workspace WORKSPACE Path for workspace root. Defaults to current dir -I INPATH, --InPath INPATH Path for SQL scripts -L LOGPATH, --LogPath LOGPATH Path for process logs. Defaults to current dir --SplitPattern SPLITPATTERN When provided it should be Regex Pattern to use to split scripts. Use capture groups to keep separator. For example: (CREATE OR REPLACE) --ObjectType [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.
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
If you want to use another authentication like Azure AD you can do:
sc-deploy-db -A my_sf_account -WH my_wh -U user -I code --authenticator externalbrowser
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.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for snowconvert-deploy-tool-0.0.2.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 201b232b706887cc8257c9f2ecd5093be9dfbb8d728e2c24600ed2b2ee8f6aaf |
|
MD5 | 246400a006cf14349047f28eb6e8ed9e |
|
BLAKE2b-256 | d9fb3ef146c7c426b12ebe551bcdfdbd6b07509f97bed0db01933261ca3e7835 |
Hashes for snowconvert_deploy_tool-0.0.2-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 46bcefdb19e0a3998e78e84162c75e54e898f1513b29663c80daf6eb41449ecd |
|
MD5 | 4f7258c78e8a50b47fc67b11459df543 |
|
BLAKE2b-256 | 7cc4445ecf0710c7dc8dd65edace1edab744dfafcf5d8959bc70a0a149ea508a |