Invalid query check your dataset schema.

I have run an ETL within Magic ETL and got error "Invalid query check your dataset schema" while viewing data output. Can anyone be able to assist in solving this error.


Best Answer

  • MarkSnodgrass
    Answer ✓

    The information you provided is pretty vague, but if your source data comes from Domo Workbench, I would open up Workbench and check to see if the schema changed on that job and then refresh the schema in there by clicking the preview icon and then running the Workbench job again.

    If that is not it, I would just try re-running the ETL and see if it was a timing issue.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    Answer ✓

    The information you provided is pretty vague, but if your source data comes from Domo Workbench, I would open up Workbench and check to see if the schema changed on that job and then refresh the schema in there by clicking the preview icon and then running the Workbench job again.

    If that is not it, I would just try re-running the ETL and see if it was a timing issue.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Thank you Mark