Skip to main content
Join the official Python Developers Survey 2018 and win valuable prizes: Start the survey!

Unix service to suspend the snowflake warehouses smartly to cut the cost.

Project description

Snowflake-Smart-Suspend intelligently suspends the running warehouse which are not being used and reaching hour boundary. Currently designed for warehouses with auto-resume enabled and without auto-suspend for better optimisation.

Usage and Details

Installation:

pip install snowflake-smart-suspend

Typical usage often looks like this:

smart_suspend start -c connections -r <role which has access to warehouses of interest> -s 55 -i 30 -w <space separated list of warehouses>

You can find the details about all the options with:

smart_suspend -h
smart_suspend --help

Configurations

If you have snowsql installed and running on the server smart-suspend will work out of the box If not you will have to have file at location HOME/.snowsql/config with snowflake cred:

[connections]
accountname = <account name>
username = <username>
password = <password>

Logging

Logs could be find in /var/log/smartsuspend/system.log. You might need to adjust the permissions to log directory during installation.

Dependancies

  • Its written for Python3 which is the present and future of the language

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
snowflake-smart-suspend-0.2.2.tar.gz (6.2 kB) Copy SHA256 hash SHA256 Source None Aug 4, 2017

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page