This is an automated email from the ASF dual-hosted git repository.
rusackas pushed a commit to branch superset-community-dashboard
in repository https://gitbox.apache.org/repos/asf/superset.git
The following commit(s) were added to refs/heads/superset-community-dashboard
by this push:
new 649db07ea7 feat(example): Superset Community Dashboard
649db07ea7 is described below
commit 649db07ea7f0d4e8e661d03b0e2f4ba3e9de6f5e
Author: Evan Rusackas <[email protected]>
AuthorDate: Fri Apr 19 17:17:32 2024 -0600
feat(example): Superset Community Dashboard
---
.../100_Most_Stale_Issues_83.yaml | 58 ++
.../100_Most_Stale_PRs_82.yaml | 81 ++
.../10_Worst_Files_76.yaml | 43 +
.../Backlog_-_ESLint_75.yaml | 54 ++
.../Debt_Timeline_by_Rule_74.yaml | 84 ++
.../GitHub_commits_by_author_90_days_90.yaml | 109 +++
.../Low_Hanging_Fruit_by_File_80.yaml | 69 ++
.../Low_Hanging_Fruit_by_Rule_79.yaml | 69 ++
.../PR_Staleness_Distribution_85.yaml | 59 ++
.../Staleness_distribution_84.yaml | 31 +
.../Ten_Worst_Violations_ESLint_77.yaml | 43 +
.../Top_10_Committers_90_days_91.yaml | 85 ++
.../Total_Rule_Violations_78.yaml | 65 ++
.../Weekly_Commits_on_GitHub_89.yaml | 83 ++
.../dashboards/Superset_Community_Dashboard.yaml | 930 +++++++++++++++++++++
.../examples/configs/databases/Shillelagh.yaml | 28 +
.../datasets/Shillelagh/Open_Superset_Issues.yaml | 447 ++++++++++
.../datasets/Shillelagh/Open_Superset_PRs.yaml | 230 +++++
.../Shillelagh/Superset_Commits_by_Committer.yaml | 73 ++
.../Superset_Tech_Debt_-_Aggregated.yaml | 102 +++
.../Shillelagh/Superset_Tech_Debt_-_ESLint.yaml | 141 ++++
.../Shillelagh/Superset_Weekly_Commits.yaml | 58 ++
22 files changed, 2942 insertions(+)
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/100_Most_Stale_Issues_83.yaml
b/superset/examples/configs/charts/Superset Community
Dashboard/100_Most_Stale_Issues_83.yaml
new file mode 100644
index 0000000000..1f916ef93c
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/100_Most_Stale_Issues_83.yaml
@@ -0,0 +1,58 @@
+slice_name: 100 Most Stale Issues
+description: null
+certified_by: null
+certification_details: null
+viz_type: table
+params:
+ datasource: 25__table
+ viz_type: table
+ slice_id: 83
+ query_mode: raw
+ groupby: []
+ time_grain_sqla: P1D
+ temporal_columns_lookup:
+ updated_at: true
+ created_at: true
+ all_columns:
+ - title
+ - link
+ - username
+ - created_at
+ - updated_at
+ - days_stale
+ - days_old
+ percent_metrics: []
+ adhoc_filters:
+ - clause: WHERE
+ comparator: No filter
+ datasourceWarning: false
+ expressionType: SIMPLE
+ filterOptionName: filter_92e89ndhg9k_77quhii36wg
+ isExtra: false
+ isNew: false
+ operator: TEMPORAL_RANGE
+ sqlExpression: null
+ subject: created_at
+ order_by_cols: []
+ row_limit: 100
+ server_page_length: 10
+ order_desc: true
+ table_timestamp_format: smart_date
+ show_cell_bars: true
+ color_pn: true
+ column_config:
+ days_old:
+ d3NumberFormat: ',.1f'
+ days_stale:
+ d3NumberFormat: ',.1f'
+ conditional_formatting: []
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context:
'{"datasource":{"id":25,"type":"table"},"force":false,"queries":[{"filters":[{"col":"created_at","op":"TEMPORAL_RANGE","val":"No
+
filter"}],"extras":{"time_grain_sqla":"P1D","having":"","where":""},"applied_time_extras":{},"columns":["title","link","username","created_at","updated_at","days_stale","days_old"],"orderby":[],"annotation_layers":[],"row_limit":100,"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{},"post_processing":[]}],"form_data":{"datasource":"25__table","viz_type":"table","slice_id":83,"query_mode":"raw","groupby":[],"time_grain_sqla":"P1D","temporal_colum
[...]
+
filter","datasourceWarning":false,"expressionType":"SIMPLE","filterOptionName":"filter_92e89ndhg9k_77quhii36wg","isExtra":false,"isNew":false,"operator":"TEMPORAL_RANGE","sqlExpression":null,"subject":"created_at"}],"order_by_cols":[],"row_limit":100,"server_page_length":10,"order_desc":true,"table_timestamp_format":"smart_date","show_cell_bars":true,"color_pn":true,"column_config":{"days_old":{"d3NumberFormat":",.1f"},"days_stale":{"d3NumberFormat":",.1f"}},"conditional_formatting":[]
[...]
+cache_timeout: null
+uuid: 1e747519-6ad1-4c48-add6-30b77aeca0a5
+version: 1.0.0
+dataset_uuid: 62f869ed-dc5e-4a2d-b5b3-6ae897ecb385
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/100_Most_Stale_PRs_82.yaml
b/superset/examples/configs/charts/Superset Community
Dashboard/100_Most_Stale_PRs_82.yaml
new file mode 100644
index 0000000000..9ee5878e4a
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/100_Most_Stale_PRs_82.yaml
@@ -0,0 +1,81 @@
+slice_name: 100 Most Stale PRs
+description: null
+certified_by: null
+certification_details: null
+viz_type: table
+params:
+ datasource: 24__table
+ viz_type: table
+ slice_id: 82
+ query_mode: raw
+ groupby: []
+ time_grain_sqla: P1D
+ temporal_columns_lookup:
+ created_at: true
+ updated_at: true
+ all_columns:
+ - title
+ - link
+ - username
+ - created_at
+ - updated_at
+ - days_stale
+ - days_old
+ percent_metrics: []
+ adhoc_filters:
+ - clause: WHERE
+ comparator: No filter
+ datasourceWarning: false
+ expressionType: SIMPLE
+ filterOptionName: filter_2qpdpgzc47y_ni3xx1demmq
+ isExtra: false
+ isNew: false
+ operator: TEMPORAL_RANGE
+ sqlExpression: null
+ subject: created_at
+ - clause: WHERE
+ comparator: false
+ datasourceWarning: false
+ expressionType: SIMPLE
+ filterOptionName: filter_dbis9uwbxrm_451s5mj9ruu
+ isExtra: false
+ isNew: false
+ operator: ==
+ operatorId: IS_FALSE
+ sqlExpression: null
+ subject: draft
+ - clause: WHERE
+ comparator: open
+ datasourceWarning: false
+ expressionType: SIMPLE
+ filterOptionName: filter_vt3fipjn1dc_x82ah8mv3m
+ isExtra: false
+ isNew: false
+ operator: ==
+ operatorId: EQUALS
+ sqlExpression: null
+ subject: state
+ order_by_cols: []
+ row_limit: 100
+ server_page_length: 10
+ order_desc: true
+ table_timestamp_format: smart_date
+ show_cell_bars: true
+ color_pn: true
+ column_config:
+ days_old:
+ d3NumberFormat: ',.1f'
+ days_stale:
+ currencyFormat: {}
+ d3NumberFormat: ',.1f'
+ conditional_formatting: []
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context:
'{"datasource":{"id":24,"type":"table"},"force":false,"queries":[{"filters":[{"col":"created_at","op":"TEMPORAL_RANGE","val":"No
+
filter"},{"col":"draft","op":"==","val":false},{"col":"state","op":"==","val":"open"}],"extras":{"time_grain_sqla":"P1D","having":"","where":""},"applied_time_extras":{},"columns":["title","link","username","created_at","updated_at","days_stale","days_old"],"orderby":[],"annotation_layers":[],"row_limit":100,"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{},"post_processing":[]}],"form_data":{"datasource":"24__table","viz_type":"table","slice_i
[...]
+
filter","datasourceWarning":false,"expressionType":"SIMPLE","filterOptionName":"filter_2qpdpgzc47y_ni3xx1demmq","isExtra":false,"isNew":false,"operator":"TEMPORAL_RANGE","sqlExpression":null,"subject":"created_at"},{"clause":"WHERE","comparator":false,"datasourceWarning":false,"expressionType":"SIMPLE","filterOptionName":"filter_dbis9uwbxrm_451s5mj9ruu","isExtra":false,"isNew":false,"operator":"==","operatorId":"IS_FALSE","sqlExpression":null,"subject":"draft"},{"clause":"WHERE","compa
[...]
+cache_timeout: null
+uuid: ef4e3a16-5550-46b1-9a00-3305cf45cf47
+version: 1.0.0
+dataset_uuid: 0543be35-e3cb-4b8e-89a9-bee3e424d9a1
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/10_Worst_Files_76.yaml b/superset/examples/configs/charts/Superset
Community Dashboard/10_Worst_Files_76.yaml
new file mode 100644
index 0000000000..cf143e101a
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/10_Worst_Files_76.yaml
@@ -0,0 +1,43 @@
+slice_name: 10 Worst Files
+description: null
+certified_by: null
+certification_details: null
+viz_type: pie
+params:
+ datasource: 22__table
+ viz_type: pie
+ slice_id: 76
+ groupby:
+ - File
+ metric: count
+ adhoc_filters:
+ - clause: WHERE
+ comparator: No filter
+ expressionType: SIMPLE
+ operator: TEMPORAL_RANGE
+ subject: Timestamp
+ row_limit: 10
+ sort_by_metric: true
+ color_scheme: supersetColors
+ show_labels_threshold: 5
+ show_legend: true
+ legendType: scroll
+ legendOrientation: top
+ label_type: key
+ number_format: SMART_NUMBER
+ date_format: smart_date
+ show_labels: true
+ labels_outside: true
+ outerRadius: 70
+ donut: true
+ innerRadius: 50
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context:
'{"datasource":{"id":22,"type":"table"},"force":false,"queries":[{"filters":[{"col":"Timestamp","op":"TEMPORAL_RANGE","val":"No
+
filter"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":["File"],"metrics":["count"],"orderby":[["count",false]],"annotation_layers":[],"row_limit":10,"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{}}],"form_data":{"datasource":"22__table","viz_type":"pie","slice_id":76,"groupby":["File"],"metric":"count","adhoc_filters":[{"clause":"WHERE","comparator":"No
+
filter","expressionType":"SIMPLE","operator":"TEMPORAL_RANGE","subject":"Timestamp"}],"row_limit":10,"sort_by_metric":true,"color_scheme":"supersetColors","show_labels_threshold":5,"show_legend":true,"legendType":"scroll","legendOrientation":"top","label_type":"key","number_format":"SMART_NUMBER","date_format":"smart_date","show_labels":true,"labels_outside":true,"outerRadius":70,"donut":true,"innerRadius":50,"extra_form_data":{},"dashboards":[9],"force":false,"result_format":"json","r
[...]
+cache_timeout: null
+uuid: e34a4358-0681-43b1-839e-82f1399b97ce
+version: 1.0.0
+dataset_uuid: 12fa12ec-9d44-4eb8-8222-9f495849ad82
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/Backlog_-_ESLint_75.yaml b/superset/examples/configs/charts/Superset
Community Dashboard/Backlog_-_ESLint_75.yaml
new file mode 100644
index 0000000000..8955768adf
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/Backlog_-_ESLint_75.yaml
@@ -0,0 +1,54 @@
+slice_name: Backlog - ESLint
+description: null
+certified_by: null
+certification_details: null
+viz_type: table
+params:
+ datasource: 22__table
+ viz_type: table
+ slice_id: 75
+ query_mode: raw
+ groupby: []
+ time_grain_sqla: P1D
+ temporal_columns_lookup:
+ Timestamp: true
+ all_columns:
+ - Rule
+ - Link
+ - Rule Description
+ - cleaned_file_path
+ - Line
+ - Column
+ - ESLint Message
+ percent_metrics: []
+ adhoc_filters:
+ - clause: WHERE
+ comparator: No filter
+ expressionType: SIMPLE
+ operator: TEMPORAL_RANGE
+ subject: Timestamp
+ order_by_cols: []
+ row_limit: 1000
+ server_page_length: 10
+ order_desc: true
+ table_timestamp_format: smart_date
+ show_cell_bars: false
+ color_pn: true
+ allow_rearrange_columns: false
+ column_config:
+ File:
+ columnWidth: 160
+ truncateLongCells: true
+ conditional_formatting: []
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context:
'{"datasource":{"id":22,"type":"table"},"force":false,"queries":[{"filters":[{"col":"Timestamp","op":"TEMPORAL_RANGE","val":"No
+
filter"}],"extras":{"time_grain_sqla":"P1D","having":"","where":""},"applied_time_extras":{},"columns":["Rule","Link","Rule
+ Description","cleaned_file_path","Line","Column","ESLint
Message"],"orderby":[],"annotation_layers":[],"row_limit":1000,"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{},"post_processing":[]}],"form_data":{"datasource":"22__table","viz_type":"table","slice_id":75,"query_mode":"raw","groupby":[],"time_grain_sqla":"P1D","temporal_columns_lookup":{"Timestamp":true},"all_columns":["Rule","Link","Rule
+ Description","cleaned_file_path","Line","Column","ESLint
Message"],"percent_metrics":[],"adhoc_filters":[{"clause":"WHERE","comparator":"No
+
filter","expressionType":"SIMPLE","operator":"TEMPORAL_RANGE","subject":"Timestamp"}],"order_by_cols":[],"row_limit":1000,"server_page_length":10,"order_desc":true,"table_timestamp_format":"smart_date","show_cell_bars":false,"color_pn":true,"allow_rearrange_columns":false,"column_config":{"File":{"columnWidth":160,"truncateLongCells":true}},"conditional_formatting":[],"extra_form_data":{},"dashboards":[9],"force":false,"result_format":"json","result_type":"full","include_time":false},"
[...]
+cache_timeout: null
+uuid: 68cf3d84-afe6-496e-8960-401fe27d0c58
+version: 1.0.0
+dataset_uuid: 12fa12ec-9d44-4eb8-8222-9f495849ad82
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/Debt_Timeline_by_Rule_74.yaml
b/superset/examples/configs/charts/Superset Community
Dashboard/Debt_Timeline_by_Rule_74.yaml
new file mode 100644
index 0000000000..1603f3cbbc
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/Debt_Timeline_by_Rule_74.yaml
@@ -0,0 +1,84 @@
+slice_name: Debt Timeline (by Rule)
+description: null
+certified_by: null
+certification_details: null
+viz_type: echarts_timeseries_line
+params:
+ datasource: 21__table
+ viz_type: echarts_timeseries_line
+ slice_id: 74
+ x_axis: Timestamp
+ x_axis_sort_asc: true
+ x_axis_sort_series: name
+ x_axis_sort_series_ascending: true
+ metrics:
+ - expressionType: SIMPLE
+ column:
+ advanced_data_type: null
+ certification_details: null
+ certified_by: null
+ column_name: Count
+ description: null
+ expression: null
+ filterable: true
+ groupby: true
+ id: 854
+ is_certified: false
+ is_dttm: false
+ python_date_format: null
+ type: INT
+ type_generic: 0
+ verbose_name: null
+ warning_markdown: null
+ aggregate: SUM
+ sqlExpression: null
+ datasourceWarning: false
+ hasCustomLabel: false
+ label: SUM(Count)
+ optionName: metric_7lqddvjwzrn_1gt26m0c22z
+ groupby:
+ - Rule
+ adhoc_filters:
+ - clause: WHERE
+ comparator: No filter
+ expressionType: SIMPLE
+ operator: TEMPORAL_RANGE
+ subject: Timestamp
+ order_desc: true
+ row_limit: 1000
+ truncate_metric: true
+ show_empty_columns: true
+ comparison_type: values
+ annotation_layers: []
+ forecastPeriods: 10
+ forecastInterval: 0.8
+ x_axis_title_margin: 15
+ y_axis_title_margin: 15
+ y_axis_title_position: Left
+ sort_series_type: sum
+ color_scheme: supersetColors
+ seriesType: line
+ only_total: true
+ opacity: 0.2
+ markerSize: 6
+ show_legend: true
+ legendType: scroll
+ legendOrientation: top
+ x_axis_time_format: smart_date
+ rich_tooltip: true
+ tooltipTimeFormat: smart_date
+ y_axis_format: SMART_NUMBER
+ truncateXAxis: true
+ y_axis_bounds:
+ - null
+ - null
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context:
'{"datasource":{"id":21,"type":"table"},"force":false,"queries":[{"filters":[{"col":"Timestamp","op":"TEMPORAL_RANGE","val":"No
+
filter"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":[{"columnType":"BASE_AXIS","sqlExpression":"Timestamp","label":"Timestamp","expressionType":"SQL"},"Rule"],"metrics":[{"expressionType":"SIMPLE","column":{"advanced_data_type":null,"certification_details":null,"certified_by":null,"column_name":"Count","description":null,"expression":null,"filterable":true,"groupby":true,"id":854,"is_certified":false,"is_dttm":false,"python_date_format":null,"type":"INT","typ
[...]
+
filter","expressionType":"SIMPLE","operator":"TEMPORAL_RANGE","subject":"Timestamp"}],"order_desc":true,"row_limit":1000,"truncate_metric":true,"show_empty_columns":true,"comparison_type":"values","annotation_layers":[],"forecastPeriods":10,"forecastInterval":0.8,"x_axis_title_margin":15,"y_axis_title_margin":15,"y_axis_title_position":"Left","sort_series_type":"sum","color_scheme":"supersetColors","seriesType":"line","only_total":true,"opacity":0.2,"markerSize":6,"show_legend":true,"l
[...]
+cache_timeout: null
+uuid: 93f3714b-8401-415e-9d4c-2c8806dfc02f
+version: 1.0.0
+dataset_uuid: a3b0a980-a1b4-4463-89fd-91e6d3347313
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/GitHub_commits_by_author_90_days_90.yaml
b/superset/examples/configs/charts/Superset Community
Dashboard/GitHub_commits_by_author_90_days_90.yaml
new file mode 100644
index 0000000000..2aecff1d49
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/GitHub_commits_by_author_90_days_90.yaml
@@ -0,0 +1,109 @@
+slice_name: GitHub commits by author (90 days)
+description: null
+certified_by: null
+certification_details: null
+viz_type: echarts_area
+params:
+ datasource: 34__table
+ viz_type: echarts_area
+ slice_id: 90
+ x_axis: week
+ time_grain_sqla: P1D
+ x_axis_sort_asc: true
+ x_axis_sort_series: name
+ x_axis_sort_series_ascending: true
+ metrics:
+ - aggregate: SUM
+ column:
+ advanced_data_type: null
+ certification_details: null
+ certified_by: null
+ column_name: commits
+ description: null
+ expression: null
+ filterable: true
+ groupby: true
+ id: 880
+ is_certified: false
+ is_dttm: false
+ python_date_format: null
+ type: INT
+ type_generic: 0
+ verbose_name: null
+ warning_markdown: null
+ datasourceWarning: false
+ expressionType: SIMPLE
+ hasCustomLabel: false
+ label: SUM(commits)
+ optionName: metric_wd0f1eqn3p_yu0bi8667qa
+ sqlExpression: null
+ groupby:
+ - handle
+ adhoc_filters:
+ - expressionType: SIMPLE
+ subject: handle
+ operator: NOT IN
+ operatorId: NOT_IN
+ comparator:
+ - actions-user
+ clause: WHERE
+ sqlExpression: null
+ isExtra: false
+ isNew: false
+ datasourceWarning: false
+ filterOptionName: filter_ef7mua9sbha_xefpfnxs3yl
+ - expressionType: SIMPLE
+ subject: week
+ operator: TEMPORAL_RANGE
+ comparator: Last quarter
+ clause: WHERE
+ sqlExpression: null
+ isExtra: false
+ isNew: false
+ datasourceWarning: false
+ filterOptionName: filter_h7a1db1tplh_f9hktetotbe
+ order_desc: true
+ row_limit: 1000
+ truncate_metric: true
+ show_empty_columns: true
+ rolling_type: sum
+ comparison_type: values
+ resample_method: zerofill
+ annotation_layers: []
+ forecastPeriods: 10
+ forecastInterval: 0.8
+ x_axis_title_margin: 15
+ y_axis_title_margin: 15
+ y_axis_title_position: Left
+ sort_series_type: sum
+ sort_series_ascending: true
+ color_scheme: supersetColors
+ seriesType: line
+ opacity: 1
+ stack: Stack
+ only_total: true
+ markerEnabled: false
+ markerSize: 6
+ zoomable: true
+ show_legend: true
+ legendType: scroll
+ legendOrientation: top
+ x_axis_time_format: smart_date
+ rich_tooltip: true
+ tooltipTimeFormat: smart_date
+ y_axis_format: SMART_NUMBER
+ truncateXAxis: true
+ y_axis_bounds:
+ - null
+ - null
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context:
'{"datasource":{"id":34,"type":"table"},"force":false,"queries":[{"filters":[{"col":"handle","op":"NOT
+ IN","val":["actions-user"]},{"col":"week","op":"TEMPORAL_RANGE","val":"Last
quarter"}],"extras":{"time_grain_sqla":"P1D","having":"","where":""},"applied_time_extras":{},"columns":[{"timeGrain":"P1D","columnType":"BASE_AXIS","sqlExpression":"week","label":"week","expressionType":"SQL"},"handle"],"metrics":[{"aggregate":"SUM","column":{"advanced_data_type":null,"certification_details":null,"certified_by":null,"column_name":"commits","description":null,"expression":null,"filterable":true
[...]
+
IN","operatorId":"NOT_IN","comparator":["actions-user"],"clause":"WHERE","sqlExpression":null,"isExtra":false,"isNew":false,"datasourceWarning":false,"filterOptionName":"filter_ef7mua9sbha_xefpfnxs3yl"},{"expressionType":"SIMPLE","subject":"week","operator":"TEMPORAL_RANGE","comparator":"Last
+
quarter","clause":"WHERE","sqlExpression":null,"isExtra":false,"isNew":false,"datasourceWarning":false,"filterOptionName":"filter_h7a1db1tplh_f9hktetotbe"}],"order_desc":true,"row_limit":1000,"truncate_metric":true,"show_empty_columns":true,"rolling_type":"sum","comparison_type":"values","resample_method":"zerofill","annotation_layers":[],"forecastPeriods":10,"forecastInterval":0.8,"x_axis_title_margin":15,"y_axis_title_margin":15,"y_axis_title_position":"Left","sort_series_type":"sum"
[...]
+cache_timeout: null
+uuid: 723dadf6-8699-4f31-a869-6f456a341c98
+version: 1.0.0
+dataset_uuid: e8dd2f72-0592-4bdd-a9cf-bf825024f4f5
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/Low_Hanging_Fruit_by_File_80.yaml
b/superset/examples/configs/charts/Superset Community
Dashboard/Low_Hanging_Fruit_by_File_80.yaml
new file mode 100644
index 0000000000..5dd4786db8
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/Low_Hanging_Fruit_by_File_80.yaml
@@ -0,0 +1,69 @@
+slice_name: Low Hanging Fruit by File
+description: null
+certified_by: null
+certification_details: null
+viz_type: table
+params:
+ datasource: 22__table
+ viz_type: table
+ slice_id: 79
+ query_mode: aggregate
+ groupby:
+ - File
+ temporal_columns_lookup:
+ Timestamp: true
+ metrics:
+ - aggregate: COUNT
+ column:
+ advanced_data_type: null
+ certification_details: null
+ certified_by: null
+ column_name: ESLint Message
+ description: null
+ expression: null
+ filterable: true
+ groupby: true
+ id: 745
+ is_certified: false
+ is_dttm: false
+ python_date_format: null
+ type: STRING
+ type_generic: 1
+ verbose_name: null
+ warning_markdown: null
+ datasourceWarning: false
+ expressionType: SIMPLE
+ hasCustomLabel: false
+ label: COUNT(ESLint Message)
+ optionName: metric_n27rlniqi4h_23ktjxr2plb
+ sqlExpression: null
+ all_columns: []
+ percent_metrics: []
+ adhoc_filters:
+ - clause: WHERE
+ comparator: No filter
+ expressionType: SIMPLE
+ operator: TEMPORAL_RANGE
+ subject: Timestamp
+ timeseries_limit_metric: count
+ order_by_cols: []
+ row_limit: 50
+ server_page_length: 10
+ order_desc: false
+ table_timestamp_format: smart_date
+ show_cell_bars: true
+ color_pn: true
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context:
'{"datasource":{"id":22,"type":"table"},"force":false,"queries":[{"filters":[{"col":"Timestamp","op":"TEMPORAL_RANGE","val":"No
+
filter"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":["File"],"metrics":[{"aggregate":"COUNT","column":{"advanced_data_type":null,"certification_details":null,"certified_by":null,"column_name":"ESLint
+
Message","description":null,"expression":null,"filterable":true,"groupby":true,"id":745,"is_certified":false,"is_dttm":false,"python_date_format":null,"type":"STRING","type_generic":1,"verbose_name":null,"warning_markdown":null},"datasourceWarning":false,"expressionType":"SIMPLE","hasCustomLabel":false,"label":"COUNT(ESLint
+
Message)","optionName":"metric_n27rlniqi4h_23ktjxr2plb","sqlExpression":null}],"orderby":[["count",true]],"annotation_layers":[],"row_limit":50,"series_limit":0,"series_limit_metric":"count","order_desc":false,"url_params":{},"custom_params":{},"custom_form_data":{},"post_processing":[]}],"form_data":{"datasource":"22__table","viz_type":"table","slice_id":79,"query_mode":"aggregate","groupby":["File"],"temporal_columns_lookup":{"Timestamp":true},"metrics":[{"aggregate":"COUNT","column"
[...]
+
Message","description":null,"expression":null,"filterable":true,"groupby":true,"id":745,"is_certified":false,"is_dttm":false,"python_date_format":null,"type":"STRING","type_generic":1,"verbose_name":null,"warning_markdown":null},"datasourceWarning":false,"expressionType":"SIMPLE","hasCustomLabel":false,"label":"COUNT(ESLint
+
Message)","optionName":"metric_n27rlniqi4h_23ktjxr2plb","sqlExpression":null}],"all_columns":[],"percent_metrics":[],"adhoc_filters":[{"clause":"WHERE","comparator":"No
+
filter","expressionType":"SIMPLE","operator":"TEMPORAL_RANGE","subject":"Timestamp"}],"timeseries_limit_metric":"count","order_by_cols":[],"row_limit":50,"server_page_length":10,"order_desc":false,"table_timestamp_format":"smart_date","show_cell_bars":true,"color_pn":true,"extra_form_data":{},"dashboards":[9],"force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}'
+cache_timeout: null
+uuid: 63a1ac01-9daf-4064-a455-ef9f5b64933f
+version: 1.0.0
+dataset_uuid: 12fa12ec-9d44-4eb8-8222-9f495849ad82
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/Low_Hanging_Fruit_by_Rule_79.yaml
b/superset/examples/configs/charts/Superset Community
Dashboard/Low_Hanging_Fruit_by_Rule_79.yaml
new file mode 100644
index 0000000000..36e7e4c913
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/Low_Hanging_Fruit_by_Rule_79.yaml
@@ -0,0 +1,69 @@
+slice_name: Low Hanging Fruit by Rule
+description: null
+certified_by: null
+certification_details: null
+viz_type: table
+params:
+ datasource: 22__table
+ viz_type: table
+ slice_id: 79
+ query_mode: aggregate
+ groupby:
+ - Rule
+ temporal_columns_lookup:
+ Timestamp: true
+ metrics:
+ - aggregate: COUNT
+ column:
+ advanced_data_type: null
+ certification_details: null
+ certified_by: null
+ column_name: ESLint Message
+ description: null
+ expression: null
+ filterable: true
+ groupby: true
+ id: 745
+ is_certified: false
+ is_dttm: false
+ python_date_format: null
+ type: STRING
+ type_generic: 1
+ verbose_name: null
+ warning_markdown: null
+ datasourceWarning: false
+ expressionType: SIMPLE
+ hasCustomLabel: false
+ label: COUNT(ESLint Message)
+ optionName: metric_n27rlniqi4h_23ktjxr2plb
+ sqlExpression: null
+ all_columns: []
+ percent_metrics: []
+ adhoc_filters:
+ - clause: WHERE
+ comparator: No filter
+ expressionType: SIMPLE
+ operator: TEMPORAL_RANGE
+ subject: Timestamp
+ timeseries_limit_metric: count
+ order_by_cols: []
+ row_limit: 50
+ server_page_length: 10
+ order_desc: false
+ table_timestamp_format: smart_date
+ show_cell_bars: true
+ color_pn: true
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context:
'{"datasource":{"id":22,"type":"table"},"force":false,"queries":[{"filters":[{"col":"Timestamp","op":"TEMPORAL_RANGE","val":"No
+
filter"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":["Rule"],"metrics":[{"aggregate":"COUNT","column":{"advanced_data_type":null,"certification_details":null,"certified_by":null,"column_name":"ESLint
+
Message","description":null,"expression":null,"filterable":true,"groupby":true,"id":745,"is_certified":false,"is_dttm":false,"python_date_format":null,"type":"STRING","type_generic":1,"verbose_name":null,"warning_markdown":null},"datasourceWarning":false,"expressionType":"SIMPLE","hasCustomLabel":false,"label":"COUNT(ESLint
+
Message)","optionName":"metric_n27rlniqi4h_23ktjxr2plb","sqlExpression":null}],"orderby":[["count",true]],"annotation_layers":[],"row_limit":50,"series_limit":0,"series_limit_metric":"count","order_desc":false,"url_params":{},"custom_params":{},"custom_form_data":{},"post_processing":[]}],"form_data":{"datasource":"22__table","viz_type":"table","slice_id":79,"query_mode":"aggregate","groupby":["Rule"],"temporal_columns_lookup":{"Timestamp":true},"metrics":[{"aggregate":"COUNT","column"
[...]
+
Message","description":null,"expression":null,"filterable":true,"groupby":true,"id":745,"is_certified":false,"is_dttm":false,"python_date_format":null,"type":"STRING","type_generic":1,"verbose_name":null,"warning_markdown":null},"datasourceWarning":false,"expressionType":"SIMPLE","hasCustomLabel":false,"label":"COUNT(ESLint
+
Message)","optionName":"metric_n27rlniqi4h_23ktjxr2plb","sqlExpression":null}],"all_columns":[],"percent_metrics":[],"adhoc_filters":[{"clause":"WHERE","comparator":"No
+
filter","expressionType":"SIMPLE","operator":"TEMPORAL_RANGE","subject":"Timestamp"}],"timeseries_limit_metric":"count","order_by_cols":[],"row_limit":50,"server_page_length":10,"order_desc":false,"table_timestamp_format":"smart_date","show_cell_bars":true,"color_pn":true,"extra_form_data":{},"dashboards":[9],"force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}'
+cache_timeout: null
+uuid: 477b5aa7-6d40-4e52-908e-e899c45935af
+version: 1.0.0
+dataset_uuid: 12fa12ec-9d44-4eb8-8222-9f495849ad82
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/PR_Staleness_Distribution_85.yaml
b/superset/examples/configs/charts/Superset Community
Dashboard/PR_Staleness_Distribution_85.yaml
new file mode 100644
index 0000000000..c9287fa92e
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/PR_Staleness_Distribution_85.yaml
@@ -0,0 +1,59 @@
+slice_name: PR Staleness Distribution
+description: null
+certified_by: null
+certification_details: null
+viz_type: histogram
+params:
+ datasource: 24__table
+ viz_type: histogram
+ slice_id: 82
+ all_columns_x:
+ - days_stale
+ adhoc_filters:
+ - clause: WHERE
+ comparator: No filter
+ datasourceWarning: false
+ expressionType: SIMPLE
+ filterOptionName: filter_2qpdpgzc47y_ni3xx1demmq
+ isExtra: false
+ isNew: false
+ operator: TEMPORAL_RANGE
+ sqlExpression: null
+ subject: created_at
+ - clause: WHERE
+ comparator: false
+ datasourceWarning: false
+ expressionType: SIMPLE
+ filterOptionName: filter_dbis9uwbxrm_451s5mj9ruu
+ isExtra: false
+ isNew: false
+ operator: ==
+ operatorId: IS_FALSE
+ sqlExpression: null
+ subject: draft
+ - clause: WHERE
+ comparator: open
+ datasourceWarning: false
+ expressionType: SIMPLE
+ filterOptionName: filter_vt3fipjn1dc_x82ah8mv3m
+ isExtra: false
+ isNew: false
+ operator: ==
+ operatorId: EQUALS
+ sqlExpression: null
+ subject: state
+ row_limit: 1000
+ groupby: []
+ color_scheme: supersetColors
+ link_length: 5
+ show_legend: true
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context:
'{"datasource":{"id":24,"type":"table"},"force":false,"queries":[{"filters":[{"col":"created_at","op":"TEMPORAL_RANGE","val":"No
+
filter"},{"col":"draft","op":"==","val":false},{"col":"state","op":"==","val":"open"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":[],"metrics":[],"annotation_layers":[],"row_limit":1000,"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{}}],"form_data":{"datasource":"24__table","viz_type":"histogram","slice_id":82,"all_columns_x":["days_stale"],"adhoc_filters":[{"clause":"WHERE","comparator":"No
+
filter","datasourceWarning":false,"expressionType":"SIMPLE","filterOptionName":"filter_2qpdpgzc47y_ni3xx1demmq","isExtra":false,"isNew":false,"operator":"TEMPORAL_RANGE","sqlExpression":null,"subject":"created_at"},{"clause":"WHERE","comparator":false,"datasourceWarning":false,"expressionType":"SIMPLE","filterOptionName":"filter_dbis9uwbxrm_451s5mj9ruu","isExtra":false,"isNew":false,"operator":"==","operatorId":"IS_FALSE","sqlExpression":null,"subject":"draft"},{"clause":"WHERE","compa
[...]
+cache_timeout: null
+uuid: a8088108-6b36-4f27-8119-367be6acb267
+version: 1.0.0
+dataset_uuid: 0543be35-e3cb-4b8e-89a9-bee3e424d9a1
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/Staleness_distribution_84.yaml
b/superset/examples/configs/charts/Superset Community
Dashboard/Staleness_distribution_84.yaml
new file mode 100644
index 0000000000..a83bc78513
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/Staleness_distribution_84.yaml
@@ -0,0 +1,31 @@
+slice_name: Staleness distribution
+description: null
+certified_by: null
+certification_details: null
+viz_type: histogram
+params:
+ datasource: 25__table
+ viz_type: histogram
+ all_columns_x:
+ - days_stale
+ adhoc_filters:
+ - clause: WHERE
+ subject: updated_at
+ operator: TEMPORAL_RANGE
+ comparator: No filter
+ expressionType: SIMPLE
+ row_limit: 10000
+ groupby: []
+ color_scheme: supersetColors
+ link_length: 5
+ show_legend: true
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context:
'{"datasource":{"id":25,"type":"table"},"force":false,"queries":[{"filters":[{"col":"updated_at","op":"TEMPORAL_RANGE","val":"No
+
filter"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":[],"metrics":[],"annotation_layers":[],"row_limit":10000,"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{}}],"form_data":{"datasource":"25__table","viz_type":"histogram","all_columns_x":["days_stale"],"adhoc_filters":[{"clause":"WHERE","subject":"updated_at","operator":"TEMPORAL_RANGE","comparator":"No
+
filter","expressionType":"SIMPLE"}],"row_limit":10000,"groupby":[],"color_scheme":"supersetColors","link_length":5,"show_legend":true,"extra_form_data":{},"dashboards":[9],"force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}'
+cache_timeout: null
+uuid: 14b0d6bb-4c34-4c52-8c0f-afecffbc0492
+version: 1.0.0
+dataset_uuid: 62f869ed-dc5e-4a2d-b5b3-6ae897ecb385
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/Ten_Worst_Violations_ESLint_77.yaml
b/superset/examples/configs/charts/Superset Community
Dashboard/Ten_Worst_Violations_ESLint_77.yaml
new file mode 100644
index 0000000000..55d3a60d01
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/Ten_Worst_Violations_ESLint_77.yaml
@@ -0,0 +1,43 @@
+slice_name: Ten Worst Violations (ESLint)
+description: null
+certified_by: null
+certification_details: null
+viz_type: pie
+params:
+ datasource: 22__table
+ viz_type: pie
+ slice_id: 77
+ groupby:
+ - Rule
+ metric: count
+ adhoc_filters:
+ - clause: WHERE
+ comparator: No filter
+ expressionType: SIMPLE
+ operator: TEMPORAL_RANGE
+ subject: Timestamp
+ row_limit: 10
+ sort_by_metric: true
+ color_scheme: supersetColors
+ show_labels_threshold: 5
+ show_legend: true
+ legendType: scroll
+ legendOrientation: top
+ label_type: key
+ number_format: SMART_NUMBER
+ date_format: smart_date
+ show_labels: true
+ labels_outside: true
+ outerRadius: 70
+ donut: true
+ innerRadius: 50
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context:
'{"datasource":{"id":22,"type":"table"},"force":false,"queries":[{"filters":[{"col":"Timestamp","op":"TEMPORAL_RANGE","val":"No
+
filter"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":["Rule"],"metrics":["count"],"orderby":[["count",false]],"annotation_layers":[],"row_limit":10,"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{}}],"form_data":{"datasource":"22__table","viz_type":"pie","slice_id":77,"groupby":["Rule"],"metric":"count","adhoc_filters":[{"clause":"WHERE","comparator":"No
+
filter","expressionType":"SIMPLE","operator":"TEMPORAL_RANGE","subject":"Timestamp"}],"row_limit":10,"sort_by_metric":true,"color_scheme":"supersetColors","show_labels_threshold":5,"show_legend":true,"legendType":"scroll","legendOrientation":"top","label_type":"key","number_format":"SMART_NUMBER","date_format":"smart_date","show_labels":true,"labels_outside":true,"outerRadius":70,"donut":true,"innerRadius":50,"extra_form_data":{},"dashboards":[9],"force":false,"result_format":"json","r
[...]
+cache_timeout: null
+uuid: 785c3bc9-fc76-446f-b725-2905071c5601
+version: 1.0.0
+dataset_uuid: 12fa12ec-9d44-4eb8-8222-9f495849ad82
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/Top_10_Committers_90_days_91.yaml
b/superset/examples/configs/charts/Superset Community
Dashboard/Top_10_Committers_90_days_91.yaml
new file mode 100644
index 0000000000..360e0a1e75
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/Top_10_Committers_90_days_91.yaml
@@ -0,0 +1,85 @@
+slice_name: Top 10 Committers (90 days)
+description: null
+certified_by: null
+certification_details: null
+viz_type: pie
+params:
+ datasource: 34__table
+ viz_type: pie
+ slice_id: 91
+ groupby:
+ - handle
+ metric:
+ aggregate: SUM
+ column:
+ advanced_data_type: null
+ certification_details: null
+ certified_by: null
+ column_name: commits
+ description: null
+ expression: null
+ filterable: true
+ groupby: true
+ id: 880
+ is_certified: false
+ is_dttm: false
+ python_date_format: null
+ type: INT
+ type_generic: 0
+ verbose_name: null
+ warning_markdown: null
+ datasourceWarning: false
+ expressionType: SIMPLE
+ hasCustomLabel: false
+ label: SUM(commits)
+ optionName: metric_wd0f1eqn3p_yu0bi8667qa
+ sqlExpression: null
+ adhoc_filters:
+ - expressionType: SIMPLE
+ subject: handle
+ operator: NOT IN
+ operatorId: NOT_IN
+ comparator:
+ - actions-user
+ clause: WHERE
+ sqlExpression: null
+ isExtra: false
+ isNew: false
+ datasourceWarning: false
+ filterOptionName: filter_ef7mua9sbha_xefpfnxs3yl
+ - expressionType: SIMPLE
+ subject: week
+ operator: TEMPORAL_RANGE
+ comparator: Last quarter
+ clause: WHERE
+ sqlExpression: null
+ isExtra: false
+ isNew: false
+ datasourceWarning: false
+ filterOptionName: filter_ne575qpyub_s6usfs93hsm
+ row_limit: 10
+ sort_by_metric: true
+ color_scheme: supersetColors
+ show_labels_threshold: 5
+ show_legend: true
+ legendType: scroll
+ legendOrientation: top
+ label_type: key
+ number_format: SMART_NUMBER
+ date_format: smart_date
+ show_labels: true
+ labels_outside: true
+ outerRadius: 70
+ donut: true
+ innerRadius: 53
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context:
'{"datasource":{"id":34,"type":"table"},"force":false,"queries":[{"filters":[{"col":"handle","op":"NOT
+ IN","val":["actions-user"]},{"col":"week","op":"TEMPORAL_RANGE","val":"Last
quarter"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":["handle"],"metrics":[{"aggregate":"SUM","column":{"advanced_data_type":null,"certification_details":null,"certified_by":null,"column_name":"commits","description":null,"expression":null,"filterable":true,"groupby":true,"id":880,"is_certified":false,"is_dttm":false,"python_date_format":null,"type":"INT","type_generic":0,"verbose_nam
[...]
+
IN","operatorId":"NOT_IN","comparator":["actions-user"],"clause":"WHERE","sqlExpression":null,"isExtra":false,"isNew":false,"datasourceWarning":false,"filterOptionName":"filter_ef7mua9sbha_xefpfnxs3yl"},{"expressionType":"SIMPLE","subject":"week","operator":"TEMPORAL_RANGE","comparator":"Last
+
quarter","clause":"WHERE","sqlExpression":null,"isExtra":false,"isNew":false,"datasourceWarning":false,"filterOptionName":"filter_ne575qpyub_s6usfs93hsm"}],"row_limit":10,"sort_by_metric":true,"color_scheme":"supersetColors","show_labels_threshold":5,"show_legend":true,"legendType":"scroll","legendOrientation":"top","label_type":"key","number_format":"SMART_NUMBER","date_format":"smart_date","show_labels":true,"labels_outside":true,"outerRadius":70,"donut":true,"innerRadius":53,"extra_
[...]
+cache_timeout: null
+uuid: ade8f58e-1c8a-4bcb-a802-8b6548ded28d
+version: 1.0.0
+dataset_uuid: e8dd2f72-0592-4bdd-a9cf-bf825024f4f5
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/Total_Rule_Violations_78.yaml
b/superset/examples/configs/charts/Superset Community
Dashboard/Total_Rule_Violations_78.yaml
new file mode 100644
index 0000000000..0d9c2eed1c
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/Total_Rule_Violations_78.yaml
@@ -0,0 +1,65 @@
+slice_name: Total Rule Violations
+description: null
+certified_by: null
+certification_details: null
+viz_type: big_number
+params:
+ datasource: 21__table
+ viz_type: big_number
+ slice_id: 78
+ x_axis: Timestamp
+ metric:
+ expressionType: SIMPLE
+ column:
+ advanced_data_type: null
+ changed_on: '2024-02-28T23:00:08.955865'
+ column_name: Count
+ created_on: '2024-02-28T23:00:08.955862'
+ description: null
+ expression: null
+ extra: '{}'
+ filterable: true
+ groupby: true
+ id: 854
+ is_active: true
+ is_dttm: false
+ python_date_format: null
+ type: INT
+ type_generic: 0
+ uuid: ca0928ca-6fdd-4060-a4d8-081ed78c7c70
+ verbose_name: null
+ aggregate: SUM
+ sqlExpression: null
+ datasourceWarning: false
+ hasCustomLabel: false
+ label: SUM(Count)
+ optionName: metric_jyyoyd30lpb_pivw96rugfa
+ adhoc_filters:
+ - clause: WHERE
+ comparator: No filter
+ expressionType: SIMPLE
+ operator: TEMPORAL_RANGE
+ subject: Timestamp
+ show_trend_line: true
+ start_y_axis_at_zero: true
+ color_picker:
+ a: 1
+ b: 135
+ g: 122
+ r: 0
+ header_font_size: 0.4
+ subheader_font_size: 0.15
+ y_axis_format: SMART_NUMBER
+ time_format: smart_date
+ rolling_type: None
+ extra_form_data: {}
+ dashboards:
+ - 8
+ - 9
+query_context:
'{"datasource":{"id":21,"type":"table"},"force":false,"queries":[{"filters":[{"col":"Timestamp","op":"TEMPORAL_RANGE","val":"No
+
filter"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":[{"columnType":"BASE_AXIS","sqlExpression":"Timestamp","label":"Timestamp","expressionType":"SQL"}],"metrics":[{"expressionType":"SIMPLE","column":{"advanced_data_type":null,"changed_on":"2024-02-28T23:00:08.955865","column_name":"Count","created_on":"2024-02-28T23:00:08.955862","description":null,"expression":null,"extra":"{}","filterable":true,"groupby":true,"id":854,"is_active":true,"is_dttm":false,"pytho
[...]
+
filter","expressionType":"SIMPLE","operator":"TEMPORAL_RANGE","subject":"Timestamp"}],"show_trend_line":true,"start_y_axis_at_zero":true,"color_picker":{"a":1,"b":135,"g":122,"r":0},"header_font_size":0.4,"subheader_font_size":0.15,"y_axis_format":"SMART_NUMBER","time_format":"smart_date","rolling_type":"None","extra_form_data":{},"dashboards":[8,9],"force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}'
+cache_timeout: null
+uuid: 2a260abd-8ada-49f1-af51-e9b956f1826c
+version: 1.0.0
+dataset_uuid: a3b0a980-a1b4-4463-89fd-91e6d3347313
diff --git a/superset/examples/configs/charts/Superset Community
Dashboard/Weekly_Commits_on_GitHub_89.yaml
b/superset/examples/configs/charts/Superset Community
Dashboard/Weekly_Commits_on_GitHub_89.yaml
new file mode 100644
index 0000000000..2942bd1ae0
--- /dev/null
+++ b/superset/examples/configs/charts/Superset Community
Dashboard/Weekly_Commits_on_GitHub_89.yaml
@@ -0,0 +1,83 @@
+slice_name: Weekly Commits on GitHub
+description: null
+certified_by: null
+certification_details: null
+viz_type: echarts_timeseries_line
+params:
+ datasource: 33__table
+ viz_type: echarts_timeseries_line
+ x_axis: week
+ x_axis_sort_asc: true
+ x_axis_sort_series: name
+ x_axis_sort_series_ascending: true
+ metrics:
+ - expressionType: SIMPLE
+ column:
+ advanced_data_type: null
+ changed_on: '2024-04-19T21:53:07.621808'
+ column_name: total
+ created_on: '2024-04-19T21:53:07.621806'
+ description: null
+ expression: null
+ extra: '{"warning_markdown":null}'
+ filterable: true
+ groupby: true
+ id: 878
+ is_active: true
+ is_dttm: false
+ python_date_format: null
+ type: INT
+ type_generic: 0
+ uuid: 27ac65c4-2615-48ef-83fc-c7262de31331
+ verbose_name: null
+ aggregate: SUM
+ sqlExpression: null
+ datasourceWarning: false
+ hasCustomLabel: false
+ label: SUM(total)
+ optionName: metric_dwip4hq975t_lvo3oi3e9eo
+ groupby: []
+ adhoc_filters:
+ - clause: WHERE
+ subject: week
+ operator: TEMPORAL_RANGE
+ comparator: No filter
+ expressionType: SIMPLE
+ order_desc: true
+ row_limit: 1000
+ truncate_metric: true
+ show_empty_columns: true
+ comparison_type: values
+ annotation_layers: []
+ forecastPeriods: 10
+ forecastInterval: 0.8
+ x_axis_title_margin: 15
+ y_axis_title_margin: 15
+ y_axis_title_position: Left
+ sort_series_type: sum
+ color_scheme: supersetColors
+ seriesType: line
+ only_total: true
+ opacity: 0.2
+ markerSize: 6
+ show_legend: true
+ legendType: scroll
+ legendOrientation: top
+ x_axis_time_format: smart_date
+ rich_tooltip: true
+ tooltipTimeFormat: smart_date
+ y_axis_format: SMART_NUMBER
+ truncateXAxis: true
+ y_axis_bounds:
+ - null
+ - null
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context:
'{"datasource":{"id":33,"type":"table"},"force":false,"queries":[{"filters":[{"col":"week","op":"TEMPORAL_RANGE","val":"No
+
filter"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":[{"columnType":"BASE_AXIS","sqlExpression":"week","label":"week","expressionType":"SQL"}],"metrics":[{"expressionType":"SIMPLE","column":{"advanced_data_type":null,"changed_on":"2024-04-19T21:53:07.621808","column_name":"total","created_on":"2024-04-19T21:53:07.621806","description":null,"expression":null,"extra":"{\"warning_markdown\":null}","filterable":true,"groupby":true,"id":878,"is_active":true,"is_dtt
[...]
+
filter","expressionType":"SIMPLE"}],"order_desc":true,"row_limit":1000,"truncate_metric":true,"show_empty_columns":true,"comparison_type":"values","annotation_layers":[],"forecastPeriods":10,"forecastInterval":0.8,"x_axis_title_margin":15,"y_axis_title_margin":15,"y_axis_title_position":"Left","sort_series_type":"sum","color_scheme":"supersetColors","seriesType":"line","only_total":true,"opacity":0.2,"markerSize":6,"show_legend":true,"legendType":"scroll","legendOrientation":"top","x_a
[...]
+cache_timeout: null
+uuid: f6e65e97-aac1-4480-9beb-e7caed078e79
+version: 1.0.0
+dataset_uuid: 7edda5f1-d1e1-457e-b3c5-2b850071eb23
diff --git
a/superset/examples/configs/dashboards/Superset_Community_Dashboard.yaml
b/superset/examples/configs/dashboards/Superset_Community_Dashboard.yaml
new file mode 100644
index 0000000000..e21c1a536d
--- /dev/null
+++ b/superset/examples/configs/dashboards/Superset_Community_Dashboard.yaml
@@ -0,0 +1,930 @@
+dashboard_title: Superset Community Dashboard
+description: null
+css: ''
+slug: null
+certified_by: ''
+certification_details: ''
+published: true
+uuid: 84cfc008-c88b-4982-8731-90b4aad2824b
+position:
+ CHART-2hoATK8Zsx:
+ children: []
+ id: CHART-2hoATK8Zsx
+ meta:
+ chartId: 77
+ height: 50
+ sliceName: Ten Worst Violations (ESLint)
+ uuid: 785c3bc9-fc76-446f-b725-2905071c5601
+ width: 3
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ - TABS-5EgQDONu1A
+ - TAB-6MZrK7E3jw
+ - ROW-9m7gUYjSq
+ type: CHART
+ CHART-8DBtgQCnUB:
+ children: []
+ id: CHART-8DBtgQCnUB
+ meta:
+ chartId: 74
+ height: 50
+ sliceName: Debt Timeline (by Rule)
+ uuid: 93f3714b-8401-415e-9d4c-2c8806dfc02f
+ width: 8
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ - ROW-9MsZ7cYIcO
+ type: CHART
+ CHART-WlJ6qakWX-:
+ children: []
+ id: CHART-WlJ6qakWX-
+ meta:
+ chartId: 78
+ height: 50
+ sliceName: Total Rule Violations
+ uuid: 2a260abd-8ada-49f1-af51-e9b956f1826c
+ width: 4
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ - ROW-9MsZ7cYIcO
+ type: CHART
+ CHART-explore-79-1:
+ children: []
+ id: CHART-explore-79-1
+ meta:
+ chartId: 79
+ height: 50
+ sliceName: Low Hanging Fruit by Rule
+ uuid: 477b5aa7-6d40-4e52-908e-e899c45935af
+ width: 3
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ - TABS-5EgQDONu1A
+ - TAB-6MZrK7E3jw
+ - ROW-9m7gUYjSq
+ type: CHART
+ CHART-explore-80-1:
+ children: []
+ id: CHART-explore-80-1
+ meta:
+ chartId: 80
+ height: 50
+ sliceName: Low Hanging Fruit by File
+ uuid: 63a1ac01-9daf-4064-a455-ef9f5b64933f
+ width: 3
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ - TABS-5EgQDONu1A
+ - TAB-6MZrK7E3jw
+ - ROW-9m7gUYjSq
+ type: CHART
+ CHART-explore-82-1:
+ children: []
+ id: CHART-explore-82-1
+ meta:
+ chartId: 82
+ height: 50
+ sliceName: 100 Most Stale PRs
+ uuid: ef4e3a16-5550-46b1-9a00-3305cf45cf47
+ width: 8
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-gQNdNGxEm
+ - ROW-_HD44Ptqc
+ type: CHART
+ CHART-explore-83-1:
+ children: []
+ id: CHART-explore-83-1
+ meta:
+ chartId: 83
+ height: 50
+ sliceName: 100 Most Stale Issues
+ uuid: 1e747519-6ad1-4c48-add6-30b77aeca0a5
+ width: 8
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-gQNdNGxEm
+ - ROW-QBodkPkjd
+ type: CHART
+ CHART-explore-84-1:
+ children: []
+ id: CHART-explore-84-1
+ meta:
+ chartId: 84
+ height: 50
+ sliceName: Staleness distribution
+ uuid: 14b0d6bb-4c34-4c52-8c0f-afecffbc0492
+ width: 4
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-gQNdNGxEm
+ - ROW-QBodkPkjd
+ type: CHART
+ CHART-explore-85-1:
+ children: []
+ id: CHART-explore-85-1
+ meta:
+ chartId: 85
+ height: 50
+ sliceName: PR Staleness Distribution
+ uuid: a8088108-6b36-4f27-8119-367be6acb267
+ width: 4
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-gQNdNGxEm
+ - ROW-_HD44Ptqc
+ type: CHART
+ CHART-explore-89-1:
+ children: []
+ id: CHART-explore-89-1
+ meta:
+ chartId: 89
+ height: 32
+ sliceName: Weekly Commits on GitHub
+ uuid: f6e65e97-aac1-4480-9beb-e7caed078e79
+ width: 12
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-0iG6IOxPs
+ - ROW-GeI7emy5O
+ type: CHART
+ CHART-explore-90-1:
+ children: []
+ id: CHART-explore-90-1
+ meta:
+ chartId: 90
+ height: 50
+ sliceName: GitHub commits by author (90 days)
+ uuid: 723dadf6-8699-4f31-a869-6f456a341c98
+ width: 7
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-0iG6IOxPs
+ - ROW-8vrQEmqRL
+ type: CHART
+ CHART-explore-91-1:
+ children: []
+ id: CHART-explore-91-1
+ meta:
+ chartId: 91
+ height: 50
+ sliceName: Top 10 Committers (90 days)
+ uuid: ade8f58e-1c8a-4bcb-a802-8b6548ded28d
+ width: 5
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-0iG6IOxPs
+ - ROW-8vrQEmqRL
+ type: CHART
+ CHART-hVo1r3LAvM:
+ children: []
+ id: CHART-hVo1r3LAvM
+ meta:
+ chartId: 75
+ height: 50
+ sliceName: Backlog - ESLint
+ uuid: 68cf3d84-afe6-496e-8960-401fe27d0c58
+ width: 12
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ - TABS-5EgQDONu1A
+ - TAB-6MZrK7E3jw
+ - ROW-ceGPqkcuF0
+ type: CHART
+ CHART-ne2sYhM_IB:
+ children: []
+ id: CHART-ne2sYhM_IB
+ meta:
+ chartId: 76
+ height: 50
+ sliceName: 10 Worst Files
+ uuid: e34a4358-0681-43b1-839e-82f1399b97ce
+ width: 3
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ - TABS-5EgQDONu1A
+ - TAB-6MZrK7E3jw
+ - ROW-9m7gUYjSq
+ type: CHART
+ DASHBOARD_VERSION_KEY: v2
+ GRID_ID:
+ children: []
+ id: GRID_ID
+ parents:
+ - ROOT_ID
+ type: GRID
+ HEADER_ID:
+ id: HEADER_ID
+ meta:
+ text: Superset Community Efforts
+ type: HEADER
+ MARKDOWN-e_ue39c8AW:
+ children: []
+ id: MARKDOWN-e_ue39c8AW
+ meta:
+ code: '# Find something to fix!
+
+
+ These charts help catalog "long tail" cleanup and migration projects
in the
+ frontend codebase. These stats are derived by ESLint warnings. Feel
free to
+ dig in by type or by file, to either help tie up a "loose end" or help
drive
+ a larger migration effort forward.'
+ height: 18
+ width: 12
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ - ROW-eRf1Ck0DTa
+ type: MARKDOWN
+ MARKDOWN-klTzn4w41d:
+ children: []
+ id: MARKDOWN-klTzn4w41d
+ meta:
+ code: '# Help us help others!
+
+
+ The issues and PRs on this page are sorted by "staleness" meaning
they''re
+ the ones that haven''t been touched or acted on for the longest time.
Please
+ help drive these toward resolution if you''re able, and/or tag a
committer
+ to help close them if they''re no longer relevant.
+
+
+ ### Note
+
+
+ The Shillelagh API currently only loads the first page of GH Issues...
we''ll
+ fix this soon to have a more comprehensive picture!'
+ height: 25
+ width: 12
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-gQNdNGxEm
+ - ROW-pvEDMOawc
+ type: MARKDOWN
+ ROOT_ID:
+ children:
+ - TABS-25qvyH3IQg
+ id: ROOT_ID
+ type: ROOT
+ ROW-8vrQEmqRL:
+ children:
+ - CHART-explore-90-1
+ - CHART-explore-91-1
+ id: ROW-8vrQEmqRL
+ meta:
+ background: BACKGROUND_TRANSPARENT
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-0iG6IOxPs
+ type: ROW
+ ROW-9MsZ7cYIcO:
+ children:
+ - CHART-WlJ6qakWX-
+ - CHART-8DBtgQCnUB
+ id: ROW-9MsZ7cYIcO
+ meta:
+ background: BACKGROUND_TRANSPARENT
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ type: ROW
+ ROW-9m7gUYjSq:
+ children:
+ - CHART-2hoATK8Zsx
+ - CHART-explore-79-1
+ - CHART-ne2sYhM_IB
+ - CHART-explore-80-1
+ id: ROW-9m7gUYjSq
+ meta:
+ background: BACKGROUND_TRANSPARENT
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ - TABS-5EgQDONu1A
+ - TAB-6MZrK7E3jw
+ type: ROW
+ ROW-GeI7emy5O:
+ children:
+ - CHART-explore-89-1
+ id: ROW-GeI7emy5O
+ meta:
+ background: BACKGROUND_TRANSPARENT
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-0iG6IOxPs
+ type: ROW
+ ROW-QBodkPkjd:
+ children:
+ - CHART-explore-83-1
+ - CHART-explore-84-1
+ id: ROW-QBodkPkjd
+ meta:
+ background: BACKGROUND_TRANSPARENT
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-gQNdNGxEm
+ type: ROW
+ ROW-_HD44Ptqc:
+ children:
+ - CHART-explore-82-1
+ - CHART-explore-85-1
+ id: ROW-_HD44Ptqc
+ meta:
+ background: BACKGROUND_TRANSPARENT
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-gQNdNGxEm
+ type: ROW
+ ROW-ceGPqkcuF0:
+ children:
+ - CHART-hVo1r3LAvM
+ id: ROW-ceGPqkcuF0
+ meta:
+ background: BACKGROUND_TRANSPARENT
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ - TABS-5EgQDONu1A
+ - TAB-6MZrK7E3jw
+ type: ROW
+ ROW-eRf1Ck0DTa:
+ children:
+ - MARKDOWN-e_ue39c8AW
+ id: ROW-eRf1Ck0DTa
+ meta:
+ background: BACKGROUND_TRANSPARENT
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ type: ROW
+ ROW-pvEDMOawc:
+ children:
+ - MARKDOWN-klTzn4w41d
+ id: ROW-pvEDMOawc
+ meta:
+ background: BACKGROUND_TRANSPARENT
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-gQNdNGxEm
+ type: ROW
+ TAB-0iG6IOxPs:
+ children:
+ - ROW-GeI7emy5O
+ - ROW-8vrQEmqRL
+ id: TAB-0iG6IOxPs
+ meta:
+ defaultText: Tab title
+ placeholder: Tab title
+ text: Project Stats
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ type: TAB
+ TAB-6MZrK7E3jw:
+ children:
+ - ROW-9m7gUYjSq
+ - ROW-ceGPqkcuF0
+ id: TAB-6MZrK7E3jw
+ meta:
+ defaultText: Tab title
+ placeholder: Tab title
+ text: ESLint
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ - TABS-5EgQDONu1A
+ type: TAB
+ TAB-Qe34bcVead:
+ children:
+ - ROW-eRf1Ck0DTa
+ - ROW-9MsZ7cYIcO
+ - TABS-5EgQDONu1A
+ id: TAB-Qe34bcVead
+ meta:
+ defaultText: Tab title
+ placeholder: Tab title
+ text: Technical Debt (Frontend)
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ type: TAB
+ TAB-gQNdNGxEm:
+ children:
+ - ROW-pvEDMOawc
+ - ROW-_HD44Ptqc
+ - ROW-QBodkPkjd
+ id: TAB-gQNdNGxEm
+ meta:
+ defaultText: Tab title
+ placeholder: Tab title
+ text: GitHub Issues and PRs
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ type: TAB
+ TABS-25qvyH3IQg:
+ children:
+ - TAB-0iG6IOxPs
+ - TAB-gQNdNGxEm
+ - TAB-Qe34bcVead
+ id: TABS-25qvyH3IQg
+ meta: {}
+ parents:
+ - ROOT_ID
+ type: TABS
+ TABS-5EgQDONu1A:
+ children:
+ - TAB-6MZrK7E3jw
+ id: TABS-5EgQDONu1A
+ meta: {}
+ parents:
+ - ROOT_ID
+ - TABS-25qvyH3IQg
+ - TAB-Qe34bcVead
+ type: TABS
+metadata:
+ chart_configuration:
+ '74':
+ id: 74
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 75
+ - 76
+ - 77
+ - 78
+ - 79
+ - 80
+ - 82
+ - 83
+ - 84
+ - 85
+ - 89
+ - 90
+ - 91
+ '75':
+ id: 75
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 74
+ - 76
+ - 77
+ - 78
+ - 79
+ - 80
+ - 82
+ - 83
+ - 84
+ - 85
+ - 89
+ - 90
+ - 91
+ '76':
+ id: 76
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 74
+ - 75
+ - 77
+ - 78
+ - 79
+ - 80
+ - 82
+ - 83
+ - 84
+ - 85
+ - 89
+ - 90
+ - 91
+ '77':
+ id: 77
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 74
+ - 75
+ - 76
+ - 78
+ - 79
+ - 80
+ - 82
+ - 83
+ - 84
+ - 85
+ - 89
+ - 90
+ - 91
+ '79':
+ id: 79
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 74
+ - 75
+ - 76
+ - 77
+ - 78
+ - 80
+ - 82
+ - 83
+ - 84
+ - 85
+ - 89
+ - 90
+ - 91
+ '80':
+ id: 80
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 74
+ - 75
+ - 76
+ - 77
+ - 78
+ - 79
+ - 82
+ - 83
+ - 84
+ - 85
+ - 89
+ - 90
+ - 91
+ '82':
+ id: 82
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 74
+ - 75
+ - 76
+ - 77
+ - 78
+ - 79
+ - 80
+ - 83
+ - 84
+ - 85
+ - 89
+ - 90
+ - 91
+ '83':
+ id: 83
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 74
+ - 75
+ - 76
+ - 77
+ - 78
+ - 79
+ - 80
+ - 82
+ - 84
+ - 85
+ - 89
+ - 90
+ - 91
+ '89':
+ id: 89
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 74
+ - 75
+ - 76
+ - 77
+ - 78
+ - 79
+ - 80
+ - 82
+ - 83
+ - 84
+ - 85
+ - 90
+ - 91
+ '90':
+ id: 90
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 74
+ - 75
+ - 76
+ - 77
+ - 78
+ - 79
+ - 80
+ - 82
+ - 83
+ - 84
+ - 85
+ - 89
+ - 91
+ '91':
+ id: 91
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 74
+ - 75
+ - 76
+ - 77
+ - 78
+ - 79
+ - 80
+ - 82
+ - 83
+ - 84
+ - 85
+ - 89
+ - 90
+ global_chart_configuration:
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded: []
+ chartsInScope:
+ - 74
+ - 75
+ - 76
+ - 77
+ - 78
+ - 79
+ - 80
+ - 82
+ - 83
+ - 84
+ - 85
+ - 89
+ - 90
+ - 91
+ color_scheme: ''
+ refresh_frequency: 0
+ shared_label_colors:
+ EugeneTorap: '#ACE1C4'
+ Always-prog: '#A1A6BD'
+ zhaoyongjie: '#666666'
+ lilykuang: '#D3B3DA'
+ villebro: '#666666'
+ rtexelm: '#A38F79'
+ craig-rueda: '#1FA8C9'
+ eschutho: '#454E7C'
+ Vitor-Avila: '#9EE5E5'
+ fisjac: '#FEC0A1'
+ Antonio-RiveroMartnez: '#B2B2B2'
+ sfirke: '#5AC189'
+ geido: '#EFA1AA'
+ kgabryje: '#E04355'
+ john-bodley: '#8FD3E4'
+ justinpark: '#3CCCCB'
+ betodealmeida: '#FCC700'
+ dpgaspar: '#A868B7'
+ michael-s-molina: '#ACE1C4'
+ mistercrunch: '#A38F79'
+ rusackas: '#A1A6BD'
+ SUM(total): '#454E7C'
+ days_stale: '#1FA8C9'
+
/home/runner/work/superset/superset/superset-frontend/packages/superset-ui-switchboard/src/switchboard.test.ts:
'#1FA8C9'
+
/home/runner/work/superset/superset/superset-frontend/src/views/CRUD/hooks.ts:
'#454E7C'
+ ?
/home/runner/work/superset/superset/superset-frontend/packages/superset-ui-demo/storybook/stories/superset-ui-chart/SuperChart.stories.tsx
+ : '#5AC189'
+
/home/runner/work/superset/superset/superset-frontend/src/explore/components/ExploreViewContainer/index.jsx:
'#FF7F44'
+
/home/runner/work/superset/superset/superset-frontend/src/filters/components/TimeGrain/TimeGrainFilterPlugin.tsx:
'#666666'
+
/home/runner/work/superset/superset/superset-frontend/src/filters/components/Range/RangeFilterPlugin.tsx:
'#E04355'
+
/home/runner/work/superset/superset/superset-frontend/src/explore/exploreUtils/exploreUtils.test.jsx:
'#FCC700'
+
/home/runner/work/superset/superset/superset-frontend/src/pages/AllEntities/index.tsx:
'#A868B7'
+
/home/runner/work/superset/superset/superset-frontend/src/filters/components/Select/SelectFilterPlugin.tsx:
'#3CCCCB'
+
/home/runner/work/superset/superset/superset-frontend/src/features/annotations/AnnotationModal.tsx:
'#A38F79'
+ react-hooks/exhaustive-deps: '#1FA8C9'
+ react-prefer-function-component/react-prefer-function-component: '#454E7C'
+ storybook/prefer-pascal-case: '#5AC189'
+ no-console: '#FF7F44'
+ '@typescript-eslint/no-unused-vars': '#666666'
+ jest/no-disabled-tests: '#E04355'
+ jest/expect-expect: '#FCC700'
+ '@typescript-eslint/no-use-before-define': '#A868B7'
+ react/no-danger: '#3CCCCB'
+ testing-library/no-debugging-utils: '#A38F79'
+ color_scheme_domain: []
+ expanded_slices: {}
+ label_colors: {}
+ timed_refresh_immune_slices: []
+ cross_filters_enabled: true
+ native_filter_configuration:
+ - id: NATIVE_FILTER_DIVIDER-Uvwpv66lm
+ type: DIVIDER
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded: []
+ title: Tech Debt Filters
+ description: These filters apply to the tech debt tab.
+ chartsInScope: []
+ tabsInScope: []
+ - id: NATIVE_FILTER-jT104f_o8
+ controlValues:
+ enableEmptyFilter: false
+ defaultToFirstItem: false
+ multiSelect: true
+ searchAllOptions: false
+ inverseSelection: false
+ name: Process (Collection)
+ filterType: filter_select
+ targets:
+ - column:
+ name: Process
+ datasetUuid: a3b0a980-a1b4-4463-89fd-91e6d3347313
+ defaultDataMask:
+ extraFormData: {}
+ filterState: {}
+ ownState: {}
+ cascadeParentIds: []
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded: []
+ type: NATIVE_FILTER
+ description: ''
+ chartsInScope:
+ - 74
+ - 75
+ - 76
+ - 77
+ - 78
+ - 79
+ - 80
+ - 82
+ tabsInScope:
+ - TAB-Qe34bcVead
+ - TAB-6MZrK7E3jw
+ - TAB-gQNdNGxEm
+ - id: NATIVE_FILTER-N062W3pFM
+ controlValues:
+ enableEmptyFilter: false
+ defaultToFirstItem: false
+ multiSelect: true
+ searchAllOptions: true
+ inverseSelection: false
+ name: Rule
+ filterType: filter_select
+ targets:
+ - column:
+ name: Rule
+ datasetUuid: a3b0a980-a1b4-4463-89fd-91e6d3347313
+ defaultDataMask:
+ extraFormData: {}
+ filterState: {}
+ ownState: {}
+ cascadeParentIds: []
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded: []
+ type: NATIVE_FILTER
+ description: ''
+ chartsInScope:
+ - 74
+ - 75
+ - 76
+ - 77
+ - 78
+ - 79
+ - 80
+ - 82
+ - 83
+ - 84
+ - 85
+ - 86
+ tabsInScope:
+ - TAB-Qe34bcVead
+ - TAB-6MZrK7E3jw
+ - TAB-gQNdNGxEm
+ - id: NATIVE_FILTER-UFZRu-GyK
+ controlValues:
+ enableEmptyFilter: false
+ name: Time Range
+ filterType: filter_time
+ targets:
+ - {}
+ defaultDataMask:
+ extraFormData: {}
+ filterState: {}
+ ownState: {}
+ cascadeParentIds: []
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded: []
+ type: NATIVE_FILTER
+ description: ''
+ chartsInScope:
+ - 74
+ - 78
+ tabsInScope: []
+ - id: NATIVE_FILTER-O1kzYk_ca
+ controlValues:
+ enableEmptyFilter: false
+ name: Violation Count
+ filterType: filter_range
+ targets:
+ - column:
+ name: Count
+ datasetUuid: a3b0a980-a1b4-4463-89fd-91e6d3347313
+ defaultDataMask:
+ extraFormData: {}
+ filterState: {}
+ ownState: {}
+ cascadeParentIds: []
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded:
+ - 75
+ - 76
+ - 77
+ type: NATIVE_FILTER
+ description: ''
+ chartsInScope:
+ - 74
+ - 78
+ - 79
+ - 80
+ tabsInScope: []
+ - id: NATIVE_FILTER-Hix7r6O6-
+ controlValues:
+ enableEmptyFilter: false
+ defaultToFirstItem: false
+ multiSelect: true
+ searchAllOptions: false
+ inverseSelection: false
+ name: FOO
+ filterType: filter_select
+ targets:
+ - column:
+ name: FOO
+ datasetUuid: a3b0a980-a1b4-4463-89fd-91e6d3347313
+ defaultDataMask:
+ extraFormData: {}
+ filterState: {}
+ ownState: {}
+ cascadeParentIds: []
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded:
+ - 75
+ - 76
+ - 77
+ - 79
+ - 80
+ - 82
+ - 83
+ - 84
+ - 85
+ - 86
+ type: NATIVE_FILTER
+ description: ''
+ chartsInScope:
+ - 74
+ - 78
+ tabsInScope:
+ - TAB-Qe34bcVead
+ default_filters: '{}'
+version: 1.0.0
diff --git a/superset/examples/configs/databases/Shillelagh.yaml
b/superset/examples/configs/databases/Shillelagh.yaml
new file mode 100644
index 0000000000..fca4ad6a93
--- /dev/null
+++ b/superset/examples/configs/databases/Shillelagh.yaml
@@ -0,0 +1,28 @@
+database_name: Shillelagh
+sqlalchemy_uri: shillelagh+safe://
+cache_timeout: 3600
+expose_in_sqllab: true
+allow_run_async: false
+allow_ctas: false
+allow_cvas: false
+allow_dml: false
+allow_file_upload: false
+extra:
+ allows_virtual_table_explore: true
+ engine_params:
+ connect_args:
+ adapters:
+ - gsheetsapi
+ - datasetteapi
+ - genericjsonapi
+ - genericxmlapi
+ - htmltableapi
+ - githubapi
+ - s3selectapi
+ - socrataapi
+ - weatherapi
+ - systemapi
+ metadata_params: {}
+ schemas_allowed_for_file_upload: []
+uuid: fe1710ff-33b3-4542-82ec-005a84cd2f50
+version: 1.0.0
diff --git
a/superset/examples/configs/datasets/Shillelagh/Open_Superset_Issues.yaml
b/superset/examples/configs/datasets/Shillelagh/Open_Superset_Issues.yaml
new file mode 100644
index 0000000000..359a1a9c98
--- /dev/null
+++ b/superset/examples/configs/datasets/Shillelagh/Open_Superset_Issues.yaml
@@ -0,0 +1,447 @@
+table_name: Open Superset Issues
+main_dttm_col: null
+description: null
+default_endpoint: null
+offset: 0
+cache_timeout: null
+schema: main
+sql: 'SELECT *, julianday(''now'') - julianday(updated_at) AS days_stale,
julianday(''now'')
+ - julianday(created_at) AS days_old
+
+ FROM "https://api.github.com/repos/apache/superset/issues"
+
+ WHERE state = ''open''
+
+ ORDER BY updated_at ASC'
+params: null
+template_params: null
+filter_select_enabled: true
+fetch_values_predicate: null
+extra: null
+normalize_columns: false
+always_filter_main_dttm: false
+uuid: 62f869ed-dc5e-4a2d-b5b3-6ae897ecb385
+metrics:
+- metric_name: count
+ verbose_name: COUNT(*)
+ metric_type: count
+ expression: COUNT(*)
+ description: null
+ d3format: null
+ currency: null
+ extra:
+ warning_markdown: ''
+ warning_text: null
+columns:
+- column_name: link
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: '''<a href="'' || REPLACE(url,
''https://api.github.com/repos/'', ''https://github.com/'')
+ || ''" target="_blank">'' || REPLACE(url,
''https://api.github.com/repos/apache/superset/issues/'',
+ ''#'') || ''</a>'' '
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: username
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: json_extract(user,'$.login')
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: days_stale
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: FLOAT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: days_old
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: FLOAT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: draft
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: BOOL
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: locked
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: BOOL
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: author_association
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: labels_url
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: comments_url
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: node_id
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: timeline_url
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: pull_request
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: events_url
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: repository_url
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: html_url
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: labels
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: reactions
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: assignees
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: state
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: body
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: title
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: user
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: url
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: number
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: INT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: comments
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: INT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: id
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: INT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: created_at
+ verbose_name: null
+ is_dttm: true
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: updated_at
+ verbose_name: null
+ is_dttm: true
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: performed_via_github_app
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: active_lock_reason
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: state_reason
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: closed_at
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: assignee
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: milestone
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+version: 1.0.0
+database_uuid: fe1710ff-33b3-4542-82ec-005a84cd2f50
diff --git
a/superset/examples/configs/datasets/Shillelagh/Open_Superset_PRs.yaml
b/superset/examples/configs/datasets/Shillelagh/Open_Superset_PRs.yaml
new file mode 100644
index 0000000000..75a3009e1d
--- /dev/null
+++ b/superset/examples/configs/datasets/Shillelagh/Open_Superset_PRs.yaml
@@ -0,0 +1,230 @@
+table_name: Open Superset PRs
+main_dttm_col: created_at
+description: null
+default_endpoint: null
+offset: 0
+cache_timeout: null
+schema: main
+sql: 'SELECT *, julianday(''now'') - julianday(updated_at) AS days_stale,
julianday(''now'')
+ - julianday(created_at) AS days_old
+
+ FROM "https://api.github.com/repos/apache/superset/pulls"
+
+ WHERE state = ''open''
+
+ ORDER BY updated_at ASC'
+params: null
+template_params: null
+filter_select_enabled: true
+fetch_values_predicate: null
+extra: null
+normalize_columns: false
+always_filter_main_dttm: false
+uuid: 0543be35-e3cb-4b8e-89a9-bee3e424d9a1
+metrics:
+- metric_name: count
+ verbose_name: COUNT(*)
+ metric_type: count
+ expression: COUNT(*)
+ description: null
+ d3format: null
+ currency: null
+ extra:
+ warning_markdown: ''
+ warning_text: null
+columns:
+- column_name: link
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: '''<a href="'' || url || ''" target="_blank">'' || REPLACE(url,
''https://github.com/apache/superset/pull/'',
+ ''#'') || ''</a>'' '
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: created_at
+ verbose_name: null
+ is_dttm: true
+ is_active: true
+ type: DATETIME
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: updated_at
+ verbose_name: null
+ is_dttm: true
+ is_active: true
+ type: DATETIME
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: days_stale
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: FLOAT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: days_old
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: FLOAT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: draft
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: BOOL
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: head
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: username
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: state
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: title
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: url
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: number
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: INT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: userid
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: INT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: id
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: INT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: closed_at
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: merged_at
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+version: 1.0.0
+database_uuid: fe1710ff-33b3-4542-82ec-005a84cd2f50
diff --git
a/superset/examples/configs/datasets/Shillelagh/Superset_Commits_by_Committer.yaml
b/superset/examples/configs/datasets/Shillelagh/Superset_Commits_by_Committer.yaml
new file mode 100644
index 0000000000..d7db253a78
--- /dev/null
+++
b/superset/examples/configs/datasets/Shillelagh/Superset_Commits_by_Committer.yaml
@@ -0,0 +1,73 @@
+table_name: Superset Commits by Committer
+main_dttm_col: null
+description: null
+default_endpoint: null
+offset: 0
+cache_timeout: null
+schema: main
+sql: "SELECT\n datetime(json_extract(json_extract(value, '$'), \"$.w\"),
'unixepoch')\
+ \ AS week, json_extract(json_extract(value, '$'), \"$.c\") as commits,
json_extract(author,\
+ \ \"$.login\") as handle\nFROM\n
\"https://api.github.com/repos/apache/superset/stats/contributors\"\
+ \ as t1,\n json_each(t1.weeks, '$')\nWHERE \n commits > 0\nAND \n week >
datetime('now',\
+ \ '-365 days');"
+params: null
+template_params: null
+filter_select_enabled: true
+fetch_values_predicate: null
+extra: null
+normalize_columns: false
+always_filter_main_dttm: false
+uuid: e8dd2f72-0592-4bdd-a9cf-bf825024f4f5
+metrics:
+- metric_name: count
+ verbose_name: COUNT(*)
+ metric_type: count
+ expression: COUNT(*)
+ description: null
+ d3format: null
+ currency: null
+ extra:
+ warning_markdown: ''
+ warning_text: null
+columns:
+- column_name: handle
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra:
+ warning_markdown: null
+- column_name: commits
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: INT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra:
+ warning_markdown: null
+- column_name: week
+ verbose_name: null
+ is_dttm: true
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra:
+ warning_markdown: null
+version: 1.0.0
+database_uuid: fe1710ff-33b3-4542-82ec-005a84cd2f50
diff --git
a/superset/examples/configs/datasets/Shillelagh/Superset_Tech_Debt_-_Aggregated.yaml
b/superset/examples/configs/datasets/Shillelagh/Superset_Tech_Debt_-_Aggregated.yaml
new file mode 100644
index 0000000000..46706c4560
--- /dev/null
+++
b/superset/examples/configs/datasets/Shillelagh/Superset_Tech_Debt_-_Aggregated.yaml
@@ -0,0 +1,102 @@
+table_name: Superset Tech Debt - Aggregated
+main_dttm_col: Timestamp
+description: null
+default_endpoint: null
+offset: 0
+cache_timeout: null
+schema: main
+sql: SELECT * FROM
"https://docs.google.com/spreadsheets/d/1oABNnzxJYzwUrHjr_c9wfYEq9dFL1ScVof9LlaAdxvo/edit"
+params: null
+template_params: null
+filter_select_enabled: true
+fetch_values_predicate: null
+extra: null
+normalize_columns: false
+always_filter_main_dttm: false
+uuid: a3b0a980-a1b4-4463-89fd-91e6d3347313
+metrics:
+- metric_name: count
+ verbose_name: COUNT(*)
+ metric_type: count
+ expression: COUNT(*)
+ description: null
+ d3format: null
+ currency: null
+ extra:
+ warning_markdown: ''
+ warning_text: null
+columns:
+- column_name: FOO
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: "CASE\n WHEN 1=1 THEN 1\n ELSE 0\nEND"
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: Timestamp
+ verbose_name: null
+ is_dttm: true
+ is_active: true
+ type: DATETIME
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: Count
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: INT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: Description
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: Process
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: Rule
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+version: 1.0.0
+database_uuid: fe1710ff-33b3-4542-82ec-005a84cd2f50
diff --git
a/superset/examples/configs/datasets/Shillelagh/Superset_Tech_Debt_-_ESLint.yaml
b/superset/examples/configs/datasets/Shillelagh/Superset_Tech_Debt_-_ESLint.yaml
new file mode 100644
index 0000000000..92c669b468
--- /dev/null
+++
b/superset/examples/configs/datasets/Shillelagh/Superset_Tech_Debt_-_ESLint.yaml
@@ -0,0 +1,141 @@
+table_name: Superset Tech Debt - ESLint
+main_dttm_col: Timestamp
+description: null
+default_endpoint: null
+offset: 0
+cache_timeout: null
+schema: main
+sql: SELECT * FROM
"https://docs.google.com/spreadsheets/d/1oABNnzxJYzwUrHjr_c9wfYEq9dFL1ScVof9LlaAdxvo/edit#gid=1042232483"
+params: null
+template_params: null
+filter_select_enabled: true
+fetch_values_predicate: null
+extra: null
+normalize_columns: false
+always_filter_main_dttm: false
+uuid: 12fa12ec-9d44-4eb8-8222-9f495849ad82
+metrics:
+- metric_name: count
+ verbose_name: COUNT(*)
+ metric_type: count
+ expression: COUNT(*)
+ description: null
+ d3format: null
+ currency: null
+ extra:
+ warning_markdown: ''
+ warning_text: null
+columns:
+- column_name: Link
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: '''<a href="'' ||
''https://github.com/apache/superset/blob/master''
+ || REPLACE(File, ''/home/runner/work/superset/superset'', '''') || ''#L''
|| Line
+ || ''" target="_blank">'' || REPLACE(File,
''/home/runner/work/superset/superset'',
+ '''') || ''</a>'' '
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: cleaned_file_path
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: null
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: REPLACE(File, '/home/runner/work/superset/superset', '')
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: Rule Description
+ verbose_name: ''
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: ESLint Message
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: Timestamp
+ verbose_name: null
+ is_dttm: true
+ is_active: true
+ type: DATETIME
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: Column
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: INT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: File
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: Rule
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+- column_name: Line
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: INT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra: {}
+version: 1.0.0
+database_uuid: fe1710ff-33b3-4542-82ec-005a84cd2f50
diff --git
a/superset/examples/configs/datasets/Shillelagh/Superset_Weekly_Commits.yaml
b/superset/examples/configs/datasets/Shillelagh/Superset_Weekly_Commits.yaml
new file mode 100644
index 0000000000..270ca2daab
--- /dev/null
+++ b/superset/examples/configs/datasets/Shillelagh/Superset_Weekly_Commits.yaml
@@ -0,0 +1,58 @@
+table_name: Superset Weekly Commits
+main_dttm_col: null
+description: null
+default_endpoint: null
+offset: 0
+cache_timeout: null
+schema: main
+sql: 'SELECT datetime(week, ''unixepoch'') as week, total from
"https://api.github.com/repos/apache/superset/stats/commit_activity"
+
+ '
+params: null
+template_params: null
+filter_select_enabled: true
+fetch_values_predicate: null
+extra: null
+normalize_columns: false
+always_filter_main_dttm: false
+uuid: 7edda5f1-d1e1-457e-b3c5-2b850071eb23
+metrics:
+- metric_name: count
+ verbose_name: COUNT(*)
+ metric_type: count
+ expression: COUNT(*)
+ description: null
+ d3format: null
+ currency: null
+ extra:
+ warning_markdown: ''
+ warning_text: null
+columns:
+- column_name: total
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: INT
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra:
+ warning_markdown: null
+- column_name: week
+ verbose_name: null
+ is_dttm: true
+ is_active: true
+ type: STRING
+ advanced_data_type: null
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ extra:
+ warning_markdown: null
+version: 1.0.0
+database_uuid: fe1710ff-33b3-4542-82ec-005a84cd2f50