JobTread integration
JobTread data, in your warehouse.
A built-in ingestr connector: add credentials, pick tables, schedule it.
name: raw.accounts
type: ingestr
parameters:
source_connection: jobtread
source_table: 'accounts'
destination: snowflake
incremental_strategy: merge$ bruin run assets/raw/jobtread.asset.yml
- extract · JobTread accountsincremental
- load · snowflake raw.accountsmerged
- checks · not_null, unique
Loaded and checked. Downstream models can run.
How it connects
Connected in three steps.
JobTread is a construction management platform that helps contractors manage jobs, estimates, invoices, budgets, tasks, and more.
- 01
Add a JobTread connection with its credentials.
- 02
Pick the tables to load and how: replace, append or merge.
- 03
Bruin runs it on your schedule and checks every load.
Connection parameters
- grantkey
- A grant key used to authenticate with the JobTread API.
- organizationid
- The ID of the organization to ingest data from.
Tables
17 tables, ready to load.
accountsjobscontactsdocumentstaskscostcodescosttypescostitemslocationscustomfieldsdailylogstimeentriesfilescommentsdocumentpaymentscostgroupsevents
The platform
Part of the Bruin platform.
Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.
01 · Move
02 · Model & govern
03 · Use
Real estate & field service
More tools, same category.
Frequently asked
Questions about JobTread.
Does Bruin have a built-in JobTread integration?
Yes. Built-in ingestr source.
Which JobTread tables can Bruin load?
accounts, jobs, contacts, documents, tasks, costcodes, costtypes, costitems, locations, customfields, dailylogs, timeentries, and 5 more.
Where can JobTread data go?
Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.
How fresh is the data?
As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.
Do we need Bruin Cloud?
No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.
Ready to connect JobTread?
$100 in credits and 50 AI tasks. No credit card.
A demo walks through your own data.