Access raw learning data with Data Connect

  • Updated

This feature requires the Data Connect solution. For more information, contact your Customer Success Partner (CSP). 

Data Connect allows you to:

Data Connect gives you access to Snowsight ↗, the Snowflake web interface:

  • If you don't have a Snowflake account, your Solution Architect (SA) will provide you with the credentials to log into Snowsight with a reader account. The reader account allows you to access and query the data in our warehouse, with no setup or usage costs for you.
  • If you already have a Snowflake account, your SA will give you access to our database. As you execute queries on the database, credits will be consumed on your Snowflake account, so you can directly control your compute costs on this resource.

This article presents the setup of Data Connect, the main use cases in Snowsight, and the data model of the 360Learning database. For more information about fetching and manipulating the data in Snowsight, you can also follow the official Snowflake documentation ↗.

Set up Data Connect

Step 1: Contact us

Email either your 360Learning Client Success Partner (CSP) or your SA, with the following information:

  • Solution: Data Connect
  • 360Learning Emails: The emails of the users who will require access to the Snowflake database. These users do not need to have specific permissions in 360Learning.
  • Do you already have a Snowflake account? [Yes/No]

After that, your SA will contact you with either of the following:

  • If you don't have a Snowflake account, your SA will send you a 1Password link to access our database via a reader account, with the following credentials:
    • Role
    • Username
    • Password
  • If you already have a Snowflake account, your SA will grant you filtered access to our database on your account.

The 1Password link expires after 30 days. Once you get your credentials, we suggest you store them in a secure place.

Step 2: Connect to your Snowflake interface

You can connect to Snowsight, the Snowflake web interface, from your browser:

  1. Go to Snowsight ↗.
  2. Enter your Username and Password.
  3. Click Sign in.

Access raw learning data

  1. Log in to Snowsight ↗.
  2. In the left navigation menu, click DataDatabases.
  3. (Optional) If you log into Snowsight with your own Snowflake account, click Private sharing.
  4. Select QWNOGPY_WW21770_DATASHARING Core Tables.

The raw learning data from your users is organized in a set of 18 tables. To visualize the entities in the database and the relationships between them, see the Entity Relationship Diagram (ERD) ↗.

For the description of the tables, see Explore the data model at the end of this article.

Query learning data with SQL worksheets

  1. Log in to Snowsight ↗.
  2. In the left navigation panel, select Worksheets.
  3. At the top right, select +SQL Worksheet to create a worksheet.
    A new worksheet is created with the date and time of creation as the default title.
  4. (Optional) In the left panel, click 3Dots.svg at the right of the worksheet title to rename the worksheet.
  5. (Optional) Click No Database selected chevronDown.svgQWNOGPY_WW21770_DATASHARING CORE.
  6. Write your query in the worksheet.
  7. At the top right, click triangleRight.svg Run.

For more information about SQL worksheets, see Querying Data with SQL Worksheets ↗.

Download query results

After you query learning data with SQL worksheets, you can export your results in CSV format:

  1. Log in to Snowsight ↗.
  2. In the left navigation panel, click Worksheets.
  3. Select the worksheet.
  4. (Optional) At the top right, clicktriangleRight.svg Run to update the query results.
  5. At the top right of the results table, click download.svg Download results Download as .csv.

Create a chart with query results

After you query learning data with SQL worksheets, you can visualize your results using charts in Snowsight:

  1. Log in to Snowsight ↗.
  2. In the left navigation panel, click Worksheets.
  3. Select the worksheet.
  4. (Optional) At the top right, clicktriangleRight.svg Run to update the query results.
  5. At the top right of the results table, click Chart.
  6. In the right panel, select the Chart type, Data, and Appearance.

Download a chart with query results

After you create a chart with your query results, you can download the chart in PNG format:

  1. Log in to Snowsight ↗.
  2. In the left navigation panel, click Worksheets.
  3. Select the worksheet.
  4. At the top right of the results table, click Chart.
  5. At the top right of the chart, click download.svg Download Chart.

