Federated Queries - Dynamic SQL Generation Improvements
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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 176 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive