Canvas Data Release Notes (2018-04-19)

[#1]

In this Canvas Data release, the schema version has been updated to 3.0.0. Additionally, the requests table includes a new column and a fixed typo.

Canvas Data is a service that provides institutions with optimized access to all their data for reporting and queries. Learn more about Canvas Data.

• Added Columns
• Requests
• Updated Columns
• Fixed Typo

Added Columns

< BACK TO TABLE OF CONTENTS

Requests

Name	Type	Description
developer_key_id	bigint	ID of the developer who accessed this page if the request was made by a developer.

Updated Columns

Fixed Typo

The web_application_action column in the requests table has been updated to fix a typo. Previously the column read as web_applicaiton_action.

[millerjm]

Thank you for fixing the typo! 

[jago_brown]

I learnt about this new release just now the hard way 😞

1. SQL query not executing as expected
2. checked all CanvasData files being pulled down: Yes
3. checked a log file "ERROR:  extra data after last expected column": ?
4. looked at the actual data... Ahh a new column as lots of \N at end of line
5. checked schema - new : developer_key_id bigint
6. Googled and got to this page

What forum do I need to belong to for a heads up on breaking changes like this? 

I get ~3 emails a day from Instructure but not a particular email on this, which would be useful

Jago

[emily_allen]

Hi  @jago_brown ,

I'm sorry to hear you found out about the changes the hard way! I recommend getting in touch with your Customer Success Manager to be added to the mailing list for Canvas Data release notes. 

Thanks!

Emily

[jago_brown]

Hi Emily,

Thanks. Good advice. I've emailed Funmi now.  I assumed because I setup Canvas for LSBM and have been asking questions about CanvasData for 3 years I would automatically be added to this mailing list 🙂

Thanks again

Jago