SQL Server Collected Data

This page describes what Sifflet imports from your SQL Server database once the SQL Server source is connected.

Imported Assets

Sifflet imports the following objects from the schemas selected in the source scope:

• Tables
• Views

Collected Metadata

For each table and view, Sifflet collects:

• Name and schema
• Columns: name, data type, nullability, default value, and size

Lineage

Sifflet doesn't extract lineage between tables inside SQL Server (from query logs or view definitions).

SQL Server tables appear in lineage when other integrations reference them, for example BI tools, dbt, or data pipelines. Sifflet links these assets when the host, port, database, and schema configured in the other tool match the SQL Server source.

Data Freshness

Sifflet refreshes the SQL Server metadata on the source schedule. See Integrations Management for the default frequency and scheduling options.

Limitations

• Table and column descriptions (extended properties) are not imported.
• The Freshness (Update Time Gap) monitor, which relies on update times from table metadata, is not available for SQL Server.

Data Exposure

Sifflet stores metadata and monitor results. Some features read and display row-level data from your tables: data preview and the failing rows of monitors. See Security for details on the data that Sifflet accesses and stores.