Connect Bamboo HR to your Definite lakehouse in minutes.
Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.
Everything Bamboo HR exposes, modeled and queryable.
Extracts HR data from BambooHR including the employee directory (names, titles, contact details), organizational structure (departments, divisions, job titles, locations), job and employment status history, employee assets, time off requests and who’s out (including holidays), profile photos, and fully customizable employee reports. This enables headcount and org structure analysis, workforce changes over time, PTO usage and coverage insights, and asset tracking.
Tables & streams
Core employee profiles including names, contact details, and org placement; enables headcount snapshots, workforce segmentation by role/location, and profile completeness analyses.
Reference lists for departments, divisions, job titles, locations, and employment statuses used as dimensions; supports org structure reporting and headcount by org, role, and location.
Historical changes to employment status (e.g., hired, active, terminated, leave); enables headcount over time, turnover/attrition, and growth trend analysis.
Changes to job information such as title, department, division, and location; supports promotion and transfer analysis, internal mobility, and organizational movement over time.
Time off requests and who’s out calendars, including holidays; enables PTO utilization, approval cycle metrics, coverage planning, and absence trends.
Records of equipment and assets assigned to employees; supports asset inventory tracking, assignment history, and compliance reporting.
Uses a BambooHR API token with HTTP Basic Auth (your API key as the username and any value as the password)
Requires a Bamboo HR account to connect.
Operational data, performance metrics, and business insights.
Three steps. One afternoon.
Authenticate Bamboo HR in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.
We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.
SQL, dashboards, or ask Fi in plain English. Your Bamboo HR data lives next to every other source — ready to join.
Build your own with the Definite SDK, or ask us — we add new connectors every week.
