Is it possible to view the SQL query of an ODBC Dataset in Domo?
I have an OBDC dataset running in Workbench on a server, but I want to make some updates to the SQL query. Is it possible to see the SQL query for that dataset directly in Domo or do I need to pull up the job in Workbench on the server?
Comments
-
I believe the only way to see the SQL is to navigate to the job in Domo workbench and look in the details of the query. Domo itself only receives the output of the query. Given there are more steps than can be performed after the SQL query is run, such as Workbench transforms, field encryption, schema changes, etc...all of which are also 'invisible' to Domo....I don't believe the Domo job details are made visible in Domo. The only exception to that, I believe, is if you export the workbench job then look at the contents of the JSON file where the query will be embedded (somewhere) - so if it's an access issue for you, seeing the job in workbench, possibly someone could export the job configuration for you and send you the JSON file.
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 511 Automate
- 114 Apps
- 389 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive