The most recent content from our members.
Hi everyone, I'm exploring some changes to how the DAP Query API handles schemas, and I want to hear from you before we go too far down any path. Here's the situation. The DAP schema today is fairly sophisticated. It defines specific enum values, type constraints, and so on. That gives you a strong data contract, but it…
Hello, We can't get the assessment_questions or quiz_questions table to finish initializing. The other 6 tables initialized fine and sync daily. We've tried many times to get these two to initialize but on the insert data part they just sit at 0% or sometimes 50%. I've dropped and re-initialized, no luck. Our DAP version…
While running the DAP 2.2 CLI on a Windows 11 machine, using Python 3.3.12, to push data into an Aurora PosgtresQL database, the data load aborts mid way through — it will look something like this: For some of the medium-sized tables I truncated the table, re-tried and it eventually loaded all the data; for this biggest…
Hello! Has anyone noticed slowness/failures in their DAP processes? We use the incremental CLI from DAP overnight starting around 1 AM Arizona Time. It was taking 15-20 minutes for a sync to occur. Then around 4/17 to now it's taking over an hour. Last night we even got 500 errors from the DAP Api and one of our other…
I am trying to migrate a cd2 / dap web_logs database from my local machine to a google cloud virtual machine. I created a postgres dump of the local database, uploaded it to the cloud, and used postgres restore. Now I am trying to syncdb and get the following error. ✗ ERROR: Operation syncdb failed. Reason: Table not…
Hey folks I've finally managed to wrestle all of my DAP queries into Power Bi dataflows, and it was quite an ordeal. I'm currently using dataflows with DAP as a surrogate databasing solution as we do not currently have access to a SQL server that can store our info, otherwise I would probably be fetching this data using…
The issue -- we currently pull reports from the api/v1/reports several times a day, and the person who is responsible for those jobs that has complained to me on multiple occasions that they take a long time and often get stuck or fail, because of the size of the reports. It looks like all of the data in those reports is…
In case it's helpful for anyone, here's my working-and-also-work-in-progress DAG ("Directed Acyclic Graph" -- it's a fancy word for "workflow" or "batch job") for Apache Airflow. It will probably work as far back as 2.4, and I currently have it running on Airflow 2.10. If you're familiar with python, it's probably pretty…
Hello, With the deployment of the 1.3.0 client, I've decided to TRY and migrate from Postgres into my native SQL Server environment. I have successfully initialized ~88 tables, but I know that's not enough. I'm seeing an issue within the Assignments table that probably exists in other tables. The script that's creating the…
I am trying to populate a database with ALL the tables in the Canvas namespace. I am following the instructions on this documentation to initialize my database using the initdb command. Below is my CLI: dap initdb --connection-string my_connection_string --namespace canvas but I get an error saying the table argument is…
Sign in to enhance your access to articles, forums, and events—and to participate by sharing insights, engaging in discussions, and connecting with your network of edtech peers.