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 , EQUIPMENT_STATS , HOS_DAILY_LOG , SAFETY_EVENT , VEHICLE , and VEHICLE_TRIP tables. |
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 |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
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
STREAM_DVIR
SYNTHETIC_ENGINE_SECOND
VEHICLE
VEHICLE_IDLING_REPORT
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.
Limitations
We do not support Webhook events.
The Samsara API provides only the last 1 year's worth of data for the ALERT_INCIDENT. Due to this limitation, during the initial sync, we only sync the last 1 year's worth of data for the ALERT_INCIDENT
table.