Hello, do you know how to use variables in dataform? For example if I have a query where I select records between specific timestamp/date, the date is variable? Or for example if I have a table with responses status codes, I can use a variable for the query to be able to get records with status code = variable so it can be 200, 404, etc.
I believe this is possible by defining your variable in your config.js, and then you can use the dataform cli run/compile with your vars. i.e dataform compile --vars=my_status_code=200
@@danoyoung Nice, yes it also works by using the "compilation overrides" dataform interface when creating scheduled compilations, please share the link to the post would like to see this way too
Thanks once again for trying your best to showing every other things about Database form and etc.
I appreciate your lesson with understanding about Dataform based SQL Workflows
where can i find the code for this
This is pretty rad! Is there a dependency UI or do you know if Google is planning on adding something like that?
Yes, if you click on the Compiled Graph link you'll get the entire dependency chain
Hello, do you know how to use variables in dataform? For example if I have a query where I select records between specific timestamp/date, the date is variable? Or for example if I have a table with responses status codes, I can use a variable for the query to be able to get records with status code = variable so it can be 200, 404, etc.
I believe this is possible by defining your variable in your config.js, and then you can use the dataform cli run/compile with your vars. i.e dataform compile --vars=my_status_code=200
This works, I just created a quick demo, I'll go ahead and get it posted ....
@@danoyoung Nice, yes it also works by using the "compilation overrides" dataform interface when creating scheduled compilations, please share the link to the post would like to see this way too
@@Satenc0 yes, this is what I've covered in new video that's being uploaded, check back!