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

• Intended audience
• 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