Remove Suffix from filename in Azure data storage

Rasool, Bilal 20 Reputation points
2024-03-22T00:50:38.84+00:00

Hi There!

I am trying to write files in Azure Data Storage (with shared key authentication method) by using Talend ETL tool.

File is saved on Azure with some suffix (don't know from where it came) that I didn't mention in my code.

How can I save file on Azure Data Storage with exact file name that I choose?

Regards

Bilal

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,668 questions
0 comments No comments
{count} votes

Accepted answer
  1. Marcin Policht 9,270 Reputation points MVP
    2024-03-22T01:59:12.82+00:00

    Make sure you set the name correctly on the upload.

    Azure Storage does not change in any way the name you specify - so check the ETL tool you are using instead.


    hth

    Marcin

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Sumarigo-MSFT 43,406 Reputation points Microsoft Employee
    2024-03-22T03:45:51.36+00:00

    @Rasool, Bilal Welcome to Microsoft Q&A Forum, Thank you for posting your query here!

    It sounds like you are experiencing an issue with saving files to Azure Data Storage using Talend ETL tool. The suffix that you are seeing may be added by the tool or by Azure Data Storage itself. To save a file with the exact file name that you choose, you can try the following steps:

    1. Check the configuration of your Talend ETL job to ensure that you are specifying the correct file name. Make sure that you are not appending any suffix to the file name in your code.
    2. Check the configuration of your Azure Data Storage account to ensure that there are no settings that are adding a suffix to the file name. You can do this by logging into the Azure portal and navigating to your storage account. Check the settings for the container where you are saving the file.

    If you are still seeing a suffix added to the file name, you can try renaming the file after it has been saved to Azure Data Storage. You can do this using the Azure Storage Explorer tool or by using the Azure Storage REST API.

    To remove the suffix from the file name in Azure Data Storage, you can try the following steps:

    1. Use the Azure Storage Explorer tool to navigate to the container where the file is stored.
    2. Right-click on the file and select "Rename".
    3. Remove the suffix from the file name and click "Save".

    Alternatively, you can use the Azure Storage REST API to rename the file. You can do this by sending a PUT request to the file with the new file name in the request header. The request should include the authentication credentials for your Azure Data Storage account.

    I hope this helps! Let me know if you have any other questions.

    Please let us know if you have any further queries. I’m happy to assist you further.


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

    0 comments No comments