Page Comparison

...

{
    "startDate": "2019-01-01",
    "endDate": "2019-02-01",
    "grade": 1,
    "school_id": 901,
    "count": 23
}

...

1. An update to the schema is not supported yet. To update please create a new schema and tie it up to the Dataset Model. Please note that this is a slower process and would lead to a downtime of the cQube instance until the migration is completed. Currently, it can only happen through private APIs exposed to a developer.

   1. If this needs to absolutely happen, create a new dimension, insert the dimension data and run the entire event source through the transformers to update the datasets.

2. A relational database is used to store the data in a flat manner. All fields are flattened and used as column names when creating a dimension table.

3. The schema provided to insert data is used to validate the data before inserting it into the database. This is to ensure that the data is in the correct format and that the data types are correct. AJV is used to validate the data.

...