Need to extract all queries used in our SQL Server connectors.
We recently realized that someone in the past hard-coded database names — names which have since changed — in some of the SQL queries used in the SQL Server connectors. Unfortunately, we have hundreds of connectors, and opening up each of them manually to look for a problem will not be fun. To avoid doing that I want a way to bulk extract the SQL from all of these connectors to a file or dataset that we could then look through. I looked in DomoStats to see if maybe this was available in an XML field, but couldn't find anything close. Is there any way to do this?
Answers
-
I agree this would be very, very helpful.
0 -
I'm going to see if there's a way to do this with the CLI. I don't think it can do this, but I want to try some things and see. If not, I'm confident using either developer tools or Jupyter notebook integration could get us the detail. Would you like go down that path if possible?
0 -
I'm a novice with both, but I'm willing to learn, and I've got people here who could probably take it over if I get in over my head.
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 542 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 344 Distribute
- 86 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 6 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive