Connector
Snowflake
Last updated:
Visier can retrieve data through this connector if the following requirements are met.
Prerequisites
Create an integration user in Snowflake.
Integration user
Create an integration user in your source system and assign it the appropriate security access so that Visier can retrieve your source data through this user.
Access | Description |
|---|---|
SELECT or OWNERSHIP access | Create a role with SELECT or OWNERSHIP access to the tables you want Visier to retrieve. Assign the role to the integration user. |
Connector credentials
You need to provide the following credentials to Visier so that we can retrieve data from your source system.
Credential | Description | Example |
|---|---|---|
Account Identifier | The unique identifier of the account to retrieve data from. | XBA47549 |
Database | The database to retrieve data from. | SNOWFLAKE_SAMPLE_DATA |
Schema | The schema associated with the database. | TPCH_SF1 |
Username | The integration user’s username. | IntegrationUser |
Password | The integration user’s password. | Password1234 |
Warehouse | The warehouse to use. | SAMPLEWAREHOUSE |
Data files
The Snowflake data connector only retrieves data stored in Snowflake for use in Visier.
For other data, you must provide that data through alternative methods such as SFTP or Visier’s other data connectors.
How the connector loads data
Initially, data connectors retrieve a full history for each subject to generate an initial history of events. In each subsequent data retrieval, each connector handles the data load differently.
Full load: All data from the source system is loaded into Visier.
Delta load: Only changed data is loaded into Visier. A delta load may take either the entire history or a specific number of years of history for each changed record.
Snapshot load: All data at a particular point in time. A snapshot load does not contain historical records or show changes over time.
Partial load: A subset of data is loaded into Visier.
After the initial load, this connector only retrieves data for changed records.