Lists every semantic context with its name, title, child counts, and last-updated time. A read-only catalog listing.
SHOW SEMANTIC CONTEXTS## Overview SHOW SEMANTIC CONTEXTS lists every semantic context defined in the metastore, one row per context, ordered by title. It is the read-only listing surface for the semantic context catalog: use it to discover which grounding spaces exist and how much each one contains before drilling in with DESCRIBE SEMANTIC CONTEXT. The listing comes from the control plane, which owns the semantic context store. A compute node never reads the store directly; the command is served through the control plane API. ## Behavior - Result columns are name (the machine name / slug used to address the context), title (the human-readable label), tables, expressions, and queries (the counts of pinned tables, named expressions, and trusted example queries), and updated_at (the last time the context changed). - Rows are ordered by title. - The command takes no arguments. It always lists the full set of contexts the caller can see. - An empty result means no semantic contexts have been created. - The command is read-only. It never changes any context, table, or table data. ## Access Control Reads the list of semantic contexts; a read-only metadata command served by the control plane. Listing contexts grants no data access; the tables each context pins remain governed by their existing table-level privileges. ## Compatibility SHOW SEMANTIC CONTEXTS is a DeltaForge extension. It is read-only, in the same family as SHOW TABLE JOINS and SHOW TABLE USAGE. There is no ANSI SQL equivalent.
-- List all semantic contexts in the metastore
SHOW SEMANTIC CONTEXTS;