Source Table Name on workflow coming as "SQL Query"

abhish
abhish Member
edited December 2023 in General

Hello,

One of my workflow datasets is SQL query and when I pull metadata like database name, table name, and hostname; the table name is coming as 'SQL Query' instead of the actual table name. Does anyone know what is causing this issue and how do I fix it?

Answers

  • Henry Simms
    Henry Simms Administrator

    I think I would expect this, given that the SQL query may join multiple tables or views. In the case where the query is a simple SELECT I suppose it may be desirable for Data Studio to try to parse the table or view name from the custom SQL

Categories