DeltaStream
Search
K

CREATE SECURITY INTEGRATION

Syntax

CREATE SECURITY INTEGRATION [IF NOT EXISTS]
security_integration_name
WITH (security_integration_parameter = value [, ... ]);

Description

Security Integrations allow organizations to configure authentication and authorization mechanisms.

Arguments

security_integration_name

Specifies the name of the new Security Integration. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.

WITH (security_integration_parameter = value [, …​ ])

This clause specifies Security Integration parameters; see Security Integration Parameters below for more information.

Security Integration Parameters

Parameter Name
Description
type
Required. Type of Security Integration. Valid values: SCIM

SCIM Specific Parameters

Parameter Name
Description
scim.client
Optional. Type of SCIM client that will use the SCIM API. Valid values: OKTA
scim.run_as_role
Optional. The Role used to manage all Users and Custom Roles for the SCIM integration. Defaults: okta_skim_provisioner for OKTA client.

Examples

Create a OKTA SCIM security integration

The following creates a new SCIM Security Integration with name okta:
CREATE SECURITY INTEGRATION
"okta"
WITH (
'type' = SCIM,
'scim.client' = OKTA,
'scim.run_as_role' = okta_skim_provisioner
);
The command will output a URI and Token which will be used to configure an Okta App Integration.