SnowflakeSource
SnowflakeSources hold the connection information to Snowflake data sources.
Example
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. |
type | string | None |