Credentials for external services

The Data Warehouse application is built using Snowflake, a cloud data warehouse provider.

Depending on your choice of BI application, you will need to select ‘Snowflake' as database selection before adding any credentials provided by the Data Warehouse app.

For more information on setting up on other BI applications, please take a look at the following video:

For the majority of every major BI application, you will need the following information which can be retrieved from your Data Share:

URL

The direct URL to the data source server location

DSN

The name of the data source (this will usually be an ODBC connection string that you will use in your chosen BI product)

Schema

The name of the specific schema as it is stored in the warehouse

Warehouse

The name of the warehouse which has been provisioned (required for external use)

Region

The region in which the schema is stored

Your Snowflake Account name

The account id AND region from the Snowflake URL available on the 'Data' panel of the Data Warehouse app For example, if the URL is AB12345.eu-west-2.aws.snowflakecomputing.com

Your account name will be AB12345.eu-west-2.aws

User Credentials

The details of the user you have already created on the Users panel of the Data Warehouse app