PinnedSagadevan KWays to load data from source to targetIn an ETL process, there are multiple ways to load data from a source system to a target system. Let’s have a look at some of them.7 min read·Mar 21, 2023--2--2
PinnedSagadevan KTest AWS Glue jobs locally using Docker and motoWe’ll find out how to run tests locally for an AWS Glue job which reads data from a Postgres instance and writes to S3 using Docker and…6 min read·Jan 8, 2023----
Sagadevan KinAWS in Plain EnglishETL: MS SQL Server to Redshift via S3 using Pandas and PyArrowIn this article, we’ll see how we can load data from an MS SQL Server instance to a Redshift cluster using pandas, pyarrow and pg8000. Code…5 min read·Jun 11, 2023--3--3
Sagadevan KDimensional Modeling for a Data WarehouseWhat is dimensional modeling?3 min read·Jun 6, 2022----
Sagadevan KSQL Views SimplifiedWe’ll try to cover SQL Views in this article5 min read·Mar 29, 2022----
Sagadevan KConnecting to Cloud SQL with Cloud Functions using CLIConnect to Cloud SQL instance with Cloud Function using Cloud Shell(only) from scratch.4 min read·Aug 14, 2021----