5 ms·
The whole idea is pretty nuts! I can imagine it being used as the dev env for teams that use SQLMesh and can thus port the sql. Might be worth investigating wit
by adrianbr 2y ago
The whole idea is pretty nuts! I can imagine it being used as the dev env for teams that use SQLMesh and can thus port the sql. Might be worth investigating with them
- ryanwaldorf 2y agoThat's really interesting! Could you tell me a bit more of what you're thinking? I'm not the most familiar with SQL Mesh and the typical workflows there.
- chrisjc 2y agoPerhaps similar to https://github.com/duckdb/dbt-duckdb https://github.com/duckdb/dbt-duckdb , but SQLMesh instead of DBT obviously.
- ryanwaldorf 2y agoAh gotcha! Do you have a use case where you'd look to remodel/transform the data between warehouses?
- chrisjc 2y agoNot the original parent, so unsure of their use-case. But I've seen the approach where some/basic development can be done on duckdb, before making its way to dev/qa/prd. Something like your project might enable grabbing data (subsets of data) from a dev enviroment (seed) for offline, cheap (no SF warehouse cost) development/unit-testing, etc.
- ryanwaldorf 2y agoThis makes sense, thank you!