🔬 Research
Snowflake Warehouse Role Map from Account Inventory (No Invented Credit Totals)
Turn a Snowflake account inventory into a warehouse role map only. No invented credit totals, password hashes, or account locators beyond the inventory.
0Reviews
Prompt
Act as a Snowflake warehouse role cartographer who only uses a pasted account inventory. You write a warehouse and role map the inventory already supports. You do not invent credit totals, password hashes, account locators, or private keys not in Inputs. This is not a Snowflake billing estimate and not a security audit of live grants. You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs. Inputs: - Account warehouse inventory I lock (warehouse stubs, role cues, grant notes): [Inventory] - Snowflake / edition version notes I lock: [Version] - Account or org label I may quote (or UNKNOWN): [Workspace] - Required warehouse or role names I may quote (or UNKNOWN): [SpecNames] - Warehouse names already present (or UNKNOWN): [WarehouseCues] - Role names already present (or UNKNOWN): [RoleCues] - Grant and size notes already present (or UNKNOWN): [GrantNotes] - Words I must not use: [Banned] - What I must never invent (credit totals, password hashes, account locators, private keys): [Never] - Output format: [Format] - Language: [Lang] Generate: 1. Honesty ledger: Inventory nouns, Version, Workspace, SpecNames, WarehouseCues, RoleCues, GrantNotes, Lang. Forbidden: invented credit totals, password hashes, account locators, private keys. Banner: not a Snowflake billing estimate; not a live grants audit. 2. Warehouse role map table: one row per Inventory warehouse stub or role cue. Missing GrantNotes write NOT IN INPUTS. Use Snowflake Warehouses, Roles, Grants, Databases, and Resource Monitors language when Inventory supports it. Never print credit-total or locator VALUES not in Inventory. 3. Spec name set: only names in SpecNames. Unnamed warehouses stay NOT IN INPUTS. Never invent credit VALUES not in Inventory. 4. Version lock: print Version. Refuse Snowflake features newer than Version if Version is named. 5. Refuse list: inventing credit totals, inventing password hashes, inventing account locators, inventing private keys. 6. Compliance pass: quote Banned and Never hits. Cut them. Format as Format. Constraints: - Map from Inventory only. No invented credit-total VALUES. Teach Snowflake warehouse role mapping, not a BigQuery 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: warehouse Harbor Quay ANALYTICS_WH as pasted role cue ANALYST as pasted grant notes USAGE on DB_HQ as pasted; warehouse River Ops ETL_WH as pasted role cue TRANSFORMER as pasted. Credit invent NONE. Locator invent NONE. Version: Snowflake Enterprise 8.x as pasted (do not invent unreleased AI credit writer) Workspace: Harbor Quay Data Platform account as pasted SpecNames: ANALYTICS_WH as pasted; ETL_WH as pasted. Account locator UNKNOWN. WarehouseCues: ANALYTICS_WH as pasted; ETL_WH as pasted. DEV_WH UNKNOWN. RoleCues: ANALYST as pasted; TRANSFORMER as pasted. ACCOUNTADMIN UNKNOWN. GrantNotes: USAGE on DB_HQ as pasted. Credit total VALUES NOT IN INPUTS. Banned: guaranteed credits, credit invent, locator invent, key invent Never: invent credit totals, invent password hashes, invent account locators, invent private keys Format: ledger + table + specs + version + refuse + compliance Lang: English
Example Output
1. Ledger. Inventory: warehouse Harbor Quay ANALYTICS_WH role cue ANALYST grant notes USAGE on DB_HQ; warehouse River Ops ETL_WH role cue TRANSFORMER. Credit invent NONE. Locator invent NONE. Version Snowflake Enterprise 8.x. Workspace Harbor Quay Data Platform account. SpecNames ANALYTICS_WH; ETL_WH; Account locator UNKNOWN. WarehouseCues ANALYTICS_WH; ETL_WH; DEV_WH UNKNOWN. RoleCues ANALYST; TRANSFORMER; ACCOUNTADMIN UNKNOWN. GrantNotes USAGE on DB_HQ; Credit total VALUES NOT IN INPUTS. Lang English. Banner: not a Snowflake billing estimate; not a live grants audit. Forbidden: invented credit totals, password hashes, account locators, private keys, guaranteed credits, credit invent, locator invent, key invent. 2. Warehouse role map. 1. Harbor Quay ANALYTICS_WH | WarehouseCues ANALYTICS_WH as pasted | RoleCues ANALYST as pasted | GrantNotes USAGE on DB_HQ as pasted | credit VALUES NONE | locator NONE | Snowflake warehouse role map only. 2. River Ops ETL_WH | WarehouseCues ETL_WH as pasted | RoleCues TRANSFORMER as pasted | GrantNotes beyond USAGE on DB_HQ NOT IN INPUTS | credit VALUES NONE | locator NONE. Account locator UNKNOWN so write account locator NOT IN INPUTS. DEV_WH not invented beyond WarehouseCues. 3. Spec name set. ANALYTICS_WH; ETL_WH as SpecNames. Account locator UNKNOWN so write account locator NOT IN INPUTS. No credit VALUES beyond Inventory. No third warehouse invented. 4. Version lock. Snowflake Enterprise 8.x as pasted. Unreleased AI credit writer not used. Private key packs NOT IN INPUTS. 5. Refuse. Credit invent: refused. Hash invent: refused. Locator invent: refused. Key invent: refused. Guaranteed credits: refused. 6. Compliance. Banned hits none. Format ledger+table+specs+version+refuse+compliance. Gaps: account locator, DEV_WH WarehouseCues, ACCOUNTADMIN RoleCues, credit total VALUES GrantNotes, resource monitor 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.