CloudQuery News

Announcing the BambooHR Source Plugin

At CloudQuery, we're constantly adding new source plugins to streamline your data integration processes and enhance your data analytics capabilities.

What is BambooHR?

BambooHR is a leading HR software provider, designed to simplify and automate various HR tasks, including time-off tracking, employee records management, and performance reviews. It offers a user-friendly interface and robust features that support HR professionals in managing employee data efficiently.

CloudQuery’s New BambooHR Plugin

The BambooHR source plugin allows you to seamlessly ELT (Extract, Load, Transform) your data from BambooHR into any supported database destination. This integration enables you to perform advanced analytics and gain deeper insights into your HR data.

Example Queries

Here are some example queries you can run if you sync your data to PostgreSQL using CloudQuery to gain valuable insights into your company's time-off requests:

Monthly Breakdown of Time-Off Requests

SELECT DATE_TRUNC('month', TO_DATE(start, 'YYYY-MM-DD')) AS month, COUNT(*) AS count
FROM bamboohr_timeoff_requests
GROUP BY DATE_TRUNC('month', TO_DATE(start, 'YYYY-MM-DD'))
ORDER BY month;

Employees with the Most Approved Time-Off Requests

SELECT employee_id, COUNT(*) AS approved_count
FROM bamboohr_timeoff_requests
WHERE status->>'status' = 'approved'
GROUP BY employee_id
ORDER BY approved_count DESC;

Average Time-Off Amount per Request

SELECT AVG((amount->>'amount')::numeric) AS average_days_off
FROM bamboohr_timeoff_requests;

Integrating BambooHR with PagerDuty Data

One of the key benefits of using the BambooHR source plugin is the ability to join your HR data with other critical business data sources like AWS and PagerDuty. This integration allows you to create comprehensive views and gain insights that would otherwise be difficult to obtain.

For example, combining data from BambooHR and PagerDuty allows you to easily identify which employees were on-call during specific incidents and their corresponding time-off records. This is particularly useful for understanding incident response patterns and improving operational efficiency.

Summary

Integrating BambooHR with your database via the CloudQuery BambooHR source plugin centralizes your HR data and empowers you to extract meaningful insights effortlessly. By leveraging SQL queries, you can transform raw data into actionable intelligence, driving better decision-making and optimizing your HR processes. Furthermore, joining BambooHR data with AWS and PagerDuty data enhances your ability to manage incidents effectively.

Check out the BambooHR plugin docs to learn more.


Want to see CloudQuery in action? Schedule a demo with our team or check out the platform documentation to learn more.

Try CloudQuery yourself

Self-hosted, open source, and free to start. Or schedule a demo to see the managed version.

Related posts

CloudQuery News

Introducing CloudQuery Insights: Cloud Intelligence That Connects the Dots

CloudQuery Insights automatically surfaces connected signals across your cloud inventory: security findings, cost data, policy violations, and audit trails.

Joe Karlsson

Joe Karlsson

April 21, 2026

Cloud Infrastructure

CloudQuery News

Introducing the Nautobot Source Integration

Sync Nautobot DCIM inventory data to PostgreSQL, BigQuery, or Snowflake and query it with SQL alongside your cloud provider data.

Joe Karlsson

Joe Karlsson

March 19, 2026

CloudQuery News

CloudQuery Is Merging with Env Zero

A letter from CloudQuery CEO Yevgeny Pats on the merger with env zero and what it means for customers.

Yevgeny Pats

Yevgeny Pats

March 17, 2026

CloudQuery News

Security

Introducing the Zoom Source Integration

New CloudQuery Zoom source plugin: sync Zoom meeting, user, and webinar data into your database for compliance, analytics, and user access governance reporting.

Joe Karlsson

Joe Karlsson

February 2, 2026

CloudQuery News

Product News

New in CloudQuery: Tines + Semgrep integration, and native visualizations,

CloudQuery October 2025 updates: Tines and Semgrep integration for security orchestration, plus native visualization support in the CloudQuery Platform.

Chris Reuter

Chris Reuter

October 31, 2025

CloudQuery News

Product News

Security

Introducing Data Access Control for CloudQuery Platform

CloudQuery Platform RBAC: Control cloud asset access with SQL-based permissions. Map Azure AD/Okta groups to roles. Available now on all environments.

Joe Karlsson

Joe Karlsson

October 28, 2025

AI

CloudQuery News

Understand your cloud infra faster using natural language

CloudQuery unifies AWS, GCP, Azure, and SaaS configs into SQL tables. The new AI assistant lets you query your cloud inventory using natural language.

Chris Reuter

Chris Reuter

September 29, 2025

CloudQuery News

Find the Cloud Waste Contest

Win CloudQuery swag by finding cloud waste in our dataset. Sync AWS data with CloudQuery, solve 3 SQL challenges, get t-shirts, sweatshirts, and mugs.

Joe Karlsson

Joe Karlsson

September 25, 2025

AI

CloudQuery News

Generate CloudQuery Configuration with Natural Language

Generate CloudQuery config files from natural language prompts. Use AI to quickly create source and destination plugin configs without manual YAML editing.

Chris Reuter

Chris Reuter

September 23, 2025

Own your pipeline.
Own your data.