Product Documentation

Appearance

7.1.2
7.0.2
6.9.3
5.4.17
5.2.31

ALTER EXTERNAL STORAGE ​

Alter one or more attributes of an external storage object.

ALTER EXTERNAL STORAGE name 
TYPE S3 | AZURE | AZDL2
ENDPOINT 'endpoint_uri'
[ REGION 'region_string']
[ IDENTITY 'identity_string']
[ CREDENTIAL 'credential_string']

You must specify the storage type (S3, AZURE, or AZDL2) and the endpoint URL.

For information about the ENDPOINT, REGION, IDENTITY, and CREDENTIAL options, see CREATE EXTERNAL STORAGE.

For example, alter the endpoint and region for an S3 storage object:

premdb=> alter external storage "premdbs3" 
type s3 endpoint 'https://s3.us-east-1.amazonaws.com' region 'us-east-1';
ALTER EXTERNAL STORAGE

Alter the endpoint for an Azure storage object:

premdb=> alter external storage "premdbAzure" 
type azure endpoint 'https://ybbobr.blob.core.windows.net/';
ALTER EXTERNAL STORAGE

You must have the correct privileges to run this command. See ON EXTERNAL object.

Parent topic:SQL Commands