debussy-labs/debussy_concert

Reverse ETL extract_query_from_temp does not support .sql file

NiltonDuarteAtDotz opened this issue · 0 comments

Parameter extract_query_from_temp from Reverse ETL composition does not support setting a .sql file.
This query need to get the value of reverse_etl_table_uri that is not passed/parsed by jinja and is internally replaced using f-string.
The solution might be to pass an user defined macro to be used in a jinja templating (see user_defined_macros in https://www.astronomer.io/guides/templating/)