topic Re: Control visibility of delta tables at sql endpoint in Data Engineering

Control visibility of delta tables at sql endpoint

athjain — Mon, 07 Mar 2022 08:24:37 GMT

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.

Re: Control visibility of delta tables at sql endpoint

-werners- — Mon, 07 Mar 2022 09:01:07 GMT

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.

Re: Control visibility of delta tables at sql endpoint

athjain — Mon, 07 Mar 2022 09:08:05 GMT

@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

Re: Control visibility of delta tables at sql endpoint

Hubert-Dudek — Mon, 07 Mar 2022 10:31:08 GMT

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)

Re: Control visibility of delta tables at sql endpoint

User16753725182 — Fri, 11 Mar 2022 08:36:33 GMT

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.

Re: Control visibility of delta tables at sql endpoint

Anonymous — Fri, 22 Apr 2022 14:04:16 GMT

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!