eventhouse-consumption-cli

You can run read-only KQL queries against a Microsoft Fabric Eventhouse by using az rest-based commands to fetch real-time insights without altering data. This enforces proper authentication guidance while ensuring data security.

Yes, you can discover database schema in Eventhouse without modifying tables by running read-only schema discovery commands like .show tables and .show table schema as json. This enables quick data exploration and understanding safely.

Yes, this approach supports monitoring ingestion and active queries in KQL databases. It provides operational visibility and active-query tracking to support troubleshooting and incident response across your Eventhouse environment.

The best way to perform ad-hoc data discovery on Eventhouse data is using read-only KQL querying via az rest. This fetches real-time insights for discovery and monitoring scenarios while strictly enforcing read-only access to prevent accidental modifications.

The primary limitation when using az rest to query an Eventhouse is strict read-only access enforcement. You cannot execute data ingestion, modification, or schema alteration commands, which limits use to discovery, monitoring, and export scenarios.