A Power Query command, also labelled View data source query, that displays what a step sends to the source. If it is greyed out on a step where the source normally supports it, query folding has stopped at that step.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains View Native Query in context, with comparison tables and the common traps.
Terms in this definition
- View
Shows a system through one chosen group of related concerns. No view is generic; each one is tied to whichever architecture it depicts.
- Search data source
Connection object in Azure AI Search pointing an indexer at its content, which must be a supported source: Blob, ADLS Gen2, Table Storage, Cosmos DB, Azure SQL, SQL Managed Instance or SQL Server on Azure VMs. One indexer, one data source.
- WHERE
Limits a SELECT, UPDATE or DELETE to just the rows meeting a condition. Omit it, and the statement hits every row.
- Query folding
Power Query converting your steps into a query in the source's own language, so the database or service does the heavy lifting rather than the mashup engine. Folding indicators, and the query plan, let you check which steps get pushed down.