tabsdatak.conn.oracle
CredentialsSpec | The credential type for Oracle connections: UserPassword (user + password), spliced into the URI by the engine factory. |
DestCfgKey | |
DestCfgSpec | |
IfTableExistsSpec | Write disposition when the target table exists: "append" adds rows; "replace" truncates before insert. |
OracleDest | Oracle destination for @subscriber -- one target table per slot. |
OracleDestConn | Oracle connection used by OracleDest. |
OracleSrc | Oracle source for @publisher -- one output slot per query. |
OracleSrcConn | Oracle connection used by OracleSrc. |
OracleTableNameSpec | An Oracle table name, either table or schema.table (at most two dot-separated parts). |
OracleTableNamesSpec | A list of Oracle table names (see OracleTableNameSpec). |
QueriesSpec | A non-empty, ordered list of SELECT statements -- one output slot per query. |
SrcCfgKey | |
SrcCfgSpec | |
UriSpec | A SQLAlchemy-style Oracle URI, e.g. |
CredentialsSpec
type_aliasCredentialsSpec: UserPassword
The credential type for Oracle connections: UserPassword (user +
password), spliced into the URI by the engine factory.
DestCfgKey
type_aliasDestCfgKey: Literal['oracle.logging_level', 'tabsdata.sql.write_engine', 'tabsdata.sql.chunk_size']
DestCfgSpec
type_aliasDestCfgSpec: Mapping[DestCfgKey, Any]
Resolved type:
Mapping[Literal['oracle.logging_level', 'tabsdata.sql.write_engine', 'tabsdata.sql.chunk_size'], Any]
IfTableExistsSpec
type_aliasIfTableExistsSpec: Literal['append', 'replace']
Write disposition when the target table exists: "append" adds
rows; "replace" truncates before insert.
OracleTableNameSpec
type_aliasOracleTableNameSpec: str
An Oracle table name, either table or schema.table (at most
two dot-separated parts). Parts may be double-quoted; Oracle has no way
to embed a literal double-quote inside a quoted identifier.
OracleTableNamesSpec
type_aliasOracleTableNamesSpec: list[OracleTableNameSpec]
Resolved type:
list[str]
A list of Oracle table names (see OracleTableNameSpec).
QueriesSpec
type_aliasQueriesSpec: list[str]
A non-empty, ordered list of SELECT statements -- one output slot per query.
SrcCfgKey
type_aliasSrcCfgKey: Literal['oracle.logging_level', 'tabsdata.sql.read_engine', 'tabsdata.sql.chunk_size', 'tabsdata.src_metadata.drop']
SrcCfgSpec
type_aliasSrcCfgSpec: Mapping[SrcCfgKey, Any]
Resolved type:
Mapping[Literal['oracle.logging_level', 'tabsdata.sql.read_engine', 'tabsdata.sql.chunk_size', 'tabsdata.src_metadata.drop'], Any]
UriSpec
type_aliasUriSpec: StrOrSecretSpec
Resolved type:
str | Secret
A SQLAlchemy-style Oracle URI, e.g.
oracle+oracledb://host:port/service. The scheme must be oracle
(an optional +driver is allowed). Accepts a plain string or a
Secret.