Connecting to a Snowflake database

Last modified by Aurelie Bertrand on 2026/06/30 14:17

To connect to a Snowflake database :

In the Create a new data model box, click the Snowflake button in the Database section.

➡ The Snowflake Database dialog box appears.
Select the desired connection mode and fill in the required fields:

Manual connection mode
The connection will be visible in the data source only.
1. Fill in the following fields:
  - Organisation: The name of the Snowflake organisation.
  - Account: The unique name of the account within your Snowflake organisation.
  - Port: The database port.
  - User: The user to authenticate with.
  - Password: The user's password.
2. Click on the Options button to configure authentication and/or connection parameters.
  It is possible to configure :
  - OAuth authentication with a service account: see the Snowflake documentation. Using the OAuth 2.0 Client Login Credentials Flow documentation client for more details.
  - Key-pair authentication: see the Snowflake documentation Using key-pair authentication and key rotation for more details.
3. Click on the Connection button to obtain the connection status (connection successful or connection failed). If the connection fails, change the connection settings.

Here are some useful/necessary connection options to specify:

Named connection mode
The connection will be visible in the connection manager and can be used by all data sources.
1. Click Select: the Database Connection Manager is displayed.
2. You can :
  - Select an existing connection from the list. Click OK.
  - Create a new connection as described on the Adding a named connection.

When the connection is successful, a Context Selection dialog box is displayed:

Select the catalogues you wish to import and click OK.
In the Query tab, create a query using theWizard:
- Tick the table to be used in the left-hand panel.
  ➡ The corresponding columns are displayed in the right-hand panel.
- You can remove columns by unchecking the corresponding boxes. The button selects all.
- You can define rules on columns: select the column then click the button at the top right of the columns and define the rule. The rule is added to the table below the columns.
Click on Options if you wish to modify the advanced properties of the database. See the options paragraph below.
In the Results tab , preview the results of the defined query. See the Preview page for more details.
You can also add data transformations. See the Transform data page for more details.
Once you are happy with the result, click Next to configure the data model.

Options

Query timeout	Maximum query duration in seconds (default is 60 seconds). If set to 0, there is no maximum limit.
Row fetch size	Number of rows to be fetched from the database. If set to 0, the number takes the JDBC driver "fetchsize" value.
Number of retries on error	Number of times the query is repeated in the event of an error. If other than 0, the time between retries must be specified, in seconds.
Persist error on schedule	Used to generate a cube containing the error. The whole process will fail later, but this avoids having to redo the job (and being in error again) for all the tasks.
Incremental data mode	Incremental data mode is used to feed the cube incrementally: each time the cube is refreshed, only the new data is brought back compared with the previous refresh. It is based on a reference column and the use of a keyword in the query: ${LASTVAL}. For example: select ... where ref_col> '${LASTVAL} The reference column is entered in the Reference column field below.

You can edit the query manually by selecting Advanced....
The query generated by the wizard is displayed.

⚠ If you switch back to the wizard, the query will be overwritten.

You can save the query you have entered for later use. To do this:

Click on the Favourites button .
Select Add to favourites then enter the name you want to give to this query.
➡ The query will be available from the same Favourites menu.

It is also possible to access the modification history via the History button.
Historique