Zero-ETL Enterprise Data Warehouse Sharing

Mount decentralized insurance telemetry directly into your Snowflake & BigQuery

Query normalized capital adequacy datasets, parametric loss ledgers, and live oracle feeds directly within your institutional analytics warehouse with zero ingestion latency and zero pipeline maintenance.

Request Snowflake Share Access Browse Data Catalog
Snowflake

Native Secure Data Sharing across AWS, GCP, and Azure regions. Read-only schema replication in seconds.

SHARE: INSURCHAIN_PROD
BigQuery

Available on Google Analytics Hub. Query partitioned tables with standard SQL without copying data.

HUB: insurchain-analytics
Databricks

Delta Sharing protocol support for high-performance Spark actuarial modeling and ML pipeline feeds.

DELTA: insurchain_share
AWS Redshift

AWS Data Exchange integration. Direct cross-account datasharing in all major US, EU, and APAC AWS regions.

ARN: aws:redshift:insur
Mount Command Generator

Deploy InsurChain to your warehouse in 30 seconds

Snowflake SQL Worksheets 
-- 1. Create local database from the InsurChain Secure Share
CREATE DATABASE IF NOT EXISTS INSURCHAIN_SHARED
  FROM SHARE INSURCHAIN_PROD_GLOBAL.INSURCHAIN_SHARE;

-- 2. Grant read access to your actuarial analysts role
GRANT IMPORTED PRIVILEGES ON DATABASE INSURCHAIN_SHARED TO ROLE RISK_ANALYST;

-- 3. Query real-time solvency ratios
SELECT * FROM INSURCHAIN_SHARED.ACTUARIAL.SOLVENCY_HOURLY
WHERE CAPITAL_ADEQUACY_RATIO < 1.50;

Normalized Enterprise Data Catalog

INSURCHAIN_CORE.PROTOCOLS Partitioned by chain_id • Refreshed per block

Master dimensions for all 48 decentralized insurance protocols, including multi-sig treasury contracts, cover pool addresses, and staking rewards APR.

Columns: protocol_id, name, chain_id, deploy_block, tvl_usd, reserve_vault_address, claims_dao_contract
INSURCHAIN_ACTUARIAL.SOLVENCY_SNAPSHOTS_HOURLY Time-series • 5-year historical depth

Hourly actuarial calibrations covering Capital Adequacy Ratios (CAR), Minimum Capital Requirements (MCR), and 99.5% Value-at-Risk across all pools.

Columns: snapshot_timestamp, protocol_id, car_ratio, var_995_usd, mcr_margin, liquid_reserves_usd
INSURCHAIN_PARAMETRIC.ORACLE_TRIGGER_LEDGER Append-only log • Zero-latency telemetry

Immutable event log for all automated and dispute-resolved parametric claim disbursements, validator voting attestations, and oracle deviations.

Columns: event_id, incident_tx_hash, protocol_id, trigger_type, payout_usd, response_seconds, oracle_signatures