ALTER CONNECTION

Syntax

ALTER {      
        ELASTICSEARCH |
        GLUE_CATALOG | 
        ICEBERG_REST_CATALOG |
        KAFKA | 
        KINESIS |      
        MSSQL |
        MONGODB |
        MYSQL |
        POSTGRES |
        REDSHIFT |
        S3 |  
        SNOWFLAKE 
        } CONNECTION <connection_identifier>
    SET <connection_option> = <value>
    [ SET <connection_option2> = <value2> ... ]; 

Note that not all connection options are mutable.

Connection options

Cloud storage

• Amazon S3

Metastores

• AWS Glue Data Catalog

• Polaris Catalog

Streaming systems

• Amazon Kinesis

• Apache Kafka

Databases

• Amazon Redshift

• Elasticsearch

• Microsoft SQL Server

• MySQL

• PostgreSQL

• Snowflake