HomeDemoContact

Snowflake

Suggest Edits

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.

Updated 4 days ago