Configure Connection to the Sigma BI Source

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

Configure the Sigma BI Source

This section describes configuring settings for credentials and connection information in the General Settings tab.

If your organization has configured Azure KeyVault or AWS Secrets Manager to hold such information, the user interface for the General Settings page will change to include the following icons to the right of most options:

By default, the database icon (right) is selected, as shown. In the vault case (lock icon on left), instead of the actual credential information, you enter the ID of the secret. See Configure Secrets for OCF Connector Settings for details.

Perform the configuration on the Settings page:

1. Specify the Application Settings:

   

Parameter	Description
Enable Raw Dump or Replay	The options in this drop list can dump the extracted metadata into files to debug extraction issues before ingesting the metadata into Alation. This feature can be used during testing if there are issues with MDE. It breaks extraction into two steps: first, the extracted metadata is dumped into files and can be viewed, and second, it can be ingested from the files into Alation. It is recommended to keep this feature enabled only if debugging is required. Enable Raw Metadata Dump: Select this option to save extracted metadata into a folder for debugging purposes. The dumped data will be saved in four files (attribute.dump, function.dump, schema.dump, table.dump) in folder opt/alation/site/tmp/ inside Alation shell. Enable Ingestion Replay: Select this option to ingest the metadata from the dump files into Alation. Off: Disable the Raw Metadata Dump or Replay feature. Extracted metadata will be ingested into Alation.
Disable Automatic Lineage Generation	Select the Disable Automatic Lineage Generation checkbox to skip the creation of automatic Lineage after extraction. When automatic Lineage generation is disabled, Alation does not calculate Lineage data for this BI source during extraction. For more information, see Disable Automatic Lineage Generation.
Disable Permission Enforcement	Leave this checkbox selected. Permission enforcement is not supported between Sigma and Alation
Server URI	Enter the server URI used to access Sigma. This should be your organization context root: https://app.sigmacomputing.com/organisation/ Note: The URL must include the final forward slash.

1. Click Save to save the information you have entered.

2. Specify Connector Settings:

   

Parameter	Description
Sigma Web URL	Specify the URL to access Sigma. This should match the Server URI parameter value entered in the Application Settings.
Sigma API URL	Specify the API URL to access Sigma APIs. The Sigma API URL used is specific to the cloud provider your Sigma instance is running on. Your Sigma Administrator should provide the cloud provider. See Sigma Cloud Provider Determination for the details. After the cloud provider is determined, use the following to determine your specific Sigma API URL: For GCP organizations, use: https://api.sigmacomputing.com/ For AWS US organizations, use: https://aws-api.sigmacomputing.com/ For AWS Canada organizations, use: https://api.ca.aws.sigmacomputing.com/ For AWS Europe organizations, use: https://api.eu.aws.sigmacomputing.com/ For Azure organizations, use: https://api.us.azure.sigmacomputing.com/
Sigma Client ID	Specify the Sigma client ID. See the Prerequisites page for details.
Sigma Client Secret	Specify the Sigma client secret. See the Prerequisites page for details.
Sigma OCF License Key	This can be left blank as no license key is currently required by this connector.
Proxy URL	Specify the URL to access Sigma via a proxy server. This optional field should be used only if the Sigma OCF connection occurs over a proxy. This field should be left blank for Alation Cloud Services customers.
Proxy Port	Specify the proxy port number. This optional field should be used only if the Sigma OCF connection occurs over a proxy. This field should be left blank for Alation Cloud Services customers.
Proxy Username	Specify the proxy server username. This optional field should be used only if the Sigma OCF connection occurs over a proxy. This field should be left blank for Alation Cloud Services customers.
Proxy Password	Specify the proxy server password. This optional field should be used only if the Sigma OCF connection occurs over a proxy. This field should be left blank for Alation Cloud Services customers.
Log Level	Select the log level to generate logs. The available options are INFO, DEBUG, WARN, TRACE, ERROR, FATAL, ALL.

4. Click Save to save the information you have entered.

5. Under Test Connection, click Test to validate network connectivity. If the test fails, double check all the above settings.