Create a dashboard with the results of multiple queries

After you query learning data with SQL worksheets, you can build a dashboard with a collection of charts to view the results of multiple queries at a glance.

  1. Log in to Snowsight ↗.
  2. In the left navigation panel, click Dashboards.
  3. At the top right, click plus.svg Dashboard.
  4. In the dialog box, enter a Dashboard name.
  5. Click Create Dashboard.
  6. At the top left, click plus.svg and drag the tiles to place on the dashboard.
  7. At the top right, click triangleRight.svg Run to view the query results.

Explore the data model

The following tables are included in the data model:

Assessments_outlines

The Assessments_outlines table contains information about the assessment outlines, with one line per assessment.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the assessment outline. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.  
NAME VARCHAR(16777216) Title of the assessment.  
ASSESSOR_INSTRUCTIONS VARCHAR(16777216) Instructions for the assessor.  
LEARNER_INSTRUCTIONS VARCHAR(16777216) Instructions for the learner.  

Assessments_trackings

The Assessments_trackings table tracks assessment metrics for each user, with one line per user per assessment attempt.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the assessment tracking. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.  
USER VARCHAR(16777216) Identifier of the user who attempted the assessment. Foreign Key (FK1) [ID > "Users"]
ASSESSMENT_OUTLINE_ID VARCHAR(16777216) Identifier of the assessment outline.

FK2 [ID >  "Assessments_outlines"]

CONTEXT_TYPE VARCHAR(16777216) Context type of the assessment. For example, if an assessment is made during a path, then the CONTEXT_TYPE is path.  
CONTEXT_ID VARCHAR(16777216) Identifier of the context. For example, if an assessment is made during a path, then CONTEXT_ID is the identifier of the path. FK3 [ID > "Paths"]
CORRECTED_AT TIMESTAMP_NTZ(9) Correction time, in the format YYYY-MM-DD HH:MI:SS. nullif the assessment has not been corrected yet.  
SCORE FLOAT

Score obtained by the user.

nullif the assessment has not been corrected yet or if the assessment is scoreless.

 
SUCCESS BOOLEAN TRUE if the user passed the assessment, FALSE if the user failed. nullif the assessment has not been corrected yet.  
CORRECTED_BY VARCHAR(16777216) Identifier of the user who validated the success of the assessment. nullif the assessment has not been corrected yet. FK4 [ID > "Users"]
ASSESSORS ARRAY List of the assessor's identifiers. FK5 [ID > "Users"]

Classrooms

The Classrooms table contains information about the classrooms, with one line per classroom.

Column Type Definition Keys in the database
ID

VARCHAR(16777216)

Identifier of the classroom.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

NAME

VARCHAR(16777216)

Title of the classroom.

 

MEDIAS

VARCHAR

Medias attached to a classroom.

 

IS_VIRTUAL

BOOLEAN

TRUE if the classroom is virtual, FALSE if the classroom is on-site.

 

Classroomslots

The Classroomslots table contains information about the classroom slots, with one line per classroom slot.

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the classroom slot.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

START_DATE

TIMESTAMP_NTZ(9)

Start date and time, in the format YYYY-MM-DD HH:MI:SS.

 

END_DATE

TIMESTAMP_NTZ(9)

End date and time, in the format YYYY-MM-DD HH:MI:SS.

 

CLASSROOM

VARCHAR(16777216)

Identifier of the classroom.

Foreign Key 1 (FK1) [ID > "Classrooms"]

NAME

VARCHAR(16777216)

Name of the classroom.

 

IS_VIRTUAL

BOOLEAN

TRUE if the classroom is virtual, FALSE if the classroom is on-site.

 

LOCATION

VARCHAR(16777216)

Location of the classroom.

 

TRAINERS

ARRAY

List of trainers identifiers.

FK2 [ID > "Users"]

REPORTED_DURATION

NUMBER(38,0)

Number of hours (as integer) for the reported duration of the classroom slot.

 

Classrooms_trackings

The Classrooms_trackings table tracks classroom participation, with one line per classroom per user.

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the classroom tracking.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

USER

VARCHAR(16777216)

Identifier of the user who participated in the classroom.

Foreign Key (FK1) [ID > "Users"]

CLASSROOMSLOT

VARCHAR(16777216)

Identifier of the classroom slot.

FK2 [ID > "Classroom_slots"]

CLASSROOM

VARCHAR(16777216)

Identifier of the classroom.

FK3 [ID > "Classrooms"]

HAS_ATTENDED

BOOLEAN

TRUE if the user has attended the classroom. FALSE if the user was absent. nullif the user is registered to a classroom slot for which the attendance was not filled.

 

ATTENDANCE_STATUS

VARCHAR(16777216)

  • attended if the learner was added to the attendance list.
  • missed if the learner was not added to the attendance list (and at least one other learner was added to the list).
  • registered if the learner is registered to a classroom slot for which attendance was not filled.

 

CONTEXT_TYPE

VARCHAR(16777216)

Context type in which the classroom took place. For example, if a classroom is part of a path, then the CONTEXT_TYPE is path. Possible values: 

  • path
  • program (soon deprecated)

 

CONTEXT_ID

VARCHAR(16777216)

Identifier of the context in which the classroom took place. For example, is a classroom is part of a path, then CONTEXT_ID is the identifier of the path.

FK4 [ID > "Paths"]

END_DATE

TIMESTAMP_NTZ(9)

End date and time, in the format YYYY-MM-DD HH:MI:SS.

 

REPORTED_DURATION

NUMBER(38,0)

Number of hours (as integer) for the reported duration of the classroom slot.

 

Courses

The Courses table contains information about the courses, with one line per course.

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the course row.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

NAME

VARCHAR(16777216)

Name of the course.

 

SKILLS

ARRAY

List of skills identified for the course.

Foreign Key 1 (FK1) [ID > "Skills"]

IS_SCORM

BOOLEAN

TRUE if the course is SCORM. FALSE otherwise.

 

CO_AUTHORS

ARRAY

List of the co-authors identifiers.

FK2 [ID > "Users"]

AUTHOR

VARCHAR(16777216)

Identifier of the course author.

FK3 [ID > "Users"]

DESCRIPTION

VARCHAR(16777216)

Description of the course.

 

MODIFIED_AT

TIMESTAMP_NTZ(9)

Last modification time of course, in the format YYYY-MM-DD HH:MI:SS.

 

SOURCE_LANG

VARCHAR(16777216)

The source language of the course.

 

COURSE_DURATION

NUMBER(38,0)

The estimated duration of the course.

 

EXTERNAL_CONTENT

VARCHAR(16777216)

If the course is from an external content provider, the following information is displayed: 

  • catalogId
  • externalPlatform
  • launchUrl
  • catalogName, when available
  • logoUrl, when available

nullif the course is not part of an external context provider.

 

IS_ARCHIVED

BOOLEAN

TRUE if the course is archived, FALSE otherwise.

 

Courses_trackings

The Courses_trackings table tracks the users' attempts on courses, with one line per user per course attempt.

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the course tracking.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

COURSE

VARCHAR(16777216)

Identifier of the course.

Foreign Key 1 (FK1) [ID > "Courses"]

USER

VARCHAR(16777216)

Identifier of the user.

FK2 [ID > "Users"]

SCORE

FLOAT

Score of the user on the attempt.

 

RESULT

VARCHAR(16777216)

Result of the user on the attempt. Possible values:

  • success
  • retry
  • failed
  • wait
  • null

 

PROGRESS

NUMBER(38,0)

Completion rate of the user on the attempt.

 

TIME_SPENT

NUMBER(37,1)

Time spent by the user on the attempt, in minutes.

 

LAST_ACCESSED_AT

TIMESTAMP_NTZ(9)

