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: 

Load data into Azure SQL Database from Azure Databricks ( restricted table not a whole workspace tables)

Dayaa
New Contributor II

Hi ,

I want to share limited tables in my databricks workspace and users will connect to my databricks through Azure Data factory and will load data into Azure SQL. Is this possible using Delta Sharing? Or any other method or tool?

1 ACCEPTED SOLUTION

Accepted Solutions

Rishabh264
Honored Contributor II

Hey @Dayananthan Marimuthu​ , they can access tables by creating delta connector Linked service from ​azure data factory , you can use the particular schema with limited tables , and you can use the query for accessing them . But my point is what exactly you want to convey that you have one schema and inside that suppose you have 6 tables and you want to give the access of 4 tables ...is this ?? You want to convey or anything else

Rishabh Pandey

View solution in original post

3 REPLIES 3

Rishabh264
Honored Contributor II

Hey @Dayananthan Marimuthu​ , they can access tables by creating delta connector Linked service from ​azure data factory , you can use the particular schema with limited tables , and you can use the query for accessing them . But my point is what exactly you want to convey that you have one schema and inside that suppose you have 6 tables and you want to give the access of 4 tables ...is this ?? You want to convey or anything else

Rishabh Pandey

Dayaa
New Contributor II

Thanks Rishab. Yes correct they need to access only 4 tables instead of 6 tables.

Anonymous
Not applicable

Hi @Dayananthan Marimuthu​ 

Thank you for your question! To assist you better, please take a moment to review the answer and let me know if it best fits your needs.

Please help us select the best solution by clicking on "Select As Best" if it does.

Your feedback will help us ensure that we are providing the best possible service to you.

Thank you!

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!