cloudformation-coverage-roadmap icon indicating copy to clipboard operation
cloudformation-coverage-roadmap copied to clipboard

AWS::LakeFormation::PrincipalPermissions DataCellsFilterResource missing properties

Open Sevi7 opened this issue 2 years ago • 0 comments

Name of the resource

Other

Resource Name

AWS::LakeFormation::PrincipalPermissions

Issue Description

DataCellsFilterResource struct in CloudFormation has the following properties:

{
  "DatabaseName" : String,
  "Name" : String,
  "TableCatalogId" : String,
  "TableName" : String
}

The issue is that there is no property to specify a row filter expression. I think there should be a property that recognizes this format: PartiQL support in row filter expressions.

Also ColumnNames and ColumnWildcard properties from TableWithColumnsResource are missing because cell filtering is when you include or exclude specific columns and also provide a row filter expression. Source: Data filters

Expected Behavior

With these three properties we would be able to establish cell-level security (cell filtering).

Useful documentation about Data filters that states the following:

The level of filtering that you get depends on how you populate the data filter.

  • When you specify the "all columns" wildcard and provide a row filter expression, you are establishing row-level security (row filtering) only.
  • When you include or exclude specific columns and specify "all rows" using the all-rows wildcard, you are establishing column-level security (column filtering) only.
  • When you include or exclude specific columns and also provide a row filter expression, you are establishing cell-level security (cell filtering).

According to the above we could also be missing a RowFilterResource in CloudFormation.

Observed Behavior

Missing properties in DataCellsFilterResource struct.

Test Cases

Test row filtering and cell filtering.

Other Details

No response

Sevi7 avatar Sep 01 '22 16:09 Sevi7