Azure Synapse serverless create external parquet table with partition

sakuraime 2,316 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,363 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Saurabh Sharma 23,671 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.