Skip to main content

Modify Data Sources

You can modify your data source properties after the initial configuration.

Step 1: Navigate to the data sources screen#

Start by clicking the Data Source tab in the top menu bar.

Data Sources view

Step 2: Select the data source you want to modify#

Click on the View button for the data source you want to modify, then click Modify Data Source.

Data Source view

Step 3: Modify the data source properties#

caution

If there is an active Presto cluster attached, modifying the data source will restart the cluster. All queries running will fail. The cluster will be moved to pending state and will be unusable until it moves back to active state.

Properties common to all data sources#

You can change the following properties for all the data sources:

PropertyDescriptionExamples / Limitations
Catalog NamePick 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.
DescriptionOptional 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:

PropertyDescriptionExamples / Limitations
Thrift Endpoint URI(s)The URI(s) to your Hive metastore Thrift service. You may define multiple URIs by separating them with commas.e.g. thrift://example.net:9083
S3 Role ARNThe ARN of the role that can connect to your S3 Bucket.e.g. 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:

PropertyDescriptionExamples / Limitations
AWS RegionThe Region where your AWS Glue Data Catalog is located.
Glue/S3 Role ARNAmazon 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.e.g. arn:aws:iam::123456789123:role/ahana-cloud-datasource-glue-s3-role

Amazon Elasticsearch properties#

You can change the following properties for the Amazon Elasticsearch data source:

PropertyDescriptionExamples / Limitations
EndpointThe URL of the Elasticsearch instance.e.g. https://search-es-abcd.us.east-1.es.amazonaws.com
AWS RegionThe AWS region where the Elasticsearch instance is located.
Access Key IDThe AWS access key for the user with permission to connect to your Elasticsearch instance.e.g. AKIRASB3AK3RXMR33PUK
Secret Access KeyThe secret access key associated with the access key ID defined above.

Amazon RDS for Mysql, PostgreSQL properties#

You can change the following properties for the Amazon RDS data source:

PropertyDescriptionExamples / Limitations
EndpointThe endpoint to the PostgreSQL RDS instance.e.g. database-1.abcd.us-east-1.rds.amazonaws.com. This endpoint needs to be accessible from the VPC where the Presto clusters are running.
PortThe port for the PostgreSQL RDS instance (the default port for PostgreSQL is 5432).
Configuration PropertiesAdditional properties which can be used to specify additional driver behavior specific to PostgreSQL. See https://jdbc.postgresql.org/documentation/head/connect.html for more details.e.g. readOnly=true&loggerLevel=DEBUG
Database Name (PostgreSQL only)The name of the database to connect to.If you need to access multiple databases on this database server, please create additional data sources with the same endpoint and port and a different database name.
UserThe database username.
PasswordThe password for the database user.

Amazon Redshift properties#

You can change the following properties for the Amazon RDS data source:

PropertyDescriptionExamples / Limitations
EndpointThe Endpoint to the Redshift server.e.g. redshift-cluster-1.clngqtvnco8w.eu-west-2.redshift.amazonaws.com:5439/dev. This Endpoint needs to be accessible from the VPC where the Presto clusters are running.
Connection ParametersAdditional properties which can be used to specify additional driver behavior specific to PostgreSQL.e.g. readOnly=true&loggerLevel=DEBUG
UserThe database username.
PasswordThe password for the database user.