Okta
Prerequisites
- Created Okta account with added application on Add Application Page page. (change okta-domain to you'r domain received after complete registration)
Tables in the Okta connector
| No | Table Name | Columns | Primary Keys | Read Mode | Inc. Sync Keys | API Info |
|---|---|---|---|---|---|---|
| 1 | user_role_assignments | 9 | Full Refresh | |||
| 2 | resource_sets | 4 | Full Refresh, Incremental | |||
| 3 | group_role_assignments | 9 | Full Refresh | |||
| 4 | group_members | 12 | Full Refresh, Incremental | |||
| 5 | permissions | 4 | Full Refresh | API Reference | ||
| 6 | custom_roles | 5 | Full Refresh | |||
| 7 | groups | 8 | Full Refresh, Incremental | API Reference | ||
| 8 | logs | 16 | Full Refresh, Incremental | |||
| 9 | users | 12 | Full Refresh, Incremental | API Reference |
Table: user_role_assignments
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | lastUpdated | VARCHAR | |
| 2 | _links | VARCHAR | |
| 3 | created | VARCHAR | |
| 4 | resource-set | VARCHAR | |
| 5 | id | VARCHAR | |
| 6 | label | VARCHAR | |
| 7 | type | VARCHAR | |
| 8 | assignmentType | VARCHAR | |
| 9 | status | VARCHAR |
Table: resource_sets
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | _links | VARCHAR | |
| 2 | description | VARCHAR | |
| 3 | id | VARCHAR | |
| 4 | label | VARCHAR |
Table: group_role_assignments
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | lastUpdated | VARCHAR | |
| 2 | _links | VARCHAR | |
| 3 | created | VARCHAR | |
| 4 | resource-set | VARCHAR | |
| 5 | id | VARCHAR | |
| 6 | label | VARCHAR | |
| 7 | type | VARCHAR | |
| 8 | assignmentType | VARCHAR | |
| 9 | status | VARCHAR |
Table: group_members
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | lastLogin | VARCHAR | |
| 2 | lastUpdated | VARCHAR | |
| 3 | passwordChanged | VARCHAR | |
| 4 | _links | VARCHAR | |
| 5 | credentials | VARCHAR | |
| 6 | created | VARCHAR | |
| 7 | profile | VARCHAR | |
| 8 | statusChanged | VARCHAR | |
| 9 | id | VARCHAR | |
| 10 | type | VARCHAR | |
| 11 | activated | VARCHAR | |
| 12 | status | VARCHAR |
Table: permissions
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | lastUpdated | VARCHAR | |
| 2 | _links | VARCHAR | |
| 3 | created | VARCHAR | |
| 4 | label | VARCHAR |
Table: custom_roles
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | lastUpdated | VARCHAR | |
| 2 | _links | VARCHAR | |
| 3 | created | VARCHAR | |
| 4 | id | VARCHAR | |
| 5 | label | VARCHAR |
Table: groups
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | lastUpdated | VARCHAR | |
| 2 | _links | VARCHAR | |
| 3 | lastMembershipUpdated | VARCHAR | |
| 4 | created | VARCHAR | |
| 5 | profile | VARCHAR | |
| 6 | objectClass | VARCHAR | |
| 7 | id | VARCHAR | |
| 8 | type | VARCHAR |
Table: logs
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | severity | VARCHAR | |
| 2 | request | VARCHAR | |
| 3 | authenticationContext | VARCHAR | |
| 4 | eventType | VARCHAR | |
| 5 | published | VARCHAR | |
| 6 | securityContext | VARCHAR | |
| 7 | uuid | VARCHAR | |
| 8 | version | VARCHAR | |
| 9 | target | VARCHAR | |
| 10 | actor | VARCHAR | |
| 11 | debugContext | VARCHAR | |
| 12 | displayMessage | VARCHAR | |
| 13 | client | VARCHAR | |
| 14 | legacyEventType | VARCHAR | |
| 15 | outcome | VARCHAR | |
| 16 | transaction | VARCHAR |
Table: users
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | lastLogin | VARCHAR | |
| 2 | lastUpdated | VARCHAR | |
| 3 | passwordChanged | VARCHAR | |
| 4 | _links | VARCHAR | |
| 5 | credentials | VARCHAR | |
| 6 | created | VARCHAR | |
| 7 | profile | VARCHAR | |
| 8 | statusChanged | VARCHAR | |
| 9 | id | VARCHAR | |
| 10 | type | VARCHAR | |
| 11 | activated | VARCHAR | |
| 12 | status | VARCHAR |
External Resources
- Add Application Page
- Here
- Signup
- Dashboard
- Domain
- User Role Assignments
- Group Members
- Group Role Assignments
- System Log
- Custom Roles
- Resource Sets
- Requests Limitation
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.