Edit or delete a data source connection
You can use the Athena console to update the description, host, port, database, and other properties for an existing connection. You can also delete the data sources from Athena console.
Edit a data source connection
To edit a data source connection
Open the Athena console at https://console.amazonaws.cn/athena/
. If the console navigation pane is not visible, choose the expansion menu on the left.
-
In the navigation pane, choose Data sources and catalogs.
-
On the Data sources and catalogs page, choose the data source connection that you want to edit.
-
For Amazon Glue connection details, choose Edit.
-
Choose Next.
-
On the Edit <connection-name> page, update the information as required. Available properties depend on the connection type.
Note
When you update connection properties for secrets, spill location, or Amazon KMS key ID, make sure the Lambda execution role still has access to the updated resources. For more information, see Viewing and updating permissions in the execution role in the Amazon Lambda Developer Guide.
-
Description – Edit the description for your connection.
-
Host – Edit the host name for your database.
-
Port – Edit the port number for your database.
-
Database – Edit the name of your database.
-
JDBC parameters – Edit any additional JDBC parameters required for your connection.
-
Secret – Choose or create a secret from Amazon Secrets Manager. Use Amazon secrets to avoid hardcoding sensitive information in your JDBC connection string. For more information, see What is Amazon Secrets Manager? For information about creating a secret in Secrets Manager, see Create an Amazon Secrets Manager secret in the Amazon Secrets Manager User Guide.
To use Amazon Secrets Manager with Athena federated queries, you must configure an Amazon VPC private endpoint for Secrets Manager. For more information, see Create a Secrets Manager VPC private endpoint in the Amazon Secrets Manager User Guide.
-
Spill location in Amazon S3 – Choose or create an Amazon S3 bucket location in your account to store data that exceeds Lambda function response size limits.
Note
Spilled data is not reused in subsequent executions and can be safely deleted after 12 hours. Athena does not delete this data for you. To manage these objects, consider adding an object lifecycle policy that deletes old data from your Amazon S3 spill bucket. For more information, see Managing your storage lifecycle in the Amazon S3 User Guide.
-
Encryption for query results in S3 – Choose one of the following:
-
(Default) Use a randomly generated key – Data that is spilled to Amazon S3 is encrypted using the AES-GCM authenticated encryption mode and a randomly generated key.
-
Use an Amazon KMS key – Choose or create a stronger, Amazon KMS generated encryption key. For more information, see Creating keys in the Amazon Key Management Service Developer Guide.
-
Turn off – Do not encrypt spill data.
-
-
Networking settings – Some connections require a virtual private cloud (VPC). Choose or create a VPC that has the data store that you want to access, a subnet, and one or more security groups. For more information, see Create a VPC for a data source connector or Amazon Glue connection.
Note
-
After you update connection properties for resources such as secrets, spill location, or Amazon KMS key ID, make sure that the Lambda execution role continues to have access to the updated resources.
-
After you update the network settings for your connection, make sure you update the Lambda function with the same settings to make your connection compatible with the data source.
-
For information about additional connection properties, see Amazon Glue connection properties in the Amazon Glue User Guide or Available data source connectors in the Amazon Athena User Guide.
-
-
Choose Save.
The Amazon Glue connection details section of the page for your data source shows the updated information for your connector.
Delete a data source
When you delete a data source, it only deletes the Athena data source and does not delete resources like the Glue connections, IAM execution role, and Lambda function.
To delete a data source
Open the Athena console at https://console.amazonaws.cn/athena/
. -
In the navigation pane, choose Data sources and catalogs.
-
On the Data sources and catalogs page, choose the data source that you want to delete.
-
Choose Delete.
-
On the Delete data source page, type confirm to confirm deletion and the choose Delete. It may take some time before the data source deletion completes. You get a success alert once the data source is deleted.