dlt.destinations.impl.mssql.configuration
escape_mssql_odbc_value
def escape_mssql_odbc_value(value: Optional[str]) -> str
Escape a value for MSSQL ADO/ODBC connection string format.
ODBC format supports {value} syntax where:
}inside braces must be doubled to}};can safely appear inside braces
To safely handle values with special characters, we use ODBC-style bracing:
- Values containing
;or}are wrapped in{} }inside the value is escaped as}}
Arguments:
value- The value to escape
Returns:
Escaped value safe for use in ADO/ODBC connection string
build_odbc_dsn
def build_odbc_dsn(params: Dict[str, Any]) -> str
Build an ADO/ODBC connection string for MSSQL, escaping values
Arguments:
params- Dictionary of connection parameters
Returns:
ADO/ODBC connection string
MsSqlCredentials Objects
@configspec(init=False)
class MsSqlCredentials(ConnectionStringCredentials)
drivername
type: ignore
MsSqlClientConfiguration Objects
@configspec
class MsSqlClientConfiguration(DestinationClientDwhWithStagingConfiguration)
destination_type
type: ignore
fingerprint
def fingerprint() -> str
Returns a fingerprint of host part of a connection string