Data and Analytics Group Discussions

Data and Analytics Group questions and discussion forum

Hi there,Following the terrific advice provided by James Jones and using some tools available on the Web, I built a signature file, generated an HMAC-SHA-256 digest and had it base64 encoded. I then tried testing the access using Postman.  Here's a s...

  • 2 Likes
  • 3 Replies

How will grading periods be used in Canvas Data?  For example, Current and Final grades which are available in Canvas Data, are likely aggregate grades over the duration of the term.  If the term is full year and the institution is using grading peri...

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

Didn't see anything similar to an e/r diagram - or anything that depicts the relationships between the tables in the documentation portal.  Did I miss it? 

  • 11 Likes
  • 21 Replies

web_applicaiton_action isn't spelled correctly.  hopefully this will save some of you some time banging your head against a wall trying to figure out why your sql isn't working...!

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

SynopsisCalls to the Canvas Data API need to be authenticated. The Canvas Data API documentation​ provides example code that isn't explained very well. This post will explain what's going on so that people can prepare the signature needed to use the ...

Community Champion
Data and Analytics Group
  • 21 Likes
  • 6 Replies

Hi, I'm looking for a "data extract date" or "data as of date" so that we know when the data was pulled into Redshift.  I didn't see a status date or table anywhere in the documentation, but maybe I missed it?  We could retrieve the max(timestamp) fr...

  • 3 Likes
  • 12 Replies

Still getting my feet wet here, but, I'm curious why there is sometimes more than one fact file. Here's an example:

  • 2 Likes
  • 1 Replies

I have been working with one of our Analyst in Institutional Research to try and get our data into database software we can work with to start evaluating what all is there and what we can do with it. For background, we are on the free tier. With that...

  • 2 Likes
  • 1 Replies

Is there a document that specifies individual data elements that are:Available in Canvas Data but not via the API; andAvailable via the API but not in Canvas Data?Maybe Deactivated user​ can answer?

  • 6 Likes
  • 6 Replies

Contrary to what appears to be a common belief, not all Canvas admins are computer geeks. Most of us did not need those skills in the prior LMSs we migrated from - everything was done through the UI. Many of us, myself included, are becoming more gee...

  • 8 Likes
  • 10 Replies

I know this is a total newby question, but when I review the BI tools to access the data files, they all seem to require Amazon Redshift Credentials, which are only available in the paid version of Canvas Data. Some of us (most of us) need informatio...

  • 4 Likes
  • 5 Replies

Hello.  We are building a report with grades for students who dropped the course.  The report grades earned on any assignments before the student dropped as well as current and final scores and grades.  We have discovered that the enrollment_fact tab...

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

Hi, I am new to the Python requests library and I am trying to figure out how to make an api call to dump the data files from Canvas. I keep getting a 404 error, so I just want to make sure I'm forming the request correctly. I looked at the API guide...

  • 12 Likes
  • 25 Replies

We are looking to extract and report on  Outcome data.  Is there a time frame when this would be included in the data ?

  • 1 Likes
  • 1 Replies

We have configured an ODBC connection per the information we found elsewhere.  Testing it while configuring indicates it was successful.  We can use it with no problems to retrieve information into Excel.  However, when trying to link to the same tab...

  • 1 Likes
  • 1 Replies

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

Anyone using Talend to connect to the redshift database?

  • 1 Likes
  • 1 Replies