Forum Discussion

Element115's avatar
Element115
Memorable Member
2 years ago
Solved

QUESTION::SQL ENDPOINT::INFORMATION_SCHEMA::QUERY RETURN NOTHING

Why do the following 2 TSQL queries return an empty result set?  Also nothing with a WHERE clause on a table name in the LH.     SELECT * FROM INFORMATION_SCHEMA.VIEW_COLUMN_USAGE       SEL...
data engineering
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Element115 
    Create a view using table present in lakehouse and retry.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Element115 
Thanks for using Fabric Community.
If you have any views in the lakehouse, then the queries will return some data.

For example:
I had no views in Lakehouse_2:


In other case I created a view in another lakehouse:


Hope this helps. Please let me know if you have any other questions.

Element115's avatar
Element115
Memorable Member
2 years ago

Oh I am sorry.  It's the column and table usage of any VIEWS.  I was reading this as the verb 'to view' the column and/or table usages of tables, not views.  Need another coffee.  😁  I have no views, so ofc it's empty.  Thanks.