https://kedro.org/ logo
#questions
Title
# questions
j

Javier del Villar

10/19/2023, 5:21 PM
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:
Copy code
users_dataset:
 type: pandas.SQLQueryDataset
 sql:
   select 
     * 
   from 
     table 
   where 
     date = ${some_date_from_node};
 credentials: db_credentials
Thanks in advance!!
j

Javier del Villar

10/19/2023, 8:46 PM
thanks a lot! I'll check it out! 😄
i

Iñigo Hidalgo

10/20/2023, 11:36 AM
https://github.com/kedro-org/kedro/issues/2374 Further discussion around this question :)
@marrrcin’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
👍 1
m

marrrcin

10/20/2023, 11:43 AM
I always seek for general solutions 😄 I will analyse the rest in-depth once I get back online (after 02.11)
🙂 1
i

Iñigo Hidalgo

10/20/2023, 11:44 AM
Enjoy your time off (if that’s why you’re offline :) )