Data and Analytics Group

glparker · 2016-05-12

This morning, Civitas reported to me that since May 2nd they've not been able to download updates to the data. When I went to look in the Canvas Data Portal through my Admin view, I observed that my nightly download only includes a single Table (Re...

mlam · 2016-05-01

Hi, I understand that Notes column is not included in the Gradebook CSV export file. (How do I use the Notes column in the Gradebook? | Canvas Instructor Guide | Canvas Guides )Are there any Tableau users out there who are able to extract/export Note...

rgiovannetti762 · 2016-04-22

I was trying to use the requests file to collect information on the number of students accessing their course home page over a one week period. I noted that a lot of the activity in the course would be from the instructor, so I attempted to map the u...

aghaffar · 2016-04-22

In Canvas Data files, how do I get points earned by user against each Quiz Question? quiz_submission_fact has the overall Quiz score but I need to get the points earned by user per question?

applem · 2016-04-21

Help!I configured the canvasdatacli on a new machine and ran the initial sync.Next I ran unpack to open one of the files and received an error message.The json schema did not downloadI checked my datafiles on the computer and did not see the schema f...

tim_hass · 2016-04-13

I'm using the instructions provided in the Getting Started with Canvas Data video to setup Canvas Data. I've been able to get all they way through the process to the unpack portion. However, the unpacking process cannot be completed because when sy...

s_moles · 2016-04-07

We are not seeing course_ui_canvas_navigation_dim file either in the Canvas Data Portal LTI or via the API /file/latest route. Any ideas why?

John_Lowe · 2016-04-06

Where would I find a deleted comment that a student made on an announcement?

galyenk · 2016-04-06

I've looked and have seen others ask a similar question, but I'm not quite sure I saw a solid answer.Is the Redshift data just as old as the Canvas Date we get on our instance? We are considering purchasing the Redshift plan, but are under the assump...

nresearcher · 2016-03-23

I have been able to download Canvas data using canvasDataCli, but what I'm ultimately interested in doing is importing canvas data (with headers) into MySql. I would appreciate instructions on how to accomplish this.Thank you.

John_Lowe · 2016-03-23

Using canvasDataCLI, I'm having success running the Sync command once-per-day and the Unpack command following that as often as I choose. However, any time that I attempt to run the Sync command a second time within the same day (assuming that I did...

cward · 2016-03-21

Canvas Data has been deployed and is now available for our Asia Pacific (Singapore)-based Canvas customers! If you're interested in enabling Canvas Data for your Canvas instance, please reach out to your CSM, and they can get you started.

John_Lowe · 2016-03-18

Is the email address of users available anywhere within Canvas Data? I've recently been asked to generate a contact list of people based on the output of a Canvas Data report, but I can't seem to locate a field for email address in the user_dim or t...

millerjm · 2016-03-16

I have the CanvasDataCLI installed and running. Thank you to Deactivated user and @James for all the help late last night!I was wondering what to expect if I run the initial command for sync? Disk Space requirements? Does it download files for...

agschmid · 2016-03-16

There doesn't seem to be any data regarding module items in Redshift. When I need to create a report for specific data pertaining to module items, I have to use the api. Are there any plans to include module and module items data in Redshift in the f...

cward · 2016-03-15

The Canvas Data team is currently performing a historical data load for February 2016. Due to this *some* Hosted Redshift instances have not seen new data added since Friday. Once the historical load has completed, the normal refresh schedule will re...

brenden_goetz · 2016-03-11

