Access raw learning data with Data Connect

Updated September 10, 2024 15:36

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

Data Connect allows you to:

Access the raw learning data of your users from our Snowflake-powered data warehouse.
Query your learning data with SQL worksheets in Snowsight.
Download your query results in CSV format.
Create charts with your query results in Snowsight.
Download the charts in PNG format.
Create a dashboard with the results of multiple queries in Snowsight.
Synchronize the data to your Business Intelligence (BI) and data integration tools ↗.

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:

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

Access raw learning data

Log in to Snowsight ↗.
In the left navigation menu, click Data → Databases.
(Optional) If you log into Snowsight with your own Snowflake account, click Private sharing.
Select QWNOGPY_WW21770_DATASHARING → Core → Tables.

The raw learning data from your users is synchronized from your platform daily at 11 AM Central European Time (CET). This data is organized into 22 tables. For a visual representation of the entities in the database and their relationships, 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

Log in to Snowsight ↗.
In the left navigation panel, select Worksheets.
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.
(Optional) In the left panel, click at the right of the worksheet title to rename the worksheet.
(Optional) Click No Database selected → QWNOGPY_WW21770_DATASHARING → CORE.
Write your query in the worksheet.
At the top right, click 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:

Log in to Snowsight ↗.
In the left navigation panel, click Worksheets.
Select the worksheet.
(Optional) At the top right, click Run to update the query results.
At the top right of the results table, click 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:

Log in to Snowsight ↗.
In the left navigation panel, click Worksheets.
Select the worksheet.
(Optional) At the top right, click Run to update the query results.
At the top right of the results table, click Chart.
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:

Log in to Snowsight ↗.
In the left navigation panel, click Worksheets.
Select the worksheet.
At the top right of the results table, click Chart.
At the top right of the chart, click 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.

Log in to Snowsight ↗.
In the left navigation panel, click Dashboards.
At the top right, click Dashboard.
In the dialog box, enter a Dashboard name.
Click Create Dashboard.
At the top left, click and drag the tiles to place on the dashboard.
At the top right, click Run to view the query results.

Explore the data model

The following tables are included in the data model:

Assessments_outlines
Assessments_trackings
Audiencebuilders
Classrooms
Classroomslots
Classrooms_trackings
Courses
Courses_trackings
Daily_metrics
Groups
Learningneeds
Paths
Paths_sessions
Paths_trackings
Posts
Programs
Program_sessions
Programs_trackings
Projects
Reactions
Tags
Users

