IBM db2 Db Store

Description	Connection to a IBM db2 database
Type	ibmdb2
Category	Db

Configuration in States

The Snowflake Db Store can be configured directly in the States interface via the Data Stores module. The following configuration modes are available:

Parameters

Name	Description	Mandatory	Default	Comment
Account	The Snowflake account identifier	Yes	—	e.g. `xy12345.eu-west-1`
Database	The name of the target database	Yes	—
Schema	The schema to use	Yes	—
Username	The username used to authenticate	Yes	—
Password	The password used to authenticate	Yes	—	Value is hidden
Warehouse	The virtual warehouse to use	No	—
Role	The role to use for the session	No	—
Suffix	Additional parameters appended to the connection string	No	—

⚠️ Important: Make sure identifiers (like db) that contain lowercase characters are double-quoted in any manually entered value. Otherwise, Snowflake assumes they are uppercase, which may result in a "database does not exist or is not authorized" error.

Connection String

A connection string can be entered manually instead of using the parameter form. For the full list of supported connection string parameters, refer to the Snowflake .NET connector documentation.

Local Configuration

The local configuration is defined in a JSON file (stores.json) deployed directly on the Workers' server. A locally configured store takes priority over a store with the same name configured in the States interface.

Name	Description	Type	Mandatory	Comment
ConnectionString	The connection string to connect to the database	string	True

JSON

{
    "Name": "database",
    "Type": "ibmdb2",
    "HealthCheck": true,
    "Config": {
        "ConnectionString": "[Host]:[Port];Database=[Database name];UId=[Username];PWD=[Password]"
    }
}