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
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.
E.g: (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
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.1a3.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | f76e1d98f3e0739b5a5692d78f8efa6fa0fff4be8437e304ebf72fd36ebdf547 |
|
MD5 | e47731f1accebf383e255ead1216c407 |
|
BLAKE2b-256 | 2a1d3670ff61a6f0ec9357c18ae6b3c36a94b57499371807421d0cc90c4e3992 |
Hashes for snowconvert_deploy_tool-0.0.1a3-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fda85278636ff2d7802101d3936c640e7091a5e83df41505c5b15a471395a6d8 |
|
MD5 | 893781162ca33d29fa8189a51a2f807e |
|
BLAKE2b-256 | a38d631e589755d8f2a6a5fcebd818e16c599d8ffe496894bcc46f1adcb5dc10 |