Azure Cache for Redis
An Azure service that provides access to a secure, dedicated Redis cache, managed by Microsoft.
259 questions
Azure Redis cache
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 98%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sanju Kushwaha
1
Reputation point
How to import .csv file to Azure Redis cache manually through portal or powershell?
I am getting below exception when I tries to import. looks like its expecting .rdb file which I am not aware of.
Import-AzRedisCache: One of the SAS URIs provided could not be used for the following reason: The data contained within the selected blob is not in a format supported by the Redis Import operation. Please select a blob in the Redis RDB file format. As an example, a blob that was generated using the Azure Redis Export feature would bein the correct format.
RequestID=29b1b234-32c7-413f-8a1c-fca5b92c0974
{count} votes
-
Oury Ba-MSFT 19,581 Reputation points Microsoft Employee2021-05-19T17:41:34.113+00:00 Hi @Sanju Kushwaha Thank you for posting your question. We are looking into this issue and will get back shortly.
Regards,
Oury -
Oury Ba-MSFT 19,581 Reputation points Microsoft Employee
2021-05-21T23:09:46.273+00:00 Hi @Sanju Kushwaha Thank you for being patient while looking into this issue. Redis does not support import of csv files directly. An RDB file is a serialized copy of a Redis database and is one of two formats Redis supports (the other being AOF).
We have found several potential solutions. Most suggest writing a script which will converts the csv file into a set of redis commands which would then be passed to the redis-cli. This is not something that can be automated as redis has many possible data structures.
Hope that helps.Please let us know if you have further query.
Regards,
Oury -
Oury Ba-MSFT 19,581 Reputation points Microsoft Employee
2021-05-24T17:08:38.853+00:00 Hi @Sanju Kushwaha Just checking if you have any further query regarding the above. Thanks
Oury -
Sanju Kushwaha 1 Reputation point
2021-05-31T16:03:13.07+00:00 I need to upload half million records. I have also created a web application to convert csv data to json and used StringSet() to import data under Redis cache. For 1000 records it was working fine but for half million records it was giving below error
"An unknown error occurred when writing the message" for StackExchange package
Sign in to comment
Sign in to answer