Re:Ask HN: How do you test SQL?
by mritchie712 on Wednesday February 01, 2023 @05:50AM
(#34608882)
Doesn't that mean you have to copy all your data into duckdb? I'd imagine with even a modest data warehouse, loading the entire thing to duckdb would be unfeasible.
[ Parent
| on HN ]
The tests are being run against small test datasets of 10s of rows rather than the real data that test whether the behaviour of transforms/joins etc. is as expected. You're right, this approach wouldn't be sensible if the tests have to use large production tables
Re:Ask HN: How do you test SQL?
by mritchie712 on Wednesday February 01, 2023 @06:51AM
(#34609293)
How do you get the small datasets? Selecting a random sample from the source?