Back to plugin list
okta
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


brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync okta.yml postgresql.yml

3. Run the sync

CloudQuery sync

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 (Rate limit spec) (optional) (default: see rate limit spec defaults)
    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;


Subscribe to product updates

Be the first to know about new features.