This feature is currently a pilot for the Data Connect solution. For more information about the pilot, contact your Customer Success Partner (CSP). If you experience issues with a pilot feature, contact your CSP or Solution Architect (SA).
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 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
- 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
- Classrooms
- Classroomslots
- Classrooms_trackings
- Courses
- Courses_trackings
- Daily_metrics
- Groups
- Learningneeds
- Paths
- Paths_sessions
- Paths_trackings
- Posts
- Projects
- Reactions
- Skills
- Users
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) |
ASSESSMENT_OUTLINE_ID | VARCHAR(16777216) | Identifier of the assessment outline. |
Foreign Key 1 (FK1) [ID > "Assessments_outlines"] |
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. | FK2 [ID > "Users"] |
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.
|
|
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"] |
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 |
|
NAME |
VARCHAR(16777216) |
Title of the classroom. |
|
MEDIAS |
VARCHAR |
Medias attached to a classroom. |
|
IS_VIRTUAL |
BOOLEAN |
|
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 |
|
START_DATE |
TIMESTAMP_NTZ(9) |
Start date and time, in the format |
|
END_DATE |
TIMESTAMP_NTZ(9) |
End date and time, in the format |
|
CLASSROOM |
VARCHAR(16777216) |
Identifier of the classroom. |
Foreign Key 1 (FK1) [ID > "Classrooms"] |
NAME |
VARCHAR(16777216) |
Name of the classroom. |
|
IS_VIRTUAL |
BOOLEAN |
|
|
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 |
|
USER |
VARCHAR(16777216) |
Identifier of the user who participated in the classroom. |
Foreign Key 1(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 |
|
|
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_ID |
VARCHAR(16777216) |
Identifier of the context in which the classroom took place. For example, is a classroom is part of a path, then |
FK4 [ID > "Paths"] |
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 |
|
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 |
|
|
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 |
|
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:
|
|
ARCHIVED |
BOOLEAN |
|
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 |
|
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:
|
|
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 course was accessed by the user, , in the format |
|
ACCESS_DATES |
ARRAY |
Dates and times in which the user has accessed a course, in the format |
|
COMPLETED_AT |
TIMESTAMP_NTZ(9) |
Date and time in which the user has completed the course, in the format |
|
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_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. |
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 |
Primary Key (PK) |
LOGGED_IN_USERS |
ARRAY |
Identifiers of the users that logged in this day. |
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 |
|
OWNER |
VARCHAR(16777216) |
Identifier of the group owner. |
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 |
|
NAME |
VARCHAR(16777216) |
Name of the learning need. |
|
STATUS |
VARCHAR(16777216) |
Status of the learning need. Possible values:
|
|
VOLUNTEERS |
ARRAY |
List of the volunteers' identifiers. |
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. |
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 |
|
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 |
|
SKILLS |
ARRAY |
List of the skills identifiers. |
FK3 [ID > "Skills"] |
STEPS |
ARRAY |
List of the steps’s identifiers. |
FK4 [ID > "Paths" OR "Courses OR "Assessments" OR "Classrooms"] |
ADDITIONAL_INFORMATION |
VARCHAR(16777216) |
Content of the additional information field in the path. |
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 |
|
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. |
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 |
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 |
|
USER |
VARCHAR(16777216) |
Identifier of the user. |
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. |
|
RESULT |
VARCHAR(16777216) |
Result of the learner in the path. Possible values:
|
|
ENROLLED |
BOOLEAN |
|
|
IS_SELF_ENROLLED |
BOOLEAN |
|
|
ENROLLED_AT |
TIMESTAMP_NTZ(9) |
Time of the learner enrollment in the path, in the format |
|
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 |
|
HAS_CERTIFICATE |
BOOLEAN |
|
|
LEARNER_STATUS |
VARCHAR(16777216) |
Status of the learner on the path. Possible values:
|
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 |
|
AUTHOR |
VARCHAR(16777216) |
Identifier of the post author. |
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:
|
|
GROUP |
VARCHAR(16777216) |
Identifier of the group where the post was published.
|
FK3 [ID > "Groups"] |
COURSE_ID |
VARCHAR(16777216) |
Identifier of the course where the post was published. |
FK4 [ID > "Courses"] |
COMMENT |
VARCHAR(16777216) |
Post message. |
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 |
|
COMPLETED_AT |
TIMESTAMP_NTZ(9) |
Completion time, in the format |
|
NAME |
VARCHAR(16777216) |
Name of the project. |
|
GROUP |
VARCHAR(16777216) |
Identifier of the group the project belongs to. |
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 |
|
AUTHOR_ID |
VARCHAR(16777216) |
Identifier of the user who reacted. |
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:
|
|
ARCHIVED_AT |
TIMESTAMP_NTZ(9) |
Time at which the reaction was archived, if applicable. In the format |
|
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 |
|
AUTHOR |
VARCHAR(16777216) |
Identifier of the user who created the skill in the platform. |
FK1 [ID > "Users"] |
NAME |
VARCHAR(16777216) |
Name of the skill. |
|
EXTERNAL_ID |
VARCHAR(16777216) |
External identifier of the skill. |
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 |
|
|
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 |
|
|
MANAGERS |
ARRAY |
List of the managers identifiers. |
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 |
|
EXTERNAL_IDS |
ARRAY |
List of the user external identifiers. |
|