Is there a way to overwrite a Kedro dataset query in code?
I want to be able to overwrite the WHERE clause in Kedro dataset queries. Let's say I have the following catalogue entry:
some_table.raw:
type: pandas.GBQQueryDataset
sql: SELECT * FROM database.table WHERE date >= {start_date}
Then, in the code, I want to overwrite it with something like:
catalog.load("some_table.raw", query={"start_date": "2024-01-01"})
I know it's impossible since the load method supports no arguments except for the dataset name. But perhaps there are some...