Are you able to hide tables in a database using Lake Formation Tagging

0

Hi,

I have a database with around 40 tables. However, some end users don't need to see all tables in the database. I'm using Lake Formation Tagging and know that if a tag is added to the database that the tag is then inherited by all the tables. I also found by going into the table that the inherited tags can't be removed.

I tried adding a tag to just the table level and granting permissions but the database won't appear as the tag is only at the table level.

Is there a way to hide certain tables in a database by using Lake Formation Tagging?

asked 2 years ago559 views
1 Answer
0

You can't hide the table, however you can restrict access to table within database using lake formation tag based access control. In simplest terms follow below steps -

  1. Define Tag at Database level
  2. Define Tag at Table Level
  3. Grant LF-tag permisions to specific IAM role/principal by using tags defined at database level and table level.

More details - https://docs.aws.amazon.com/lake-formation/latest/dg/granting-cat-perms-TBAC-console.html

AWS
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions