Enrich your customer data with geospatial insights using Amazon Redshift, AWS Data Exchange, and Amazon QuickSight
Big Data Blog
This article demonstrates how to enrich customer address data with demographic details from the U.S. Census Bureau dataset using Amazon Redshift, AWS Data Exchange, Amazon Location Service, and Amazon QuickSight.
Specifically, the article covers:
- Setting up an Amazon Redshift Serverless endpoint and loading customer data
- Setting up a place index in Amazon Location Service
- Writing an AWS Lambda user-defined function to call Location Service from Amazon Redshift
- Subscribing to census data on AWS Data Exchange
- Using geospatial queries to tag addresses to census blocks
- Creating a new customer dataset in Amazon Redshift
- Visualizing the enriched customer data in Amazon QuickSight
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
May 16
2024
2024
Breaking barriers in geospatial: Amazon Redshift, CARTO, and H3
Jul 10
2025
2025
Geospatial data lakes with Amazon Redshift
Dec 8
2025
2025
Announcing Spatial Data Management on AWS to accelerate spatial-data insights
Jun 19
2025
2025
Build a multi-Region analytics solution with Amazon Redshift, Amazon S3, and Amazon QuickSight
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.