HomeDemoContact

Snowflake

Suggest Edits

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

FieldRequiredDescription
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

FieldRequiredDescription
Name✅Identifier for the connector. Used when setting up validators
RoleRole of the Snowflake user account used to ingest data from.
WarehouseName 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 presetDetermines 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