From the course: Amazon Web Services: Data Analytics
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Query Redshift for RDBMS - Amazon Web Services (AWS) Tutorial
From the course: Amazon Web Services: Data Analytics
Query Redshift for RDBMS
- [Narrator] Next up we're going to work with Redshift which is the managed due to warehouse so we're going to work with our Redshift client. We're going to make sure that it connects properly then we're going to run a script to create and load a database and write and execute ANSI SQL queries that are designed for data warehousing type workloads. And the underlying database that we're using here is modeled in a star schemer, so a center fact table with outside dimension tables and this is structurally what is recommended for Redshift. Please consult the documentation when you're working with Redshift. It really matters how you set up the structure of the underlying database. SO here's our cluster and you can see that it's healthy and available and if I click into it here's the end point. And you can see that this tells us about our security connectivity. It's really important that you set up the appropriate security group roles because even if you set Redshift to be available…
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
-
-
-
-
Setup for AWS analytics7m 29s
-
(Locked)
Query Athena using SQL query on S35m 44s
-
(Locked)
Query DynamoDB for NoSQL7m 19s
-
(Locked)
Set up Kinesis for input streams9m 17s
-
(Locked)
Query Kinesis Analytics8m 38s
-
(Locked)
Query CloudSearch and Elasticsearch5m 17s
-
(Locked)
Query AWS IoT7m 27s
-
(Locked)
Set up EMR, RDS, and Redshift3m 49s
-
(Locked)
Query RDS with ANSI SQL3m 38s
-
(Locked)
Query Redshift for RDBMS8m 36s
-
(Locked)
Query Redshift Spectrum2m 25s
-
(Locked)
Query EMR with Apache Spark5m 5s
-
-
-
-