Import/Export from/to Microsoft Azure Blob Storage

Detail name	Value
Changelog Number	4394
Type	New Feature
Status	Resolved
Fix Versions	Exasol 7.0.0, Exasol 7.0.beta1
Resolution Date	2020-08-17

New functionality

IMPORT and EXPORT can now be used to read and write data directly from/to Microsoft Azure Blob storage containers.

To authenticate with a user/password, provide the Azure storage account name in the USER field and the storage account key in the IDENTIFIED BY field. As for other IMPORT/EXPORT statements, the connection information (username, password) can be stored in connection objects.

Syntax

The following are example statements.

IMPORT INTO testtable FROM CSV AT CLOUD AZURE 'https://teststorageaccount.blob.core.windows.net/testcontainer'
USER '<account-name>' IDENTIFIED BY '<account-key>' -- user/password
FILE 'test.csv';

EXPORT testtable INTO CSV AT CLOUD AZURE 'https://teststorageaccount.blob.core.windows.net/testcontainer'
USER '<account-name>' IDENTIFIED BY '<account-key>' -- user/password
FILE 'test.csv';