Canvas data portal file downloads

For institutions with a hosted account, admins can also manage access to Redshift and the IP Address Allowlist.

Files are also available in the institution's Redshift database. As an admin, you may choose to install Canvas Data Services in your account.

Canvas Data services allows you to configure data streams to access Live Events data from Canvas. Admins can use Canvas Data schemas and APIs to get insight on topics such as accreditation, improving course design, assessing student engagements, and enabling student intervention. As part of the Canvas Data Portal, the Canvas Data schema includes documentation that explains all the table data that is exported from Canvas.

Relevant files can be compared and used to answer questions such as:. Canvas Data files can be used to create visual analysis using queries and reports in ODBC analytics tools. If you find a typo or outdated info, or have a suggestion to improve this guide, please share your feedback. Additional Products. Interest Groups. Most recent data is generally 24—36 hours older than the given date. After Canvas Data has been enabled in your account, a series of flat files display nightly for your account.

The files contain tables representing all data beginning from the time Canvas Data was enabled in the account, with the exception of page view requests that contain an incremental download from the day before. To receive historical page view requests from before Canvas Data was enabled in the account, please contact your Implementation Consultant.

The historical page view table data is uploaded separately and requests are typically processed every other month. The Manage Users section shows admins who have been given access to the Canvas Data Portal, along with their permissions. You cannot edit permissions for yourself. Any admin who does not have access but who has tried to view the portal also appears in the list. You can choose to edit that user's settings and grant permission access at any time.

Learn how to manage Canvas Data Admin users. If you would like to grant access to other users or third-party partners to automatically download data, you can generate API credentials and pass them to those users. To generate the credentials, click the Create Credentials button. Once the credentials are generated, you will need to save them and transmit them securely to the users or third-party partners that will need them. How do I use Canvas Data files?

Ask a Question View Related Guides. Quick Links Canvas Guides. Additional Product Guides. Find answers in the Additional Product guides. Learn about new and updated Canvas features. Learn about new and updated Additional Product features. Post your question to get help from fellow Community members. Find others who share your interests and share your own experiences.

Related Guides. Instructure Live. Join or host a live event in the Community. Learn about upcoming conferences or watch recordings from past events. Upcoming Event:. November 23, Canvas Klatch - Nov. Featured Partners. Amazon Web Services. Partners View All Partners. How can I update the CLI? You can update the CLI by running: "npm update -g canvas-data-cli".

These fields are no longer used. They will likely be deprecated in future versions of Canvas Data. Can I get the first name, last name separated out? Some DBMS systems do not support unsigned bit integers so we went with signed integers. Where are student grades located? One way to do this would be to determine the following: Courses with published assignments by enrollment term Courses with published discussions by enrollment term Courses with published quizzes by enrollment term External tool activations by course and enrollment term This would give an indication of the extent to which faculty are using courses by determining how many assignments, discussions, quizzes, and external tool activations exists for each course.

The best we can say is that the date associated with the latest dump is the data extract date. These tables represent the navigation settings that have been chosen by instructors for different courses. What exactly does "pseudonym" mean in Canvas? In Canvas, users can have one or more logins.

Can I obtain login information for every user? Do the assignment tables include assignments, quizzes, and discussions? This would be within conversations. Please review the schema documentation to see the data available in those tables. Labels 1. Labels: General Information.

Tags 4. Was this article helpful? Yes No. Ask a Question View Related Guides. Quick Links Canvas Guides. Additional Product Guides. Find answers in the Additional Product guides. Learn about new and updated Canvas features. Learn about new and updated Additional Product features. Post your question to get help from fellow Community members. Find others who share your interests and share your own experiences.

Related Guides. General Information 2. Where is the API documentation? What exactly is "Hosted Data Services"?