MYSQL ETL including parameters
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
0
Answers
-
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!**1 -
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"1
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 134 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 52 Domo Everywhere
- 2K Charting
- 994 Ideas Exchange
- 894 Connectors
- 236 Workbench
- 342 APIs
- 76 Apps
- 18 Governance & Productivity
- 233 Use Cases & Best Practices
- 49 News
- 473 Onboarding
- 570 日本支部