Federated Queries - Dynamic SQL Generation Improvements

DataArchitect
Member
I've observed that the dynamic SQL that gets executed for federated datasets isn't always the most optimal. For instance to fetch the possible value list for a series or quick filter, it is still executing the same query as for the main card. It would perform much faster if it did a distinct over just the column needed for that quick filter. Or it shared the results from the main card query. But I've seen Domo execute two queries that are identical, once for the main card but then a second for quick filter options. It makes the federated database work harder than it needs to. Plus if the federated DB is a columnar db such as Redshift, it could return a distinct list much faster rather waiting for the aggregate query to return.
Tagged:
1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive