Data-level permissions using Posit Connect (with Databricks, Snowflake, OAuth)

Should one viewer of your app be able to see more (or different) data than another? Maybe colleagues in California should only see data relevant to them? Or managers should only have access to their own employee data?

The Connect team joined us for a demo on inheriting data-level permissions using Posit Connect and Databricks Unity Catalog. While this workflow uses Databricks to illustrate federated data access controls, this same methodology can also be applied to Snowflake or any external data source that supports OAuth.

During this workflow demo, you will learn:

  1. How to define row-level access controls in Databricks Unity Catalog
  2. How to create a Databricks OAuth integration in Posit Connect
  3. How to write interactive applications that utilize the viewer’s Databricks credentials when reading data from Databricks Unity Catalog, providing the viewer with a personalized experience depending on their level of data access
  4. How to deploy this application to Posit Connect and share it within your organization

To enable OAuth integrations, your team will need to upgrade to Posit Connect 2024.08.0. This feature is available in Enhanced and Advanced product tiers. 

If you’d like to talk further with our team 1:1 about doing this, you can find a time to chat here.

Helpful resources for this workflow:

  1. Full examples to get you started: https://github.com/posit-dev/posit-sdk-py/tree/main/examples/connect
  2. Admins will likely be most interested in starting here: https://docs.posit.co/connect/admin/integrations/oauth-integrations/databricks/
  3. End users will be most interested here: https://docs.posit.co/connect/user/oauth-integrations/
  4. Q&A Link: https://youtube.com/live/TZQY6rm6hU4?feature=share

Additional resources shared:

  1. Release Blurb: https://docs.posit.co/connect/news/#posit-connect-2024.08.0
  2. Security: https://docs.posit.co/connect/admin/integrations/oauth-integrations/security.html
  3. Publishing Quarto: https://docs.posit.co/connect/how-to/basic/publish-databricks-quarto-notebook/
  4. sparklyr: https://github.com/sparklyr/sparklyr?tab=readme-ov-file#connecting-through-databricks-connect-v2
  5. odbc: https://github.com/r-dbi/odbc?tab=readme-ov-file#odbc-

We host these Workflow Demos the last Wednesday of every month, and you can add them to your calendar here. 

 

Subscribe to more inspiring open-source data science content.

We love to celebrate and help people do great data science. By subscribing, you'll get alerted whenever we publish something new.

Subscribe now