Which data warehouse users have write access to production tables but have not executed a write query in the last 60 days?
Identifies stale write permissions in the data warehouse that should be revoked per least-privilege principles.
Metrics & KPIs
Required Data
Data Sources
Works with tools like
How Bruin answers this
Bruin AI Data Analyst
Which data warehouse users have write access to production tables but have not executed a write query in the last 60 days?
Bruin connects to your Data Warehouse and runs the analysis automatically.
It tracks Stale permission count, over-privileged user count, permission types and delivers the answer in seconds, in Slack, Discord, Teams, Google Chat, WhatsApp, Telegram, email, or your browser.
Related use cases
Data Pipeline Freshness
Which data pipelines have breached their 2-hour freshness SLA more than 3 times in the past week?
Data & Analyticsdbt Model Run Failures
Which dbt models have failed more than twice in the last 7 days and are blocking downstream dashboards?
Data & AnalyticsQuery Cost Anomaly Detection
Which warehouse queries have cost more than $50 per run in the last 7 days and are scheduled to run more than once daily?
Bruin for SaaS
Use cases across every team in your SaaS company, from churn & retention to revenue operations, product analytics to engineering. One AI that speaks your data.
Get this answer in seconds
Connect your data, ask the question, get the answer. No SQL needed.