Amazon Redshift auto-copy is now available in the AWS Asia Pacific (Malaysia), Asia Pacific (Thailand), Mexico (Central), and Asia Pacific (Taipei) regions. With Auto-Copy, you can set up continuous file ingestion from your Amazon S3 prefix and automatically load new files to tables in your Amazon Redshift data warehouse without the need for additional tools or custom solutions.
Previously, Amazon Redshift customers had to build their data pipelines using COPY commands to automate continuous loading of data from S3 to Amazon Redshift tables. With auto-copy, you can now setup an integration which will automatically detect and load new files in a specified S3 prefix to Redshift tables. The auto-copy jobs keep track of previously loaded files and exclude them from the ingestion process. You can monitor auto-copy jobs using system tables.
To learn more, see the documentation or check out the AWS Blog.
Categories: marketing:marchitecture/databases,marketing:marchitecture/analytics
Source: Amazon Web Services
Latest Posts
- (Updated) Microsoft Loop – Require Existing Microsoft 365 Group for New Loop workspaces [MC929022]
- (Updated) Microsoft 365 Copilot: Podcast voice interactions make audio experiences conversational [MC1183009]
- (Updated) Microsoft Outlook for iOS/Android: Improved Contacts with profile enrichment and duplicate management [MC1093912]
- (Updated) Microsoft 365 Copilot: Business justification for Copilot license requests [MC1227088]
![(Updated) Microsoft Teams: New keyboard shortcut for adding emojis [MC1000269]](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-googledeepmind-17483867-150x150.webp "(Updated) Microsoft Teams: New keyboard shortcut for adding emojis [MC1000269] 6")
