ALTER CONNECTION

Purpose

Use this statement to change the connection data of an external connection.

Prerequisite

At least one of the following prerequisites must be fulfilled:

  • User has the system privilege ALTER ANY CONNECTION
  • The connection is granted to the user with the WITH ADMIN OPTION
  • The connection belongs to the current user or one of the user’s roles

Syntax

alter_connection::=

Alter Connection

Alter Connection

alter connection

alter connection

Examples

Exa-to-Exa connection

Copy 
ALTER CONNECTION exa_connection TO '192.168.6.11..14:8564';

FTP

Copy 
ALTER CONNECTION ftp_connection
      TO 'ftp://192.168.1.1/'
      USER 'my_user'
      IDENTIFIED BY 'my_secret'
      PUBLIC KEY 'my_public_key';

Oracle

Copy 
ALTER CONNECTION ora_connection TO '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.54)(PORT = 1522))
(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)))';

Amazon S3 on AWS

Copy 
ALTER CONNECTION my_s3_bucket
    TO 'https://<bucketname>.s3[-REGION].amazonaws.com'
    USER '<my_access_key>' 
    IDENTIFIED BY '<my_secret_key>'
    [SESSION TOKEN '<my_session_token>']
;

Azure Blob Storage

Copy 
ALTER CONNECTION my_blob_conn
    TO 'DefaultEndpointsProtocol=https;EndpointSuffix=core.windows.net'
    USER '<AccountName>' IDENTIFIED BY '<AccountKey>'
;

Authorization in Azure with SAS token or Microsoft Entra ID (AAD) is supported in Exasol 2026.1.0 and later. For more details, see Load data from Azure Blob Storage.

Copy 
ALTER CONNECTION my_blob_conn
    TO 'DefaultEndpointsProtocol=https;EndpointSuffix=core.windows.net'
    USER '<AccountName>' SAS TOKEN '<SASToken>'
;
Copy 
ALTER CONNECTION my_blob_conn
    TO 'DefaultEndpointsProtocol=https;EndpointSuffix=core.windows.net'
    USER '<AccountName>' IDENTIFIED BY '<ClientSecret>'
    CLIENT ID '<ClientId>'
    TENANT ID '<TenantId>'
;