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
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 464 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 190 Visualize
- 252 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
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive