Could people post sample SQL they are using and short description of what it pulls?

What's the target latency goal? Is this on flat files only?Sent from my iPad

Tap/click map to enlargeMatthew GunkelIndiana University - HigherEdLearn how IU is mentoring faculty in instructional design; setting standards around best practices by example; and using Canvas modul...

OK. Let's start putting SQL in this thread and then we can comment as needed to get accepted code.

Good morning - Recently selecting all data and looking at the external tool dim and fact tables I am not see valid ID's in the FACT and in the DIM table the Canvas ID's appear to be wrong.Are others s...

What's the target latency goal? Is this on flat files only?Sent from my iPad

Tap/click map to enlargeMatthew GunkelIndiana University - HigherEdLearn how IU is mentoring faculty in instructional design; setting standards around best practices by example; and using Canvas modul...

Good morning - Recently selecting all data and looking at the external tool dim and fact tables I am not see valid ID's in the FACT and in the DIM table the Canvas ID's appear to be wrong.Are others s...

I generally get the sense that these are pretty good. I have not dug into the details but I would be curious how faculty and teachers react to this level of detail and quantity of information. I am co...

OK. Let's start putting SQL in this thread and then we can comment as needed to get accepted code.