You can import data that's been stored using Amazon Simple Storage Service into a table on an Aurora PostgreSQL DB cluster instance. To do this, you first install the Aurora PostgreSQL aws_s3 extension. This extension provides the functions that you use to import data from an Amazon S3 bucket. A bucket is an Amazon S3 container for objects and files. The data can be in a comma-separate value (CSV) file, a text file, or a compressed (gzip) file. Following, you can learn how to install the extension and how to import data from Amazon S3 into a table.
Your database must be running PostgreSQL version 10.7 or higher to import from Amazon S3 into Aurora PostgreSQL.
If you don't have data stored on Amazon S3, you need to first create a bucket and store the data. For more information, see the following topics in the Amazon Simple Storage Service User Guide.
Cross-account import from Amazon S3 is supported. For more information, see Granting cross-account permissions in the Amazon Simple Storage Service User Guide.
You can use the customer managed key for encryption while importing data from S3. For more information, see KMS keys stored in AWS KMS in the Amazon Simple Storage Service User Guide.
NoteImporting data from Amazon S3 isn't supported for Aurora Serverless v1. It is supported for Aurora Serverless v2.
Integrating Aurora PostgreSQL with AWS services
Installing the extension
Did this page help you? - Yes
Thanks for letting us know we're doing a good job!
If you've got a moment, please tell us what we did right so we can do more of it.
Did this page help you? - No
Thanks for letting us know this page needs work. We're sorry we let you down.
If you've got a moment, please tell us how we can make the documentation better.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4