Re:Launch HN: Datafold (YC S20) – Diff Tool for SQL Databases
by forrestb on Thursday August 06, 2020 @02:50PM
(#24074176)
> Well, if they don't and you're responsible you've really messed up, but that does happen (cough). Just do a similar diff via information_schema to show you schema discrepancies.
Analysts with 1-2 years experience in SQL are often writing ETL. Responsible Data Engineers can't be there every time they deploy to production.
> All this is annoying but of very little work compared to a whole ETL process, and - emphatically - is reusable on the next job.
Yes, you can write your own tools for SQL QA. Making a standard tool that the entire company can and does use is another story.
Analysts with 1-2 years experience in SQL are often writing ETL. Responsible Data Engineers can't be there every time they deploy to production.
> All this is annoying but of very little work compared to a whole ETL process, and - emphatically - is reusable on the next job.
Yes, you can write your own tools for SQL QA. Making a standard tool that the entire company can and does use is another story.