MYSQL ETL including parameters

shannonmoranWF · 2021-03-04T22:07:36+00:00

There was an error rendering this rich post.

Is there a way to create parameters in SQL statements within the MySQL ETL data flow?

Here is an example:

set @lastDate = select * from `last_date_of_spent_data`; -- this returns a single column and row

Select `Program Name`, @lastDate as LastClosedPeriod

Find more posts tagged with

you can use variables within a MySQL data flow following standard MySQL 5.6 syntax

Sure.

just store the qeuery as table, and CROSS APPLY it to your table. Not sexy, but gets the job done.

select * from `last_date_of_spent_data`

SELECT *
FROM table
, ( select max(date) as LastDate from `last_date_of_spent_data`) ld