Common
This section provides a description of the information shared in common by processes that use the following databases:
-
DB2 (*1)
-
MySQL
-
Oracle
-
PostgreSQL (*1)
-
SQL Server
-
JDBC
-
Snowflake (*1)
-
Amazon Athena (*2)
|
*1 |
: |
It doesn't have the Execute Stored Procedure operation. |
|
*2 |
: |
It doesn't have the Write Table operation, Execute Update SQL operation, and Execute Stored Procedure operation. |
Supported versions
-
PostgreSQL 12
-
PostgreSQL 15
Amazon Aurora for MySQL connector
-
Amazon Aurora for MySQL 5.7
-
Amazon Aurora for MySQL 8.0
Amazon RDS for PostgreSQL connector
-
Amazon RDS for PostgreSQL 12
-
Amazon RDS for PostgreSQL 15
-
SQL Server 2019
-
SQL Server 2022
Notes
-
Connecting to Amazon RDS DB instances isn't supported.
-
To connect to Amazon RDS DB instances, use the Amazon RDS for PostgreSQL connector.
-
If you are using data sources other than Amazon S3, refer to the following document and set all the Lambda permissions used for your data sources:
https://docs.aws.amazon.com/athena/latest/ug/connect-to-a-data-source.html
Refer to the descriptions on each page from the links below.