Extract, load, transform: raw data lands in the target system first and is transformed there. See ETL for the opposite order.
Also called extract, load, transform.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains ELT in context, with comparison tables and the common traps.
Terms in this definition
- Chat message roles
Labels on chat messages: instructions go under system, the person's input under user, the model's previous answers under assistant, and results returned by a called tool under tool (or function).
- FIRST
A DAX function available only inside visual calculations. It fetches the value at the start of one axis of the visual's matrix, which makes it handy for comparing each point with the first; its opposite is LAST.
- ETL
Extract, transform, load: data is reshaped before it reaches the target. Data Factory offers ETL and ELT as a managed service.
Related terms
- 168.63.129.16
Special platform address (WireServer) through which Azure delivers the VM agent channel, built-in DNS, DHCP and load balancer health probes. Traffic to it must stay open, or those platform functions stop working.
- Active Standby
An NSX gateway HA mode where one Edge node handles traffic while a second waits to take over. Stateful services such as NAT, VPN, load balancing and the stateful firewall depend on it, and VCF Automation 9.0 expects its Tier-0 to be set up this way.
- Advanced label-based protection for all files on devices
An Endpoint DLP option for onboarded Windows computers. Users can go on working with labelled files that are not Office or PDF files while the extension stays the same; the label's print, view and extract rights are enforced on the device, and the file is encrypted once it is moved off it.
- @akv()
Available since version 1.6, this function lets a Data API builder config file pull in a Key Vault secret at load time from the vault endpoint you've configured. Substitutions made with
@env()happen earlier. - Apache JMeter
An open-source tool for load testing. Azure Load Testing runs its JMX scripts with support for every JMeter protocol and plugin, and also supports Locust.
- App Service Health check
An App Service feature that calls a path you choose on each instance every minute, takes persistently failing instances out of load balancing and replaces those still unhealthy after an hour.
- Application Gateway
Layer-7 load balancer deployed per region, offering URL-based routing, TLS offload, cookie-based affinity and an optional WAF.
- Application Gateway for Containers
Recent Application Gateway-based option for load balancing and ingress on AKS, offered as an alternative to AGIC.