Step "SQL Query" | Using environment variables

[bernabeudario]

Hi,

In Step “SQL Query” I configured the query to use an environment variable:

SELECT * FROM input_df1
WHERE Fecha = '{os.environ["ENV_DATE"]}'

I press the button “Export to Python code” and I see:

sqlQuery1 = duckdb.query("""SELECT * FROM inlineInput1
WHERE Fecha = f'{os.environ["ENV_DATE"]}'""").to_df().convert_dtypes()

Which causes an error and the variable is not replaced:

Catalog Error: Type with name f does not exist!
Did you mean "float"?

You should get something like:

sqlQuery1 = duckdb.query(f"""SELECT * FROM inlineInput1
WHERE Fecha = '{os.environ["ENV_DATE"]}'""").to_df().convert_dtypes()

SQLQuery_Using_environment_variables.zip

Attached pipeline.

Regards

[tgourdel]

Thanks @bernabeudario, I was able to reproduce