Hello John,The courses don't necessarily have a published attribute as assignments, and such do. Instead they have a workflow state. The workflow state for a course that is published is "avail...

Dealing with large tables can always be a tricky thing to do. Unfortunately there isn't a skeleton key for performance in databases. Nor is there any set steps to provide a better experience. Most...

Hello Robert,The state.json file is the current state of downloaded files for the CLI. Since the CLI doesn't want to parse through all the files it's downloaded to see where it is (reason it s...

Hello Steve,The requests table actually shows much more than analytics, I wouldn't be surprised if it was literally easily double, or triple the amount of requests from pageviews/analytics. There ...

Hello Krista,As for the historical data, yes you'll need to make a request for historical back fill. This can be done through Canvas Support.As for "query_string_redacted" this is a comple...

Hey Ryan,All of our redshift instances are managed independently of one another. So it's very rare that one redshift is going to cause problems with the other. Can you shoot us over a support emai...

As of last nights dump we are aware of a serious problem with submission_comment_participant_* tables. It turns out this data is not being exported at all.The cause of this fire is very similar to wha...

In reference to the reported Canvas Data load failure that has been earlier posted here, we have published the first set of two days data. This has been populated to portal, and will be populating to ...

On May 11th our ETL Engine which is the process responsible for processing all the data from Canvas, and uploading them to the Customers Portals have run into series of failures causing the dumps to b...

Hey Stuart,I know I'm not Sydney, but I'd be happy to help step in here.- You can also use canvasDataCli -unpack to unzip the files.Yes you can, although since it does other things we don'...