Re: Window functions missing from MySQL
Hi,
My data source is a flat file from FTP and i am using the SQL data flow in Domo for data transformations. I have a need to use rank function and am wondering if i can use rank() over window partition by method. I can use the MySQL method mentioned at below link, but the window method is throwing errors.
Does the redshift method work only when your data soruce is redshift databse? Thanks much in advance!
https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Rank_or_Row_Count
Best Answer
-
Hello,
Thank you for the request. MySQL recently started supporting windowing functions in their current version. Domo is not currently using that version. Redshift does support the windowing functions and you are able to load in your flat file into a Redshift DataFlow and use those functions.
You can also use Magic ETL, see this article to give you the information on the different options:
https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/03ETL_Actions%3A_Rank_and_Window
2
Answers
-
Hello,
Thank you for the request. MySQL recently started supporting windowing functions in their current version. Domo is not currently using that version. Redshift does support the windowing functions and you are able to load in your flat file into a Redshift DataFlow and use those functions.
You can also use Magic ETL, see this article to give you the information on the different options:
https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/03ETL_Actions%3A_Rank_and_Window
2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive