database_profiler

sqllocks_spindle.inference.database_profiler

Database profiler -- read schema metadata from SQL Server catalog views.

Connects to SQL Server, Azure SQL, Fabric Warehouse, or Fabric SQL Database and reads exact PKs, FKs, column metadata from sys catalog views. Then samples data for distribution profiling.

Requires the fabric-sql extra::

pip install sqllocks-spindle[fabric-sql]

Classes

DatabaseProfiler

Profile a SQL database by reading catalog metadata + sampling data.

Methods:

profile(schema='dbo', sample_rows=1000, tables=None)

Profile a database schema with exact PKs, FKs, types, and sampled distributions.