Creating a data lake from a JDBC source in Lake Formation
This tutorial guides you through the steps to take on the Amazon 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 a data analyst user
- Step 2: Create a connection in Amazon 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