MYSQL ETL including parameters

shannonmoranWF
shannonmoranWF ⚪️
in Dataflows

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 

Answers

  • GrantSmith
    GrantSmith Indiana 🥷

    Hi @shannonmoranWF

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



    **Was this post helpful? Click the heart icon**

    **Did this solve your problem? Accept it as a solution!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    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`

    or

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



    Jae Wilson
    Check out my Domo Training YouTube Channel

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories