Inserting data into Lake Formation governed tables
Governed tables are packed with a lot of features such as ACID transactions, automatic data compaction for faster query response times, and time travel queries. Now we will go through the process of creating Lake Formation governed tables using Glue jobs:
- Go to the Outputs tab of the CloudFormation stack and grab the S3 path for the
LakeFormationLocationForRegistry
key. - Go to AWS Lake Formation (https://console.aws.amazon.com/lakeformation/home) and register the S3 location, from step 1, with Lake Formation, as shown in the following screenshot:
Figure 13.24 – Registering the location
The format of this path is s3://<target_s3_bucket>/employees_governed_table/
. Make sure that you register it in the same region where you created the Cloud Formation stack.
Note that you should use the AWSServiceRoleForLakeFormationDataAccess
role. This role has been granted access to the KMS key...