INTERNAL USE ONLY
Question:
Can i harvest Snowflake metadata via JDBC Driver?
Answer: Yes. Please follow the below steps to capture Snowflake metadata.
Steps:
Configuring the Snowflake JDBC Driver in Tomcat Directory (One-time activity)
The latest Snowflake driver i.e., snowflake-jdbc-3.8.7.jar will be placed in below mentioned Tomcat directory path:
\Apache Software Foundation\Tomcat 8.5.35\webapps\erwinDISuite\WEB-INF\lib
How to establish Connectivity to Snowflake Database ?
Driver Name: com.snowflake.client.jdbc.SnowflakeDriver
DBMS Name/ DSN: <Enter the Snowflake Database Name>
IP Address: <Enter the Snowflake URL>
DBMS Name/ DSN: 443
Username: <Enter the Snowflake account username>
Password: <Enter the Snowflake account password>
**Password will be encrypted
Connection URL: Snowflake requires a connection string with the following syntax.
jdbc:snowflake://<account_name.eu-central-1>.snowflakecomputing.com/
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center