Reference https://docs.aws.amazon.com/datapipeline/latest/DeveloperGuide/dp-how-pipeline-definition.html
AWS data pipeline definition:
Names, locations, and formats of your data sources
Activities that transform the data
The schedule for those activities
Resources that run your activities and preconditions
Preconditions that must be satisfied before the activities can be scheduled
Ways to alert you with status updates as pipeline execution proceeds
Comparison between Database and Data warehouse
reference website:
https://panoply.io/data-warehouse-guide/the-difference-between-a-database-and-a-data-warehouse/#:~:text=A%20data%20warehouse%20is%20a,used%20to%20make%20business%20decisions.
Database transactions usually are executed in an ACID (Atomic, Consistent, Isolated, and Durable) compliant manner
Sample Solution
