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
|Account||This can be found in the URL that you use to login to Snowflake. For example |
|User||User name used to login to Snowflake|
|Role||Role with the right privileges dedicated to Datacoral. The |
|Password||Password for |
|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.
|COMMENT||DATACORAL_OWNED||null||user comment associated to an object in the dictionary|
|DISPLAY_NAME||null||Display name of the associated object|
|LOGIN_NAME||null||Login name of the user|
|DEFAULT_WAREHOUSE||null||Default warehouse for this user|
|DEFAULT_NAMESPACE||null||Default database namespace prefix for this user|
|DEFAULT_ROLE||null||Primary principal of user session will be set to this role|
Step 3: Add Elastic IP to your network policy
Navigate to Account > Policies and create a new network policy
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.