#questions
Title
# questions
j
Javier del Villar
10/19/2023, 5:21 PMHi 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_credentialsj
Javier del Villar
10/19/2023, 8:46 PMthanks a lot! I'll check it out! 😄
i
Iñigo Hidalgo
10/20/2023, 11:36 AMhttps://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 AMI 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 AMEnjoy your time off (if that’s why you’re offline :) )