Skip to content
NextLytics
Megamenü_2023_Über-uns

Shaping Business Intelligence

Whether clever add-on products for SAP BI, development of meaningful dashboards or implementation of AI-based applications - we shape the future of Business Intelligence together with you. 

Megamenü_2023_Über-uns_1

About us

As a partner with deep process know-how, knowledge of the latest SAP technologies as well as high social competence and many years of project experience, we shape the future of Business Intelligence in your company too.

Megamenü_2023_Methodik

Our Methodology

The mixture of classic waterfall model and agile methodology guarantees our projects a high level of efficiency and satisfaction on both sides. Learn more about our project approach.

Products
Megamenü_2023_NextTables

NextTables

Edit data in SAP BW out of the box: NextTables makes editing tables easier, faster and more intuitive, whether you use SAP BW on HANA, SAP S/4HANA or SAP BW 4/HANA.

Megamenü_2023_Connector

NextLytics Connectors

The increasing automation of processes requires the connectivity of IT systems. NextLytics Connectors allow you to connect your SAP ecosystem with various open-source technologies.

IT-Services
Megamenü_2023_Data-Science

Data Science & Engineering

Ready for the future? As a strong partner, we will support you in the design, implementation and optimization of your AI application.

Megamenü_2023_Planning

SAP Planning

We design new planning applications using SAP BPC Embedded, IP or SAC Planning which create added value for your company.

Megamenü_2023_Dashboarding

Business Intelligence

We help you with our expertise to create meaningful dashboards based on Tableau, Power BI, SAP Analytics Cloud or SAP Lumira. 

Megamenü_2023_Data-Warehouse-1

SAP Data Warehouse

Are you planning a migration to SAP HANA? We show you the challenges and which advantages a migration provides.

Business Analytics
Megamenü_2023_Procurement

Procurement Analytics

Transparent and valid figures are important, especially in companies with a decentralized structure. SAP Procurement Analytics allows you to evaluate SAP ERP data in SAP BI.

Megamenü_2023_Reporting

SAP HR Reporting & Analytics

With our standard model for reporting from SAP HCM with SAP BW, you accelerate business activities and make data from various systems available centrally and validly.

Megamenü_2023_Dataquality

Data Quality Management

In times of Big Data and IoT, maintaining high data quality is of the utmost importance. With our Data Quality Management (DQM) solution, you always keep the overview.

Career
Megamenü_2023_Karriere-2b

Working at NextLytics

If you would like to work with pleasure and don't want to miss out on your professional and personal development, we are the right choice for you!

Megamenü_2023_Karriere-1

Senior

Time for a change? Take your next professional step and work with us to shape innovation and growth in an exciting business environment!

Megamenü_2023_Karriere-5

Junior

Enough of grey theory - time to get to know the colourful reality! Start your working life with us and enjoy your work with interesting projects.

Megamenü_2023_Karriere-4-1

Students

You don't just want to study theory, but also want to experience it in practice? Check out theory and practice with us and experience where the differences are made.

Megamenü_2023_Karriere-3

Jobs

You can find all open vacancies here. Look around and submit your application - we look forward to it! If there is no matching position, please send us your unsolicited application.

Blog
NextLytics Newsletter
Subscribe for our monthly newsletter:
Sign up for newsletter
 

Databricks Secrets: Secret Scopes vs Azure Key Vault vs Unity Catalog

Working with Databricks you probably know this scenario all too well: A new pipeline needs to talk to SAP and SAP needs a password. Someone on the platform team has to decide where that password lives: a Databricks-backed secret scope, an Azure Key Vault-backed one, or the newer Unity Catalog secret from a release note nobody's gotten around to using yet. Whichever one they pick becomes the pattern the next five pipelines copy, because nobody revisits a decision that already "works."

We've written before about keeping Unity Catalog grants consistent with Terraform and Databricks Bundles, and about using YAML anchors to stop copy-pasting grant blocks across bronze, silver and gold. Secrets sit right next to that governance model and get almost none of the attention, even though every pipeline needs a credential to actually run.

Databricks currently gives you three ways to store one. The third fixes most of what's wrong with the first two, but isn't a drop-in replacement yet.

Read our "Hands-on Databricks" Blog-Series:

1. How to leverage SAP Databricks to integrate ServiceNow Data
2. Data Modeling with dbt on Databricks: A Practical Guide
3. Databricks AutoML for Time-Series: Fast, Reliable Sales Forecasting
4. Advanced Data Warehousing in Databricks with DBT Macros and Snapshots
5. Databricks Secrets: Secret Scopes vs Azure Key Vault vs Unity Catalog

Three Ways to Store a Databricks Secret

A Databricks-backed secret scope stores key-value pairs in an encrypted store Databricks owns and manages: creation, population and permissioning all happen inside Databricks, through the CLI or the Secrets API.

An Azure Key Vault-backed secret scope is a read-only window into an existing Key Vault. Databricks never stores the value, it reads it live from Azure, so rotation, versioning and the secret material itself stay wherever your Key Vault governance already lives.

A Unity Catalog secret is neither: it's a securable object with a three-level name, catalog.schema.secret, governed by ordinary Unity Catalog privileges inherited from catalog and schema the way a table's SELECT grant is. Catalog Explorer gives you a real UI for creating, granting and listing secrets, no CLI required.

The first two scope types are what most estates still run on, and why teams outgrow them.

databricks_three_secret_storage_models

Databricks Classic Scopes: One ACL for the Whole Scope

Both the Databricks-backed and Key Vault-backed scope types share the same underlying limitation: ACLs sit on the scope, not the individual secret inside it. Databricks' own guidance is to align a scope to a role or an application rather than to individuals, one scope per source system, say, so access stays coarse enough to manage. The direct consequence: your scope count now tracks your permission granularity, not your credential count, and a workspace tops out at 1,000 scopes, a soft limit raisable through your account team. Every scope past the first needs its own grants, repeated per environment, each one a separate databricks secrets put-acl my-scope data-engineers WRITE run by hand, no bulk grant, nothing resembling a desired-state file to diff against.

The Key Vault-backed variant adds a governance layer: rotation, versioning and access logging inherit whatever process already governs your other vaults, real upside if that process is solid. But three things still catch teams off guard. Key Vault-backed scopes only support the vault's legacy access-policy model, not Azure RBAC, so if your landing zone standardized on RBAC, most do now, you have to flip the vault backwards before Databricks will touch it. The ACL is still scope-level and a scope maps to an entire vault, so granting a team access grants them every secret in it (the documented workaround is a separate vault per boundary). And creating one means visiting https://<workspace-url>#secrets/createScope, a URL nothing in the UI links to, then hand-copying a DNS name and resource ID out of the Azure portal. Get anything wrong and the error you get back, Authorization_RequestDenied, tells you almost nothing about what to fix.

Reasonable for one team and a handful of admins. It stops holding up once secrets management spans several teams and three environments, because each gap depends on someone remembering it exists.

What Unity Catalog Secrets Actually Fix

Unity Catalog secrets are a different model entirely. Permissions are per-secret, inherited the same way any other Unity Catalog privilege is:

GRANT CREATE SECRET, USE SCHEMA ON SCHEMA main.sap TO `data-engineers`;
GRANT READ SECRET ON SECRET main.sap.bw_password TO `job-runner-sp`;

Catalog Explorer gives you a real UI for this too. Anyone with the right privilege can create a secret, grant or revoke access, and see who has it, no terminal required. Every grant, read and write lands in system.access.audit, queryable like any other system table, the audit trail that classic scopes never had.

It isn't a wholesale replacement yet. It requires Databricks Runtime 17.3 LTS or above on standard-access-mode compute, or serverless environment version 4+. SQL warehouses aren't supported at all, and there's no path for pulling a secret in an init script, so those workloads stay on a classic scope. Quotas are tighter too: 100 secrets per schema, 1,000 per metastore, against the workspace-wide 1,000-scope ceiling on the classic side. The permission story is clearly better; the runtime gate decides whether you can use it yet.


Watch the recording of our webinar "Bridging Business and Analytics: The Plug-and-Play future of Data Platforms"


How to choose between Databricks Secret Scopes, Key Vault and Unity Catalog Secrets?

Unity Catalog secrets are the default for any new workload that can use them, per-secret grants, an audit trail, and a real UI, no reason to inherit scope-level ACLs when the platform offers all three. The exceptions are specific: anything touching a SQL warehouse, an init script, or a runtime older than 17.3 LTS stays on a classic scope for now, not as a stopgap but because UC secrets aren't reachable from that compute. Secrets that other Azure services also need to read belong in Key Vault-backed scopes, and the access-policy exception and per-boundary vault sprawl that comes with them are worth budgeting for up front. Most real estates, for a while, will run all three at once. Migration happens per workload, not as a single switch. And if you're already on Databricks Bundles, declare the scope or secret there instead of the CLI.

databricks_secrets_3Databricks Secrets introduce API and graphical user interfaces for secret management that are fully integrated into the Unity Catalog governance.

databricks_secrets_4Databricks Secrets are stored within a Unity Catalog schema and follow unified governance mechanisms for fine-grained permission management and access control.

Bundles Closed the Declarative Gap, Mostly

A year ago, this section would have said Databricks Bundles don't model secrets at all. That's no longer true: since CLI v0.252.0 (May 2025), databricks.yml supports a secret_scope resource (backend_type, keyvault_metadata for the Key Vault variant, a permissions block) and a secret resource for Unity Catalog secrets with a grants block, the same shape as catalog and schema grants elsewhere in the bundle. If you already deploy through Bundles, declare secrets there, not the CLI.

