Create a simple SQL routine in the PROJECT > Routines subfolder.
When attempting to populate the Inline SQL Transformation properties using the selection box in order to select my newly routine, it does not allow me to make a selection.
After running the pipeline, I receive the following error:
"Custom SQL is empty - write a SELECT or pick a SQL routine."
at the same time, entering hard-coded sql below in the free-form textbox, it's working just fine
Create a simple SQL routine in the PROJECT > Routines subfolder.
When attempting to populate the Inline SQL Transformation properties using the selection box in order to select my newly routine, it does not allow me to make a selection.
After running the pipeline, I receive the following error:
"Custom SQL is empty - write a SELECT or pick a SQL routine."
at the same time, entering hard-coded sql below in the free-form textbox, it's working just fine