How to Create a table in Fabric Lakhouse usign the SQL Endpoint Analytics

[Shanthan8]

Hi Community,

I am trying to create a table in Sql Endpoint Analytics Option which is available in Fabric Lakehouse.
as shown in the below screenshot

when i am executing the query i am getting the following error

is there any specific reason for this or we can't create a table in Lakehouse SQL EndPoint Analytics.

Can any one in community provide help on this issue.

[Anonymous · Accepted solution]

Hi @Shanthan8 ,

Thanks for using Fabric Community.
Currently this is limitation with Sql End point.

Doc to refer - 
T-SQL surface area - Microsoft Fabric | Microsoft Learn
Creating Managed and External Spark Tables in Fabric Lakehouse | by Aitor Murguzur | Medium

Incase if you wish to create tables in lakehouse, I suggest you to use Spark SQL in Fabric Notebooks.

Hope this is helpful. Please let me know incase of further queries.