Response Schema

The table below outlines the response schema for all integration configurations.

Property	Description
id number	The unique identifier of the integration.
status string	The status of the integration. Statuses include createError, creating, deleteError, deleting, editError, editing, enabled, migrateError, and migrating. See the statuses table below for descriptions.
validationResults object	The results of the validation tests. See the object description for details.
config object	The integration configuration. See the integration configuration payload for Amazon S3, Azure Synapse Analytics, Databricks Unity Catalog, Google BigQuery, Redshift, or Snowflake for details.

Integration statuses

The status property in the response schema shows the status of the integration. The table below provides definitions for each status and the state of the integration configuration.

Status	Description	State
createError	Error occurred during creation of the integration.	In use
creating	Integration is in the process of being created and set up.	In use
deleted	Integration is deleted.	Not in use
deleteError	Error occurred while deleting the integration. The integration has been rolled back to the previous state.	In use
deleting	Integration is in the process of being disabled or deleted.	In use
disabled	Integration was force disabled and no cleanup was performed on the remote platform.	Not in use
editError	Error occurred while editing the integration. The integration has been rolled back to the previous state.	In use
editing	The integration is in the process of being edited.	In use
enabled	The integration is enabled and active.	In use
migrateError	Error occurred while performing a migration of the integration. The integration has been rolled back to the previous state.	In use
migrating	Migration is being performed on the integration. An example of a migration is a stored procedure update.	In use
recurringValidationError	Validation has failed during the periodic check and the integration may be misconfigured.	In use

Validation results object

The validationResults object provides details about the status of each test Immuta runs to validate the the integration configuration.

Attribute	Description	Possible values
status string	Whether or not the connection validation passed.	passed failed warning skipped
validationTests array[]	This array includes the validation tests run on the integration connection.	-
validationTests.name string	The name of the validation test.	See the section corresponding to your integration type for a list of test names and messages: Azure Synapse Analytics Databricks Unity Catalog Google BigQuery Redshift Snowflake
validationTests.status string	The status of the validation test.	passed failed warning skipped
validationTests.message string	When a test fails, the message provides context and guidance for addressing the failure.	See the section corresponding to your integration type for a list of test names and messages: Amazon S3 Azure Synapse Analytics Databricks Unity Catalog Google BigQuery Redshift Snowflake

Amazon S3 validation tests

The table below provides the errors and messages for validation tests that fail when configuring or updating the integration.

Test name	Description	Message
There is no existing integration matching this configuration	Verifies that the integration configuration does not match an existing one.	-
The provided integration name is unique across Immuta S3 integrations	Verifies that the name of the integration does not match an existing S3 integration name.	"The Immuta service account does not end with expected value."
The provided access grants location role is a valid ARN format	Verifies that the access grants location role is in the correct format.	"The specified access grants location role is not a valid ARN format."
The provided AWS credentials allow fetching the caller's identity via the AWS STS API	Verifies that the integration can use the AWS STS API to get the caller's identity using the provided credentials.	"Found user ID [], ARN [] using STS."
An AWS Access Grants instance is configured in the provided AWS account and region	Verifies that an Access Grants instance has been created in the specified AWS account and region.	"AccessDenied: Unable to retrieve the access grants instance for account, region: AWS responded with code [403], name [AccessDenied] and message [Access Denied] for request ID []."
The provided S3 path exists and Immuta can list prefixes	Verifies that Immuta can access and list prefixes for the provided S3 path.	"Immuta does not have access to the requested path [s3://]. Without access, Immuta will be unable to assist with S3 path discovery during data source creation."
An AWS Access Grants location does not yet exist for the provided path	Verifies that an Access Grants location has not already been registered for the specified S3 path.	"AccessDenied: Unable to list S3 access grants locations for account [], location scope []: AWS responded with code [403], name [AccessDenied] and message [Access Denied] for request ID []."

Azure Synapse Analytics validation tests

The table below provides the errors and messages for validation tests that fail when configuring or updating the integration.

Test name	Description	Message
Initial validation: connect	Verifies that Immuta can connect to Azure Synapse Analytics.	"Unable to connect to host."
Initial validation: delimiters test	Verifies that the delimiters are unique.	"Hash delimiter and array delimiter must not have the same value."
Validate automatic: impersonation role does not exist	Verifies that the user impersonation role specified in the request payload does not already exist.	"Impersonation role already exists. If this role can be safely dropped please do so and try again. Alternatively, specify a different role name."
Validate Immuta system user can manage database	Verifies that the specified user can manage the database.	"User does not have permission to manage database."

Databricks Unity Catalog validation tests

The table below provides the errors and messages for validation tests that fail when configuring or updating the integration.

