Kedro is an open-sourced Python framework for creating maintainable and modular data science code.

Kedro

Hi all! What would be the most kedronic way to achieve this?
The date placeholder of the query comes from the result from a node.

Catalog entry:
```users_dataset:
 type: pandas.SQLQueryDataset
 sql:
   select 
     * 
   from 
     table 
   where 
     date = ${some_date_from_node};
 credentials: db_credentials```
Thanks in advance!!

<https://kedro-org.slack.com/archives/C03RKP2LW64/p1695291572735829?thread_ts=1695291188.286309&amp;channel=C03RKP2LW64&amp;message_ts=1695291572.735829|https://kedro-org.slack.com/archives/C03RKP2LW64/p1695291572735829?thread_ts=1695291188.286309&amp;channel=C03RKP2LW64&amp;message_ts=1695291572.735829>

<https://github.com/kedro-org/kedro/issues/2374|https://github.com/kedro-org/kedro/issues/2374>

Further discussion around this question :)

<@U045L91RV9D>’s solution (which I hadn’t seen til now) seems to be a more general approach to lazy loading anything, whereas that issue is more specific to SQL queries. I’ve been experimenting with using Ibis’ very nice syntax to prototype a lazy load SQL dataset: <https://github.com/inigohidalgo/kedro-ibis-dataset|https://github.com/inigohidalgo/kedro-ibis-dataset>

I always seek for general solutions :smile:
I will analyse the rest in-depth once I get back online (after 02.11)

Enjoy your time off (if that’s why you’re offline :) )