Tutorial: Creating a Data Lake from a JDBC Source in Lake Formation
This tutorial guides you through the steps to take on the AWS Lake Formation console to create and load your first data lake from a JDBC source using Lake Formation.
Topics
- About the Personas in This Tutorial
- JDBC Tutorial Prerequisites
- Step 1: Create the IAM User to Be the Data Analyst
- Step 2: Create a Connection in AWS Glue
- Step 3: Create an Amazon S3 Bucket for the Data Lake
- Step 4: Register an Amazon S3 Path
- Step 5: Grant Data Location Permissions
- Step 6: Create a Database in the Data Catalog
- Step 7: Grant Data Permissions
- Step 8: Use a Blueprint to Create a Workflow
- Step 9: Run the Workflow
- Step 10: Grant SELECT on the Tables
- Step 11: Query the Data Lake Using Amazon Athena
- Step 12: Query the Data in the Data Lake Using Amazon Redshift Spectrum
- Step 13: Grant or Revoke Lake Formation Permissions Using Amazon Redshift Spectrum