Forum Discussion

MohammedS's avatar
MohammedS
New Member
1 year ago

External table Creation in Fabric

Hi, I wanted to create an external table in fabric/ADLS and file type is Parquet. Not getting to find any article which is useful , all the sql query which is written is giving syntax error: h...
data engineering
lakehouse
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi MohammedS 

 

The statements you are referring to are in the SQL Server 2022 documentation. It's likely that Fabric doesn't support these statements. When you switch the documentation to the Fabric version, you will notice that these statements are not available.

Although Fabric provides many SQL Server features through Data warehouse and SQL analytics endpoint, it doesn't support all of the table features offered by SQL Server at this time. According to this documentation, External tables are not currently supported in Data warehouse and SQL analytics endpoint in Fabric.

 

So if you want to experience with external tables in Fabric, you can create them in a lakehouse via a notebook. You could refer to frithjof_v 's reply. 

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!