Snowflake
Prerequisite credentials
You need the following to configure Snowflake credentials in the Validio platform:
- A user account with permissions to access the specified dataset and table
Permissions for user accounts
Certain permissions are required for the user account.
User account for Source config
We recommend that you create a user with read access to the table you want to ingest data from.
Set up a read-only user
The following are example commands to create a user with read-only access:
# Creating user
CREATE USER user1;
# Creating a role
CREATE ROLE read_only comment = 'This role has read only access';
# Granting read-only access to the role on selected warehouse, schemas and tables
GRANT USAGE ON DATABASE VALIDIO_DB TO ROLE read_only;
GRANT USAGE ON SCHEMA VALIDIO_DB.DEMO_DATA TO ROLE read_only;
GRANT SELECT ON ALL TABLES IN SCHEMA VALIDIO_DB.DEMO_DATA TO ROLE read_only;
GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE read_only;
GRANT SELECT ON FUTURE TABLES IN SCHEMA VALIDIO_DB.DEMO_DATA TO ROLE read_only;
# Set the users role
GRANT ROLE read_only TO USER user1;
ALTER USER user1 SET default_role = read_only;
# Set a password for the user
ALTER USER user1 set password = 'Validio2022';
Credential parameters
Field | Required | Description |
---|---|---|
Name | β | Identifier for the credentials. Used when accessing sources. |
Account | β | Snowflake account identifier. |
User | β | Username of Snowflake account with read access to the desired table. |
Password | β | Password of the specified Snowflake user. |
Configuration parameters
Field | Required | Description |
---|---|---|
Name | β | Identifier for the connector. Used when setting up validators |
Role | Role of the Snowflake user account used to ingest data from. | |
Warehouse | Name of the Snowflake warehouse to ingest data from. | |
Database | β | Name of the database to ingest data from. |
Schema | β | Name of the schema that contains the table to read from. |
Table | β | Name of the table to ingest data from. |
Cron preset | Determines how often to query the table for new data based on a preset option. Select custom to use your own cron expression. | |
Cron expression | β | Determines how often to query the table for new data based on cron expression. Expression of cron presets are displayed here. Used to enter your own cron expression. |
Updated 4 days ago