Raw
The raw layer is the untyped landing zone for data crawled by the Scrapy spider. Tables sit in the <env>__raw ClickHouse schema and are declared as dbt sources, not models — there is no SQL transformation here, just the JSON payloads as scraped.
| Source | Table | Loaded at |
|---|---|---|
| bet365 / ended_events | bet365__ended_events | extracted_at |
| bet365 / odds | bet365__odds | extracted_at |
| bet365 / lineups | bet365__lineups | extracted_at |
| bet365 / dbt_test_results | dbt_test_results_raw | executed_at |
| bet365 / dbt_test_failures | dbt_test_failures_raw | recorded_at |
Source freshness is checked with a 26-hour warn / 50-hour error threshold across all five tables (configured in models/raw/betsapi/properties.yml).