Hex

Usage Instructions

Integrate Hex into your workflow. Run projects, check run status, manage collections and groups, list users, and view data connections. Requires a Hex API token.

Tools

`hex_cancel_run`

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`projectId`	string	Yes	No description
`runId`	string	Yes	No description

Output

Parameter	Type	Description
`success`	boolean	Whether the run was successfully cancelled
`projectId`	string	Project UUID
`runId`	string	Run UUID that was cancelled

`hex_create_collection`

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`name`	string	Yes	No description
`description`	string	No	No description

Output

Parameter	Type	Description
`id`	string	Newly created collection UUID
`name`	string	Collection name
`description`	string	Collection description
`creator`	object	Collection creator
↳ `email`	string	Creator email
↳ `id`	string	Creator UUID

`hex_get_collection`

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`collectionId`	string	Yes	No description

Output

Parameter	Type	Description
`id`	string	Collection UUID
`name`	string	Collection name
`description`	string	Collection description
`creator`	object	Collection creator
↳ `email`	string	Creator email
↳ `id`	string	Creator UUID

`hex_get_data_connection`

Retrieve details for a specific data connection including type, description, and configuration flags.

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`dataConnectionId`	string	Yes	No description

Output

Parameter	Type	Description
`id`	string	Connection UUID
`name`	string	Connection name
`type`	string	Connection type (e.g., snowflake, postgres, bigquery)
`description`	string	Connection description
`connectViaSsh`	boolean	Whether SSH tunneling is enabled
`includeMagic`	boolean	Whether Magic AI features are enabled
`allowWritebackCells`	boolean	Whether writeback cells are allowed

`hex_get_group`

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`groupId`	string	Yes	No description

Output

Parameter	Type	Description
`id`	string	Group UUID
`name`	string	Group name
`createdAt`	string	Creation timestamp

`hex_get_project`

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`projectId`	string	Yes	No description

Output

Parameter	Type	Description
`id`	string	Project UUID
`title`	string	Project title
`description`	string	Project description
`status`	object	Project status
↳ `name`	string	Status name (e.g., PUBLISHED, DRAFT)
`type`	string	Project type (PROJECT or COMPONENT)
`creator`	object	Project creator
↳ `email`	string	Creator email
`owner`	object	Project owner
↳ `email`	string	Owner email
`categories`	array	Project categories
↳ `name`	string	Category name
↳ `description`	string	Category description
`lastEditedAt`	string	ISO 8601 last edited timestamp
`lastPublishedAt`	string	ISO 8601 last published timestamp
`createdAt`	string	ISO 8601 creation timestamp
`archivedAt`	string	ISO 8601 archived timestamp
`trashedAt`	string	ISO 8601 trashed timestamp

`hex_get_project_runs`

Retrieve API-triggered runs for a Hex project with optional filtering by status and pagination.

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`projectId`	string	Yes	No description
`limit`	number	No	No description
`offset`	number	No	No description
`statusFilter`	string	No	Filter by run status: PENDING, RUNNING, ERRORED, COMPLETED, KILLED, UNABLE_TO_ALLOCATE_KERNEL

Output

Parameter	Type	Description
`runs`	array	List of project runs
↳ `projectId`	string	Project UUID
↳ `runId`	string	Run UUID
↳ `runUrl`	string	URL to view the run
↳ `status`	string	Run status (PENDING, RUNNING, COMPLETED, ERRORED, KILLED, UNABLE_TO_ALLOCATE_KERNEL)
↳ `startTime`	string	Run start time
↳ `endTime`	string	Run end time
↳ `elapsedTime`	number	Elapsed time in seconds
↳ `traceId`	string	Trace ID
↳ `projectVersion`	number	Project version number
`total`	number	Total number of runs returned
`traceId`	string	Top-level trace ID

`hex_get_queried_tables`

Return the warehouse tables queried by a Hex project, including data connection and table names.

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`projectId`	string	Yes	No description
`limit`	number	No	No description

Output

Parameter	Type	Description
`tables`	array	List of warehouse tables queried by the project
↳ `dataConnectionId`	string	Data connection UUID
↳ `dataConnectionName`	string	Data connection name
↳ `tableName`	string	Table name
`total`	number	Total number of tables returned

`hex_get_run_status`

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`projectId`	string	Yes	No description
`runId`	string	Yes	No description

Output

Parameter	Type	Description
`projectId`	string	Project UUID
`runId`	string	Run UUID
`runUrl`	string	URL to view the run
`status`	string	Run status (PENDING, RUNNING, COMPLETED, ERRORED, KILLED, UNABLE_TO_ALLOCATE_KERNEL)
`startTime`	string	ISO 8601 run start time
`endTime`	string	ISO 8601 run end time
`elapsedTime`	number	Elapsed time in seconds
`traceId`	string	Trace ID for debugging
`projectVersion`	number	Project version number

