Glue Integration Parameters (Iceberg Metastore)

These parameters control how OpenText™ Analytics Database connects to AWS Glue when accessing Iceberg external tables. They are database-level ALTER DATABASE...SET PARAMETER or session-level ALTER SESSION...SET PARAMETER configuration settings. For example:

=> ALTER DATABASE SET PARAMETER='parameter=value';
 
=> ALTER SESSION SET PARAMETER='parameter=value';

These parameters are not part of the CREATE EXTERNAL TABLE ICEBERG statement because they affect connection behavior, not table definition.

GlueEnableHttps

Boolean, specifies whether to use the HTTPS protocol (TLS) when connecting to AWS Glue endpoints. If you choose not to use TLS, set this parameter to 0.

Default: 1 (Enabled)

To enable TLS, set as follows:

=> ALTER SESSION SET GlueEnableHttps='1';

To disable TLS, set as follows:

=> ALTER SESSION SET GlueEnableHttps='0';

GlueRegion

String, specifies the AWS Region for AWS Glue operations. This ensures the database contacts the correct regional Glue Data Catalog.

Default: Empty

If not specified, then the value is inherited from the AWSRegion parameter.

For example:

=> ALTER SESSION SET GlueRegion='us-east-1';

=> ALTER SESSION SET GlueRegion='ap-south-1';

GlueEndpoint

String, specifies the endpoint host for AWS Glue.

Default: Empty

If not specified, then the default endpoint is determined by the AWS SDK. You can set this parameter to override the default Glue endpoint.

For example:

=> ALTER SESSION SET GlueRegion='glue.us-east-1.amazonaws.com';

Interaction with HTTPS

When GlueEnableHttps = 1, connections use:

https://glue.us-east-1.amazonaws.com

When GlueEnableHttps = 0, connections use:

http://glue.us-east-1.amazonaws.com