Snowflake / Enterprise System

Snowflake account
├── DATABASE: ANALYTICS
│   ├── SCHEMA: BRONZE   (raw, owned by ingest role)
│   ├── SCHEMA: SILVER   (transform role)
│   ├── SCHEMA: GOLD     (read-only to BI)
│   └── SCHEMA: AUDIT
└── WAREHOUSES
    ├── WH_INGEST_XS
    ├── WH_TRANSFORM_M
    └── WH_BI_S  (auto-suspend 60s)

CREATE OR REPLACE STAGE bronze_stage
  URL='s3://co-data/bronze/claims/'
  STORAGE_INTEGRATION = s3_int
  FILE_FORMAT = (TYPE=PARQUET);

CREATE OR REPLACE PIPE bronze.pipe_raw_claims
  AUTO_INGEST = TRUE AS
COPY INTO bronze.raw_claims
FROM @bronze_stage
FILE_FORMAT = (TYPE=PARQUET)
ON_ERROR = 'CONTINUE';

models:
  analytics:
    bronze:
      +materialized: incremental
      +schema: bronze
    silver:
      +materialized: incremental
      +schema: silver
    gold:
      +materialized: table
      +schema: gold