Snowflake#

The connection to Snowflake is based on the snowflake-connector-python library.

Dependency#

  • snowflake-connector-python

Parameters#

Required:

  • user is the database user.

  • password is the snowflake account password.

  • database is the database name.

  • warehouse is the snowflake warehouse name.

  • account is the snowflake account number ( can be found in the url ).

  • schema is the schema name.

Warning

Provide the parameters of an already running Snowflake Data Warehouse. EvaDB only connects to an existing Snowflake Data Warehouse.

Create Connection#

CREATE DATABASE snowflake_data WITH ENGINE = 'snowflake', PARAMETERS = {
     "user": "<username>",
     "password": "<my_password>"
     "account": "<account_number>",
     "database": "EVADB",
     "warehouse":  "COMPUTE_WH",
     "schema": "SAMPLE_DATA"
};

Warning

In Snowflake Terminology, Database and Schema refer to the following.
A database is a logical grouping of schemas. Each database belongs to a single Snowflake account.
A schema is a logical grouping of database objects (tables, views, etc.). Each schema belongs to a single database.