Select data from Lakehouse table from schema

[Ali_CloudBI]

Hi all,

I have an issue working with the delta table in Lakehouse when the data is created in a schema other than dbo. The table is created under the schema by  SourceDF.write.format("delta").mode("overwrite").save(TablePath), however, I get an error on reading the table. Has anyone tested this before?

[Anonymous]

Hi @Ali_CloudBI ,

Thanks for the reply from lbendlin .

I get an error when I query the table below the dbo using your syntax.

After switching to this syntax, it runs fine.

%%sql
USE daisyTest1;
SELECT * FROM products LIMIT 1000.

This syntax can not specify the schema in the red box, only the blue box.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Ali_CloudBI]

I know it works without schema, my intention is to create different schemas and create the related tables under each own schema  

[lbendlin]

can you run queries against dbo tables?

Maybe omit the db name?

[Ali_CloudBI]

Hi @lbendlin , same error when use dbo as the schema, however it works fine when use LakehouseName.TableName. enabling schema in Lakehouse still in preview and looks like this a bug. 

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .