Data and Analytics Group Discussions

Data and Analytics Group questions and discussion forum

We have configured the ODBC connection and can connect to tables and retrieve data using Excel, but when trying to link to tables using Access we receive the message: "Reserved error (-7733); there is no message for this error."  Has anyone else expe...

  • 1 Likes
  • 1 Replies

In the data portal it says "Please note that the date specified does not reflect the actual dates of the data, but instead when the data was finished exporting. The most recent data in a given export is generally 24-36 hours older than the date given...

Community Contributor
Data and Analytics Group
  • 1 Likes
  • 1 Replies

I noticed today when working in one of my sub accounts, that I can access the Canvas Data menu item from the SubAccounts.   Is there anything special about accessing the Canvas Data panel from a SubAccount?    Thanks< Glen

Community Champion
Data and Analytics Group
  • 1 Likes
  • 0 Replies

Looking at the "Create Credentials" page, it looks like I, as myself, can create a single set of credentials.   So, If I want to share those credentials with others, they all use a common set of credentials created by me.      If things go sideways, ...

  • 2 Likes
  • 3 Replies

Looking at the Docs, it looks like I would use the option to Create API Credentials.    This for sure lets myself, and anyone I give them to, access to download the data files and load them into my private DBMS.   But, I was told that Civitas, in par...

  • 2 Likes
  • 2 Replies

Please let us know if we are joining incorrectly, or is this a bug?I expect these to be able to join to one other.  E.g. if I want to get a list of all quiz submissions that have been done, I should be able to see both when the user had finished the ...

  • 1 Likes
  • 1 Replies

There are just so many questions to ask... I hear of a document that is being created to address this. Can we take a peak and give you feedback?Thanks!!

Community Novice
Data and Analytics Group
  • 0 Likes
  • 0 Replies

Greetings,  I was wondering if Outcome data was going to be added to the data feeds. thanksMark

  • 7 Likes
  • 4 Replies

Are calendar events available in Canvas Data? I see that assignment_dim has due_at. But are other entered calendar activities available through other such tables?

Community Novice
Data and Analytics Group
  • 0 Likes
  • 0 Replies

I was stuck longer than I'm proud of this morning with a bug in my code - it turned out to be because the requests table has a column named "conversaion_id", while my code was using a more traditional spelling...It's a minor thing, but it'd be helpfu...

  • 1 Likes
  • 1 Replies

Good morning - Recently selecting all data and looking at the external tool dim and fact tables I am not see valid ID's in the FACT and in the DIM table the Canvas ID's appear to be wrong.Are others seeing similar behavior?

Community Novice
Data and Analytics Group
  • 0 Likes
  • 0 Replies

We've been doing some validation across the dataset as a whole, and one thing that has jumped out is that the various free-form text fields are truncated to 255 (or sometimes 256) characters at the schema level. Some of the work that our researchers ...

  • 1 Likes
  • 3 Replies

Hello,Trying to get R to connect with this command:> <- redshift.connect("jdbc:postgresql://ucdenver-redshift.beta.inshosteddata.com:5439/canvas","canvas","<password>")But getting this error:Error: unexpected assignment in "<-"Everything seems in ord...

  • 1 Likes
  • 1 Replies

I am new to Tableau and am struggling with some very basic queries.  Here is a basic query I am starting with:For each course, what are the total number of assignments.  This simple metric is a good way to measure Canvas adoption on Campus (we used t...

  • 2 Likes
  • 2 Replies

We’re starting to look into some of the data from the Canvas Data with the requests table. We are looking at the URL column to understand what requests are being made most often--and which of those we need to filter out because they are made by autom...

  • 5 Likes
  • 4 Replies

Would it be possible to add the quiz due date to the quiz_dim table

  • 1 Likes
  • 1 Replies

Deactivated user​ will attendance reporting be available with Hosted Data? I have an Admin that wants to be able to download attendance history (beyond the past 7 days that you can currently run in Canvas UI).I wasn't sure if these kinds of analytics...

  • 2 Likes
  • 1 Replies

Anyone using Talend to connect to the redshift database?

  • 1 Likes
  • 1 Replies

Is the Mobile App Data Going to be included? As our mobile usage grows, it would be interesting to pull stats on what tools are being used etc.

  • 3 Likes
  • 1 Replies

Would Page Views generated by Canvas Data determine if a collaboration was Etherpad or Google doc? Would there be anything in the URL returned in page views that would indicate which type of collaboration was accessed? My guess is that it wouldn't an...

  • 1 Likes
  • 1 Replies

Could people post sample SQL they are using and short description of what it pulls?

  • 7 Likes
  • 5 Replies

Hi, I was comparing submissions data and noticed a difference between the "graded_at" dates that were returned via Canvas Data in Redshift and the Submissions API.  I suspect it is timezone-related since it matches some of the time but not all the ti...

  • 1 Likes
  • 1 Replies

Hi,Has anyone utilized requests table to calculate basic site usage metrics like the ones available with Google Analytics? I've created a basic set of visualizations showing number of requests made over time & most accessed courses however I wonder i...

  • 4 Likes
  • 5 Replies

Would it be possible to include the user’s email address in either the user_dim or the pseudonym_dim? We see that for some institutions, the pseudonym_dim.unique_name contains the user’s email address but for us, that field contains the user’s Canvas...

  • 4 Likes
  • 2 Replies

We can see a student_entered_score field in the submission_fact table. What does this represent? We see "TBD" in the documentation. There is a "what-if" feature that I'm not overly familiar with, but may be what is represented by this field. Has anyo...

  • 1 Likes
  • 2 Replies

Is there always a 1:1 relationship between a course and enrollment term (I believe a course can only exist in one term at a time, but wanted to confirm)?  Also, we see enrollment_term_id in the quiz_submission_fact and submission_fact, but not in the...

  • 2 Likes
  • 2 Replies

Updated from Tableau v8 to v9. I had no trouble before the update, but now I have connection to Redshift errors.  The error is: FATAL: password authentication failed for user "canvas" I don't get this with SQLWorkbench, so I'm guessing it is a Tablea...

  • 0 Likes
  • 2 Replies

I stumbled over these while trying to do some aggregate functions.  There are 45,588 entries in my submission_dim table that don't have a match in the submission_fact table.  Does this mean something specific?  Is it a data error?Here is an example:c...

  • 2 Likes
  • 1 Replies

It looks like in our requests table, there are no assignment, conversation, discussion or quiz links:canvas=> select * from requests where quiz_id is not null or conversaion_id is not null or discussion_id is not null or assignment_id is not null lim...

  • 2 Likes
  • 1 Replies

One of our tables, requests, has over 1,000,000,000 rows in it.  Since redshift doesn't support indexes, it's a very cumbersome table to work with.What is the plan for scale in the future?

  • 3 Likes
  • 3 Replies