cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Control visibility of delta tables at sql endpoint

athjain
New Contributor III

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Hubert-Dudek
Esteemed Contributor III
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)

View solution in original post

5 REPLIES 5

-werners-
Esteemed Contributor III

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
New Contributor III

@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
Esteemed Contributor III
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
Contributor III

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
Not applicable

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!

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group