Microsoft Fabric Updates Blog

Variable Library Support in Notebook (Generally Available)

This release brings consistent, secure, and scalable configuration management directly into notebooks—streamlining environment-aware development and CI/CD workflows without hardcoding.

Why it Matters

As projects grow, managing environment-specific settings can become complex. With Variable Library support in notebooks, you can:

  • Centralize configuration management for notebooks without hardcoding values.
  • Enable dynamic parameterization for Spark settings, lakehouse bindings, and compute configurations.
  • Simplify CI/CD pipelines by using variables across environments and stages.

Key Highlights

  • NotebookUtils Integration – Access variables programmatically in your notebook code using the NotebookUtils Variable library utilities APIs, run the notebookutils.variableLibrary.help() to get more detailed usage.
  • Service Principal (SPN) support – SPN authentication is now available for Variable Library, enabling secure, automated processes in enterprise CI/CD pipelines and notebook activity pipelines.
  • Use %%configure to dynamically assign runtime settings – Combine Variable Library with %%configure to bind environment-specific runtime settings in the notebook, such as the default lakehouse, without manual edits.

The following is an example of how to use Variable Library in notebook.

Define variables in Variable library
Use Variable library in notebook

Resources

Billets de blog associés

Variable Library Support in Notebook (Generally Available)

avril 7, 2026 par Premal Shah

Organizations today manage data across multiple storage systems, often in formats like CSV, Parquet, and JSON. While this data is readily available, turning it into analytics-ready tables typically requires building and maintaining complex ETL pipelines. Shortcut transformations remove that complexity. With Shortcut transformations, you can convert structured files referenced through OneLake shortcuts into Delta tables … Continue reading “Shortcut transformations: Turn files into Delta tables without pipelines (Generally Available)”

avril 6, 2026 par Jovan Popovic

Fabric Data Warehouse now supports the ANY_VALUE() aggregate, making it easier to write readable, efficient T-SQL when you want to group by a key but still return descriptive columns that are functionally the same for every row in the group. What is ANY_VALUE()? ANY_VALUE() is an aggregate or analytic function that returns an arbitrary value … Continue reading “Use ANY_VALUE() for simpler grouping of results in Fabric Data Warehouse (Generally Available)”