SQL View of DataSets

Is there a way to view the SQL query of an output dataset in Domo?

We are working on exporting our data to Cognos and it would be nice to see the query we are working with in Domo when recreating it in Cognos.

Thanks,

Erik

Best Answers

  • MichelleH
    MichelleH 🟢
    Answer ✓

    @EWold It depends on where your dataset comes from. If the dataset is an output of a dataflow, you should be able to see the query in the dataflow editor if it is from a MySQL or Redshift dataflow. Otherwise, I don't believe there is a way to produce the SQL query from a MagicETL.

  • GrantSmith
    GrantSmith Indiana 🥷
    Answer ✓

    Magic ETL isn't performing SQL under the hood so there's no SQL to extract from the ETL. It's all done using Apache Spark. You'd need someone to look through your ETL logic and then write then translate it into SQL.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • EWold
    EWold ⚪️

    Hi Michelle,

    My dataset does come from the output of a DataFlow, but I'm unsure where to see the SQL behind the DataFlow. Where in DataFlow editor can I see it? Below is a basic example of what I'm working with.


    Thanks,

    Erik

  • @EWold , do you have anyone in your organization who knows SQL? The Magic ETL is just a visual representation of SQl, so if there's somebody who's knowledgeable with SQL, they should be able to use the ETL to write an equivalent query.

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**