Samsara Lite
Samsara develops sensor systems with remote networking and cloud-based analytics.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | DEFECT , DRIVER , DRIVER_HOS_VIOLATION , DVIR , HOS_DAILY_LOG , SAFETY_EVENT , VEHICLE , and VEHICLE_TRIP . |
History mode | ||
Custom data | check | value_ prefix in the DOCUMENT_FIELD table. |
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 Samsara setup guide to connect Samsara with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
AUX_INPUT
BATTERY_MILLI_VOLT
DEFECT
DOCUMENT
DRIVER_HOS_VIOLATION
DRIVER_VEHICLE_ASSIGNMENT
DRIVER
DVIR
ENGINE_STATE
FAULT_CODE
FUEL_PERCENT
GPS_ODOMETER
GPS
HOS_DAILY_LOG
OBD_ENGINE_SECOND
OBD_ODOMETER
ROUTE
SAFETY_EVENT
SYNTHETIC_ENGINE_SECOND
VEHICLE_TRIP
We also re-import the DOCUMENT
and ROUTE
tables once a week to capture updates and deletes.
We re-import the remaining tables during every sync.
We sync the following values in the units below, unless we state otherwise in the column name or table name:
Value | Unit of Measurement |
---|---|
Temperature | Millidegrees Celsius (m°C) |
Pressure | Kilopascals (kPa) |
Speed | Miles per hour (MPH) |
Schema information
This schema applies to all Samsara connectors.
Explore Samsara schema ERD
Limitations
We do not support Webhook events.