Snowflake

https://www.snowflake.com/

Snowflake is a cloud-native data warehouse.

Installation

Required packages: snowflake-sqlalchemy

echo "snowflake-sqlalchemy" >> ./docker/requirements-local.txt

Connection String

snowflake://{user}:{password}@{account}.{region}/{database}?role={role}&warehouse={warehouse}

Connection Examples

With role and warehouse

snowflake://{user}:{password}@{account}.{region}/{database}?role={role}&warehouse={warehouse}

With defaults (role/warehouse optional)

snowflake://{user}:{password}@{account}.{region}/{database}

Authentication Methods

Key Pair Authentication

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 72/201

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Extended Time Grains:

FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR

Notes

Schema is not required in connection string. Ensure user has privileges for all databases/schemas/tables/views/warehouses.

Resources

Official Documentation

Help improve this documentation by editing the engine spec:

Edit snowflake.py