Click HERE to see how Saviynt Intelligence is transforming the industry. |
12/05/2023 01:46 AM
I need to do integrate the Snowflake with Saviynt and have never worked on DB connector.
What are the exact values that should be provided in the "username" and "password" parameters of a DB Connector using for the Snowflake connection.
Instead of DB Connector fresh desk link is there any forum link for the Snowflake integration.
12/07/2023 02:13 AM
Hi @Saviynt_Savvy,
We are checking on this and we will keep you posted.
12/18/2023 12:44 PM
@Saviynt_Savvy @DixshantValecha
I am in the same boat in that I need to setup a JDBC connection - but I found the integration guide lacking. Specifically, the piece about the JDBC driver. After I upload a JAR file to WIN (I'm assuming I need to though the documentation didn't talk about it) - what URL do I reference in the parameter to have it use that driver?
12/18/2023 01:33 PM - edited 12/18/2023 01:38 PM
@KevinP : JDBC Driver name for snowflake DB is: com.snowflake.client.jdbc.SnowflakeDriver. Also you need to upload the respective JDBC jar to Saviynt(File Directory -> External JARs) and restart the application. Also for url you have to use the format as : jdbc:snowflake://<domain.zone>.snowflakecomputing.com/
12/18/2023 02:03 PM
@Saathvik Thanks! I wasn't sure if I had to reference some Saviynt URL since I uploaded the driver there or not. Also I was an idiot and accidentally forgot about the jdbc:snowflake:// piece for the URL. At least now I'm getting an access denied error from Snowflake (due to IP restrictions, which is being fixed) as opposed to a failure to connect!
12/18/2023 01:42 PM
@Saviynt_Savvy : For username/password you may need work with snowflake admin to have one created which has read/write permissions to below schemas(you may or may not have all below listed schemas available). But in short you should be able to read all users and their memberships and all able to do provision and deprovision
01/17/2024 08:45 PM
URL | jdbc:snowflake://your_account_name.snowflakecomputing.com/?db=your_database&warehouse=your_warehouse&schema=your_schema&role=your_role&ssl=true | change hostname |
USERNAME | admin | Check with snowflake Admin |
PASSWORD | ***** | Check with snowflake Admin |
DRIVERNAME | com.snowflake.client.jdbc.SnowflakeDriver |
Driver download link
https://docs.snowflake.com/en/developer-guide/jdbc/jdbc
01/17/2024 09:53 PM
@Saviynt_Savvy try this details :
URL : jdbc:snowflake://<snowflake domain>.snowflakecomputing.com/
DRIVERNAME : com.snowflake.client.jdbc.SnowflakeDriver
Make sure to restart the server or reach out to saviynt ops to do full stack restart once the jar is loaded.