Requirements for a Successful Snowflake Configuration:
User Creation and Authentication: Create a user with password authentication and assign a role.
Virtual Warehouse Access: Grant usage permissions and set the default warehouse for the user.
Database and Schema Access: Grant usage permissions on the database and schema.
Namespace Configuration: Verify and set the default database and schema for the user.
Table Access: Grant select permissions on specific tables and future privileges on tables within the schema.
Role and Privileges Management: Create a role with necessary privileges, assign it to the user, and set the user's default role.
Network Configuration: Safelist Vitally's IP addresses in the network policy.
For US-hosted Vitally customers: 52.2.105.119, 34.198.95.164, 54.225.45.200, 3.233.54.92, 44.197.82.135, 44.205.137.47, 3.231.135.245, 34.234.2.125, 18.117.45.34, 18.118.174.158, 3.128.104.4, 3.128.39.40, 3.137.39.224, 3.20.73.62
For EU-hosted Vitally customers: 13.50.117.250, 13.48.176.93, 13.48.142.17, 13.53.227.107, 16.171.90.148, 16.170.120.57, 16.171.215.121, 16.171.156.82
Step 1 - Connect
We’ll need these values to connect to your Snowflake warehouse:
Account: The account identifier of your Snowflake account
Username: A unique user that you’ve created for Vitally
Password: That user’s password
Warehouse: The virtual warehouse to use
Database: The name of the database that you want to connect to (e.g. production)
Schema: The schema in the database to use
Step 2 - Configure Sync