Source Table Name on workflow coming as "SQL Query"

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

    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