Snowctl

A cli tool for automating tasks in Snowflake Database.

Installation

Install python3 (version 3.6 and higher)

Use Python's pip installer to install or update snowctl

pip install snowctl
pip install snowctl --upgrade

Usage

Run in interactive mode (prompts for configuration on the first run)

snowctl

Optional arguments

usage: snowctl [-h] [-d] [-s] [-c] [-e]

optional arguments:
  -h, --help           show this help message and exit
  -d, --debug          log to console
  -s, --safe           ask for confirmation before executing copy operations
  -c, --configuration  re-input configuration values
  -e, --echo           echo configuration values
  -v, --version        display snowctl version

Commands

CMD	ACTION
help	display help
use db/schema/warehouse name	change context
copy [-h] [-d] [-f] [-r]	copy views across schemas, see flags below
list filter	list views in current context with an optional filter
peek view	display first row from a view
sql query	execute sql query
exit	Exit

usage: copy

optional arguments:
  -h, --help    show this help message
  -d, --derive  create new view by selecting all cols from source view instead of copying ddl
  -f, --filter  filter out columns of target view when copying
  -r, --rename  rename target views

License
- OSI Approved :: MIT License
Operating System
- OS Independent
Programming Language
- Python :: 3

Metadata

License
- OSI Approved :: MIT License
Operating System
- OS Independent
Programming Language
- Python :: 3

Release files for snowctl 1.0.9

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Built distribution (wheel)

Table of built distributions (wheels) for snowctl 1.0.9
File	Interpreter	ABI	Platform	Reset
snowctl-1.0.9-py3-none-any.whl 10.3 kB Aug 7, 2020	Python 3	none	any	Details

Release files / snowctl-1.0.9-py3-none-any.whl

Download URL	snowctl-1.0.9-py3-none-any.whl
Size	10.3 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`51318705af37ac182600007cd2065a8f967241948cb1162dd19508a622980905`
BLAKE2b-256 checksum How to use checksums	`5299420ee8efe4b70013bffc9bf5806823bc7cc77a095e282e2c65dbe352be1b`
Upload date	Aug 7, 2020
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/3.1.1 pkginfo/1.5.0.1 requests/2.23.0 setuptools/47.3.1 requests-toolbelt/0.9.1 tqdm/4.45.0 CPython/3.8.3`