Destination Azure Blob Storage: save file with correct extension

[marcosmarxm]

Environment

• Airbyte version: 0.40.29
• OS Version / Instance: macOS
• Deployment: Docker
• Source Connector and version: Zendesk Ticket
• Destination Connector and version: Azure Blob Storage 0.2.0
• Step where error happened: Deploy / Sync job / Setup new connection / Update connector / Upgrade Airbyte

Current Behavior

Files after the sync don't save the extension (csv or json)

Expected Behavior

Tell us what should happen.

Logs

Steps to Reproduce

Are you willing to submit a PR?

Remove this with your answer.

[localfolkhero]

Also have this concern. If it's a json/jsonl format - extension should be either json or jsonl. If csv, then csv.

Nothing as an extension is not very helpful and makes integrations more work.

[edweip3]

Please add the extension names to the blob storage destination. This connector is useless without the extension since most of other apps that pull from azure blob storage looks at file extensions to determine file type.

[marijncv]

Also interested in this feature! Should be addressed by #27701