| Changes in this topic | Description |
|---|---|
| Introduced in version 24.1 | Snowflake Datasource |
This is an example of a named connection to a Snowflake table.
<?xml version="1.0" encoding="UTF-8"?>
<NamedConnection version="MXP_NamedResource_1_5" xmlns="http://www.mapinfo.com/mxp">
<DBConnection dbType="snowflake">
<ConnectionName>Connection_1</ConnectionName>
<JDBCDriverParameters>
<JDBCUrl>@jdbcurl@</JDBCUrl>
<DriverPropertySet>
<Property name="user" value="@user@"/>
<Property name="password" value="@password@"/>
</DriverPropertySet>
</JDBCDriverParameters>
</DBConnection>
</NamedConnection>Note: The @jdbcurl@ would be in form like the below example. You can check the exact
configuration in your snowflake account.
jdbc:snowflake://@host@:@port@/?warehouse=<warehouse-name>&db=<database-name>&schema=<schema-name>
&CLIENT_SESSION_KEEP_ALIVE=TRUE&CLIENT_SESSION_KEEP_ALIVE_HEARTBEAT_FREQUENCY=900
&CLIENT_PREFETCH_THREADS=10