It closes the process gap, not the permission-model gap. A permissions: block on a secret_scope still grants MANAGE, WRITE or READ on the whole scope, exactly as put-acl always did. Declaring it in YAML gets you a diff and a PR review before PROD, but the scope is still scope-wide, and a Key Vault-backed one is still vault-wide. Bundling an existing setup buys review and consistency across DEV, QA and PROD; migrating the workload to a Unity Catalog secret buys actual per-secret granularity. Both have their place, but they solve different problems.

Managing Secrets in Databricks: Our Conclusion

Databricks won't keep three storage models for one credential forever. Unity Catalog secrets are clearly where the platform is headed: per-secret grants, a real UI, an audit trail for free, and today's runtime and SQL-warehouse gaps will keep closing. The decision worth making now isn't "which one forever" but which workloads can move today, and which are stuck on a classic scope until the platform catches up.

The harder problem is the gap between a platform that is always deployed through Bundles and one that accumulated years of hand-created scopes and ACLs first. Reconciling that history without losing the record of who granted what, and coordinating the Azure-side half of a Key Vault-backed scope that no Databricks tool reaches, is exactly the kind of problem a purpose-built custom Databricks management toolkit is for, built on top of Bundles rather than instead of them.

If your secrets setup predates your move to Bundles, or spans scopes, Key Vault and Unity Catalog at once with no clear picture of which team has access to what, get in touch, we're happy to walk through it with you.

 

FAQ - Managing Secrets in Databricks

Here you will find some of the most frequently asked questions about how to handle secrets in Databricks.

Should new pipelines use Unity Catalog secrets instead of a secret scope? If the compute is serverless or DBR 17.3+ on standard access mode, yes, there's little reason to start on the older ACL model. If the workload touches a SQL warehouse, an init script, or an older runtime, Unity Catalog secrets aren't reachable from there yet, so a classic scope is the only option for now, not a stopgap you chose.
Is a Key Vault-backed scope more secure than a Databricks-backed one? Not inherently, it's a different custody model, not a stricter one. It moves rotation and versioning into Azure, which helps if that's already governed well there, but the Databricks-side permission model is exactly as coarse: scope-level ACLs, access policies only, no Azure RBAC. Choose it because the secret needs to be read by something other than Databricks, not because it sounds more locked-down.
Can Databricks Bundles create and permission secret scopes or Unity Catalog secrets declaratively? Yes, since a recent Databricks CLI release, and it's worth knowing even if you're not building anything new: a scope or secret created some other way doesn't automatically become bundle-managed just because the resource type now exists. Bringing an existing one under a bundle means importing it deliberately, the same way you'd import any pre-existing cloud resource into Terraform state, not just adding a matching block and redeploying.
Do Unity Catalog secrets, or the new Bundle support, replace the need for governance tooling? Partly. Bundles make the existing ACL model declarative and reviewable, but a classic scope's grant is still scope-wide and a Key Vault-backed one is still vault-wide either way, the bundle changes the process, not the granularity. Unity Catalog secrets fix the granularity question directly, but only for workloads that can already run on the compute they require.
What happens if I hit the 1,000-scope limit on a workspace?  It's a soft limit; Databricks can raise it on request through your account team. That's less a blocker than a sign the scope-per-role pattern has scaled past what a single workspace was sized for, worth treating as a prompt to look at Unity Catalog secrets or a consolidation pass rather than just filing the increase request.
Can I automate secret ACL changes safely with a CI/CD pipeline? If you're deploying through Bundles already, the plan-and-apply cycle does the diffing for you. If you're scripting directly against the Secrets API instead, watch its 1,100-requests-per-minute limit: a script that blindly re-applies every ACL on every run rather than diffing against current state will eventually hit that ceiling on a large enough estate.

,

avatar

Markus

Markus has been a Senior Consultant for Machine Learning and Data Engineering at NextLytics AG since 2022. With significant experience as a system architect and team leader in data engineering, he is an expert in micro services, databases and workflow orchestration - especially in the field of open source solutions. In his spare time he tries to optimize the complex system of growing vegetables in his own garden.

Got a question about this blog?
Ask Markus

Databricks Secrets: Secret Scopes vs Azure Key Vault vs Unity Catalog
8:51

Blog - NextLytics AG 

Welcome to our blog. In this section we regularly report on news and background information on topics such as SAP Business Intelligence (BI), SAP Dashboarding with Lumira Designer or SAP Analytics Cloud, Machine Learning with SAP BW, Data Science and Planning with SAP Business Planning and Consolidation (BPC), SAP Integrated Planning (IP) and SAC Planning and much more.

Subscribe to our newsletter

Related Posts

Recent Posts