Column-level lineage
Trace any number on a dashboard back through every join, model and source column. Lineage is parsed from query logs, so it stays correct without annotation.
How lineage is builtWhy mccloudCo
mccloudCo started with a simple observation: a school district and a growing business have almost nothing in common — except both needed senior leadership they couldn't justify hiring full-time. Building one advisory model that actually works for both was never the easy part. It was just the part worth doing.
mccloudCo is two practices led by two principal consultants — one for schools and districts, one for growing businesses — and neither of us learned this business from the outside. We built the firm after watching what happens when "senior advisor" quietly becomes "whoever's available" once an engagement runs past the first few months, and after watching how often advice gets bent toward whatever platform or curriculum the advisor happens to sell. Neither happens here. It shows in how we work: the same consultant from the first call to the last, a named backup so nothing stalls if that consultant is ever out, and recommendations that are never steered by a commission — no curriculum, platform, or product endorsement sits behind anything we tell you. When an engagement ends, the rubrics, playbooks, and frameworks we used stay with your team; capability is the actual deliverable, not a report that gets filed away and forgotten.
We diagnose before we recommend anything — a short review, either standalone or built into the first month of working together, that tells us what the situation actually calls for rather than what we'd like to sell. From there, everything gets scoped and put in writing before any work begins, so there's never a gap between what was discussed on a call and what actually shows up in the engagement. The relationship is built to let you start small and grow only when the work demands it: plenty of our clients stay exactly where they started for years, and we treat that as a good outcome, not a missed upsell. Response times are published, not promised — thirty minutes for anything critical, a single business day for a routine request — and if the diagnostic turns up nothing that justifies bringing us in further, we say so directly instead of finding a reason to proceed anyway.
Trust
The controls, retention windows and sub-processors behind every Northlane deployment. Last reviewed 14 March 2025.
Northlane never copies your rows. The platform reads metadata — query history, information-schema snapshots, dbt manifests and BI catalogue exports — and stores the resulting lineage graph in the region you pick. Column values, row contents and query result sets are not retained at any point in the pipeline.
Every deployment is pinned to one region at provisioning time: eu-west-1 (Dublin), eu-central-1 (Frankfurt), us-east-1 (N. Virginia) or ap-southeast-2 (Sydney). Regions cannot be changed afterwards without a full workspace migration, which our support team runs inside a scheduled maintenance window.
Lineage snapshots are kept for 90 days on Team plans and 400 days on Enterprise plans. Audit events — logins, permission changes, connection edits and policy approvals — are kept for 24 months on every plan and cannot be shortened, because they form the evidence trail behind SOC 2 and ISO 27001 reporting.
When a workspace is deleted, its metadata is soft-deleted immediately, removed from primary storage within 30 days, and purged from encrypted backups within 90 days.
Deletion is irreversible once the 30-day grace period closes. Export anything you need for evidence requests before you remove a workspace.
Access to production is granted through short-lived, role-scoped credentials issued by our identity provider. Every production session is recorded, and no engineer holds standing access — elevation requires an approved change ticket and expires after four hours.
We publish the full sub-processor list, including the purpose, region and data category for each one. Customers on any plan can subscribe to change notifications and receive 30 days' notice before a new sub-processor is added.
Note
Customer-managed encryption keys are available on Enterprise plans only. Talk to your account team before enabling them — rotation cannot be reversed without a re-encryption window.
Important
Deleting a workspace purges its lineage history after a 30-day grace period. Export any evidence you need for audits before the workspace is removed.
Implementation
Every account runs the same sequence with a solutions engineer. Most teams are enforcing their first freshness contract on day two.
Step 01
Grant a read-only role in Snowflake, BigQuery, Redshift or Postgres. Northlane reads query history and metadata — no agents to install, no VPC peering, no copies of your data.
Day 1 · 20 minutes
Step 02
Tag the 30 to 50 tables your revenue, product and finance reporting actually depends on. Column-level lineage is traced upstream from there, including through dbt models and reverse-ETL syncs.
Week 1
Step 03
Declare what good looks like per table — arrival window, row-count band, null and uniqueness thresholds — then set who is paged when the contract fails. Templates cover the common shapes.
Week 2
Step 04
Breaches open in Slack and PagerDuty with the failing column, the upstream job and every affected dashboard already attached. Nothing else changes in your stack.
Week 3 · Ongoing
Median time from kickoff to first production alert across 2025 deployments: 9 days.
Book a demoWhat you can expect
Not projections — the commitments built into every engagement, regardless of practice or tier.
68 %
Fewer pipeline incidents
Measured against the 90 days before rollout.
42 accounts · platform telemetry
$ 4.2 M
Warehouse spend recovered
Idle compute and duplicate models retired automatically.
Median enterprise account, FY25
99.98 %
Freshness SLA held
Across 12,400 monitored production tables.
Rolling 12-month average
9 ×
Faster root-cause analysis
Alert raised to owner-confirmed cause.
Customer survey, n=310
Platform capabilities
Northlane connects to your warehouse in read-only mode and maps every table, column and job in under an hour. Lineage, monitoring and access policy then come from one graph instead of three tools.
Trace any number on a dashboard back through every join, model and source column. Lineage is parsed from query logs, so it stays correct without annotation.
How lineage is builtNorthlane learns each table's normal cadence and row count, then pages the team that owns the model when a load lands late or a volume halves.
See the monitor typesDefine row and column rules once. Northlane pushes them down to Snowflake, BigQuery and Redshift and keeps a signed approval trail for audit.
Read the security brief180+ connectors, including Snowflake, BigQuery, Databricks and Redshift.
The principal consultants
Forty-one people across nine countries, building the data operations layer we wanted back when we were the ones carrying the pager.
Customer stories
Every story below is a production deployment with numbers the customer signed off on. No pilots, no anonymised logos.
Fintech 480 employees
Four hand-run reconciliation jobs became one governed pipeline, and the books closed in three days instead of eight.
63% faster close
Healthcare 1,200 employees
A decade of untracked SQL moved onto column-level lineage without pausing a single downstream dashboard.
1,400 models migrated
Logistics 260 employees
Freshness checks run themselves, so nobody triages “is this dashboard stale?” tickets any more.
6 hrs back each week
Get started
Book a no-cost consultation, and we'll talk through your organization, your goals, and your budget cycle — then recommend a starting point, or tell you honestly if now isn't the time.
No cost to talk. No obligation to sign. No pressure either way.