🔬 Research
BigQuery Dataset ACL Map from Project Inventory (No Invented Slot Ms)
Turn a BigQuery project inventory into a dataset ACL map only. No invented slot-ms, service account keys, or row counts beyond the inventory.
0Reviews
Prompt
Act as a BigQuery dataset ACL cartographer who only uses a pasted project inventory. You write a dataset and ACL map the inventory already supports. You do not invent slot-ms totals, service account keys, row counts, or billing export IDs not in Inputs. This is not a BigQuery cost estimate and not a live IAM audit. You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs. Inputs: - Project dataset inventory I lock (dataset stubs, ACL cues, table notes): [Inventory] - BigQuery / location version notes I lock: [Version] - Project or folder label I may quote (or UNKNOWN): [Workspace] - Required dataset or ACL names I may quote (or UNKNOWN): [SpecNames] - Dataset names already present (or UNKNOWN): [DatasetCues] - ACL roles already present (or UNKNOWN): [AclRoles] - Table and location notes already present (or UNKNOWN): [TableNotes] - Words I must not use: [Banned] - What I must never invent (slot-ms, service account keys, row counts, billing export IDs): [Never] - Output format: [Format] - Language: [Lang] Generate: 1. Honesty ledger: Inventory nouns, Version, Workspace, SpecNames, DatasetCues, AclRoles, TableNotes, Lang. Forbidden: invented slot-ms, service account keys, row counts, billing export IDs. Banner: not a BigQuery cost estimate; not a live IAM audit. 2. Dataset ACL map table: one row per Inventory dataset stub or ACL cue. Missing TableNotes write NOT IN INPUTS. Use BigQuery datasets, tables, ACLs, roles, and locations language when Inventory supports it. Never print slot-ms or key VALUES not in Inventory. 3. Spec name set: only names in SpecNames. Unnamed datasets stay NOT IN INPUTS. Never invent row-count VALUES not in Inventory. 4. Version lock: print Version. Refuse BigQuery features newer than Version if Version is named. 5. Refuse list: inventing slot-ms, inventing service account keys, inventing row counts, inventing billing export IDs. 6. Compliance pass: quote Banned and Never hits. Cut them. Format as Format. Constraints: - Map from Inventory only. No invented slot-ms VALUES. Teach BigQuery dataset ACL mapping, not a Snowflake or Redshift 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: dataset Harbor Quay analytics_raw as pasted ACL cue roles/bigquery.dataViewer as pasted table notes events as pasted; dataset River Ops analytics_mart as pasted ACL cue roles/bigquery.dataEditor as pasted. Slot invent NONE. Key invent NONE. Version: BigQuery US multi-region 2024 as pasted (do not invent unreleased AI ACL writer) Workspace: Harbor Quay data-platform project as pasted SpecNames: analytics_raw ACL map as pasted; analytics_mart ACL map as pasted. SA key UNKNOWN. DatasetCues: analytics_raw as pasted; analytics_mart as pasted. analytics_pii UNKNOWN. AclRoles: roles/bigquery.dataViewer as pasted; roles/bigquery.dataEditor as pasted. roles/owner UNKNOWN. TableNotes: events as pasted. Slot-ms VALUES NOT IN INPUTS. Banned: guaranteed slots, slot invent, key invent, row invent Never: invent slot-ms, invent service account keys, invent row counts, invent billing export IDs Format: ledger + table + specs + version + refuse + compliance Lang: English
Example Output
1. Ledger. Inventory: dataset Harbor Quay analytics_raw ACL cue roles/bigquery.dataViewer table notes events; dataset River Ops analytics_mart ACL cue roles/bigquery.dataEditor. Slot invent NONE. Key invent NONE. Version BigQuery US multi-region 2024. Workspace Harbor Quay data-platform project. SpecNames analytics_raw ACL map; analytics_mart ACL map; SA key UNKNOWN. DatasetCues analytics_raw; analytics_mart; analytics_pii UNKNOWN. AclRoles roles/bigquery.dataViewer; roles/bigquery.dataEditor; roles/owner UNKNOWN. TableNotes events; Slot-ms VALUES NOT IN INPUTS. Lang English. Banner: not a BigQuery cost estimate; not a live IAM audit. Forbidden: invented slot-ms, service account keys, row counts, billing export IDs, guaranteed slots, slot invent, key invent, row invent. 2. Dataset ACL map. 1. Harbor Quay analytics_raw | DatasetCues analytics_raw as pasted | AclRoles roles/bigquery.dataViewer as pasted | TableNotes events as pasted | slot VALUES NONE | key NONE | BigQuery dataset ACL map only. 2. River Ops analytics_mart | DatasetCues analytics_mart as pasted | AclRoles roles/bigquery.dataEditor as pasted | TableNotes beyond events NOT IN INPUTS | slot VALUES NONE | key NONE. SA key UNKNOWN so write SA key NOT IN INPUTS. analytics_pii not invented beyond DatasetCues. 3. Spec name set. analytics_raw ACL map; analytics_mart ACL map as SpecNames. SA key UNKNOWN so write SA key NOT IN INPUTS. No slot-ms VALUES beyond Inventory. No third dataset invented. 4. Version lock. BigQuery US multi-region 2024 as pasted. Unreleased AI ACL writer not used. Billing export packs NOT IN INPUTS. 5. Refuse. Slot invent: refused. Key invent: refused. Row invent: refused. Billing invent: refused. Guaranteed slots: refused. 6. Compliance. Banned hits none. Format ledger+table+specs+version+refuse+compliance. Gaps: SA key policy, analytics_pii DatasetCues, roles/owner AclRoles, slot-ms VALUES TableNotes, authorized view 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.