The Data Developers
Documentation

Technical Documentation

Warehouse-native setup and reference material for The Data Developers data estate.

Getting Started

BigQuery and Snowflake access setup, IAM patterns, and provisioning flow.

Data Product Reference

Catalog-level descriptions, source authorities, record counts, and refresh cadence.

Data Dictionary

Schema reference, key columns, sample paths, and join-key conventions.

Sample Queries

Reusable SQL for IRA exposure, FAERS signal scoring, trial landscapes, and label intelligence.

Setup

Getting started with warehouse delivery

BigQuery access setup

  1. Create or select a governed GCP project.
  2. Share a service account principal or approved Google group.
  3. We provision datasets with table descriptions, policy tags if requested, and lineage views.
  4. Your team validates sample queries and schedules refresh monitoring.

Snowflake sharing

  1. Provide target Snowflake account locator and region.
  2. We create a native share with products in scope.
  3. Your admin grants database roles to analyst groups.
  4. Refresh notes land in changelog and lineage tables.
SQL

Sample query pattern

SELECT
  canonical_drug_id,
  source_authority,
  COUNT(*) AS row_count,
  MAX(last_refreshed_at) AS latest_refresh
FROM `customer_project.tdd_biomedical.product_facts`
GROUP BY canonical_drug_id, source_authority
ORDER BY row_count DESC
LIMIT 50;