Looker LookML Explore Map from Model Inventory (No Invented Row Counts)

Prompt

Act as a Looker LookML explore instructor who only uses a pasted model inventory. You write an explore map the inventory already supports so analysts can learn which explores exist. You do not invent row counts, SQL dialect strings, connection hostnames, or join keys not in Inputs. This is not a warehouse cost estimate and not a student grade.
You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs.

Inputs:
- LookML model inventory I lock (explore stubs, view cues, join notes): [Inventory]
- Looker / LookML version notes I lock: [Version]
- Project or course label I may quote (or UNKNOWN): [Workspace]
- Required explore names I may quote (or UNKNOWN): [SpecNames]
- Explore names already present (or UNKNOWN): [ExploreNames]
- View file cues already present (or UNKNOWN): [ViewCues]
- Join and relationship notes already present (or UNKNOWN): [JoinNotes]
- Words I must not use: [Banned]
- What I must never invent (row counts, SQL dialects, connection hosts, join keys): [Never]
- Output format: [Format]
- Language: [Lang]

Generate:
1. Honesty ledger: Inventory nouns, Version, Workspace, SpecNames, ExploreNames, ViewCues, JoinNotes, Lang. Forbidden: invented row counts, SQL dialects, connection hosts, join keys. Banner: not a warehouse cost estimate; not a student grade.
2. LookML explore map table: one row per Inventory explore stub or view cue. Missing JoinNotes write NOT IN INPUTS. Use Looker explores, views, dimensions, measures, and joins language when Inventory supports it. Never print row-count or connection-host VALUES not in Inventory.
3. Spec name set: only names in SpecNames. Unnamed explores stay NOT IN INPUTS. Never invent join-key VALUES not in Inventory.
4. Version lock: print Version. Refuse LookML features newer than Version if Version is named.
5. Refuse list: inventing row counts, inventing SQL dialect strings, inventing connection hostnames, inventing join keys.
6. Compliance pass: quote Banned and Never hits. Cut them. Format as Format.

Constraints:
- Map from Inventory only. No invented row-count VALUES. Teach Looker LookML explore mapping for education, not a generic Tableau or Power BI swap.
- Honor Version. No emojis.

Instructions

Replace every [bracket] with your details before running. Works on ChatGPT, Claude, and Gemini.

Generated Output

This image was generated using the prompt above.

Looker LookML Explore Map from Model Inventory (No Invented Row Counts) - Result

Examples

Example Input

Inventory: explore Harbor Quay Orders as pasted view cue order_items.view as pasted join notes joins users on user_id as pasted; explore River Ops Users as pasted view cue users.view as pasted. Row count invent NONE. Connection invent NONE.
Version: Looker 24.0 LookML as pasted (do not invent unreleased AI explore writer)
Workspace: Harbor Quay Analytics course project as pasted
SpecNames: orders as pasted; users as pasted. ConnectionName UNKNOWN.
ExploreNames: orders as pasted; users as pasted. products UNKNOWN.
ViewCues: order_items.view as pasted; users.view as pasted. products.view UNKNOWN.
JoinNotes: joins users on user_id as pasted. many_to_one cardinality NOT IN INPUTS.
Banned: guaranteed query, row invent, dialect invent, host invent
Never: invent row counts, invent SQL dialects, invent connection hosts, invent join keys
Format: ledger + table + specs + version + refuse + compliance
Lang: English

Example Output

1. Ledger. Inventory: explore Harbor Quay Orders view cue order_items.view join notes joins users on user_id; explore River Ops Users view cue users.view. Row count invent NONE. Connection invent NONE. Version Looker 24.0 LookML. Workspace Harbor Quay Analytics course project. SpecNames orders; users; ConnectionName UNKNOWN. ExploreNames orders; users; products UNKNOWN. ViewCues order_items.view; users.view; products.view UNKNOWN. JoinNotes joins users on user_id; many_to_one cardinality NOT IN INPUTS. Lang English. Banner: not a warehouse cost estimate; not a student grade. Forbidden: invented row counts, SQL dialects, connection hosts, join keys, guaranteed query, row invent, dialect invent, host invent.

3. Spec name set. orders; users as SpecNames. ConnectionName UNKNOWN so write ConnectionName NOT IN INPUTS. No row-count VALUES beyond Inventory. No third explore invented.

4. Version lock. Looker 24.0 LookML as pasted. Unreleased AI explore writer not used. Marketplace packs NOT IN INPUTS.

5. Refuse. Row invent: refused. Dialect invent: refused. Host invent: refused. Join-key invent: refused. Guaranteed query: refused.

6. Compliance. Banned hits none. Format ledger+table+specs+version+refuse+compliance. Gaps: ConnectionName decision, products ExploreNames, products.view ViewCues, many_to_one JoinNotes, marketplace packs list if any.

Missing-data policy: if a field was blank, write NOT IN INPUTS rather than guessing. Lock any tool version named in Inputs; if unnamed, write unknown. No invented testimonials, star ratings, or press logos. If legal, clinical, insurance, HR, education-plan, or veterinary content appears, add a one-line not-advice and de-identify banner. Quote banned-word hits and cut them. End with a gaps list of five bullets the user still owes you. Character and byte caps in the job are hard; print counts when relevant. Refuse to backfill DOIs, exam dumps, PHI, PII, or compensation promises not in Inputs.