Sacramento 311
Sync Sacramento 311 service requests into your warehouse.
The Sacramento 311 connector syncs Sacramento service requests into analytics-ready tables in your data warehouse. Pull 311 calls with the three-level category, intake source, public status and created, updated and closed timestamps from the City of Sacramento 311 calls feature service, with Ingest handling pagination and retries so the tables stay current.
Sacramento 311 is not a certified connector yet. Ingest authors one from the vendor's API documentation when a customer asks for it, runs it against the real API, and only then lists it as deployable. Request it and it moves up the queue.
What you can sync
Ingest lands the following Sacramento 311 data in your warehouse or lake, each as its own table on the schedule you pick:
- Service requests
- Request status and closure
- Request categories
- Neighborhood and council district
Authentication
None. The Sacramento 311 API is public and needs no credential.
Credentials go into a form, never into a chat, and are held in a secret store under your own path. Only the key NAMES ever reach the control database.