Back to plugin list
Official
Okta
The CloudQuery Okta plugin extracts data from your Okta domain and loads it into any supported CloudQuery destination
Publisher
cloudquery
Repositorygithub.com
Latest version
v4.1.3
Type
Source
Platforms
Date Published
Mar 12, 2024
Price
Free
Set up process
Overview
Okta Source Plugin
The CloudQuery Okta plugin extracts data from your Okta domain and loads it into any supported CloudQuery destination (e.g. PostgreSQL, BigQuery, Snowflake, and more).
Authentication
To authenticate CloudQuery with your Okta account you need to add Okta API token to the configuration.
Configuration
The following example sets up the Okta plugin, and connects it to a postgresql destination:
kind: source
spec:
# Source spec section
name: okta
path: cloudquery/okta
registry: cloudquery
version: "v4.1.3"
tables: ["*"]
destinations: ["postgresql"]
spec:
# required, Okta domain name, for example: https://example.okta.com, https://example.okta-emea.com, https://example.oktapreview.com
domain: "${OKTA_DOMAIN}"
# required, Okta Token to access API
token: "${OKTA_ACCESS_TOKEN}"
# Optional. Rate limiter settings
# rate_limit:
# max_backoff: 5s
# max_retries: 3
domain
(string
) (required)Specify the Okta domain you are fetching from. Visit this link to find your Okta domain.token
(string
) (required)Token for Okta API access.debug
(bool
) (optional) (default:false
)Enables debug logs within the Okta SDK.concurrency
(integer
) (optional) (default:10000
)Number of concurrent requests to be made to Okta API.- Rate limit configuration.
Rate limit spec
max_backoff
(duration
) (optional) (default:30s
)Max backoff interval to be used. If the value specified is less than the default one, the default one is used.max_retries
(integer
) (optional) (default:2
)Max retries to be performed. If the value specified is less than the default one, the default one is used.
Example Queries
List all users in Okta
select
id,
profile->>'firstName' as first_name,
profile->>'lastName' as last_name,
profile->>'email' as email,
status
from okta_users;
List all active users
select
id,
profile->>'firstName' as first_name,
profile->>'lastName' as last_name,
profile->>'email' as email,
status from okta_users
where
status = 'ACTIVE';
List active Okta applications
select
id,
name
from
okta_applications
where status = 'ACTIVE';
List active Okta applications, ordered by number of users
select
a.id,
a.name,
a.status,
count(u)
from okta_applications a
left join okta_application_users u
on u.app_id = a.id
group by a.id, a.name
order by count desc;