Access raw learning data with Data Connect

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

Data Connect gives you direct access to the raw learning data of your platform via a Snowflake-powered data warehouse.

Who can use this: Platform admins

Data Connect allows you to:

• Query your learning data with SQL worksheets in Snowsight, the Snowflake web interface.
• 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 ↗.

The raw learning data from your users is synchronized from your platform daily at 11 AM Central European Time (CET), ensuring all data from the previous day is collected. Same-day data may also be added as it becomes available, as some tables are updated more frequently to support specific use cases.

For the latest changes to Data Connect, see Data Connect Release updates ↗.

Set up Data Connect

Step 1: Contact us

Email either your 360Learning Client Success Partner (CSP) or your Solution Architect (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 already have a Snowflake account, your SA will grant you filtered access to our database on your account. As you execute queries on the database, credits will be consumed on your Snowflake account. You can directly control your compute costs on this resource.
• If you don't have a Snowflake account, your SA will send you a 1Password link to access our database via a reader account. This account allows you to access and query the data in our warehouse with no setup or usage costs for you. The 1Password link will contain the following credentials:
  • Role
  • Username
  • Password

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 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 Data → Databases.
3. (Optional) If you log into Snowsight with your own Snowflake account, click Private sharing.
4. Select QWNOGPY_WW21770_DATASHARING → Core → Tables.

The data is organized into sets of tables. For a full description of each table and its columns, see Data Connect data model reference.

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 at the right of the worksheet title to rename the worksheet.
5. (Optional) Click No Database selected → QWNOGPY_WW21770_DATASHARING → CORE.
6. Write your query in the worksheet. For common query examples, see Snowflake queries for Data Connect ↗
7. At the top right, click Run.

For more information, see the official Snowflake documentation on querying data using worksheets↗.

Explore common query examples

For common query examples, see Snowflake queries for Data Connext ↗.

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, click Run to update the query results.
5. 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:

1. Log in to Snowsight ↗.
2. In the left navigation panel, click Worksheets.
3. Select the worksheet.
4. (Optional) At the top right, click 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 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 Dashboard.
4. In the dialog box, enter a Dashboard name.
5. Click Create Dashboard.
6. At the top left, click and drag the tiles to place on the dashboard.
7. At the top right, click Run to view the query results.