Hi all -I receive the following error when trying to create a .tde file in Tableau of the requests table:[Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: exceeded the maximum size allowed for the total set of cursor...

phil_mcgachey · 2016-03-04

We're pulling the flat files from the Canvas Data API to load into our own AWS data warehouse, ultimately ending up in Redshift. We're a little behind, and have just hit the first dump that uses version 1.6.0 of the schema, which changes the type of ...

tom_lamy · 2016-03-02

I have canvasDataCli working on Linux. How can I configure it to dump just one file, or select files I want as opposed to all files? Thank you

akline1 · 2016-02-26

The 3 assignment_group files, assignment_rule, and 2 communication_channel files are not being unpacked when I run the sync. Is there an update to the CanvasDataCLI that includes this with the unpack or do I just have to do this manually?Thanks!Abe

leward · 2016-02-26

Please add the "Users can only participate in the course between these dates" flag to the the course_dim table. It's available for the course_section_dim, but not the course_dim.

brenden_goetz · 2016-02-19

I am trying to look at the schema docs, but the page is not populating with anything but the intro (see attached image). Anyone having similar issues, or know the cause, or know if there is another source to view these? Thanks!

kellenk · 2016-02-13

The Getting Started with Canvas Data webinar made it seem as though a Canvas data admin could give a second user access to specific tables, limited to a specific query (more granular access). However, I can't find documentation in the guides to supp...

akline1 · 2016-02-01

I'm pretty new to Canvas and just set up CanvasDataCLI and unpacked my synced files to txt. Problem is that I have truncated IDs (e.g., 4372897E13). I know that I can open in Excel and change the format but, I'm trying to manage without having to op...

galyenk · 2016-01-24

I downloaded the requests table in Canvas Data. I have only one day's worth of data in the requests table, but I am assuming that I need to request the historical dump of our data, is that right? That said, within the requests table I get "query_stri...

amcdona · 2016-01-14

University of Florida would like to connect our Cognos Server to the Redshift but don't want to expose it outside of our private network. Has anyone used a product similar to SQL Proxy to have an IP address white-listed in Canvas Data Portal as a mi...

schang11 · 2016-01-13

I often get this error when trying to unpack certain files. The resulting file only contains the column headers with no data. Retrying has worked for all tables except for requests. What can be done about it?events.js:141 throw er; // Unhandled ...

jpt0001 · 2016-01-13

I can't seem to find the attribute that defines whether a course has been published by the instructor. Can someone point me in the right direction?

rob_callicotte · 2016-01-12

What does this file do and how can I manipulate it with impunity? The reason I'm asking about this is I noticed if I delete the dataFiles directory, after having processed the Canvas Data, the CanvasDataCli command does not recognize the fact I need ...

rob_callicotte · 2016-01-12

canvasDataCli -- How to create a LOG file? I've used the -l command, but do not see a log in any of the directories.

Data and Analytics Group

Data and Analytics Documentation

Data and Analytics Group Discussions

Why do I only see Requests in my Canvas Data Portal?

How to extract Notes from Canvas Gradebook using Tableau?

We have obscured the user ids so join keys can be shared without sharing ac...

Canvas Data - How to get points earned by user against Quiz Question?

missing json schema

No schema file included in sync, cannot unpack

Cannot find/retrieve course_ui_canvas_navigation_dim

Where would I find a deleted comment that a student made on an announcement...

How old is redshift data?

Import Canvas Data into MySQL Database

Cannot read property 'toDownload' of undefined

Canvas Data now available in our Asia Pacific (Singapore) Region!

Is email address available in Canvas Data?

Initial Canvas Data Sync Questions

Will modules and module items data be added to Redshift in the future?

[COMPLETE] Canvas Data Hosted Redshift Maintenance

ODBC cursor data size error in Tableau

Redshift data type for GUID field in requests table.

How can I dump just one file as opposed to all files?

Not all dataFiles get unpacked

Users can only participate in the course between these dates

Schema Docs not working?

Granular Permissions to Access Canvas Data?

Problem with Unpacked Files and truncated IDs (e.g., 4372897E13)

query_string_redacted in Requests Table?

Does Redshift support Sourceforge SQL Relay as a SQL Proxy?

canvasDataCli error when unpacking

Course published attribute

state.json

canvasDataCli Log Creation

You're signed out

Data and Analytics Group

Data and Analytics Documentation

Data and Analytics Group Discussions

Community Help

View our top guides and resources: