| Changes in this topic | Description |
|---|---|
| Introduced in version 24.1 | Snowflake Datasource |
Example
This is an example of a named table definition for a Snowflake database table, using the Snowflake data provider.
In this example, the definition defines a connection to a Snowflake database table using the following tokens:
-
@jdbcurl@ the JDBC URL used to connect to the database, which is of the form
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 - @host@ the host name used to connect to the database
- @port@ the port number used to connect to the database
- @databasename@ the name for the instance
- @user@ the user name credentials to access the table
- @password@ the password credentials for accessing the database
- @table@ the name of the table in the database
- @schema@ the schema used by the database. For example: public
- @named_connection_path@ the name of the named connection with path in the repository
<?xml version="1.0" encoding="UTF-8"?>
<NamedDataSourceDefinition version="MXP_NamedResource_1_5" xmlns="http://www.mapinfo.com/mxp">
<ConnectionSet>
<NamedConnectionRef resourceID="@named_connection_path@">
<ConnectionName>Connection_1</ConnectionName>
</NamedConnectionRef>
</ConnectionSet>
<DataSourceDefinitionSet>
<DBDataSourceDefinition id="dbDataSourceDef1" volatile="true">
<DataSourceName>SnowflakeDataSource</DataSourceName>
<ConnectionMember>
<ConnectionName>Connection_1</ConnectionName>
</ConnectionMember>
<DBTable owner="@schema@" useQuotes="true">@table@</DBTable>
</DBDataSourceDefinition>
</DataSourceDefinitionSet>
<DataSourceRef ref="dbDataSourceDef1"/>
</NamedDataSourceDefinition>