Connecting to Snowflake¶
To connect to Snowflake, select Snowflake from the Database dropdown on the connection tab.
Your connection details
You will need to provide several pieces of information. You may need to retrieve this information from your system administrator.
The host is the full name of your account (provided by Snowflake). You can find the account name in the Snowflake URL (ending with .snowflakecomputing.com). You can find more information about the format of your account host in the Snowflake JDBC configuration guide. Do not include jdbc:snowflake in the host string.
Enter the database to use. The specified database should be an existing database for which the specified user has privileges.
Specify the schema to use for the specified database once connected, or an empty string. The specified schema should be an existing schema for which the specified user has privileges.
Provide the name of the warehouse to use for Snowflake queries through this connection. The warehouse name can be found on the warehouses-page in the Snowflake interface. The warehouse name is typically an uppercase string such as COMPUTE_WH.
Enter the username associated with the user you would like to connect as. Do not use your own username or a privileged user. Instead, create a dedicated user with minimal permissions required for your reporting and data access needs. See Security Considerations for more information about how to safely connect to a remote database.
Provide the password associated with the specified username.
Testing your configuration¶
You can test your configuration by pressing the Test Configuration button. Rational BI will attempt to make a connection to the remote database and will indicate if the connection was successful. If an error was reported, check that the supplied information is correct and and that the supplied user has sufficient privileges to access Snowflake through JDBC.
Saving your configuration¶
When the configuration is correct, press Save. The system will connect to the remote database and create the metadata schema with table and column information based on the tables and views visible to the configured user.
The dataset will be updated to reflect that the remote database is online, and the database connection is now ready for use.