Native cloud deployment on Azure is not available for this version of Exasol, but you can install Exasol as a Linux application on Azure instances. For more information, see Installation.

Native cloud deployment on Google Cloud is not available for this version of Exasol, but you can install Exasol as a Linux application on Google Cloud instances. For more information, see Installation.

IMPORT allows accessing public files and presigned URLs from Amazon S3

Details

Detail name	Value
Changelog Number	15504
Type	Improvement
Status	Resolved
Fix Versions	Exasol 8.6.0, Exasol 7.1.16
Resolution Date	2022-10-12

Background

If the USER is left empty within an IMPORT command, the database tried to connect with temporary IAM credentials.

Improvement

The IMPORT command allows accessing public files and presigned URLs from Amazon S3.
Temporary IAM credentials are no longer used.

Example Presigned URL

IMPORT INTO table1 
FROM CSV 
AT 'https://testbucket.s3.eu-west-1.amazonaws.com' 
USER '' 
IDENTIFIED BY '' 
FILE 'test.csv?<querystring>'

Example public files

IMPORT INTO table1 
FROM CSV 
AT 'https://testbucket.s3.eu-west-1.amazonaws.com' 
USER '' 
IDENTIFIED BY '' 
FILE 'test.csv'