MYSQL ETL including parameters

shannonmoranWF
shannonmoranWF Member
in Magic ETL

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 Coach

    Hi @shannonmoranWF

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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    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 ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories