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

Troubleshooting

Common error messages you may encounter when connecting to or querying Snowflake, along with their causes and solutions.

Query2 errors

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 superset.db_engine_specs.snowflake.py