Brivo Lite Private Preview
Brivo is a cloud-based access control platform for commercial real estate.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | ACCESS_POINT, ACCOUNT, CAMERA, EVENT_SUBSCRIPTION, SCHEDULE, SITE, and USERS tables. |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Brivo setup guide to connect Brivo with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the ACCESS_EVENT and AUDIT_EVENT tables.
To capture updates and deletes, we re-import the following tables in every sync:
ACCESS_POINTACCOUNTCAMERAEVENT_SUBSCRIPTIONSCHEDULESITEUSERS
Schema information
This schema applies to all Brivo connectors.
Explore Brivo schema ERD
Limitations
Brivo's API has three types of subscriptions, each with different data retention periods. Due to limitation in data retention periods, we retrieve only the last 12 months' worth of data for the ACCESS_EVENT and AUDIT_EVENT tables.
Sync frequency
Due to Brivo's API rate limitations, we recommend that you set your connection's sync frequency to 24 hours.