I'm fairly new to Canvas Data and SQL. We set up the Canvas CLI tool and I'm able to access the flat file tables. I'm using DB Browser for SQLite to import tables and run reports, but the reports don't align correctly when I join tables. Could you share which database management system (e.g., Tableau, MySQL) you use to import tables and run reports?
Also, I went to InstructureCon and talked with a data person at Canvas Services and they are guessing there is something transposed when I load the table files into the SQLite database. Does anyone have guidance with DB Browser for SQLite?