Table Storage Import from CSV Row Limit

Oz Brown 21

I am trying to import USA ZipCode data into an Azure Table Storage Table using AZ Storage Explorer. When the import procedure completes running the CSV file, it only has uploaded 199 rows of data, not the 38K rows that exist in the dataset. Is there a configuration I need to do that allows the process to properly batch the request to allow all data rows to be imported?

Kevin Lineback 1 Reputation point

2022-01-18T02:12:09.263+00:00

I'm having the same problem.
Sumarigo-MSFT 47,021 Reputation points Microsoft Employee

2022-01-19T10:59:46.91+00:00

@Oz Brown If possible, can you share some sample data that you're trying to upload? May I know which version of Azure Storage explorer are you using?
For a better understanding of Azure Storage Table design, you could refer to this tutorial.
Additionally, you could import a CSV file to Azure Table Storage by using PowerShell script or Azure Storage Client Library for your development language.
You can also Copy data to and from Azure Table storage using Azure Data Factory

In mean while I will check with the product team on row limit size and get back to you!
Carlos Paz-Soldan 1 Reputation point

2022-01-22T00:41:07.14+00:00

Having the same problem loading UNSPSC table (21,206 rows) and NAICS (2084 rows).
It worked fine last week and today my imports kept stopping after 199 rows.
Thanks for the answer, I was pulling my hair!
I'll try to find an older version.

Accepted answer

Sumarigo-MSFT 47,021 Reputation points Microsoft Employee

2022-01-20T17:55:04.253+00:00

@Oz Brown We looked into this, and we were able to reproduce this behavior in 1.22.0. This is likely in part due to the large amount of work we did in that release to update the table client library. 1.23 and older do not have these changes, so this would not be reproducible in those versions.

This behavior is a bug, and we will be including a fix in our 1.22.1 hotfix, which we plan to release soon. Will keep you updated!

----------

Please do not forget to and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Table Storage Import from CSV Row Limit

0 additional answers

Your answer