Need to extract all queries used in our SQL Server connectors.

jimsteph · 2023-04-19T18:32:18+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

SQL

Connectors

Accepted answers

All comments

Haloupek

I agree this would be very, very helpful.

RobB

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?

jimsteph

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.

manojshipwire

I wanted the same - is there any CLI tool that can help me get all queries inside domo datasets - thanks.

ellibot

@manojshipwire @jimsteph it looks like you can get the query that powers the domo dataset by hitting this API:

GET https://{{instance}}.domo.com/api/data/v1/streams/{{streamId}}

The Stream Id for connectors can be found in the DomoStats Dataset History report.