Data Connector: Data Dictionary - Table, Fields, and Schema

  • Updated

In this article, you'll find Data Connector tables that are currently supported via the database management system, PostgreSQL, as well as a Schema diagram.

 

Note: All database timestamps are in the UTC timezone.  

We recommend you refresh your data connector access credentials every year. You can do this by contacting support@skilljar.com and we'll update the key for you. 

Learn more about Skilljar Data Connector at Skilljar Data Connector 101.

Common Fields

There are a few common fields on all tables.

Primary ID

Each table has a primary ID field.  The ID is an alphanumeric (lowercase) field up to 32 characters long.  The value of the ID is unique across all instances of the particular table, but not necessarily globally unique across all IDs within Skilljar.

Naming of the primary ID field is typically the table name suffixed with “_id”.

Created At

The “created_at” field is a datetime indicating when the given row was created within Skilljar.

Updated At

The “updated_at” field is a datetime indicating when the given row was last updated within Skilljar.

 

Tables and Fields

Full Schema Information and Field details can be explored in depth at the following Link:

Skilljar Data Connector Schema Details

Click through this site to have a better understanding of the Schema and Fields available in the Skilljar Data Connector Objects.

 

Other details can be found in our Data Dictionary PDF (last updated: 07/16/2024). 

 

Data Connector Schema Diagram

 

 

data_connector_schema-07-10-2024.png

Select the image to enlarge. 

Was this article helpful?

0 out of 0 found this helpful