Last time the user accessed the course, in the format YYYY-MM-DD HH:MI:SS.

 

ACCESS_DATES

ARRAY

Dates and times in which the user has accessed a course, in the format YYYY-MM-DD HH:MI:SS.

 

COMPLETED_AT

TIMESTAMP_NTZ(9)

Date and time in which the user has completed the course, in the format YYYY-MM-DD HH:MI:SS.

 

CONTEXT_TYPE

VARCHAR(16777216)

Context in which the course was played. For example, if a course is played in the context of a path, then the CONTEXT_TYPE is path.

 

CONTEXT_ID

VARCHAR(16777216)

Identifier of the path session in which the course was played.

FK3 [ID > "Paths"]

LANG

VARCHAR(16777216)

Language the learner is playing the course in.

 

DEVICE

VARCHAR(16777216)

Device used on the attempt creation. Possible values:

  • android
  • ios
  • web

 

Daily_metrics

The Daily_metrics table contains general information on the users who logged into the platform each day, with one line per day.

Column Type Definition Keys in the database

DATE

TIMESTAMP_NTZ(9)

Date, in the format YYYY-MM-DD.

Primary Key (PK)

LOGGED_IN_USERS

ARRAY

Identifiers of the users that logged in this day.

Foreign Key (FK1) [ID > "Users"]

Groups

The Groups table contains general information on the groups in the platform, with one line per group.

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the group.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9) 

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

OWNER

VARCHAR(16777216)

Identifier of the group owner.

Foreign Key (FK1) [ID > "Users"]

NAME

VARCHAR(16777216)

Group name.

 

ADMINS

ARRAY

List of the group administrators identifiers.

FK2 [ID > "Users"]

AUTHORS

ARRAY

List of the group authors identifiers.

FK3 [ID > "Users"]

COACHES

ARRAY

List of group coaches.

FK4 [ID > "Users"]

PARENT_ID

VARCHAR(16777216)

Identifier of the parent group.

FK5 [ID > "Groups"]

USERS

ARRAY

List of the learners identifiers.

FK6 [ID > "Users"]

Learningneeds

The Learningneeds table contains information about the learning needs, with one line per learning need.

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the learning need.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

NAME

VARCHAR(16777216)

Name of the learning need.

 

STATUS

VARCHAR(16777216)

Status of the learning need. Possible values:

  • new
  • alreadyExists
  • discarded
  • exploring
  • done
  • projectOngoing

 

VOLUNTEERS

ARRAY

List of the volunteers' identifiers.

Foreign Key (FK1) [ID > "Users"]

EXPERTS

ARRAY

List of the experts' identifiers.

FK2 [ID > "Users"]

GROUP

VARCHAR(16777216)

Group identifier.

FK3 [ID > "Groups"]

ANSWERS

ARRAY

List of answers.

 

DELETED_AT

TIMESTAMP_NTZ(9)

Deletion date, if applicable.

 

DECLARED_BY

VARCHAR(16777216)

Identifier of the user who declared the learning need.

FK4 [ID > "Users"]

Paths

The Paths table contains one line per path, with the following information:

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the path.

Primary Key

NAME

VARCHAR(16777216)

Name of the path.

 

AUTHOR

VARCHAR(16777216)

Identifier of the path author.

Foreign Key (FK1) [ID > "Users"]

CO_AUTHORS

ARRAY

List of the co-authors identifiers.

FK2 [ID > "Users"]

DESCRIPTION

VARCHAR(16777216)

Path description.

 

SOURCE_LANG

VARCHAR(16777216)

Source language of the path.

 

MODIFIED_AT

TIMESTAMP_NTZ(9) 

Last time the path was modified, in the format YYYY-MM-DD HH:MI:SS.

 

OWNER_GROUP

VARCHAR(16777216)

Identifier of the group that owns the path.

FK3 [ID > "Groups"]

DURATION

NUMBER(38,0)

Estimated duration of the path, in hours.

 

CREATED_AT

TIMESTAMP_NTZ(9) 

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

SKILLS

ARRAY

List of the skills identifiers.

FK4 [ID > "Skills"]

STEPS

ARRAY

List of the steps’s identifiers.

FK5 [ID > "Paths" OR "Courses" OR "Assessments" OR "Classrooms"]

ADDITIONAL_INFORMATION

VARCHAR(16777216)

Content of the additional information field in the path.

 

IS_CHILD_PATH

BOOLEAN

TRUE if the path is a step within a path, FALSE otherwise.

 

Paths_sessions

The Paths_sessions table contains one line per path session, with the following information:

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the path session.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

NAME

VARCHAR(16777216)

Path session name.

 

START_DATE

TIMESTAMP_NTZ(9)

Start date of the path session.

 

END_DATE

TIMESTAMP_NTZ(9)

End date of the path session.

 

PATH

VARCHAR(16777216)

Identifier of the path.

Foreign Key (FK1) [ID > "Paths"]

INSTRUCTORS

ARRAY

List of the co-instructors' identifiers.

FK2 [ID > "Users"]

MAIN_INSTRUCTOR

VARCHAR(16777216)

Main instructor identifier.

FK3 [ID > "Users"]

OWNER_GROUP

VARCHAR(16777216)

Identifier of the group that owns the path session.

FK4 [ID > "Groups"]

MODIFIED_AT

TIMESTAMP_NTZ(9)

Last time the path session was modified, in the format YYYY-MM-DD HH:MI:SS.

 

Paths_trackings

The Paths_trackings table track the paths participation, with one line per user per path attempt.

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the path tracking.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

USER

VARCHAR(16777216)

Identifier of the user.

Foreign Key (FK1) [ID > "Users"]

PATH_ID

VARCHAR(16777216)

Identifier of the path.

FK2 [ID > "Paths"]

PATH_SESSION

VARCHAR(16777216)

Identifier of the path session.

FK3 [ID > "Paths_sessions"]

SCORE

NUMBER(38,0)

Average of the score of all steps in the path.

 

PROGRESS

NUMBER(38,0)

Percentage (in integer number) of the completion rate of the learner in the path.

 

LEARNER_STATUS

VARCHAR(16777216)

Status of the learner on the path. Possible values:

  • awaitingCorrection
  • onTime
  • late
  • completed
 

RESULT

VARCHAR(16777216)

Result of the learner in the path. Possible values:

  • successful
  • retry
  • failed
  • null

 

ENROLLED

BOOLEAN

  • TRUE if the learner is still enrolled in the path session
  • FALSE if they were unenrolled

 

IS_SELF_ENROLLED

BOOLEAN

  • TRUE if the user self-enrolled in the path. 
  • FALSE if they were enrolled by someone else.

 

ENROLLED_AT

TIMESTAMP_NTZ(9)

Time of the learner enrollment in the path, in the format YYYY-MM-DD HH:MI:SS.

 

TIME_SPENT

NUMBER(38,0)

Time spent by the learner in the path, in minutes.

 

COMPLETED_AT

TIMESTAMP_NTZ(9)

Time when the learner completed the path, in the format YYYY-MM-DD HH:MI:SS.

 

HAS_CERTIFICATE

BOOLEAN

  • TRUE if the learner was granted a certificate
  • FALSEif the learner was not granted a certificate when completing the path.

 

Posts

The Posts table contains one line per reaction, with the following information:

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the post.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

AUTHOR

VARCHAR(16777216)

Identifier of the post author. 

Foreign Key (FK1) [ID > "Users"]

TARGET_ID

VARCHAR(16777216)

Identifier of the context in which the post was published.

FK2 [ID > "Course" OR "Paths" OR "Groups"]

TARGET_TYPE

VARCHAR(16777216)

The context type of the post. Possible values:

  • medias
  • questions
  • programSessions
  • posts
  • polls
  • responses
  • courses
  • sheets
  • pages

 

GROUP

VARCHAR(16777216)

