Snowflake
2 article
Set Up Snowflake
Last Updated: October 19, 2021Snowflake app setup within SecurEnds Navigate to Application under users and click Add Select Connector Radio Button and search for ‘Snowflake’. Select Application Snowflake Driver– Ex. com.snowflake.client.jdbc.SnowflakeDriver Snowflake Username– Ex. ‘Descriptive Service Account Name’ Snowflake Password Snowflake URL– Ex. jdbc:snowflake://hm19016.us-south-5.snowflakecomputing.com:443/ Snowflake Role– Ex. SECURITYADMIN
Configuration Details
Last Updated: October 20, 2021Admin 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*GatheredEx. ************ Snowflake URL*gathered– Ex. jdbc:snowflake://xy12345.us-south-5.snowflakecomputing.com:443/– ‘xy12345’ is unique to client‘.us-south-5 is unique to clientCopy 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.
