A SQL transformation must run inside Redshift. What can you use?
Why A is the answer
Stored procedures
Redshift supports stored procedures for in-warehouse transformation.
In detail
- Stored procedures run SQL logic inside Redshift.
- Keeps logic close to the data.
Use case
An illustrative scenario, not a real incident.
A daily summary is built with stored procedures, so the data stays in Redshift and no external tool is needed.
See it in different ways
mindmap
root((Transform))
Glue
Serverless Spark
Job bookmarks
EMR
Custom tuning
Lambda
Small files
DataBrew
No code
Redshift
Stored proceduresflowchart LR S0["Raw table"] --> S1["Stored procedure"] --> S2["Summary table"]
Key point: Stored procedures transform in Redshift.
Why the other options are wrong
- B. AWS Lambda at the edge
- Edge functions run at CloudFront.
- C. Amazon Kinesis Data Analytics
- That service works on streams.
- D. Amazon SNS subscriptions
- SNS sends messages.