Integrate Google BigQuery with LeanKit
About Google BigQuery
Querying massive datasets can be time-consuming and expensive without the right hardware and infrastructure. Google BigQuery solves this problem by enabling super-fast, SQL-like queries against petabytes of data using the processing power of Google’s infrastructure.
It’s a scalable, no-setup service that gives you real-time business insights about your data.
LeanKit is a kanban board management tool designed specifically for Lean that makes it easy to visualize and manage the workflow of various projects. It works by allowing users to analyze their work and see bottlenecks, waste, and areas of slowdown so that they can quickly address these issues and maximize their productivity.
Integrate Google BigQuery With LeanKit Today
Free 7-day trial. Easy setup. Cancel any time.
LeanKit's End Points
Follow card movements through various lanes and retrieve the IDs of the board, card, and lane. Additionally, monitor when a card enters and exits the lane. This allows you to track speed of movement for these cards and send that lane movement information to other relevant tools.
Receive data about all available cards, including both identification info - like the card ID, card title, parent card ID and parent card title - and more action-oriented analytics data, such as card priority, start time, planned finish date, and current lane. Use this endpoint to track insights about specific cards or make card data accessible in other integrated data sources.
Historic User Assignments
Get a card’s assignment history. This includes the assigned users’ IDs, names, and email as well as historical data about when the card was assigned. This helps gauge the efficiency of various users and understand the workflow speed of each card.
Current User Assignments
Request a list of who is assigned to which cards. This list includes both data about the cards themselves (card ID, priority, and type) and information about the assigned users, such as their name, email address, and user ID. Use this data to track a specific user’s progress with their cards and/or visualize where and why bottlenecks occur.
View a list of cards with custom fields and access an array of information about them, such as their card IDs and the ID, label, type, and value of the related custom fields. Then, use this endpoint to export custom field data into data sources that provide valuable insights about those fields.
Examine all accessible lanes and get both identification data - like lane ID, title, class and type - and data about how the lane is used, such as the lane’s policy, creation date, position, and WiP limit. Integrate this endpoint with endpoints like ‘Cards” and “Current User Assignments” to get more specific analytics about the efficiency of different lanes in your workflow.
See the board IDs, card IDs, and titles of all tags that are attached to cards in your LeanKit. Use these tags to track more specific data from integrated data sources. This will allow for better, more detailed organizational structures.