Topic lessonTopic: AWS data pipelines and SQL Server integration
Lake Formation access paths across the Data Catalog, S3 and audit
Visibility of metadata does not establish read access to SQL Server detail. Test the reporting and detail roles across both integrated and direct access paths.
Test the reporting and detail roles across both integrated and direct access paths.
This exercise uses fictional evidence and makes no changes in a live environment.
Compare two ways of reaching the same object
Integrated access to a registered S3 location requires the relevant data grant and IAM permission. Direct S3 API access is a separate control path.
- Actor → CatalogPick the resource
- Catalog → DataInspect data grants
- Data → VerifyCompare both paths
- Actor
- Summary or detail reader
- Catalog
- Specific table and action
- Data
- Registered S3 location
- Verify
- Query and direct API
Restrict the summary reader
| Trial | Expected | Evidence |
|---|---|---|
| Athena summary | Allowed | Grant and applicable IAM permissions |
| Athena detail | Denied | Detail table grant absent |
| Direct S3 detail | Denied | Check IAM and bucket policies |
| Audit | Matches all three trials | Compare actor, action and time |
A denied query alone cannot demonstrate that direct object access is denied.
Acceptance checks
Identify the permission type Separate creating metadata at a location, selecting from a table and IAM GetDataAccess.
Exercise the other path Review applicable direct S3 and encryption permissions with the owner.
Reconcile audit evidence Record the test actor, resource, time and result.
Check your decision
Choose an option to see the result and explanation.
Check, then explain in your own words
- Match actors and tables.
- Exercise query and direct access.
- Reconcile the audit entries.
Check your understanding: Does data-location permission for creating a table establish read access?
Check the relevant table data grants and IAM permissions separately.
Permissions for metadata and reading the data serve different purposes.
Sources and conditions checked
The official references used in this lesson are collected here with their scope, conditions and corresponding sections. Independent expert review and live AWS comparison have not been performed.
- Underlying data access controlChecked:
Scope and conditionsRegistered locations, table grants, GetDataAccess and direct S3 access.
Used in this lessonCompare two ways of reaching the same object Restrict the summary reader Acceptance checks