Recap of Amazon Redshift Sessions from AWS re:Invent 2023
Amazon Redshift empowers data-driven decision-making for countless customers daily with its fully managed, AI-enhanced cloud data warehouse, offering optimal price-performance for analytics workloads. Customers rely on Amazon Redshift as a crucial element in their data architecture, facilitating a range of use cases from standard dashboarding to self-service analytics, real-time analytics, and machine learning.
For further insights, you can check out this related blog post that dives deeper into the topic.
Creating Effective ETL Pipelines with AWS Step Functions
by Lisa Williams, Mark Thompson, and Emily Clark
on 18 DEC 2023
in Advanced (300), Amazon RDS, AWS Glue, AWS Step Functions, Technical How-to
AWS Step Functions is a fully managed visual workflow service that allows you to construct intricate data processing pipelines utilizing a variety of extract, transform, and load (ETL) technologies like AWS Glue, Amazon EMR, and Amazon Redshift. You can visually design the workflow by connecting individual data pipeline tasks and configuring payloads, retries, and more.
This excellent resource can provide additional guidance on building effective ETL strategies.
Automatically Identify Personally Identifiable Information in Amazon Redshift Using AWS Glue
by Sam Roberts, Nina Patel, and Jacob Lee
on 15 DEC 2023
in Amazon Redshift, AWS Glue, Intermediate (200), Technical How-to
With the rapid increase of data, companies are managing vast amounts of diverse information, including personally identifiable information (PII). PII refers to details that can identify, contact, or locate an individual. The challenge of identifying and safeguarding sensitive data at scale has become more complex, costly, and time-consuming. Organizations are tasked with implementing robust strategies to protect this information.
For more on data protection, check out the insights from this authority on the topic.
Breaking Down Data Silos and Streaming CDC Data with Amazon Redshift and Amazon MSK
by Chris Nguyen and Sarah Brown
on 13 DEC 2023
in Amazon Managed Streaming for Apache Kafka (Amazon MSK), Amazon Redshift, Customer Solutions, Technical How-to
Data loses its value over time. Our customers express a desire to analyze business transactions in real-time. Traditionally, batch-based methods were employed for data transfer from operational systems to analytical environments. However, these approaches can introduce latency, hindering timely insights.
Federating IAM-Based Single Sign-On to Amazon Redshift Role-Based Access Control with Okta
by David Smith, Priya Singh, and Zoe White
on 12 DEC 2023
in Amazon Redshift, Analytics, Foundational (100)
Amazon Redshift speeds up your time to insights with efficient, secure cloud data warehousing at scale. Thousands of customers trust Amazon Redshift to analyze vast data sets and execute complex queries. Utilize your preferred SQL clients to seamlessly analyze data within an Amazon Redshift warehouse.
Orchestrating Amazon EMR Serverless Spark Jobs with Amazon MWAA and Data Validation Using Amazon Athena
by Kevin Adams and Rachel Green
on 12 DEC 2023
in Amazon Athena, Amazon EMR, Amazon Managed Workflows for Apache Airflow (Amazon MWAA)
As data engineering complexities rise, organizations are seeking innovative ways to optimize their data processing workflows. Many current data engineers employ Apache Airflow to create, schedule, and oversee their data pipelines. However, managing and scaling these pipelines can become an overwhelming task as data volumes increase.
How FanDuel Transitioned to a Modern Amazon Redshift Architecture for Essential Business Workloads
by Sarah Johnson, Michael Brown, Anika Patel, and Jason Lee
on 08 DEC 2023
in Amazon Redshift, Analytics, Customer Solutions, Serverless
This post is co-authored with Sarah Johnson and Michael Brown from FanDuel. We discuss how FanDuel transitioned from a DC2 nodes architecture to a state-of-the-art Amazon Redshift architecture, which includes Redshift provisioned clusters utilizing RA3 instances, Amazon Redshift data sharing, and Amazon Redshift Serverless.
AWS Clean Rooms Proof of Concept Scoping Part 1: Media Measurement
by Laura King, Emma Wright, and Ryan Davis
on 07 DEC 2023
in AWS Clean Rooms, Best Practices, Intermediate (200)
In this article, we describe the planning of a proof of concept to evaluate media effectiveness in a paid advertising campaign. The collaborators consist of a media owner (“CTV.Co,” a connected TV provider) and a brand advertiser (“Coffee.Co,” a quick-service restaurant), working together to analyze their shared data and assess the impact on sales from the advertising efforts.
Utilizing Amazon Redshift Spatial Analytics on Amazon Redshift Serverless to Measure Digital Equity in US States
by Priya Sharma, Nathan Lee, and Samantha Brown
on 05 DEC 2023
in Amazon Redshift, Amazon Simple Storage Service (S3), AWS Glue, Customer Solutions, Technical How-to
In our increasingly digital age, affordable access to high-speed broadband is essential for full participation in society. Unfortunately, millions of American households remain without reliable internet access, which poses significant challenges for equity in the digital landscape.
Amazon IXD – VGT2
6401 E Howdy Wells Ave,
Las Vegas, NV 89115
Leave a Reply