Stitch ETL - A Simple, extensible ETL built for data teams

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

4.44 (8 reviews)
Udemy
platform
English
language
Other
category
instructor
42
students
1 hour
content
Jan 2022
last update
$49.99
regular price

What you will learn

Stitch ETL from scratch

Data Migration

Data Replication

Streaming Data Pipeline

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 teams


This 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 target


It enables to,

• Extract data from various sources

• Load into the leading cloud data platforms

• Analyze the data with the leading BI tools


Replication

Stitch’s replication process consists of three distinct phases:

  1. Extract: Stitch pulls data from your data sources and persists it to Stitch’s data pipeline through the Import API.

  2. Prepare: Data is lightly transformed to ensure compatibility with the destination.

  3. 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

• Snowflake


This course is for,

• ETL Developers

• Data Engineers

• Data Architects

• Data Migration Specialists

• Data Integration Specialists

Content

Introduction

About the Course
Introduction

Signing Up

Sign Up

Integration

AWS S3 Integration
PostgreSql Integration

Destination

Snowflake Destination
AWS S3 Destination
PostgreSql Destination

Replication

AWS S3 to Snowflake
AWS S3 to AWS S3

Screenshots

Stitch ETL - A Simple, extensible ETL built for data teams - Screenshot_01Stitch ETL - A Simple, extensible ETL built for data teams - Screenshot_02Stitch ETL - A Simple, extensible ETL built for data teams - Screenshot_03Stitch ETL - A Simple, extensible ETL built for data teams - Screenshot_04

Charts

Price

Stitch ETL - A Simple, extensible ETL built for data teams - Price chart

Rating

Stitch ETL - A Simple, extensible ETL built for data teams - Ratings chart

Enrollment distribution

Stitch ETL - A Simple, extensible ETL built for data teams - Distribution chart

Related Topics

4505430
udemy ID
1/20/2022
course created date
5/8/2022
course indexed date
Bot
course submited by