`hex_list_collections`

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`limit`	number	No	No description
`sortBy`	string	No	No description

Output

Parameter	Type	Description
`collections`	array	List of collections
↳ `id`	string	Collection UUID
↳ `name`	string	Collection name
↳ `description`	string	Collection description
↳ `creator`	object	Collection creator
↳ `email`	string	Creator email
↳ `id`	string	Creator UUID
`total`	number	Total number of collections returned

`hex_list_data_connections`

List all data connections in the Hex workspace (e.g., Snowflake, PostgreSQL, BigQuery).

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`limit`	number	No	No description
`sortBy`	string	No	No description
`sortDirection`	string	No	No description

Output

Parameter	Type	Description
`connections`	array	List of data connections
↳ `id`	string	Connection UUID
↳ `name`	string	Connection name
↳ `type`	string	Connection type (e.g., athena, bigquery, databricks, postgres, redshift, snowflake)
↳ `description`	string	Connection description
↳ `connectViaSsh`	boolean	Whether SSH tunneling is enabled
↳ `includeMagic`	boolean	Whether Magic AI features are enabled
↳ `allowWritebackCells`	boolean	Whether writeback cells are allowed
`total`	number	Total number of connections returned

`hex_list_groups`

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`limit`	number	No	No description
`sortBy`	string	No	No description
`sortDirection`	string	No	No description

Output

Parameter	Type	Description
`groups`	array	List of workspace groups
↳ `id`	string	Group UUID
↳ `name`	string	Group name
↳ `createdAt`	string	Creation timestamp
`total`	number	Total number of groups returned

`hex_list_projects`

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`limit`	number	No	No description
`includeArchived`	boolean	No	No description
`statusFilter`	string	No	No description

Output

Parameter	Type	Description
`projects`	array	List of Hex projects
↳ `id`	string	Project UUID
↳ `title`	string	Project title
↳ `description`	string	Project description
↳ `status`	object	Project status
↳ `name`	string	Status name (e.g., PUBLISHED, DRAFT)
↳ `type`	string	Project type (PROJECT or COMPONENT)
↳ `creator`	object	Project creator
↳ `email`	string	Creator email
↳ `owner`	object	Project owner
↳ `email`	string	Owner email
↳ `lastEditedAt`	string	Last edited timestamp
↳ `lastPublishedAt`	string	Last published timestamp
↳ `createdAt`	string	Creation timestamp
↳ `archivedAt`	string	Archived timestamp
`total`	number	Total number of projects returned

`hex_list_users`

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`limit`	number	No	No description
`sortBy`	string	No	No description
`sortDirection`	string	No	No description
`groupId`	string	No	No description

Output

Parameter	Type	Description
`users`	array	List of workspace users
↳ `id`	string	User UUID
↳ `name`	string	User name
↳ `email`	string	User email
↳ `role`	string	User role (ADMIN, MANAGER, EDITOR, EXPLORER, MEMBER, GUEST, EMBEDDED_USER, ANONYMOUS)
`total`	number	Total number of users returned

`hex_run_project`

Execute a published Hex project. Optionally pass input parameters and control caching behavior.

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`projectId`	string	Yes	No description
`inputParams`	json	No	JSON object of input parameters for the project (e.g., {"date": "2024-01-01"})
`dryRun`	boolean	No	No description
`updateCache`	boolean	No	No description
`updatePublishedResults`	boolean	No	No description
`useCachedSqlResults`	boolean	No	No description

Output

Parameter	Type	Description
`projectId`	string	Project UUID
`runId`	string	Run UUID
`runUrl`	string	URL to view the run
`runStatusUrl`	string	URL to check run status
`traceId`	string	Trace ID for debugging
`projectVersion`	number	Project version number

`hex_update_project`

Update a Hex project status label (e.g., endorsement or custom workspace statuses).

Input

Parameter	Type	Required	Description
`apiKey`	string	Yes	No description
`projectId`	string	Yes	No description
`status`	string	Yes	No description

Output

Parameter	Type	Description
`id`	string	Project UUID
`title`	string	Project title
`description`	string	Project description
`status`	object	Updated project status
↳ `name`	string	Status name (e.g., PUBLISHED, DRAFT)
`type`	string	Project type (PROJECT or COMPONENT)
`creator`	object	Project creator
↳ `email`	string	Creator email
`owner`	object	Project owner
↳ `email`	string	Owner email
`categories`	array	Project categories
↳ `name`	string	Category name
↳ `description`	string	Category description
`lastEditedAt`	string	Last edited timestamp
`lastPublishedAt`	string	Last published timestamp
`createdAt`	string	Creation timestamp
`archivedAt`	string	Archived timestamp
`trashedAt`	string	Trashed timestamp

On this page