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?

Not 100% sure, would it work if you create another resolver (

${read_file}

)to read the file?

I can try this, I thought adding it to the

config_patterns

would work, but it didn't