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

Options
jimsteph
jimsteph Contributor

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?

Tagged:

Answers

  • Haloupek
    Options

    I agree this would be very, very helpful.

  • RobB
    RobB Domo Employee
    Options

    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
    jimsteph Contributor
    Options

    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
    Options

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

  • ellibot
    ellibot Contributor
    Options

    @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.