Intro­duc­tion to Cloud Data Ware­housing: Focus on Snow­flake vs. Redshift



Intro­duc­tion to Cloud Data Ware­housing: Focus on Snow­flake vs. Redshift


This webinar provides the par­ti­cipant with a brief insight into data ware­housing strategies within the AWS Cloud.



Descrip­tion


Spe­cial focus is placed on the Snow­flake Cloud Data Ware­house and AWS-nat­ive solu­tions based on Red­shift in com­bin­a­tion with other AWS ser­vices (e.g. Lambda, Glue, EMR, Lake Form­a­tion). Com­mon cloud data ware­house archi­tec­tures using Red­shift and Snow­flake are examined in more detail in order to define rough guidelines for use cases for these two data ware­house solutions.


Share post





Register


Date: 05/02/2025 05/02/2025


Time: 11:00


Location: online


Price: free

Register

Experts



Niels Warnecke


Senior Lead Consultant

Agenda


Intro­duc­tion

  • Tra­di­tion­elles vs. Cloud Data Ware­housing (Shared Disk und Shared Noth­ing Architek­turen, Vorteile Cloud Computing)
  • Haup­tak­teure Cloud Data Ware­housing (AWS Red­shift, Azure Syn­apse Ana­lyt­ics, Google Big Query, Snowflake)
Data Stor­age

  • Hot / Cold Stor­age (AWS S3, AWS Gla­cier, Snow­flake Stages)
  • Semi-Struc­tured Data (Snow­flake Vari­ant Datentyp)
Data Trans­form­a­tion

  • Per­form­ance classes (AWS Lambda, AWS EMR, AWS Glue, Snow­flake procedures)
  • Pro­cess auto­ma­tion, orches­tra­tion, and mon­it­or­ing (AWS Lambda, AWS Step­Func­tions, AWS Cloud­Watch, Snow­flake streams, tasks, and procedures)
Data Ana­lysis

  • Integ­ra­tion Cold Data (AWS Red­shift Spec­trum, AWS Athena, Snow­flake External Tables)
  • BI-Ana­lyse (3rd Party Tools)


Basic inform­a­tion


Pre­requis­ites

Basic know­ledge of cloud mech­an­isms and Snow­flake would be an advantage.

Method

Online-Webinar

Tar­get audience

This webinar is aimed at IT pro­ject man­agers and engin­eers who are inter­ested in Snow­flake or Red­shift as a platform.

Languages

Ger­man


Upcoming webinars and workshops


top