Admin action required in Snowflake
Must create or use service account with SECURITYADMIN permission
Retrieved from Snowflake
Snowflake Driver
*Provided
– Ex. com.snowflake.client.jdbc.SnowflakeDriver
Snowflake Username
*Gathered
– Ex. ‘Descriptive Service Account Name’
Snowflake Password
*Gathered
Ex. ************
Snowflake URL
*gathered
– Ex. jdbc:snowflake://xy12345.us-south-5.snowflakecomputing.com:443/
– ‘xy12345’ is unique to client
‘.us-south-5 is unique to client
Copy example URL, sub unique variables
Snowflake Role
– Must be either SECURITYADMIN OR ACCOUNTADMIN
NOTE
If a user does not have an email id in the Snowflake DB, the users are not created in SecurEnds.