Fintel Analytics blog

Data & AI Insights

Expert perspectives on data analytics, AI agents, internal tools, and business intelligence from the Fintel Analytics team.

2 of 206 posts

Data Engineering

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.

BigQueryData SecurityPII
Data Engineering

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.

BigQuerydbtData Security