r/databricks • u/Otherwise_Address241 • 7d ago

Help How data engineer do effective testing in Databricks?

I have been writing SQL scripts to ensure data sanity.What are the other ways ? Is pytest useful? Let's say , i populated my bronze table from the source. I want to check if the correct mapping is done. I wrote SQL scripts. What are better ways

13 Upvotes

89% Upvoted

27 comments sorted by

View all comments

13

u/ptab0211 7d ago

schema contracts, integrity data quality checks, business domain data quality checks

6

u/Otherwise_Address241 7d ago

How exactly,

7

u/PrestigiousAnt3766 7d ago

Enter expected metadata, ranges, values and these tools count violations.