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