Identifier of the group where the post was published. 

nullif the post was not made in the context of a group.

FK3 [ID > "Groups"]

COURSE_ID

VARCHAR(16777216)

Identifier of the course where the post was published.

FK4 [ID > "Courses"]

COMMENT

VARCHAR(16777216)

Post message.

 

Programs

The Programs table contains one line per program template, with the following information:

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the program template.

Primary Key (PK)

NAME

VARCHAR(16777216)

Name of the program template.

 

AUTHOR

VARCHAR(16777216)

Identifier of the program template author.

Foreign Key (FK1) [ID > "Users"]

DESCRIPTION

VARCHAR(16777216)

Description of the program template.

 

CREATED_AT

TIMESTAMP_NTZ(9) 

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

MODIFIED_AT

TIMESTAMP_NTZ(9) 

Last modification time, in the format YYYY-MM-DD HH:MI:SS.

 

OWNER_GROUP

VARCHAR(16777216)

Identifier of the group that owns the program template.

FK2 [ID > "Groups"]

DURATION

NUMBER(38,0)

Estimated duration of the program, in hours.

 

IS_DELETED

BOOLEAN

TRUE if the program template is deleted, FALSE otherwise.

 

SKILLS

ARRAY

List of the skills' identifiers associated with the program template.

FK3 [ID > "Skills"]

MODULES

ARRAY

List of the modules’ identifiers.

FK4 [ID > "Courses"]

IS_ARCHIVED

BOOLEAN

TRUE if the program template is archived, FALSE otherwise.

 

Program_sessions

The Program_sessions table contains one line per program session, with the following information:

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the program session.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

NAME

VARCHAR(16777216)

Name of the program session.

 

DESCRIPTION

VARCHAR(16777216)

Description of the program session.

 

START_DATE

TIMESTAMP_NTZ(9)

Session start date, in the format YYYY-MM-DD HH:MI:SS.

 

END_DATE

TIMESTAMP_NTZ(9)

Session end date, in the format YYYY-MM-DD HH:MI:SS.

 

USERS_PROGRESS

VARIANT

Array of users and their associated progress in the program session.

The possible values for the associated progress are:

  • success
  • failure
  • percentage of completion

 

AUTHOR

VARCHAR(16777216)

Author of the program session.

Foreign Key 1 (FK1) [ID > "Users"]

GROUPS

ARRAY

List of groups assigned to the program session.

FK2 [ID > "Groups"]

TUTORS

ARRAY

List of instructors of the program sessions.

FK3 [ID > "Users"]

SKILLS

ARRAY

List of skills associated with the program session.

FK4 [ID > "Skills"]

LANG

VARCHAR(16777216)

Language of the program session.

 

DELETED

BOOLEAN

TRUE if the program session was deleted, FALSE otherwise.

 

PROGRAM_DURATION

NUMBER(38,0)

Theoretical duration of the program, in hours.

 

MODIFIED_AT

TIMESTAMP_NTZ(9)

Date of last modification of the program session.

 

PROGRAM_TEMPLATE_ID

VARCHAR(16777216)

Identifier of the program template.

FK5 [ID > "Programs"]

MODULES

ARRAY

List of the courses' identifiers.

FK6 [ID > "Courses"]

OPEN_USERS

ARRAY

List of the users' identifiers who enrolled in the program session.

null if no users are enrolled in the program session.

FK7 [ID > "Users"]

Programs_trackings

The Programs_trackings table tracks the program participation for each user, with one line per user per program session.

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the program tracking.

Primary Key (PK)

USER_ID

VARCHAR(16777216)

Identifier of the user.

Foreign Key (FK1) [ID > "Users"]

PROGRAM_TEMPLATE_ID

VARCHAR(16777216)

Identifier of the program template.

FK2 [ID > "Programs"]

PROGRAM_SESSION_ID

VARCHAR(16777216)

Identifier of the program session.

FK3 [ID > "Program_sessions"]

SCORE

NUMBER(38,0)

