• Source
  • Finance & Ops Analytics
  • Alpha

Move 7shifts data anywhere it matters.

Send 7shifts companies, locations and departments to any warehouse, lake or AI app.

Source

7shifts

  • Snowflake
  • BigQuery
  • Postgres
  • Databricks
  • Claude
Streams
12
Incremental streams
7
Destinations
50+
Standard support
0.0.56

Overview

What is the Airbyte 7shifts connector?

The Airbyte 7shifts connector extracts data from 7shifts and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes 12 streams you can select per connection.

  • 01

    Sync to your warehouse

    Land 12 7shifts tables in 50+ destinations on a schedule you control.

  • 02

    Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • 03

    One authorization

    Authenticate 7shifts once and Airbyte keeps every scheduled sync running on it.

  • 04

    Cloud or self-hosted

    Run the 7shifts connector on Cloud, OSS, Hybrid.

12 streams

Every table you can sync from 7shifts

  • companiesIncremental
    Primary keyid
    PaginationDefaultPaginator
    Sync modesFullIncr.
  • locationsIncremental
    Primary keyid
    PaginationDefaultPaginator
    Sync modesFullIncr.
  • departmentsIncremental
    Primary keyid
    PaginationDefaultPaginator
    Sync modesFullIncr.
  • rolesIncremental
    Primary keyid
    PaginationDefaultPaginator
    Sync modesFullIncr.
  • usersIncremental
    Primary keyid
    PaginationDefaultPaginator
    Sync modesFullIncr.
  • wages
    PaginationNo pagination
    Sync modesFullIncr.

Setup

Live in three steps

  1. Get your 7shifts credentials from the vendor dashboard or developer settings.

  2. Configure the source in Airbyte with the required connection fields.

  3. Pick a destination, choose streams, set full refresh or incremental, and schedule syncs.

Configuration fields

7shifts configuration fields
FieldTypeDescription
access_token*stringAccess token to use for authentication. Generate it in the 7shifts Developer Tools.
start_date*stringNot documented.

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

  • Cloud
  • OSS
  • Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

7shifts connector questions

What data can I sync from 7shifts with Airbyte?

12 streams: companies, locations, departments, roles, users, wages, assignments, location assignments, department assignments, role assignments, time punches, shifts.

Does the 7shifts connector support incremental sync?

Yes. companies, locations, departments, roles and others support incremental sync, and every documented stream supports full refresh.

Where can I run the 7shifts connector?

Run the 7shifts connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales

Start syncing 7shifts in minutes.

Free 14-day trial. No credit card needed.