Control visibility of delta tables at sql endpoint

[athjain]

Hi Community,

Let's take a scenario where the data from s3 is read to create delta table and then stored on dbfs, and then to query these delta table we used mysql endpoint from where all the delta tables are visible, but we need to control which all delta tables can be visible through that endpoint.

[-werners-]

Best you browse through the docs.

Interesting to know is that with Unity Catalog, new functionalities will be added. Mind that it is not yet GA.

[athjain]

@Werner Stinckens​ 

Thanks for your kind response, Surely I will go through the above said suggestion and will contact team to make it available for testing and will let you know if it can fulfill above said usecase

[Hubert-Dudek · Accepted solution]

GRANT privilege_types ON securable_object TO principal
 
privilege_types
  { ALL PRIVILEGES |
    privilege_type [, ...] }

REVOKE privilege_types ON securable_object FROM principal
 
privilege_types
  { ALL PRIVILEGES |
    privilege_type [, ...] }

principal need to be user which connect through sql endpoint (from BI tool for example)

[User16753725182]

Hi @Athlestan Jain​ , Let us know if you were able to achieve this using @Hubert Dudek​ solution.

You can also restrict the endpoint by using Access control along with a combination of the proposed solution.

[Anonymous]

Hey @Athlestan Jain​ 

Just checking in. Do you think you were able to find a solution to your problem from the above answers?  If yes, would you be happy to mark it as best so that other members can find the solution more quickly?

Thank you!