Skip to main content
GuideServerConfigure and deploy Tabsdata servers on your machine.TutorialsConfigure data integration workflows within a running Tabsdata server.API ReferenceCLI ReferenceRelease Notes
Version: 2.3.0

tabsdatak.conn.mssql

CredentialsSpecThe credential type for MSSQL connections: UserPassword (user + password).
DestCfgKey
DestCfgSpec
IfTableExistsSpec
MSSQLDestMSSQL destination for @subscriber -- one output slot per table.
MSSQLDestConnMSSQL connection used by MSSQLDest.
MSSQLSrcMSSQL source for @publisher -- one output slot per query.
MSSQLSrcConnMSSQL connection used by MSSQLSrc.
MSSQLTableNameSpec
MSSQLTableNamesSpecA list of MSSQL table names (see MSSQLTableNameSpec), each at most once: names that differ only in quoting or in case are the same table, as SQL Server's default collation ignores the case of a name, quoted or not.
QueriesSpec
SchemaEvolutionSpec
SrcCfgKey
SrcCfgSpec
UriSpec

CredentialsSpec

type_alias
CredentialsSpec: UserPassword

The credential type for MSSQL connections: UserPassword (user + password).


DestCfgKey

type_alias
DestCfgKey: Literal['mssql.logging_level', 'mssql.schema_evolution_engine', 'tabsdata.sql.write_engine', 'tabsdata.sql.chunk_size']

DestCfgSpec

type_alias
DestCfgSpec: Mapping[DestCfgKey, Any]

Resolved type:

Mapping[Literal['mssql.logging_level', 'mssql.schema_evolution_engine', 'tabsdata.sql.write_engine', 'tabsdata.sql.chunk_size'], Any]

IfTableExistsSpec

type_alias
IfTableExistsSpec: Literal['append', 'replace']

MSSQLTableNameSpec

type_alias
MSSQLTableNameSpec: str

MSSQLTableNamesSpec

type_alias
MSSQLTableNamesSpec: list[MSSQLTableNameSpec]

Resolved type:

list[str]

A list of MSSQL table names (see MSSQLTableNameSpec), each at most once: names that differ only in quoting or in case are the same table, as SQL Server's default collation ignores the case of a name, quoted or not.


QueriesSpec

type_alias
QueriesSpec: list[str]

SchemaEvolutionSpec

type_alias
SchemaEvolutionSpec: Literal['strict', 'update']

SrcCfgKey

type_alias
SrcCfgKey: Literal['mssql.logging_level', 'tabsdata.sql.read_engine', 'tabsdata.sql.chunk_size', 'tabsdata.src_metadata.drop']

SrcCfgSpec

type_alias
SrcCfgSpec: Mapping[SrcCfgKey, Any]

Resolved type:

Mapping[Literal['mssql.logging_level', 'tabsdata.sql.read_engine', 'tabsdata.sql.chunk_size', 'tabsdata.src_metadata.drop'], Any]

UriSpec

type_alias
UriSpec: StrOrSecretSpec

Resolved type:

str | Secret