ploosh.

Documentation

Snowflake

This connector is used to query a Snowflake data warehouse using SQL.

Connection configuration

NameMandatoryDefaultDescription
account_identifieryesSnowflake account identifier (e.g. xy12345.us-east-1)
usernameyesUsername
passwordyesPassword
databasenoDatabase name
schemanoSchema name
warehousenoWarehouse name
rolenoRole name

Example

connections:
  snowflake_connection:
    type: snowflake
    account_identifier: xy12345.us-east-1
    username: my_user
    password: $var.snowflake_password
    database: my_database
    schema: public
    warehouse: my_warehouse
    role: my_role

Test case configuration

NameMandatoryDefaultDescription
queryyesSQL query to execute

Example

Example Snowflake:
  source:
    type: snowflake
    connection: snowflake_connection
    query: |
      SELECT *
      FROM employees
      WHERE hire_date < '2000-01-01'
  expected:
    type: csv
    path: data/employeesbefore2000.csv

Requirements

  • pip install snowflake-sqlalchemy (included in ploosh full installation)