Sigma Integration Discovered Resources

Overview

The Sigma integration discovers the following resources:

  • Sigma Account

  • Sigma Folder (Workspaces and Folders)

  • Sigma Data Model

  • Sigma Workbook

  • Sigma Element

  • Data Warehouse Tables (referenced by workbooks)

Sigma Account

A single resource of type sigma_account is observed for each configured Sigma integration, representing the top-level Sigma organization.

Properties

Property
Value

name

The organization name, or "Sigma Account ({organization_id})" if the name is not available

type

always sigma_account

subtype

always sigma_account

native_id

The Sigma organization ID

container_type

always pure_container

external_links

List of links to open this resource in Sigma. See External links below.

Many Sigma resources expose an external_links property so API and UI consumers can offer โ€œopen in Sigmaโ€โ€“style actions. This property is a list of link objects. Each object has:

Field
Type
Description

label

string

Display label for the link (e.g. "Open in Sigma", "Sigma Account").

url

string

URL that opens the resource in the Sigma web application.

Where it appears:

  • sigma_account: Typically one link with label "Sigma Account" pointing to the organization in Sigma (e.g. https://app.sigmacomputing.com/{organization_name}).

  • sigma_folder: Link with label "Open in Sigma" to the folder in the Sigma UI (when a URL is available).

  • sigma_data_model: Link with label "Open in Sigma" to the data model.

  • sigma_workbook: Link with label "Open in Sigma" to the workbook.

  • sigma_element: Link with label "Open in Sigma" to the element within its workbook.

If the Sigma API does not provide a URL for the resource, external_links may be an empty list.

Sigma Folders and workspaces

Folders and workspaces are organizational containers in Sigma. Workspaces are top-level folders, while folders can be nested within workspaces or other folders.

Properties

Property
Value

name

The folder or workspace name

type

always sigma_folder

subtype

sigma_folder or sigma_workspace

native_id

The unique folder/workspace ID in Sigma

created_at

The timestamp when the folder was created

updated_at

The timestamp when the folder was last modified

created_by

The email address of the user who created the folder

updated_by

The email address of the user who last updated the folder

owner

The owner of the folder

external_links

Links to open the folder in Sigma. See External links.

Sigma Data Model

Data models are reusable semantic layers in Sigma that provide business-friendly views of data warehouse tables.

Properties

Property
Value

name

The data model name

type

always sigma_data_model

subtype

always sigma_data_model

native_id

The unique data model ID in Sigma

created_at

The timestamp when the data model was created

updated_at

The timestamp when the data model was last modified

created_by

The email address of the user who created the data model

updated_by

The email address of the user who last updated the data model

owner

The owner of the data model

tags

List of version tag names associated with the data model

external_links

Links to open the data model in Sigma. See External links.

Sigma Workbook

Workbooks are analytics documents in Sigma containing visualizations, tables, and analyses.

Properties

Property
Value

name

The workbook name

type

always sigma_workbook

subtype

always sigma_workbook

native_id

The unique workbook ID in Sigma

description

The workbook description, if provided

created_at

The timestamp when the workbook was created

updated_at

The timestamp when the workbook was last modified

created_by

The email address of the user who created the workbook

updated_by

The email address of the user who last updated the workbook

owner

The owner of the workbook

tags

List of version tag names associated with the workbook

external_links

Links to open the workbook in Sigma. See External links.

total_read_queries_14/30/60d

When integrated with a supported warehouse, the total read queries for the timeframe are propagated to the resource.

total_read_cost_14/30/60d

When integrated with Snowflake warehouse, the total read cost for the timeframe propagated to the resource.

total_read_credits_14/30/60d

When integrated with Snowflake, the total read credits for the timeframe propagated to the resource.

Sigma Element

Elements are individual components within a Sigma workbook, such as tables, visualizations, or calculations. Each element may contain SQL queries and can reference other elements or data warehouse tables.

Properties

Property
Value

name

The element name

type

always sigma_element

subtype

always sigma_element

native_id

The element ID in the format {workbook_uri}/{element_id}

external_links

Links to open the element in Sigma. See External links.

total_read_queries_14/30/60d

When integrated with a supported warehouse, the total read queries for the timeframe are propagated to the resource.

total_read_cost_14/30/60d

When integrated with Snowflake warehouse, the total read cost for the timeframe propagated to the resource.

total_read_credits_14/30/60d

When integrated with Snowflake, the total read credits for the timeframe propagated to the resource.

Data Warehouse Tables

When a Sigma workbook references a data warehouse table, Euno automatically observes that table if it hasn't been discovered yet.

Properties

Property
Value

name

The table name

type

always table

subtype

always table

database_technology

The data warehouse type

database

The database name

schema

The schema name

Relationships

Container Relationships

  • Sigma Account โ†’ Workspaces: Workspaces are top-level folders under the account

  • Workspaces โ†’ Folders: Folders can be nested within workspaces

  • Folders โ†’ Subfolders: Folders can contain other folders

  • Folders โ†’ Workbooks: Workbooks belong to folders

  • Sigma Account โ†’ Data Models: Data models are direct children of the account

  • Workbooks โ†’ Elements: Elements belong to workbooks

Lineage Relationships

  • Workbooks โ†’ Elements: Workbooks have their upstream set to their elements

  • Elements โ†’ Tables: Root elements (elements that directly reference a data warehouse table) has upstream set to the data warehouse tables

  • Elements โ†’ Elements: Non-root (elements that only reference other elements in the workbook) has upstream set to the elements they reference

  • Elements โ†’ Data Models: Elements that reference data models have the data models they reference added to their upstream

Column level lineage

  • Elements -> Table Columns: Root elements has upstream_fields set to the columns they reference in the upstream data warehouse tables

Last updated