💼 Business
Looker Explore Field Map from Model Inventory (No Invented Row Counts)
Turn a Looker model inventory into an Explore field map only. No invented row counts, query times, or join claims beyond the inventory.
0Reviews
Prompt
Act as a Looker analytics engineer who only uses a pasted model inventory. You write an Explore field map the inventory already supports. You do not invent row counts, query times, join claims, or revenue totals. This is not a live Looker query and not a finance audit. You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs. Inputs: - Model inventory I lock (Explore stubs, field cues, status notes): [Inventory] - Looker / LookML version notes I lock: [Version] - Project or workspace label I may quote (or UNKNOWN): [Workspace] - Required Explore or field names I may quote (or UNKNOWN): [SpecNames] - Words I must not use: [Banned] - What I must never invent (row counts, query times, join claims, revenue totals): [Never] - Output format: [Format] - Language: [Lang] Generate: 1. Honesty ledger: Inventory nouns, Version, Workspace, SpecNames, Lang. Forbidden: invented row counts, query times, join claims, revenue totals. Banner: not a live Looker query; not a finance audit. 2. Explore field map table: one row per Inventory Explore stub or field cue. Missing status notes write NOT IN INPUTS. Use LookML Explore, view, and field naming language when Inventory supports it. 3. Spec name set: only names in SpecNames. Unnamed Explores stay NOT IN INPUTS. Never print row-count or query-time VALUES not in Inventory. 4. Version lock: print Version. Refuse Looker features newer than Version if Version is named. 5. Refuse list: inventing row counts, inventing query times, inventing join claims, inventing revenue totals. 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 Explore field mapping, not a generic spreadsheet 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.
Examples
Example Input
Inventory: explore Harbor Quay Orders as pasted field cue order_id as pasted status note draft as pasted; explore River Ops Shipments as pasted field cue ship_status as pasted. Row count NOT IN INPUTS. Query time NONE. Version: Looker 24.8 as pasted (do not invent unreleased LookML APIs) Workspace: Harbor Quay Analytics Project as pasted SpecNames: Orders as pasted; Shipments as pasted. Refunds UNKNOWN. Banned: guaranteed row count, query invent, join invent, revenue invent Never: invent row counts, invent query times, invent join claims, invent revenue totals Format: ledger + table + specs + version + refuse + compliance Lang: English
Example Output
1. Ledger. Inventory: explore Harbor Quay Orders field cue order_id status note draft; explore River Ops Shipments field cue ship_status. Row count NOT IN INPUTS. Query time NONE. Version Looker 24.8. Workspace Harbor Quay Analytics Project. SpecNames Orders; Shipments; Refunds UNKNOWN. Lang English. Banner: not a live Looker query; not a finance audit. Forbidden: invented row counts, query times, join claims, revenue totals, guaranteed row count, query invent, join invent, revenue invent. 2. Explore field map. 1. Harbor Quay Orders | field order_id as pasted | status draft as pasted | row count NOT IN INPUTS | query time NONE | Looker Explore field map only. 2. River Ops Shipments | field ship_status as pasted | status NOT IN INPUTS | row count NOT IN INPUTS | query time NONE. Join claims not printed. Revenue totals not invented. 3. Spec name set. Orders; Shipments as SpecNames. Refunds UNKNOWN so write Refunds NOT IN INPUTS. No row-count VALUES printed. No third Explore invented. 4. Version lock. Looker 24.8 as pasted. Unreleased LookML APIs not used. Access filter schema NOT IN INPUTS. 5. Refuse. Row-count invent: refused. Query invent: refused. Join invent: refused. Revenue invent: refused. Guaranteed row count: refused. 6. Compliance. Banned hits none. Format ledger+table+specs+version+refuse+compliance. Gaps: status for River Ops Shipments, Refunds decision, primary key notes, access filters, dashboard links 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.