You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@superset.apache.org by el...@apache.org on 2021/08/11 03:48:01 UTC
[superset] branch master updated: update covid dashboard (#16183)
This is an automated email from the ASF dual-hosted git repository.
elizabeth pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/superset.git
The following commit(s) were added to refs/heads/master by this push:
new 3aefa69 update covid dashboard (#16183)
3aefa69 is described below
commit 3aefa6925bb513e48f90a3d70ff37940e178c8a8
Author: Elizabeth Thompson <es...@gmail.com>
AuthorDate: Tue Aug 10 20:47:13 2021 -0700
update covid dashboard (#16183)
---
.../dashboards/COVID_Vaccine_Dashboard.yaml | 288 ++++++++--------
.../examples/configs/datasets/examples/users.yaml | 378 ++++++++++-----------
.../examples/users_channels-uzooNNtSRO.yaml | 87 ++---
.../configs/datasets/examples/users_channels.yaml | 58 ++--
.../datasets/examples/video_game_sales.yaml | 240 ++++++-------
superset/examples/energy.py | 2 +-
superset/examples/world_bank.py | 4 +-
7 files changed, 535 insertions(+), 522 deletions(-)
diff --git a/superset/examples/configs/dashboards/COVID_Vaccine_Dashboard.yaml b/superset/examples/configs/dashboards/COVID_Vaccine_Dashboard.yaml
index 28bfe4c..8919440 100644
--- a/superset/examples/configs/dashboards/COVID_Vaccine_Dashboard.yaml
+++ b/superset/examples/configs/dashboards/COVID_Vaccine_Dashboard.yaml
@@ -16,7 +16,7 @@
# under the License.
dashboard_title: COVID Vaccine Dashboard
description: null
-css: ''
+css: ""
slug: null
uuid: f4065089-110a-41fa-8dd7-9ce98a65e250
position:
@@ -25,134 +25,118 @@ position:
id: CHART-63bEuxjDMJ
meta:
chartId: 3961
- height: 76
+ height: 72
sliceName: Vaccine Candidates per Country
sliceNameOverride: Map of Vaccine Candidates
uuid: ddc91df6-fb40-4826-bdca-16b85af1c024
- width: 7
+ width: 12
parents:
- - ROOT_ID
- - TABS-wUKya7eQ0Z
- - TAB-BCIJF4NvgQ
- - ROW-zvw7luvEL
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
+ - TAB-BCIJF4NvgQ
+ - ROW-zvw7luvEL
type: CHART
CHART-F-fkth0Dnv:
children: []
id: CHART-F-fkth0Dnv
meta:
chartId: 3960
- height: 76
+ height: 60
sliceName: Vaccine Candidates per Country
sliceNameOverride: Treemap of Vaccine Candidates per Country
uuid: e2f5a8a7-feb0-4f79-bc6b-01fe55b98b3c
- width: 5
+ width: 8
parents:
- - ROOT_ID
- - TABS-wUKya7eQ0Z
- - TAB-BCIJF4NvgQ
- - ROW-zvw7luvEL
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
+ - TAB-BCIJF4NvgQ
+ - ROW-xSeNAspgw
type: CHART
CHART-RjD_ygqtwH:
children: []
id: CHART-RjD_ygqtwH
meta:
chartId: 3957
- height: 59
+ height: 72
sliceName: Vaccine Candidates per Phase
sliceNameOverride: Vaccine Candidates per Phase
uuid: 30b73c65-85e7-455f-bb24-801bb0cdc670
- width: 2
+ width: 3
parents:
- - ROOT_ID
- - TABS-wUKya7eQ0Z
- - TAB-BCIJF4NvgQ
- - ROW-xSeNAspgw
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
+ - TAB-BCIJF4NvgQ
+ - ROW-zvw7luvEL
type: CHART
CHART-aGfmWtliqA:
children: []
id: CHART-aGfmWtliqA
meta:
chartId: 3956
- height: 59
+ height: 72
sliceName: Vaccine Candidates per Phase
uuid: 392f293e-0892-4316-bd41-c927b65606a4
+ width: 5
+ parents:
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
+ - TAB-BCIJF4NvgQ
+ - ROW-zvw7luvEL
+ type: CHART
+ CHART-j4hUvP5dDD:
+ children: []
+ id: CHART-j4hUvP5dDD
+ meta:
+ chartId: 3962
+ height: 82
+ sliceName: Vaccine Candidates per Approach & Stage
+ sliceNameOverride: Heatmap of Aproaches & Clinical Stages
+ uuid: 0c953c84-0c9a-418d-be9f-2894d2a2cee0
width: 4
parents:
- - ROOT_ID
- - TABS-wUKya7eQ0Z
- - TAB-BCIJF4NvgQ
- - ROW-xSeNAspgw
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
+ - TAB-BCIJF4NvgQ
+ - ROW-dieUdkeUw
type: CHART
CHART-dCUpAcPsji:
children: []
id: CHART-dCUpAcPsji
meta:
chartId: 3963
- height: 82
+ height: 72
sliceName: Vaccine Candidates per Country & Stage
sliceNameOverride: Heatmap of Countries & Clinical Stages
uuid: cd111331-d286-4258-9020-c7949a109ed2
width: 4
parents:
- - ROOT_ID
- - TABS-wUKya7eQ0Z
- - TAB-BCIJF4NvgQ
- - ROW-zhOlQLQnB
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
+ - TAB-BCIJF4NvgQ
+ - ROW-dieUdkeUw
type: CHART
CHART-eirDduqb1A:
children: []
id: CHART-eirDduqb1A
meta:
chartId: 3965
- height: 59
+ height: 60
sliceName: Filtering Vaccines
sliceNameOverride: Filter Box of Vaccines
uuid: c29381ce-0e99-4cf3-bf0f-5f55d6b94176
- width: 3
- parents:
- - ROOT_ID
- - TABS-wUKya7eQ0Z
- - TAB-BCIJF4NvgQ
- - ROW-xSeNAspgw
- type: CHART
- CHART-fYo7IyvKZQ:
- children: []
- id: CHART-fYo7IyvKZQ
- meta:
- chartId: 3964
- height: 82
- sliceName: Vaccine Candidates per Country & Stage
- sliceNameOverride: Sunburst of Country & Clinical Stages
- uuid: f69c556f-15fe-4a82-a8bb-69d5b6954123
- width: 5
- parents:
- - ROOT_ID
- - TABS-wUKya7eQ0Z
- - TAB-BCIJF4NvgQ
- - ROW-zhOlQLQnB
- type: CHART
- CHART-j4hUvP5dDD:
- children: []
- id: CHART-j4hUvP5dDD
- meta:
- chartId: 3962
- height: 82
- sliceName: Vaccine Candidates per Approach & Stage
- sliceNameOverride: Heatmap of Aproaches & Clinical Stages
- uuid: 0c953c84-0c9a-418d-be9f-2894d2a2cee0
- width: 3
+ width: 4
parents:
- - ROOT_ID
- - TABS-wUKya7eQ0Z
- - TAB-BCIJF4NvgQ
- - ROW-zhOlQLQnB
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
+ - TAB-BCIJF4NvgQ
+ - ROW-xSeNAspgw
type: CHART
DASHBOARD_VERSION_KEY: v2
GRID_ID:
children: []
id: GRID_ID
parents:
- - ROOT_ID
+ - ROOT_ID
type: GRID
HEADER_ID:
id: HEADER_ID
@@ -163,7 +147,7 @@ position:
children: []
id: MARKDOWN-VjQQ5SFj5v
meta:
- code: '# COVID-19 Vaccine Dashboard
+ code: "# COVID-19 Vaccine Dashboard
Everywhere you look, you see negative news about COVID-19. This is to be expected;
@@ -193,129 +177,157 @@ position:
country responsible for each vaccine effort.
- _Note that this dataset was last updated on 12/23/2020_.
+ _Note that this dataset was last updated on 07/2021_.
- '
- height: 59
- width: 3
+ "
+ height: 72
+ width: 4
parents:
- - ROOT_ID
- - TABS-wUKya7eQ0Z
- - TAB-BCIJF4NvgQ
- - ROW-xSeNAspgw
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
+ - TAB-BCIJF4NvgQ
+ - ROW-zhOlQLQnB
type: MARKDOWN
+ CHART-fYo7IyvKZQ:
+ children: []
+ id: CHART-fYo7IyvKZQ
+ meta:
+ chartId: 3964
+ height: 72
+ sliceName: Vaccine Candidates per Country & Stage
+ sliceNameOverride: Sunburst of Country & Clinical Stages
+ uuid: f69c556f-15fe-4a82-a8bb-69d5b6954123
+ width: 4
+ parents:
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
+ - TAB-BCIJF4NvgQ
+ - ROW-dieUdkeUw
+ type: CHART
ROOT_ID:
children:
- - TABS-wUKya7eQ0Z
+ - TABS-wUKya7eQ0Z
id: ROOT_ID
type: ROOT
+ ROW-zhOlQLQnB:
+ children:
+ - MARKDOWN-VjQQ5SFj5v
+ - CHART-RjD_ygqtwH
+ - CHART-aGfmWtliqA
+ id: ROW-zhOlQLQnB
+ meta:
+ "0": ROOT_ID
+ background: BACKGROUND_TRANSPARENT
+ parents:
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
+ - TAB-BCIJF4NvgQ
+ type: ROW
ROW-xSeNAspgw:
children:
- - MARKDOWN-VjQQ5SFj5v
- - CHART-aGfmWtliqA
- - CHART-RjD_ygqtwH
- - CHART-eirDduqb1A
+ - CHART-eirDduqb1A
+ - CHART-F-fkth0Dnv
id: ROW-xSeNAspgw
meta:
- '0': ROOT_ID
+ "0": ROOT_ID
background: BACKGROUND_TRANSPARENT
parents:
- - ROOT_ID
- - TABS-wUKya7eQ0Z
- - TAB-BCIJF4NvgQ
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
+ - TAB-BCIJF4NvgQ
type: ROW
- ROW-zhOlQLQnB:
+ ROW-dieUdkeUw:
children:
- - CHART-j4hUvP5dDD
- - CHART-dCUpAcPsji
- - CHART-fYo7IyvKZQ
- id: ROW-zhOlQLQnB
+ - CHART-dCUpAcPsji
+ - CHART-fYo7IyvKZQ
+ - CHART-j4hUvP5dDD
+ id: ROW-xSeNAspgw
meta:
- '0': ROOT_ID
+ "0": ROOT_ID
background: BACKGROUND_TRANSPARENT
parents:
- - ROOT_ID
- - TABS-wUKya7eQ0Z
- - TAB-BCIJF4NvgQ
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
+ - TAB-BCIJF4NvgQ
type: ROW
ROW-zvw7luvEL:
children:
- - CHART-63bEuxjDMJ
- - CHART-F-fkth0Dnv
+ - CHART-63bEuxjDMJ
id: ROW-zvw7luvEL
meta:
- '0': ROOT_ID
+ "0": ROOT_ID
background: BACKGROUND_TRANSPARENT
parents:
- - ROOT_ID
- - TABS-wUKya7eQ0Z
- - TAB-BCIJF4NvgQ
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
+ - TAB-BCIJF4NvgQ
type: ROW
TAB-BCIJF4NvgQ:
children:
- - ROW-xSeNAspgw
- - ROW-zvw7luvEL
- - ROW-zhOlQLQnB
+ - ROW-zhOlQLQnB
+ - ROW-xSeNAspgw
+ - ROW-zvw7luvEL
+ - ROW-dieUdkeUw
id: TAB-BCIJF4NvgQ
meta:
text: Overview
parents:
- - ROOT_ID
- - TABS-wUKya7eQ0Z
+ - ROOT_ID
+ - TABS-wUKya7eQ0Z
type: TAB
TABS-wUKya7eQ0Z:
children:
- - TAB-BCIJF4NvgQ
+ - TAB-BCIJF4NvgQ
id: TABS-wUKya7eQ0Z
meta: {}
parents:
- - ROOT_ID
+ - ROOT_ID
type: TABS
metadata:
timed_refresh_immune_slices: []
expanded_slices: {}
refresh_frequency: 0
- default_filters: '{}'
+ default_filters: "{}"
color_scheme: supersetColors
label_colors:
- '0': '#D3B3DA'
- '1': '#9EE5E5'
- 0. Pre-clinical: '#1FA8C9'
- 2. Phase II or Combined I/II: '#454E7C'
- 1. Phase I: '#5AC189'
- 3. Phase III: '#FF7F44'
- 4. Authorized: '#666666'
- root: '#1FA8C9'
- Protein subunit: '#454E7C'
- Phase II: '#5AC189'
- Pre-clinical: '#FF7F44'
- Phase III: '#666666'
- Phase I: '#E04355'
- Phase I/II: '#FCC700'
- Inactivated virus: '#A868B7'
- Virus-like particle: '#3CCCCB'
- Replicating bacterial vector: '#A38F79'
- DNA-based: '#8FD3E4'
- RNA-based vaccine: '#A1A6BD'
- Authorized: '#ACE1C4'
- Non-replicating viral vector: '#FEC0A1'
- Replicating viral vector: '#B2B2B2'
- Unknown: '#EFA1AA'
- Live attenuated virus: '#FDE380'
- COUNT(*): '#D1C6BC'
+ "0": "#D3B3DA"
+ "1": "#9EE5E5"
+ 0. Pre-clinical: "#1FA8C9"
+ 2. Phase II or Combined I/II: "#454E7C"
+ 1. Phase I: "#5AC189"
+ 3. Phase III: "#FF7F44"
+ 4. Authorized: "#666666"
+ root: "#1FA8C9"
+ Protein subunit: "#454E7C"
+ Phase II: "#5AC189"
+ Pre-clinical: "#FF7F44"
+ Phase III: "#666666"
+ Phase I: "#E04355"
+ Phase I/II: "#FCC700"
+ Inactivated virus: "#A868B7"
+ Virus-like particle: "#3CCCCB"
+ Replicating bacterial vector: "#A38F79"
+ DNA-based: "#8FD3E4"
+ RNA-based vaccine: "#A1A6BD"
+ Authorized: "#ACE1C4"
+ Non-replicating viral vector: "#FEC0A1"
+ Replicating viral vector: "#B2B2B2"
+ Unknown: "#EFA1AA"
+ Live attenuated virus: "#FDE380"
+ COUNT(*): "#D1C6BC"
filter_scopes:
- '3965':
+ "3965":
Country_Name:
scope:
- - ROOT_ID
+ - ROOT_ID
immune: []
Product_Category:
scope:
- - ROOT_ID
+ - ROOT_ID
immune: []
Clinical Stage:
scope:
- - ROOT_ID
+ - ROOT_ID
immune: []
version: 1.0.0
diff --git a/superset/examples/configs/datasets/examples/users.yaml b/superset/examples/configs/datasets/examples/users.yaml
index 5252e23..7c9fc69 100644
--- a/superset/examples/configs/datasets/examples/users.yaml
+++ b/superset/examples/configs/datasets/examples/users.yaml
@@ -14,7 +14,7 @@
# KIND, either express or implied. See the License for the
# specific language governing permissions and limitations
# under the License.
-table_name: users
+table_name: Slack Users
main_dttm_col: updated
description: null
default_endpoint: null
@@ -29,195 +29,195 @@ fetch_values_predicate: null
extra: null
uuid: 7195db6b-2d17-7619-b7c7-26b15378df8c
metrics:
-- metric_name: count
- verbose_name: COUNT(*)
- metric_type: count
- expression: COUNT(*)
- description: null
- d3format: null
- extra: null
- warning_text: null
+ - metric_name: count
+ verbose_name: COUNT(*)
+ metric_type: count
+ expression: COUNT(*)
+ description: null
+ d3format: null
+ extra: null
+ warning_text: null
columns:
-- column_name: updated
- verbose_name: null
- is_dttm: true
- is_active: true
- type: TIMESTAMP WITHOUT TIME ZONE
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: has_2fa
- verbose_name: null
- is_dttm: false
- is_active: true
- type: BOOLEAN
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: real_name
- verbose_name: null
- is_dttm: false
- is_active: true
- type: VARCHAR
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: tz_label
- verbose_name: null
- is_dttm: false
- is_active: true
- type: VARCHAR
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: team_id
- verbose_name: null
- is_dttm: false
- is_active: true
- type: VARCHAR
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: name
- verbose_name: null
- is_dttm: false
- is_active: true
- type: VARCHAR
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: color
- verbose_name: null
- is_dttm: false
- is_active: true
- type: VARCHAR
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: id
- verbose_name: null
- is_dttm: false
- is_active: true
- type: VARCHAR
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: tz
- verbose_name: null
- is_dttm: false
- is_active: true
- type: VARCHAR
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: is_ultra_restricted
- verbose_name: null
- is_dttm: false
- is_active: true
- type: BOOLEAN
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: is_primary_owner
- verbose_name: null
- is_dttm: false
- is_active: true
- type: BOOLEAN
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: is_app_user
- verbose_name: null
- is_dttm: false
- is_active: true
- type: BOOLEAN
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: is_admin
- verbose_name: null
- is_dttm: false
- is_active: true
- type: BOOLEAN
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: is_bot
- verbose_name: null
- is_dttm: false
- is_active: true
- type: BOOLEAN
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: is_restricted
- verbose_name: null
- is_dttm: false
- is_active: true
- type: BOOLEAN
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: is_owner
- verbose_name: null
- is_dttm: false
- is_active: true
- type: BOOLEAN
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: deleted
- verbose_name: null
- is_dttm: false
- is_active: true
- type: BOOLEAN
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: tz_offset
- verbose_name: null
- is_dttm: false
- is_active: true
- type: BIGINT
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
+ - column_name: updated
+ verbose_name: null
+ is_dttm: true
+ is_active: true
+ type: TIMESTAMP WITHOUT TIME ZONE
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: has_2fa
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: BOOLEAN
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: real_name
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: VARCHAR
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: tz_label
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: VARCHAR
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: team_id
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: VARCHAR
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: name
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: VARCHAR
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: color
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: VARCHAR
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: id
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: VARCHAR
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: tz
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: VARCHAR
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: is_ultra_restricted
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: BOOLEAN
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: is_primary_owner
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: BOOLEAN
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: is_app_user
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: BOOLEAN
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: is_admin
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: BOOLEAN
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: is_bot
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: BOOLEAN
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: is_restricted
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: BOOLEAN
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: is_owner
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: BOOLEAN
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: deleted
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: BOOLEAN
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: tz_offset
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: BIGINT
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
version: 1.0.0
database_uuid: a2dc77af-e654-49bb-b321-40f6b559a1ee
data: https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/slack/users.csv
diff --git a/superset/examples/configs/datasets/examples/users_channels-uzooNNtSRO.yaml b/superset/examples/configs/datasets/examples/users_channels-uzooNNtSRO.yaml
index 75e0e79..68f836c 100644
--- a/superset/examples/configs/datasets/examples/users_channels-uzooNNtSRO.yaml
+++ b/superset/examples/configs/datasets/examples/users_channels-uzooNNtSRO.yaml
@@ -14,18 +14,19 @@
# KIND, either express or implied. See the License for the
# specific language governing permissions and limitations
# under the License.
-table_name: users_channels-uzooNNtSRO
+table_name: Slack Channel Combinations and Users
main_dttm_col: null
description: null
default_endpoint: null
offset: 0
cache_timeout: null
schema: null
-sql: 'SELECT uc1.name as channel_1, uc2.name as channel_2, count(*) AS cnt
- FROM users_channels uc1
- JOIN users_channels uc2 ON uc1.user_id = uc2.user_id
+sql: >
+ SELECT uc1.name as channel_1, uc2.name as channel_2, count(*) AS cnt
+ FROM "Slack Users and Channels" uc1
+ JOIN "Slack Users and Channels" uc2 ON uc1.user_id = uc2.user_id
GROUP BY uc1.name, uc2.name
- HAVING uc1.name <> uc2.name'
+ HAVING uc1.name <> uc2.name
params: null
template_params: null
filter_select_enabled: true
@@ -33,44 +34,44 @@ fetch_values_predicate: null
extra: null
uuid: 473d6113-b44a-48d8-a6ae-e0ef7e2aebb0
metrics:
-- metric_name: count
- verbose_name: null
- metric_type: null
- expression: count(*)
- description: null
- d3format: null
- extra: null
- warning_text: null
+ - metric_name: count
+ verbose_name: null
+ metric_type: null
+ expression: count(*)
+ description: null
+ d3format: null
+ extra: null
+ warning_text: null
columns:
-- column_name: channel_1
- verbose_name: null
- is_dttm: false
- is_active: true
- type: STRING
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: channel_2
- verbose_name: null
- is_dttm: false
- is_active: true
- type: STRING
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: cnt
- verbose_name: null
- is_dttm: false
- is_active: true
- type: INT
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
+ - column_name: channel_1
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: channel_2
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: cnt
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: INT
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
version: 1.0.0
database_uuid: a2dc77af-e654-49bb-b321-40f6b559a1ee
diff --git a/superset/examples/configs/datasets/examples/users_channels.yaml b/superset/examples/configs/datasets/examples/users_channels.yaml
index 62b6934..e688fb4 100644
--- a/superset/examples/configs/datasets/examples/users_channels.yaml
+++ b/superset/examples/configs/datasets/examples/users_channels.yaml
@@ -14,7 +14,7 @@
# KIND, either express or implied. See the License for the
# specific language governing permissions and limitations
# under the License.
-table_name: users_channels
+table_name: Slack Users and Channels
main_dttm_col: null
description: null
default_endpoint: null
@@ -29,35 +29,35 @@ fetch_values_predicate: null
extra: null
uuid: 29b18573-c9d6-40bc-b8cb-f70c9a1b6244
metrics:
-- metric_name: count
- verbose_name: null
- metric_type: null
- expression: count(*)
- description: null
- d3format: null
- extra: null
- warning_text: null
+ - metric_name: count
+ verbose_name: null
+ metric_type: null
+ expression: count(*)
+ description: null
+ d3format: null
+ extra: null
+ warning_text: null
columns:
-- column_name: user_id
- verbose_name: null
- is_dttm: false
- is_active: true
- type: STRING
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: name
- verbose_name: null
- is_dttm: false
- is_active: true
- type: STRING
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
+ - column_name: user_id
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: name
+ verbose_name: null
+ is_dttm: false
+ is_active: true
+ type: STRING
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
version: 1.0.0
database_uuid: a2dc77af-e654-49bb-b321-40f6b559a1ee
data: https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/slack/users_channels.csv
diff --git a/superset/examples/configs/datasets/examples/video_game_sales.yaml b/superset/examples/configs/datasets/examples/video_game_sales.yaml
index 34ae997..6099e28 100644
--- a/superset/examples/configs/datasets/examples/video_game_sales.yaml
+++ b/superset/examples/configs/datasets/examples/video_game_sales.yaml
@@ -14,14 +14,14 @@
# KIND, either express or implied. See the License for the
# specific language governing permissions and limitations
# under the License.
-table_name: video_game_sales
+table_name: Video Game Sales
main_dttm_col: null
description: null
default_endpoint: null
offset: 0
cache_timeout: null
schema: null
-sql: ''
+sql: ""
params:
remote_id: 64
database_name: examples
@@ -32,125 +32,125 @@ fetch_values_predicate: null
extra: null
uuid: 53d47c0c-c03d-47f0-b9ac-81225f808283
metrics:
-- metric_name: count
- verbose_name: COUNT(*)
- metric_type: null
- expression: COUNT(*)
- description: null
- d3format: null
- extra: null
- warning_text: null
+ - metric_name: count
+ verbose_name: COUNT(*)
+ metric_type: null
+ expression: COUNT(*)
+ description: null
+ d3format: null
+ extra: null
+ warning_text: null
columns:
-- column_name: year
- verbose_name: null
- is_dttm: true
- is_active: null
- type: BIGINT
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: '%Y'
-- column_name: na_sales
- verbose_name: null
- is_dttm: false
- is_active: null
- type: FLOAT64
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: eu_sales
- verbose_name: null
- is_dttm: false
- is_active: null
- type: FLOAT64
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: global_sales
- verbose_name: null
- is_dttm: false
- is_active: null
- type: FLOAT64
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: jp_sales
- verbose_name: null
- is_dttm: false
- is_active: null
- type: FLOAT64
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: other_sales
- verbose_name: null
- is_dttm: false
- is_active: null
- type: FLOAT64
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: rank
- verbose_name: null
- is_dttm: false
- is_active: null
- type: BIGINT
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: genre
- verbose_name: null
- is_dttm: false
- is_active: null
- type: STRING
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: name
- verbose_name: null
- is_dttm: false
- is_active: null
- type: STRING
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: platform
- verbose_name: null
- is_dttm: false
- is_active: null
- type: STRING
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
-- column_name: publisher
- verbose_name: null
- is_dttm: false
- is_active: null
- type: STRING
- groupby: true
- filterable: true
- expression: null
- description: null
- python_date_format: null
+ - column_name: year
+ verbose_name: null
+ is_dttm: true
+ is_active: null
+ type: BIGINT
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: "%Y"
+ - column_name: na_sales
+ verbose_name: null
+ is_dttm: false
+ is_active: null
+ type: FLOAT64
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: eu_sales
+ verbose_name: null
+ is_dttm: false
+ is_active: null
+ type: FLOAT64
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: global_sales
+ verbose_name: null
+ is_dttm: false
+ is_active: null
+ type: FLOAT64
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: jp_sales
+ verbose_name: null
+ is_dttm: false
+ is_active: null
+ type: FLOAT64
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: other_sales
+ verbose_name: null
+ is_dttm: false
+ is_active: null
+ type: FLOAT64
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: rank
+ verbose_name: null
+ is_dttm: false
+ is_active: null
+ type: BIGINT
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: genre
+ verbose_name: null
+ is_dttm: false
+ is_active: null
+ type: STRING
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: name
+ verbose_name: null
+ is_dttm: false
+ is_active: null
+ type: STRING
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: platform
+ verbose_name: null
+ is_dttm: false
+ is_active: null
+ type: STRING
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
+ - column_name: publisher
+ verbose_name: null
+ is_dttm: false
+ is_active: null
+ type: STRING
+ groupby: true
+ filterable: true
+ expression: null
+ description: null
+ python_date_format: null
version: 1.0.0
database_uuid: a2dc77af-e654-49bb-b321-40f6b559a1ee
data: https://github.com/apache-superset/examples-data/raw/lowercase_columns_examples/datasets/examples/video_game_sales.csv
diff --git a/superset/examples/energy.py b/superset/examples/energy.py
index 4ad56b0..2c2003f 100644
--- a/superset/examples/energy.py
+++ b/superset/examples/energy.py
@@ -56,7 +56,7 @@ def load_energy(
method="multi",
)
- print("Creating table [wb_health_population] reference")
+ print("Creating table [World Bank Health Data] reference")
table = get_table_connector_registry()
tbl = db.session.query(table).filter_by(table_name=tbl_name).first()
if not tbl:
diff --git a/superset/examples/world_bank.py b/superset/examples/world_bank.py
index ccfcfca..624fdc7 100644
--- a/superset/examples/world_bank.py
+++ b/superset/examples/world_bank.py
@@ -45,7 +45,7 @@ def load_world_bank_health_n_pop( # pylint: disable=too-many-locals, too-many-s
only_metadata: bool = False, force: bool = False, sample: bool = False,
) -> None:
"""Loads the world bank health dataset, slices and a dashboard"""
- tbl_name = "wb_health_population"
+ tbl_name = "World Bank Health Data"
database = utils.get_example_database()
table_exists = database.has_table_by_name(tbl_name)
@@ -76,7 +76,7 @@ def load_world_bank_health_n_pop( # pylint: disable=too-many-locals, too-many-s
index=False,
)
- print("Creating table [wb_health_population] reference")
+ print("Creating table [World Bank Health Data] reference")
table = get_table_connector_registry()
tbl = db.session.query(table).filter_by(table_name=tbl_name).first()
if not tbl: