Edit on GitHub
Open Data DC Lite link
Open Data DC is an open data portal that provides government data for Washington, D.C.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | All tables |
Custom data | ||
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | ||
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Sync overviewlink
The connector syncs data for the Crashes In DC dataset into your destination. To capture new records, we incrementally sync the CRASH_IN_DC
table and its child tables.
We sync all the tables once daily because the source data is not frequently updated. To capture updates and deletes, we also re-import the CRASH_IN_DC
table and its child tables once a week.
Setup guidelink
Follow our step-by-step Open Data DC setup guide to connect Open Data DC with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all Open Data DC connectors.
To zoom, open the ERD in a new window.