Skip to content

SnowflakeTarget

SnowflakeTargets hold the connection information to Snowflake data sources.

Example

    targets:
      - name: snowflake_target
        type: snowflake
        database: DEV
        warehouse: DEV
        account: ab12345.us-west-1.aws
        db_schema: DEFAULT
        username: {{ env_var('SNOWFLAKE_USER') }}
        password: {{ env_var('SNOWFLAKE_PASSWORD') }}

Note: Recommended environment variable use is covered in the targets overview.

Attributes

Field Type Default Description
name string None The unique name of the object across the entire project.
host string None The host url of the database.
port integer None The port of the database.
database string None The database that the Visivo project will use in queries.
username string None Username for the database.
password string None Password corresponding to the username.
db_schema string None The schema that the Visivo project will use in queries.
account string None The snowflake account url. Here's how you find this: snowflake docs.
warehouse string None The compute warehouse that you want queries from your Visivo project to leverage.
role string None The access role that you want to use when running queries.
type string None