- 新しい順
- 投票が多い順
- コメントが多い順
This error states that the database has "Use only IAM access control for new tables in this database" enabled. Having this setting enabled, it grants permission to 'IAM_ALLOWED_PRINCIPALS' for any new tables created in the database. Permission granted to 'IAM_ALLOWED_PRINCIPALS' means it uses only IAM permissions (and not LF) to determine access to the resource. When this setting is disabled, this permission is not added and therefore access to the table is determined by both IAM and LF.
For data catalog views to work this setting must be disabled (so that access is determined by LF permissions) and underlying tables referred in view must be registered in lakeformation.
This setting can be found under database in lakeformation.
On lakeformation console navigate to Databases > Select the database > Edit > uncheck 'Use only IAM access control for new tables in this database'.