We've just begun implementation of Canvas and are using this utility as recommended for importing data to SQL Server.
Got through set up and importing data, and scheduling jobs, but now trying to verify data. Data team is pointing out several columns that appear to be missing.....
• In the SQL Course_DIM table, the syllabus_body column is missing.
• In the SQL Enrollment_DIM table, the last_activity_at column is missing.
Addressing the first column noted, I reviewed raw data table for Course_Dim and it looks like maybe left part of Syllabus_Body is being included in the Wiki_Id column when data imported to SQL. I don't see the Syllabus_Body column defined in the CanvasDataStoremmddyyy...sql code. I do see Wiki__Id defined as 50 character, final column in specs (column #14). I believe there should be a column # 15 defined...Syllabus_Body. What is the proper way to resolve this? How many queries, and how many places must modifications be made to do this correctly? Should this simply be addressed by getting an updated version of the CanvasDataStoremmddyyy...sql ? If so....how do I get the right/accurate version of that sql code?
We've just begun implementation of Canvas and are using this utility as recommended for importing data to SQL Server.
Got through set up and importing data, and scheduling jobs, but now trying to verify data. Data team is pointing out several columns that appear to be missing.....
• In the SQL Course_DIM table, the syllabus_body column is missing. • In the SQL Enrollment_DIM table, the last_activity_at column is missing.
Addressing the first column noted, I reviewed raw data table for Course_Dim and it looks like maybe left part of Syllabus_Body is being included in the Wiki_Id column when data imported to SQL. I don't see the Syllabus_Body column defined in the CanvasDataStoremmddyyy...sql code. I do see Wiki__Id defined as 50 character, final column in specs (column #14). I believe there should be a column # 15 defined...Syllabus_Body. What is the proper way to resolve this? How many queries, and how many places must modifications be made to do this correctly? Should this simply be addressed by getting an updated version of the CanvasDataStoremmddyyy...sql ? If so....how do I get the right/accurate version of that sql code?