Copy Page

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.

Draft

<h1><img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3RvY30&amp;locale=en_GB&amp;version=2" data-macro-name="toc" data-macro-id="37d1fbfa-f5b4-42cd-a893-28bdc034d973" data-macro-schema-version="1">1.Overview</h1>Superset is an open-source modern data exploration and visualization platform.Link: <a href="https://insight.galaxyedu.io/superset/welcome/">https://insight.galaxyedu.io/superset/welcome/</a><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2009.17.15.png?version=1&amp;modificationDate=1746497050097&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2009.17.15.png?version=1&amp;modificationDate=1746497050097&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837292" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 09.17.15.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 09.17.15.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 09.17.15.png" data-image-height="1706" data-image-width="3296"><h1>2. How to build dashboard</h1><h2>Step 1: Query to get data → Save dataset</h2><ol><li>Choose database, schema</li><li>Write code SQL to get data</li><li>Run to check your result</li><li>Click button beside &quot;Save&quot;</li><li>Save dataset</li><li>Save as new or Overwrite existing</li></ol><table class="confluenceTable"><colgroup><col style="width: 86.0px;" /><col style="width: 104.0px;" /><col style="width: 232.0px;" /></colgroup><tbody><tr><td class="confluenceTd">Database</td><td class="confluenceTd">Schema</td><td class="confluenceTd">Description</td></tr><tr><td rowspan="3" class="confluenceTd">CORE</td><td class="confluenceTd">icanid</td><td class="confluenceTd">merchant, users</td></tr><tr><td class="confluenceTd">icanpayment</td><td class="confluenceTd">bank transfer, billing, transaction</td></tr><tr><td class="confluenceTd">subscription</td><td class="confluenceTd">Product plan</td></tr><tr><td class="confluenceTd">ICAN Kid</td><td class="confluenceTd">icankid</td><td class="confluenceTd"><a href="https://drive.google.com/file/d/1mmT2W5_j2_mtBmFiEQYjm6ig5eJHTCuw/view?usp=sharing">Link</a></td></tr><tr><td class="confluenceTd">Report</td><td class="confluenceTd">user_report</td><td class="confluenceTd">cash in, paid user 4 BUs</td></tr></tbody></table> <img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-05%20at%2015.39.29.png?version=1&amp;modificationDate=1746497049994&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-05%20at%2015.39.29.png?version=1&amp;modificationDate=1746497049994&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837275" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-05 at 15.39.29.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-05 at 15.39.29.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-05 at 15.39.29.png" data-image-height="1740" data-image-width="3344"><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-05%20at%2015.45.04.png?version=1&amp;modificationDate=1746497049984&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-05%20at%2015.45.04.png?version=1&amp;modificationDate=1746497049984&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837274" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-05 at 15.45.04.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-05 at 15.45.04.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-05 at 15.45.04.png" data-image-height="536" data-image-width="1244"><h2>Step 2: Create dashboard</h2><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.29.18.png?version=1&amp;modificationDate=1746497050053&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.29.18.png?version=1&amp;modificationDate=1746497050053&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837284" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 10.29.18.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.29.18.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.29.18.png" data-image-height="1152" data-image-width="3300"><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-05%20at%2015.51.58.png?version=1&amp;modificationDate=1746497049981&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-05%20at%2015.51.58.png?version=1&amp;modificationDate=1746497049981&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837273" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-05 at 15.51.58.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-05 at 15.51.58.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-05 at 15.51.58.png" data-image-height="1726" data-image-width="3350"><h2>Step 3: Create new chart</h2><ol><li>Choose a dataset (step 1)</li><li>Choose chart type</li><li>Click button Create New chart</li><li>Add the name of chart, select time range, metrics, filters,...</li><li>Save</li></ol><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-05%20at%2016.03.04.png?version=1&amp;modificationDate=1746497049976&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-05%20at%2016.03.04.png?version=1&amp;modificationDate=1746497049976&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837272" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-05 at 16.03.04.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-05 at 16.03.04.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-05 at 16.03.04.png" data-image-height="1920" data-image-width="3344"><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.25.01.png?version=1&amp;modificationDate=1746497050014&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.25.01.png?version=1&amp;modificationDate=1746497050014&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837277" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 10.25.01.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.25.01.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.25.01.png" data-image-height="1694" data-image-width="3298"><h2>Step 4: Edit dashboard</h2><ol><li>Click button Edit dashboard</li><li>Drag and drop to edit chart size and position</li><li>Discard or Save your chart.</li></ol><h2>Step 5: Share</h2>Share the dashboard by generating a public or private URL, or embed it in other web applications.<h1>3. Dashboard</h1><h2>3.1. View</h2><h3>3.1.1. Choose dashboard</h3><ol><li>Click dashboards on toolbar.</li><li>Search title or filter by owner, created by, status,...</li><li>Click Choose dashboard to view</li></ol><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2009.18.57.png?version=1&amp;modificationDate=1746497050094&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2009.18.57.png?version=1&amp;modificationDate=1746497050094&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837291" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 09.18.57.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 09.18.57.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 09.18.57.png" data-image-height="1604" data-image-width="3308"><h3>3.1.2. Filter</h3><ol><li>After choose dashboard, select Filters on left-side bar</li><li>Apply filters</li></ol><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2009.30.59.png?version=1&amp;modificationDate=1746497050089&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2009.30.59.png?version=1&amp;modificationDate=1746497050089&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837290" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 09.30.59.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 09.30.59.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 09.30.59.png" data-image-height="1680" data-image-width="3292"><h3>3.1.3. View query</h3>On current dashboard, choose the chart → Click View query<img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2009.41.13.png?version=1&amp;modificationDate=1746497050084&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2009.41.13.png?version=1&amp;modificationDate=1746497050084&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837289" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 09.41.13.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 09.41.13.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 09.41.13.png" data-image-height="1370" data-image-width="3288"><h3>3.1.4. Download data from chart</h3><ol><li>Choose the chart you would like to download</li><li>Select Export to .CSV or Download as image</li></ol><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.35.24.png?version=1&amp;modificationDate=1746497050081&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.35.24.png?version=1&amp;modificationDate=1746497050081&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837288" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 10.35.24.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.35.24.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.35.24.png" data-image-height="1108" data-image-width="3278"><h2>3.2. Edit</h2><ol><li>Click button Edit dashboard</li><li>Create, Edit, Delete charts</li><li>Discard or Save</li></ol><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2009.48.45.png?version=1&amp;modificationDate=1746497050074&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2009.48.45.png?version=1&amp;modificationDate=1746497050074&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837287" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 09.48.45.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 09.48.45.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 09.48.45.png" data-image-height="1366" data-image-width="3302"><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2009.51.13.png?version=1&amp;modificationDate=1746497050070&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2009.51.13.png?version=1&amp;modificationDate=1746497050070&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837286" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 09.51.13.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 09.51.13.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 09.51.13.png" data-image-height="1676" data-image-width="3308"><h2>3.3. Create</h2><ol><li>Click dashboards on toolbar</li><li>Click button Add dashboard</li><li>Set title dashboard, create new chart...</li><li>Save</li></ol><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.29.18.png?version=1&amp;modificationDate=1746497050053&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.29.18.png?version=1&amp;modificationDate=1746497050053&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837284" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 10.29.18.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.29.18.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.29.18.png" data-image-height="1152" data-image-width="3300"><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.31.32.png?version=1&amp;modificationDate=1746497050049&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.31.32.png?version=1&amp;modificationDate=1746497050049&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837283" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 10.31.32.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.31.32.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.31.32.png" data-image-height="1600" data-image-width="3296"><h1>4. Chart</h1><h2>4.1. View</h2><h3>4.1.1. Choose chart</h3><ol><li>Click Charts on toolbar</li><li>Search or filter</li><li>Choose chart you would like to view</li></ol><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.02.12.png?version=1&amp;modificationDate=1746497050043&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.02.12.png?version=1&amp;modificationDate=1746497050043&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837282" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 10.02.12.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.02.12.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.02.12.png" data-image-height="1266" data-image-width="3300"><h3>4.1.2. Filter</h3><ol><li>Click box Time range</li><li>Select range type</li><li>Apply</li><li>Select column at Filters</li><li>Click button Update chart</li></ol><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.06.55.png?version=1&amp;modificationDate=1746497050040&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.06.55.png?version=1&amp;modificationDate=1746497050040&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837281" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 10.06.55.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.06.55.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.06.55.png" data-image-height="1302" data-image-width="3298"><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.11.21.png?version=1&amp;modificationDate=1746497050036&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.11.21.png?version=1&amp;modificationDate=1746497050036&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837280" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 10.11.21.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.11.21.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.11.21.png" data-image-height="1676" data-image-width="3292">Note: Please do not save if you only want to view the chart.<h2>4.2. Create</h2><ol><li>Click Charts on toolbar</li><li>Click button Add chart</li><li>Choose a dataset</li><li>Click button Create new chart</li><li>Add name, time column, metrics, filters and customize</li></ol><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.17.55.png?version=1&amp;modificationDate=1746497050030&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.17.55.png?version=1&amp;modificationDate=1746497050030&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837279" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 10.17.55.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.17.55.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.17.55.png" data-image-height="1648" data-image-width="3296"><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.20.46.png?version=1&amp;modificationDate=1746497050023&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.20.46.png?version=1&amp;modificationDate=1746497050023&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837278" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 10.20.46.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.20.46.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.20.46.png" data-image-height="1596" data-image-width="2160"><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.25.01.png?version=1&amp;modificationDate=1746497050014&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.25.01.png?version=1&amp;modificationDate=1746497050014&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837277" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 10.25.01.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.25.01.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.25.01.png" data-image-height="1694" data-image-width="3298"><h1>5. Query</h1><ol><li>Click SQL on toolbar</li></ol><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.42.07.png?version=1&amp;modificationDate=1746497050011&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.42.07.png?version=1&amp;modificationDate=1746497050011&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837276" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 10.42.07.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.42.07.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.42.07.png" data-image-height="1486" data-image-width="3304"> <ol><li>Select database</li><li>Select schema</li><li>Write code SQL to get data</li><li>Select limit</li><li>Click button Run</li></ol>Optional: <ul style="list-style-type: square;"><li>Save query or Save dataset</li><li>Select &quot;See table schema&quot; to Preview table</li></ul><img class="confluence-embedded-image" height="250" src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.45.24.png?version=1&amp;modificationDate=1746497049969&amp;api=v2" data-image-src="/download/attachments/84837270/Screen%20Shot%202023-10-04%20at%2010.45.24.png?version=1&amp;modificationDate=1746497049969&amp;api=v2" data-unresolved-comment-count="0" data-linked-resource-id="84837271" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Screen Shot 2023-10-04 at 10.45.24.png" data-base-url="https://confluence.galaxyedu.io" data-linked-resource-content-type="image/png" data-linked-resource-container-id="84837270" data-linked-resource-container-version="1" title="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.45.24.png" data-location="Galaxy Education > Copy of Guide to Using Superset > Screen Shot 2023-10-04 at 10.45.24.png" data-image-height="1846" data-image-width="3350"> <table class="wrapped confluenceTable"><colgroup><col /><col /><col /></colgroup><tbody><tr><td class="confluenceTd">Database</td><td class="confluenceTd">Schema</td><td class="confluenceTd">Description</td></tr><tr><td rowspan="3" class="confluenceTd">CORE</td><td class="confluenceTd">icanid</td><td class="confluenceTd">merchant, users</td></tr><tr><td class="confluenceTd">icanpayment</td><td class="confluenceTd">bank transfer, billing, transaction</td></tr><tr><td class="confluenceTd">subscription</td><td class="confluenceTd">Product plan</td></tr><tr><td class="confluenceTd">ICAN Kid</td><td class="confluenceTd">icankid</td><td class="confluenceTd"><a href="https://drive.google.com/file/d/1mmT2W5_j2_mtBmFiEQYjm6ig5eJHTCuw/view?usp=sharing">Link</a></td></tr><tr><td class="confluenceTd">Report</td><td class="confluenceTd">user_report</td><td class="confluenceTd">cash in, paid user 4 BUs</td></tr></tbody></table><h1 class="auto-cursor-target">6. Considerations when querying</h1>Given Superset's shared usage, it's crucial to optimize queries and datasets while creating dashboards to ensure a seamless experience for all users<ol><li>Specify What You Need: Be clear about the data you need and only request the necessary fields to minimize the amount of data returned.</li><li>Avoid SELECT *: Avoid using <code>SELECT *</code> as it retrieves all columns, which can be inefficient. Instead, explicitly list the columns you need.</li><li>Filter Early: Apply filters and conditions early in your query to reduce the dataset size before any complex operations are performed.</li><li>Use Joins Wisely: Be mindful of how you use joins, as they can be resource-intensive. Use INNER JOIN, LEFT JOIN, etc., as appropriate for your data relationships.</li><li>Aggregate Smartly: When performing aggregations, consider the efficiency of GROUP BY and aggregation functions like COUNT, SUM, AVG, etc.</li><li>Limit Results: Use the LIMIT clause to restrict the number of rows returned, especially when working with large datasets.</li><li>Monitor Performance: Regularly monitor query performance, identify bottlenecks, and optimize slow queries.</li><li>Avoid Nested Subqueries: Be cautious when using nested subqueries, as they can be complex and impact performance.</li><li>Consider Data Types: Be aware of data types and conversions when filtering or manipulating data.</li><li>Caching: Implement caching for frequently used queries to reduce database load.</li></ol>