New Columns in the Assignments Table

[sgergely]

We are excited to announce updates to the assignments table in the DAP Query API dataset, designed to enhance your data analysis capabilities. The following new columns will be added:

• parent_assignment_id: This column may contain foreign key references to other assignments. Existing rows created before December 9, 2024, will have NULL values unless a snapshot is taken after this date.
• type: This is a varchar field that will always have a value on our side. Initially, it will contain “Assignment,” but it may also support “SubAssignment” in the future. Please note, there will be no NOT NULL constraint or default value in your database schema; rows created before December 9, 2024, will show NULL unless a snapshot is made.
• has_sub_assignments: This is a boolean field that may indicate whether an assignment contains sub-assignments. While our schema will ensure it always has a value, it will not have a NOT NULL constraint or default value in your schema. For rows created before December 9, 2024, this field will be NULL unless updated by a snapshot.

Important Notes for Customers

• If you have not performed a snapshot, these new fields will appear as NULL for rows created prior to mid-December 2024.
• Your database schema will not enforce constraints like NOT NULL or defaults for these fields, allowing you to customize usage according to your needs.

These changes will go live on December 9th, 2024. Please review your queries and data pipelines to ensure they are prepared to handle these new fields effectively.