Version: 2.0.0

MSSQLDest

class

class MSSQLDest(
    tables: MSSQLTableNamesSpec,
    if_table_exists: IfTableExistsSpec = 'append',
    transactional: bool = True,
    dest_cfg: DestCfgSpec | None = None,
)

Bases: Dest

Categories: destination

MSSQL destination for @subscriber -- one output slot per table.

Parameters

parameter

tablesMSSQLTableNamesSpec (list[str])

Target table names, one write slot per entry. Each is a 1-, 2- or 3-part name (table, schema.table or database.schema.table); bracket-quote a part ([name]) to allow special characters.

parameter

if_table_existsIfTableExistsSpec (Literal['append', 'replace'])

"append" (the default) adds rows; "replace" truncates the table before inserting.

parameter

transactionalbool

When True (the default), wrap every table write in one transactional session.

parameter

dest_cfgDestCfgSpec | None (Mapping[Literal['mssql.logging_level', 'tabsdata.sql.write_engine', 'tabsdata.sql.chunk_size'], Any] | None)

Optional connector config; supported keys are mssql.logging_level, tabsdata.sql.write_engine and tabsdata.sql.chunk_size.

#

Parameters​

#

#

#

#

Parameters