- Mais recentes
- Mais votos
- Mais comentários
Hello,
Yes you can use Amazon Redshift Serverless as target for KDS. I would suggest to use Redshift streaming ingestion feature to ingest data from KDS to Redshift serverless in near real time. Redshift ingests the data from streams into a materialized view which you can control by doing manual refresh and then use the materialized view to do further transformations as needed.
You can refer to the below docs to learn more about the streaming ingestion.
https://aws.amazon.com/redshift/redshift-streaming-ingestion/ https://aws.amazon.com/blogs/big-data/real-time-analytics-with-amazon-redshift-streaming-ingestion/
Here's a concise guide to load data into Redshift Serverless from a Step Function:
- Ensure your Redshift Serverless cluster is properly configured and accessible, and define the necessary tables and schemas in Redshift Serverless to accommodate the incoming data.
- Your Step Function is triggered by an EventBridge event, which is, in turn, triggered by data ingested into Kinesis.
- A Lambda function within your Step Function extracts and enriches the data as required.
- Your Lambda function can write the enriched data to an S3 bucket.
- You can have another step in your Step Function to trigger a Lambda function or an AWS Glue job that executes the COPY command to load data from S3 into Redshift Serverless.
This workflow can be adjusted based on your specific requirements
If this has answered your question or was helpful, accepting the answer would be greatly appreciated. Thank you!
Conteúdo relevante
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 6 meses
- AWS OFICIALAtualizada há 2 anos