Module desc

Metadata about tables, columns, and other objects from SQL Server.

Tables

When creating a SQL Server source we will query system tables from the upstream instance to get a SqlServerTableRaw. From this raw information we create a SqlServerTableDesc which describes how the upstream table will get represented in Materialize.

Rows

With a SqlServerTableDesc and an mz_repr::RelationDesc we can create a SqlServerRowDecoder which will be used when running a source to efficiently decode tiberius::Rows into mz_repr::Rows.

Modules

proto_sql_server_column_desc

Nested message and enum types in ProtoSqlServerColumnDesc.

proto_sql_server_table_constraint

Nested message and enum types in ProtoSqlServerTableConstraint.

Structs

ProtoSqlServerColumnDesc

ProtoSqlServerTableConstraint

ProtoSqlServerTableDesc

SqlServerCaptureInstanceRaw

Raw capture instance metadata.

SqlServerColumnDesc

Description of a column from a table in Microsoft SQL Server.

SqlServerColumnRaw

Raw metadata for a column from a table in Microsoft SQL Server.

SqlServerQualifiedTableName

Partially qualified name of a table from Microsoft SQL Server.

SqlServerRowDecoder

A decoder from tiberius::Row to mz_repr::Row.

SqlServerTableConstraint

SQL Server table constraint.

SqlServerTableConstraintRaw

Raw metadata for a table constraint.

SqlServerTableDesc

Materialize compatible description of a table in Microsoft SQL Server.

SqlServerTableRaw

Raw metadata for a table from Microsoft SQL Server.

UnsupportedDataType

The raw datatype from SQL Server is not supported in Materialize.

Enums

SqlServerColumnDecodeType

Rust type that we should use when reading a column from SQL Server.

SqlServerTableConstraintType

SQL Server table constraint type (e.g. PRIMARY KEY, UNIQUE, etc.) See https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/table-constraints-transact-sql?view=sql-server-ver17

Functions

parse_data_type 🔒

Parse a raw data type from SQL Server into a Materialize SqlScalarType.

tiberius_numeric_to_mz_numeric 🔒

Numerics in SQL Server have a maximum precision of 38 digits, where Numerics in Materialize have a maximum precision of 39 digits, so this conversion is infallible.