ceven

Hex

Triggers complex data notebooks as part of a larger workflow, manages project permissions for team members, and synchronizes notebook outputs with your external reporting tools.

Try Hex in Ceven

Ask Ceven anything
Standard

Why use Ceven?

  1. AI native Hex integration

    • Describe the outcome and Ceven picks the right Hex calls, fills the parameters, and checks the result.
    • Structured, agent friendly tool schemas so each call runs reliably instead of by guesswork.
    • Rich coverage for reading, writing, and querying your Hex data, across all 31 of its actions.

  2. Managed auth

    • Built in OAuth with automatic token refresh and rotation.
    • One place to manage, scope, and revoke Hex access.
    • Per user and per environment credentials instead of shared keys.

  3. Agent optimized design

    • Actions are tuned from real success and error rates so reliability climbs over time.
    • Full execution logs so you always know what ran in Hex, when, and on whose behalf.
    • The agent pauses and asks when Hex is unclear instead of plowing ahead.

  4. Enterprise grade security

    • Fine grained access so you control which agents and people can reach Hex.
    • Least privilege by default, read scopes first and only the writes a workflow needs.
    • A full audit trail of every Hex action to support review and sign off.

Supported tools

Every action Ceven's agents can run on Hex, and when to use it.

Run Project
Use this when you need to execute the latest published version of a Hex project programmatically.
Get Run Status
Pull the current state, timing, and completion status of a specific project execution.
Update Cell
Use this to modify the source code or data connection within a code or SQL cell.
Create Cell
Add a new CODE or SQL cell to the draft version of a project.
List Hex Projects
Retrieve all viewable projects, optionally filtered by status, category, or owner.
Edit Project Sharing Users
Use this to add or modify access levels for specific users on a project.
Publish Guide Drafts
Make specific draft guides or all current drafts publicly available as apps.
Get Project
Pull metadata for a single project including its description, owner, and schedules.
Cancel Run
Stop a project run that is currently in progress before it completes.
List Data Connections
Retrieve and audit all configured data connections in the workspace.
Edit Project Sharing Groups
Use this to modify group access levels for a specific project.
Upsert Guide Draft
Create or update a guide draft based on a file path.
List Users
Pull a list of workspace users including their roles and last login dates.
Create Collection
Organize projects and resources into a new named 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 -> Wri
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.
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 assoc
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 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.
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 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.

30 actions · scroll to see them all

Frequently asked questions

Ceven monitors the API response codes from Hex to ensure your workflows stay within boundaries. It is important to note that Hex imposes a rate limit of 20 requests per minute and 60 requests per hour for triggering project runs via the API. If a Ceven workflow attempts to trigger runs faster than this, the agent will automatically queue the requests and implement an exponential backoff strategy. You will see a warning in your workflow logs if you are consistently hitting these limits, allowing you to optimize your trigger frequency or contact Hex to discuss higher tier limits for your workspace.
Yes, Ceven can modify the source code of cells within the draft version of a project using the Update Cell action. This is particularly useful for dynamically updating SQL queries or Python variables based on data from another tool. For example, you can pull a list of high value customers from Salesforce and inject those IDs directly into a Hex SQL cell before triggering a run. Note that these changes happen in the draft layer, meaning you must use the Publish Guide Drafts action if you want those logic changes to be reflected in the public facing version of your data app.
To operate effectively, the connected workspace token requires specific scopes based on the actions you use. For basic project execution, read access to projects is sufficient. However, if you want Ceven to manage your notebooks, you must grant EDIT_PROJECT_CONTENTS permissions. This allows the agent to create, update, or delete cells. For organization tasks, the token needs Write access to Collections. We recommend using a dedicated service account in Hex with the minimum permissions required for your specific workflows to maintain a strong security posture and a clear audit trail of all automated changes.
Ceven does not just trigger a run and forget it. The agent uses the Get Run Status tool to poll the Hex API until the project reaches a terminal state. If the status returns as failed, Ceven can trigger a failure branch in your workflow. This allows you to send an alert to the data engineering team via PagerDuty or Slack, including the run ID and timestamp. You can also configure the agent to attempt a retry once or to revert the most recent cell update if the failure happened immediately after a code change.
Yes, Ceven can handle the administrative overhead of project sharing. By using the Edit Project Sharing Users and Groups actions, you can automate access control. For instance, when a new employee is added to your HR system, Ceven can automatically add them to the relevant Hex groups and grant them view access to the standard company dashboards. It can also remove access for deactivated users by calling the Deactivate User tool, ensuring that sensitive data remains secure and that your user seat count stays optimized without manual auditing.
Currently, the Hex API focuses on managing the contents and execution of existing projects rather than the creation of entirely new project shells from scratch. Ceven can create cells, update code, and manage sharing within a project, but it cannot instantiate a brand new project file. The best practice is to create a template project in Hex manually, and then use Ceven to duplicate the logic or update the parameters of that template for different clients or time periods by modifying the cells and saving the results.
Ceven interacts with the backend of Hex rather than the frontend UI. It cannot click buttons or move sliders on a published Hex app as a human would. Instead, it achieves the same result by updating the underlying cell values or parameters in the draft version and then triggering a new run. If you have a widget that filters a report by region, Ceven updates the region variable in the Python or SQL cell and runs the project, which generates the specific view you need for your downstream automation.
Ceven focuses on the orchestration layer, meaning it manages the execution and the metadata of the run. When a Hex project completes, the agent can pull the run status and metadata. For the actual data frames, Ceven encourages the use of Hex's native data export capabilities or writing the results to a data warehouse. Once the data is in your warehouse, Ceven can then trigger the next step in your workflow, such as sending a summary of those results to a stakeholder or updating a record in your CRM.

Alternatives to Hex

Other tools that solve a similar problem. Ceven supports these too, so you can switch or run more than one at once.

Deepnote logoDeepnoteJupyter AI logoJupyter AIObservable logoObservableDatabricks logoDatabricks

Try Ceven on your stack

Plug Ceven on top of the tools you already run. Connect Hex and the rest of your stack, describe the outcome, and its agents handle the work end to end, days of it in minutes.

Get started for free