%pip install semantic-link-labs
import sempy_labs as labs
table_name = 'MyTable' # Enter the name of the delta table
lakehouse = 'MyLakehouse' # Enter the name or ID of the lakehouse in which the delta table resides
workspace = 'MyWorkspace' # Enter the name or ID of the workspace in which the lakehouse resides
x = labs.delta_analyzer(
table_name=table_name,
lakehouse=lakehouse,
workspace=workspace
)
for name, df in x.items():
print(name)
display(df)
x = labs.delta_analyzer(
table_name=table_name,
approx_distinct_count=False,
lakehouse=lakehouse,
workspace=workspace
)
The export always appends results to the delta tables
x = labs.delta_analyzer(
table_name=table_name,
lakehouse=lakehouse,
workspace=workspace,
export=True
)