CD2 - Try to use dap initdb to get all tables but table argement is required

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 required.

dap initdb: error: the following arguments are required: --table

Is there a way to get all the tables instead of running the initdb command manually for the 89 tables on the Canvas namespace?

Thanks!

Find more posts tagged with

cd2 dap

Accepted answers

Gergely Schmidt

Hello everyone, I would like to let you know that we have released DAP CLI 1.4.0 where the main feature is that you can define all or multiple tables for one DAP CLI run:

dap initdb --namespace canvas --table all
OR
dap initdb --namespace canvas --table content_tags,courses,submissions

I hope this helps reducing the complexity in your codebase and makes DAP CLI use easier.

All comments

Robert

The commands are a little confusing at first, because they use 'db', but they are single table only.

dap --loglevel info --logfile courses.log initdb --namespace canvas --table courses;

SunnyYeung

Below is my current workaround to initiate all the tables - using loop.

Note: Switch the keyword from initdb to syncdb to update the data.

FOR %i IN (access_tokens,account_users,accounts,assessment_question_banks,assessment_questions,assignment_groups,assignment_override_students,assignment_overrides,assignments,attachment_associations,attachments,calendar_events,canvadocs_annotation_contexts,comment_bank_items,communication_channels,content_migrations,content_participation_counts,content_participations,content_shares,content_tags,context_external_tools,context_module_progressions,context_modules,conversation_message_participants,conversation_messages,conversation_participants,conversations,course_account_associations,course_sections,courses,custom_gradebook_column_data,custom_gradebook_columns,developer_key_account_bindings,developer_keys,discussion_entries,discussion_entry_participants,discussion_topic_participants,discussion_topics,enrollment_dates_overrides,enrollment_states,enrollment_terms,enrollments,favorites,folders,grading_period_groups,grading_periods,grading_standards,group_categories,group_memberships,groups,late_policies,learning_outcome_groups,learning_outcome_question_results,learning_outcome_results,learning_outcomes,lti_line_items,lti_resource_links,lti_results,master_courses_child_content_tags,master_courses_child_subscriptions,master_courses_master_content_tags,master_courses_master_migrations,master_courses_master_templates,master_courses_migration_results,originality_reports,outcome_proficiencies,outcome_proficiency_ratings,post_policies,pseudonyms,quiz_groups,quiz_questions,quiz_submissions,quizzes,role_overrides,roles,rubric_assessments,rubric_associations,rubrics,score_statistics,scores,submission_comments,submission_versions,submissions,user_account_associations,users,web_conference_participants,web_conferences,wiki_pages,wikis) DO dap --base-url https://api-gateway.instructure.com --client-id=client_id_here --client-secret=client_secret_here initdb --connection-string connection_string_here --namespace canvas --table %i

This list of tables can be created using the following code, then add the commas using Excel.

dap --base-url https://api-gateway.instructure.com --client-id=client_id_here --client-secret=client_secret_here list --namespace canvas

Gergely Schmidt

Hello everyone, I would like to let you know that we have released DAP CLI 1.4.0 where the main feature is that you can define all or multiple tables for one DAP CLI run:

dap initdb --namespace canvas --table all
OR
dap initdb --namespace canvas --table content_tags,courses,submissions

I hope this helps reducing the complexity in your codebase and makes DAP CLI use easier.

Unanswered Questions

EDUCAUSE Insights: Data and Decision-Making
EDUCAUSE is full of inspiration, whether you’re onsite or following from afar. Join the evolution by sharing what sparks your curiosity, the questions you have, and the insights you discover. We'll learn from each other, expand our networks, and strengthen our Community. Your perspective matters, and the more we share,…
Problems with GraphQL in User Pageviews reports
Prompted by the most recent Canvas release notes, we looked into the Page Views feature, and we were happy with the new documented changes. However, we notice that more user actions are done by GraphQL API, which does not provide details in the page view report, either in the GUI or in the CSV file download. We and most…
Metrics Easy Button
I am currently teaching five courses this semester with more than 70 students. To track their progress, I currently have to review each course and section individually, which is very time-consuming. Ideally, I would like to consolidate key information for all students into a single Excel file—showing class attendance…
Analytics API / Metrics calculation logic
Hello, We are currently using the Analytics API provided in the Instructure Developer Documentation Portal to retrieve certain metrics-related data. We would like to know if it’s possible to replicate these datasets using the Canvas Data Platform (CDP), instead of relying on API calls. For example, could you please advise…
CD2: Enhanced Rubrics
Is there a way to tell via CD2 if a course is using Enhanced Rubrics? I didn't see it in the entity diagram for Rubrics table, but I might have missed something... Thanks Ian