Test name	Description	Message
Basic connection test	Verifies that Immuta can connect to Databricks Unity Catalog.	"Could not connect to host, please confirm you are using valid connection parameters."
Manual catalog setup	Verifies that the catalog and tables used by Immuta are present and have the correct permissions. This test is run when autoBootstrap is false in the Databricks Unity Catalog integration configuration.	"Encountered an error looking up catalog metadata for catalog."
Metastore validation	Verifies that the Unity Catalog metastore is assigned to the specified workspace.	"No metastore is assigned to workspace."

Google BigQuery validation tests

The table below provides the errors and messages for validation tests that fail when configuring or updating the integration.

Test name	Description	Message
Basic validation: connection can be made to BigQuery	Verifies that Immuta can connect to Google BigQuery.	"Could not connect to the remote BigQuery connection."
Basic validation: Immuta service account postfix	Verifies that the service account ends with the expected value of @<projectId>.iam.gserviceaccount.com.	"The Immuta service account does not end with expected value."
Basic validation: non-matching service account in key file	Verifies that the service account matches the one provided in the keyfile.	"The service account does not match the service account in the provided key file."
Basic validation: verify service account not being used for data source connection credentials	Verifies that credentials that have been used to create Google BigQuery data sources are not the same credentials used to configure the Google BigQuery integration.	"BigQuery doesn't support the reuse of service accounts for integrations that are currently being used for data sources."
Validate manual: [dataset - create]	Verifies that the custom role assigned to the service account has the permissions to create the dataset.	Message includes a permission warning.
Validate manual: [dataset - delete]	Verifies that the custom role assigned to the service account has the permissions to delete the Immuta-managed dataset.	Message includes a permission warning.
Initialize validation: [dataset - exists]	Verifies that this dataset does not already exist.	"An existing Immuta instance exists. Delete this dataset to continue."
Validate manual: [table - create]	Verifies that the custom role assigned to the service account has the permissions to create Immuta-managed tables.	Message includes a permission warning.
Validate manual: [table - delete]	Verifies that the custom role assigned to the service account has the permissions to delete Immuta-managed tables.	Message includes a permission warning.
Validate manual: [table - get]	Verifies that the custom role assigned to the service account has the permissions to get Immuta-managed tables.	Message includes a permission warning.
Validate manual: [table - insert]	Verifies that the custom role assigned to the service account has the permissions to insert rows in Immuta-managed tables.	Message includes a permission warning.
Validate manual: [table - update]	Verifies that the custom role assigned to the service account has the permissions to update Immuta-managed tables.	Message includes a permission warning.

Redshift validation tests

The table below provides the errors and messages for validation tests that fail when configuring or updating the integration.

Test name	Description	Message
Initial validation: basic connection test	Verifies that Immuta can connect to Redshift.	"Unable to connect to host."
Validate automatic: database does not exist	Verifies that the database specified in the request payload does not already exist.	"The database already exists. If this database can be safely dropped, please do so and try again. Alternatively, specify a different database name."
Validate automatic: impersonation role does not exist	Verifies that the user impersonation role specified in the request payload does not already exist.	"Impersonation role already exists. If this role can be safely dropped please do so and try again. Alternatively, specify a different role name."

Snowflake validation tests

The table below provides the errors and messages for validation tests that fail when configuring or updating the integration.

Test name	Description	Message
Initial validation: basic connection test	Verifies that Immuta can connect to the Snowflake database.	"Unable to connect to host."
Initial validation: default warehouse access test	Verifies that the default warehouse exists and that the Immuta system account user has permissions to act on the default warehouse specified.	"Unable to access default warehouse. If this was a manual installation, ensure that the user has been granted usage on the specified warehouse."
Initial validation: table grants role prefix is unique	Verifies that the prefix for Snowflake table grants does not already exist. If this prefix already exists, navigate to the Integration Settings section on the Immuta app settings page to disable Snowflake table grants, re-enable it, and then update the role prefix.	"The Snowflake table grants role prefix IMMUTA is used by another Immuta instance connected to the same Snowflake host. Please update the table grants role prefix for this Immuta instance and try again."
Initial validation: validate access to privileged role	Verifies that the privileged role exists and that it has been assigned to the Immuta system account user.	"User does not have access to the privileged role."
Validate automatic bootstrap user grants	Verifies the credentials of the user executing the Immuta bootstrap script in Snowflake.	-
Validate automatic: database does not exist	Verifies that the database specified in the request payload does not already exist.	"The database already exists. If this database can be safely dropped, please do so and try again. Alternatively, specify a different database name."
Validate automatic: impersonation role does not exist	Verifies that the user impersonation role specified in the request payload does not already exist.	"Impersonation role already exists. If this role can be safely dropped please do so and try again. Alternatively, specify a different role name."