4 Comments
User's avatar
db100's avatar

Also, do you have any link to an official documentation page on python macros? I only happen to find one on python models but not just macros, any hints?

Thanks!

Yuki's avatar

Hey thanks for getting to my attention. I just added a link to the article but here it is: https://sqlmesh.readthedocs.io/en/stable/concepts/macros/sqlmesh_macros/. There is a section on Python macros in that page

db100's avatar

I am halfway through the post and I am wondering, what's the meaning of signing a Cron schedule to a view? I mean a view should by definition not be materialized and so it needs to be computed at every run of the pipeline ... So what's the meaning of Cron in such case?

Yuki's avatar

It just does the virtual update on the model I believe. Not really doing anything but making sure the virtual layer points to the correct physical layer. if that makes sense. If you don't specify the cron schedule for a view it'll be set as daily