| # |
| # Licensed to the Apache Software Foundation (ASF) under one |
| # or more contributor license agreements. See the NOTICE file |
| # distributed with this work for additional information |
| # regarding copyright ownership. The ASF licenses this file |
| # to you under the Apache License, Version 2.0 (the |
| # "License"); you may not use this file except in compliance |
| # with the License. You may obtain a copy of the License at |
| # |
| # http://www.apache.org/licenses/LICENSE-2.0 |
| # |
| # Unless required by applicable law or agreed to in writing, |
| # software distributed under the License is distributed on an |
| # "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| # KIND, either express or implied. See the License for the |
| # specific language governing permissions and limitations |
| # under the License. |
| # |
| |
| apiVersion: v1 |
| kind: ConfigMap |
| metadata: |
| name: superset-config |
| namespace: pinot-quickstart |
| data: |
| superset_config.py: |- |
| #--------------------------------------------------------- |
| # Superset specific config |
| #--------------------------------------------------------- |
| ROW_LIMIT = 5000 |
| |
| SUPERSET_WEBSERVER_PORT = 8088 |
| SUPERSET_HOME = '/app/superset_home/superset.db' |
| SUPERSET_ENV = 'production' |
| #--------------------------------------------------------- |
| |
| #--------------------------------------------------------- |
| # Flask App Builder configuration |
| #--------------------------------------------------------- |
| # Your App secret key |
| SECRET_KEY = '\2\1thisismyscretkey\1\2\e\y\y\h' |
| |
| # The SQLAlchemy connection string to your database backend |
| # This connection defines the path to the database that stores your |
| # superset metadata (slices, connections, tables, dashboards, ...). |
| # Note that the connection information to connect to the datasources |
| # you want to explore are managed directly in the web UI |
| SQLALCHEMY_DATABASE_URI = 'sqlite:////app/superset_home/superset.db' |
| |
| # Flask-WTF flag for CSRF |
| WTF_CSRF_ENABLED = True |
| # Add endpoints that need to be exempt from CSRF protection |
| WTF_CSRF_EXEMPT_LIST = [] |
| # A CSRF token that expires in 1 year |
| WTF_CSRF_TIME_LIMIT = 60 * 60 * 24 * 365 |
| |
| # Set this API key to enable Mapbox visualizations |
| MAPBOX_API_KEY = '' |
| |
| pinot_example_datasource.yaml: |- |
| databases: |
| - database_name: pinot-quickstart |
| sqlalchemy_uri: pinot+http://pinot-broker:8099/query?server=http://pinot-controller:9000/ |
| tables: |
| - columns: |
| - column_name: SecondsSinceEpoch |
| is_dttm: true |
| python_date_format: epoch_s |
| type: LONG |
| - column_name: ArrDel15 |
| type: LONG |
| - column_name: DepDel15 |
| type: LONG |
| - column_name: ArrTimeBlk |
| type: STRING |
| - column_name: CRSArrTime |
| type: LONG |
| - column_name: DestAirportSeqID |
| type: LONG |
| - column_name: DivAirportSeqIDs |
| type: LONG |
| - column_name: DestAirportID |
| type: LONG |
| - column_name: DivAirportIDs |
| type: LONG |
| - column_name: DivArrDelay |
| type: LONG |
| - column_name: DivActualElapsedTime |
| type: LONG |
| - column_name: ArrivalDelayGroups |
| type: LONG |
| - column_name: OriginAirportSeqID |
| type: LONG |
| - column_name: OriginAirportID |
| type: LONG |
| - column_name: AirlineID |
| type: LONG |
| - column_name: DivAirports |
| type: STRING |
| - column_name: LateAircraftDelay |
| type: LONG |
| - column_name: DivAirportLandings |
| type: LONG |
| - column_name: ArrDelayMinutes |
| type: LONG |
| - column_name: NASDelay |
| type: LONG |
| - column_name: ArrDelay |
| type: LONG |
| - column_name: ActualElapsedTime |
| type: LONG |
| - column_name: LongestAddGTime |
| type: LONG |
| - column_name: TotalAddGTime |
| type: LONG |
| - column_name: RandomAirports |
| type: STRING |
| - column_name: AirTime |
| type: LONG |
| - column_name: ArrTime |
| type: LONG |
| - column_name: DepTimeBlk |
| type: STRING |
| - column_name: CancellationCode |
| type: STRING |
| - column_name: DestCityMarketID |
| type: LONG |
| - column_name: OriginCityMarketID |
| type: LONG |
| - column_name: DestCityName |
| type: STRING |
| - column_name: CRSDepTime |
| type: LONG |
| - column_name: CarrierDelay |
| type: LONG |
| - column_name: CRSElapsedTime |
| type: LONG |
| - column_name: OriginCityName |
| type: STRING |
| - column_name: UniqueCarrier |
| type: STRING |
| - column_name: Carrier |
| type: STRING |
| - column_name: Cancelled |
| type: LONG |
| - column_name: DepartureDelayGroups |
| type: LONG |
| - column_name: DepDelayMinutes |
| type: LONG |
| - column_name: DivReachedDest |
| type: LONG |
| - column_name: DivDistance |
| type: LONG |
| - column_name: DepDelay |
| type: LONG |
| - column_name: DaysSinceEpoch |
| type: LONG |
| - column_name: FlightDate |
| type: STRING |
| - column_name: DestStateFips |
| type: LONG |
| - column_name: FirstDepTime |
| type: LONG |
| - column_name: DivLongestGTimes |
| type: LONG |
| - column_name: DivTotalGTimes |
| type: LONG |
| - column_name: DistanceGroup |
| type: LONG |
| - column_name: DestStateName |
| type: STRING |
| - column_name: DivTailNums |
| type: STRING |
| - column_name: DestState |
| type: STRING |
| - column_name: Dest |
| type: STRING |
| - column_name: DayofMonth |
| type: LONG |
| - column_name: DayOfWeek |
| type: LONG |
| - column_name: DivWheelsOffs |
| type: LONG |
| - column_name: DivWheelsOns |
| type: LONG |
| - column_name: SecurityDelay |
| type: LONG |
| - column_name: DepTime |
| type: LONG |
| - column_name: WeatherDelay |
| type: LONG |
| - column_name: DestWac |
| type: LONG |
| - column_name: Distance |
| type: LONG |
| - column_name: Diverted |
| type: LONG |
| - column_name: FlightNum |
| type: LONG |
| - column_name: OriginStateFips |
| type: LONG |
| - column_name: Flights |
| type: LONG |
| - column_name: TaxiIn |
| type: LONG |
| - column_name: OriginStateName |
| type: STRING |
| - column_name: TailNum |
| type: STRING |
| - column_name: OriginState |
| type: STRING |
| - column_name: Origin |
| type: STRING |
| - column_name: Month |
| type: LONG |
| - column_name: TaxiOut |
| type: LONG |
| - column_name: OriginWac |
| type: LONG |
| - column_name: WheelsOff |
| type: LONG |
| - column_name: WheelsOn |
| type: LONG |
| - column_name: Quarter |
| type: LONG |
| - column_name: Year |
| type: LONG |
| metrics: |
| - expression: COUNT(*) |
| metric_name: count |
| metric_type: count |
| verbose_name: COUNT(*) |
| table_name: airlineStats |
| |
| pinot_example_dashboard.json: |- |
| { |
| "dashboards": [ |
| { |
| "__Dashboard__": { |
| "css": "", |
| "dashboard_title": "AirlineStats", |
| "description": null, |
| "json_metadata": "{\"default_filters\": \"{}\", \"expanded_slices\": {}, \"import_time\": 1584979678, \"refresh_frequency\": 0, \"remote_id\": 1, \"timed_refresh_immune_slices\": []}", |
| "position_json": "{\"CHART-EPWTG21UAl\": {\"children\": [], \"id\": \"CHART-EPWTG21UAl\", \"meta\": {\"chartId\": 2, \"height\": 50, \"sliceName\": \"Destination States Flight Time Series\", \"width\": 4}, \"parents\": [\"ROOT_ID\", \"GRID_ID\", \"ROW-DHJKqb0-2\"], \"type\": \"CHART\"}, \"CHART-F0aEdk-eR-\": {\"children\": [], \"id\": \"CHART-F0aEdk-eR-\", \"meta\": {\"chartId\": 3, \"height\": 50, \"sliceName\": \"Flight Count Per City\", \"width\": 4}, \"parents\": [\"ROOT_ID\", \"GRID_ID\", \"ROW-DHJKqb0-2\"], \"type\": \"CHART\"}, \"CHART-YLcJ6aWYSa\": {\"children\": [], \"id\": \"CHART-YLcJ6aWYSa\", \"meta\": {\"chartId\": 1, \"height\": 50, \"sliceName\": \"Flight Destination City Count\", \"width\": 4}, \"parents\": [\"ROOT_ID\", \"GRID_ID\", \"ROW-DHJKqb0-2\"], \"type\": \"CHART\"}, \"DASHBOARD_VERSION_KEY\": \"v2\", \"GRID_ID\": {\"children\": [\"ROW-DHJKqb0-2\"], \"id\": \"GRID_ID\", \"parents\": [\"ROOT_ID\"], \"type\": \"GRID\"}, \"HEADER_ID\": {\"id\": \"HEADER_ID\", \"meta\": {\"text\": \"AirlineStats\"}, \"type\": \"HEADER\"}, \"ROOT_ID\": {\"children\": [\"GRID_ID\"], \"id\": \"ROOT_ID\", \"type\": \"ROOT\"}, \"ROW-DHJKqb0-2\": {\"children\": [\"CHART-YLcJ6aWYSa\", \"CHART-EPWTG21UAl\", \"CHART-F0aEdk-eR-\"], \"id\": \"ROW-DHJKqb0-2\", \"meta\": {\"background\": \"BACKGROUND_TRANSPARENT\"}, \"parents\": [\"ROOT_ID\", \"GRID_ID\"], \"type\": \"ROW\"}}", |
| "slices": [ |
| { |
| "__Slice__": { |
| "cache_timeout": null, |
| "datasource_name": "airlineStats", |
| "datasource_type": "table", |
| "id": 1, |
| "params": "{\"adhoc_filters\": [], \"bar_stacked\": false, \"bottom_margin\": \"auto\", \"color_scheme\": \"bnbColors\", \"columns\": [], \"contribution\": false, \"database_name\": \"pinot-quickstart\", \"datasource\": \"1__table\", \"datasource_name\": \"airlineStats\", \"granularity_sqla\": null, \"groupby\": [\"DestCityName\"], \"import_time\": 1584979678, \"label_colors\": {}, \"metrics\": [\"count\"], \"order_bars\": false, \"reduce_x_ticks\": false, \"remote_id\": 1, \"row_limit\": 10000, \"schema\": null, \"show_bar_value\": false, \"show_controls\": false, \"show_legend\": true, \"slice_id\": 1, \"time_range\": \"Last week\", \"url_params\": {}, \"viz_type\": \"dist_bar\", \"x_axis_label\": \"\", \"x_ticks_layout\": \"auto\", \"y_axis_format\": \"SMART_NUMBER\", \"y_axis_label\": \"\"}", |
| "slice_name": "Flight Destination City Count", |
| "viz_type": "dist_bar" |
| } |
| }, |
| { |
| "__Slice__": { |
| "cache_timeout": null, |
| "datasource_name": "airlineStats", |
| "datasource_type": "table", |
| "id": 2, |
| "params": "{\"adhoc_filters\": [], \"annotation_layers\": [], \"bottom_margin\": \"auto\", \"color_scheme\": \"bnbColors\", \"comparison_type\": \"values\", \"contribution\": false, \"database_name\": \"pinot-quickstart\", \"datasource\": \"1__table\", \"datasource_name\": \"airlineStats\", \"granularity_sqla\": \"SecondsSinceEpoch\", \"groupby\": [\"DestStateName\"], \"import_time\": 1584979678, \"label_colors\": {}, \"left_margin\": \"auto\", \"line_interpolation\": \"linear\", \"metrics\": [\"count\"], \"order_desc\": true, \"remote_id\": 2, \"resample_method\": null, \"resample_rule\": null, \"rich_tooltip\": true, \"rolling_type\": \"None\", \"row_limit\": 10000, \"schema\": null, \"send_time_range\": false, \"show_brush\": \"auto\", \"show_legend\": true, \"show_markers\": false, \"time_grain_sqla\": \"P1D\", \"time_range\": \"No filter\", \"timeseries_limit_metric\": null, \"url_params\": {}, \"viz_type\": \"line\", \"x_axis_format\": \"smart_date\", \"x_axis_label\": \"\", \"x_axis_showminmax\": false, \"x_ticks_layout\": \"auto\", \"y_axis_bounds\": [null, null], \"y_axis_format\": \"SMART_NUMBER\", \"y_axis_label\": \"\", \"y_axis_showminmax\": false, \"y_log_scale\": false}", |
| "slice_name": "Destination States Flight Time Series", |
| "viz_type": "line" |
| } |
| }, |
| { |
| "__Slice__": { |
| "cache_timeout": null, |
| "datasource_name": "airlineStats", |
| "datasource_type": "table", |
| "id": 3, |
| "params": "{\"adhoc_filters\": [], \"columns\": [], \"combine_metric\": false, \"database_name\": \"pinot-quickstart\", \"datasource\": \"1__table\", \"datasource_name\": \"airlineStats\", \"granularity_sqla\": \"SecondsSinceEpoch\", \"groupby\": [\"DestCityName\"], \"import_time\": 1584979678, \"metrics\": [\"count\"], \"number_format\": \"SMART_NUMBER\", \"pandas_aggfunc\": \"sum\", \"pivot_margins\": true, \"remote_id\": 3, \"row_limit\": 50000, \"schema\": null, \"time_grain_sqla\": \"P1D\", \"time_range\": \"No filter\", \"transpose_pivot\": false, \"url_params\": {}, \"viz_type\": \"pivot_table\"}", |
| "slice_name": "Flight Count Per City", |
| "viz_type": "pivot_table" |
| } |
| } |
| ], |
| "slug": null |
| } |
| } |
| ], |
| "datasources": [ |
| { |
| "__SqlaTable__": { |
| "cache_timeout": null, |
| "columns": [ |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "SecondsSinceEpoch", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 1, |
| "is_active": true, |
| "is_dttm": true, |
| "python_date_format": "epoch_s", |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "ArrDel15", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 2, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "DepDel15", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 3, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "ArrTimeBlk", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 4, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "CRSArrTime", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 5, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "DestAirportSeqID", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 6, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "DivAirportSeqIDs", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 7, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "DestAirportID", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 8, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "DivAirportIDs", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 9, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "DivArrDelay", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 10, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "DivActualElapsedTime", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 11, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "ArrivalDelayGroups", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 12, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "OriginAirportSeqID", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 13, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "OriginAirportID", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 14, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "AirlineID", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 15, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "DivAirports", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 16, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "LateAircraftDelay", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 17, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "DivAirportLandings", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 18, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "ArrDelayMinutes", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 19, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "NASDelay", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 20, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "ArrDelay", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 21, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "ActualElapsedTime", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 22, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "LongestAddGTime", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 23, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "TotalAddGTime", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 24, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "RandomAirports", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 25, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "AirTime", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 26, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "ArrTime", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 27, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "DepTimeBlk", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 28, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "CancellationCode", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 29, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "DestCityMarketID", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 30, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "OriginCityMarketID", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 31, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "DestCityName", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 32, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "CRSDepTime", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 33, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "CarrierDelay", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 34, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "CRSElapsedTime", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 35, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "column_name": "OriginCityName", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 36, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "UniqueCarrier", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 37, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "Carrier", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 38, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "Cancelled", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 39, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DepartureDelayGroups", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 40, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DepDelayMinutes", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 41, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DivReachedDest", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 42, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DivDistance", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 43, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DepDelay", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 44, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DaysSinceEpoch", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 45, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "FlightDate", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 46, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DestStateFips", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 47, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "FirstDepTime", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 48, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DivLongestGTimes", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 49, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DivTotalGTimes", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 50, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DistanceGroup", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 51, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DestStateName", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 52, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DivTailNums", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 53, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DestState", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 54, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "Dest", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 55, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DayofMonth", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 56, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DayOfWeek", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 57, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DivWheelsOffs", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 58, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DivWheelsOns", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 59, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "SecurityDelay", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 60, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DepTime", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 61, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "WeatherDelay", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 62, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "DestWac", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 63, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "Distance", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 64, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "Diverted", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 65, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "FlightNum", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 66, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "OriginStateFips", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 67, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "Flights", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 68, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "TaxiIn", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 69, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "OriginStateName", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 70, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "TailNum", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 71, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "OriginState", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 72, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "Origin", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 73, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "STRING", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "Month", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 74, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "TaxiOut", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 75, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "OriginWac", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 76, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "WheelsOff", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 77, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "WheelsOn", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 78, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "Quarter", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 79, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| }, |
| { |
| "__TableColumn__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "column_name": "Year", |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:55" |
| }, |
| "description": null, |
| "expression": null, |
| "filterable": true, |
| "groupby": true, |
| "id": 80, |
| "is_active": true, |
| "is_dttm": false, |
| "python_date_format": null, |
| "table_id": 1, |
| "type": "LONG", |
| "verbose_name": null |
| } |
| } |
| ], |
| "database_id": 3, |
| "default_endpoint": null, |
| "description": null, |
| "fetch_values_predicate": null, |
| "filter_select_enabled": false, |
| "main_dttm_col": null, |
| "metrics": [ |
| { |
| "__SqlMetric__": { |
| "changed_by_fk": null, |
| "changed_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "created_by_fk": null, |
| "created_on": { |
| "__datetime__": "2020-03-23T16:07:54" |
| }, |
| "d3format": null, |
| "description": null, |
| "expression": "COUNT(*)", |
| "id": 1, |
| "metric_name": "count", |
| "metric_type": "count", |
| "table_id": 1, |
| "verbose_name": "COUNT(*)", |
| "warning_text": null |
| } |
| } |
| ], |
| "offset": 0, |
| "params": "{\"remote_id\": 1, \"database_name\": \"pinot-quickstart\", \"import_time\": 1584979678}", |
| "schema": null, |
| "sql": null, |
| "table_name": "airlineStats", |
| "template_params": null |
| } |
| } |
| ] |
| } |
| |
| |
| --- |
| apiVersion: apps/v1 |
| kind: StatefulSet |
| metadata: |
| name: superset |
| namespace: pinot-quickstart |
| spec: |
| selector: |
| matchLabels: |
| app: superset |
| serviceName: superset |
| replicas: 1 |
| updateStrategy: |
| type: RollingUpdate |
| podManagementPolicy: Parallel |
| template: |
| metadata: |
| labels: |
| app: superset |
| spec: |
| terminationGracePeriodSeconds: 30 |
| securityContext: |
| runAsUser: 1000 |
| runAsGroup: 1000 |
| fsGroup: 1000 |
| containers: |
| - image: apachepinot/pinot-superset:latest |
| imagePullPolicy: Always |
| name: superset |
| args: [ "superset", "run", "-p", "8088", "--with-threads", "--reload", "--debugger", "--host=0.0.0.0" ] |
| env: |
| - name: PYTHONPATH |
| value: "/etc/superset" |
| ports: |
| - containerPort: 8088 |
| protocol: TCP |
| resources: |
| requests: |
| memory: 1Gi |
| volumeMounts: |
| - name: superset-storage-vol |
| mountPath: "/app/superset_home" |
| - name: superset-config |
| mountPath: "/etc/superset" |
| nodeSelector: {} |
| restartPolicy: Always |
| volumes: |
| - name: superset-config |
| configMap: |
| name: superset-config |
| volumeClaimTemplates: |
| - metadata: |
| name: superset-storage-vol |
| annotations: |
| pv.beta.kubernetes.io/gid: "1000" |
| pv.beta.kubernetes.io/groups: "1000" |
| spec: |
| accessModes: |
| - ReadWriteOnce |
| storageClassName: "default" # "pd-ssd" or "standard" for GKE, "hostpath" for docker-desktop |
| resources: |
| requests: |
| storage: 1Gi |
| |
| --- |
| apiVersion: v1 |
| kind: Service |
| metadata: |
| name: superset |
| namespace: pinot-quickstart |
| spec: |
| ports: |
| # [podname].superset.pinot-quickstart.svc.cluster.local |
| - port: 8088 |
| clusterIP: None |
| selector: |
| app: superset |