Edit - cQube

Event:

cQube adopts below event specification.

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

Ex:

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

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:

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

Datasets

Below is the Dataset specification for Datasets

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

1{
  "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"
33}