Samsara Lite

Samsara develops sensor systems with remote networking and cloud-based analytics.

Features

Feature Name	Supported	Notes
Capture deletes		All tables except the `DEFECT`, `DRIVER`, `DRIVER_HOS_VIOLATION`, `DVIR`, `EQUIPMENT_STATS`, `HOS_DAILY_LOG`, `SAFETY_EVENT`, `VEHICLE`, and `VEHICLE_TRIP` tables.
History mode
Custom data		All fields with the `value_` prefix in the `DOCUMENT_FIELD` table.
Data blocking		Column level
Column hashing
Re-sync		Table level. A table re-sync includes all the associated child tables.
API configurable		API configuration
Priority-first sync
Fivetran data models
Private networking
Authorization via API

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 connections.

Explore Samsara schema ERD

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.