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

Welcome!

To participate in this community, sign in or register!