About
pmichaud
Patrick Michaud ">'>
Rank:
Community Novice
Title:
Joined:
Apr 20, 2015 4:43:21 PM
Posts:
7
Solutions:
0
Likes Received:
18
Bio:
An amazing Instructure Community member
Most Liked Posts
I was exploring that table as a way of measuring per student/course "engagement". So tracking how often they're viewing grades/assignments/submissions/external tools/etc. For the beta, I've been try...
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?
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 ...
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 discussi...
That sounds great. Do you have an outline of how we might work with that as an institution?
Most Recent Posts
That sounds great. Do you have an outline of how we might work with that as an institution?
I was exploring that table as a way of measuring per student/course "engagement". So tracking how often they're viewing grades/assignments/submissions/external tools/etc. For the beta, I've been try...
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 ...
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 discussi...
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?
Latest Badges
First Like Received
2024-01-05
Instructure Community: 8 Year
8 Years with Instructure Community
2024-01-03
Instructure Community: 7 Year
7 Years with Instructure Community
2024-01-03
Instructure Community: 6 Year
6 Years with Instructure Community
2024-01-03