Skip to main content

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


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


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:

accountname = <account name>
username = <username>
password = <password>


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


  • 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.

Source Distribution

snowflake-smart-suspend-0.2.2.tar.gz (6.2 kB view hashes)

Uploaded source

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page