question

sakuraime avatar image
0 Votes"
sakuraime asked ·

Azure Synapse serverless create external parquet table with partition

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
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered ·

@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.

· 3 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thanks for your reply .

Which means External table can't be created when the parquet table are already partition on the blob storage ?

0 Votes 0 ·

@sakuraime yes, that is correct.


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

0 Votes 0 ·

@sakuraime Please let me know if you find above reply useful. If yes, do click on 'Mark as answer' link in above reply. This will help other community members facing similar query to refer to this solution. Thanks.

0 Votes 0 ·