Frits
12/20/2022, 9:24 AMDhaval Thakkar
12/20/2022, 9:25 AMTom Taylor-Vigrass
12/20/2022, 9:30 AMFrits
12/20/2022, 9:35 AMTom Taylor-Vigrass
12/20/2022, 9:42 AM# in settings.py
from kedro.config import TemplatedConfigLoader
CONFIG_LOADER_CLASS = TemplatedConfigLoader
CONFIG_LOADER_ARGS = {
"globals_dict": {'filter_date': os.getenv('FILTER_DATE')},
}
then the query argument in the dataset could look like this
select * from table where dt>${filter_date}
Frits
12/20/2022, 9:54 AMTom Taylor-Vigrass
12/20/2022, 9:58 AM${variable}
patternFrits
12/20/2022, 10:00 AMIñigo Hidalgo
02/24/2023, 5:30 PMdatajoely
02/24/2023, 5:33 PMIñigo Hidalgo
02/24/2023, 5:39 PMusing sqlalchemy directly likely let us do this programatically.could you explain what you mean by this? I'm not familiar with the sql dataset implementation at all, haven't gotten round to looking at it just yet, so if I just need to go look at the code tell me that haha
datajoely
02/24/2023, 5:40 PMIñigo Hidalgo
02/24/2023, 5:42 PMdatajoely
02/24/2023, 5:58 PMIñigo Hidalgo
02/24/2023, 6:01 PMdatajoely
02/24/2023, 6:07 PMIñigo Hidalgo
02/24/2023, 6:07 PMdatajoely
02/24/2023, 6:08 PMIñigo Hidalgo
02/24/2023, 6:08 PMdatajoely
02/24/2023, 6:09 PMIñigo Hidalgo
02/24/2023, 6:09 PMdatajoely
02/28/2023, 4:13 PMIñigo Hidalgo
02/28/2023, 4:43 PMdatajoely
02/28/2023, 4:55 PMIñigo Hidalgo
02/28/2023, 4:55 PMFrits
02/28/2023, 6:07 PM