STORED AS

In the Ultra Transcenders books

DBX-DEP

Each book explains STORED AS in context, with comparison tables and the common traps.

Terms in this definition

• AUTO CDC

  The Lakeflow pipelines API for change data capture: it merges incoming changes into a streaming table, keeping either just the latest values (SCD 1) or full history (SCD 2), and uses an ordering column to cope with records that arrive late. A snapshot variant also exists.

• SCD

  Slowly changing dimension. Type 1 keeps only current attribute values; type 2 retains every past version, bounded by __START_AT and __END_AT. Pipelines get both via AUTO CDC (STORED AS SCD TYPE 1 or STORED AS SCD TYPE 2), while TRACK HISTORY ON names which columns produce history.

• Get

  Key Vault permission on secrets that allows a single secret to be read; App Service Key Vault references need nothing beyond it.

• WHERE

  Limits a SELECT, UPDATE or DELETE to just the rows meeting a condition. Omit it, and the statement hits every row.

Related terms

• DER

  Certificate format stored as binary, whereas PEM uses Base64 text. Importing a trusted certificate from a file through the VCF Operations orchestrator workflow calls for DER; VCF Operations has no support for it.

• Fabric mirroring

  Keeps a live copy of a source system such as Azure Cosmos DB or Azure SQL Database in OneLake, stored as Delta Parquet, so it can be analysed straight away with no ETL to write.

• Inference table

  A log, stored as a Delta table in Unity Catalog, of the raw traffic going in and out of a served model or endpoint. Teams use it to debug, monitor, optimise prompts and meet compliance needs, and the two live versions differ in schema and limits.

• Intelligent throughput optimization

  A Copy activity setting, stored as dataIntegrationUnits, that limits how much CPU, memory and network a copy may consume; it accepts Auto, Standard, Balanced, Maximum or a number from 4 to 256. The units actually used appear as usedDataIntegrationUnits in the output and determine the data movement charge.

• Key Vault certificate

  X.509 certificate stored as a Key Vault object; Key Vault manages it alongside its associated key and secret and can renew it automatically.

• Locale

  Determines how Power Query reads dates and numbers stored as text when converting them. By default Power BI Desktop follows the regional format of the operating system; you can override this per file, or per step using Change type > Using locale.

• Manual categorisation

  Choosing objects by hand from the desktop client's Business View node and putting them in groups belonging to static categories. Their names are stored as a Manual selection condition, and nothing changes until someone edits it.

• Resource tags

  Metadata stored as name-value pairs, for example Environment = Production, that you attach to subscriptions, resource groups and resources (but not management groups) to organise them and their costs. By default, child items don't inherit them.