Abstract Modern ETL tools should be capable of extracting data from different sources like RDBMS, Flat files, Cloud Data-Stores, Data Lakes, Warehouses etc. and should smoothly build integration between them. Data transformations or pre-processing tasks have become complex because of variety of data often in semi-structured or un-structured form. Data pre-processing tasks are now preparing […]
Alteryx : A Brief Introduction Read More »
Introduction In this topic we are using AWS resources to ingest and visualize NYC taxi sample data. This lab guides you in the process of creating AWS Lambda trigger and use of data wrangler for ingest data. As you walk through the topic you will gradually get introduced to Amazon Redshift, AWS Data wrangler, AWS
Incremental Load to Redshift using AWS Lambda Read More »
Introduction: Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is easy to use. Simply point to your data in Amazon S3, define the schema, and start querying using standard SQL. Most results are delivered within seconds. With Athena, there’s no need for
Optimize Amazon Athena Queries Read More »
