Sigma (beta)
Sigma is a BI analytics tool built for your cloud data warehouse.
Beta Feature
Beta features represent newly added features in the product, and there is a chance of incompatible changes that impact the API and functionality in subsequent releases as we approach a stable version. As such we will not provide any advanced notice of any deprecation of functionality related to beta features.
The Sigma integration for Validio is a credential configuration to fetch catalog and lineage information from Sigma to display in Validio Data Catalog and Data Lineage. The integration does not perform any updates or edits to Sigma.
Prerequisites for Integrating with Sigma
To connect Validio with your Sigma instance,
- Create a Sigma
Admin
account for the Validio user. The admin account type is required to fetch lineage relations of datasets and workbooks.- (Required) Grant the Validio user
Can view
access permissions on the tables in the warehouse you want to monitor. - (Recommended) Disable
Write access
for Connections on this account. You can find this setting in your Sigma Administration page > Connections > Write Access.
- (Required) Grant the Validio user
- In your Sigma Administration page, generate and store a Client ID and Client Secret (API token). These credentials should be associated with your
Admin
Validio user account in Sigma.
For more information, refer to Generate Client Credentials in Sigma documentation.
Add a Sigma Credential
To add a Sigma credential in Validio,
- Navigate to Credentials, and click + New Credential.
- Under Namespace, select a namespace to define where resources will be created and who can access it.
- Under Credential Type, select Sigma Credential.
- Fill in the configuration parameters for the credential. For more information, see Sigma Credential Parameters.
- Click Create.
Validio will perform a validation step to ensure that the Sigma account can be successfully accessed. If validation passes, Validio will automatically start fetching data and you will be able to view Sigma assets and their relationships in the Catalog (if selected) and Lineage pages. If validation fails, check that you provided the correct parameter values.
Sigma Credential Parameters
Field | Description |
---|---|
Name | The display name of your credential. |
Base URL | The base URL for the Sigma API server. |
Client ID | The client ID of your Sigma credentials. |
Client Secret | The client secret of your Sigma credentials. |
Use for Catalog | Check to use the credential to discover Sigma assets and relationships for catalog and lineage. |
View Sigma Assets in Catalog
To view the Sigma assets in Catalog, navigate to Catalog and select the BI Tools tab.
The Sigma assets are listed and organized by Name, source Type, Credential, Date, and Tags. To view more information about each asset, click on the row to open the details panel.
BI Tool Assets and Sources
Validio BI tool integrations are only credentials, and you cannot use them to create sources or convert their assets to sources.
For more information, see About Data Catalog.
View Sigma Relationships in Lineage
To view the Sigma assets in Lineage, navigate to Lineage . You can also open Lineage directly for a Sigma asset by clicking on the asset in the BI Tools list and clicking on the View in Lineage button in the side panel.
For more information, see About Data Lineage.
Updated 7 days ago