SQL Query against dataset
Hi, I am wondering if anyone has ever had a ask for a way to just write sql against a dataset, or join to datasets. I know we have redshift, but this would be more like a SQL IDE you would use in a relational database. I know its kinda an odd question, but we have some users who prefer sql vs magic etl. I have seen the AI demo that generates the SQL and runs against a dataset so seems possible.
Comments
-
@Byboth Yes, Domo supports SQL dataflows in MySQL and Redshift:
That said, MagicETL runs much more efficiently than SQL dataflow because it can execute steps simultaneously whereas SQL transforms must be run sequentially. As someone who was also more comfortable with SQL I've found that switching to MagicETL has been well worth it because it reduces the amount of time between runs, so I don't have to spend so much time waiting to validate my dataflow changes.
1 -
@Byboth - Michelle is spot-on.
Have you tried to create any dataflows yet? The SQL option is quite prominent, so I am thinking you are just looking at documentation, perhaps?
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Check out this "SQL EDITOR" option in Views Explorer:
Which enables this:
View queries are evaluated for each query against the view. If the underlying dataset is large and/or you have a lot of queries, "materializing" the results of the query using a DataFlow may be desirable. If you prefer to use SQL in a DataFlow, you can currently leverage MySQL, Redshift, or Adrenaline DataFlows (depending on which of those you have available in your instance).
A SQL tile for MagicETL is entering beta soon. This tile will allow you to author SQL which will still execute in parallel with the rest of the MagicETL DataFlow (no impact to parallelization/performance).
0 -
I'll have to read up on @timehat's suggestion. I don't use the Views Explorer because I don't want it altering my ability to use standard tools as the warning says. That message always keeps me from exploring…bad pun intended.
Michelle is absolutely right about speed. Domo's implementation of SQL is horrendous. I too am much more comfortable in MS SQL but stay away from it in Domo unless it's the only way I can implement something.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
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