Data Source Properties

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.

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`

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`

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.

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.

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.

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.