Where is the most Kedronic (i.e. idiomatic Kedro) ...
# questions
g
Where is the most Kedronic (i.e. idiomatic Kedro) path to put SQL queries in my kedro project? They'll be accessed using the
filepath
option in
SQLDataset
.
d
Don't think there's a standard answer; Kedro supports SQL in these very limited cases, so there's no broader recommendation that I'm aware of.
g
Okay, thank you!
For now I will put them in
/data/00_scripts
with a README explaining that the directory is only for scripts that are responsible for obtaining data. But ping me, anyone, who has other suggestions.
n
I will just have a sql folder if they are just reading data from some table. If it's etl script then I may just follow what the Sql world using, having the raw, staging etc.
g
@Nok Lam Chan Thanks!