|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/stitch-etl/
课程评论：没有评论
课程名称：Stitch ETL - 为数据团队构建的简单、可扩展的ETL 课程概述： 本课程围绕Stitch展开，这是一个由Talend拥有的产品。Stitch是一个以云为中心的开源平台，旨在快速移动数据。这是一项简单而强大的ETL服务，可以连接多种数据源并将数据复制到目标位置。 课程内容包括： - Stitch的介绍 - 如何注册Stitch - 创建AWS S3和AWS RDS PostgreSql的数据源 - 创建Snowflake、AWS S3和AWS RDS PostgreSql的数据目标 - 从源到目标的数据复制 使用Stitch，用户可以： - 从多种源提取数据 - 加载数据到领先的云数据平台 - 使用领先的商业智能工具分析数据 数据复制的过程包括三个主要阶段： 1. 提取：Stitch从数据源中提取数据，并通过导入API将其存储到Stitch的数据管道中。 2. 准备：对数据进行轻微转换，以确保与目标的兼容性。 3. 加载：Stitch将数据加载到目标位置。 这些阶段的单次执行称为复制作业，用户可以在任何集成的摘要页面上监控复制作业的进度。 Stitch与多种目标系统集成，包括： - Amazon Redshift - AWS S3 - Databricks上的Delta Lake - Google BigQuery - Microsoft Azure Synapse Analytics - Microsoft SQL Server - Panoply - PostgreSQL - Snowflake 本课程适合以下人群： - ETL开发人员 - 数据工程师 - 数据架构师 - 数据迁移专家 - 数据集成专家 通过本课程，学员将掌握使用Stitch进行数据提取、加载与分析的技能，为数据团队的工作提供支持。
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
