Create a Connection to a Snowflake Database

Connect to a Snowflake database so that you can model data.

Before you start, see Configure Your Environment for Modeling Snowflake Data.

1. In Model Administration Tool, enable the JDBC connection pool functionality by loading Java data sources.
   1. From the File menu, click Open, then In the Cloud, and use the Open in the Cloud dialog to specify the details of your Cloud data model.
   2. From the File menu, click Load Java Data Sources.
   3. At the Connect to Java Datasource Server dialog:
      • In the Hostname field, enter the machine name that you noted in Step 1. Fully qualify the hostname. For example, if you noted machine in Step 1, you might specify machine.us.example.com.
      • In the Port field, enter the port that you noted in Step 1. For example, 51811.
      • In the Username and Password fields, enter dummy or any string (these credentials aren't validated because this is a public call to discover the capabilities advertised by the Data Gateway).
2. In Model Administration Tool, create a new database and set the type to Snowflake.
3. Add a Connection Pools and specify these details on the General tab:
   • Call Interface: JDBC(Direct Driver).
   • Require fully qualified table names: Yes.
   • Data source name: Enter the connection string, for example: jdbc:snowflake://xxxx.snowflakecomputing.com?db=xxxx&warehouse=xxxxxx&schema=xxxxxx
   • RDC Version: Leave this field blank.
4. On the Miscellaneous tab, specify these details:
   • JDS Server URL: Leave this field blank (remove any entry in this field).
   • Driver Class: net.snowflake.client.jdbc.SnowflakeDriver.
   • Use SQL over HTTP: false.
5. Model your data using this connection.
6. When you have completed your model, upload or save your semantic model back to Oracle Analytics.