Configure Snowflake for Datacoral
As part of setting up the Datacoral platform with Snowflake, you will be asked to provide the following fields.
Step 1: Run the commands in Snowflake
Run the following commands to setup the Datacoral user in Snowflake and provide the right permissions.
Here is the explanation of the user defined fields
Field Name | Description |
---|---|
Account | This can be found in the URL that you use to login to Snowflake. For example wm00000 from https://wm00000.snowflakecomputing.com/console#/internal/worksheet . The account name sometimes contains a region or cloud provider name as well. |
User | User name used to login to Snowflake |
Role | Role with the right privileges dedicated to Datacoral. The User should have this role |
Password | Password for User |
Database | Name of the Snowflake database to get data populated by Datacoral |
Warehouse | Name of the Snowflake warehouse to isolate Datacoral workloads |
Step 2: Verify that the above commands
The output of the above statement should contain the following based on the names you chose.
property | value | default | description |
---|---|---|---|
NAME | <USER_NAME> | ||
COMMENT | DATACORAL_OWNED | null | user comment associated to an object in the dictionary |
DISPLAY_NAME | <USER_NAME> | null | Display name of the associated object |
LOGIN_NAME | <USER_NAME> | null | Login name of the user |
... | ... | ... | ... |
DEFAULT_WAREHOUSE | <WAREHOUSE_NAME> | null | Default warehouse for this user |
DEFAULT_NAMESPACE | <DATABASE_NAME> | null | Default database namespace prefix for this user |
DEFAULT_ROLE | <ROLE_NAME> | null | Primary principal of user session will be set to this role |
... | ... | ... | ... |
Step 3: Add Elastic IP to your network policy
Look for the elastic ip of your Datacoral installation in the installation settings. Add it to the
network policy by running the following statements. Note that you will need to add /32
to the
end of the elastic ip value to indicate that you are allowing traffic from a single IP address.
Step 4: Follow along the Datacoral onboarding flow
Once the above steps are done, you can provide the credentials to your snowflake cluster in the onboarding flow.