Hey all! I'm fairly new to dagster.
And I'm currently working to schedule extractions of aggregated data out of my snowflake warehouse into timescale db, the aggregates are windowed per hour basis. My questions are as follows:
1. Is there a recommended approach to dynamically load a collection of SQL scripts with formatting placeholder for timestamp range as queried aggregation into op as a dataframe for further processing?
2. OR is there a way to run dbt models with dynamic time range based on the time it is run on dagster?
Any advice is greatly appreciated!!