Are you combining this with the wiki_page_fact table? Wiki_page_fact has the course ID in it. In SQL parlance, join the two tables on wiki_page_fact.wiki_page_id = wiki_page_dim.id.
I just did a quick query with that join and verified that my class has 29 wiki pages in it.
Thank you James. I think this is where I must be going wrong. I have neither the wiki the wiki_page_fact nor the wiki_fact available to me in the data lake at the moment. They are going to be added soon so it sounds like I'll be able to get the information I need when that happens.
If you have the wiki_dim and wiki_page_dim, then you should also have their corresponding fact tables. Are these still not generating for you?
since my last post the wiki_fact and wiki_page_fact tables have been added to the data lake that I have access to. I'm now able to interrogate these to get page numbers for all courses. Not all the Canvas data tables are available to me, only the ones I need but I had these added.