From the course: Data Engineering Project: Build Streaming Ingestion Pipelines for Snowflake with AWS
Unlock the full course today
Join today to access over 24,900 courses taught by industry experts.
Setting up your MSK cluster and EC2 instance
From the course: Data Engineering Project: Build Streaming Ingestion Pipelines for Snowflake with AWS
Setting up your MSK cluster and EC2 instance
- [Instructor] We'll start setting up our pipeline by building our MSK cluster and EC2 instance. The EC2 instance will serve as the data producer that sends messages to MSK. It will also host the Snowpipe Streaming via Kafka Connect. Before proceeding, pause this video here and refer to the handout for a link to a handy CloudFormation template provided by Snowflake. Click that link, but come back to this video before proceeding to kick off the build. We'll be operating out of the US-West-2 region. The CloudFormation template is set up to build in that region as well. Let's click on the View in Designer button to understand what this template will be setting up for us. We can break this JSON code down into sections. Firstly, we are setting up parameters to be referenced in the build of the EC2 instance and MSK cluster. For the MSK cluster, we are defining the subnet associations and the security group associations to ensure…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Setting up your MSK cluster and EC2 instance3m 52s
-
(Locked)
Setting up your keys5m 8s
-
(Locked)
What is Snowpipe?1m 42s
-
(Locked)
Installing Snowpipe Kafka connector3m 26s
-
(Locked)
Set up config for provider-MSK connection and create topic6m 35s
-
(Locked)
Preparing your Snowflake environment6m 23s
-
(Locked)
Setting up your Snowpipe Kafka connect config4m 29s
-
(Locked)
Sending data to Snowflake3m 25s
-
(Locked)
Final considerations2m 8s
-
(Locked)
-