A Query Portal for Amazon redshift

Quick functions and common interfaces for SQL Server, Amazon Redshift and SQLite databases

An end-to-end data ingestion pipeline for airline data, utilizing various AWS services to process and store flight information efficiently.

A useful collection of code snippets that I've created and used in my projects.

Building an ETL pipeline for a database hosted on Redshift. Extracting data from S3 to staging tables on Redshift . Transforming data by executing SQL statements that create the analytics tables from these staging tables by start schema. Loading star schema tables to Redshift

This Airflow DAG automates the process of extracting data from an Amazon Redshift database and unloading it to Amazon S3 in Parquet format. It runs daily, exporting data from the previous day based on a specified query.

This contains all the projects from Udacity Nanodegree

Docker image for Amazon Redshift RSQL

Redshift sink for Apache Beam

Simplified blueprints for building data pipelines with Amazon Redshift.

Udacity Data Engineering Capstone project

A lightweight tool based on sweetviz that generates high-density visualizations to kickstart Exploratory Data Analysis within Amazon Redshift using pyodbc with just one line of code.

Simulation of business requests and problem-solving using AWS S3, Redshift, and relational database for Northwind. Includes reports and analyses.

Canalización desde MongoDB hacia un Data Lake de Amazon S3, creación de Data Warehouse en Amazon Redshift y visualización en Tableau.

Creating a Data Warehouse in AWS Cloud with all infrastructure created by code (IaC) through Terraform

Full code for UDACITY's Data Engineer Nano Degree project. Build a Data Warehouse in AWS with Amazon Redshift.

Building Data Pipelines for a data warehouse with Airflow and AWS

ETL Pipeline for Spar Nord Bank for the analysis of refilling frequency of the ATM's all over the europe