Data Source Properties
Properties common to all data sources
You can change the following properties for all the data sources:
Property | Description | Examples / Limitations |
---|---|---|
Catalog Name | Enter a name for the data source. This is unique across the Ahana compute plane. We recommend a descriptive name to help you identify the data source. It will also be used as the name of the catalog when attached to a Presto cluster. | Due to Presto limitations, this value can only contain lowercase letters, numbers and underscores. |
Description | Optional description to add context to the data source. |
Hive Metastore for Amazon S3 properties
You can change the following properties for the Hive Metastore for Amazon S3 data source:
Property | Description | Examples / Limitations |
---|---|---|
Thrift Endpoint URI(s) | The URI(s) of your Hive metastore Thrift service. Define multiple URIs by separating them with commas. | thrift://example.net:9083 |
S3 Role ARN | The ARN of the role that can connect to your S3 Bucket. | arn:aws:iam::123456789012:role/my-s3-role |
Amazon Glue for S3 properties
You can change the following properties for the Amazon Glue for S3 data source:
Property | Description | Examples / Limitations |
---|---|---|
AWS Region | The Region where your AWS Glue Data Catalog is located. | |
Glue/S3 Role ARN | Amazon Resource Names (ARNs) uniquely identify AWS resources. Enter the ARN for the Glue/S3 IAM Role that was created using the CloudFormation quick create. This role will be used by your Presto cluster to access your S3 data via the Glue Catalog. | arn:aws:iam::123456789123:role/ahana-cloud-datasource-glue-s3-role |
Amazon OpenSearch properties
You can change the following properties for the Amazon OpenSearch data source:
Property | Description | Examples / Limitations |
---|---|---|
Endpoint | The URL of the OpenSearch instance. | https://search-es-abcd.us.east-1.es.amazonaws.com |
Enable TLS Encryption | Default is Enabled. | |
AWS Region | The AWS region where the OpenSearch instance is located. | |
Access Key ID | The AWS access key for the user with permission to connect to your OpenSearch instance. | AKIRASB3AK3RXMR33PUK |
Secret Access Key | The secret access key associated with the Access Key ID. |
Amazon RDS for MySQL properties
You can change the following properties for the Amazon RDS for MySQL data source:
Property | Description | Examples / Limitations |
---|---|---|
Endpoint | The endpoint of the RDS instance. | database-1.abcd.us-east-1.rds.amazonaws.com . The endpoint must be accessible from the VPC where the Presto clusters are running. |
Port | The port for the RDS instance. The default port for MySQL is 3306. | |
Configuration Properties | Additional properties which can be used to specify additional driver behavior specific to MySQL. See Configuration Properties. | readOnly=true&loggerLevel=DEBUG |
User | The database username. | |
Password | The password for the database user. |
Amazon RDS for PostgreSQL properties
You can change the following properties for the Amazon RDS for PostgreSQL data source:
Property | Description | Examples / Limitations |
---|---|---|
Endpoint | The endpoint of the RDS instance. | database-1.abcd.us-east-1.rds.amazonaws.com . The endpoint must be accessible from the VPC where the Presto clusters are running. |
Port | The port for the RDS instance. The default port for PostgreSQL is 5432. | |
Configuration Properties | Additional properties which can be used to specify additional driver behavior specific to PostgreSQL. See Connecting to the Database. | readOnly=true&loggerLevel=DEBUG |
Database Name | The name of the database to connect to. | To access multiple databases on this database server, create additional data sources with the same endpoint and port and a different database name. |
User | The database username. | |
Password | The password for the database user. |
Amazon Redshift properties
You can change the following properties for the Amazon Redshift data source:
Property | Description | Examples / Limitations |
---|---|---|
Endpoint | The endpoint of the Redshift server. | redshift-cluster-1.clngqtvnco8w.eu-west-2.redshift.amazonaws.com:5439/dev . The endpoint must be accessible from the VPC where the Presto clusters are running. |
Connection Parameters | Additional properties which can be used to specify additional driver behavior specific to PostgreSQL. | readOnly=true&loggerLevel=DEBUG |
User | The database username. | |
Password | The password for the database user. |