Fintel AnalyticsBigQuery Access Control: Row & Column Security Done Right
Most growth-stage companies running BigQuery give everyone too much access. Here is how to implement row-level and column-level security that scales with your team.
Fintel Analytics blog
Data & AI Insights
Expert perspectives on data analytics, AI agents, internal tools, and business intelligence from the Fintel Analytics team.
10 of 206 posts
dbt Authorized Views in BigQuery: Fix Broken Access Control
Most dbt BigQuery teams grant dataset-level IAM instead of using authorized views — here's why that breaks security and exactly how to fix it.
PII Sitting Unmasked in BigQuery: How to Find It Fast
Unmasked PII in BigQuery is a compliance and security risk most teams discover too late. Here's how to find it in under five minutes using SQL against INFORMATION_SCHEMA.
Snowflake ACCOUNTADMIN Audit: Who Has It and Who Uses It?
Too many people, and too many dbt jobs, run as ACCOUNTADMIN. Use these Snowflake queries to find them and fix it safely.
BigQuery Service Account Key in dbt Repo: Find & Fix It
A BigQuery service account key committed to a dbt repo is a live credential, not a tidy-up task. Find it, rotate it and remove it for good.
BigQuery Dynamic Data Masking in dbt: The Access Pattern That Breaks at Scale
Building data masking logic inside dbt models is one of the most quietly dangerous patterns in a growing warehouse. Here's why it breaks — and how to fix it.
BigQuery Column-Level Encryption in dbt: Protect Sensitive Data
BigQuery column-level encryption lets you protect PII and financial data at the field level — but wiring it correctly into dbt without breaking downstream models is harder than the docs suggest.
Over-Broad IAM Grants in BigQuery: Find & Fix Them Now
Over-broad BigQuery IAM grants are the most common—and most quietly dangerous—misconfiguration in fast-growing data teams. Here's how to find them in under five minutes.
Multi-Tenant SaaS Analytics: Build It Right in 2026
Multi-tenant SaaS analytics is one of the most under-engineered parts of a B2B product. Get the architecture wrong and you risk data leaks, broken dashboards, and a rebuild at scale.
Anomaly Detection and Fraud Prevention with Data Analytics
Fraud costs businesses billions every year. Discover how anomaly detection and data analytics are transforming fraud prevention strategies in 2026.