Stitch Etl - A Simple, Extensible Etl Built For Data Teams

Learn Stitch ETL, migrating data between Snowflake, AWS S3 and AWS PostgreSql

What you'll learn

Stitch ETL from scratch

Data Migration

Data Replication

Streaming Data Pipeline

Requirements

No programming experience required. Basic understanding of ETL/ELT and Cloud Architecture is an advantage, but not mandatory

Description

The course is about Stitch, a product owned by Talend.What is Stitch?Stitch is a cloud-first, open source platform for rapidly moving data. A simple, powerful ETL service, Stitch connects to various data sources and replicates that data to a destination.• Stitch helps you replicate data into cloud data warehouses• Stitch rapidly moves data from 130+ sources into a cloud data warehouse with no coding• Stitch is Simple, extensible ETL built for data teamsThis course starts with,• Introduction of Stitch• Signing up with Stitch• Creating sources of AWS S3, AWS RDS PostgreSql• Creating the targets of Snowflake, AWS S3 and AWS RDS PostgreSql• Replicate the data from source to targetIt enables to,• Extract data from various sources• Load into the leading cloud data platforms• Analyze the data with the leading BI toolsReplicationStitch’s replication process consists of three distinct phases:Extract: Stitch pulls data from your data sources and persists it to Stitch’s data pipeline through the Import API.Prepare: Data is lightly transformed to ensure compatibility with the destination.Load: Stitch loads the data into your destination.A single occurrence of these three phases is called a replication job. You can keep an eye on a replication job’s progress on any integration’s Summary page.Stitch integrated with the target systems such as,• Amazon Redshift• AWS S3• Delta Lake on Databricks• Google BigQuery• Microsoft Azure Synapse Analytics• Microsoft SQL Server• Panoply• PostgreSQL• SnowflakeThis course is for,• ETL Developers• Data Engineers• Data Architects• Data Migration Specialists• Data Integration Specialists

Overview

Section 1: Introduction

Lecture 1 About the Course

Lecture 2 Introduction

Section 2: Signing Up

Lecture 3 Sign Up

Section 3: Integration

Lecture 4 AWS S3 Integration

Lecture 5 PostgreSql Integration

Section 4: Destination

Lecture 6 Snowflake Destination

Lecture 7 AWS S3 Destination

Lecture 8 PostgreSql Destination

Section 5: Replication

Lecture 9 AWS S3 to Snowflake

Lecture 10 AWS S3 to AWS S3

ETL Developers,Data Migration specialists,Data Engineers,Data Architects,Database Administrators