HiveSparkScylla_datasource.yaml

databases:
- allow_run_async: true
  database_name: HiveSparkScylla
  expose_in_sqllab: true
  extra: "{\r\n    \"metadata_params\": {},\r\n    \"engine_params\": {}\r\n}\r\n"
  sqlalchemy_uri: hive://172.17.0.3:10000/default
  tables:
  - columns:
    - {avg: true, column_name: co_ppm, sum: true, type: INT}
    - {column_name: sensor_id, filterable: true, groupby: true, type: STRING}
    - {column_name: location, filterable: true, groupby: true, type: STRING}
    - {column_name: time, is_dttm: true, type: TIMESTAMP}
    main_dttm_col: time
    metrics:
    - {expression: AVG(co_ppm), metric_name: avg__co_ppm, metric_type: avg}
    - {expression: COUNT(*), metric_name: count, metric_type: count, verbose_name: COUNT(*)}
    - {expression: SUM(co_ppm), metric_name: sum__co_ppm, metric_type: sum}
    schema: ''
    table_name: air_quality