{"page":"\n\n
\n
\n
\n
\n
\n\nVideo\n
\n

\nAWS Certified Data Analytics Specialty 2021 – Hands-On - Redshift Sort Keys\n

\n
\n
\nGet Free Access for 10 Days!\n
\n
\n
\n
\n
\n
×
\n\n\n
\n\nPublisher:\n\nCurated Video\n\n\n
\n
\nThis video explains how to select the Amazon Redshift sort keys. This clip is from the chapter \"Domain 4: Analysis\" of the series \"AWS Certified Data Analytics Specialty (2022) Hands-on\".In this section, you will learn how to build a...\nThis video explains how to select the Amazon Redshift sort keys.

This clip is from the chapter \"Domain 4: Analysis\" of the series \"AWS Certified Data Analytics Specialty (2022) Hands-on\".In this section, you will learn how to build a more complex application that monitors our incoming order data using Kinesis Analytics. If an anomalous order rate is detected, an alarm will be sent using a text message to your cell phone using Lambda and SNS. In this hands-on activity, you will spin up an Amazon Elasticsearch cluster and configure Kinesis Firehose to dump Apache web server logs into it for querying and visualization with Kibana. You will also learn to use a Glue crawler to set up a Glue Data CatLog for the Amazon S3 order data and then query it directly using Amazon Athena. Finally, you will learn about the Redshift cluster and how to use AWS Glue to provide a schema to query the Amazon S3 order data via Redshift Spectrum.\n
\n
\n\n
\n
\n
\n
\n

Resource Details

\n
\n
\n
\n
Curator Rating
\n
\n
\n
\n
\n
\n
Educator Rating
Not yet Rated
\n
\n
\n
\n
\n
Media Length
\n
3:09
\n
\n
\n
\n
\n
Grade
Higher Ed
\n
\n
\n
\n
\n
Subjects
STEM
3 more...
\n
\n
\n
\n
\n
Media Type
Instructional Videos
\n
\n
\n
\n
\n
Source:
\n
\nPackt - Cloud & Networking\n\n
\n
\n
\n
\n
\n
Date
\n
2023
\n
\n
\n
\n
\n\n
Language
English
\n
\n
\n
\n
\n
Audiences
For Teacher Use
2 more...
\n
\n
\n
\n
\n
Usage Permissions
Fine Print: Educational Use
\n
\n
\n
\n
\n
\n

Additional Materials

\n
\n\nSign in or Join Now
\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" href=\"/subscription/new\">Video Transcript\n
\n
\n\nSign in or Join Now
\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" href=\"/subscription/new\">Video Preview\n
\n
\n
\n

Concepts

\n
\n
data, sorting
\n
\n\n\n
\n
\n
\n
\n

Additional Tags

\n
\n
aws certified data analytics - specialty exam, aws das-c01, kinesis, emr, dynamodb, redshift, data analytics, data visualization, data processing, security, sort key, improve compression, interleaved sort, primary column, single column, sort, single, query, column, queries, table, blocks, skip, frequently, sorted, listed, compound, columns, stored, order, minimum, block, important, choose, enable, choice, date
\n
\n\n\n
\n
\n
\n
\n

Classroom Considerations

\n
Best For: Explaining a topic
Video is ad-free
\n
\n
\n

Educator Ratings

\n
\n
\n
\n
\n
\n\nShow resource details\n
\n
\n\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" aria-label=\"Play video: AWS Certified Data Analytics Specialty 2021 – Hands-On - Redshift Sort Keys\" href=\"/subscription/new\">\"AWS\n\n
\n
\n
\n\n\n\n"}