Connection - Attributes (Parameters)
A connection attribute is a attribute of a connection.
Parameter
The connection attribute of type parameters:
- define how to connect to a system connection via its URI attribute
- and configure the behavior of this connection.
The only mandatory parameter variable is the URI.
Base parameters are parameters used for all connections. Each connection type has its own parameters variable.
Management
See
You can see the attributes of your connection with the connection info command.
Set
You can set connection parameters:
- by editing manually the configuration vault
connections:
connectionName:
parameter1: value1
- with the connection upsert command.
- with a OS environment variable
connections:
connectionName:
parameter1: ${MY_OS_ENV}
Base Parameters
Base Connection Attribute are connection attributes available to all connections.
| Name | Description |
|---|---|
| URI | The connection URI |
| COMMENT | A connection description |
| USER | The user |
| PASSWORD | The password |
| DATE_DATA_TYPE | Define the text storage format of a Date data type (YYYY-MM-DD) if not supported by the connection . See Time storage |
| TIMESTAMP_DATA_TYPE | Define the text storage format of a Timestamp data type (YYYY-MM-DD HH:MM:SS) if not supported by the connection . See Time storage |
| TIME_DATA_TYPE | Define the text storage format of a Time data type (HH:MM:SS) if not supported by the connection . See Time storage |
| BOOLEAN_DATA_TYPE | Define the text storage format of a Boolean. See boolean if not supported by the connection |
| VARCHAR_DEFAULT_PRECISION | Define the default precision of a Varchar |
| NVARCHAR_DEFAULT_PRECISION | Define the default precision of a NVarchar |
| CHAR_DEFAULT_PRECISION | Define the default precision of a char |
| NCHAR_DEFAULT_PRECISION | Define the default precision of a nchar |
| MAX_NAME_IN_PATH | The maximum name in a path (for instance, Sqlite supports only one) |
| MAX_CONCURRENT_THREAD | The maximum number of concurrent thread for the connection (for instance, Sqlite supports only one) |
| NATIVES | The native driver connection properties as map of key value (jdbc driver properties, …) |
Derived: You can't change it
| Name | Description |
|---|---|
| ORIGIN | The origin of the connection data (ie built-in or user) |