Snowflake

Prerequisite credentials

You need the following to configure Redshift 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 Destination config

We recommended that you create a user account with write access to the table you want to egress data into.

Set up a write-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 write_only comment = 'This role has write only access';

# Granting write-only access to the role on selected warehouse, schemas and tables
GRANT USAGE ON DATABASE VALIDIO_DB TO ROLE write_only;
GRANT USAGE ON SCHEMA VALIDIO_DB.DEMO_DATA TO ROLE write_only;
GRANT SELECT ON ALL TABLES IN SCHEMA VALIDIO_DB.DEMO_DATA TO ROLE write_only;
GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE write_onlyy;
GRANT SELECT ON FUTURE TABLES IN SCHEMA VALIDIO_DB.DEMO_DATA TO ROLE write_only;

# Set the users role
GRANT ROLE write_only TO USER user1;
ALTER USER user1 SET default_role = write_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

FieldRequiredDescriptionExample
Nameβœ…Identifier for the destination in Validio.
Roleβœ…Role of the user account with access to the destination where data is egressed to.
Warehouseβœ…Name of the Snowflake warehouse to egress data to.
Databaseβœ…Name of the Snowflake database to egress data to.
Schemaβœ…Schema that the Snowflake table resides in.
Tableβœ…Name of the table created when initializing the destination connector.