Could Instructure report on CD2 status on a table by table basis?

[pgo586]

I have an alert in place that warns me when our CD2 data retrieval process has been unable to retrieve any given table for at least a couple of days (BTW each day we retrieve snapshot data once, and incremental data every 4 hours after that, with 3 attempts each time around on each table). I received one such alert early morning today for the following tables:

- canvadocs_annotation_contexts

- enrollment_dates_overrides

This means that we got no data for those tables in between Friday and today's fresh snapshot at 9 am. While we're not actively using the above tables in any meaningful way,  I still wonder whether it would be possible for Instructure to post status of CD2 services on a table by table basis, which would be certainly more informative than simply reporting whether CD2 is operational or not. 

[IanGoh]

Might have to consider what type of table it is.  For instance, the Accounts table.  Most likely it won't have many changes day to day.

[pgo586]

@IanGoh , what I meant is that we were unable to retrieve either incremental OR snapshot data for these tables. In other words, the jobs created repeatedly to access these tables ALL failed. This is why I'm suggesting that status post should perhaps be on individual table basis (since other tables apparently caused no such failures). 

[IanGoh]

Gotcha.  It's not one of the tables we normally get. 

I did try in postman on our CD2 instance

https://api-gateway.instructure.com/dap/query/canvas/table/canvadocs_annotation_contexts/data

and did get data back.

Yours

Ian

[pgo586]

Thanks @IanGoh for trying this out. The reality is that we also got data on Monday for this table, but the point was that it would be nice to be able to detect that a 'particular' table was 'inoperable' in CD2 for a given number of days. I am not going to worry for this table either actually, but I would worry if the same thing happened with 'accounts' , 'users', etc. So just trying to make status more transparent on a table by table basis. Any thoughts from Instructure?