AntoineGiraud
commented
1 month ago from GCP's dataform issue #366123439
How this might work:
- dataform's GCP UI : toggle option to choose for "prod" database for deferal in dev environements
- dataforms's CLI :
dataform run --actions ventes+ achats+ --defer prod_profile
If applicable, reasons why alternative solutions are not sufficient:
Without defer to prod here are the options :
- rebuild ALL parent tables -> storage & compute costs $$
- clone all parents schemas & tables as views -> ~5min init for 360 tables in 3 schemas
create view xxx-dev.xxx.xxx as select * from xxx.xxx.xxx
Hi,
Could dataform add a defer to prod option ? i'd help to init our dev env' without having to clone/recreate all our parents tables when editing 1 child table !
resolving in compute, storage & time savings while developping
I'd help us a lot @Homeserve 👷♂️
DBT equivalent 🙏