Event/Dimension/Datasets Specification

Event:

cQube adopts below event specification.

{
"type": "object",
"properties": {
<COLUMN NAME>: {
"type": "string || number",
"shouldnotnull": true
}
}
}

Ex:

{
    "properties": {
        "date": {
            "type": "string",
            "format": "date"
        },
        "grade_state": {
            "type": "string",
            "unique": true
        },
        "total_teachers": {
            "type": "integer",
            "unique": true
        }
    }
}

Dimension:

cQube adopts below Dimension specification.

{
"title": <NAME OF THE DIMENSION TABLE>,
"indexes": [
{
"columns": [
[
<COLUMN NAME TO BE INDEXED>
]
]
}
],
"properties": {
<COLUMN NAME>: {
"type": "string || number",
"unique": true
}
},
"psql_schema": "dimensions"
}

Example:

{
    "title": "sch_att_teachers_marked_Weekly_cluster",
    "properties": {
        "sum": {
            "type": "number"
        },
        "count": {
            "type": "number"
        },
        "cluster_id": {
            "type": "string"
        }
    },
    "psql_schema": "datasets"
}

Datasets

Below is the Dataset specification for Datasets

{
"title": <NAME OF THE DATASET TABLE>,
"properties": {
<COLUMN NAME>: {
"type": "string || number"
}
},
"psql_schema": "datasets"
}

{
    "title": "subject",
    "indexes": [
        {
            "columns": [
                [
                    "subject_nas",
                    "subject_diksha",
                    "subject_state"
                ]
            ]
        }
    ],
    "properties": {
        "subject_id": {
            "type": "string",
            "unique": true
        },
        "subject_nas": {
            "type": "string",
            "unique": true
        },
        "subject_state": {
            "type": "string",
            "unique": true
        },
        "subject_diksha": {
            "type": "string",
            "unique": true
        }
    },
    "psql_schema": "dimensions"
}