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

Galen Seilis

02/07/2024, 11:45 PM
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

Deepyaman Datta

02/07/2024, 11:48 PM
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

Galen Seilis

02/07/2024, 11:49 PM
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

Nok Lam Chan

02/08/2024, 12:16 AM
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

Galen Seilis

02/08/2024, 1:07 AM
@Nok Lam Chan Thanks!