Sigma Computing
Connector for Sigma Computing — browse workbooks, elements, and data models, export analytics data, and manage members, teams, workspaces, and permissions.
Categories: Business Intelligence, Analytics, Data & Analytics
What you can ask
- Export the
Revenue by Regionworkbook element as CSV and post it to the finance channel. - List workbooks shared with the
Salesteam and flag ones untouched in 90 days. - Add a new analyst to the right workspace and team with view permissions.
Set up
Sigma Computing connects with credentials from your Sigma Computing account. Have these values ready:
- API base URL
- Client ID
- Client secret
- Go to Organization > Connectors and find Sigma Computing.
- Click Enable and choose which tools to allow.
- Each member enters their own values the first time they use it.
To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.
Tools
Sigma Computing offers 95 tools. Admins choose which ones agents can use. See Tool permission groups.
Read (64)
View and search information without changing it.
| Tool | What it does |
|---|---|
download_query | Download the result of an export started by export_workbook or export_report, using the query_id those tools return. |
get_connection | Get a warehouse connection by ID, including its type, host, and write-back setting. |
get_current_user | Get the member the API credentials act as, returning user_id and organization_id. |
get_data_model | Get a data model by ID, including its name, folder path, owner, and latest version. |
get_element_lineage | Get the lineage of one workbook element, tracing it back to its sources. |
get_element_query | Get the warehouse SQL Sigma generates for one workbook element. |
get_file | Get a file (inode) by ID, including its type, folder path, owner, and the caller's permission on it. |
get_grant | Get a permission grant by ID. |
get_member | Get a member by ID, including their account type and home_folder_id. |
get_report | Get a report by ID, including its name, folder path, owner, and latest version. |
get_report_element_query | Get the warehouse SQL Sigma generates for one report element. |
get_team | Get a team by ID, including its description and visibility. |
get_template | Get a workbook template by ID, including its name, path, and latest version. |
get_user_attribute | Get a user attribute by ID, including its type and default value. |
get_workbook | Get a Sigma workbook by ID, including its name, folder path, owner, and latest_version. |
get_workbook_schema | Get the full schema of a workbook: every element plus all columns with types and formulas. |
get_workspace | Get a workspace by ID. |
list_account_types | List the organization's account types (license tiers), built-in and custom. |
list_connection_paths | List the browsable paths (databases, schemas, tables) available in warehouse connections. |
list_connections | List the warehouse connections configured in Sigma (Snowflake, BigQuery, Databricks, and so on). |
list_data_model_columns | List columns for every element in a data model, with labels, formulas, and data types. |
list_data_model_elements | List the elements (tables and joins) in a data model. |
list_data_model_lineage | List the lineage graph for a data model, tracing it back to warehouse tables. |
list_data_model_sources | List the warehouse tables and other sources a data model reads from. |
list_data_models | List Sigma data models — the governed, reusable datasets that workbooks build on. |
list_element_columns | List the columns of one workbook element, with labels, formulas, and data types. |
list_files | Browse the Sigma file tree: workspaces, folders, workbooks, data models, and reports. |
list_grants | List permission grants. |
list_member_favorites | List the documents a member has favorited. |
list_member_files | List the files a member can access, filterable by name, inode type, or parent folder. |
list_member_recent_files | List a member's recently viewed files, most recent first. |
list_member_schedules | List the scheduled exports owned by a member. |
list_member_teams | List the teams a member belongs to. |
list_members | List members (users) in the Sigma organization. |
list_report_columns | List columns for every element in a report, each tagged with its element_id. |
list_report_controls | List a report's controls (filters and parameters). |
list_report_elements | List the elements in a report. |
list_report_pages | List the pages in a report. |
list_report_sources | List the data sources a report reads from. |
list_reports | List Sigma reports — the paginated, print-oriented documents. |
list_tag_workbooks | List the workbooks pinned to a version tag. |
list_tags | List the organization's version tags, used to pin published document versions (for example 'Production'). |
list_team_members | List the members of a team. |
list_teams | List teams in the Sigma organization. |
list_templates | List workbook templates available in the organization, including Sigma's samples. |
list_user_attributes | List the organization's user attributes, used to drive row-level security and dynamic content. |
list_workbook_bookmarks | List the saved views (bookmarks) on a workbook. |
list_workbook_columns | List columns for every element in a workbook in one call, each tagged with its element_id. |
list_workbook_controls | List a workbook's controls (filters and parameters). |
list_workbook_elements | List every element (table, chart, control, text, image) in a workbook, across all pages. |
list_workbook_lineage | List the lineage graph for a workbook: warehouse tables, data models, and elements with their upstream source IDs. |
list_workbook_page_elements | List the elements on one workbook page. |
list_workbook_pages | List the pages (tabs) in a workbook. |
list_workbook_queries | List the generated warehouse SQL for every element in a workbook. |
list_workbook_schedules | List the scheduled exports configured on a workbook. |
list_workbook_sources | List the data sources a workbook reads from (tables, data models, other workbooks). |
list_workbook_tags | List the version tags applied to a workbook. |
list_workbook_versions | List a workbook's published version history with publish times and authors. |
list_workbooks | List Sigma workbooks the credentials can access, newest first. |
list_workspace_grants | List the members and teams granted access to a workspace, with their permission levels. |
list_workspaces | List workspaces in the Sigma organization. |
read_query_text | Read an export as text; prefer over download_query to READ. |
test_connection | Test whether Sigma can reach a warehouse connection. |
validate_credential | Validate the Sigma client ID, client secret, and API base URL by fetching the current member. |
Write (16)
Create or send data.
| Tool | What it does |
|---|---|
add_favorite | Favorite a document for a member. |
copy_workbook | Duplicate a workbook into a destination folder. |
create_file | Create a workspace, folder, workbook, or report. |
create_grant | Grant a member or team access to any inode (folder, workbook, data model, table). |
create_member | Create a member in the Sigma organization. member_type is an account type name — call list_account_types first, since custom account types vary per organization. |
create_tag | Create a version tag. |
create_team | Create a team, optionally seeding it with members and creating a shared team folder. |
create_workbook | Create an empty workbook in a folder. folder_id is required — get one from list_files with type_filters=['folder'], or a member's home_folder_id from get_member. |
create_workbook_bookmark | Create a saved view (bookmark) on a workbook, reusing the exploration of an existing one. |
create_workbook_from_template | Create a workbook from a template and return its workbook_id for the workbook tools. |
create_workbook_grant | Grant a member or team access to a workbook at the view, explore, or edit level. |
create_workspace | Create a workspace to hold shared folders and documents. |
create_workspace_grant | Grant a member or team access to a workspace at the view, explore, organize, or edit level. |
export_report | Start a PDF export of a report and return a query_id to pass to download_query. |
export_workbook | Start an export of a workbook element or page and return a query_id. |
remove_favorite | Remove a document from a member's favorites. |
Delete or overwrite (15)
Remove or replace existing data.
| Tool | What it does |
|---|---|
deactivate_member | Deactivate a member, revoking their access while preserving their content. |
delete_file | Archive a file (workbook, folder, data model, or report) by inode ID, moving it to the trash along with a folder's contents. |
delete_grant | Revoke a permission grant. |
delete_tag | Delete a version tag. |
delete_team | Delete a team permanently. |
delete_workbook_bookmark | Delete a saved view (bookmark) from a workbook. |
delete_workspace | Delete a workspace permanently, along with the documents it contains. |
delete_workspace_grant | Revoke a member's or team's access to a workspace. |
tag_workbook | Apply a version tag to a published workbook version. 'tag' is the tag NAME, not its ID — call list_tags and use the 'name' field, or create_tag to make a new one. |
update_file | Rename a file, change its description, move it to another folder via parent_id, transfer ownership, or restore it from the archive with restore=true. |
update_member | Update a member's name, email, or account type, or deactivate them with is_archived=true. |
update_tag | Update a version tag's name, description, or color. |
update_team | Update a team's name, description, or visibility. |
update_team_members | Add or remove members on a team in one call. |
update_workspace | Rename a workspace. |