Use this connector to have Foundational scan and determine lineage and downstream impact for Sigma.
This setup should take about 15 minutes.
Permissions: You need to be a Sigma admin for some parts of this setup.
Configuring Sigma Connector
In order to provide Foundational access to Sigma, please follow the steps below:
1. Create New Account Type in Sigma for Foundational
First you have to create a user in Sigma that will be used by Foundational to access your Sigma metadata.
Sign in to Sigma Computing at: https://app.sigmacomputing.com/
Select Administration
Select Account Types
Select Create New Account Type
Enter a name for the account type:
Foundational Connector TypeCheck the following checkboxes:
View datasets (under Data Modeling)
View workbooks (under Documents)
Click on Create
2. Assign Existing Account or Create New Account
Foundational need an account in Sigma in order to access relevant Sigma metadata. You can either create a new account, or assign existing account for Foundational to access
Option 1: Create New Account
Select People from the left side bar
Click on the Invite People button
Enter the email address for the account
Select
Foundational Connector Typefrom the account type drop downClick Invite
Option 2: Assign Existing Account
Select People from the left side bar
Select the user you want to assign for Foundational
Click on the edit icon at the account type box
Select
Foundational Connector Typefrom the account type drop downClick on Confirm
3. Add account to all relevant teams
By default, accounts in Sigma only have access to the default workspace (there is always a default workspace in Sigma). However, other workspaces, will not be accessible by the account you created/assigned to Foundational.
The way to solve this is to add Foundational account to all of the existing teams within Sigma, as workspaces are assigned access to teams, and once Foundational account is part of those teams, it will be able to view the relevant workspaces.
Foundational account does not read your data, jsut the metadata of the workbooks.
Foundational need an account in Sigma in order to access relevant Sigma metadata. You can either create a new account, or assign existing account for Foundational to access
Sign in to Sigma Computing at: https://app.sigmacomputing.com/
Select Administration
Click on "Teams"
For each team:
Click on the team
Click on "Add Members"
Type the name/email of the account you created or assigned in the previous step, select it and click on "Add"
4. Create Client Key and Secret
Select Developer Access fron the left side bar
Click on Create New
Pick a name for the API Key
Assign an owner for the API Key
Click on Create
Write down the client id and secret created (we will use it in the subsequent step)
5. Configure Sigma Connector in Foundational
Sign in to https://app.foundational.io
Select Connectors from the left side bar
In the Connectors page, Click on Configure in the Sigma card
Click on Add New Sigma Account
Fill in the Client ID and Client Secret with the client id and secret you created in the previous step
Click on Save
That's it! You are all set, you should be able to see lineage from Sigma within a day