Skip to main content

sessions

Creates, updates, deletes, gets or lists a sessions resource.

Overview

Namesessions
TypeResource
Idokta.identity_sources.sessions

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe ID of the identity source session
createdstring (date-time)The timestamp when the identity source session was created
identitySourceIdstringThe ID of the custom identity source for which the session is created
importTypestringThe type of import. All imports are INCREMENTAL imports.
lastUpdatedstring (date-time)The timestamp when the identity source session was created
statusstringThe current status of the identity source session

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_identity_source_sessionsselectsubdomainLists all identity source sessions for the given identity source instance
get_identity_source_sessionselectsubdomainRetrieves an identity source session for a given identity source ID and session ID
create_identity_source_sessioninsertsubdomainCreates an identity source session for the given identity source instance
delete_identity_source_sessiondeletesubdomainDeletes an identity source session for a given identity source ID and session Id

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
subdomainstringThe domain of your organization. This can be a provided subdomain of an official okta domain (okta.com, oktapreview.com, etc) or one of your configured custom domains. (default: my-org)

SELECT examples

Lists all identity source sessions for the given identity source instance

SELECT
id,
created,
identitySourceId,
importType,
lastUpdated,
status
FROM okta.identity_sources.sessions
WHERE subdomain = '{{ subdomain }}' -- required;

INSERT examples

Creates an identity source session for the given identity source instance

INSERT INTO okta.identity_sources.sessions (
subdomain
)
SELECT
'{{ subdomain }}'
RETURNING
id,
created,
identitySourceId,
importType,
lastUpdated,
status
;

DELETE examples

Deletes an identity source session for a given identity source ID and session Id

DELETE FROM okta.identity_sources.sessions
WHERE subdomain = '{{ subdomain }}' --required;