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

Brandon Meek

02/19/2024, 5:45 PM
Hey all, I've got a dataset with a decently complex sql query to load it, since the query is nearly 50 lines I put it into a sql file in
conf/base/queries/
I would like to still use globals to define certain parameters in the sql query like I can in my catalog, but it doesn't seem like that's happening automatically, is there a way I can tell
OmegaConf
to parse my
queries
directory?
🤔 1
n

Nok Lam Chan

02/19/2024, 8:11 PM
Not 100% sure, would it work if you create another resolver (
${read_file}
)to read the file?
b

Brandon Meek

02/20/2024, 7:51 PM
I can try this, I thought adding it to the
config_patterns
would work, but it didn't
2 Views