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

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

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