Hex

31 tools available

Hex is a collaborative data workspace that combines SQL, Python, and R notebooks for analytics and data science

Connect Hex to Definable to answer ad-hoc analytics questions, detect anomalies, auto-generate weekly summaries. Personas call Hex's 31 tools directly from chat or scheduled flows. Plug into a data-analysis persona to ask questions in plain English — the agent runs the queries.

Common workflows with Hex

Weekly anomaly digest

Query metrics from this tool
Compare against rolling baseline
Surface anomalies with reasoning

Funnel deep-dive

Pull funnel events for a date range
Compute drop-offs at each step
Generate a written analysis

Cohort answers on demand

User asks a question in chat
Agent translates it to a query
Returns numbers + a chart-ready summary

Hex actions 31

Every Hex action below is a callable tool any Definable persona can invoke.

Cancel Run

Tool to cancel a project run that is in progress. Use when you need to stop a currently executing Hex project run before it completes.

Create Cell

Tool to create a new cell in the draft version of a Hex project. Use when adding CODE or SQL cells to a project. Only CODE and SQL cell types are supported. Requires EDIT_PROJECT_CONTENTS permission.

Create Collection

Tool to create a new collection in the Hex workspace. Use when you need to organize projects and resources into a collection.

Create Group

Tool to create a new group in the Hex workspace. Use when you need to organize users into groups for collaboration and access control.

Deactivate User

Deactivates a user in the Hex workspace. Use this when you need to deactivate a user by their ID.

Delete Cell

Permanently delete a cell from the draft version of a project. Requires EDIT_PROJECT_CONTENTS permission. Use when you need to remove a cell from a Hex project's draft.

Delete Group

Deletes a group from the Hex workspace. Use this when you need to permanently remove a group by its ID.

Delete Guide Draft

Deletes a guide draft by ID from Hex. Use this when you need to permanently remove a draft guide.

Edit Collection

Tool to edit a collection's name, description, and sharing settings in Hex. Use when you need to update collection metadata or change sharing permissions.

Edit Group

Tool to edit a group's name and/or members in Hex. Use when you need to update group details, add users to a group, or remove users from a group.

Edit Project Sharing Collections

Tool to add a project to collections or remove it from collections. Use when you need to update project sharing by adding or modifying collection access. Workspace tokens need Collections -> Write access scope in addition to Projects -> Write access scope.

Edit Project Sharing Groups

Tool to edit project sharing settings for groups in Hex. Use when you need to add or modify group access to a project. Supports up to 25 groups per request.

Edit Project Sharing Settings

Tool to edit project sharing settings for workspace members and public web access. Use when you need to control who can access a Hex project and what permissions they have.

Edit Project Sharing Users

Tool to edit project sharing settings for individual users in Hex. Add or modify user access to a project by specifying access levels (NONE, APP_ONLY, CAN_VIEW, CAN_EDIT, FULL_ACCESS). Use when you need to grant or update project permissions for specific users. Maximum 25 users per request.

Get Cell

Tool to get a single cell by ID from the draft version of a Hex project. Use when you need to retrieve cell details including source contents for CODE and SQL cells. Returns complete cell information including cell type, contents, and associated metadata.

Get collection

Tool to get information about a specific collection in Hex. Returns collection details including name, description, creator, and sharing settings. Use when you need to retrieve metadata about a collection by its ID.

Get Group

Tool to retrieve information about a specific Hex group. Use when you need to get details about a group including its ID, name, and creation date.

Get Project

Tool to get metadata about a single Hex project. Use when you need to retrieve project details including title, description, creator, owner, status, categories, analytics, schedules, and sharing information.

Get Project Runs

Tool to retrieve the status of API-triggered runs for a specific Hex project. Use when you need to check the execution status, timing, or history of project runs. Returns a paginated list of runs with detailed status information.

Get Run Status

Tool to retrieve the status of a specific Hex project run. Use when you need to check the current state, timing, or completion status of a project execution. Returns detailed information including start/end times, elapsed time, status, and notification details.

List Cells

Tool to list all cells from the draft version of a Hex project. Use when you need to retrieve cells with source code for SQL and CODE cells. Returns paginated results with cell details including type, label, and contents.

List Collections

Tool to retrieve all collections in the workspace with pagination support. Use when you need to list or discover available collections.

List Data Connections

Tool to list all data connections in the Hex workspace with pagination support. Use when you need to retrieve, browse, or audit data connections configured in Hex. Supports filtering by sort criteria and cursor-based pagination for large result sets.

List groups

Tool to list all groups in the Hex workspace with pagination support. Use when you need to retrieve groups with optional sorting and pagination.

List Hex Projects

Tool to list all viewable Hex projects with pagination and filtering support. Use when you need to retrieve projects sorted by creation date or filter by status, categories, creator, owner, or collection.

List Users

Tool to list all users in the Hex workspace with pagination support. Returns user details including names, emails, roles, and last login dates. Use when you need to retrieve users, filter by group, or paginate through large user lists.

Publish Guide Drafts

Tool to publish all currently drafted guides or specific guides by ID. Use when you need to make draft guides publicly available. Specify either publishAllDraftGuides=true or provide specific guide IDs.

Run Project

Tool to trigger a run of the latest published version of a Hex project. Use when you need to execute a project programmatically. Rate limited to 20 requests per minute and 60 requests per hour.

Update Cell

Tool to update a cell's source code and/or data connection in Hex. Use when you need to modify the contents of a code cell or SQL cell. Requires EDIT_PROJECT_CONTENTS permission.

Update Project Status

Tool to add or remove a status (including endorsements) from a Hex project. Use when you need to update the project's status or remove an existing status by setting it to null.

Upsert Guide Draft

Tool to update or create guide drafts by filePath. Creates a new guide if it doesn't exist, creates a draft if the guide exists without a draft, or updates an existing draft. Use when you need to programmatically manage guide content in Hex.

Frequently asked questions

What can I automate with Hex on Definable?

Anything Hex exposes through its API. Common analytics workflows on Definable include answer ad-hoc analytics questions, detect anomalies, auto-generate weekly summaries. Personas can call any of the 31 Hex tools directly, then chain the result into another integration without you writing code.

How does Hex authentication work?

Hex uses API_KEY on Definable. You connect once from the integrations page, scoped to the permissions you choose, and from then on any persona that has the integration enabled can act on your behalf. Tokens are encrypted at rest and rotated automatically.

Is the Hex integration included in my Definable plan?

Yes — every Definable plan, including Starter, includes access to all 31 Hex tools. You only need a separate Hex subscription if Hex itself charges per seat or per API call.

Is using Hex through Definable secure?

Every call from a persona to Hex is logged with the user, persona, prompt, and response. Tokens never leave Definable's secrets vault, scopes are configurable per persona, and you can revoke access at any time from the integration page.

How do I get started with Hex on Definable?

Sign up for Definable, open the integrations page, find Hex, and connect via OAuth or API key. You can immediately attach Hex to any persona and start running workflows. The free Starter plan includes 5,000 credits/month.

What Hex actions does Definable expose?

Definable exposes all 31 Hex actions as callable tools — including `Cancel Run`, `Create Cell`, `Create Collection`, plus 28 more. Each tool gets a typed parameter schema so personas know exactly how to call it.

Ready to automate with Hex?

Wire it up in minutes. No coding required.

Start for free Schedule a demo

← All integrations