⚠️ DEPRECATED: Typed connector configuration models are deprecated and will be removed in v1.1.0. Pass configuration as a plain dict with a required 'destinationType' key instead..
| Field | Type | Required | Description | Example |
|---|---|---|---|---|
database |
str | ✔️ | The name of the MSSQL database. | |
destination_type |
models.DestinationMssqlMssql | ✔️ | N/A | |
host |
str | ✔️ | The host name of the MSSQL database. | |
jdbc_url_params |
Optional[str] | ➖ | Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3). | |
load_type |
models.DestinationMssqlLoadTypeUnion | ✔️ | Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration. | |
password |
Optional[str] | ➖ | The password associated with this username. | |
port |
int | ✔️ | The port of the MSSQL database. | 1433 |
schema_ |
Optional[str] | ➖ | The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". | public |
ssl_method |
models.DestinationMssqlSSLMethod | ✔️ | The encryption method which is used to communicate with the database. | |
tunnel_method |
Optional[models.DestinationMssqlSSHTunnelMethod] | ➖ | Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use. | |
user |
str | ✔️ | The username which is used to access the database. |