Azure Synapse serverless create external parquet table with partition

sakuraime 2,321 Reputation points
2021-03-16T09:26:51.877+00:00

I have a parquet table folder in blob storage with partition .

/table/Partition=1
/table/Partition=2...

what should be the TSQL To create the external table ?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,652 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Saurabh Sharma 23,786 Reputation points Microsoft Employee
    2021-03-16T23:54:34.04+00:00

    @sakuraime Thanks for using Microsoft Q&A !!

    Unfortunately adding partitioning to serverless external tables is currently not possible. I will internally provide your feedback to products team however you can also upvote similar feedback available here.

    Thanks
    Saurabh

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.