On July 10th, 2024, we replaced “skills” with “tags” across our platform. This change is now reflected in our Data Connect solution, where you’ll see a new table and columns named “Tags”. Please note that the table and columns named “Skills” will be removed on October 14th.

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`. `null`if the assessment has not been corrected yet.
SCORE	FLOAT	Score obtained by the user. `null`if 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. `null`if the assessment has not been corrected yet.
CORRECTED_BY	VARCHAR(16777216)	Identifier of the user who validated the success of the assessment. `null`if the assessment has not been corrected yet.	FK4 [ID > "Users"]
ASSESSORS	ARRAY	List of the assessor's identifiers.	FK5 [ID > "Users"]

Audiencebuilders

The Audiencebuilders table contains information of each audience created to automate learner enrollment. Each row in the Audiencebuilders table represents a single created audience.

An audience is a collection of users who share specific criteria. For more information about audiences, see Enroll learners in a path session.

Column	Type	Definition	Keys in the database
ID	VARCHAR(16777216)	Identifier of the audience.	Primary Key (PK)
CREATED_AT	TIMESTAMP_NTZ(9)	Creation date and time of the audience, in the format `YYYY-MM-DD HH:MI:SS`.
MODIFIED_AT	TIMESTAMP_NTZ(9)	Modification date and time of the audience, in the format `YYYY-MM-DD HH:MI:SS`.
EXCLUDED_LEARNER_IDS	ARRAY	Array of IDs for learners excluded from the filters.	Foreign Key 1 (FK1) [ID > "Users"]
FILTERS	ARRAY	Criteria that a learner must meet to be included in the audience. Each filter checks a different attribute, such as group membership or custom field. The following fields are included in the filters: `uid`: A unique identifier for the filter, used to combine filters. `attrName`: The name of the attribute being checked. `type`: The category of the attribute being checked. Possible values: `certificate-status`, `group`, `path-result`, `user`, or `user-custom-field`. `operator`: The logical operator for the filter.
ACTIVE	BOOLEAN	Determines whether the audience builder rules are currently being applied. If set to `FALSE`, the audience criteria are not being used. This might be set to false if: The session is deleted. The audience builder is not activated for your company.
MODE	VARCHAR(16777216)	Audience modes. Possible values: `dynamic` for audiences that automatically enroll users as soon as they meet the audience criteria, and unenroll them as soon as they cease to meet them. `manual` for static audiences that enroll only users who meet the audience criteria at the specific moment when the audience is created.

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.
ATTENDANCESHEETS_STATUS	ARRAY	List of IDs and statuses of attendance sheets. Possible values for `status`: `closed`: A sheet is initially in this status. `signed`: A sheet is in this status when signed with check-in closed. `open`: A sheet is in this status when opened for check-in. `adjustment`: a sheet is in this status when opened for adjustment.

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. `null`if 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.
RSVP_GOING	BOOLEAN	`TRUE` if the learner accepted the invitation. `FALSE` if the learner declined the invitation. `null` if the learner did not respond to the invitation.

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.
TAGS	ARRAY	List of tags identified for the course.	Foreign Key 1 (FK1) [ID > "Tags"]
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 `null`if 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"]
CATALOG_COURSES	ARRAY	List of identifiers for the the courses included in the group catalog.	FK7 [ID > "Courses"]
CATALOG_PSESSIONS	ARRAY	List of identifiers for the program sessions included in the group catalog.	FK8 [ID > "Program_sessions"]
CATALOG_PATH_SESS	ARRAY	List of identifiers for the paths sessions included in the group catalog.	FK9 [ID > "Paths_sessions"]
COACHES_PTEMPLATES	ARRAY	List of identifiers for the programs shared in the group library.	FK10 [ID > "Programs"]
COACHES_COURSES	ARRAY	List of identifiers for the courses shared in the group library.	FK11 [ID > "Courses"]
COACHES_PATHS	ARRAY	List of identifiers for the paths shared in the group library.	FK12 [ID > "Paths"]

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`.
TAGS	ARRAY	List of the tags identifiers.	FK4 [ID > "Tags"]
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.
HAS_CERTIFICATE	BOOLEAN	`TRUE` if the path has a certificate, `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"]
AUDIENCE_BUILDER_ID	VARCHAR	Identifier of the audience builder that is implemented within the path session.	FK5 [ID > "Audiencebuilders"]
WAITLIST_IDS	ARRAY	List of user IDs that are in the waitlist of the path session.	FK6 [ID > "Users"]
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 `FALSE`if 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. `null`if 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.
TAGS	ARRAY	List of the tags' identifiers associated with the program template.	FK3 [ID > "Tags"]
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"]
TAGS	ARRAY	List of tags associated with the program session.	FK4 [ID > "Tags"]
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`.

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.
ARRAY_DELETED_AT	ARRAY	Array of dates when the user has been deleted.
IS_INVITED	BOOLEAN	`TRUE` if the user has been invited into the platform; `FALSE` otherwise.
TO_DEACTIVATE_AT	TIMESTAMP_NTZ(9)	Date by which the user will be deactivated from the platform.
CREATED_FROM	VARCHAR(16777216)	Whether the user has been created through self-registration or not. Possible values: `null`: The user was not created through self-registration. `selfRegistration`: The user was created through self-registration.
UPDATED_BY_ID	VARCHAR(16777216)	Identifier of the user who most recently modified the given user.	FK2 [ID > "Users"]
FROM_INVITATION_ID	VARCHAR(16777216)	Identifier of the user who invited the given user to the platform.	FK3 [ID > "Users"]
ARRAY_REACTIVATED_AT	ARRAY	Array of dates when the user has been reactivated.

ERD - Data sharing - 360Learning.pdf200 KB

Check out our blog for more L&D resources.

Was this article helpful?

3 out of 4 found this helpful

Have more questions? Submit a request

Search