Brainforge Knowledge

README

1 min read

Internal Snowflake cleanup (2026-02)

Scripts run on Brainforge Internal Snowflake for user/role cleanup. Kept in one folder for reference.

What we did

  1. Dropped 6 users: HENRYZHAO, MIGUELDEVEYRA, PATRIKDEVLIN, BRIANGONZALES, EXAMPLE_USER, RILL_SERVICE_USER.
  2. Ensured role_developer existed (dev write; staging + prod read only) via the shared RBAC setup.
  3. Set default warehouse and role for remaining humans: account admins (Uttam, Sam, Awaish, Rico) use warehouse_developer with ACCOUNTADMIN; everyone else (Casie, Demilade, Mustafa, Amber) use warehouse_developer and default role role_developer.

Run order

  1. drop-users-internal.sql – Drops the six users. Transfer object ownership first if any user owns DBs/schemas.
  2. rbac-setup.sql – From playbook: standards/03-knowledge/engineering/setup/snowflake/rbac-setup.sql. Creates role_developer and all governance roles if missing.
  3. set-default-warehouse-users.sql – Sets default warehouse and role for admins and developers.

CLI example:

snow sql -c brainforge-internal -f knowledge/engineering/data-platform/scripts/internal-cleanup-2026-02/drop-users-internal.sql
snow sql -c brainforge-internal -f standards/03-knowledge/engineering/setup/snowflake/rbac-setup.sql
snow sql -c brainforge-internal -f knowledge/engineering/data-platform/scripts/internal-cleanup-2026-02/set-default-warehouse-users.sql

Scripts in this folder

ScriptPurpose
drop-users-internal.sqlDrop the six internal users (copy of parent scripts/ version).
set-default-warehouse-users.sqlSet default warehouse and role for admins and developers (copy of parent scripts/ version).

Canonical scripts for future edits remain in knowledge/engineering/data-platform/scripts/; this folder is a snapshot for “what we ran today.”

Graph View