Azure Synapse serverless create external parquet table with partition

sakuraime 2,331 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.
5,184 questions
0 comments No comments
{count} votes

1 answer

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


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.