Contracts

[
  {
    "contract_id": "network_alarm_v1",
    "warehouse": "bigquery",
    "fivetran_connector_id": "ft_airtable_network",
    "bq_project": "prj-caiml-hackathon-01",
    "bq_dataset": "airtable_network_appxzsmwynqrvmfcq",
    "bq_table": "network_alarm",
    "freshness": {
      "max_delay_minutes": 15
    },
    "schema_block": {
      "required_columns": [
        "alarm_id",
        "cell_id",
        "severity",
        "timestamp"
      ],
      "column_types": {},
      "nullable": {}
    },
    "volume": null,
    "semantic": []
  },
  {
    "contract_id": "network_cdr_freshness_v1",
    "warehouse": "bigquery",
    "fivetran_connector_id": "ft_airtable_network",
    "bq_project": "prj-caiml-hackathon-01",
    "bq_dataset": "airtable_network_appxzsmwynqrvmfcq",
    "bq_table": "cdr",
    "freshness": {
      "max_delay_minutes": 30
    },
    "schema_block": {
      "required_columns": [
        "cdr_id",
        "subscriber_id",
        "charge_amount"
      ],
      "column_types": {
        "charge_amount": "FLOAT"
      },
      "nullable": {}
    },
    "volume": null,
    "semantic": []
  },
  {
    "contract_id": "network_cdr_schema_v1",
    "warehouse": "bigquery",
    "fivetran_connector_id": "ft_airtable_network",
    "bq_project": "prj-caiml-hackathon-01",
    "bq_dataset": "airtable_network_appxzsmwynqrvmfcq",
    "bq_table": "cdr",
    "freshness": {
      "max_delay_minutes": 120
    },
    "schema_block": {
      "required_columns": [
        "cdr_id",
        "subscriber_id",
        "duration_seconds",
        "bytes_transferred",
        "charge_amount"
      ],
      "column_types": {
        "charge_amount": "FLOAT",
        "duration_seconds": "INTEGER",
        "bytes_transferred": "INTEGER"
      },
      "nullable": {
        "charge_amount": false
      }
    },
    "volume": {
      "daily_row_variance_percent": 25
    },
    "semantic": [
      {
        "name": "non_negative_charges",
        "sql": "SELECT COUNT(*) FROM cdr WHERE charge_amount < 0",
        "threshold": 0
      }
    ]
  },
  {
    "contract_id": "network_cell_tower_v1",
    "warehouse": "bigquery",
    "fivetran_connector_id": "ft_airtable_network",
    "bq_project": "prj-caiml-hackathon-01",
    "bq_dataset": "airtable_network_appxzsmwynqrvmfcq",
    "bq_table": "cell_tower",
    "freshness": {
      "max_delay_minutes": 1440
    },
    "schema_block": {
      "required_columns": [
        "cell_id",
        "site_name",
        "latitude",
        "longitude",
        "technology",
        "status"
      ],
      "column_types": {
        "latitude": "FLOAT",
        "longitude": "FLOAT"
      },
      "nullable": {}
    },
    "volume": null,
    "semantic": []
  },
  {
    "contract_id": "network_data_session_v1",
    "warehouse": "bigquery",
    "fivetran_connector_id": "ft_airtable_network",
    "bq_project": "prj-caiml-hackathon-01",
    "bq_dataset": "airtable_network_appxzsmwynqrvmfcq",
    "bq_table": "data_session",
    "freshness": {
      "max_delay_minutes": 60
    },
    "schema_block": {
      "required_columns": [
        "session_id",
        "subscriber_id",
        "apn",
        "rx_bytes",
        "tx_bytes",
        "data_charge"
      ],
      "column_types": {
        "rx_bytes": "INTEGER",
        "tx_bytes": "INTEGER",
        "data_charge": "FLOAT"
      },
      "nullable": {}
    },
    "volume": {
      "daily_row_variance_percent": 30
    },
    "semantic": []
  },
  {
    "contract_id": "network_signal_sample_v1",
    "warehouse": "bigquery",
    "fivetran_connector_id": "ft_airtable_network",
    "bq_project": "prj-caiml-hackathon-01",
    "bq_dataset": "airtable_network_appxzsmwynqrvmfcq",
    "bq_table": "signal_sample",
    "freshness": {
      "max_delay_minutes": 120
    },
    "schema_block": {
      "required_columns": [
        "sample_id",
        "cell_id",
        "subscriber_id",
        "rsrp_dbm",
        "rsrq_db",
        "sampled_at"
      ],
      "column_types": {
        "rsrp_dbm": "FLOAT",
        "rsrq_db": "FLOAT"
      },
      "nullable": {}
    },
    "volume": {
      "daily_row_variance_percent": 40
    },
    "semantic": []
  }
]