SnowflakeSource

SnowflakeSources hold the connection information to Snowflake data sources.

Example

Simple

    sources:
      - name: snowflake_source
        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 sources overview.

Attributes

Field	Type	Default	Description
path	string	None	A unique path to this object
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.
timezone	string	None	The timezone that you want to use by default when running queries.
type	string	None
connection_pool_size	integer	8	The pool size that is used for this connection.