Sigma Computing

Before you start

To connect Sigma to Select Star, you will need...

• Admin access to your Sigma account.

Complete the following steps to enable metadata, lineage, and popularity of your Sigma workbooks in Select Star.

1. Identify your Sigma API request URL

2. Generate API Client ID and Secret

3. Connect Sigma API to Select Star

1. Identify your Sigma API request URL

The URL Select Star uses to send API requests depends on the cloud your Sigma organization is hosted on.

View your Base URL in the Administration section of Sigma. Go to Administration > Developer Access > API base URL. Keep this information for the next steps.

2. Generate API client ID and secret

To generate API client credentials, you must be assigned the Admin account type.

1. From Sigma Home, open Administration, or click your user avatar to open the user menu and select Administration.

2. In the side panel, select Developer Access.

3. Click Create new to set up new credentials.

   1. The Create client credentials modal opens.

4. For Select scopes, select the REST API checkbox to enable the use of these credentials for the API.

5. For Name, enter a unique name to identify the credentials. For example, "Select Star".

6. [optional] For Description, enter a description of the purpose of the credentials. For example, "Token used to connect Select Star integration"

7. For Owner, set yourself as the owner, OR search for and select a member of your organisation with whom to associate the credentials.

   1. Note: The API secret uses the account type permissions assigned to this user.

   2. Select Star recommends selecting an Admin as the Owner in order to fetch all workbooks available in your Sigma instance.

8. Click Create to generate the credentials.

1. Copy the client ID and secret, and securely store them for the next steps.

3. Connect Sigma API to Select Star

Go to the Select Star Settings. Click Data in the sidebar, then + Add to create a new Data Source.

Choose Sigma in the Source Type dropdown and provide the following information:

• Display Name: This value is Sigma by default, but you can override it if desired.

• API Client ID: The API Client ID from step 2 above.

• API Client Secret: The API Secret Token from step 2 above.

• API Server: This is based on your Sigma cloud configuration. You need to use the API request URL from step 1 above.

• DB Connection: This is based on the database connection used in your Sigma instance.

• DB Username: This is the database user configured in your Sigma instance.