Average of the scores in all the program steps.

 

PROGRESS

NUMBER(38,0)

Completion rate of the user in the program.

 

RESULT

VARCHAR(16777216)

Result of the user in the program. Possible values:

  • success
  • failure
  • null

 

ENROLLED

BOOLEAN

Always equal to TRUE.

 

IS_SELF_ENROLLED

BOOLEAN

TRUE if the user self-enrolled in the program.

FALSE if the user was enrolled in the program by someone else.

 

TIME_SPENT

NUMBER(38,0)

Time spent by the learner in the program, in minutes.

 

COMPLETED_AT

TIMESTAMP_NTZ(9)

Time when the learner completed the path, in the format YYYY-MM-DD HH:MI:SS.

 

HAS_CERTIFICATE

BOOLEAN

TRUE if the learner was granted a certificate.

FALSE if the learner was not granted a certificate upon program completion.

 

Projects

The Projects table contains one line per project, with the following information:

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the project.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

COMPLETED_AT

TIMESTAMP_NTZ(9)

Completion time, in the format YYYY-MM-DD HH:MI:SS.

 

NAME

VARCHAR(16777216)

Name of the project.

 

GROUP

VARCHAR(16777216)

Identifier of the group the project belongs to.

Foreign Key (FK1) [ID > "Groups"]

Reactions

The Reactions table contains one line per reaction, with the following information:

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the reaction.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

AUTHOR_ID

VARCHAR(16777216)

Identifier of the user who reacted. 

Foreign Key (FK1) [ID > "Users"]

GROUP_ID

VARCHAR(16777216)

Identifier of the group the reaction belongs to.

FK2 [ID > "Groups"]

COURSE_ID

VARCHAR(16777216)

Identifier of the course the reaction belongs to.

FK3 [ID > "Courses"]

TARGET_ID

VARCHAR(16777216)

Identifier of the target the user reacted to.

FK4 [ID > "Course" OR "Posts"]

COLLECTION

VARCHAR(16777216)

Type of the target of the reaction. Possible values:

  • activities
  • courses
  • posts
  • paths
  • comments
  • replies
  • sheets
  • questions
  • medias

 

ARCHIVED_AT

TIMESTAMP_NTZ(9)

Time at which the reaction was archived, if applicable. In the format YYYY-MM-DD HH:MI:SS.

 

Skills

The Skills table contains one line per skill, with the following information:

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the skill.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

AUTHOR

VARCHAR(16777216)

Identifier of the user who created the skill in the platform.

Foreign Key (FK1) [ID > "Users"]

NAME

VARCHAR(16777216)

Name of the skill.

 

EXTERNAL_ID

VARCHAR(16777216)

External identifier of the skill if it was imported from external content providers.

 

Users

The Users table contains one line per user, with the following information:

Column Type Definition Keys in the database

ID

VARCHAR(16777216)

Identifier of the user.

Primary Key (PK)

CREATED_AT

TIMESTAMP_NTZ(9)

Creation time, in the format YYYY-MM-DD HH:MI:SS.

 

MAIL

VARCHAR(16777216)

Email of the user.

 

FIRST_NAME

VARCHAR(16777216) 

First name of the user.

 

LAST_NAME

VARCHAR(16777216)

Last name of the user.

 

DELETED

BOOLEAN

  • TRUE if the user has been deleted from the platform.
  • FALSE otherwise.

 

MANAGERS

ARRAY

List of the managers' identifiers.

Foreign Key (FK1) [ID > "Users"]

CUSTOMFIELDS

ARRAY

List of custom fields added to the user profile.

 

LAST_LOG_IN_AT

TIMESTAMP_NTZ(9) 

Time the user last logged in, in the format YYYY-MM-DD HH:MI:SS.

 

EXTERNAL_IDS

ARRAY

List of the user external identifiers.

 

 

Check out our blog for more L&D resources.

Was this article helpful?

1 out of 1 found this helpful

Have more questions? Submit a request