Back to Discover

#bigquery

1 prompt found

BigQuery Dataset ACL Map from Project Inventory (No Invented Slot Ms)
๐Ÿ”ฌ Research

BigQuery Dataset ACL Map from Project Inventory (No Invented Slot Ms)

PpromptstudioยทSep 14, 2026
No rating

Turn a BigQuery project inventory into a dataset ACL map only. No invented slot-ms, service account keys, or row counts beyond the inventory.

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.