You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@superset.apache.org by ru...@apache.org on 2020/08/31 23:41:11 UTC
[incubator-superset-site] 06/26: Latest docs as of 0.24ish
This is an automated email from the ASF dual-hosted git repository.
rusackas pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/incubator-superset-site.git
commit 3193bf3abd81d96523e242aaf0cfd75ab02a9fe1
Author: Maxime Beauchemin <ma...@gmail.com>
AuthorDate: Fri Apr 13 11:30:12 2018 -0700
Latest docs as of 0.24ish
---
_images/area.png | Bin 105237 -> 14469 bytes
_images/bank_dash.png | Bin 0 -> 1532812 bytes
_images/bar.png | Bin 50564 -> 9058 bytes
_images/big_number.png | Bin 51404 -> 10101 bytes
_images/big_number_total.png | Bin 27637 -> 4925 bytes
_images/box_plot.png | Bin 56136 -> 9496 bytes
_images/bubble.png | Bin 135455 -> 22779 bytes
_images/bullet.png | Bin 8764 -> 2174 bytes
_images/cal_heatmap.png | Bin 31627 -> 11238 bytes
_images/chord.png | Bin 0 -> 39273 bytes
_images/compare.png | Bin 258894 -> 32918 bytes
_images/country_map.png | Bin 0 -> 41210 bytes
_images/deck_arc.png | Bin 0 -> 38815 bytes
_images/deck_geojson.png | Bin 0 -> 42386 bytes
_images/deck_grid.png | Bin 0 -> 143670 bytes
_images/deck_hex.png | Bin 0 -> 85015 bytes
_images/deck_multi.png | Bin 0 -> 106790 bytes
_images/deck_path.png | Bin 0 -> 75705 bytes
_images/deck_polygon.png | Bin 0 -> 37261 bytes
_images/deck_scatter.png | Bin 0 -> 120091 bytes
_images/deck_screengrid.png | Bin 0 -> 76990 bytes
_images/deckgl_dash.png | Bin 0 -> 6777438 bytes
_images/directed_force.png | Bin 247382 -> 42753 bytes
_images/dist_bar.png | Bin 52519 -> 8752 bytes
_images/dual_line.png | Bin 0 -> 19229 bytes
_images/event_flow.png | Bin 0 -> 17191 bytes
_images/explore.png | Bin 0 -> 674489 bytes
_images/filter_box.png | Bin 49653 -> 8550 bytes
_images/heatmap.png | Bin 435496 -> 39866 bytes
_images/histogram.png | Bin 64899 -> 9717 bytes
_images/horizon.png | Bin 165253 -> 24924 bytes
_images/iframe.png | Bin 755166 -> 50998 bytes
_images/line.png | Bin 321509 -> 42915 bytes
_images/mapbox.png | Bin 225567 -> 85714 bytes
_images/markup.png | Bin 227846 -> 23186 bytes
_images/paired_ttest.png | Bin 0 -> 23323 bytes
_images/para.png | Bin 471027 -> 52039 bytes
_images/partition.png | Bin 0 -> 11364 bytes
_images/pie.png | Bin 28302 -> 6007 bytes
_images/pivot_table.png | Bin 276020 -> 54527 bytes
_images/rose.png | Bin 0 -> 37386 bytes
_images/sankey.png | Bin 205313 -> 43735 bytes
_images/separator.png | Bin 101451 -> 16632 bytes
_images/sqllab.png | Bin 0 -> 514789 bytes
_images/sunburst.png | Bin 173806 -> 26030 bytes
_images/table.png | Bin 109326 -> 22572 bytes
_images/time_pivot.png | Bin 0 -> 13209 bytes
_images/time_table.png | Bin 0 -> 17464 bytes
_images/treemap.png | Bin 96420 -> 16623 bytes
_images/tutorial_02_add_database.png | Bin 19533 -> 24994 bytes
_images/word_cloud.png | Bin 117846 -> 24048 bytes
_images/world_map.png | Bin 136501 -> 28598 bytes
_modules/index.html | 7 +-
_modules/superset/jinja_context.html | 25 +-
_sources/druid.rst.txt | 25 +-
_sources/faq.rst.txt | 33 +-
_sources/gallery.rst.txt | 163 +-
_sources/import_export_datasources.rst.txt | 108 ++
_sources/index.rst.txt | 22 +-
_sources/installation.rst.txt | 127 +-
_sources/misc.rst.txt | 10 +
_sources/security.rst.txt | 4 +-
_sources/sqllab.rst.txt | 17 +-
_sources/tutorial.rst.txt | 96 +-
_sources/videos.rst.txt | 53 +-
_sources/visualization.rst.txt | 1574 ++++++++++----------
_static/img/favicon.png | Bin 5586 -> 6927 bytes
_static/img/screenshots/bank_dash.png | Bin 0 -> 1532812 bytes
_static/img/screenshots/deckgl_dash.png | Bin 0 -> 6777438 bytes
_static/img/screenshots/explore.png | Bin 0 -> 674489 bytes
_static/img/screenshots/sqllab.png | Bin 0 -> 514789 bytes
_static/img/tutorial/tutorial_02_add_database.png | Bin 19533 -> 24994 bytes
_static/img/viz_thumbnails/area.png | Bin 105237 -> 14469 bytes
_static/img/viz_thumbnails/bar.png | Bin 50564 -> 9058 bytes
_static/img/viz_thumbnails/big_number.png | Bin 51404 -> 10101 bytes
_static/img/viz_thumbnails/big_number_total.png | Bin 27637 -> 4925 bytes
_static/img/viz_thumbnails/box_plot.png | Bin 56136 -> 9496 bytes
_static/img/viz_thumbnails/bubble.png | Bin 135455 -> 22779 bytes
_static/img/viz_thumbnails/bullet.png | Bin 8764 -> 2174 bytes
_static/img/viz_thumbnails/cal_heatmap.png | Bin 31627 -> 11238 bytes
_static/img/viz_thumbnails/chord.png | Bin 407616 -> 39273 bytes
_static/img/viz_thumbnails/compare.png | Bin 258894 -> 32918 bytes
_static/img/viz_thumbnails/country_map.png | Bin 303004 -> 41210 bytes
_static/img/viz_thumbnails/deck_arc.png | Bin 0 -> 38815 bytes
_static/img/viz_thumbnails/deck_geojson.png | Bin 0 -> 42386 bytes
_static/img/viz_thumbnails/deck_grid.png | Bin 0 -> 143670 bytes
_static/img/viz_thumbnails/deck_hex.png | Bin 0 -> 85015 bytes
_static/img/viz_thumbnails/deck_multi.png | Bin 0 -> 106790 bytes
_static/img/viz_thumbnails/deck_path.png | Bin 0 -> 75705 bytes
_static/img/viz_thumbnails/deck_polygon.png | Bin 0 -> 37261 bytes
_static/img/viz_thumbnails/deck_scatter.png | Bin 0 -> 120091 bytes
_static/img/viz_thumbnails/deck_screengrid.png | Bin 0 -> 76990 bytes
_static/img/viz_thumbnails/directed_force.png | Bin 247382 -> 42753 bytes
_static/img/viz_thumbnails/dist_bar.png | Bin 52519 -> 8752 bytes
_static/img/viz_thumbnails/dual_line.png | Bin 165716 -> 19229 bytes
_static/img/viz_thumbnails/event_flow.png | Bin 108626 -> 17191 bytes
_static/img/viz_thumbnails/filter_box.png | Bin 49653 -> 8550 bytes
_static/img/viz_thumbnails/heatmap.png | Bin 435496 -> 39866 bytes
_static/img/viz_thumbnails/histogram.png | Bin 64899 -> 9717 bytes
_static/img/viz_thumbnails/horizon.png | Bin 165253 -> 24924 bytes
_static/img/viz_thumbnails/iframe.png | Bin 755166 -> 50998 bytes
_static/img/viz_thumbnails/line.png | Bin 321509 -> 42915 bytes
_static/img/viz_thumbnails/mapbox.png | Bin 225567 -> 85714 bytes
_static/img/viz_thumbnails/markup.png | Bin 227846 -> 23186 bytes
_static/img/viz_thumbnails/multi.png | Bin 0 -> 108443 bytes
_static/img/viz_thumbnails/paired_ttest.png | Bin 236049 -> 23323 bytes
_static/img/viz_thumbnails/para.png | Bin 471027 -> 52039 bytes
_static/img/viz_thumbnails/partition.png | Bin 198125 -> 11364 bytes
_static/img/viz_thumbnails/pie.png | Bin 28302 -> 6007 bytes
_static/img/viz_thumbnails/pivot_table.png | Bin 276020 -> 54527 bytes
_static/img/viz_thumbnails/rose.png | Bin 0 -> 37386 bytes
_static/img/viz_thumbnails/sankey.png | Bin 205313 -> 43735 bytes
_static/img/viz_thumbnails/separator.png | Bin 101451 -> 16632 bytes
_static/img/viz_thumbnails/sunburst.png | Bin 173806 -> 26030 bytes
_static/img/viz_thumbnails/table.png | Bin 109326 -> 22572 bytes
_static/img/viz_thumbnails/time_pivot.png | Bin 0 -> 13209 bytes
_static/img/viz_thumbnails/time_table.png | Bin 65153 -> 17464 bytes
_static/img/viz_thumbnails/treemap.png | Bin 96420 -> 16623 bytes
_static/img/viz_thumbnails/word_cloud.png | Bin 117846 -> 24048 bytes
_static/img/viz_thumbnails/world_map.png | Bin 136501 -> 28598 bytes
.../area.png | Bin
.../bar.png | Bin
.../big_number.png | Bin
.../big_number_total.png | Bin
.../box_plot.png | Bin
.../bubble.png | Bin
.../bullet.png | Bin
.../cal_heatmap.png | Bin
.../chord.png | Bin
.../compare.png | Bin
.../country_map.png | Bin
_static/img/viz_thumbnails_large/deck_arc.png | Bin 0 -> 230107 bytes
_static/img/viz_thumbnails_large/deck_geojson.png | Bin 0 -> 181512 bytes
_static/img/viz_thumbnails_large/deck_grid.png | Bin 0 -> 2125810 bytes
_static/img/viz_thumbnails_large/deck_hex.png | Bin 0 -> 1090997 bytes
_static/img/viz_thumbnails_large/deck_multi.png | Bin 0 -> 991412 bytes
_static/img/viz_thumbnails_large/deck_path.png | Bin 0 -> 523094 bytes
_static/img/viz_thumbnails_large/deck_polygon.png | Bin 0 -> 443630 bytes
_static/img/viz_thumbnails_large/deck_scatter.png | Bin 0 -> 795739 bytes
.../img/viz_thumbnails_large/deck_screengrid.png | Bin 0 -> 591701 bytes
.../directed_force.png | Bin
.../dist_bar.png | Bin
.../dual_line.png | Bin
.../event_flow.png | Bin
.../filter_box.png | Bin
.../heatmap.png | Bin
.../histogram.png | Bin
.../horizon.png | Bin
.../iframe.png | Bin
.../line.png | Bin
.../mapbox.png | Bin
.../markup.png | Bin
_static/img/viz_thumbnails_large/multi.png | Bin 0 -> 761211 bytes
.../paired_ttest.png | Bin
.../para.png | Bin
.../partition.png | Bin
.../pie.png | Bin
.../pivot_table.png | Bin
_static/img/viz_thumbnails_large/rose.png | Bin 0 -> 506254 bytes
.../sankey.png | Bin
.../separator.png | Bin
.../sunburst.png | Bin
.../table.png | Bin
_static/img/viz_thumbnails_large/time_pivot.png | Bin 0 -> 84481 bytes
.../time_table.png | Bin
.../treemap.png | Bin
.../word_cloud.png | Bin
.../world_map.png | Bin
druid.html | 53 +-
faq.html | 67 +-
gallery.html | 95 +-
genindex.html | 32 +-
import_export_datasources.html | 345 +++++
index.html | 49 +-
installation.html | 149 +-
genindex.html => misc.html | 74 +-
objects.inv | Bin 457 -> 510 bytes
search.html | 7 +-
searchindex.js | 2 +-
security.html | 13 +-
sqllab.html | 42 +-
tutorial.html | 23 +-
videos.html | 83 +-
visualization.html | 59 +-
184 files changed, 2047 insertions(+), 1310 deletions(-)
diff --git a/_images/area.png b/_images/area.png
index 86f1080..6b2fb75 100644
Binary files a/_images/area.png and b/_images/area.png differ
diff --git a/_images/bank_dash.png b/_images/bank_dash.png
new file mode 100644
index 0000000..c0544b0
Binary files /dev/null and b/_images/bank_dash.png differ
diff --git a/_images/bar.png b/_images/bar.png
index ab0e8d9..1ef2633 100644
Binary files a/_images/bar.png and b/_images/bar.png differ
diff --git a/_images/big_number.png b/_images/big_number.png
index 2420f25..01d6da4 100644
Binary files a/_images/big_number.png and b/_images/big_number.png differ
diff --git a/_images/big_number_total.png b/_images/big_number_total.png
index eb4b345..350d5a1 100644
Binary files a/_images/big_number_total.png and b/_images/big_number_total.png differ
diff --git a/_images/box_plot.png b/_images/box_plot.png
index de8f061..8925e50 100644
Binary files a/_images/box_plot.png and b/_images/box_plot.png differ
diff --git a/_images/bubble.png b/_images/bubble.png
index 08de51f..4533881 100644
Binary files a/_images/bubble.png and b/_images/bubble.png differ
diff --git a/_images/bullet.png b/_images/bullet.png
index 7a66a41..f98c70f 100644
Binary files a/_images/bullet.png and b/_images/bullet.png differ
diff --git a/_images/cal_heatmap.png b/_images/cal_heatmap.png
index bf79a9e..c83db08 100644
Binary files a/_images/cal_heatmap.png and b/_images/cal_heatmap.png differ
diff --git a/_images/chord.png b/_images/chord.png
new file mode 100644
index 0000000..18df6a7
Binary files /dev/null and b/_images/chord.png differ
diff --git a/_images/compare.png b/_images/compare.png
index 00b0a7c..c17af52 100644
Binary files a/_images/compare.png and b/_images/compare.png differ
diff --git a/_images/country_map.png b/_images/country_map.png
new file mode 100644
index 0000000..52acbfa
Binary files /dev/null and b/_images/country_map.png differ
diff --git a/_images/deck_arc.png b/_images/deck_arc.png
new file mode 100644
index 0000000..02b84b1
Binary files /dev/null and b/_images/deck_arc.png differ
diff --git a/_images/deck_geojson.png b/_images/deck_geojson.png
new file mode 100644
index 0000000..9c1a732
Binary files /dev/null and b/_images/deck_geojson.png differ
diff --git a/_images/deck_grid.png b/_images/deck_grid.png
new file mode 100644
index 0000000..2710d9f
Binary files /dev/null and b/_images/deck_grid.png differ
diff --git a/_images/deck_hex.png b/_images/deck_hex.png
new file mode 100644
index 0000000..99149db
Binary files /dev/null and b/_images/deck_hex.png differ
diff --git a/_images/deck_multi.png b/_images/deck_multi.png
new file mode 100644
index 0000000..acedd5b
Binary files /dev/null and b/_images/deck_multi.png differ
diff --git a/_images/deck_path.png b/_images/deck_path.png
new file mode 100644
index 0000000..d783a14
Binary files /dev/null and b/_images/deck_path.png differ
diff --git a/_images/deck_polygon.png b/_images/deck_polygon.png
new file mode 100644
index 0000000..b32c540
Binary files /dev/null and b/_images/deck_polygon.png differ
diff --git a/_images/deck_scatter.png b/_images/deck_scatter.png
new file mode 100644
index 0000000..a111a15
Binary files /dev/null and b/_images/deck_scatter.png differ
diff --git a/_images/deck_screengrid.png b/_images/deck_screengrid.png
new file mode 100644
index 0000000..78a26e6
Binary files /dev/null and b/_images/deck_screengrid.png differ
diff --git a/_images/deckgl_dash.png b/_images/deckgl_dash.png
new file mode 100644
index 0000000..6ba049c
Binary files /dev/null and b/_images/deckgl_dash.png differ
diff --git a/_images/directed_force.png b/_images/directed_force.png
index 1cc7ce9..15e0edb 100644
Binary files a/_images/directed_force.png and b/_images/directed_force.png differ
diff --git a/_images/dist_bar.png b/_images/dist_bar.png
index b410147..cdd5120 100644
Binary files a/_images/dist_bar.png and b/_images/dist_bar.png differ
diff --git a/_images/dual_line.png b/_images/dual_line.png
new file mode 100644
index 0000000..a5f723c
Binary files /dev/null and b/_images/dual_line.png differ
diff --git a/_images/event_flow.png b/_images/event_flow.png
new file mode 100644
index 0000000..a24c1c5
Binary files /dev/null and b/_images/event_flow.png differ
diff --git a/_images/explore.png b/_images/explore.png
new file mode 100644
index 0000000..c462a6b
Binary files /dev/null and b/_images/explore.png differ
diff --git a/_images/filter_box.png b/_images/filter_box.png
index 209259c..be08f68 100644
Binary files a/_images/filter_box.png and b/_images/filter_box.png differ
diff --git a/_images/heatmap.png b/_images/heatmap.png
index ac81a45..8d5f8da 100644
Binary files a/_images/heatmap.png and b/_images/heatmap.png differ
diff --git a/_images/histogram.png b/_images/histogram.png
index f7bbe62..c6f8fdc 100644
Binary files a/_images/histogram.png and b/_images/histogram.png differ
diff --git a/_images/horizon.png b/_images/horizon.png
index a5d4bf3..f927b76 100644
Binary files a/_images/horizon.png and b/_images/horizon.png differ
diff --git a/_images/iframe.png b/_images/iframe.png
index d5f0f56..5c6524a 100644
Binary files a/_images/iframe.png and b/_images/iframe.png differ
diff --git a/_images/line.png b/_images/line.png
index 67f8fe8..7df5084 100644
Binary files a/_images/line.png and b/_images/line.png differ
diff --git a/_images/mapbox.png b/_images/mapbox.png
index 662c163..2132df5 100644
Binary files a/_images/mapbox.png and b/_images/mapbox.png differ
diff --git a/_images/markup.png b/_images/markup.png
index 675e42a..5878e15 100644
Binary files a/_images/markup.png and b/_images/markup.png differ
diff --git a/_images/paired_ttest.png b/_images/paired_ttest.png
new file mode 100644
index 0000000..4a3b225
Binary files /dev/null and b/_images/paired_ttest.png differ
diff --git a/_images/para.png b/_images/para.png
index fc1a157..5401034 100644
Binary files a/_images/para.png and b/_images/para.png differ
diff --git a/_images/partition.png b/_images/partition.png
new file mode 100644
index 0000000..f49ee88
Binary files /dev/null and b/_images/partition.png differ
diff --git a/_images/pie.png b/_images/pie.png
index ab76749..1c93bf5 100644
Binary files a/_images/pie.png and b/_images/pie.png differ
diff --git a/_images/pivot_table.png b/_images/pivot_table.png
index 37f86af..a22794b 100644
Binary files a/_images/pivot_table.png and b/_images/pivot_table.png differ
diff --git a/_images/rose.png b/_images/rose.png
new file mode 100644
index 0000000..2006746
Binary files /dev/null and b/_images/rose.png differ
diff --git a/_images/sankey.png b/_images/sankey.png
index 981cdba..93d73f6 100644
Binary files a/_images/sankey.png and b/_images/sankey.png differ
diff --git a/_images/separator.png b/_images/separator.png
index eddb59d..0533413 100644
Binary files a/_images/separator.png and b/_images/separator.png differ
diff --git a/_images/sqllab.png b/_images/sqllab.png
new file mode 100644
index 0000000..6d35a9b
Binary files /dev/null and b/_images/sqllab.png differ
diff --git a/_images/sunburst.png b/_images/sunburst.png
index f155363..ec6b607 100644
Binary files a/_images/sunburst.png and b/_images/sunburst.png differ
diff --git a/_images/table.png b/_images/table.png
index a3dd1be..0561210 100644
Binary files a/_images/table.png and b/_images/table.png differ
diff --git a/_images/time_pivot.png b/_images/time_pivot.png
new file mode 100644
index 0000000..83201c2
Binary files /dev/null and b/_images/time_pivot.png differ
diff --git a/_images/time_table.png b/_images/time_table.png
new file mode 100644
index 0000000..fe11d8e
Binary files /dev/null and b/_images/time_table.png differ
diff --git a/_images/treemap.png b/_images/treemap.png
index 0aec60c..27c6c5c 100644
Binary files a/_images/treemap.png and b/_images/treemap.png differ
diff --git a/_images/tutorial_02_add_database.png b/_images/tutorial_02_add_database.png
index 0ee12d3..7eb671a 100644
Binary files a/_images/tutorial_02_add_database.png and b/_images/tutorial_02_add_database.png differ
diff --git a/_images/word_cloud.png b/_images/word_cloud.png
index 03936e1..1829a2f 100644
Binary files a/_images/word_cloud.png and b/_images/word_cloud.png differ
diff --git a/_images/world_map.png b/_images/world_map.png
index 82e8ad2..4b3fe0b 100644
Binary files a/_images/world_map.png and b/_images/world_map.png differ
diff --git a/_modules/index.html b/_modules/index.html
index cb17a36..5f63f27 100644
--- a/_modules/index.html
+++ b/_modules/index.html
@@ -86,13 +86,12 @@
<ul>
<li class="toctree-l1"><a class="reference internal" href="../installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1"><a class="reference internal" href="../tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1"><a class="reference internal" href="../security.html">Security</a></li>
<li class="toctree-l1"><a class="reference internal" href="../sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1"><a class="reference internal" href="../visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1"><a class="reference internal" href="../videos.html">Videos</a></li>
-<li class="toctree-l1"><a class="reference internal" href="../gallery.html">Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../gallery.html">Visualizations Gallery</a></li>
<li class="toctree-l1"><a class="reference internal" href="../druid.html">Druid</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../misc.html">Misc</a></li>
<li class="toctree-l1"><a class="reference internal" href="../faq.html">FAQ</a></li>
</ul>
diff --git a/_modules/superset/jinja_context.html b/_modules/superset/jinja_context.html
index b1b2975..35909d6 100644
--- a/_modules/superset/jinja_context.html
+++ b/_modules/superset/jinja_context.html
@@ -87,13 +87,12 @@
<ul>
<li class="toctree-l1"><a class="reference internal" href="../../installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1"><a class="reference internal" href="../../tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../../tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../security.html">Security</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1"><a class="reference internal" href="../../visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1"><a class="reference internal" href="../../videos.html">Videos</a></li>
-<li class="toctree-l1"><a class="reference internal" href="../../gallery.html">Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../../gallery.html">Visualizations Gallery</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../druid.html">Druid</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../../misc.html">Misc</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../faq.html">FAQ</a></li>
</ul>
@@ -159,7 +158,8 @@
<div itemprop="articleBody">
<h1>Source code for superset.jinja_context</h1><div class="highlight"><pre>
-<span></span><span class="sd">"""Defines the templating context for SQL Lab"""</span>
+<span></span><span class="c1"># -*- coding: utf-8 -*-</span>
+<span class="sd">"""Defines the templating context for SQL Lab"""</span>
<span class="kn">from</span> <span class="nn">__future__</span> <span class="k">import</span> <span class="n">absolute_import</span>
<span class="kn">from</span> <span class="nn">__future__</span> <span class="k">import</span> <span class="n">division</span>
<span class="kn">from</span> <span class="nn">__future__</span> <span class="k">import</span> <span class="n">print_function</span>
@@ -167,6 +167,7 @@
<span class="kn">from</span> <span class="nn">datetime</span> <span class="k">import</span> <span class="n">datetime</span><span class="p">,</span> <span class="n">timedelta</span>
<span class="kn">import</span> <span class="nn">inspect</span>
+<span class="kn">import</span> <span class="nn">json</span>
<span class="kn">import</span> <span class="nn">random</span>
<span class="kn">import</span> <span class="nn">time</span>
<span class="kn">import</span> <span class="nn">uuid</span>
@@ -190,15 +191,21 @@
<div class="viewcode-block" id="url_param"><a class="viewcode-back" href="../../sqllab.html#superset.jinja_context.url_param">[docs]</a><span class="k">def</span> <span class="nf">url_param</span><span class="p">(</span><span class="n">param</span><span class="p">,</span> <span class="n">default</span><span class="o">=</span><span class="kc">None</span><span class="p">):</span>
- <span class="sd">"""Get a url paramater</span>
+ <span class="sd">"""Get a url or post data parameter</span>
-<span class="sd"> :param param: the url parameter to lookup</span>
+<span class="sd"> :param param: the parameter to lookup</span>
<span class="sd"> :type param: str</span>
<span class="sd"> :param default: the value to return in the absence of the parameter</span>
<span class="sd"> :type default: str</span>
<span class="sd"> """</span>
- <span class="nb">print</span><span class="p">(</span><span class="n">request</span><span class="o">.</span><span class="n">args</span><span class="p">)</span>
- <span class="k">return</span> <span class="n">request</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="n">param</span><span class="p">,</span> <span class="n">default</span><span class="p">)</span></div>
+ <span class="k">if</span> <span class="n">request</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="n">param</span><span class="p">):</span>
+ <span class="k">return</span> <span class="n">request</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="n">param</span><span class="p">,</span> <span class="n">default</span><span class="p">)</span>
+ <span class="c1"># Supporting POST as well as get</span>
+ <span class="k">if</span> <span class="n">request</span><span class="o">.</span><span class="n">form</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s1">'form_data'</span><span class="p">):</span>
+ <span class="n">form_data</span> <span class="o">=</span> <span class="n">json</span><span class="o">.</span><span class="n">loads</span><span class="p">(</span><span class="n">request</span><span class="o">.</span><span class="n">form</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s1">'form_data'</span><span class="p">))</span>
+ <span class="n">url_params</span> <span class="o">=</span> <span class="n">form_data</span><span class="p">[</span><span class="s1">'url_params'</span><span class="p">]</span> <span class="ow">or</span> <span class="p">{}</span>
+ <span class="k">return</span> <span class="n">url_params</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="n">param</span><span class="p">,</span> <span class="n">default</span><span class="p">)</span>
+ <span class="k">return</span> <span class="n">default</span></div>
<span class="k">def</span> <span class="nf">current_user_id</span><span class="p">():</span>
diff --git a/_sources/druid.rst.txt b/_sources/druid.rst.txt
index af956d9..b673546 100644
--- a/_sources/druid.rst.txt
+++ b/_sources/druid.rst.txt
@@ -1,16 +1,14 @@
Druid
=====
-Superset works well with Druid, though currently not all
-advanced features out of Druid are covered. This page clarifies what is
-covered and what isn't and explains how to use some of the features.
+Superset has a native connector to Druid, and a majority of Druid's
+features are accessible through Superset.
.. note ::
- Currently Airbnb runs against Druid ``0.8.x`` and previous /
- following versions are not tested against.
-
-Supported
-'''''''''
+ Druid now supports SQL and can be accessed through Superset's
+ SQLAlchemy connector. The long term vision is to deprecate
+ the Druid native REST connector and query Druid exclusively through
+ the SQL interface.
Aggregations
------------
@@ -28,7 +26,7 @@ element correspond to Druid aggregation definition. You can create your own
aggregations manually from the ``List Druid Metric`` tab following Druid
documentation.
-.. image:: _static/img/druid_agg.png
+.. image:: images/druid_agg.png
:scale: 50 %
Post-Aggregations
@@ -41,8 +39,9 @@ json post-aggregation definition (as specified in the Druid docs) in the
Json field.
-Not yet supported
-'''''''''''''''''
+Unsupported Features
+--------------------
-- Regex filters
-- Lookups / joins
+.. note ::
+ Unclear at this point, this section of the documentation could use
+ some input.
diff --git a/_sources/faq.rst.txt b/_sources/faq.rst.txt
index d825ef5..21e4e74 100644
--- a/_sources/faq.rst.txt
+++ b/_sources/faq.rst.txt
@@ -45,6 +45,15 @@ visualizations.
https://github.com/airbnb/superset/issues?q=label%3Aexample+is%3Aclosed
+Can I upload and visualize csv data?
+------------------------------------
+
+Yes, using the ``Upload a CSV`` button under the ``Sources`` menu item.
+This brings up a form that allows you specify required information.
+After creating the table from CSV, it can then be loaded like any
+other on the ``Sources -> Tables`` page.
+
+
Why are my queries timing out?
------------------------------
@@ -99,7 +108,7 @@ edit the ``JSON Metadata`` field, more specifically the
never be affected by any dashboard level filtering.
-..code::
+.. code-block:: json
{
"filter_immune_slices": [324, 65, 92],
@@ -134,7 +143,7 @@ to be refreshed - especially if some data is slow moving, or run heavy queries.
slices from the timed refresh process, add the ``timed_refresh_immune_slices`` key to the dashboard
``JSON Metadata`` field:
-..code::
+.. code-block:: json
{
"filter_immune_slices": [],
@@ -150,7 +159,7 @@ Slice refresh will also be staggered over the specified period. You can turn off
by setting the ``stagger_refresh`` to ``false`` and modify the stagger period by setting
``stagger_time`` to a value in milliseconds in the ``JSON Metadata`` field:
-..code::
+.. code-block:: json
{
"stagger_refresh": false,
@@ -161,7 +170,7 @@ Here, the entire dashboard will refresh at once if periodic refresh is on. The s
2.5 seconds is ignored.
Why does fabmanager or superset freezed/hung/not responding when started (my home directory is NFS mounted)?
------------------------------------------------------------------------------------------
+------------------------------------------------------------------------------------------------------------
By default, superset creates and uses an sqlite database at ``~/.superset/superset.db``. Sqlite is known to `don't work well if used on NFS`__ due to broken file locking implementation on NFS.
__ https://www.sqlite.org/lockingv3.html
@@ -221,3 +230,19 @@ When adding columns to a table, you can have Superset detect and merge the
new columns in by using the "Refresh Metadata" action in the
``Source -> Tables`` page. Simply check the box next to the tables
you want the schema refreshed, and click ``Actions -> Refresh Metadata``.
+
+Is there a way to force the use specific colors?
+------------------------------------------------
+
+It is possible on a per-dashboard basis by providing a mapping of
+labels to colors in the ``JSON Metadata`` attribute using the
+``label_colors`` key.
+
+.. code-block:: json
+
+ {
+ "label_colors": {
+ "Girls": "#FF69B4",
+ "Boys": "#ADD8E6"
+ }
+ }
diff --git a/_sources/gallery.rst.txt b/_sources/gallery.rst.txt
index f0c7dfa..5fa212d 100644
--- a/_sources/gallery.rst.txt
+++ b/_sources/gallery.rst.txt
@@ -1,89 +1,190 @@
-Gallery
-=======
+Visualizations Gallery
+======================
-.. image:: _static/img/viz_thumbnails/line.png
+.. image:: images/viz_thumbnails/area.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/bubble.png
+
+.. image:: images/viz_thumbnails/bar.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/table.png
+
+.. image:: images/viz_thumbnails/big_number.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/pie.png
+
+.. image:: images/viz_thumbnails/big_number_total.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/bar.png
+
+.. image:: images/viz_thumbnails/box_plot.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/world_map.png
+
+.. image:: images/viz_thumbnails/bubble.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/sankey.png
+
+.. image:: images/viz_thumbnails/bullet.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/word_cloud.png
+
+.. image:: images/viz_thumbnails/cal_heatmap.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/filter_box.png
+
+.. image:: images/viz_thumbnails/chord.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/compare.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/pivot_table.png
+
+.. image:: images/viz_thumbnails/country_map.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/deck_arc.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/deck_geojson.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/deck_grid.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/directed_force.png
+
+.. image:: images/viz_thumbnails/deck_hex.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/compare.png
+
+.. image:: images/viz_thumbnails/deck_multi.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/sunburst.png
+
+.. image:: images/viz_thumbnails/deck_path.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/area.png
+
+.. image:: images/viz_thumbnails/deck_polygon.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/big_number.png
+
+.. image:: images/viz_thumbnails/deck_scatter.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/big_number_total.png
+
+.. image:: images/viz_thumbnails/deck_screengrid.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/bullet.png
+
+.. image:: images/viz_thumbnails/directed_force.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/dist_bar.png
+
+.. image:: images/viz_thumbnails/dist_bar.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/heatmap.png
+
+.. image:: images/viz_thumbnails/dual_line.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/markup.png
+
+.. image:: images/viz_thumbnails/event_flow.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/para.png
+
+.. image:: images/viz_thumbnails/filter_box.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/iframe.png
+
+.. image:: images/viz_thumbnails/heatmap.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/box_plot.png
+
+.. image:: images/viz_thumbnails/histogram.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/treemap.png
+
+.. image:: images/viz_thumbnails/horizon.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/cal_heatmap.png
+
+.. image:: images/viz_thumbnails/iframe.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/horizon.png
+
+.. image:: images/viz_thumbnails/line.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/mapbox.png
+
+.. image:: images/viz_thumbnails/mapbox.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/separator.png
+
+.. image:: images/viz_thumbnails/markup.png
:scale: 25 %
-.. image:: _static/img/viz_thumbnails/histogram.png
+
+.. image:: images/viz_thumbnails/paired_ttest.png
:scale: 25 %
+
+
+.. image:: images/viz_thumbnails/para.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/partition.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/pie.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/pivot_table.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/rose.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/sankey.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/separator.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/sunburst.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/table.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/time_pivot.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/time_table.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/treemap.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/word_cloud.png
+ :scale: 25 %
+
+
+.. image:: images/viz_thumbnails/world_map.png
+ :scale: 25 %
+
diff --git a/_sources/import_export_datasources.rst.txt b/_sources/import_export_datasources.rst.txt
new file mode 100644
index 0000000..4de7a74
--- /dev/null
+++ b/_sources/import_export_datasources.rst.txt
@@ -0,0 +1,108 @@
+Importing and Exporting Datasources
+===================================
+
+The superset cli allows you to import and export datasources from and to YAML.
+Datasources include both databases and druid clusters. The data is expected to be organized in the following hierarchy: ::
+
+ .
+ ├──databases
+ | ├──database_1
+ | | ├──table_1
+ | | | ├──columns
+ | | | | ├──column_1
+ | | | | ├──column_2
+ | | | | └──... (more columns)
+ | | | └──metrics
+ | | | ├──metric_1
+ | | | ├──metric_2
+ | | | └──... (more metrics)
+ | | └── ... (more tables)
+ | └── ... (more databases)
+ └──druid_clusters
+ ├──cluster_1
+ | ├──datasource_1
+ | | ├──columns
+ | | | ├──column_1
+ | | | ├──column_2
+ | | | └──... (more columns)
+ | | └──metrics
+ | | ├──metric_1
+ | | ├──metric_2
+ | | └──... (more metrics)
+ | └── ... (more datasources)
+ └── ... (more clusters)
+
+
+Exporting Datasources to YAML
+-----------------------------
+You can print your current datasources to stdout by running: ::
+
+ superset export_datasources
+
+
+To save your datasources to a file run: ::
+
+ superset export_datasources -f <filename>
+
+
+By default, default (null) values will be omitted. Use the ``-d`` flag to include them.
+If you want back references to be included (e.g. a column to include the table id
+it belongs to) use the ``-b`` flag.
+
+Alternatively you can export datasources using the UI:
+
+1. Open **Sources** -> **Databases** to export all tables associated to a
+ single or multiple databases. (**Tables** for one or more tables,
+ **Druid Clusters** for clusters, **Druid Datasources** for datasources)
+#. Select the items you would like to export
+#. Click **Actions** -> **Export to YAML**
+#. If you want to import an item that you exported through the UI, you
+ will need to nest it inside its parent element, e.g. a `database`
+ needs to be nested under `databases` a `table` needs to be
+ nested inside a `database` element.
+
+Exporting the complete supported YAML schema
+--------------------------------------------
+In order to obtain an exhaustive list of all fields you can import using the YAML import run: ::
+
+ superset export_datasource_schema
+
+Again, you can use the ``-b`` flag to include back references.
+
+
+Importing Datasources from YAML
+-------------------------------
+In order to import datasources from a YAML file(s), run: ::
+
+ superset import_datasources -p <path or filename>
+
+If you supply a path all files ending with ``*.yaml`` or ``*.yml`` will be parsed.
+You can apply additional flags e.g.: ::
+
+ superset import_datasources -p <path> -r
+
+Will search the supplied path recursively.
+
+The sync flag ``-s`` takes parameters in order to sync the supplied elements with
+your file. Be careful this can delete the contents of your meta database. Example:
+
+ superset import_datasources -p <path / filename> -s columns,metrics
+
+This will sync all ``metrics`` and ``columns`` for all datasources found in the
+``<path / filename>`` in the Superset meta database. This means columns and metrics
+not specified in YAML will be deleted. If you would add ``tables`` to ``columns,metrics``
+those would be synchronised as well.
+
+
+If you don't supply the sync flag (``-s``) importing will only add and update (override) fields.
+E.g. you can add a ``verbose_name`` to the the column ``ds`` in the table ``random_time_series`` from the example datasets
+by saving the following YAML to file and then running the ``import_datasources`` command. ::
+
+ databases:
+ - database_name: main
+ tables:
+ - table_name: random_time_series
+ columns:
+ - column_name: ds
+ verbose_name: datetime
+
diff --git a/_sources/index.rst.txt b/_sources/index.rst.txt
index eba2e94..370f516 100644
--- a/_sources/index.rst.txt
+++ b/_sources/index.rst.txt
@@ -1,4 +1,4 @@
-.. image:: _static/img/s.png
+.. image:: images/s.png
Apache Superset (incubating)
''''''''''''''''''''''''''''
@@ -25,10 +25,10 @@ intelligence web application
endorsed by the ASF.
Overview
-=======================================
+========
Features
----------
+--------
- A rich set of data visualizations
- An easy-to-use interface for exploring and visualizing data
@@ -45,23 +45,28 @@ Features
- Integration with most SQL-speaking RDBMS through SQLAlchemy
- Deep integration with Druid.io
+Screenshots
+-----------
+
+.. image:: images/screenshots/bank_dash.png
+
------
-.. image:: https://camo.githubusercontent.com/82e264ef777ba06e1858766fe3b8817ee108eb7e/687474703a2f2f672e7265636f726469742e636f2f784658537661475574732e676966
+.. image:: images/screenshots/explore.png
------
-.. image:: https://camo.githubusercontent.com/4991ff37a0005ea4e4267919a52786fda82d2d21/687474703a2f2f672e7265636f726469742e636f2f755a6767594f645235672e676966
+.. image:: images/screenshots/sqllab.png
------
-.. image:: https://camo.githubusercontent.com/a389af15ac1e32a3d0fee941b4c62c850b1d583b/687474703a2f2f672e7265636f726469742e636f2f55373046574c704c76682e676966
+.. image:: images/screenshots/deckgl_dash.png
------
Contents
----------
+--------
.. toctree::
:maxdepth: 2
@@ -70,10 +75,9 @@ Contents
tutorial
security
sqllab
- visualization
- videos
gallery
druid
+ misc
faq
diff --git a/_sources/installation.rst.txt b/_sources/installation.rst.txt
index 3d043b8..be4abe8 100644
--- a/_sources/installation.rst.txt
+++ b/_sources/installation.rst.txt
@@ -53,6 +53,12 @@ the required dependencies are installed: ::
sudo apt-get install build-essential libssl-dev libffi-dev python-dev python-pip libsasl2-dev libldap2-dev
+**Ubuntu 16.04** If you have python3.5 installed alongside with python2.7, as is default on **Ubuntu 16.04 LTS**, run this command also
+
+ sudo apt-get install build-essential libssl-dev libffi-dev python3.5-dev python-pip libsasl2-dev libldap2-dev
+
+otherwhise build for ``cryptography`` fails.
+
For **Fedora** and **RHEL-derivatives**, the following command will ensure
that the required dependencies are installed: ::
@@ -119,10 +125,7 @@ Follow these few simple steps to install Superset.::
# Create default roles and permissions
superset init
- # Start the web server on port 8088, use -p to bind to another port
- superset runserver
-
- # To start a development web server, use the -d switch
+ # To start a development web server on port 8088, use -p to bind to another port
# superset runserver -d
@@ -141,14 +144,10 @@ Gunicorn, preferably in **async mode**, which allows for impressive
concurrency even and is fairly easy to install and configure. Please
refer to the
documentation of your preferred technology to set up this Flask WSGI
-application in a way that works well in your environment.
+application in a way that works well in your environment. Here's an **async**
+setup known to work well in production: ::
-While the `superset runserver` command act as an quick wrapper
-around `gunicorn`, it doesn't expose all the options you may need,
-so you'll want to craft your own `gunicorn` command in your production
-environment. Here's an **async** setup known to work well: ::
-
- gunicorn \
+ gunicorn \
-w 10 \
-k gevent \
--timeout 120 \
@@ -159,7 +158,7 @@ environment. Here's an **async** setup known to work well: ::
superset:app
Refer to the
-[Gunicorn documentation](http://docs.gunicorn.org/en/stable/design.html)
+`Gunicorn documentation <http://docs.gunicorn.org/en/stable/design.html>`_
for more information.
Note that *gunicorn* does not
@@ -167,6 +166,30 @@ work on Windows so the `superset runserver` command is not expected to work
in that context. Also note that the development web
server (`superset runserver -d`) is not intended for production use.
+If not using gunicorn, you may want to disable the use of flask-compress
+by setting `ENABLE_FLASK_COMPRESS = False` in your `superset_config.py`
+
+Flask-AppBuilder Permissions
+----------------------------
+
+By default every time the Flask-AppBuilder (FAB) app is initialized the
+permissions and views are added automatically to the backend and associated with
+the ‘Admin’ role. The issue however is when you are running multiple concurrent
+workers this creates a lot of contention and race conditions when defining
+permissions and views.
+
+To alleviate this issue, the automatic updating of permissions can be disabled
+by setting the :envvar:`SUPERSET_UPDATE_PERMS` environment variable to `0`.
+The value `1` enables it, `0` disables it. Note if undefined the functionality
+is enabled to maintain backwards compatibility.
+
+In a production environment initialization could take on the following form:
+
+ export SUPERSET_UPDATE_PERMS=1
+ superset init
+
+ export SUPERSET_UPDATE_PERMS=0
+ gunicorn -w 10 ... superset:app
Configuration behind a load balancer
------------------------------------
@@ -181,6 +204,11 @@ If the load balancer is inserting X-Forwarded-For/X-Forwarded-Proto headers, you
should set `ENABLE_PROXY_FIX = True` in the superset config file to extract and use
the headers.
+In case that the reverse proxy is used for providing ssl encryption,
+an explicit definition of the `X-Forwarded-Proto` may be required.
+For the Apache webserver this can be set as follows: ::
+
+ RequestHeader set X-Forwarded-Proto "https"
Configuration
-------------
@@ -193,7 +221,6 @@ of the parameters you can copy / paste in that configuration module: ::
# Superset specific config
#---------------------------------------------------------
ROW_LIMIT = 5000
- SUPERSET_WORKERS = 4
SUPERSET_WEBSERVER_PORT = 8088
#---------------------------------------------------------
@@ -215,17 +242,29 @@ of the parameters you can copy / paste in that configuration module: ::
WTF_CSRF_ENABLED = True
# Add endpoints that need to be exempt from CSRF protection
WTF_CSRF_EXEMPT_LIST = []
+ # A CSRF token that expires in 1 year
+ WTF_CSRF_TIME_LIMIT = 60 * 60 * 24 * 365
# Set this API key to enable Mapbox visualizations
MAPBOX_API_KEY = ''
-This file also allows you to define configuration parameters used by
-Flask App Builder, the web framework used by Superset. Please consult
+All the parameters and default values defined in
+https://github.com/apache/incubator-superset/blob/master/superset/config.py
+can be altered in your local ``superset_config.py`` .
+Administrators will want to
+read through the file to understand what can be configured locally
+as well as the default values in place.
+
+Since ``superset_config.py`` acts as a Flask configuration module, it
+can be used to alter the settings Flask itself,
+as well as Flask extensions like ``flask-wtf``, ``flask-cache``,
+``flask-migrate``, and ``flask-appbuilder``. Flask App Builder, the web
+framework used by Superset offers many configuration settings. Please consult
the `Flask App Builder Documentation
<http://flask-appbuilder.readthedocs.org/en/latest/config.html>`_
-for more information on how to configure Superset.
+for more information on how to configure it.
-Please make sure to change:
+Make sure to change:
* *SQLALCHEMY_DATABASE_URI*, by default it is stored at *~/.superset/superset.db*
* *SECRET_KEY*, to a long random string
@@ -259,7 +298,7 @@ Here's a list of some of the recommended packages.
+---------------+-------------------------------------+-------------------------------------------------+
| sqlite | | ``sqlite://`` |
+---------------+-------------------------------------+-------------------------------------------------+
-| Redshift | ``pip install sqlalchemy-redshift`` | ``postgresql+psycopg2://`` |
+| Redshift | ``pip install sqlalchemy-redshift`` | ``redshift+psycopg2://`` |
+---------------+-------------------------------------+-------------------------------------------------+
| MSSQL | ``pip install pymssql`` | ``mssql://`` |
+---------------+-------------------------------------+-------------------------------------------------+
@@ -277,6 +316,8 @@ Here's a list of some of the recommended packages.
| ClickHouse | ``pip install | ``clickhouse://`` |
| | sqlalchemy-clickhouse`` | |
+---------------+-------------------------------------+-------------------------------------------------+
+| Kylin | ``pip install kylinpy`` | ``kylin://`` |
++---------------+-------------------------------------+-------------------------------------------------+
Note that many other database are supported, the main criteria being the
existence of a functional SqlAlchemy dialect and Python driver. Googling
@@ -315,6 +356,16 @@ For setting your timeouts, this is done in the Superset metadata and goes
up the "timeout searchpath", from your slice configuration, to your
data source's configuration, to your database's and ultimately falls back
into your global default defined in ``CACHE_CONFIG``.
+
+.. code-block:: python
+
+ CACHE_CONFIG = {
+ 'CACHE_TYPE': 'redis',
+ 'CACHE_DEFAULT_TIMEOUT': 60 * 60 * 24, # 1 day default (in secs)
+ 'CACHE_KEY_PREFIX': 'superset_results',
+ 'CACHE_REDIS_URL': 'redis://localhost:6379/0',
+ }
+
Deeper SQLAlchemy integration
@@ -324,7 +375,7 @@ It is possible to tweak the database connection information using the
parameters exposed by SQLAlchemy. In the ``Database`` edit view, you will
find an ``extra`` field as a ``JSON`` blob.
-.. image:: _static/img/tutorial/add_db.png
+.. image:: images/tutorial/add_db.png
:scale: 30 %
This JSON string contains extra configuration elements. The ``engine_params``
@@ -360,6 +411,16 @@ in your config file to point to that function. ::
SQLALCHEMY_CUSTOM_PASSWORD_STORE = example_lookup_password
+A common pattern is to use environment variables to make secrets available.
+``SQLALCHEMY_CUSTOM_PASSWORD_STORE`` can also be used for that purpose. ::
+
+ def example_password_as_env_var(url):
+ # assuming the uri looks like
+ # mysql://localhost?superset_user:{SUPERSET_PASSWORD}
+ return url.password.format(os.environ)
+
+ SQLALCHEMY_CUSTOM_PASSWORD_STORE = example_password_as_env_var
+
SSL Access to databases
-----------------------
@@ -394,7 +455,7 @@ metadata from your Druid cluster(s)
CORS
------
+----
The extra CORS Dependency must be installed:
@@ -456,8 +517,8 @@ execute beyond the typical web request's timeout (30-60 seconds), it is
necessary to configure an asynchronous backend for Superset which consist of:
* one or many Superset worker (which is implemented as a Celery worker), and
- can be started with the ``superset worker`` command, run
- ``superset worker --help`` to view the related options
+ can be started with the ``celery worker`` command, run
+ ``celery worker --help`` to view the related options.
* a celery broker (message queue) for which we recommend using Redis
or RabbitMQ
* a results backend that defines where the worker will persist the query
@@ -477,6 +538,10 @@ have the same configuration.
CELERY_CONFIG = CeleryConfig
+To start a Celery worker to leverage the configuration run: ::
+
+ celery worker --app=superset.sql_lab:celery_app --pool=gevent -Ofair
+
To setup a result backend, you need to pass an instance of a derivative
of ``werkzeug.contrib.cache.BaseCache`` to the ``RESULTS_BACKEND``
configuration key in your ``superset_config.py``. It's possible to use
@@ -498,6 +563,11 @@ look something like:
RESULTS_BACKEND = RedisCache(
host='localhost', port=6379, key_prefix='superset_results')
+Note that it's important that all the worker nodes and web servers in
+the Superset cluster share a common metadata database.
+This means that SQLite will not work in this context since it has
+limited support for concurrency and
+typically lives on the local file system.
Also note that SQL Lab supports Jinja templating in queries, and that it's
possible to overload
@@ -512,6 +582,15 @@ in this dictionary are made available for users to use in their SQL.
}
+Flower is a web based tool for monitoring the Celery cluster which you can
+install from pip: ::
+
+ pip install flower
+
+and run via: ::
+
+ celery flower --app=superset.sql_lab:celery_app
+
Making your own build
---------------------
@@ -539,7 +618,7 @@ at the ``/simple_page`` url. This can allow you to run other things such
as custom data visualization applications alongside Superset, on the
same server.
-..code ::
+.. code-block:: python
from flask import Blueprint
simple_page = Blueprint('simple_page', __name__,
@@ -560,7 +639,7 @@ are logged as well as key events like query start and end in SQL Lab.
To setup StatsD logging, it's a matter of configuring the logger in your
``superset_config.py``.
-..code ::
+.. code-block:: python
from superset.stats_logger import StatsdStatsLogger
STATS_LOGGER = StatsdStatsLogger(host='localhost', port=8125, prefix='superset')
diff --git a/_sources/misc.rst.txt b/_sources/misc.rst.txt
new file mode 100644
index 0000000..fb953dd
--- /dev/null
+++ b/_sources/misc.rst.txt
@@ -0,0 +1,10 @@
+
+Misc
+----
+
+.. toctree::
+ :maxdepth: 2
+
+ visualization
+ videos
+ import_export_datasources
diff --git a/_sources/security.rst.txt b/_sources/security.rst.txt
index afc00cb..b6a2b10 100644
--- a/_sources/security.rst.txt
+++ b/_sources/security.rst.txt
@@ -10,7 +10,7 @@ Provided Roles
--------------
Superset ships with a set of roles that are handled by Superset itself.
You can assume that these roles will stay up-to-date as Superset evolves.
-Even though it's possible for ``Admin`` usrs to do so, it is not recommended
+Even though it's possible for ``Admin`` users to do so, it is not recommended
that you alter these roles in any way by removing
or adding permissions to them as these roles will be re-synchronized to
their original values as you run your next ``superset init`` command.
@@ -70,7 +70,7 @@ sure the users with limited access have [only] the Gamma role assigned to
them. Second, create a new role (``Menu -> Security -> List Roles``) and
click the ``+`` sign.
-.. image:: _static/img/create_role.png
+.. image:: images/create_role.png
:scale: 50 %
This new window allows you to give this new role a name, attribute it to users
diff --git a/_sources/sqllab.rst.txt b/_sources/sqllab.rst.txt
index a1da6c7..9230b2c 100644
--- a/_sources/sqllab.rst.txt
+++ b/_sources/sqllab.rst.txt
@@ -4,6 +4,11 @@ SQL Lab
SQL Lab is a modern, feature-rich SQL IDE written in
`React <https://facebook.github.io/react/>`_.
+------
+
+.. image:: images/screenshots/sqllab.png
+
+------
Feature Overview
----------------
@@ -48,17 +53,25 @@ Available macros
We expose certain modules from Python's standard library in
Superset's Jinja context:
+
- ``time``: ``time``
- ``datetime``: ``datetime.datetime``
- ``uuid``: ``uuid``
- ``random``: ``random``
- ``relativedelta``: ``dateutil.relativedelta.relativedelta``
-- more to come!
`Jinja's builtin filters <http://jinja.pocoo.org/docs/dev/templates/>`_ can be also be applied where needed.
-
.. autoclass:: superset.jinja_context.PrestoTemplateProcessor
:members:
.. autofunction:: superset.jinja_context.url_param
+
+Extending macros
+''''''''''''''''
+
+As mentioned in the `Installation & Configuration <https://superset.incubator.apache.org/installation.html#installation-configuration>`_ documentation,
+it's possible for administrators to expose more more macros in their
+environment using the configuration variable ``JINJA_CONTEXT_ADDONS``.
+All objects referenced in this dictionary will become available for users
+to integrate in their queries in **SQL Lab**.
diff --git a/_sources/tutorial.rst.txt b/_sources/tutorial.rst.txt
index 695057c..82ac31e 100644
--- a/_sources/tutorial.rst.txt
+++ b/_sources/tutorial.rst.txt
@@ -1,31 +1,31 @@
-Tutorial for Superset Administrators
-====================================
+Tutorial - Creating your first dashboard
+========================================
-This tutorial targets a Superset administrator: someone configuring Superset
-for an organization on behalf of users. We'll show you how to connect Superset
-to a new database and configure a table in that database for analysis. You'll
-also explore the data you've exposed and add a visualization to a dashboard
+This tutorial targets someone who wants to create charts and dashboards
+in Superset. We'll show you how to connect Superset
+to a new database and configure a table in that database for analysis. You'll
+also explore the data you've exposed and add a visualization to a dashboard
so that you get a feel for the end-to-end user experience.
Connecting to a new database
----------------------------
We assume you already have a database configured and can connect to it from the
-instance on which you’re running Superset. If you’re just testing Superset and
-want to explore sample data, you can load some
+instance on which you’re running Superset. If you’re just testing Superset and
+want to explore sample data, you can load some
`sample PostgreSQL datasets <https://wiki.postgresql.org/wiki/Sample_Databases>`_
-into a fresh DB, or configure the
+into a fresh DB, or configure the
`example weather data <https://github.com/dylburger/noaa-ghcn-weather-data>`_
we use here.
Under the **Sources** menu, select the *Databases* option:
-.. image:: _static/img/tutorial/tutorial_01_sources_database.png
+.. image:: images/tutorial/tutorial_01_sources_database.png
:scale: 70%
-On the resulting page, click on the green plus sign, near the top left:
+On the resulting page, click on the green plus sign, near the top right:
-.. image:: _static/img/tutorial/tutorial_02_add_database.png
+.. image:: images/tutorial/tutorial_02_add_database.png
:scale: 70%
You can configure a number of advanced options on this page, but for
@@ -33,12 +33,12 @@ this walkthrough, you’ll only need to do **two things**:
1. Name your database connection:
-.. image:: _static/img/tutorial/tutorial_03_database_name.png
+.. image:: images/tutorial/tutorial_03_database_name.png
:scale: 70%
2. Provide the SQLAlchemy Connection URI and test the connection:
-.. image:: _static/img/tutorial/tutorial_04_sqlalchemy_connection_string.png
+.. image:: images/tutorial/tutorial_04_sqlalchemy_connection_string.png
:scale: 70%
This example shows the connection string for our test weather database.
@@ -51,19 +51,19 @@ Click the **Test Connection** button to confirm things work end to end.
Once Superset can successfully connect and authenticate, you should see
a popup like this:
-.. image:: _static/img/tutorial/tutorial_05_connection_popup.png
+.. image:: images/tutorial/tutorial_05_connection_popup.png
:scale: 50%
Moreover, you should also see the list of tables Superset can read from
the schema you’re connected to, at the bottom of the page:
-.. image:: _static/img/tutorial/tutorial_06_list_of_tables.png
+.. image:: images/tutorial/tutorial_06_list_of_tables.png
:scale: 70%
If the connection looks good, save the configuration by clicking the **Save**
button at the bottom of the page:
-.. image:: _static/img/tutorial/tutorial_07_save_button.png
+.. image:: images/tutorial/tutorial_07_save_button.png
:scale: 70%
Adding a new table
@@ -74,25 +74,25 @@ to Superset that you’d like to query.
Under the **Sources** menu, select the *Tables* option:
-.. image:: _static/img/tutorial/tutorial_08_sources_tables.png
+.. image:: images/tutorial/tutorial_08_sources_tables.png
:scale: 70%
On the resulting page, click on the green plus sign, near the top left:
-.. image:: _static/img/tutorial/tutorial_09_add_new_table.png
+.. image:: images/tutorial/tutorial_09_add_new_table.png
:scale: 70%
You only need a few pieces of information to add a new table to Superset:
* The name of the table
-.. image:: _static/img/tutorial/tutorial_10_table_name.png
+.. image:: images/tutorial/tutorial_10_table_name.png
:scale: 70%
* The target database from the **Database** drop-down menu (i.e. the one
you just added above)
-.. image:: _static/img/tutorial/tutorial_11_choose_db.png
+.. image:: images/tutorial/tutorial_11_choose_db.png
:scale: 70%
* Optionally, the database schema. If the table exists in the “default” schema
@@ -101,13 +101,13 @@ You only need a few pieces of information to add a new table to Superset:
Click on the **Save** button to save the configuration:
-.. image:: _static/img/tutorial/tutorial_07_save_button.png
+.. image:: images/tutorial/tutorial_07_save_button.png
:scale: 70%
When redirected back to the list of tables, you should see a message indicating
that your table was created:
-.. image:: _static/img/tutorial/tutorial_12_table_creation_success_msg.png
+.. image:: images/tutorial/tutorial_12_table_creation_success_msg.png
:scale: 70%
This message also directs you to edit the table configuration. We’ll edit a limited
@@ -116,7 +116,7 @@ a more advanced tutorial.
Click on the edit button next to the table you’ve created:
-.. image:: _static/img/tutorial/tutorial_13_edit_table_config.png
+.. image:: images/tutorial/tutorial_13_edit_table_config.png
:scale: 70%
On the resulting page, click on the **List Table Column** tab. Here, you’ll define the
@@ -136,7 +136,7 @@ Here’s how we’ve configured fields for the weather data. Even for measures l
weather measurements (precipitation, snowfall, etc.), it’s ideal to group and filter
by these values:
-.. image:: _static/img/tutorial/tutorial_14_field_config.png
+.. image:: images/tutorial/tutorial_14_field_config.png
As with the configurations above, click the **Save** button to save these settings.
@@ -146,17 +146,17 @@ Exploring your data
To start exploring your data, simply click on the table name you just created in
the list of available tables:
-.. image:: _static/img/tutorial/tutorial_15_click_table_name.png
+.. image:: images/tutorial/tutorial_15_click_table_name.png
By default, you’ll be presented with a Table View:
-.. image:: _static/img/tutorial/tutorial_16_datasource_chart_type.png
+.. image:: images/tutorial/tutorial_16_datasource_chart_type.png
Let’s walk through a basic query to get the count of all records in our table.
First, we’ll need to change the **Since** filter to capture the range of our data.
You can use simple phrases to apply these filters, like "3 years ago":
-.. image:: _static/img/tutorial/tutorial_17_choose_time_range.png
+.. image:: images/tutorial/tutorial_17_choose_time_range.png
The upper limit for time, the **Until** filter, defaults to "now", which may or may
not be what you want.
@@ -164,25 +164,25 @@ not be what you want.
Look for the Metrics section under the **GROUP BY** header, and start typing "Count"
- you’ll see a list of metrics matching what you type:
-.. image:: _static/img/tutorial/tutorial_18_choose_metric.png
+.. image:: images/tutorial/tutorial_18_choose_metric.png
Select the *COUNT(\*)* metric, then click the green **Query** button near the top
of the explore:
-.. image:: _static/img/tutorial/tutorial_19_click_query.png
+.. image:: images/tutorial/tutorial_19_click_query.png
You’ll see your results in the table:
-.. image:: _static/img/tutorial/tutorial_20_count_star_result.png
+.. image:: images/tutorial/tutorial_20_count_star_result.png
Let’s group this by the *weather_description* field to get the count of records by
the type of weather recorded by adding it to the *Group by* section:
-.. image:: _static/img/tutorial/tutorial_21_group_by.png
+.. image:: images/tutorial/tutorial_21_group_by.png
and run the query:
-.. image:: _static/img/tutorial/tutorial_22_group_by_result.png
+.. image:: images/tutorial/tutorial_22_group_by_result.png
Let’s find a more useful data point: the top 10 times and places that recorded the
highest temperature in 2015.
@@ -190,11 +190,11 @@ highest temperature in 2015.
We replace *weather_description* with *latitude*, *longitude* and *measurement_date* in the
*Group by* section:
-.. image:: _static/img/tutorial/tutorial_23_group_by_more_dimensions.png
+.. image:: images/tutorial/tutorial_23_group_by_more_dimensions.png
And replace *COUNT(\*)* with *max__measurement_flag*:
-.. image:: _static/img/tutorial/tutorial_24_max_metric.png
+.. image:: images/tutorial/tutorial_24_max_metric.png
The *max__measurement_flag* metric was created when we checked the box under **Max** and
next to the *measurement_flag* field, indicating that this field was numeric and that
@@ -206,16 +206,16 @@ precipitation and temperature). Therefore, we must filter our query only on reco
where the *weather_description* is equal to "Maximum temperature", which we do in
the **Filters** section at the bottom of the explore:
-.. image:: _static/img/tutorial/tutorial_25_max_temp_filter.png
+.. image:: images/tutorial/tutorial_25_max_temp_filter.png
Finally, since we only care about the top 10 measurements, we limit our results to
10 records using the *Row limit* option under the **Options** header:
-.. image:: _static/img/tutorial/tutorial_26_row_limit.png
+.. image:: images/tutorial/tutorial_26_row_limit.png
We click **Query** and get the following results:
-.. image:: _static/img/tutorial/tutorial_27_top_10_max_temps.png
+.. image:: images/tutorial/tutorial_27_top_10_max_temps.png
In this dataset, the maximum temperature is recorded in tenths of a degree Celsius.
The top value of 1370, measured in the middle of Nevada, is equal to 137 C, or roughly
@@ -240,20 +240,20 @@ a dashboard.
We change the Chart Type to "Distribution - Bar Chart":
-.. image:: _static/img/tutorial/tutorial_28_bar_chart.png
+.. image:: images/tutorial/tutorial_28_bar_chart.png
Our filter on Maximum temperature measurements was retained, but the query and
formatting options are dependent on the chart type, so you’ll have to set the
values again:
-.. image:: _static/img/tutorial/tutorial_29_bar_chart_series_metrics.png
+.. image:: images/tutorial/tutorial_29_bar_chart_series_metrics.png
You should note the extensive formatting options for this chart: the ability to
set axis labels, margins, ticks, etc. To make the data presentable to a broad
audience, you’ll want to apply many of these to slices that end up in dashboards.
For now, though, we run our query and get the following chart:
-.. image:: _static/img/tutorial/tutorial_30_bar_chart_results.png
+.. image:: images/tutorial/tutorial_30_bar_chart_results.png
:scale: 70%
Creating a slice and dashboard
@@ -265,39 +265,39 @@ a saved query is called a **Slice**.
To create a slice, click the **Save as** button near the top-left of the
explore:
-.. image:: _static/img/tutorial/tutorial_19_click_query.png
+.. image:: images/tutorial/tutorial_19_click_query.png
A popup should appear, asking you to name the slice, and optionally add it to a
dashboard. Since we haven’t yet created any dashboards, we can create one and
immediately add our slice to it. Let’s do it:
-.. image:: _static/img/tutorial/tutorial_31_save_slice_to_dashboard.png
+.. image:: images/tutorial/tutorial_31_save_slice_to_dashboard.png
:scale: 70%
Click Save, which will direct you back to your original query. We see that
our slice and dashboard were successfully created:
-.. image:: _static/img/tutorial/tutorial_32_save_slice_confirmation.png
+.. image:: images/tutorial/tutorial_32_save_slice_confirmation.png
:scale: 70%
Let’s check out our new dashboard. We click on the **Dashboards** menu:
-.. image:: _static/img/tutorial/tutorial_33_dashboard.png
+.. image:: images/tutorial/tutorial_33_dashboard.png
and find the dashboard we just created:
-.. image:: _static/img/tutorial/tutorial_34_weather_dashboard.png
+.. image:: images/tutorial/tutorial_34_weather_dashboard.png
Things seemed to have worked - our slice is here!
-.. image:: _static/img/tutorial/tutorial_35_slice_on_dashboard.png
+.. image:: images/tutorial/tutorial_35_slice_on_dashboard.png
:scale: 70%
But it’s a bit smaller than we might like. Luckily, you can adjust the size
of slices in a dashboard by clicking, holding and dragging the bottom-right
corner to your desired dimensions:
-.. image:: _static/img/tutorial/tutorial_36_adjust_dimensions.gif
+.. image:: images/tutorial/tutorial_36_adjust_dimensions.gif
:scale: 120%
After adjusting the size, you’ll be asked to click on the icon near the
diff --git a/_sources/videos.rst.txt b/_sources/videos.rst.txt
index 15ef91d..9c00b41 100644
--- a/_sources/videos.rst.txt
+++ b/_sources/videos.rst.txt
@@ -1,54 +1,5 @@
Videos
======
-Here is a collection of short videos showing different aspect
-of Superset.
-
-Quick Intro
-'''''''''''
-This video demonstrates how Superset works at a high level, it shows how
-to navigate through datasets and dashboards that are already available.
-
-.. youtube:: https://www.youtube.com/watch?v=3Txm_nj_R7M
-
-Dashboard Creation
-''''''''''''''''''
-This video walk you through the creation of a simple dashboard as a
-collection of data slices.
-
-- Coming soon!
-
-Dashboard Filtering
-'''''''''''''''''''
-This video shows how to create dynamic filters on dashboards, how to
-immunize certain widgets from being affected by filters.
-
-- Coming soon!
-
-Customize CSS and dashboard themes
-''''''''''''''''''''''''''''''''''
-A quick walkthrough on how to apply existing CSS templates, alter them and
-create new ones.
-
-- Coming soon!
-
-Slice Annotations
-'''''''''''''''''
-A short video on how to annotate your charts, the markdown language and
-to toggle them on dashboards.
-
-- Coming soon!
-
-Adding a Table
-''''''''''''''
-This videos shows you how to expose a new table in Superset, and how to
-define the semantics on how this can be accessed by others in the ``Explore``
-and ``Dashboard`` views.
-
-- Coming soon!
-
-Define SQL Expressions
-''''''''''''''''''''''
-A walkthrough on how to create your own derived dimensions and metrics.
-
-- Coming soon!
+.. note ::
+ This section of the documentation has yet to be filled in.
diff --git a/_sources/visualization.rst.txt b/_sources/visualization.rst.txt
index c10e8fe..45cd76c 100644
--- a/_sources/visualization.rst.txt
+++ b/_sources/visualization.rst.txt
@@ -7,7 +7,7 @@ Country Map Tools
-----------------
This tool is used in slices for visualization number or string by region, province or department of your countries.
-So, if you want to use tools, you need ISO 3166-2 code of region, province or departmenent.
+So, if you want to use tools, you need ISO 3166-2 code of region, province or department.
ISO 3166-2 is part of the ISO 3166 standard published by the International Organization for Standardization (ISO), and defines codes for identifying the principal subdivisions (e.g., provinces or states) of all countries coded in ISO 3166-1
@@ -22,7 +22,7 @@ List of Countries
* Belgium
+---------+-------------------+
-| ISO | Name of region |
+| ISO | Name of region |
+=========+===================+
| BE-BRU | Bruxelles |
+---------+-------------------+
@@ -54,7 +54,7 @@ List of Countries
* Brazil
+----------+-----------------------+
-| ISO | Name of region |
+| ISO | Name of region |
+==========+=======================+
| BR-AC | Acre |
+----------+-----------------------+
@@ -114,7 +114,7 @@ List of Countries
* China
+---------+--------------------+
-| ISO | Name of region |
+| ISO | Name of region |
+=========+====================+
| CN-34 | Anhui |
+---------+--------------------+
@@ -188,7 +188,7 @@ List of Countries
* Egypt
+---------+--------------------+
-| ISO | Name of region |
+| ISO | Name of region |
+=========+====================+
| EG-DK | Ad Daqahliyah |
+---------+--------------------+
@@ -249,7 +249,7 @@ List of Countries
* France
+---------+------------------------------+
-| ISO | Name of region |
+| ISO | Name of region |
+=========+==============================+
| FR-67 | Bas-Rhin |
+---------+------------------------------+
@@ -448,7 +448,7 @@ List of Countries
* Germany
+---------+------------------------------+
-| ISO | Name of region |
+| ISO | Name of region |
+=========+==============================+
| DE-BW | Baden-Württemberg |
+---------+------------------------------+
@@ -488,7 +488,7 @@ List of Countries
+------+------------------------------------+
-|ISO | Name of region |
+|ISO | Name of region |
+======+====================================+
|IT-CH |Chieti |
+------+------------------------------------+
@@ -713,123 +713,123 @@ List of Countries
* Morocco
-+------+------------------------------+
-|ISO | Name of region |
-+======+==============================+
-|MA-BES| Ben Slimane |
-+------+------------------------------+
-|MA-KHO| Khouribga |
-+------+------------------------------+
-|MA-SET| Settat |
-+------+------------------------------+
-|MA-JDI| El Jadida |
-+------+------------------------------+
-|MA-SAF| Safi |
-+------+------------------------------+
-|MA-BOM| Boulemane |
-+------+------------------------------+
-|MA-FES| Fès |
-+------+------------------------------+
-|MA-SEF| Sefrou |
-+------+------------------------------+
-|MA-MOU| Zouagha-Moulay Yacoub |
-+------+------------------------------+
-|MA-KEN| Kénitra |
-+------+------------------------------+
-|MA-SIK| Sidi Kacem |
-+------+------------------------------+
-|MA-CAS| Casablanca |
-+------+------------------------------+
-|MA-MOH| Mohammedia |
-+------+------------------------------+
-|MA-ASZ| Assa-Zag |
-+------+------------------------------+
-|MA-GUE| Guelmim |
-+------+------------------------------+
-|MA-TNT| Tan-Tan |
-+------+------------------------------+
-|MA-TAT| Tata |
-+------+------------------------------+
-|MA-LAA| Laâyoune |
-+------+------------------------------+
-|MA-HAO| Al Haouz |
-+------+------------------------------+
-|MA-CHI| Chichaoua |
-+------+------------------------------+
-|MA-KES| El Kelaâ des Sraghna |
-+------+------------------------------+
-|MA-ESI| Essaouira |
-+------+------------------------------+
-|MA-MMD| Marrakech |
-+------+------------------------------+
-|MA-HAJ| El Hajeb |
-+------+------------------------------+
-|MA-ERR| Errachidia |
-+------+------------------------------+
-|MA-IFR| Ifrane |
-+------+------------------------------+
-|MA-KHN| Khénifra |
-+------+------------------------------+
-|MA-MEK| Meknès |
-+------+------------------------------+
-|MA-BER| Berkane Taourirt |
-+------+------------------------------+
-|MA-FIG| Figuig |
-+------+------------------------------+
-|MA-JRA| Jerada |
-+------+------------------------------+
-|MA-NAD| Nador |
-+------+------------------------------+
-|MA-OUJ| Oujda Angad |
-+------+------------------------------+
-|MA-KHE| Khémisset |
-+------+------------------------------+
-|MA-RAB| Rabat |
-+------+------------------------------+
-|MA-SAL| Salé |
-+------+------------------------------+
-|MA-SKH| Skhirate-Témara |
-+------+------------------------------+
-|MA-AGD| Agadir-Ida ou Tanane |
-+------+------------------------------+
-|MA-CHT| Chtouka-Aït Baha |
-+------+------------------------------+
-|MA-INE| Inezgane-Aït Melloul |
-+------+------------------------------+
-|MA-OUA| Ouarzazate |
-+------+------------------------------+
-|MA-TAR| Taroudannt |
-+------+------------------------------+
-|MA-TIZ| Tiznit |
-+------+------------------------------+
-|MA-ZAG| Zagora |
-+------+------------------------------+
-|MA-AZI| Azilal |
-+------+------------------------------+
-|MA-BEM| Béni Mellal |
-+------+------------------------------+
-|MA-CHE| Chefchaouen |
-+------+------------------------------+
-|MA-FAH| Fahs Anjra |
-+------+------------------------------+
-|MA-LAR| Larache |
-+------+------------------------------+
-|MA-TET| Tétouan |
-+------+------------------------------+
-|MA-TNG| Tanger-Assilah |
-+------+------------------------------+
-|MA-HOC| Al Hoceïma |
-+------+------------------------------+
-|MA-TAO| Taounate |
-+------+------------------------------+
-|MA-TAZ| Taza |
-+------+------------------------------+
++-------+------------------------------+
+|ISO | Name of region |
++=======+==============================+
+|MA-BES | Ben Slimane |
++-------+------------------------------+
+|MA-KHO | Khouribga |
++-------+------------------------------+
+|MA-SET | Settat |
++-------+------------------------------+
+|MA-JDI | El Jadida |
++-------+------------------------------+
+|MA-SAF | Safi |
++-------+------------------------------+
+|MA-BOM | Boulemane |
++-------+------------------------------+
+|MA-FES | Fès |
++-------+------------------------------+
+|MA-SEF | Sefrou |
++-------+------------------------------+
+|MA-MOU | Zouagha-Moulay Yacoub |
++-------+------------------------------+
+|MA-KEN | Kénitra |
++-------+------------------------------+
+|MA-SIK | Sidi Kacem |
++-------+------------------------------+
+|MA-CAS | Casablanca |
++-------+------------------------------+
+|MA-MOH | Mohammedia |
++-------+------------------------------+
+|MA-ASZ | Assa-Zag |
++-------+------------------------------+
+|MA-GUE | Guelmim |
++-------+------------------------------+
+|MA-TNT | Tan-Tan |
++-------+------------------------------+
+|MA-TAT | Tata |
++-------+------------------------------+
+|MA-LAA | Laâyoune |
++-------+------------------------------+
+|MA-HAO | Al Haouz |
++-------+------------------------------+
+|MA-CHI | Chichaoua |
++-------+------------------------------+
+|MA-KES | El Kelaâ des Sraghna |
++-------+------------------------------+
+|MA-ESI | Essaouira |
++-------+------------------------------+
+|MA-MMD | Marrakech |
++-------+------------------------------+
+|MA-HAJ | El Hajeb |
++-------+------------------------------+
+|MA-ERR | Errachidia |
++-------+------------------------------+
+|MA-IFR | Ifrane |
++-------+------------------------------+
+|MA-KHN | Khénifra |
++-------+------------------------------+
+|MA-MEK | Meknès |
++-------+------------------------------+
+|MA-BER | Berkane Taourirt |
++-------+------------------------------+
+|MA-FIG | Figuig |
++-------+------------------------------+
+|MA-JRA | Jerada |
++-------+------------------------------+
+|MA-NAD | Nador |
++-------+------------------------------+
+|MA-OUJ | Oujda Angad |
++-------+------------------------------+
+|MA-KHE | Khémisset |
++-------+------------------------------+
+|MA-RAB | Rabat |
++-------+------------------------------+
+|MA-SAL | Salé |
++-------+------------------------------+
+|MA-SKH | Skhirate-Témara |
++-------+------------------------------+
+|MA-AGD | Agadir-Ida ou Tanane |
++-------+------------------------------+
+|MA-CHT | Chtouka-Aït Baha |
++-------+------------------------------+
+|MA-INE | Inezgane-Aït Melloul |
++-------+------------------------------+
+|MA-OUA | Ouarzazate |
++-------+------------------------------+
+|MA-TAR | Taroudannt |
++-------+------------------------------+
+|MA-TIZ | Tiznit |
++-------+------------------------------+
+|MA-ZAG | Zagora |
++-------+------------------------------+
+|MA-AZI | Azilal |
++-------+------------------------------+
+|MA-BEM | Béni Mellal |
++-------+------------------------------+
+|MA-CHE | Chefchaouen |
++-------+------------------------------+
+|MA-FAH | Fahs Anjra |
++-------+------------------------------+
+|MA-LAR | Larache |
++-------+------------------------------+
+|MA-TET | Tétouan |
++-------+------------------------------+
+|MA-TNG | Tanger-Assilah |
++-------+------------------------------+
+|MA-HOC | Al Hoceïma |
++-------+------------------------------+
+|MA-TAO | Taounate |
++-------+------------------------------+
+|MA-TAZ | Taza |
++-------+------------------------------+
* Netherlands
+------+------------------------------+
-|ISO | Name of region |
+|ISO | Name of region |
+======+==============================+
|NL-DR | Drenthe |
+------+------------------------------+
@@ -862,688 +862,688 @@ List of Countries
* Russian
-+------+------------------------------+
-|ISO | Name of region |
-+======+==============================+
-|RU-AD | Adygey |
-+------+------------------------------+
-|RU-ALT| Altay |
-+------+------------------------------+
-|RU-AMU| Amur |
-+------+------------------------------+
-|RU-ARK| Arkhangel'sk |
-+------+------------------------------+
-|RU-AST| Astrakhan' |
-+------+------------------------------+
-|RU-BA | Bashkortostan |
-+------+------------------------------+
-|RU-BEL| Belgorod |
-+------+------------------------------+
-|RU-BRY| Bryansk |
-+------+------------------------------+
-|RU-BU | Buryat |
-+------+------------------------------+
-|RU-CE | Chechnya |
-+------+------------------------------+
-|RU-CHE| Chelyabinsk |
-+------+------------------------------+
-|RU-CHU| Chukot |
-+------+------------------------------+
-|RU-CU | Chuvash |
-+------+------------------------------+
-|RU-SPE| City of St. Petersburg |
-+------+------------------------------+
-|RU-DA | Dagestan |
-+------+------------------------------+
-|RU-AL | Gorno-Altay |
-+------+------------------------------+
-|RU-IN | Ingush |
-+------+------------------------------+
-|RU-IRK| Irkutsk |
-+------+------------------------------+
-|RU-IVA| Ivanovo |
-+------+------------------------------+
-|RU-KB | Kabardin-Balkar |
-+------+------------------------------+
-|RU-KGD| Kaliningrad |
-+------+------------------------------+
-|RU-KL | Kalmyk |
-+------+------------------------------+
-|RU-KLU| Kaluga |
-+------+------------------------------+
-|RU-KAM| Kamchatka |
-+------+------------------------------+
-|RU-KC | Karachay-Cherkess |
-+------+------------------------------+
-|RU-KR | Karelia |
-+------+------------------------------+
-|RU-KEM| Kemerovo |
-+------+------------------------------+
-|RU-KHA| Khabarovsk |
-+------+------------------------------+
-|RU-KK | Khakass |
-+------+------------------------------+
-|RU-KHM| Khanty-Mansiy |
-+------+------------------------------+
-|RU-KIR| Kirov |
-+------+------------------------------+
-|RU-KO | Komi |
-+------+------------------------------+
-|RU-KOS| Kostroma |
-+------+------------------------------+
-|RU-KDA| Krasnodar |
-+------+------------------------------+
-|RU-KYA| Krasnoyarsk |
-+------+------------------------------+
-|RU-KGN| Kurgan |
-+------+------------------------------+
-|RU-KRS| Kursk |
-+------+------------------------------+
-|RU-LEN| Leningrad |
-+------+------------------------------+
-|RU-LIP| Lipetsk |
-+------+------------------------------+
-|RU-MAG| Maga Buryatdan |
-+------+------------------------------+
-|RU-ME | Mariy-El |
-+------+------------------------------+
-|RU-MO | Mordovia |
-+------+------------------------------+
-|RU-MOW| Moscow City |
-+------+------------------------------+
-|RU-MOS| Moskva |
-+------+------------------------------+
-|RU-MUR| Murmansk |
-+------+------------------------------+
-|RU-NEN| Nenets |
-+------+------------------------------+
-|RU-NIZ| Nizhegorod |
-+------+------------------------------+
-|RU-SE | North Ossetia |
-+------+------------------------------+
-|RU-NGR| Novgorod |
-+------+------------------------------+
-|RU-NVS| Novosibirsk |
-+------+------------------------------+
-|RU-OMS| Omsk |
-+------+------------------------------+
-|RU-ORL| Orel |
-+------+------------------------------+
-|RU-ORE| Orenburg |
-+------+------------------------------+
-|RU-PNZ| Penza |
-+------+------------------------------+
-|RU-PER| Perm' |
-+------+------------------------------+
-|RU-PRI| Primor'ye |
-+------+------------------------------+
-|RU-PSK| Pskov |
-+------+------------------------------+
-|RU-ROS| Rostov |
-+------+------------------------------+
-|RU-RYA| Ryazan' |
-+------+------------------------------+
-|RU-SAK| Sakhalin |
-+------+------------------------------+
-|RU-SA | Sakha |
-+------+------------------------------+
-|RU-SAM| Samara |
-+------+------------------------------+
-|RU-SAR| Saratov |
-+------+------------------------------+
-|RU-SMO| Smolensk |
-+------+------------------------------+
-|RU-STA| Stavropol' |
-+------+------------------------------+
-|RU-SVE| Sverdlovsk |
-+------+------------------------------+
-|RU-TAM| Tambov |
-+------+------------------------------+
-|RU-TA | Tatarstan |
-+------+------------------------------+
-|RU-TOM| Tomsk |
-+------+------------------------------+
-|RU-TUL| Tula |
-+------+------------------------------+
-|RU-TY | Tuva |
-+------+------------------------------+
-|RU-TVE| Tver' |
-+------+------------------------------+
-|RU-TYU| Tyumen' |
-+------+------------------------------+
-|RU-UD | Udmurt |
-+------+------------------------------+
-|RU-ULY| Ul'yanovsk |
-+------+------------------------------+
-|RU-VLA| Vladimir |
-+------+------------------------------+
-|RU-VGG| Volgograd |
-+------+------------------------------+
-|RU-VLG| Vologda |
-+------+------------------------------+
-|RU-VOR| Voronezh |
-+------+------------------------------+
-|RU-YAN| Yamal-Nenets |
-+------+------------------------------+
-|RU-YAR| Yaroslavl' |
-+------+------------------------------+
-|RU-YEV| Yevrey |
-+------+------------------------------+
-|RU-ZAB| Zabaykal'ye |
-+------+------------------------------+
++-------+------------------------------+
+|ISO | Name of region |
++=======+==============================+
+|RU-AD | Adygey |
++-------+------------------------------+
+|RU-ALT | Altay |
++-------+------------------------------+
+|RU-AMU | Amur |
++-------+------------------------------+
+|RU-ARK | Arkhangel'sk |
++-------+------------------------------+
+|RU-AST | Astrakhan' |
++-------+------------------------------+
+|RU-BA | Bashkortostan |
++-------+------------------------------+
+|RU-BEL | Belgorod |
++-------+------------------------------+
+|RU-BRY | Bryansk |
++-------+------------------------------+
+|RU-BU | Buryat |
++-------+------------------------------+
+|RU-CE | Chechnya |
++-------+------------------------------+
+|RU-CHE | Chelyabinsk |
++-------+------------------------------+
+|RU-CHU | Chukot |
++-------+------------------------------+
+|RU-CU | Chuvash |
++-------+------------------------------+
+|RU-SPE | City of St. Petersburg |
++-------+------------------------------+
+|RU-DA | Dagestan |
++-------+------------------------------+
+|RU-AL | Gorno-Altay |
++-------+------------------------------+
+|RU-IN | Ingush |
++-------+------------------------------+
+|RU-IRK | Irkutsk |
++-------+------------------------------+
+|RU-IVA | Ivanovo |
++-------+------------------------------+
+|RU-KB | Kabardin-Balkar |
++-------+------------------------------+
+|RU-KGD | Kaliningrad |
++-------+------------------------------+
+|RU-KL | Kalmyk |
++-------+------------------------------+
+|RU-KLU | Kaluga |
++-------+------------------------------+
+|RU-KAM | Kamchatka |
++-------+------------------------------+
+|RU-KC | Karachay-Cherkess |
++-------+------------------------------+
+|RU-KR | Karelia |
++-------+------------------------------+
+|RU-KEM | Kemerovo |
++-------+------------------------------+
+|RU-KHA | Khabarovsk |
++-------+------------------------------+
+|RU-KK | Khakass |
++-------+------------------------------+
+|RU-KHM | Khanty-Mansiy |
++-------+------------------------------+
+|RU-KIR | Kirov |
++-------+------------------------------+
+|RU-KO | Komi |
++-------+------------------------------+
+|RU-KOS | Kostroma |
++-------+------------------------------+
+|RU-KDA | Krasnodar |
++-------+------------------------------+
+|RU-KYA | Krasnoyarsk |
++-------+------------------------------+
+|RU-KGN | Kurgan |
++-------+------------------------------+
+|RU-KRS | Kursk |
++-------+------------------------------+
+|RU-LEN | Leningrad |
++-------+------------------------------+
+|RU-LIP | Lipetsk |
++-------+------------------------------+
+|RU-MAG | Maga Buryatdan |
++-------+------------------------------+
+|RU-ME | Mariy-El |
++-------+------------------------------+
+|RU-MO | Mordovia |
++-------+------------------------------+
+|RU-MOW | Moscow City |
++-------+------------------------------+
+|RU-MOS | Moskva |
++-------+------------------------------+
+|RU-MUR | Murmansk |
++-------+------------------------------+
+|RU-NEN | Nenets |
++-------+------------------------------+
+|RU-NIZ | Nizhegorod |
++-------+------------------------------+
+|RU-SE | North Ossetia |
++-------+------------------------------+
+|RU-NGR | Novgorod |
++-------+------------------------------+
+|RU-NVS | Novosibirsk |
++-------+------------------------------+
+|RU-OMS | Omsk |
++-------+------------------------------+
+|RU-ORL | Orel |
++-------+------------------------------+
+|RU-ORE | Orenburg |
++-------+------------------------------+
+|RU-PNZ | Penza |
++-------+------------------------------+
+|RU-PER | Perm' |
++-------+------------------------------+
+|RU-PRI | Primor'ye |
++-------+------------------------------+
+|RU-PSK | Pskov |
++-------+------------------------------+
+|RU-ROS | Rostov |
++-------+------------------------------+
+|RU-RYA | Ryazan' |
++-------+------------------------------+
+|RU-SAK | Sakhalin |
++-------+------------------------------+
+|RU-SA | Sakha |
++-------+------------------------------+
+|RU-SAM | Samara |
++-------+------------------------------+
+|RU-SAR | Saratov |
++-------+------------------------------+
+|RU-SMO | Smolensk |
++-------+------------------------------+
+|RU-STA | Stavropol' |
++-------+------------------------------+
+|RU-SVE | Sverdlovsk |
++-------+------------------------------+
+|RU-TAM | Tambov |
++-------+------------------------------+
+|RU-TA | Tatarstan |
++-------+------------------------------+
+|RU-TOM | Tomsk |
++-------+------------------------------+
+|RU-TUL | Tula |
++-------+------------------------------+
+|RU-TY | Tuva |
++-------+------------------------------+
+|RU-TVE | Tver' |
++-------+------------------------------+
+|RU-TYU | Tyumen' |
++-------+------------------------------+
+|RU-UD | Udmurt |
++-------+------------------------------+
+|RU-ULY | Ul'yanovsk |
++-------+------------------------------+
+|RU-VLA | Vladimir |
++-------+------------------------------+
+|RU-VGG | Volgograd |
++-------+------------------------------+
+|RU-VLG | Vologda |
++-------+------------------------------+
+|RU-VOR | Voronezh |
++-------+------------------------------+
+|RU-YAN | Yamal-Nenets |
++-------+------------------------------+
+|RU-YAR | Yaroslavl' |
++-------+------------------------------+
+|RU-YEV | Yevrey |
++-------+------------------------------+
+|RU-ZAB | Zabaykal'ye |
++-------+------------------------------+
* Singapore
+-----+------------------------------+
-| Id | Name of region |
+| Id | Name of region |
+=====+==============================+
| 205| Singapore |
+-----+------------------------------+
* Spain
-+------+-----------------------------+
-|ISO | Name of region |
-+======+=============================+
-|ES-AL | Almería |
-+------+-----------------------------+
-|ES-CA | Cádiz |
-+------+-----------------------------+
-|ES-CO | Córdoba |
-+------+-----------------------------+
-|ES-GR | Granada |
-+------+-----------------------------+
-|ES-H | Huelva |
-+------+-----------------------------+
-|ES-J | Jaén |
-+------+-----------------------------+
-|ES-MA | Málaga |
-+------+-----------------------------+
-|ES-SE | Sevilla |
-+------+-----------------------------+
-|ES-HU | Huesca |
-+------+-----------------------------+
-|ES-TE | Teruel |
-+------+-----------------------------+
-|ES-Z | Zaragoza |
-+------+-----------------------------+
-|ES-S3 | Cantabria |
-+------+-----------------------------+
-|ES-AB | Albacete |
-+------+-----------------------------+
-|ES-CR | Ciudad Real |
-+------+-----------------------------+
-|ES-CU | Cuenca |
-+------+-----------------------------+
-|ES-GU | Guadalajara |
-+------+-----------------------------+
-|ES-TO | Toledo |
-+------+-----------------------------+
-|ES-AV | Ávila |
-+------+-----------------------------+
-|ES-BU | Burgos |
-+------+-----------------------------+
-|ES-LE | León |
-+------+-----------------------------+
-|ES-P | Palencia |
-+------+-----------------------------+
-|ES-SA | Salamanca |
-+------+-----------------------------+
-|ES-SG | Segovia |
-+------+-----------------------------+
-|ES-SO | Soria |
-+------+-----------------------------+
-|ES-VA | Valladolid |
-+------+-----------------------------+
-|ES-ZA | Zamora |
-+------+-----------------------------+
-|ES-B | Barcelona |
-+------+-----------------------------+
-|ES-GI | Girona |
-+------+-----------------------------+
-|ES-L | Lleida |
-+------+-----------------------------+
-|ES-T | Tarragona |
-+------+-----------------------------+
-|ES-CE | Ceuta |
-+------+-----------------------------+
-|ES-ML | Melilla |
-+------+-----------------------------+
-|ES-M5 | Madrid |
-+------+-----------------------------+
-|ES-NA7| Navarra |
-+------+-----------------------------+
-|ES-A | Alicante |
-+------+-----------------------------+
-|ES-CS | Castellón |
-+------+-----------------------------+
-|ES-V | Valencia |
-+------+-----------------------------+
-|ES-BA | Badajoz |
-+------+-----------------------------+
-|ES-CC | Cáceres |
-+------+-----------------------------+
-|ES-C | A Coruña |
-+------+-----------------------------+
-|ES-LU | Lugo |
-+------+-----------------------------+
-|ES-OR | Ourense |
-+------+-----------------------------+
-|ES-PO | Pontevedra |
-+------+-----------------------------+
-|ES-PM | Baleares |
-+------+-----------------------------+
-|ES-GC | Las Palmas |
-+------+-----------------------------+
-|ES-TF | Santa Cruz de Tenerife |
-+------+-----------------------------+
-|ES-LO4| La Rioja |
-+------+-----------------------------+
-|ES-VI | Álava |
-+------+-----------------------------+
-|ES-SS | Guipúzcoa |
-+------+-----------------------------+
-|ES-BI | Vizcaya |
-+------+-----------------------------+
-|ES-O2 | Asturias |
-+------+-----------------------------+
-|ES-MU6| Murcia |
-+------+-----------------------------+
++-------+-----------------------------+
+|ISO | Name of region |
++=======+=============================+
+|ES-AL | Almería |
++-------+-----------------------------+
+|ES-CA | Cádiz |
++-------+-----------------------------+
+|ES-CO | Córdoba |
++-------+-----------------------------+
+|ES-GR | Granada |
++-------+-----------------------------+
+|ES-H | Huelva |
++-------+-----------------------------+
+|ES-J | Jaén |
++-------+-----------------------------+
+|ES-MA | Málaga |
++-------+-----------------------------+
+|ES-SE | Sevilla |
++-------+-----------------------------+
+|ES-HU | Huesca |
++-------+-----------------------------+
+|ES-TE | Teruel |
++-------+-----------------------------+
+|ES-Z | Zaragoza |
++-------+-----------------------------+
+|ES-S3 | Cantabria |
++-------+-----------------------------+
+|ES-AB | Albacete |
++-------+-----------------------------+
+|ES-CR | Ciudad Real |
++-------+-----------------------------+
+|ES-CU | Cuenca |
++-------+-----------------------------+
+|ES-GU | Guadalajara |
++-------+-----------------------------+
+|ES-TO | Toledo |
++-------+-----------------------------+
+|ES-AV | Ávila |
++-------+-----------------------------+
+|ES-BU | Burgos |
++-------+-----------------------------+
+|ES-LE | León |
++-------+-----------------------------+
+|ES-P | Palencia |
++-------+-----------------------------+
+|ES-SA | Salamanca |
++-------+-----------------------------+
+|ES-SG | Segovia |
++-------+-----------------------------+
+|ES-SO | Soria |
++-------+-----------------------------+
+|ES-VA | Valladolid |
++-------+-----------------------------+
+|ES-ZA | Zamora |
++-------+-----------------------------+
+|ES-B | Barcelona |
++-------+-----------------------------+
+|ES-GI | Girona |
++-------+-----------------------------+
+|ES-L | Lleida |
++-------+-----------------------------+
+|ES-T | Tarragona |
++-------+-----------------------------+
+|ES-CE | Ceuta |
++-------+-----------------------------+
+|ES-ML | Melilla |
++-------+-----------------------------+
+|ES-M5 | Madrid |
++-------+-----------------------------+
+|ES-NA7 | Navarra |
++-------+-----------------------------+
+|ES-A | Alicante |
++-------+-----------------------------+
+|ES-CS | Castellón |
++-------+-----------------------------+
+|ES-V | Valencia |
++-------+-----------------------------+
+|ES-BA | Badajoz |
++-------+-----------------------------+
+|ES-CC | Cáceres |
++-------+-----------------------------+
+|ES-C | A Coruña |
++-------+-----------------------------+
+|ES-LU | Lugo |
++-------+-----------------------------+
+|ES-OR | Ourense |
++-------+-----------------------------+
+|ES-PO | Pontevedra |
++-------+-----------------------------+
+|ES-PM | Baleares |
++-------+-----------------------------+
+|ES-GC | Las Palmas |
++-------+-----------------------------+
+|ES-TF | Santa Cruz de Tenerife |
++-------+-----------------------------+
+|ES-LO4 | La Rioja |
++-------+-----------------------------+
+|ES-VI | Álava |
++-------+-----------------------------+
+|ES-SS | Guipúzcoa |
++-------+-----------------------------+
+|ES-BI | Vizcaya |
++-------+-----------------------------+
+|ES-O2 | Asturias |
++-------+-----------------------------+
+|ES-MU6 | Murcia |
++-------+-----------------------------+
* Uk
-+------+------------------------------+
-|ISO | Name of region |
-+======+==============================+
-|GB-BDG| Barking and Dagenham |
-+------+------------------------------+
-|GB-BAS| Bath and North East Somerset |
-+------+------------------------------+
-|GB-BDF| Bedfordshire |
-+------+------------------------------+
-|GB-WBK| Berkshire |
-+------+------------------------------+
-|GB-BEX| Bexley |
-+------+------------------------------+
-|GB-BBD| Blackburn with Darwen |
-+------+------------------------------+
-|GB-BMH| Bournemouth |
-+------+------------------------------+
-|GB-BEN| Brent |
-+------+------------------------------+
-|GB-BNH| Brighton and Hove |
-+------+------------------------------+
-|GB-BST| Bristol |
-+------+------------------------------+
-|GB-BRY| Bromley |
-+------+------------------------------+
-|GB-BKM| Buckinghamshire |
-+------+------------------------------+
-|GB-CAM| Cambridgeshire |
-+------+------------------------------+
-|GB-CMD| Camden |
-+------+------------------------------+
-|GB-CHS| Cheshire |
-+------+------------------------------+
-|GB-CON| Cornwall |
-+------+------------------------------+
-|GB-CRY| Croydon |
-+------+------------------------------+
-|GB-CMA| Cumbria |
-+------+------------------------------+
-|GB-DAL| Darlington |
-+------+------------------------------+
-|GB-DBY| Derbyshire |
-+------+------------------------------+
-|GB-DER| Derby |
-+------+------------------------------+
-|GB-DEV| Devon |
-+------+------------------------------+
-|GB-DOR| Dorset |
-+------+------------------------------+
-|GB-DUR| Durham |
-+------+------------------------------+
-|GB-EAL| Ealing |
-+------+------------------------------+
-|GB-ERY| East Riding of Yorkshire |
-+------+------------------------------+
-|GB-ESX| East Sussex |
-+------+------------------------------+
-|GB-ENF| Enfield |
-+------+------------------------------+
-|GB-ESS| Essex |
-+------+------------------------------+
-|GB-GLS| Gloucestershire |
-+------+------------------------------+
-|GB-GRE| Greenwich |
-+------+------------------------------+
-|GB-HCK| Hackney |
-+------+------------------------------+
-|GB-HAL| Halton |
-+------+------------------------------+
-|GB-HMF| Hammersmith and Fulham |
-+------+------------------------------+
-|GB-HAM| Hampshire |
-+------+------------------------------+
-|GB-HRY| Haringey |
-+------+------------------------------+
-|GB-HRW| Harrow |
-+------+------------------------------+
-|GB-HPL| Hartlepool |
-+------+------------------------------+
-|GB-HAV| Havering |
-+------+------------------------------+
-|GB-HRT| Herefordshire |
-+------+------------------------------+
-|GB-HEF| Hertfordshire |
-+------+------------------------------+
-|GB-HIL| Hillingdon |
-+------+------------------------------+
-|GB-HNS| Hounslow |
-+------+------------------------------+
-|GB-IOW| Isle of Wight |
-+------+------------------------------+
-|GB-ISL| Islington |
-+------+------------------------------+
-|GB-KEC| Kensington and Chelsea |
-+------+------------------------------+
-|GB-KEN| Kent |
-+------+------------------------------+
-|GB-KHL| Kingston upon Hull |
-+------+------------------------------+
-|GB-KTT| Kingston upon Thames |
-+------+------------------------------+
-|GB-LBH| Lambeth |
-+------+------------------------------+
-|GB-LAN| Lancashire |
-+------+------------------------------+
-|GB-LEC| Leicestershire |
-+------+------------------------------+
-|GB-LCE| Leicester |
-+------+------------------------------+
-|GB-LEW| Lewisham |
-+------+------------------------------+
-|GB-LIN| Lincolnshire |
-+------+------------------------------+
-|GB-LND| London |
-+------+------------------------------+
-|GB-LUT| Luton |
-+------+------------------------------+
-|GB-MAN| Manchester |
-+------+------------------------------+
-|GB-MDW| Medway |
-+------+------------------------------+
-|GB-MER| Merseyside |
-+------+------------------------------+
-|GB-MRT| Merton |
-+------+------------------------------+
-|GB-MDB| Middlesbrough |
-+------+------------------------------+
-|GB-MIK| Milton Keynes |
-+------+------------------------------+
-|GB-NWM| Newham |
-+------+------------------------------+
-|GB-NFK| Norfolk |
-+------+------------------------------+
-|GB-NEL| North East Lincolnshire |
-+------+------------------------------+
-|GB-NLN| North Lincolnshire |
-+------+------------------------------+
-|GB-NSM| North Somerset |
-+------+------------------------------+
-|GB-NYK| North Yorkshire |
-+------+------------------------------+
-|GB-NTH| Northamptonshire |
-+------+------------------------------+
-|GB-NBL| Northumberland |
-+------+------------------------------+
-|GB-NTT| Nottinghamshire |
-+------+------------------------------+
-|GB-NGM| Nottingham |
-+------+------------------------------+
-|GB-OXF| Oxfordshire |
-+------+------------------------------+
-|GB-PTE| Peterborough |
-+------+------------------------------+
-|GB-PLY| Plymouth |
-+------+------------------------------+
-|GB-POL| Poole |
-+------+------------------------------+
-|GB-POR| Portsmouth |
-+------+------------------------------+
-|GB-RDB| Redbridge |
-+------+------------------------------+
-|GB-RCC| Redcar and Cleveland |
-+------+------------------------------+
-|GB-RIC| Richmond upon Thames |
-+------+------------------------------+
-|GB-RUT| Rutland |
-+------+------------------------------+
-|GB-SHR| Shropshire |
-+------+------------------------------+
-|GB-SOM| Somerset |
-+------+------------------------------+
-|GB-SGC| South Gloucestershire |
-+------+------------------------------+
-|GB-SY | South Yorkshire |
-+------+------------------------------+
-|GB-STH| Southampton |
-+------+------------------------------+
-|GB-SOS| Southend-on-Sea |
-+------+------------------------------+
-|GB-SWK| Southwark |
-+------+------------------------------+
-|GB-STS| Staffordshire |
-+------+------------------------------+
-|GB-STT| Stockton-on-Tees |
-+------+------------------------------+
-|GB-STE| Stoke-on-Trent |
-+------+------------------------------+
-|GB-SFK| Suffolk |
-+------+------------------------------+
-|GB-SRY| Surrey |
-+------+------------------------------+
-|GB-STN| Sutton |
-+------+------------------------------+
-|GB-SWD| Swindon |
-+------+------------------------------+
-|GB-TFW| Telford and Wrekin |
-+------+------------------------------+
-|GB-THR| Thurrock |
-+------+------------------------------+
-|GB-TOB| Torbay |
-+------+------------------------------+
-|GB-TWH| Tower Hamlets |
-+------+------------------------------+
-|GB-TAW| Tyne and Wear |
-+------+------------------------------+
-|GB-WFT| Waltham Forest |
-+------+------------------------------+
-|GB-WND| Wandsworth |
-+------+------------------------------+
-|GB-WRT| Warrington |
-+------+------------------------------+
-|GB-WAR| Warwickshire |
-+------+------------------------------+
-|GB-WM | West Midlands |
-+------+------------------------------+
-|GB-WSX| West Sussex |
-+------+------------------------------+
-|GB-WY | West Yorkshire |
-+------+------------------------------+
-|GB-WSM| Westminster |
-+------+------------------------------+
-|GB-WIL| Wiltshire |
-+------+------------------------------+
-|GB-WOR| Worcestershire |
-+------+------------------------------+
-|GB-YOR| York |
-+------+------------------------------+
-|GB-ANT| Antrim |
-+------+------------------------------+
-|GB-ARD| Ards |
-+------+------------------------------+
-|GB-ARM| Armagh |
-+------+------------------------------+
-|GB-BLA| Ballymena |
-+------+------------------------------+
-|GB-BLY| Ballymoney |
-+------+------------------------------+
-|GB-BNB| Banbridge |
-+------+------------------------------+
-|GB-BFS| Belfast |
-+------+------------------------------+
-|GB-CKF| Carrickfergus |
-+------+------------------------------+
-|GB-CSR| Castlereagh |
-+------+------------------------------+
-|GB-CLR| Coleraine |
-+------+------------------------------+
-|GB-CKT| Cookstown |
-+------+------------------------------+
-|GB-CGV| Craigavon |
-+------+------------------------------+
-|GB-DRY| Derry |
-+------+------------------------------+
-|GB-DOW| Down |
-+------+------------------------------+
-|GB-DGN| Dungannon |
-+------+------------------------------+
-|GB-FER| Fermanagh |
-+------+------------------------------+
-|GB-LRN| Larne |
-+------+------------------------------+
-|GB-LMV| Limavady |
-+------+------------------------------+
-|GB-LSB| Lisburn |
-+------+------------------------------+
-|GB-MFT| Magherafelt |
-+------+------------------------------+
-|GB-MYL| Moyle |
-+------+------------------------------+
-|GB-NYM| Newry and Mourne |
-+------+------------------------------+
-|GB-NTA| Newtownabbey |
-+------+------------------------------+
-|GB-NDN| North Down |
-+------+------------------------------+
-|GB-OMH| Omagh |
-+------+------------------------------+
-|GB-STB| Strabane |
-+------+------------------------------+
-|GB-ABD| Aberdeenshire |
-+------+------------------------------+
-|GB-ABE| Aberdeen |
-+------+------------------------------+
-|GB-ANS| Angus |
-+------+------------------------------+
-|GB-AGB| Argyll and Bute |
-+------+------------------------------+
-|GB-CLK| Clackmannanshire |
-+------+------------------------------+
-|GB-DGY| Dumfries and Galloway |
-+------+------------------------------+
-|GB-DND| Dundee |
-+------+------------------------------+
-|GB-EAY| East Ayrshire |
-+------+------------------------------+
-|GB-EDU| East Dunbartonshire |
-+------+------------------------------+
-|GB-ELN| East Lothian |
-+------+------------------------------+
-|GB-ERW| East Renfrewshire |
-+------+------------------------------+
-|GB-EDH| Edinburgh |
-+------+------------------------------+
-|GB-ELS| Eilean Siar |
-+------+------------------------------+
-|GB-FAL| Falkirk |
-+------+------------------------------+
-|GB-FIF| Fife |
-+------+------------------------------+
-|GB-GLG| Glasgow |
-+------+------------------------------+
-|GB-HLD| Highland |
-+------+------------------------------+
-|GB-IVC| Inverclyde |
-+------+------------------------------+
-|GB-MLN| Midlothian |
-+------+------------------------------+
-|GB-MRY| Moray |
-+------+------------------------------+
-|GB-NAY| North Ayshire |
-+------+------------------------------+
-|GB-NLK| North Lanarkshire |
-+------+------------------------------+
-|GB-ORK| Orkney Islands |
-+------+------------------------------+
-|GB-PKN| Perthshire and Kinross |
-+------+------------------------------+
-|GB-RFW| Renfrewshire |
-+------+------------------------------+
-|GB-SCB| Scottish Borders |
-+------+------------------------------+
-|GB-ZET| Shetland Islands |
-+------+------------------------------+
-|GB-SAY| South Ayrshire |
-+------+------------------------------+
-|GB-SLK| South Lanarkshire |
-+------+------------------------------+
-|GB-STG| Stirling |
-+------+------------------------------+
-|GB-WDU| West Dunbartonshire |
-+------+------------------------------+
-|GB-WLN| West Lothian |
-+------+------------------------------+
-|GB-AGY| Anglesey |
-+------+------------------------------+
-|GB-BGW| Blaenau Gwent |
-+------+------------------------------+
-|GB-BGE| Bridgend |
-+------+------------------------------+
-|GB-CAY| Caerphilly |
-+------+------------------------------+
-|GB-CRF| Cardiff |
-+------+------------------------------+
-|GB-CMN| Carmarthenshire |
-+------+------------------------------+
-|GB-CGN| Ceredigion |
-+------+------------------------------+
-|GB-CWY| Conwy |
-+------+------------------------------+
-|GB-DEN| Denbighshire |
-+------+------------------------------+
-|GB-FLN| Flintshire |
-+------+------------------------------+
-|GB-GWN| Gwynedd |
-+------+------------------------------+
-|GB-MTY| Merthyr Tydfil |
-+------+------------------------------+
-|GB-MON| Monmouthshire |
-+------+------------------------------+
-|GB-NTL| Neath Port Talbot |
-+------+------------------------------+
-|GB-NWP| Newport |
-+------+------------------------------+
-|GB-PEM| Pembrokeshire |
-+------+------------------------------+
-|GB-POW| Powys |
-+------+------------------------------+
-|GB-RCT| Rhondda|
-+------+------------------------------+
-|GB-SWA| Swansea |
-+------+------------------------------+
-|GB-TOF| Torfaen |
-+------+------------------------------+
-|GB-VGL| Vale of Glamorgan |
-+------+------------------------------+
-|GB-WRX| Wrexham |
-+------+------------------------------+
++-------+------------------------------+
+|ISO | Name of region |
++=======+==============================+
+|GB-BDG | Barking and Dagenham |
++-------+------------------------------+
+|GB-BAS | Bath and North East Somerset |
++-------+------------------------------+
+|GB-BDF | Bedfordshire |
++-------+------------------------------+
+|GB-WBK | Berkshire |
++-------+------------------------------+
+|GB-BEX | Bexley |
++-------+------------------------------+
+|GB-BBD | Blackburn with Darwen |
++-------+------------------------------+
+|GB-BMH | Bournemouth |
++-------+------------------------------+
+|GB-BEN | Brent |
++-------+------------------------------+
+|GB-BNH | Brighton and Hove |
++-------+------------------------------+
+|GB-BST | Bristol |
++-------+------------------------------+
+|GB-BRY | Bromley |
++-------+------------------------------+
+|GB-BKM | Buckinghamshire |
++-------+------------------------------+
+|GB-CAM | Cambridgeshire |
++-------+------------------------------+
+|GB-CMD | Camden |
++-------+------------------------------+
+|GB-CHS | Cheshire |
++-------+------------------------------+
+|GB-CON | Cornwall |
++-------+------------------------------+
+|GB-CRY | Croydon |
++-------+------------------------------+
+|GB-CMA | Cumbria |
++-------+------------------------------+
+|GB-DAL | Darlington |
++-------+------------------------------+
+|GB-DBY | Derbyshire |
++-------+------------------------------+
+|GB-DER | Derby |
++-------+------------------------------+
+|GB-DEV | Devon |
++-------+------------------------------+
+|GB-DOR | Dorset |
++-------+------------------------------+
+|GB-DUR | Durham |
++-------+------------------------------+
+|GB-EAL | Ealing |
++-------+------------------------------+
+|GB-ERY | East Riding of Yorkshire |
++-------+------------------------------+
+|GB-ESX | East Sussex |
++-------+------------------------------+
+|GB-ENF | Enfield |
++-------+------------------------------+
+|GB-ESS | Essex |
++-------+------------------------------+
+|GB-GLS | Gloucestershire |
++-------+------------------------------+
+|GB-GRE | Greenwich |
++-------+------------------------------+
+|GB-HCK | Hackney |
++-------+------------------------------+
+|GB-HAL | Halton |
++-------+------------------------------+
+|GB-HMF | Hammersmith and Fulham |
++-------+------------------------------+
+|GB-HAM | Hampshire |
++-------+------------------------------+
+|GB-HRY | Haringey |
++-------+------------------------------+
+|GB-HRW | Harrow |
++-------+------------------------------+
+|GB-HPL | Hartlepool |
++-------+------------------------------+
+|GB-HAV | Havering |
++-------+------------------------------+
+|GB-HRT | Herefordshire |
++-------+------------------------------+
+|GB-HEF | Hertfordshire |
++-------+------------------------------+
+|GB-HIL | Hillingdon |
++-------+------------------------------+
+|GB-HNS | Hounslow |
++-------+------------------------------+
+|GB-IOW | Isle of Wight |
++-------+------------------------------+
+|GB-ISL | Islington |
++-------+------------------------------+
+|GB-KEC | Kensington and Chelsea |
++-------+------------------------------+
+|GB-KEN | Kent |
++-------+------------------------------+
+|GB-KHL | Kingston upon Hull |
++-------+------------------------------+
+|GB-KTT | Kingston upon Thames |
++-------+------------------------------+
+|GB-LBH | Lambeth |
++-------+------------------------------+
+|GB-LAN | Lancashire |
++-------+------------------------------+
+|GB-LEC | Leicestershire |
++-------+------------------------------+
+|GB-LCE | Leicester |
++-------+------------------------------+
+|GB-LEW | Lewisham |
++-------+------------------------------+
+|GB-LIN | Lincolnshire |
++-------+------------------------------+
+|GB-LND | London |
++-------+------------------------------+
+|GB-LUT | Luton |
++-------+------------------------------+
+|GB-MAN | Manchester |
++-------+------------------------------+
+|GB-MDW | Medway |
++-------+------------------------------+
+|GB-MER | Merseyside |
++-------+------------------------------+
+|GB-MRT | Merton |
++-------+------------------------------+
+|GB-MDB | Middlesbrough |
++-------+------------------------------+
+|GB-MIK | Milton Keynes |
++-------+------------------------------+
+|GB-NWM | Newham |
++-------+------------------------------+
+|GB-NFK | Norfolk |
++-------+------------------------------+
+|GB-NEL | North East Lincolnshire |
++-------+------------------------------+
+|GB-NLN | North Lincolnshire |
++-------+------------------------------+
+|GB-NSM | North Somerset |
++-------+------------------------------+
+|GB-NYK | North Yorkshire |
++-------+------------------------------+
+|GB-NTH | Northamptonshire |
++-------+------------------------------+
+|GB-NBL | Northumberland |
++-------+------------------------------+
+|GB-NTT | Nottinghamshire |
++-------+------------------------------+
+|GB-NGM | Nottingham |
++-------+------------------------------+
+|GB-OXF | Oxfordshire |
++-------+------------------------------+
+|GB-PTE | Peterborough |
++-------+------------------------------+
+|GB-PLY | Plymouth |
++-------+------------------------------+
+|GB-POL | Poole |
++-------+------------------------------+
+|GB-POR | Portsmouth |
++-------+------------------------------+
+|GB-RDB | Redbridge |
++-------+------------------------------+
+|GB-RCC | Redcar and Cleveland |
++-------+------------------------------+
+|GB-RIC | Richmond upon Thames |
++-------+------------------------------+
+|GB-RUT | Rutland |
++-------+------------------------------+
+|GB-SHR | Shropshire |
++-------+------------------------------+
+|GB-SOM | Somerset |
++-------+------------------------------+
+|GB-SGC | South Gloucestershire |
++-------+------------------------------+
+|GB-SY | South Yorkshire |
++-------+------------------------------+
+|GB-STH | Southampton |
++-------+------------------------------+
+|GB-SOS | Southend-on-Sea |
++-------+------------------------------+
+|GB-SWK | Southwark |
++-------+------------------------------+
+|GB-STS | Staffordshire |
++-------+------------------------------+
+|GB-STT | Stockton-on-Tees |
++-------+------------------------------+
+|GB-STE | Stoke-on-Trent |
++-------+------------------------------+
+|GB-SFK | Suffolk |
++-------+------------------------------+
+|GB-SRY | Surrey |
++-------+------------------------------+
+|GB-STN | Sutton |
++-------+------------------------------+
+|GB-SWD | Swindon |
++-------+------------------------------+
+|GB-TFW | Telford and Wrekin |
++-------+------------------------------+
+|GB-THR | Thurrock |
++-------+------------------------------+
+|GB-TOB | Torbay |
++-------+------------------------------+
+|GB-TWH | Tower Hamlets |
++-------+------------------------------+
+|GB-TAW | Tyne and Wear |
++-------+------------------------------+
+|GB-WFT | Waltham Forest |
++-------+------------------------------+
+|GB-WND | Wandsworth |
++-------+------------------------------+
+|GB-WRT | Warrington |
++-------+------------------------------+
+|GB-WAR | Warwickshire |
++-------+------------------------------+
+|GB-WM | West Midlands |
++-------+------------------------------+
+|GB-WSX | West Sussex |
++-------+------------------------------+
+|GB-WY | West Yorkshire |
++-------+------------------------------+
+|GB-WSM | Westminster |
++-------+------------------------------+
+|GB-WIL | Wiltshire |
++-------+------------------------------+
+|GB-WOR | Worcestershire |
++-------+------------------------------+
+|GB-YOR | York |
++-------+------------------------------+
+|GB-ANT | Antrim |
++-------+------------------------------+
+|GB-ARD | Ards |
++-------+------------------------------+
+|GB-ARM | Armagh |
++-------+------------------------------+
+|GB-BLA | Ballymena |
++-------+------------------------------+
+|GB-BLY | Ballymoney |
++-------+------------------------------+
+|GB-BNB | Banbridge |
++-------+------------------------------+
+|GB-BFS | Belfast |
++-------+------------------------------+
+|GB-CKF | Carrickfergus |
++-------+------------------------------+
+|GB-CSR | Castlereagh |
++-------+------------------------------+
+|GB-CLR | Coleraine |
++-------+------------------------------+
+|GB-CKT | Cookstown |
++-------+------------------------------+
+|GB-CGV | Craigavon |
++-------+------------------------------+
+|GB-DRY | Derry |
++-------+------------------------------+
+|GB-DOW | Down |
++-------+------------------------------+
+|GB-DGN | Dungannon |
++-------+------------------------------+
+|GB-FER | Fermanagh |
++-------+------------------------------+
+|GB-LRN | Larne |
++-------+------------------------------+
+|GB-LMV | Limavady |
++-------+------------------------------+
+|GB-LSB | Lisburn |
++-------+------------------------------+
+|GB-MFT | Magherafelt |
++-------+------------------------------+
+|GB-MYL | Moyle |
++-------+------------------------------+
+|GB-NYM | Newry and Mourne |
++-------+------------------------------+
+|GB-NTA | Newtownabbey |
++-------+------------------------------+
+|GB-NDN | North Down |
++-------+------------------------------+
+|GB-OMH | Omagh |
++-------+------------------------------+
+|GB-STB | Strabane |
++-------+------------------------------+
+|GB-ABD | Aberdeenshire |
++-------+------------------------------+
+|GB-ABE | Aberdeen |
++-------+------------------------------+
+|GB-ANS | Angus |
++-------+------------------------------+
+|GB-AGB | Argyll and Bute |
++-------+------------------------------+
+|GB-CLK | Clackmannanshire |
++-------+------------------------------+
+|GB-DGY | Dumfries and Galloway |
++-------+------------------------------+
+|GB-DND | Dundee |
++-------+------------------------------+
+|GB-EAY | East Ayrshire |
++-------+------------------------------+
+|GB-EDU | East Dunbartonshire |
++-------+------------------------------+
+|GB-ELN | East Lothian |
++-------+------------------------------+
+|GB-ERW | East Renfrewshire |
++-------+------------------------------+
+|GB-EDH | Edinburgh |
++-------+------------------------------+
+|GB-ELS | Eilean Siar |
++-------+------------------------------+
+|GB-FAL | Falkirk |
++-------+------------------------------+
+|GB-FIF | Fife |
++-------+------------------------------+
+|GB-GLG | Glasgow |
++-------+------------------------------+
+|GB-HLD | Highland |
++-------+------------------------------+
+|GB-IVC | Inverclyde |
++-------+------------------------------+
+|GB-MLN | Midlothian |
++-------+------------------------------+
+|GB-MRY | Moray |
++-------+------------------------------+
+|GB-NAY | North Ayshire |
++-------+------------------------------+
+|GB-NLK | North Lanarkshire |
++-------+------------------------------+
+|GB-ORK | Orkney Islands |
++-------+------------------------------+
+|GB-PKN | Perthshire and Kinross |
++-------+------------------------------+
+|GB-RFW | Renfrewshire |
++-------+------------------------------+
+|GB-SCB | Scottish Borders |
++-------+------------------------------+
+|GB-ZET | Shetland Islands |
++-------+------------------------------+
+|GB-SAY | South Ayrshire |
++-------+------------------------------+
+|GB-SLK | South Lanarkshire |
++-------+------------------------------+
+|GB-STG | Stirling |
++-------+------------------------------+
+|GB-WDU | West Dunbartonshire |
++-------+------------------------------+
+|GB-WLN | West Lothian |
++-------+------------------------------+
+|GB-AGY | Anglesey |
++-------+------------------------------+
+|GB-BGW | Blaenau Gwent |
++-------+------------------------------+
+|GB-BGE | Bridgend |
++-------+------------------------------+
+|GB-CAY | Caerphilly |
++-------+------------------------------+
+|GB-CRF | Cardiff |
++-------+------------------------------+
+|GB-CMN | Carmarthenshire |
++-------+------------------------------+
+|GB-CGN | Ceredigion |
++-------+------------------------------+
+|GB-CWY | Conwy |
++-------+------------------------------+
+|GB-DEN | Denbighshire |
++-------+------------------------------+
+|GB-FLN | Flintshire |
++-------+------------------------------+
+|GB-GWN | Gwynedd |
++-------+------------------------------+
+|GB-MTY | Merthyr Tydfil |
++-------+------------------------------+
+|GB-MON | Monmouthshire |
++-------+------------------------------+
+|GB-NTL | Neath Port Talbot |
++-------+------------------------------+
+|GB-NWP | Newport |
++-------+------------------------------+
+|GB-PEM | Pembrokeshire |
++-------+------------------------------+
+|GB-POW | Powys |
++-------+------------------------------+
+|GB-RCT | Rhondda|
++-------+------------------------------+
+|GB-SWA | Swansea |
++-------+------------------------------+
+|GB-TOF | Torfaen |
++-------+------------------------------+
+|GB-VGL | Vale of Glamorgan |
++-------+------------------------------+
+|GB-WRX | Wrexham |
++-------+------------------------------+
* Ukraine
+------+------------------------------+
-|ISO | Name of region |
+|ISO | Name of region |
+======+==============================+
|UA-71 | Cherkasy |
+------+------------------------------+
@@ -1604,7 +1604,7 @@ List of Countries
* Usa
+------+------------------------------+
-|ISO | Name of region |
+|ISO | Name of region |
+======+==============================+
|US-AL | Alabama |
+------+------------------------------+
@@ -1735,7 +1735,7 @@ To add a new country in country map tools, we need follow next steps :
7. Add your country in component 'select_country'
Example :
-.. code:: python
+.. code-block:: javascript
select_country: {
type: 'SelectControl',
diff --git a/_static/img/favicon.png b/_static/img/favicon.png
index 804a1c9..55316fa 100644
Binary files a/_static/img/favicon.png and b/_static/img/favicon.png differ
diff --git a/_static/img/screenshots/bank_dash.png b/_static/img/screenshots/bank_dash.png
new file mode 100644
index 0000000..c0544b0
Binary files /dev/null and b/_static/img/screenshots/bank_dash.png differ
diff --git a/_static/img/screenshots/deckgl_dash.png b/_static/img/screenshots/deckgl_dash.png
new file mode 100644
index 0000000..6ba049c
Binary files /dev/null and b/_static/img/screenshots/deckgl_dash.png differ
diff --git a/_static/img/screenshots/explore.png b/_static/img/screenshots/explore.png
new file mode 100644
index 0000000..c462a6b
Binary files /dev/null and b/_static/img/screenshots/explore.png differ
diff --git a/_static/img/screenshots/sqllab.png b/_static/img/screenshots/sqllab.png
new file mode 100644
index 0000000..6d35a9b
Binary files /dev/null and b/_static/img/screenshots/sqllab.png differ
diff --git a/_static/img/tutorial/tutorial_02_add_database.png b/_static/img/tutorial/tutorial_02_add_database.png
index 0ee12d3..7eb671a 100644
Binary files a/_static/img/tutorial/tutorial_02_add_database.png and b/_static/img/tutorial/tutorial_02_add_database.png differ
diff --git a/_static/img/viz_thumbnails/area.png b/_static/img/viz_thumbnails/area.png
index 86f1080..6b2fb75 100644
Binary files a/_static/img/viz_thumbnails/area.png and b/_static/img/viz_thumbnails/area.png differ
diff --git a/_static/img/viz_thumbnails/bar.png b/_static/img/viz_thumbnails/bar.png
index ab0e8d9..1ef2633 100644
Binary files a/_static/img/viz_thumbnails/bar.png and b/_static/img/viz_thumbnails/bar.png differ
diff --git a/_static/img/viz_thumbnails/big_number.png b/_static/img/viz_thumbnails/big_number.png
index 2420f25..01d6da4 100644
Binary files a/_static/img/viz_thumbnails/big_number.png and b/_static/img/viz_thumbnails/big_number.png differ
diff --git a/_static/img/viz_thumbnails/big_number_total.png b/_static/img/viz_thumbnails/big_number_total.png
index eb4b345..350d5a1 100644
Binary files a/_static/img/viz_thumbnails/big_number_total.png and b/_static/img/viz_thumbnails/big_number_total.png differ
diff --git a/_static/img/viz_thumbnails/box_plot.png b/_static/img/viz_thumbnails/box_plot.png
index de8f061..8925e50 100644
Binary files a/_static/img/viz_thumbnails/box_plot.png and b/_static/img/viz_thumbnails/box_plot.png differ
diff --git a/_static/img/viz_thumbnails/bubble.png b/_static/img/viz_thumbnails/bubble.png
index 08de51f..4533881 100644
Binary files a/_static/img/viz_thumbnails/bubble.png and b/_static/img/viz_thumbnails/bubble.png differ
diff --git a/_static/img/viz_thumbnails/bullet.png b/_static/img/viz_thumbnails/bullet.png
index 7a66a41..f98c70f 100644
Binary files a/_static/img/viz_thumbnails/bullet.png and b/_static/img/viz_thumbnails/bullet.png differ
diff --git a/_static/img/viz_thumbnails/cal_heatmap.png b/_static/img/viz_thumbnails/cal_heatmap.png
index bf79a9e..c83db08 100644
Binary files a/_static/img/viz_thumbnails/cal_heatmap.png and b/_static/img/viz_thumbnails/cal_heatmap.png differ
diff --git a/_static/img/viz_thumbnails/chord.png b/_static/img/viz_thumbnails/chord.png
index a4a30b6..18df6a7 100644
Binary files a/_static/img/viz_thumbnails/chord.png and b/_static/img/viz_thumbnails/chord.png differ
diff --git a/_static/img/viz_thumbnails/compare.png b/_static/img/viz_thumbnails/compare.png
index 00b0a7c..c17af52 100644
Binary files a/_static/img/viz_thumbnails/compare.png and b/_static/img/viz_thumbnails/compare.png differ
diff --git a/_static/img/viz_thumbnails/country_map.png b/_static/img/viz_thumbnails/country_map.png
index 896fd6b..52acbfa 100644
Binary files a/_static/img/viz_thumbnails/country_map.png and b/_static/img/viz_thumbnails/country_map.png differ
diff --git a/_static/img/viz_thumbnails/deck_arc.png b/_static/img/viz_thumbnails/deck_arc.png
new file mode 100644
index 0000000..02b84b1
Binary files /dev/null and b/_static/img/viz_thumbnails/deck_arc.png differ
diff --git a/_static/img/viz_thumbnails/deck_geojson.png b/_static/img/viz_thumbnails/deck_geojson.png
new file mode 100644
index 0000000..9c1a732
Binary files /dev/null and b/_static/img/viz_thumbnails/deck_geojson.png differ
diff --git a/_static/img/viz_thumbnails/deck_grid.png b/_static/img/viz_thumbnails/deck_grid.png
new file mode 100644
index 0000000..2710d9f
Binary files /dev/null and b/_static/img/viz_thumbnails/deck_grid.png differ
diff --git a/_static/img/viz_thumbnails/deck_hex.png b/_static/img/viz_thumbnails/deck_hex.png
new file mode 100644
index 0000000..99149db
Binary files /dev/null and b/_static/img/viz_thumbnails/deck_hex.png differ
diff --git a/_static/img/viz_thumbnails/deck_multi.png b/_static/img/viz_thumbnails/deck_multi.png
new file mode 100644
index 0000000..acedd5b
Binary files /dev/null and b/_static/img/viz_thumbnails/deck_multi.png differ
diff --git a/_static/img/viz_thumbnails/deck_path.png b/_static/img/viz_thumbnails/deck_path.png
new file mode 100644
index 0000000..d783a14
Binary files /dev/null and b/_static/img/viz_thumbnails/deck_path.png differ
diff --git a/_static/img/viz_thumbnails/deck_polygon.png b/_static/img/viz_thumbnails/deck_polygon.png
new file mode 100644
index 0000000..b32c540
Binary files /dev/null and b/_static/img/viz_thumbnails/deck_polygon.png differ
diff --git a/_static/img/viz_thumbnails/deck_scatter.png b/_static/img/viz_thumbnails/deck_scatter.png
new file mode 100644
index 0000000..a111a15
Binary files /dev/null and b/_static/img/viz_thumbnails/deck_scatter.png differ
diff --git a/_static/img/viz_thumbnails/deck_screengrid.png b/_static/img/viz_thumbnails/deck_screengrid.png
new file mode 100644
index 0000000..78a26e6
Binary files /dev/null and b/_static/img/viz_thumbnails/deck_screengrid.png differ
diff --git a/_static/img/viz_thumbnails/directed_force.png b/_static/img/viz_thumbnails/directed_force.png
index 1cc7ce9..15e0edb 100644
Binary files a/_static/img/viz_thumbnails/directed_force.png and b/_static/img/viz_thumbnails/directed_force.png differ
diff --git a/_static/img/viz_thumbnails/dist_bar.png b/_static/img/viz_thumbnails/dist_bar.png
index b410147..cdd5120 100644
Binary files a/_static/img/viz_thumbnails/dist_bar.png and b/_static/img/viz_thumbnails/dist_bar.png differ
diff --git a/_static/img/viz_thumbnails/dual_line.png b/_static/img/viz_thumbnails/dual_line.png
index 23a7750..a5f723c 100644
Binary files a/_static/img/viz_thumbnails/dual_line.png and b/_static/img/viz_thumbnails/dual_line.png differ
diff --git a/_static/img/viz_thumbnails/event_flow.png b/_static/img/viz_thumbnails/event_flow.png
index 4576529..a24c1c5 100644
Binary files a/_static/img/viz_thumbnails/event_flow.png and b/_static/img/viz_thumbnails/event_flow.png differ
diff --git a/_static/img/viz_thumbnails/filter_box.png b/_static/img/viz_thumbnails/filter_box.png
index 209259c..be08f68 100644
Binary files a/_static/img/viz_thumbnails/filter_box.png and b/_static/img/viz_thumbnails/filter_box.png differ
diff --git a/_static/img/viz_thumbnails/heatmap.png b/_static/img/viz_thumbnails/heatmap.png
index ac81a45..8d5f8da 100644
Binary files a/_static/img/viz_thumbnails/heatmap.png and b/_static/img/viz_thumbnails/heatmap.png differ
diff --git a/_static/img/viz_thumbnails/histogram.png b/_static/img/viz_thumbnails/histogram.png
index f7bbe62..c6f8fdc 100644
Binary files a/_static/img/viz_thumbnails/histogram.png and b/_static/img/viz_thumbnails/histogram.png differ
diff --git a/_static/img/viz_thumbnails/horizon.png b/_static/img/viz_thumbnails/horizon.png
index a5d4bf3..f927b76 100644
Binary files a/_static/img/viz_thumbnails/horizon.png and b/_static/img/viz_thumbnails/horizon.png differ
diff --git a/_static/img/viz_thumbnails/iframe.png b/_static/img/viz_thumbnails/iframe.png
index d5f0f56..5c6524a 100644
Binary files a/_static/img/viz_thumbnails/iframe.png and b/_static/img/viz_thumbnails/iframe.png differ
diff --git a/_static/img/viz_thumbnails/line.png b/_static/img/viz_thumbnails/line.png
index 67f8fe8..7df5084 100644
Binary files a/_static/img/viz_thumbnails/line.png and b/_static/img/viz_thumbnails/line.png differ
diff --git a/_static/img/viz_thumbnails/mapbox.png b/_static/img/viz_thumbnails/mapbox.png
index 662c163..2132df5 100644
Binary files a/_static/img/viz_thumbnails/mapbox.png and b/_static/img/viz_thumbnails/mapbox.png differ
diff --git a/_static/img/viz_thumbnails/markup.png b/_static/img/viz_thumbnails/markup.png
index 675e42a..5878e15 100644
Binary files a/_static/img/viz_thumbnails/markup.png and b/_static/img/viz_thumbnails/markup.png differ
diff --git a/_static/img/viz_thumbnails/multi.png b/_static/img/viz_thumbnails/multi.png
new file mode 100644
index 0000000..e894506
Binary files /dev/null and b/_static/img/viz_thumbnails/multi.png differ
diff --git a/_static/img/viz_thumbnails/paired_ttest.png b/_static/img/viz_thumbnails/paired_ttest.png
index 4f8ad71..4a3b225 100644
Binary files a/_static/img/viz_thumbnails/paired_ttest.png and b/_static/img/viz_thumbnails/paired_ttest.png differ
diff --git a/_static/img/viz_thumbnails/para.png b/_static/img/viz_thumbnails/para.png
index fc1a157..5401034 100644
Binary files a/_static/img/viz_thumbnails/para.png and b/_static/img/viz_thumbnails/para.png differ
diff --git a/_static/img/viz_thumbnails/partition.png b/_static/img/viz_thumbnails/partition.png
index 7cf6e13..f49ee88 100644
Binary files a/_static/img/viz_thumbnails/partition.png and b/_static/img/viz_thumbnails/partition.png differ
diff --git a/_static/img/viz_thumbnails/pie.png b/_static/img/viz_thumbnails/pie.png
index ab76749..1c93bf5 100644
Binary files a/_static/img/viz_thumbnails/pie.png and b/_static/img/viz_thumbnails/pie.png differ
diff --git a/_static/img/viz_thumbnails/pivot_table.png b/_static/img/viz_thumbnails/pivot_table.png
index 37f86af..a22794b 100644
Binary files a/_static/img/viz_thumbnails/pivot_table.png and b/_static/img/viz_thumbnails/pivot_table.png differ
diff --git a/_static/img/viz_thumbnails/rose.png b/_static/img/viz_thumbnails/rose.png
new file mode 100644
index 0000000..2006746
Binary files /dev/null and b/_static/img/viz_thumbnails/rose.png differ
diff --git a/_static/img/viz_thumbnails/sankey.png b/_static/img/viz_thumbnails/sankey.png
index 981cdba..93d73f6 100644
Binary files a/_static/img/viz_thumbnails/sankey.png and b/_static/img/viz_thumbnails/sankey.png differ
diff --git a/_static/img/viz_thumbnails/separator.png b/_static/img/viz_thumbnails/separator.png
index eddb59d..0533413 100644
Binary files a/_static/img/viz_thumbnails/separator.png and b/_static/img/viz_thumbnails/separator.png differ
diff --git a/_static/img/viz_thumbnails/sunburst.png b/_static/img/viz_thumbnails/sunburst.png
index f155363..ec6b607 100644
Binary files a/_static/img/viz_thumbnails/sunburst.png and b/_static/img/viz_thumbnails/sunburst.png differ
diff --git a/_static/img/viz_thumbnails/table.png b/_static/img/viz_thumbnails/table.png
index a3dd1be..0561210 100644
Binary files a/_static/img/viz_thumbnails/table.png and b/_static/img/viz_thumbnails/table.png differ
diff --git a/_static/img/viz_thumbnails/time_pivot.png b/_static/img/viz_thumbnails/time_pivot.png
new file mode 100644
index 0000000..83201c2
Binary files /dev/null and b/_static/img/viz_thumbnails/time_pivot.png differ
diff --git a/_static/img/viz_thumbnails/time_table.png b/_static/img/viz_thumbnails/time_table.png
index 5eba0c2..fe11d8e 100644
Binary files a/_static/img/viz_thumbnails/time_table.png and b/_static/img/viz_thumbnails/time_table.png differ
diff --git a/_static/img/viz_thumbnails/treemap.png b/_static/img/viz_thumbnails/treemap.png
index 0aec60c..27c6c5c 100644
Binary files a/_static/img/viz_thumbnails/treemap.png and b/_static/img/viz_thumbnails/treemap.png differ
diff --git a/_static/img/viz_thumbnails/word_cloud.png b/_static/img/viz_thumbnails/word_cloud.png
index 03936e1..1829a2f 100644
Binary files a/_static/img/viz_thumbnails/word_cloud.png and b/_static/img/viz_thumbnails/word_cloud.png differ
diff --git a/_static/img/viz_thumbnails/world_map.png b/_static/img/viz_thumbnails/world_map.png
index 82e8ad2..4b3fe0b 100644
Binary files a/_static/img/viz_thumbnails/world_map.png and b/_static/img/viz_thumbnails/world_map.png differ
diff --git a/_static/img/viz_thumbnails/area.png b/_static/img/viz_thumbnails_large/area.png
similarity index 100%
copy from _static/img/viz_thumbnails/area.png
copy to _static/img/viz_thumbnails_large/area.png
diff --git a/_static/img/viz_thumbnails/bar.png b/_static/img/viz_thumbnails_large/bar.png
similarity index 100%
copy from _static/img/viz_thumbnails/bar.png
copy to _static/img/viz_thumbnails_large/bar.png
diff --git a/_static/img/viz_thumbnails/big_number.png b/_static/img/viz_thumbnails_large/big_number.png
similarity index 100%
copy from _static/img/viz_thumbnails/big_number.png
copy to _static/img/viz_thumbnails_large/big_number.png
diff --git a/_static/img/viz_thumbnails/big_number_total.png b/_static/img/viz_thumbnails_large/big_number_total.png
similarity index 100%
copy from _static/img/viz_thumbnails/big_number_total.png
copy to _static/img/viz_thumbnails_large/big_number_total.png
diff --git a/_static/img/viz_thumbnails/box_plot.png b/_static/img/viz_thumbnails_large/box_plot.png
similarity index 100%
copy from _static/img/viz_thumbnails/box_plot.png
copy to _static/img/viz_thumbnails_large/box_plot.png
diff --git a/_static/img/viz_thumbnails/bubble.png b/_static/img/viz_thumbnails_large/bubble.png
similarity index 100%
copy from _static/img/viz_thumbnails/bubble.png
copy to _static/img/viz_thumbnails_large/bubble.png
diff --git a/_static/img/viz_thumbnails/bullet.png b/_static/img/viz_thumbnails_large/bullet.png
similarity index 100%
copy from _static/img/viz_thumbnails/bullet.png
copy to _static/img/viz_thumbnails_large/bullet.png
diff --git a/_static/img/viz_thumbnails/cal_heatmap.png b/_static/img/viz_thumbnails_large/cal_heatmap.png
similarity index 100%
copy from _static/img/viz_thumbnails/cal_heatmap.png
copy to _static/img/viz_thumbnails_large/cal_heatmap.png
diff --git a/_static/img/viz_thumbnails/chord.png b/_static/img/viz_thumbnails_large/chord.png
similarity index 100%
copy from _static/img/viz_thumbnails/chord.png
copy to _static/img/viz_thumbnails_large/chord.png
diff --git a/_static/img/viz_thumbnails/compare.png b/_static/img/viz_thumbnails_large/compare.png
similarity index 100%
copy from _static/img/viz_thumbnails/compare.png
copy to _static/img/viz_thumbnails_large/compare.png
diff --git a/_static/img/viz_thumbnails/country_map.png b/_static/img/viz_thumbnails_large/country_map.png
similarity index 100%
copy from _static/img/viz_thumbnails/country_map.png
copy to _static/img/viz_thumbnails_large/country_map.png
diff --git a/_static/img/viz_thumbnails_large/deck_arc.png b/_static/img/viz_thumbnails_large/deck_arc.png
new file mode 100644
index 0000000..f79f283
Binary files /dev/null and b/_static/img/viz_thumbnails_large/deck_arc.png differ
diff --git a/_static/img/viz_thumbnails_large/deck_geojson.png b/_static/img/viz_thumbnails_large/deck_geojson.png
new file mode 100644
index 0000000..acc452c
Binary files /dev/null and b/_static/img/viz_thumbnails_large/deck_geojson.png differ
diff --git a/_static/img/viz_thumbnails_large/deck_grid.png b/_static/img/viz_thumbnails_large/deck_grid.png
new file mode 100644
index 0000000..cd93965
Binary files /dev/null and b/_static/img/viz_thumbnails_large/deck_grid.png differ
diff --git a/_static/img/viz_thumbnails_large/deck_hex.png b/_static/img/viz_thumbnails_large/deck_hex.png
new file mode 100644
index 0000000..31feff5
Binary files /dev/null and b/_static/img/viz_thumbnails_large/deck_hex.png differ
diff --git a/_static/img/viz_thumbnails_large/deck_multi.png b/_static/img/viz_thumbnails_large/deck_multi.png
new file mode 100644
index 0000000..21c27c0
Binary files /dev/null and b/_static/img/viz_thumbnails_large/deck_multi.png differ
diff --git a/_static/img/viz_thumbnails_large/deck_path.png b/_static/img/viz_thumbnails_large/deck_path.png
new file mode 100644
index 0000000..eede9da
Binary files /dev/null and b/_static/img/viz_thumbnails_large/deck_path.png differ
diff --git a/_static/img/viz_thumbnails_large/deck_polygon.png b/_static/img/viz_thumbnails_large/deck_polygon.png
new file mode 100644
index 0000000..dfae861
Binary files /dev/null and b/_static/img/viz_thumbnails_large/deck_polygon.png differ
diff --git a/_static/img/viz_thumbnails_large/deck_scatter.png b/_static/img/viz_thumbnails_large/deck_scatter.png
new file mode 100644
index 0000000..11f38cc
Binary files /dev/null and b/_static/img/viz_thumbnails_large/deck_scatter.png differ
diff --git a/_static/img/viz_thumbnails_large/deck_screengrid.png b/_static/img/viz_thumbnails_large/deck_screengrid.png
new file mode 100644
index 0000000..d5da29c
Binary files /dev/null and b/_static/img/viz_thumbnails_large/deck_screengrid.png differ
diff --git a/_static/img/viz_thumbnails/directed_force.png b/_static/img/viz_thumbnails_large/directed_force.png
similarity index 100%
copy from _static/img/viz_thumbnails/directed_force.png
copy to _static/img/viz_thumbnails_large/directed_force.png
diff --git a/_static/img/viz_thumbnails/dist_bar.png b/_static/img/viz_thumbnails_large/dist_bar.png
similarity index 100%
copy from _static/img/viz_thumbnails/dist_bar.png
copy to _static/img/viz_thumbnails_large/dist_bar.png
diff --git a/_static/img/viz_thumbnails/dual_line.png b/_static/img/viz_thumbnails_large/dual_line.png
similarity index 100%
copy from _static/img/viz_thumbnails/dual_line.png
copy to _static/img/viz_thumbnails_large/dual_line.png
diff --git a/_static/img/viz_thumbnails/event_flow.png b/_static/img/viz_thumbnails_large/event_flow.png
similarity index 100%
copy from _static/img/viz_thumbnails/event_flow.png
copy to _static/img/viz_thumbnails_large/event_flow.png
diff --git a/_static/img/viz_thumbnails/filter_box.png b/_static/img/viz_thumbnails_large/filter_box.png
similarity index 100%
copy from _static/img/viz_thumbnails/filter_box.png
copy to _static/img/viz_thumbnails_large/filter_box.png
diff --git a/_static/img/viz_thumbnails/heatmap.png b/_static/img/viz_thumbnails_large/heatmap.png
similarity index 100%
copy from _static/img/viz_thumbnails/heatmap.png
copy to _static/img/viz_thumbnails_large/heatmap.png
diff --git a/_static/img/viz_thumbnails/histogram.png b/_static/img/viz_thumbnails_large/histogram.png
similarity index 100%
copy from _static/img/viz_thumbnails/histogram.png
copy to _static/img/viz_thumbnails_large/histogram.png
diff --git a/_static/img/viz_thumbnails/horizon.png b/_static/img/viz_thumbnails_large/horizon.png
similarity index 100%
copy from _static/img/viz_thumbnails/horizon.png
copy to _static/img/viz_thumbnails_large/horizon.png
diff --git a/_static/img/viz_thumbnails/iframe.png b/_static/img/viz_thumbnails_large/iframe.png
similarity index 100%
copy from _static/img/viz_thumbnails/iframe.png
copy to _static/img/viz_thumbnails_large/iframe.png
diff --git a/_static/img/viz_thumbnails/line.png b/_static/img/viz_thumbnails_large/line.png
similarity index 100%
copy from _static/img/viz_thumbnails/line.png
copy to _static/img/viz_thumbnails_large/line.png
diff --git a/_static/img/viz_thumbnails/mapbox.png b/_static/img/viz_thumbnails_large/mapbox.png
similarity index 100%
copy from _static/img/viz_thumbnails/mapbox.png
copy to _static/img/viz_thumbnails_large/mapbox.png
diff --git a/_static/img/viz_thumbnails/markup.png b/_static/img/viz_thumbnails_large/markup.png
similarity index 100%
copy from _static/img/viz_thumbnails/markup.png
copy to _static/img/viz_thumbnails_large/markup.png
diff --git a/_static/img/viz_thumbnails_large/multi.png b/_static/img/viz_thumbnails_large/multi.png
new file mode 100644
index 0000000..be62cd4
Binary files /dev/null and b/_static/img/viz_thumbnails_large/multi.png differ
diff --git a/_static/img/viz_thumbnails/paired_ttest.png b/_static/img/viz_thumbnails_large/paired_ttest.png
similarity index 100%
copy from _static/img/viz_thumbnails/paired_ttest.png
copy to _static/img/viz_thumbnails_large/paired_ttest.png
diff --git a/_static/img/viz_thumbnails/para.png b/_static/img/viz_thumbnails_large/para.png
similarity index 100%
copy from _static/img/viz_thumbnails/para.png
copy to _static/img/viz_thumbnails_large/para.png
diff --git a/_static/img/viz_thumbnails/partition.png b/_static/img/viz_thumbnails_large/partition.png
similarity index 100%
copy from _static/img/viz_thumbnails/partition.png
copy to _static/img/viz_thumbnails_large/partition.png
diff --git a/_static/img/viz_thumbnails/pie.png b/_static/img/viz_thumbnails_large/pie.png
similarity index 100%
copy from _static/img/viz_thumbnails/pie.png
copy to _static/img/viz_thumbnails_large/pie.png
diff --git a/_static/img/viz_thumbnails/pivot_table.png b/_static/img/viz_thumbnails_large/pivot_table.png
similarity index 100%
copy from _static/img/viz_thumbnails/pivot_table.png
copy to _static/img/viz_thumbnails_large/pivot_table.png
diff --git a/_static/img/viz_thumbnails_large/rose.png b/_static/img/viz_thumbnails_large/rose.png
new file mode 100644
index 0000000..763fa2b
Binary files /dev/null and b/_static/img/viz_thumbnails_large/rose.png differ
diff --git a/_static/img/viz_thumbnails/sankey.png b/_static/img/viz_thumbnails_large/sankey.png
similarity index 100%
copy from _static/img/viz_thumbnails/sankey.png
copy to _static/img/viz_thumbnails_large/sankey.png
diff --git a/_static/img/viz_thumbnails/separator.png b/_static/img/viz_thumbnails_large/separator.png
similarity index 100%
copy from _static/img/viz_thumbnails/separator.png
copy to _static/img/viz_thumbnails_large/separator.png
diff --git a/_static/img/viz_thumbnails/sunburst.png b/_static/img/viz_thumbnails_large/sunburst.png
similarity index 100%
copy from _static/img/viz_thumbnails/sunburst.png
copy to _static/img/viz_thumbnails_large/sunburst.png
diff --git a/_static/img/viz_thumbnails/table.png b/_static/img/viz_thumbnails_large/table.png
similarity index 100%
copy from _static/img/viz_thumbnails/table.png
copy to _static/img/viz_thumbnails_large/table.png
diff --git a/_static/img/viz_thumbnails_large/time_pivot.png b/_static/img/viz_thumbnails_large/time_pivot.png
new file mode 100644
index 0000000..149f3da
Binary files /dev/null and b/_static/img/viz_thumbnails_large/time_pivot.png differ
diff --git a/_static/img/viz_thumbnails/time_table.png b/_static/img/viz_thumbnails_large/time_table.png
similarity index 100%
copy from _static/img/viz_thumbnails/time_table.png
copy to _static/img/viz_thumbnails_large/time_table.png
diff --git a/_static/img/viz_thumbnails/treemap.png b/_static/img/viz_thumbnails_large/treemap.png
similarity index 100%
copy from _static/img/viz_thumbnails/treemap.png
copy to _static/img/viz_thumbnails_large/treemap.png
diff --git a/_static/img/viz_thumbnails/word_cloud.png b/_static/img/viz_thumbnails_large/word_cloud.png
similarity index 100%
copy from _static/img/viz_thumbnails/word_cloud.png
copy to _static/img/viz_thumbnails_large/word_cloud.png
diff --git a/_static/img/viz_thumbnails/world_map.png b/_static/img/viz_thumbnails_large/world_map.png
similarity index 100%
copy from _static/img/viz_thumbnails/world_map.png
copy to _static/img/viz_thumbnails_large/world_map.png
diff --git a/druid.html b/druid.html
index 94d65e9..3b0a05b 100644
--- a/druid.html
+++ b/druid.html
@@ -36,8 +36,8 @@
href="genindex.html"/>
<link rel="search" title="Search" href="search.html"/>
<link rel="top" title="Apache Superset documentation" href="index.html"/>
- <link rel="next" title="FAQ" href="faq.html"/>
- <link rel="prev" title="Gallery" href="gallery.html"/>
+ <link rel="next" title="Misc" href="misc.html"/>
+ <link rel="prev" title="Visualizations Gallery" href="gallery.html"/>
<script src="_static/js/modernizr.min.js"></script>
@@ -88,21 +88,17 @@
<ul class="current">
<li class="toctree-l1"><a class="reference internal" href="installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1"><a class="reference internal" href="security.html">Security</a></li>
<li class="toctree-l1"><a class="reference internal" href="sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a></li>
-<li class="toctree-l1"><a class="reference internal" href="gallery.html">Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
<li class="toctree-l1 current"><a class="current reference internal" href="#">Druid</a><ul>
-<li class="toctree-l2"><a class="reference internal" href="#supported">Supported</a><ul>
-<li class="toctree-l3"><a class="reference internal" href="#aggregations">Aggregations</a></li>
-<li class="toctree-l3"><a class="reference internal" href="#post-aggregations">Post-Aggregations</a></li>
-</ul>
-</li>
-<li class="toctree-l2"><a class="reference internal" href="#not-yet-supported">Not yet supported</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#aggregations">Aggregations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#post-aggregations">Post-Aggregations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#unsupported-features">Unsupported Features</a></li>
</ul>
</li>
+<li class="toctree-l1"><a class="reference internal" href="misc.html">Misc</a></li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
</ul>
@@ -167,18 +163,17 @@
<div class="section" id="druid">
<h1>Druid<a class="headerlink" href="#druid" title="Permalink to this headline">¶</a></h1>
-<p>Superset works well with Druid, though currently not all
-advanced features out of Druid are covered. This page clarifies what is
-covered and what isn’t and explains how to use some of the features.</p>
+<p>Superset has a native connector to Druid, and a majority of Druid’s
+features are accessible through Superset.</p>
<div class="admonition note">
<p class="first admonition-title">Note</p>
-<p class="last">Currently Airbnb runs against Druid <code class="docutils literal"><span class="pre">0.8.x</span></code> and previous /
-following versions are not tested against.</p>
+<p class="last">Druid now supports SQL and can be accessed through Superset’s
+SQLAlchemy connector. The long term vision is to deprecate
+the Druid native REST connector and query Druid exclusively through
+the SQL interface.</p>
</div>
-<div class="section" id="supported">
-<h2>Supported<a class="headerlink" href="#supported" title="Permalink to this headline">¶</a></h2>
<div class="section" id="aggregations">
-<h3>Aggregations<a class="headerlink" href="#aggregations" title="Permalink to this headline">¶</a></h3>
+<h2>Aggregations<a class="headerlink" href="#aggregations" title="Permalink to this headline">¶</a></h2>
<p>Common aggregations, or Druid metrics can be defined and used in Superset.
The first and simpler use case is to use the checkbox matrix expose in your
datasource’s edit view (<code class="docutils literal"><span class="pre">Sources</span> <span class="pre">-></span> <span class="pre">Druid</span> <span class="pre">Datasources</span> <span class="pre">-></span>
@@ -194,20 +189,20 @@ documentation.</p>
<a class="reference internal image-reference" href="_images/druid_agg.png"><img alt="_images/druid_agg.png" src="_images/druid_agg.png" style="width: 894.0px; height: 564.0px;" /></a>
</div>
<div class="section" id="post-aggregations">
-<h3>Post-Aggregations<a class="headerlink" href="#post-aggregations" title="Permalink to this headline">¶</a></h3>
+<h2>Post-Aggregations<a class="headerlink" href="#post-aggregations" title="Permalink to this headline">¶</a></h2>
<p>Druid supports post aggregation and this works in Superset. All you have to
do is creating a metric, much like you would create an aggregation manually,
but specify <code class="docutils literal"><span class="pre">postagg</span></code> as a <code class="docutils literal"><span class="pre">Metric</span> <span class="pre">Type</span></code>. You then have to provide a valid
json post-aggregation definition (as specified in the Druid docs) in the
Json field.</p>
</div>
+<div class="section" id="unsupported-features">
+<h2>Unsupported Features<a class="headerlink" href="#unsupported-features" title="Permalink to this headline">¶</a></h2>
+<div class="admonition note">
+<p class="first admonition-title">Note</p>
+<p class="last">Unclear at this point, this section of the documentation could use
+some input.</p>
</div>
-<div class="section" id="not-yet-supported">
-<h2>Not yet supported<a class="headerlink" href="#not-yet-supported" title="Permalink to this headline">¶</a></h2>
-<ul class="simple">
-<li>Regex filters</li>
-<li>Lookups / joins</li>
-</ul>
</div>
</div>
@@ -221,10 +216,10 @@ Json field.</p>
<div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
- <a href="faq.html" class="btn btn-neutral float-right" title="FAQ" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
+ <a href="misc.html" class="btn btn-neutral float-right" title="Misc" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
- <a href="gallery.html" class="btn btn-neutral" title="Gallery" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+ <a href="gallery.html" class="btn btn-neutral" title="Visualizations Gallery" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
</div>
diff --git a/faq.html b/faq.html
index 64d8699..aeb4c8e 100644
--- a/faq.html
+++ b/faq.html
@@ -36,7 +36,7 @@
href="genindex.html"/>
<link rel="search" title="Search" href="search.html"/>
<link rel="top" title="Apache Superset documentation" href="index.html"/>
- <link rel="prev" title="Druid" href="druid.html"/>
+ <link rel="prev" title="Importing and Exporting Datasources" href="import_export_datasources.html"/>
<script src="_static/js/modernizr.min.js"></script>
@@ -87,17 +87,17 @@
<ul class="current">
<li class="toctree-l1"><a class="reference internal" href="installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1"><a class="reference internal" href="security.html">Security</a></li>
<li class="toctree-l1"><a class="reference internal" href="sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a></li>
-<li class="toctree-l1"><a class="reference internal" href="gallery.html">Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
+<li class="toctree-l1"><a class="reference internal" href="misc.html">Misc</a></li>
<li class="toctree-l1 current"><a class="current reference internal" href="#">FAQ</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#can-i-query-join-multiple-tables-at-one-time">Can I query/join multiple tables at one time?</a></li>
<li class="toctree-l2"><a class="reference internal" href="#how-big-can-my-data-source-be">How BIG can my data source be?</a></li>
<li class="toctree-l2"><a class="reference internal" href="#how-do-i-create-my-own-visualization">How do I create my own visualization?</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#can-i-upload-and-visualize-csv-data">Can I upload and visualize csv data?</a></li>
<li class="toctree-l2"><a class="reference internal" href="#why-are-my-queries-timing-out">Why are my queries timing out?</a></li>
<li class="toctree-l2"><a class="reference internal" href="#why-is-the-map-not-visible-in-the-mapbox-visualization">Why is the map not visible in the mapbox visualization?</a></li>
<li class="toctree-l2"><a class="reference internal" href="#how-to-add-dynamic-filters-to-a-dashboard">How to add dynamic filters to a dashboard?</a></li>
@@ -109,6 +109,7 @@
<li class="toctree-l2"><a class="reference internal" href="#how-can-i-configure-oauth-authentication-and-authorization">How can i configure OAuth authentication and authorization?</a></li>
<li class="toctree-l2"><a class="reference internal" href="#how-can-i-set-a-default-filter-on-my-dashboard">How can I set a default filter on my dashboard?</a></li>
<li class="toctree-l2"><a class="reference internal" href="#how-do-i-get-superset-to-refresh-the-schema-of-my-table">How do I get Superset to refresh the schema of my table?</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#is-there-a-way-to-force-the-use-specific-colors">Is there a way to force the use specific colors?</a></li>
</ul>
</li>
</ul>
@@ -208,6 +209,13 @@ framework, in the meantime, we’ve tagged a few pull requests as
visualizations.</p>
<p><a class="reference external" href="https://github.com/airbnb/superset/issues?q=label%3Aexample+is%3Aclosed">https://github.com/airbnb/superset/issues?q=label%3Aexample+is%3Aclosed</a></p>
</div>
+<div class="section" id="can-i-upload-and-visualize-csv-data">
+<h2>Can I upload and visualize csv data?<a class="headerlink" href="#can-i-upload-and-visualize-csv-data" title="Permalink to this headline">¶</a></h2>
+<p>Yes, using the <code class="docutils literal"><span class="pre">Upload</span> <span class="pre">a</span> <span class="pre">CSV</span></code> button under the <code class="docutils literal"><span class="pre">Sources</span></code> menu item.
+This brings up a form that allows you specify required information.
+After creating the table from CSV, it can then be loaded like any
+other on the <code class="docutils literal"><span class="pre">Sources</span> <span class="pre">-></span> <span class="pre">Tables</span></code> page.</p>
+</div>
<div class="section" id="why-are-my-queries-timing-out">
<h2>Why are my queries timing out?<a class="headerlink" href="#why-are-my-queries-timing-out" title="Permalink to this headline">¶</a></h2>
<p>There are many reasons may cause long query timing out.</p>
@@ -248,15 +256,14 @@ dashboard? You can do that by editing your dashboard, and in the form,
edit the <code class="docutils literal"><span class="pre">JSON</span> <span class="pre">Metadata</span></code> field, more specifically the
<code class="docutils literal"><span class="pre">filter_immune_slices</span></code> key, that receives an array of sliceIds that should
never be affected by any dashboard level filtering.</p>
-<p>..code:</p>
-<div class="highlight-default"><div class="highlight"><pre><span></span><span class="p">{</span>
- <span class="s2">"filter_immune_slices"</span><span class="p">:</span> <span class="p">[</span><span class="mi">324</span><span class="p">,</span> <span class="mi">65</span><span class="p">,</span> <span class="mi">92</span><span class="p">],</span>
- <span class="s2">"expanded_slices"</span><span class="p">:</span> <span class="p">{},</span>
- <span class="s2">"filter_immune_slice_fields"</span><span class="p">:</span> <span class="p">{</span>
- <span class="s2">"177"</span><span class="p">:</span> <span class="p">[</span><span class="s2">"country_name"</span><span class="p">,</span> <span class="s2">"__from"</span><span class="p">,</span> <span class="s2">"__to"</span><span class="p">],</span>
- <span class="s2">"32"</span><span class="p">:</span> <span class="p">[</span><span class="s2">"__from"</span><span class="p">,</span> <span class="s2">"__to"</span><span class="p">]</span>
+<div class="highlight-json"><div class="highlight"><pre><span></span><span class="p">{</span>
+ <span class="nt">"filter_immune_slices"</span><span class="p">:</span> <span class="p">[</span><span class="mi">324</span><span class="p">,</span> <span class="mi">65</span><span class="p">,</span> <span class="mi">92</span><span class="p">],</span>
+ <span class="nt">"expanded_slices"</span><span class="p">:</span> <span class="p">{},</span>
+ <span class="nt">"filter_immune_slice_fields"</span><span class="p">:</span> <span class="p">{</span>
+ <span class="nt">"177"</span><span class="p">:</span> <span class="p">[</span><span class="s2">"country_name"</span><span class="p">,</span> <span class="s2">"__from"</span><span class="p">,</span> <span class="s2">"__to"</span><span class="p">],</span>
+ <span class="nt">"32"</span><span class="p">:</span> <span class="p">[</span><span class="s2">"__from"</span><span class="p">,</span> <span class="s2">"__to"</span><span class="p">]</span>
<span class="p">},</span>
- <span class="s2">"timed_refresh_immune_slices"</span><span class="p">:</span> <span class="p">[</span><span class="mi">324</span><span class="p">]</span>
+ <span class="nt">"timed_refresh_immune_slices"</span><span class="p">:</span> <span class="p">[</span><span class="mi">324</span><span class="p">]</span>
<span class="p">}</span>
</pre></div>
</div>
@@ -278,12 +285,11 @@ on a dashboard according to a set schedule. Sometimes, however, you won’t want
to be refreshed - especially if some data is slow moving, or run heavy queries. To exclude specific
slices from the timed refresh process, add the <code class="docutils literal"><span class="pre">timed_refresh_immune_slices</span></code> key to the dashboard
<code class="docutils literal"><span class="pre">JSON</span> <span class="pre">Metadata</span></code> field:</p>
-<p>..code:</p>
-<div class="highlight-default"><div class="highlight"><pre><span></span><span class="p">{</span>
- <span class="s2">"filter_immune_slices"</span><span class="p">:</span> <span class="p">[],</span>
- <span class="s2">"expanded_slices"</span><span class="p">:</span> <span class="p">{},</span>
- <span class="s2">"filter_immune_slice_fields"</span><span class="p">:</span> <span class="p">{},</span>
- <span class="s2">"timed_refresh_immune_slices"</span><span class="p">:</span> <span class="p">[</span><span class="mi">324</span><span class="p">]</span>
+<div class="highlight-json"><div class="highlight"><pre><span></span><span class="p">{</span>
+ <span class="nt">"filter_immune_slices"</span><span class="p">:</span> <span class="p">[],</span>
+ <span class="nt">"expanded_slices"</span><span class="p">:</span> <span class="p">{},</span>
+ <span class="nt">"filter_immune_slice_fields"</span><span class="p">:</span> <span class="p">{},</span>
+ <span class="nt">"timed_refresh_immune_slices"</span><span class="p">:</span> <span class="p">[</span><span class="mi">324</span><span class="p">]</span>
<span class="p">}</span>
</pre></div>
</div>
@@ -292,10 +298,9 @@ be automatically re-queried on schedule.</p>
<p>Slice refresh will also be staggered over the specified period. You can turn off this staggering
by setting the <code class="docutils literal"><span class="pre">stagger_refresh</span></code> to <code class="docutils literal"><span class="pre">false</span></code> and modify the stagger period by setting
<code class="docutils literal"><span class="pre">stagger_time</span></code> to a value in milliseconds in the <code class="docutils literal"><span class="pre">JSON</span> <span class="pre">Metadata</span></code> field:</p>
-<p>..code:</p>
-<div class="highlight-default"><div class="highlight"><pre><span></span><span class="p">{</span>
- <span class="s2">"stagger_refresh"</span><span class="p">:</span> <span class="n">false</span><span class="p">,</span>
- <span class="s2">"stagger_time"</span><span class="p">:</span> <span class="mi">2500</span>
+<div class="highlight-json"><div class="highlight"><pre><span></span><span class="p">{</span>
+ <span class="nt">"stagger_refresh"</span><span class="p">:</span> <span class="kc">false</span><span class="p">,</span>
+ <span class="nt">"stagger_time"</span><span class="p">:</span> <span class="mi">2500</span>
<span class="p">}</span>
</pre></div>
</div>
@@ -351,6 +356,20 @@ new columns in by using the “Refresh Metadata” action in the
<code class="docutils literal"><span class="pre">Source</span> <span class="pre">-></span> <span class="pre">Tables</span></code> page. Simply check the box next to the tables
you want the schema refreshed, and click <code class="docutils literal"><span class="pre">Actions</span> <span class="pre">-></span> <span class="pre">Refresh</span> <span class="pre">Metadata</span></code>.</p>
</div>
+<div class="section" id="is-there-a-way-to-force-the-use-specific-colors">
+<h2>Is there a way to force the use specific colors?<a class="headerlink" href="#is-there-a-way-to-force-the-use-specific-colors" title="Permalink to this headline">¶</a></h2>
+<p>It is possible on a per-dashboard basis by providing a mapping of
+labels to colors in the <code class="docutils literal"><span class="pre">JSON</span> <span class="pre">Metadata</span></code> attribute using the
+<code class="docutils literal"><span class="pre">label_colors</span></code> key.</p>
+<div class="highlight-json"><div class="highlight"><pre><span></span><span class="p">{</span>
+ <span class="nt">"label_colors"</span><span class="p">:</span> <span class="p">{</span>
+ <span class="nt">"Girls"</span><span class="p">:</span> <span class="s2">"#FF69B4"</span><span class="p">,</span>
+ <span class="nt">"Boys"</span><span class="p">:</span> <span class="s2">"#ADD8E6"</span>
+ <span class="p">}</span>
+<span class="p">}</span>
+</pre></div>
+</div>
+</div>
</div>
@@ -364,7 +383,7 @@ you want the schema refreshed, and click <code class="docutils literal"><span cl
<div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
- <a href="druid.html" class="btn btn-neutral" title="Druid" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+ <a href="import_export_datasources.html" class="btn btn-neutral" title="Importing and Exporting Datasources" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
</div>
diff --git a/gallery.html b/gallery.html
index f3d1949..bcf5f6e 100644
--- a/gallery.html
+++ b/gallery.html
@@ -8,7 +8,7 @@
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Gallery — Apache Superset documentation</title>
+ <title>Visualizations Gallery — Apache Superset documentation</title>
@@ -37,7 +37,7 @@
<link rel="search" title="Search" href="search.html"/>
<link rel="top" title="Apache Superset documentation" href="index.html"/>
<link rel="next" title="Druid" href="druid.html"/>
- <link rel="prev" title="Videos" href="videos.html"/>
+ <link rel="prev" title="SQL Lab" href="sqllab.html"/>
<script src="_static/js/modernizr.min.js"></script>
@@ -88,13 +88,12 @@
<ul class="current">
<li class="toctree-l1"><a class="reference internal" href="installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1"><a class="reference internal" href="security.html">Security</a></li>
<li class="toctree-l1"><a class="reference internal" href="sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a></li>
-<li class="toctree-l1 current"><a class="current reference internal" href="#">Gallery</a></li>
+<li class="toctree-l1 current"><a class="current reference internal" href="#">Visualizations Gallery</a></li>
<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
+<li class="toctree-l1"><a class="reference internal" href="misc.html">Misc</a></li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
</ul>
@@ -140,7 +139,7 @@
<li><a href="index.html">Docs</a> »</li>
- <li>Gallery</li>
+ <li>Visualizations Gallery</li>
<li class="wy-breadcrumbs-aside">
@@ -157,37 +156,55 @@
<div role="main" class="document" itemscope="itemscope" itemtype="http://schema.org/Article">
<div itemprop="articleBody">
- <div class="section" id="gallery">
-<h1>Gallery<a class="headerlink" href="#gallery" title="Permalink to this headline">¶</a></h1>
-<a class="reference internal image-reference" href="_images/line.png"><img alt="_images/line.png" src="_images/line.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/bubble.png"><img alt="_images/bubble.png" src="_images/bubble.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/table.png"><img alt="_images/table.png" src="_images/table.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/pie.png"><img alt="_images/pie.png" src="_images/pie.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/bar.png"><img alt="_images/bar.png" src="_images/bar.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/world_map.png"><img alt="_images/world_map.png" src="_images/world_map.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/sankey.png"><img alt="_images/sankey.png" src="_images/sankey.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/word_cloud.png"><img alt="_images/word_cloud.png" src="_images/word_cloud.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/filter_box.png"><img alt="_images/filter_box.png" src="_images/filter_box.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/pivot_table.png"><img alt="_images/pivot_table.png" src="_images/pivot_table.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/directed_force.png"><img alt="_images/directed_force.png" src="_images/directed_force.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/compare.png"><img alt="_images/compare.png" src="_images/compare.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/sunburst.png"><img alt="_images/sunburst.png" src="_images/sunburst.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/area.png"><img alt="_images/area.png" src="_images/area.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/big_number.png"><img alt="_images/big_number.png" src="_images/big_number.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/big_number_total.png"><img alt="_images/big_number_total.png" src="_images/big_number_total.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/bullet.png"><img alt="_images/bullet.png" src="_images/bullet.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/dist_bar.png"><img alt="_images/dist_bar.png" src="_images/dist_bar.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/heatmap.png"><img alt="_images/heatmap.png" src="_images/heatmap.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/markup.png"><img alt="_images/markup.png" src="_images/markup.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/para.png"><img alt="_images/para.png" src="_images/para.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/iframe.png"><img alt="_images/iframe.png" src="_images/iframe.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/box_plot.png"><img alt="_images/box_plot.png" src="_images/box_plot.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/treemap.png"><img alt="_images/treemap.png" src="_images/treemap.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/cal_heatmap.png"><img alt="_images/cal_heatmap.png" src="_images/cal_heatmap.png" style="width: 187.75px; height: 187.75px;" /></a>
-<a class="reference internal image-reference" href="_images/horizon.png"><img alt="_images/horizon.png" src="_images/horizon.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/mapbox.png"><img alt="_images/mapbox.png" src="_images/mapbox.png" style="width: 125.0px; height: 125.0px;" /></a>
-<a class="reference internal image-reference" href="_images/separator.png"><img alt="_images/separator.png" src="_images/separator.png" style="width: 256.0px; height: 256.0px;" /></a>
-<a class="reference internal image-reference" href="_images/histogram.png"><img alt="_images/histogram.png" src="_images/histogram.png" style="width: 256.0px; height: 256.0px;" /></a>
+ <div class="section" id="visualizations-gallery">
+<h1>Visualizations Gallery<a class="headerlink" href="#visualizations-gallery" title="Permalink to this headline">¶</a></h1>
+<a class="reference internal image-reference" href="_images/area.png"><img alt="_images/area.png" src="_images/area.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/bar.png"><img alt="_images/bar.png" src="_images/bar.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/big_number.png"><img alt="_images/big_number.png" src="_images/big_number.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/big_number_total.png"><img alt="_images/big_number_total.png" src="_images/big_number_total.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/box_plot.png"><img alt="_images/box_plot.png" src="_images/box_plot.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/bubble.png"><img alt="_images/bubble.png" src="_images/bubble.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/bullet.png"><img alt="_images/bullet.png" src="_images/bullet.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/cal_heatmap.png"><img alt="_images/cal_heatmap.png" src="_images/cal_heatmap.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/chord.png"><img alt="_images/chord.png" src="_images/chord.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/compare.png"><img alt="_images/compare.png" src="_images/compare.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/country_map.png"><img alt="_images/country_map.png" src="_images/country_map.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/deck_arc.png"><img alt="_images/deck_arc.png" src="_images/deck_arc.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/deck_geojson.png"><img alt="_images/deck_geojson.png" src="_images/deck_geojson.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/deck_grid.png"><img alt="_images/deck_grid.png" src="_images/deck_grid.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/deck_hex.png"><img alt="_images/deck_hex.png" src="_images/deck_hex.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/deck_multi.png"><img alt="_images/deck_multi.png" src="_images/deck_multi.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/deck_path.png"><img alt="_images/deck_path.png" src="_images/deck_path.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/deck_polygon.png"><img alt="_images/deck_polygon.png" src="_images/deck_polygon.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/deck_scatter.png"><img alt="_images/deck_scatter.png" src="_images/deck_scatter.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/deck_screengrid.png"><img alt="_images/deck_screengrid.png" src="_images/deck_screengrid.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/directed_force.png"><img alt="_images/directed_force.png" src="_images/directed_force.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/dist_bar.png"><img alt="_images/dist_bar.png" src="_images/dist_bar.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/dual_line.png"><img alt="_images/dual_line.png" src="_images/dual_line.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/event_flow.png"><img alt="_images/event_flow.png" src="_images/event_flow.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/filter_box.png"><img alt="_images/filter_box.png" src="_images/filter_box.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/heatmap.png"><img alt="_images/heatmap.png" src="_images/heatmap.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/histogram.png"><img alt="_images/histogram.png" src="_images/histogram.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/horizon.png"><img alt="_images/horizon.png" src="_images/horizon.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/iframe.png"><img alt="_images/iframe.png" src="_images/iframe.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/line.png"><img alt="_images/line.png" src="_images/line.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/mapbox.png"><img alt="_images/mapbox.png" src="_images/mapbox.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/markup.png"><img alt="_images/markup.png" src="_images/markup.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/paired_ttest.png"><img alt="_images/paired_ttest.png" src="_images/paired_ttest.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/para.png"><img alt="_images/para.png" src="_images/para.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/partition.png"><img alt="_images/partition.png" src="_images/partition.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/pie.png"><img alt="_images/pie.png" src="_images/pie.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/pivot_table.png"><img alt="_images/pivot_table.png" src="_images/pivot_table.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/rose.png"><img alt="_images/rose.png" src="_images/rose.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/sankey.png"><img alt="_images/sankey.png" src="_images/sankey.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/separator.png"><img alt="_images/separator.png" src="_images/separator.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/sunburst.png"><img alt="_images/sunburst.png" src="_images/sunburst.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/table.png"><img alt="_images/table.png" src="_images/table.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/time_pivot.png"><img alt="_images/time_pivot.png" src="_images/time_pivot.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/time_table.png"><img alt="_images/time_table.png" src="_images/time_table.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/treemap.png"><img alt="_images/treemap.png" src="_images/treemap.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/word_cloud.png"><img alt="_images/word_cloud.png" src="_images/word_cloud.png" style="width: 128.0px; height: 128.0px;" /></a>
+<a class="reference internal image-reference" href="_images/world_map.png"><img alt="_images/world_map.png" src="_images/world_map.png" style="width: 128.0px; height: 128.0px;" /></a>
</div>
@@ -203,7 +220,7 @@
<a href="druid.html" class="btn btn-neutral float-right" title="Druid" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
- <a href="videos.html" class="btn btn-neutral" title="Videos" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+ <a href="sqllab.html" class="btn btn-neutral" title="SQL Lab" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
</div>
diff --git a/genindex.html b/genindex.html
index fb7d610..6ebee1b 100644
--- a/genindex.html
+++ b/genindex.html
@@ -87,13 +87,12 @@
<ul>
<li class="toctree-l1"><a class="reference internal" href="installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1"><a class="reference internal" href="security.html">Security</a></li>
<li class="toctree-l1"><a class="reference internal" href="sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a></li>
-<li class="toctree-l1"><a class="reference internal" href="gallery.html">Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
+<li class="toctree-l1"><a class="reference internal" href="misc.html">Misc</a></li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
</ul>
@@ -160,10 +159,25 @@
<h1 id="index">Index</h1>
<div class="genindex-jumpbox">
- <a href="#P"><strong>P</strong></a>
+ <a href="#E"><strong>E</strong></a>
+ | <a href="#P"><strong>P</strong></a>
+ | <a href="#S"><strong>S</strong></a>
| <a href="#U"><strong>U</strong></a>
</div>
+<h2 id="E">E</h2>
+<table style="width: 100%" class="indextable genindextable"><tr>
+ <td style="width: 33%; vertical-align: top;"><ul>
+ <li>
+ environment variable
+
+ <ul>
+ <li><a href="installation.html#index-0">SUPERSET_UPDATE_PERMS</a>
+</li>
+ </ul></li>
+ </ul></td>
+</tr></table>
+
<h2 id="P">P</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
<td style="width: 33%; vertical-align: top;"><ul>
@@ -172,6 +186,14 @@
</ul></td>
</tr></table>
+<h2 id="S">S</h2>
+<table style="width: 100%" class="indextable genindextable"><tr>
+ <td style="width: 33%; vertical-align: top;"><ul>
+ <li><a href="installation.html#index-0">SUPERSET_UPDATE_PERMS</a>
+</li>
+ </ul></td>
+</tr></table>
+
<h2 id="U">U</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
<td style="width: 33%; vertical-align: top;"><ul>
diff --git a/import_export_datasources.html b/import_export_datasources.html
new file mode 100644
index 0000000..2c524e6
--- /dev/null
+++ b/import_export_datasources.html
@@ -0,0 +1,345 @@
+
+
+<!DOCTYPE html>
+<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
+<!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
+<head>
+ <meta charset="utf-8">
+
+ <meta name="viewport" content="width=device-width, initial-scale=1.0">
+
+ <title>Importing and Exporting Datasources — Apache Superset documentation</title>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <link rel="stylesheet" href="_static/css/theme.css" type="text/css" />
+
+
+
+
+
+ <link rel="index" title="Index"
+ href="genindex.html"/>
+ <link rel="search" title="Search" href="search.html"/>
+ <link rel="top" title="Apache Superset documentation" href="index.html"/>
+ <link rel="up" title="Misc" href="misc.html"/>
+ <link rel="next" title="FAQ" href="faq.html"/>
+ <link rel="prev" title="Videos" href="videos.html"/>
+
+
+ <script src="_static/js/modernizr.min.js"></script>
+
+</head>
+
+<body class="wy-body-for-nav" role="document">
+
+
+ <div class="wy-grid-for-nav">
+
+
+ <nav data-toggle="wy-nav-shift" class="wy-nav-side">
+ <div class="wy-side-scroll">
+ <div class="wy-side-nav-search">
+
+
+
+ <a href="index.html" class="icon icon-home"> Apache Superset
+
+
+
+ </a>
+
+
+
+
+
+
+
+<div role="search">
+ <form id="rtd-search-form" class="wy-form" action="search.html" method="get">
+ <input type="text" name="q" placeholder="Search docs" />
+ <input type="hidden" name="check_keywords" value="yes" />
+ <input type="hidden" name="area" value="default" />
+ </form>
+</div>
+
+
+ </div>
+
+ <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation">
+
+
+
+
+
+
+ <ul class="current">
+<li class="toctree-l1"><a class="reference internal" href="installation.html">Installation & Configuration</a></li>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a></li>
+<li class="toctree-l1"><a class="reference internal" href="security.html">Security</a></li>
+<li class="toctree-l1"><a class="reference internal" href="sqllab.html">SQL Lab</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
+<li class="toctree-l1 current"><a class="reference internal" href="misc.html">Misc</a><ul class="current">
+<li class="toctree-l2"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
+<li class="toctree-l2"><a class="reference internal" href="videos.html">Videos</a></li>
+<li class="toctree-l2 current"><a class="current reference internal" href="#">Importing and Exporting Datasources</a><ul>
+<li class="toctree-l3"><a class="reference internal" href="#exporting-datasources-to-yaml">Exporting Datasources to YAML</a></li>
+<li class="toctree-l3"><a class="reference internal" href="#exporting-the-complete-supported-yaml-schema">Exporting the complete supported YAML schema</a></li>
+<li class="toctree-l3"><a class="reference internal" href="#importing-datasources-from-yaml">Importing Datasources from YAML</a></li>
+</ul>
+</li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
+</ul>
+
+
+
+ </div>
+ </div>
+ </nav>
+
+ <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
+
+
+ <nav class="wy-nav-top" role="navigation" aria-label="top navigation">
+
+ <i data-toggle="wy-nav-top" class="fa fa-bars"></i>
+ <a href="index.html">Apache Superset</a>
+
+ </nav>
+
+
+
+ <div class="wy-nav-content">
+ <div class="rst-content">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+<div role="navigation" aria-label="breadcrumbs navigation">
+
+ <ul class="wy-breadcrumbs">
+
+ <li><a href="index.html">Docs</a> »</li>
+
+ <li><a href="misc.html">Misc</a> »</li>
+
+ <li>Importing and Exporting Datasources</li>
+
+
+ <li class="wy-breadcrumbs-aside">
+
+
+
+ </li>
+
+ </ul>
+
+
+ <hr/>
+</div>
+ <div role="main" class="document" itemscope="itemscope" itemtype="http://schema.org/Article">
+ <div itemprop="articleBody">
+
+ <div class="section" id="importing-and-exporting-datasources">
+<h1>Importing and Exporting Datasources<a class="headerlink" href="#importing-and-exporting-datasources" title="Permalink to this headline">¶</a></h1>
+<p>The superset cli allows you to import and export datasources from and to YAML.
+Datasources include both databases and druid clusters. The data is expected to be organized in the following hierarchy:</p>
+<div class="highlight-default"><div class="highlight"><pre><span></span>.
+├──databases
+| ├──database_1
+| | ├──table_1
+| | | ├──columns
+| | | | ├──column_1
+| | | | ├──column_2
+| | | | └──... (more columns)
+| | | └──metrics
+| | | ├──metric_1
+| | | ├──metric_2
+| | | └──... (more metrics)
+| | └── ... (more tables)
+| └── ... (more databases)
+└──druid_clusters
+ ├──cluster_1
+ | ├──datasource_1
+ | | ├──columns
+ | | | ├──column_1
+ | | | ├──column_2
+ | | | └──... (more columns)
+ | | └──metrics
+ | | ├──metric_1
+ | | ├──metric_2
+ | | └──... (more metrics)
+ | └── ... (more datasources)
+ └── ... (more clusters)
+</pre></div>
+</div>
+<div class="section" id="exporting-datasources-to-yaml">
+<h2>Exporting Datasources to YAML<a class="headerlink" href="#exporting-datasources-to-yaml" title="Permalink to this headline">¶</a></h2>
+<p>You can print your current datasources to stdout by running:</p>
+<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">superset</span> <span class="n">export_datasources</span>
+</pre></div>
+</div>
+<p>To save your datasources to a file run:</p>
+<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">superset</span> <span class="n">export_datasources</span> <span class="o">-</span><span class="n">f</span> <span class="o"><</span><span class="n">filename</span><span class="o">></span>
+</pre></div>
+</div>
+<p>By default, default (null) values will be omitted. Use the <code class="docutils literal"><span class="pre">-d</span></code> flag to include them.
+If you want back references to be included (e.g. a column to include the table id
+it belongs to) use the <code class="docutils literal"><span class="pre">-b</span></code> flag.</p>
+<p>Alternatively you can export datasources using the UI:</p>
+<ol class="arabic simple">
+<li>Open <strong>Sources</strong> -> <strong>Databases</strong> to export all tables associated to a
+single or multiple databases. (<strong>Tables</strong> for one or more tables,
+<strong>Druid Clusters</strong> for clusters, <strong>Druid Datasources</strong> for datasources)</li>
+<li>Select the items you would like to export</li>
+<li>Click <strong>Actions</strong> -> <strong>Export to YAML</strong></li>
+<li>If you want to import an item that you exported through the UI, you
+will need to nest it inside its parent element, e.g. a <cite>database</cite>
+needs to be nested under <cite>databases</cite> a <cite>table</cite> needs to be
+nested inside a <cite>database</cite> element.</li>
+</ol>
+</div>
+<div class="section" id="exporting-the-complete-supported-yaml-schema">
+<h2>Exporting the complete supported YAML schema<a class="headerlink" href="#exporting-the-complete-supported-yaml-schema" title="Permalink to this headline">¶</a></h2>
+<p>In order to obtain an exhaustive list of all fields you can import using the YAML import run:</p>
+<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">superset</span> <span class="n">export_datasource_schema</span>
+</pre></div>
+</div>
+<p>Again, you can use the <code class="docutils literal"><span class="pre">-b</span></code> flag to include back references.</p>
+</div>
+<div class="section" id="importing-datasources-from-yaml">
+<h2>Importing Datasources from YAML<a class="headerlink" href="#importing-datasources-from-yaml" title="Permalink to this headline">¶</a></h2>
+<p>In order to import datasources from a YAML file(s), run:</p>
+<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">superset</span> <span class="n">import_datasources</span> <span class="o">-</span><span class="n">p</span> <span class="o"><</span><span class="n">path</span> <span class="ow">or</span> <span class="n">filename</span><span class="o">></span>
+</pre></div>
+</div>
+<p>If you supply a path all files ending with <code class="docutils literal"><span class="pre">*.yaml</span></code> or <code class="docutils literal"><span class="pre">*.yml</span></code> will be parsed.
+You can apply additional flags e.g.:</p>
+<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">superset</span> <span class="n">import_datasources</span> <span class="o">-</span><span class="n">p</span> <span class="o"><</span><span class="n">path</span><span class="o">></span> <span class="o">-</span><span class="n">r</span>
+</pre></div>
+</div>
+<p>Will search the supplied path recursively.</p>
+<p>The sync flag <code class="docutils literal"><span class="pre">-s</span></code> takes parameters in order to sync the supplied elements with
+your file. Be careful this can delete the contents of your meta database. Example:</p>
+<blockquote>
+<div>superset import_datasources -p <path / filename> -s columns,metrics</div></blockquote>
+<p>This will sync all <code class="docutils literal"><span class="pre">metrics</span></code> and <code class="docutils literal"><span class="pre">columns</span></code> for all datasources found in the
+<code class="docutils literal"><span class="pre"><path</span> <span class="pre">/</span> <span class="pre">filename></span></code> in the Superset meta database. This means columns and metrics
+not specified in YAML will be deleted. If you would add <code class="docutils literal"><span class="pre">tables</span></code> to <code class="docutils literal"><span class="pre">columns,metrics</span></code>
+those would be synchronised as well.</p>
+<p>If you don’t supply the sync flag (<code class="docutils literal"><span class="pre">-s</span></code>) importing will only add and update (override) fields.
+E.g. you can add a <code class="docutils literal"><span class="pre">verbose_name</span></code> to the the column <code class="docutils literal"><span class="pre">ds</span></code> in the table <code class="docutils literal"><span class="pre">random_time_series</span></code> from the example datasets
+by saving the following YAML to file and then running the <code class="docutils literal"><span class="pre">import_datasources</span></code> command.</p>
+<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">databases</span><span class="p">:</span>
+<span class="o">-</span> <span class="n">database_name</span><span class="p">:</span> <span class="n">main</span>
+ <span class="n">tables</span><span class="p">:</span>
+ <span class="o">-</span> <span class="n">table_name</span><span class="p">:</span> <span class="n">random_time_series</span>
+ <span class="n">columns</span><span class="p">:</span>
+ <span class="o">-</span> <span class="n">column_name</span><span class="p">:</span> <span class="n">ds</span>
+ <span class="n">verbose_name</span><span class="p">:</span> <span class="n">datetime</span>
+</pre></div>
+</div>
+</div>
+</div>
+
+
+ </div>
+ <div class="articleComments">
+
+ </div>
+ </div>
+ <footer>
+
+ <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
+
+ <a href="faq.html" class="btn btn-neutral float-right" title="FAQ" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
+
+
+ <a href="videos.html" class="btn btn-neutral" title="Videos" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+
+ </div>
+
+
+ <hr/>
+
+ <div role="contentinfo">
+ <p>
+
+ </p>
+ </div>
+ Built with <a href="http://sphinx-doc.org/">Sphinx</a> using a <a href="https://github.com/snide/sphinx_rtd_theme">theme</a> provided by <a href="https://readthedocs.org">Read the Docs</a>.
+
+</footer>
+
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+
+
+
+
+ <script type="text/javascript">
+ var DOCUMENTATION_OPTIONS = {
+ URL_ROOT:'./',
+ VERSION:'',
+ COLLAPSE_INDEX:false,
+ FILE_SUFFIX:'.html',
+ HAS_SOURCE: true,
+ SOURCELINK_SUFFIX: '.txt'
+ };
+ </script>
+ <script type="text/javascript" src="_static/jquery.js"></script>
+ <script type="text/javascript" src="_static/underscore.js"></script>
+ <script type="text/javascript" src="_static/doctools.js"></script>
+
+
+
+
+
+ <script type="text/javascript" src="_static/js/theme.js"></script>
+
+
+
+
+ <script type="text/javascript">
+ jQuery(function () {
+ SphinxRtdTheme.StickyNav.enable();
+ });
+ </script>
+
+
+</body>
+</html>
\ No newline at end of file
diff --git a/index.html b/index.html
index 1d343ef..e8438d7 100644
--- a/index.html
+++ b/index.html
@@ -87,13 +87,12 @@
<ul>
<li class="toctree-l1"><a class="reference internal" href="installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1"><a class="reference internal" href="security.html">Security</a></li>
<li class="toctree-l1"><a class="reference internal" href="sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a></li>
-<li class="toctree-l1"><a class="reference internal" href="gallery.html">Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
+<li class="toctree-l1"><a class="reference internal" href="misc.html">Misc</a></li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
</ul>
@@ -199,12 +198,16 @@ to the user</li>
<li>Integration with most SQL-speaking RDBMS through SQLAlchemy</li>
<li>Deep integration with Druid.io</li>
</ul>
+</div>
+<div class="section" id="screenshots">
+<h3>Screenshots<a class="headerlink" href="#screenshots" title="Permalink to this headline">¶</a></h3>
+<img alt="_images/bank_dash.png" src="_images/bank_dash.png" />
<hr class="docutils" />
-<img alt="https://camo.githubusercontent.com/82e264ef777ba06e1858766fe3b8817ee108eb7e/687474703a2f2f672e7265636f726469742e636f2f784658537661475574732e676966" src="https://camo.githubusercontent.com/82e264ef777ba06e1858766fe3b8817ee108eb7e/687474703a2f2f672e7265636f726469742e636f2f784658537661475574732e676966" />
+<img alt="_images/explore.png" src="_images/explore.png" />
<hr class="docutils" />
-<img alt="https://camo.githubusercontent.com/4991ff37a0005ea4e4267919a52786fda82d2d21/687474703a2f2f672e7265636f726469742e636f2f755a6767594f645235672e676966" src="https://camo.githubusercontent.com/4991ff37a0005ea4e4267919a52786fda82d2d21/687474703a2f2f672e7265636f726469742e636f2f755a6767594f645235672e676966" />
+<img alt="_images/sqllab.png" src="_images/sqllab.png" />
<hr class="docutils" />
-<img alt="https://camo.githubusercontent.com/a389af15ac1e32a3d0fee941b4c62c850b1d583b/687474703a2f2f672e7265636f726469742e636f2f55373046574c704c76682e676966" src="https://camo.githubusercontent.com/a389af15ac1e32a3d0fee941b4c62c850b1d583b/687474703a2f2f672e7265636f726469742e636f2f55373046574c704c76682e676966" />
+<img alt="_images/deckgl_dash.png" src="_images/deckgl_dash.png" />
</div>
<hr class="docutils" />
<div class="section" id="contents">
@@ -219,6 +222,7 @@ to the user</li>
<li class="toctree-l2"><a class="reference internal" href="installation.html#python-s-setup-tools-and-pip">Python’s setup tools and pip</a></li>
<li class="toctree-l2"><a class="reference internal" href="installation.html#superset-installation-and-initialization">Superset installation and initialization</a></li>
<li class="toctree-l2"><a class="reference internal" href="installation.html#a-proper-wsgi-http-server">A proper WSGI HTTP Server</a></li>
+<li class="toctree-l2"><a class="reference internal" href="installation.html#flask-appbuilder-permissions">Flask-AppBuilder Permissions</a></li>
<li class="toctree-l2"><a class="reference internal" href="installation.html#configuration-behind-a-load-balancer">Configuration behind a load balancer</a></li>
<li class="toctree-l2"><a class="reference internal" href="installation.html#configuration">Configuration</a></li>
<li class="toctree-l2"><a class="reference internal" href="installation.html#database-dependencies">Database dependencies</a></li>
@@ -238,7 +242,7 @@ to the user</li>
<li class="toctree-l2"><a class="reference internal" href="installation.html#statsd-logging">StatsD logging</a></li>
</ul>
</li>
-<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial for Superset Administrators</a><ul>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a><ul>
<li class="toctree-l2"><a class="reference internal" href="tutorial.html#connecting-to-a-new-database">Connecting to a new database</a></li>
<li class="toctree-l2"><a class="reference internal" href="tutorial.html#adding-a-new-table">Adding a new table</a></li>
<li class="toctree-l2"><a class="reference internal" href="tutorial.html#exploring-your-data">Exploring your data</a></li>
@@ -257,32 +261,24 @@ to the user</li>
<li class="toctree-l2"><a class="reference internal" href="sqllab.html#templating-with-jinja">Templating with Jinja</a></li>
</ul>
</li>
-<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a><ul>
-<li class="toctree-l2"><a class="reference internal" href="visualization.html#country-map-tools">Country Map Tools</a></li>
-<li class="toctree-l2"><a class="reference internal" href="visualization.html#list-of-countries">List of Countries</a></li>
-<li class="toctree-l2"><a class="reference internal" href="visualization.html#you-need-to-add-a-new-country">You need to add a new Country ?</a></li>
-</ul>
-</li>
-<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a><ul>
-<li class="toctree-l2"><a class="reference internal" href="videos.html#quick-intro">Quick Intro</a></li>
-<li class="toctree-l2"><a class="reference internal" href="videos.html#dashboard-creation">Dashboard Creation</a></li>
-<li class="toctree-l2"><a class="reference internal" href="videos.html#dashboard-filtering">Dashboard Filtering</a></li>
-<li class="toctree-l2"><a class="reference internal" href="videos.html#customize-css-and-dashboard-themes">Customize CSS and dashboard themes</a></li>
-<li class="toctree-l2"><a class="reference internal" href="videos.html#slice-annotations">Slice Annotations</a></li>
-<li class="toctree-l2"><a class="reference internal" href="videos.html#adding-a-table">Adding a Table</a></li>
-<li class="toctree-l2"><a class="reference internal" href="videos.html#define-sql-expressions">Define SQL Expressions</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="druid.html#aggregations">Aggregations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="druid.html#post-aggregations">Post-Aggregations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="druid.html#unsupported-features">Unsupported Features</a></li>
</ul>
</li>
-<li class="toctree-l1"><a class="reference internal" href="gallery.html">Gallery</a></li>
-<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a><ul>
-<li class="toctree-l2"><a class="reference internal" href="druid.html#supported">Supported</a></li>
-<li class="toctree-l2"><a class="reference internal" href="druid.html#not-yet-supported">Not yet supported</a></li>
+<li class="toctree-l1"><a class="reference internal" href="misc.html">Misc</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
+<li class="toctree-l2"><a class="reference internal" href="videos.html">Videos</a></li>
+<li class="toctree-l2"><a class="reference internal" href="import_export_datasources.html">Importing and Exporting Datasources</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a><ul>
<li class="toctree-l2"><a class="reference internal" href="faq.html#can-i-query-join-multiple-tables-at-one-time">Can I query/join multiple tables at one time?</a></li>
<li class="toctree-l2"><a class="reference internal" href="faq.html#how-big-can-my-data-source-be">How BIG can my data source be?</a></li>
<li class="toctree-l2"><a class="reference internal" href="faq.html#how-do-i-create-my-own-visualization">How do I create my own visualization?</a></li>
+<li class="toctree-l2"><a class="reference internal" href="faq.html#can-i-upload-and-visualize-csv-data">Can I upload and visualize csv data?</a></li>
<li class="toctree-l2"><a class="reference internal" href="faq.html#why-are-my-queries-timing-out">Why are my queries timing out?</a></li>
<li class="toctree-l2"><a class="reference internal" href="faq.html#why-is-the-map-not-visible-in-the-mapbox-visualization">Why is the map not visible in the mapbox visualization?</a></li>
<li class="toctree-l2"><a class="reference internal" href="faq.html#how-to-add-dynamic-filters-to-a-dashboard">How to add dynamic filters to a dashboard?</a></li>
@@ -294,6 +290,7 @@ to the user</li>
<li class="toctree-l2"><a class="reference internal" href="faq.html#how-can-i-configure-oauth-authentication-and-authorization">How can i configure OAuth authentication and authorization?</a></li>
<li class="toctree-l2"><a class="reference internal" href="faq.html#how-can-i-set-a-default-filter-on-my-dashboard">How can I set a default filter on my dashboard?</a></li>
<li class="toctree-l2"><a class="reference internal" href="faq.html#how-do-i-get-superset-to-refresh-the-schema-of-my-table">How do I get Superset to refresh the schema of my table?</a></li>
+<li class="toctree-l2"><a class="reference internal" href="faq.html#is-there-a-way-to-force-the-use-specific-colors">Is there a way to force the use specific colors?</a></li>
</ul>
</li>
</ul>
diff --git a/installation.html b/installation.html
index cf2d0a3..cce68a8 100644
--- a/installation.html
+++ b/installation.html
@@ -36,7 +36,7 @@
href="genindex.html"/>
<link rel="search" title="Search" href="search.html"/>
<link rel="top" title="Apache Superset documentation" href="index.html"/>
- <link rel="next" title="Tutorial for Superset Administrators" href="tutorial.html"/>
+ <link rel="next" title="Tutorial - Creating your first dashboard" href="tutorial.html"/>
<link rel="prev" title="Apache Superset (incubating)" href="index.html"/>
@@ -95,6 +95,7 @@
<li class="toctree-l2"><a class="reference internal" href="#python-s-setup-tools-and-pip">Python’s setup tools and pip</a></li>
<li class="toctree-l2"><a class="reference internal" href="#superset-installation-and-initialization">Superset installation and initialization</a></li>
<li class="toctree-l2"><a class="reference internal" href="#a-proper-wsgi-http-server">A proper WSGI HTTP Server</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#flask-appbuilder-permissions">Flask-AppBuilder Permissions</a></li>
<li class="toctree-l2"><a class="reference internal" href="#configuration-behind-a-load-balancer">Configuration behind a load balancer</a></li>
<li class="toctree-l2"><a class="reference internal" href="#configuration">Configuration</a></li>
<li class="toctree-l2"><a class="reference internal" href="#database-dependencies">Database dependencies</a></li>
@@ -114,13 +115,12 @@
<li class="toctree-l2"><a class="reference internal" href="#statsd-logging">StatsD logging</a></li>
</ul>
</li>
-<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1"><a class="reference internal" href="security.html">Security</a></li>
<li class="toctree-l1"><a class="reference internal" href="sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a></li>
-<li class="toctree-l1"><a class="reference internal" href="gallery.html">Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
+<li class="toctree-l1"><a class="reference internal" href="misc.html">Misc</a></li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
</ul>
@@ -229,6 +229,10 @@ the required dependencies are installed:</p>
<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">sudo</span> <span class="n">apt</span><span class="o">-</span><span class="n">get</span> <span class="n">install</span> <span class="n">build</span><span class="o">-</span><span class="n">essential</span> <span class="n">libssl</span><span class="o">-</span><span class="n">dev</span> <span class="n">libffi</span><span class="o">-</span><span class="n">dev</span> <span class="n">python</span><span clas [...]
</pre></div>
</div>
+<p><strong>Ubuntu 16.04</strong> If you have python3.5 installed alongside with python2.7, as is default on <strong>Ubuntu 16.04 LTS</strong>, run this command also</p>
+<blockquote>
+<div>sudo apt-get install build-essential libssl-dev libffi-dev python3.5-dev python-pip libsasl2-dev libldap2-dev</div></blockquote>
+<p>otherwhise build for <code class="docutils literal"><span class="pre">cryptography</span></code> fails.</p>
<p>For <strong>Fedora</strong> and <strong>RHEL-derivatives</strong>, the following command will ensure
that the required dependencies are installed:</p>
<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">sudo</span> <span class="n">yum</span> <span class="n">upgrade</span> <span class="n">python</span><span class="o">-</span><span class="n">setuptools</span>
@@ -296,10 +300,7 @@ and <code class="docutils literal"><span class="pre">setuptools</span></code> li
<span class="c1"># Create default roles and permissions</span>
<span class="n">superset</span> <span class="n">init</span>
-<span class="c1"># Start the web server on port 8088, use -p to bind to another port</span>
-<span class="n">superset</span> <span class="n">runserver</span>
-
-<span class="c1"># To start a development web server, use the -d switch</span>
+<span class="c1"># To start a development web server on port 8088, use -p to bind to another port</span>
<span class="c1"># superset runserver -d</span>
</pre></div>
</div>
@@ -317,29 +318,47 @@ Gunicorn, preferably in <strong>async mode</strong>, which allows for impressive
concurrency even and is fairly easy to install and configure. Please
refer to the
documentation of your preferred technology to set up this Flask WSGI
-application in a way that works well in your environment.</p>
-<p>While the <cite>superset runserver</cite> command act as an quick wrapper
-around <cite>gunicorn</cite>, it doesn’t expose all the options you may need,
-so you’ll want to craft your own <cite>gunicorn</cite> command in your production
-environment. Here’s an <strong>async</strong> setup known to work well:</p>
+application in a way that works well in your environment. Here’s an <strong>async</strong>
+setup known to work well in production:</p>
<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">gunicorn</span> \
- <span class="o">-</span><span class="n">w</span> <span class="mi">10</span> \
- <span class="o">-</span><span class="n">k</span> <span class="n">gevent</span> \
- <span class="o">--</span><span class="n">timeout</span> <span class="mi">120</span> \
- <span class="o">-</span><span class="n">b</span> <span class="mf">0.0</span><span class="o">.</span><span class="mf">0.0</span><span class="p">:</span><span class="mi">6666</span> \
- <span class="o">--</span><span class="n">limit</span><span class="o">-</span><span class="n">request</span><span class="o">-</span><span class="n">line</span> <span class="mi">0</span> \
- <span class="o">--</span><span class="n">limit</span><span class="o">-</span><span class="n">request</span><span class="o">-</span><span class="n">field_size</span> <span class="mi">0</span> \
- <span class="o">--</span><span class="n">statsd</span><span class="o">-</span><span class="n">host</span> <span class="n">localhost</span><span class="p">:</span><span class="mi">8125</span> \
- <span class="n">superset</span><span class="p">:</span><span class="n">app</span>
+ <span class="o">-</span><span class="n">w</span> <span class="mi">10</span> \
+ <span class="o">-</span><span class="n">k</span> <span class="n">gevent</span> \
+ <span class="o">--</span><span class="n">timeout</span> <span class="mi">120</span> \
+ <span class="o">-</span><span class="n">b</span> <span class="mf">0.0</span><span class="o">.</span><span class="mf">0.0</span><span class="p">:</span><span class="mi">6666</span> \
+ <span class="o">--</span><span class="n">limit</span><span class="o">-</span><span class="n">request</span><span class="o">-</span><span class="n">line</span> <span class="mi">0</span> \
+ <span class="o">--</span><span class="n">limit</span><span class="o">-</span><span class="n">request</span><span class="o">-</span><span class="n">field_size</span> <span class="mi">0</span> \
+ <span class="o">--</span><span class="n">statsd</span><span class="o">-</span><span class="n">host</span> <span class="n">localhost</span><span class="p">:</span><span class="mi">8125</span> \
+ <span class="n">superset</span><span class="p">:</span><span class="n">app</span>
</pre></div>
</div>
<p>Refer to the
-[Gunicorn documentation](<a class="reference external" href="http://docs.gunicorn.org/en/stable/design.html">http://docs.gunicorn.org/en/stable/design.html</a>)
+<a class="reference external" href="http://docs.gunicorn.org/en/stable/design.html">Gunicorn documentation</a>
for more information.</p>
<p>Note that <em>gunicorn</em> does not
work on Windows so the <cite>superset runserver</cite> command is not expected to work
in that context. Also note that the development web
server (<cite>superset runserver -d</cite>) is not intended for production use.</p>
+<p>If not using gunicorn, you may want to disable the use of flask-compress
+by setting <cite>ENABLE_FLASK_COMPRESS = False</cite> in your <cite>superset_config.py</cite></p>
+</div>
+<div class="section" id="flask-appbuilder-permissions">
+<h2>Flask-AppBuilder Permissions<a class="headerlink" href="#flask-appbuilder-permissions" title="Permalink to this headline">¶</a></h2>
+<p>By default every time the Flask-AppBuilder (FAB) app is initialized the
+permissions and views are added automatically to the backend and associated with
+the ‘Admin’ role. The issue however is when you are running multiple concurrent
+workers this creates a lot of contention and race conditions when defining
+permissions and views.</p>
+<p>To alleviate this issue, the automatic updating of permissions can be disabled
+by setting the <span class="target" id="index-0"></span><code class="xref std std-envvar docutils literal"><span class="pre">SUPERSET_UPDATE_PERMS</span></code> environment variable to <cite>0</cite>.
+The value <cite>1</cite> enables it, <cite>0</cite> disables it. Note if undefined the functionality
+is enabled to maintain backwards compatibility.</p>
+<p>In a production environment initialization could take on the following form:</p>
+<blockquote>
+<div><p>export SUPERSET_UPDATE_PERMS=1
+superset init</p>
+<p>export SUPERSET_UPDATE_PERMS=0
+gunicorn -w 10 … superset:app</p>
+</div></blockquote>
</div>
<div class="section" id="configuration-behind-a-load-balancer">
<h2>Configuration behind a load balancer<a class="headerlink" href="#configuration-behind-a-load-balancer" title="Permalink to this headline">¶</a></h2>
@@ -351,6 +370,12 @@ webserver is running.</p>
<p>If the load balancer is inserting X-Forwarded-For/X-Forwarded-Proto headers, you
should set <cite>ENABLE_PROXY_FIX = True</cite> in the superset config file to extract and use
the headers.</p>
+<p>In case that the reverse proxy is used for providing ssl encryption,
+an explicit definition of the <cite>X-Forwarded-Proto</cite> may be required.
+For the Apache webserver this can be set as follows:</p>
+<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">RequestHeader</span> <span class="nb">set</span> <span class="n">X</span><span class="o">-</span><span class="n">Forwarded</span><span class="o">-</span><span class="n">Proto</span> <span class="s2">"https"</span>
+</pre></div>
+</div>
</div>
<div class="section" id="configuration">
<h2>Configuration<a class="headerlink" href="#configuration" title="Permalink to this headline">¶</a></h2>
@@ -361,7 +386,6 @@ of the parameters you can copy / paste in that configuration module:</p>
<span class="c1"># Superset specific config</span>
<span class="c1">#---------------------------------------------------------</span>
<span class="n">ROW_LIMIT</span> <span class="o">=</span> <span class="mi">5000</span>
-<span class="n">SUPERSET_WORKERS</span> <span class="o">=</span> <span class="mi">4</span>
<span class="n">SUPERSET_WEBSERVER_PORT</span> <span class="o">=</span> <span class="mi">8088</span>
<span class="c1">#---------------------------------------------------------</span>
@@ -383,16 +407,27 @@ of the parameters you can copy / paste in that configuration module:</p>
<span class="n">WTF_CSRF_ENABLED</span> <span class="o">=</span> <span class="kc">True</span>
<span class="c1"># Add endpoints that need to be exempt from CSRF protection</span>
<span class="n">WTF_CSRF_EXEMPT_LIST</span> <span class="o">=</span> <span class="p">[]</span>
+<span class="c1"># A CSRF token that expires in 1 year</span>
+<span class="n">WTF_CSRF_TIME_LIMIT</span> <span class="o">=</span> <span class="mi">60</span> <span class="o">*</span> <span class="mi">60</span> <span class="o">*</span> <span class="mi">24</span> <span class="o">*</span> <span class="mi">365</span>
<span class="c1"># Set this API key to enable Mapbox visualizations</span>
<span class="n">MAPBOX_API_KEY</span> <span class="o">=</span> <span class="s1">''</span>
</pre></div>
</div>
-<p>This file also allows you to define configuration parameters used by
-Flask App Builder, the web framework used by Superset. Please consult
+<p>All the parameters and default values defined in
+<a class="reference external" href="https://github.com/apache/incubator-superset/blob/master/superset/config.py">https://github.com/apache/incubator-superset/blob/master/superset/config.py</a>
+can be altered in your local <code class="docutils literal"><span class="pre">superset_config.py</span></code> .
+Administrators will want to
+read through the file to understand what can be configured locally
+as well as the default values in place.</p>
+<p>Since <code class="docutils literal"><span class="pre">superset_config.py</span></code> acts as a Flask configuration module, it
+can be used to alter the settings Flask itself,
+as well as Flask extensions like <code class="docutils literal"><span class="pre">flask-wtf</span></code>, <code class="docutils literal"><span class="pre">flask-cache</span></code>,
+<code class="docutils literal"><span class="pre">flask-migrate</span></code>, and <code class="docutils literal"><span class="pre">flask-appbuilder</span></code>. Flask App Builder, the web
+framework used by Superset offers many configuration settings. Please consult
the <a class="reference external" href="http://flask-appbuilder.readthedocs.org/en/latest/config.html">Flask App Builder Documentation</a>
-for more information on how to configure Superset.</p>
-<p>Please make sure to change:</p>
+for more information on how to configure it.</p>
+<p>Make sure to change:</p>
<ul class="simple">
<li><em>SQLALCHEMY_DATABASE_URI</em>, by default it is stored at <em>~/.superset/superset.db</em></li>
<li><em>SECRET_KEY</em>, to a long random string</li>
@@ -445,7 +480,7 @@ connect to the databases you want to access through Superset.</p>
</tr>
<tr class="row-odd"><td>Redshift</td>
<td><code class="docutils literal"><span class="pre">pip</span> <span class="pre">install</span> <span class="pre">sqlalchemy-redshift</span></code></td>
-<td><code class="docutils literal"><span class="pre">postgresql+psycopg2://</span></code></td>
+<td><code class="docutils literal"><span class="pre">redshift+psycopg2://</span></code></td>
</tr>
<tr class="row-even"><td>MSSQL</td>
<td><code class="docutils literal"><span class="pre">pip</span> <span class="pre">install</span> <span class="pre">pymssql</span></code></td>
@@ -477,6 +512,10 @@ connect to the databases you want to access through Superset.</p>
<span class="pre">sqlalchemy-clickhouse</span></code></td>
<td><code class="docutils literal"><span class="pre">clickhouse://</span></code></td>
</tr>
+<tr class="row-odd"><td>Kylin</td>
+<td><code class="docutils literal"><span class="pre">pip</span> <span class="pre">install</span> <span class="pre">kylinpy</span></code></td>
+<td><code class="docutils literal"><span class="pre">kylin://</span></code></td>
+</tr>
</tbody>
</table>
<p>Note that many other database are supported, the main criteria being the
@@ -513,6 +552,14 @@ the <a class="reference external" href="https://pypi.python.org/pypi/redis">redi
up the “timeout searchpath”, from your slice configuration, to your
data source’s configuration, to your database’s and ultimately falls back
into your global default defined in <code class="docutils literal"><span class="pre">CACHE_CONFIG</span></code>.</p>
+<div class="highlight-python"><div class="highlight"><pre><span></span><span class="n">CACHE_CONFIG</span> <span class="o">=</span> <span class="p">{</span>
+ <span class="s1">'CACHE_TYPE'</span><span class="p">:</span> <span class="s1">'redis'</span><span class="p">,</span>
+ <span class="s1">'CACHE_DEFAULT_TIMEOUT'</span><span class="p">:</span> <span class="mi">60</span> <span class="o">*</span> <span class="mi">60</span> <span class="o">*</span> <span class="mi">24</span><span class="p">,</span> <span class="c1"># 1 day default (in secs)</span>
+ <span class="s1">'CACHE_KEY_PREFIX'</span><span class="p">:</span> <span class="s1">'superset_results'</span><span class="p">,</span>
+ <span class="s1">'CACHE_REDIS_URL'</span><span class="p">:</span> <span class="s1">'redis://localhost:6379/0'</span><span class="p">,</span>
+ <span class="p">}</span>
+</pre></div>
+</div>
</div>
<div class="section" id="deeper-sqlalchemy-integration">
<h2>Deeper SQLAlchemy integration<a class="headerlink" href="#deeper-sqlalchemy-integration" title="Permalink to this headline">¶</a></h2>
@@ -549,6 +596,16 @@ in your config file to point to that function.</p>
<span class="n">SQLALCHEMY_CUSTOM_PASSWORD_STORE</span> <span class="o">=</span> <span class="n">example_lookup_password</span>
</pre></div>
</div>
+<p>A common pattern is to use environment variables to make secrets available.
+<code class="docutils literal"><span class="pre">SQLALCHEMY_CUSTOM_PASSWORD_STORE</span></code> can also be used for that purpose.</p>
+<div class="highlight-default"><div class="highlight"><pre><span></span><span class="k">def</span> <span class="nf">example_password_as_env_var</span><span class="p">(</span><span class="n">url</span><span class="p">):</span>
+ <span class="c1"># assuming the uri looks like</span>
+ <span class="c1"># mysql://localhost?superset_user:{SUPERSET_PASSWORD}</span>
+ <span class="k">return</span> <span class="n">url</span><span class="o">.</span><span class="n">password</span><span class="o">.</span><span class="n">format</span><span class="p">(</span><span class="n">os</span><span class="o">.</span><span class="n">environ</span><span class="p">)</span>
+
+<span class="n">SQLALCHEMY_CUSTOM_PASSWORD_STORE</span> <span class="o">=</span> <span class="n">example_password_as_env_var</span>
+</pre></div>
+</div>
</div>
<div class="section" id="ssl-access-to-databases">
<h2>SSL Access to databases<a class="headerlink" href="#ssl-access-to-databases" title="Permalink to this headline">¶</a></h2>
@@ -634,8 +691,8 @@ execute beyond the typical web request’s timeout (30-60 seconds), it is
necessary to configure an asynchronous backend for Superset which consist of:</p>
<ul class="simple">
<li>one or many Superset worker (which is implemented as a Celery worker), and
-can be started with the <code class="docutils literal"><span class="pre">superset</span> <span class="pre">worker</span></code> command, run
-<code class="docutils literal"><span class="pre">superset</span> <span class="pre">worker</span> <span class="pre">--help</span></code> to view the related options</li>
+can be started with the <code class="docutils literal"><span class="pre">celery</span> <span class="pre">worker</span></code> command, run
+<code class="docutils literal"><span class="pre">celery</span> <span class="pre">worker</span> <span class="pre">--help</span></code> to view the related options.</li>
<li>a celery broker (message queue) for which we recommend using Redis
or RabbitMQ</li>
<li>a results backend that defines where the worker will persist the query
@@ -653,6 +710,10 @@ have the same configuration.</p>
<span class="n">CELERY_CONFIG</span> <span class="o">=</span> <span class="n">CeleryConfig</span>
</pre></div>
</div>
+<p>To start a Celery worker to leverage the configuration run:</p>
+<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">celery</span> <span class="n">worker</span> <span class="o">--</span><span class="n">app</span><span class="o">=</span><span class="n">superset</span><span class="o">.</span><span class="n">sql_lab</span><span class="p">:</span><span class="n">celery_app</span> <span class="o">--</span><span class="n">pool</span><span class="o">=</span><span class="n">gevent</span> <span class="o">-</span><span class= [...]
+</pre></div>
+</div>
<p>To setup a result backend, you need to pass an instance of a derivative
of <code class="docutils literal"><span class="pre">werkzeug.contrib.cache.BaseCache</span></code> to the <code class="docutils literal"><span class="pre">RESULTS_BACKEND</span></code>
configuration key in your <code class="docutils literal"><span class="pre">superset_config.py</span></code>. It’s possible to use
@@ -672,6 +733,11 @@ look something like:</p>
<span class="n">host</span><span class="o">=</span><span class="s1">'localhost'</span><span class="p">,</span> <span class="n">port</span><span class="o">=</span><span class="mi">6379</span><span class="p">,</span> <span class="n">key_prefix</span><span class="o">=</span><span class="s1">'superset_results'</span><span class="p">)</span>
</pre></div>
</div>
+<p>Note that it’s important that all the worker nodes and web servers in
+the Superset cluster share a common metadata database.
+This means that SQLite will not work in this context since it has
+limited support for concurrency and
+typically lives on the local file system.</p>
<p>Also note that SQL Lab supports Jinja templating in queries, and that it’s
possible to overload
the default Jinja context in your environment by defining the
@@ -682,6 +748,15 @@ in this dictionary are made available for users to use in their SQL.</p>
<span class="p">}</span>
</pre></div>
</div>
+<p>Flower is a web based tool for monitoring the Celery cluster which you can
+install from pip:</p>
+<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">pip</span> <span class="n">install</span> <span class="n">flower</span>
+</pre></div>
+</div>
+<p>and run via:</p>
+<div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">celery</span> <span class="n">flower</span> <span class="o">--</span><span class="n">app</span><span class="o">=</span><span class="n">superset</span><span class="o">.</span><span class="n">sql_lab</span><span class="p">:</span><span class="n">celery_app</span>
+</pre></div>
+</div>
</div>
<div class="section" id="making-your-own-build">
<h2>Making your own build<a class="headerlink" href="#making-your-own-build" title="Permalink to this headline">¶</a></h2>
@@ -707,12 +782,11 @@ so, you can expect Superset to serve a page that says “OK”
at the <code class="docutils literal"><span class="pre">/simple_page</span></code> url. This can allow you to run other things such
as custom data visualization applications alongside Superset, on the
same server.</p>
-<p>..code</p>
-<div class="highlight-default"><div class="highlight"><pre><span></span><span class="kn">from</span> <span class="nn">flask</span> <span class="k">import</span> <span class="n">Blueprint</span>
+<div class="highlight-python"><div class="highlight"><pre><span></span><span class="kn">from</span> <span class="nn">flask</span> <span class="kn">import</span> <span class="n">Blueprint</span>
<span class="n">simple_page</span> <span class="o">=</span> <span class="n">Blueprint</span><span class="p">(</span><span class="s1">'simple_page'</span><span class="p">,</span> <span class="vm">__name__</span><span class="p">,</span>
<span class="n">template_folder</span><span class="o">=</span><span class="s1">'templates'</span><span class="p">)</span>
-<span class="nd">@simple_page</span><span class="o">.</span><span class="n">route</span><span class="p">(</span><span class="s1">'/'</span><span class="p">,</span> <span class="n">defaults</span><span class="o">=</span><span class="p">{</span><span class="s1">'page'</span><span class="p">:</span> <span class="s1">'index'</span><span class="p">})</span>
-<span class="nd">@simple_page</span><span class="o">.</span><span class="n">route</span><span class="p">(</span><span class="s1">'/<page>'</span><span class="p">)</span>
+<span class="nd">@simple_page.route</span><span class="p">(</span><span class="s1">'/'</span><span class="p">,</span> <span class="n">defaults</span><span class="o">=</span><span class="p">{</span><span class="s1">'page'</span><span class="p">:</span> <span class="s1">'index'</span><span class="p">})</span>
+<span class="nd">@simple_page.route</span><span class="p">(</span><span class="s1">'/<page>'</span><span class="p">)</span>
<span class="k">def</span> <span class="nf">show</span><span class="p">(</span><span class="n">page</span><span class="p">):</span>
<span class="k">return</span> <span class="s2">"Ok"</span>
@@ -726,8 +800,7 @@ same server.</p>
are logged as well as key events like query start and end in SQL Lab.</p>
<p>To setup StatsD logging, it’s a matter of configuring the logger in your
<code class="docutils literal"><span class="pre">superset_config.py</span></code>.</p>
-<p>..code</p>
-<div class="highlight-default"><div class="highlight"><pre><span></span><span class="kn">from</span> <span class="nn">superset.stats_logger</span> <span class="k">import</span> <span class="n">StatsdStatsLogger</span>
+<div class="highlight-python"><div class="highlight"><pre><span></span><span class="kn">from</span> <span class="nn">superset.stats_logger</span> <span class="kn">import</span> <span class="n">StatsdStatsLogger</span>
<span class="n">STATS_LOGGER</span> <span class="o">=</span> <span class="n">StatsdStatsLogger</span><span class="p">(</span><span class="n">host</span><span class="o">=</span><span class="s1">'localhost'</span><span class="p">,</span> <span class="n">port</span><span class="o">=</span><span class="mi">8125</span><span class="p">,</span> <span class="n">prefix</span><span class="o">=</span><span class="s1">'superset'</span><span class="p">)</span>
</pre></div>
</div>
@@ -746,7 +819,7 @@ are logged as well as key events like query start and end in SQL Lab.</p>
<div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
- <a href="tutorial.html" class="btn btn-neutral float-right" title="Tutorial for Superset Administrators" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
+ <a href="tutorial.html" class="btn btn-neutral float-right" title="Tutorial - Creating your first dashboard" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
<a href="index.html" class="btn btn-neutral" title="Apache Superset (incubating)" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
diff --git a/genindex.html b/misc.html
similarity index 63%
copy from genindex.html
copy to misc.html
index fb7d610..a35da64 100644
--- a/genindex.html
+++ b/misc.html
@@ -1,6 +1,5 @@
-
<!DOCTYPE html>
<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
<!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
@@ -9,7 +8,7 @@
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Index — Apache Superset documentation</title>
+ <title>Misc — Apache Superset documentation</title>
@@ -34,9 +33,11 @@
<link rel="index" title="Index"
- href="#"/>
+ href="genindex.html"/>
<link rel="search" title="Search" href="search.html"/>
- <link rel="top" title="Apache Superset documentation" href="index.html"/>
+ <link rel="top" title="Apache Superset documentation" href="index.html"/>
+ <link rel="next" title="Visualization Tools" href="visualization.html"/>
+ <link rel="prev" title="Druid" href="druid.html"/>
<script src="_static/js/modernizr.min.js"></script>
@@ -85,15 +86,19 @@
- <ul>
+ <ul class="current">
<li class="toctree-l1"><a class="reference internal" href="installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1"><a class="reference internal" href="security.html">Security</a></li>
<li class="toctree-l1"><a class="reference internal" href="sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a></li>
-<li class="toctree-l1"><a class="reference internal" href="gallery.html">Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
+<li class="toctree-l1 current"><a class="current reference internal" href="#">Misc</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
+<li class="toctree-l2"><a class="reference internal" href="videos.html">Videos</a></li>
+<li class="toctree-l2"><a class="reference internal" href="import_export_datasources.html">Importing and Exporting Datasources</a></li>
+</ul>
+</li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
</ul>
@@ -139,7 +144,7 @@
<li><a href="index.html">Docs</a> »</li>
- <li>Index</li>
+ <li>Misc</li>
<li class="wy-breadcrumbs-aside">
@@ -156,30 +161,26 @@
<div role="main" class="document" itemscope="itemscope" itemtype="http://schema.org/Article">
<div itemprop="articleBody">
-
-<h1 id="index">Index</h1>
-
-<div class="genindex-jumpbox">
- <a href="#P"><strong>P</strong></a>
- | <a href="#U"><strong>U</strong></a>
-
-</div>
-<h2 id="P">P</h2>
-<table style="width: 100%" class="indextable genindextable"><tr>
- <td style="width: 33%; vertical-align: top;"><ul>
- <li><a href="sqllab.html#superset.jinja_context.PrestoTemplateProcessor">PrestoTemplateProcessor (class in superset.jinja_context)</a>
+ <div class="section" id="misc">
+<h1>Misc<a class="headerlink" href="#misc" title="Permalink to this headline">¶</a></h1>
+<div class="toctree-wrapper compound">
+<ul>
+<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="visualization.html#country-map-tools">Country Map Tools</a></li>
+<li class="toctree-l2"><a class="reference internal" href="visualization.html#list-of-countries">List of Countries</a></li>
+<li class="toctree-l2"><a class="reference internal" href="visualization.html#you-need-to-add-a-new-country">You need to add a new Country ?</a></li>
+</ul>
</li>
- </ul></td>
-</tr></table>
-
-<h2 id="U">U</h2>
-<table style="width: 100%" class="indextable genindextable"><tr>
- <td style="width: 33%; vertical-align: top;"><ul>
- <li><a href="sqllab.html#superset.jinja_context.url_param">url_param() (in module superset.jinja_context)</a>
+<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a></li>
+<li class="toctree-l1"><a class="reference internal" href="import_export_datasources.html">Importing and Exporting Datasources</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="import_export_datasources.html#exporting-datasources-to-yaml">Exporting Datasources to YAML</a></li>
+<li class="toctree-l2"><a class="reference internal" href="import_export_datasources.html#exporting-the-complete-supported-yaml-schema">Exporting the complete supported YAML schema</a></li>
+<li class="toctree-l2"><a class="reference internal" href="import_export_datasources.html#importing-datasources-from-yaml">Importing Datasources from YAML</a></li>
+</ul>
</li>
- </ul></td>
-</tr></table>
-
+</ul>
+</div>
+</div>
</div>
@@ -189,6 +190,15 @@
</div>
<footer>
+ <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
+
+ <a href="visualization.html" class="btn btn-neutral float-right" title="Visualization Tools" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
+
+
+ <a href="druid.html" class="btn btn-neutral" title="Druid" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+
+ </div>
+
<hr/>
diff --git a/objects.inv b/objects.inv
index 1638831..b6a8f76 100644
Binary files a/objects.inv and b/objects.inv differ
diff --git a/search.html b/search.html
index c799646..8c68375 100644
--- a/search.html
+++ b/search.html
@@ -86,13 +86,12 @@
<ul>
<li class="toctree-l1"><a class="reference internal" href="installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1"><a class="reference internal" href="security.html">Security</a></li>
<li class="toctree-l1"><a class="reference internal" href="sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a></li>
-<li class="toctree-l1"><a class="reference internal" href="gallery.html">Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
+<li class="toctree-l1"><a class="reference internal" href="misc.html">Misc</a></li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
</ul>
diff --git a/searchindex.js b/searchindex.js
index 462ba3e..89c640c 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({docnames:["druid","faq","gallery","index","installation","security","sqllab","tutorial","videos","visualization"],envversion:52,filenames:["druid.rst","faq.rst","gallery.rst","index.rst","installation.rst","security.rst","sqllab.rst","tutorial.rst","videos.rst","visualization.rst"],objects:{"superset.jinja_context":{PrestoTemplateProcessor:[6,0,1,""],url_param:[6,1,1,""]}},objnames:{"0":["py","class","Python class"],"1":["py","function","Python function"]},objtypes:{"0": [...]
\ No newline at end of file
+Search.setIndex({docnames:["druid","faq","gallery","import_export_datasources","index","installation","misc","security","sqllab","tutorial","videos","visualization"],envversion:52,filenames:["druid.rst","faq.rst","gallery.rst","import_export_datasources.rst","index.rst","installation.rst","misc.rst","security.rst","sqllab.rst","tutorial.rst","videos.rst","visualization.rst"],objects:{"superset.jinja_context":{PrestoTemplateProcessor:[8,0,1,""],url_param:[8,1,1,""]}},objnames:{"0":["py"," [...]
\ No newline at end of file
diff --git a/security.html b/security.html
index faf53a7..5feeb8c 100644
--- a/security.html
+++ b/security.html
@@ -37,7 +37,7 @@
<link rel="search" title="Search" href="search.html"/>
<link rel="top" title="Apache Superset documentation" href="index.html"/>
<link rel="next" title="SQL Lab" href="sqllab.html"/>
- <link rel="prev" title="Tutorial for Superset Administrators" href="tutorial.html"/>
+ <link rel="prev" title="Tutorial - Creating your first dashboard" href="tutorial.html"/>
<script src="_static/js/modernizr.min.js"></script>
@@ -88,7 +88,7 @@
<ul class="current">
<li class="toctree-l1"><a class="reference internal" href="installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1 current"><a class="current reference internal" href="#">Security</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#provided-roles">Provided Roles</a><ul>
<li class="toctree-l3"><a class="reference internal" href="#admin">Admin</a></li>
@@ -108,10 +108,9 @@
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a></li>
-<li class="toctree-l1"><a class="reference internal" href="gallery.html">Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
+<li class="toctree-l1"><a class="reference internal" href="misc.html">Misc</a></li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
</ul>
@@ -184,7 +183,7 @@ Please read its <a class="reference external" href="http://flask-appbuilder.read
<h2>Provided Roles<a class="headerlink" href="#provided-roles" title="Permalink to this headline">¶</a></h2>
<p>Superset ships with a set of roles that are handled by Superset itself.
You can assume that these roles will stay up-to-date as Superset evolves.
-Even though it’s possible for <code class="docutils literal"><span class="pre">Admin</span></code> usrs to do so, it is not recommended
+Even though it’s possible for <code class="docutils literal"><span class="pre">Admin</span></code> users to do so, it is not recommended
that you alter these roles in any way by removing
or adding permissions to them as these roles will be re-synchronized to
their original values as you run your next <code class="docutils literal"><span class="pre">superset</span> <span class="pre">init</span></code> command.</p>
@@ -333,7 +332,7 @@ is dependent on revenue.</p>
<a href="sqllab.html" class="btn btn-neutral float-right" title="SQL Lab" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
- <a href="tutorial.html" class="btn btn-neutral" title="Tutorial for Superset Administrators" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+ <a href="tutorial.html" class="btn btn-neutral" title="Tutorial - Creating your first dashboard" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
</div>
diff --git a/sqllab.html b/sqllab.html
index 91f9de2..07be060 100644
--- a/sqllab.html
+++ b/sqllab.html
@@ -36,7 +36,7 @@
href="genindex.html"/>
<link rel="search" title="Search" href="search.html"/>
<link rel="top" title="Apache Superset documentation" href="index.html"/>
- <link rel="next" title="Visualization Tools" href="visualization.html"/>
+ <link rel="next" title="Visualizations Gallery" href="gallery.html"/>
<link rel="prev" title="Security" href="security.html"/>
@@ -88,21 +88,21 @@
<ul class="current">
<li class="toctree-l1"><a class="reference internal" href="installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1"><a class="reference internal" href="security.html">Security</a></li>
<li class="toctree-l1 current"><a class="current reference internal" href="#">SQL Lab</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#feature-overview">Feature Overview</a></li>
<li class="toctree-l2"><a class="reference internal" href="#extra-features">Extra features</a></li>
<li class="toctree-l2"><a class="reference internal" href="#templating-with-jinja">Templating with Jinja</a><ul>
<li class="toctree-l3"><a class="reference internal" href="#available-macros">Available macros</a></li>
+<li class="toctree-l3"><a class="reference internal" href="#extending-macros">Extending macros</a></li>
</ul>
</li>
</ul>
</li>
-<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a></li>
-<li class="toctree-l1"><a class="reference internal" href="gallery.html">Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
+<li class="toctree-l1"><a class="reference internal" href="misc.html">Misc</a></li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
</ul>
@@ -169,6 +169,9 @@
<h1>SQL Lab<a class="headerlink" href="#sql-lab" title="Permalink to this headline">¶</a></h1>
<p>SQL Lab is a modern, feature-rich SQL IDE written in
<a class="reference external" href="https://facebook.github.io/react/">React</a>.</p>
+<hr class="docutils" />
+<img alt="_images/sqllab.png" src="_images/sqllab.png" />
+<hr class="docutils" />
<div class="section" id="feature-overview">
<h2>Feature Overview<a class="headerlink" href="#feature-overview" title="Permalink to this headline">¶</a></h2>
<ul class="simple">
@@ -209,13 +212,14 @@ parameterized so they can be re-used easily.</p>
<div class="section" id="available-macros">
<h3>Available macros<a class="headerlink" href="#available-macros" title="Permalink to this headline">¶</a></h3>
<p>We expose certain modules from Python’s standard library in
-Superset’s Jinja context:
-- <code class="docutils literal"><span class="pre">time</span></code>: <code class="docutils literal"><span class="pre">time</span></code>
-- <code class="docutils literal"><span class="pre">datetime</span></code>: <code class="docutils literal"><span class="pre">datetime.datetime</span></code>
-- <code class="docutils literal"><span class="pre">uuid</span></code>: <code class="docutils literal"><span class="pre">uuid</span></code>
-- <code class="docutils literal"><span class="pre">random</span></code>: <code class="docutils literal"><span class="pre">random</span></code>
-- <code class="docutils literal"><span class="pre">relativedelta</span></code>: <code class="docutils literal"><span class="pre">dateutil.relativedelta.relativedelta</span></code>
-- more to come!</p>
+Superset’s Jinja context:</p>
+<ul class="simple">
+<li><code class="docutils literal"><span class="pre">time</span></code>: <code class="docutils literal"><span class="pre">time</span></code></li>
+<li><code class="docutils literal"><span class="pre">datetime</span></code>: <code class="docutils literal"><span class="pre">datetime.datetime</span></code></li>
+<li><code class="docutils literal"><span class="pre">uuid</span></code>: <code class="docutils literal"><span class="pre">uuid</span></code></li>
+<li><code class="docutils literal"><span class="pre">random</span></code>: <code class="docutils literal"><span class="pre">random</span></code></li>
+<li><code class="docutils literal"><span class="pre">relativedelta</span></code>: <code class="docutils literal"><span class="pre">dateutil.relativedelta.relativedelta</span></code></li>
+</ul>
<p><a class="reference external" href="http://jinja.pocoo.org/docs/dev/templates/">Jinja’s builtin filters</a> can be also be applied where needed.</p>
<dl class="class">
<dt id="superset.jinja_context.PrestoTemplateProcessor">
@@ -228,13 +232,13 @@ jinja context as in <code class="docutils literal"><span class="pre">SELECT</spa
<dl class="function">
<dt id="superset.jinja_context.url_param">
<code class="descclassname">superset.jinja_context.</code><code class="descname">url_param</code><span class="sig-paren">(</span><em>param</em>, <em>default=None</em><span class="sig-paren">)</span><a class="reference internal" href="_modules/superset/jinja_context.html#url_param"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#superset.jinja_context.url_param" title="Permalink to this definition">¶</a></dt>
-<dd><p>Get a url paramater</p>
+<dd><p>Get a url or post data parameter</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
<col class="field-body" />
<tbody valign="top">
<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first last simple">
-<li><strong>param</strong> (<em>str</em>) – the url parameter to lookup</li>
+<li><strong>param</strong> (<em>str</em>) – the parameter to lookup</li>
<li><strong>default</strong> (<em>str</em>) – the value to return in the absence of the parameter</li>
</ul>
</td>
@@ -244,6 +248,14 @@ jinja context as in <code class="docutils literal"><span class="pre">SELECT</spa
</dd></dl>
</div>
+<div class="section" id="extending-macros">
+<h3>Extending macros<a class="headerlink" href="#extending-macros" title="Permalink to this headline">¶</a></h3>
+<p>As mentioned in the <a class="reference external" href="https://superset.incubator.apache.org/installation.html#installation-configuration">Installation & Configuration</a> documentation,
+it’s possible for administrators to expose more more macros in their
+environment using the configuration variable <code class="docutils literal"><span class="pre">JINJA_CONTEXT_ADDONS</span></code>.
+All objects referenced in this dictionary will become available for users
+to integrate in their queries in <strong>SQL Lab</strong>.</p>
+</div>
</div>
</div>
@@ -257,7 +269,7 @@ jinja context as in <code class="docutils literal"><span class="pre">SELECT</spa
<div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
- <a href="visualization.html" class="btn btn-neutral float-right" title="Visualization Tools" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
+ <a href="gallery.html" class="btn btn-neutral float-right" title="Visualizations Gallery" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
<a href="security.html" class="btn btn-neutral" title="Security" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
diff --git a/tutorial.html b/tutorial.html
index 8f89955..f9bebf0 100644
--- a/tutorial.html
+++ b/tutorial.html
@@ -8,7 +8,7 @@
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Tutorial for Superset Administrators — Apache Superset documentation</title>
+ <title>Tutorial - Creating your first dashboard — Apache Superset documentation</title>
@@ -88,7 +88,7 @@
<ul class="current">
<li class="toctree-l1"><a class="reference internal" href="installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1 current"><a class="current reference internal" href="#">Tutorial for Superset Administrators</a><ul>
+<li class="toctree-l1 current"><a class="current reference internal" href="#">Tutorial - Creating your first dashboard</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#connecting-to-a-new-database">Connecting to a new database</a></li>
<li class="toctree-l2"><a class="reference internal" href="#adding-a-new-table">Adding a new table</a></li>
<li class="toctree-l2"><a class="reference internal" href="#exploring-your-data">Exploring your data</a></li>
@@ -97,10 +97,9 @@
</li>
<li class="toctree-l1"><a class="reference internal" href="security.html">Security</a></li>
<li class="toctree-l1"><a class="reference internal" href="sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a></li>
-<li class="toctree-l1"><a class="reference internal" href="gallery.html">Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
+<li class="toctree-l1"><a class="reference internal" href="misc.html">Misc</a></li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
</ul>
@@ -146,7 +145,7 @@
<li><a href="index.html">Docs</a> »</li>
- <li>Tutorial for Superset Administrators</li>
+ <li>Tutorial - Creating your first dashboard</li>
<li class="wy-breadcrumbs-aside">
@@ -163,10 +162,10 @@
<div role="main" class="document" itemscope="itemscope" itemtype="http://schema.org/Article">
<div itemprop="articleBody">
- <div class="section" id="tutorial-for-superset-administrators">
-<h1>Tutorial for Superset Administrators<a class="headerlink" href="#tutorial-for-superset-administrators" title="Permalink to this headline">¶</a></h1>
-<p>This tutorial targets a Superset administrator: someone configuring Superset
-for an organization on behalf of users. We’ll show you how to connect Superset
+ <div class="section" id="tutorial-creating-your-first-dashboard">
+<h1>Tutorial - Creating your first dashboard<a class="headerlink" href="#tutorial-creating-your-first-dashboard" title="Permalink to this headline">¶</a></h1>
+<p>This tutorial targets someone who wants to create charts and dashboards
+in Superset. We’ll show you how to connect Superset
to a new database and configure a table in that database for analysis. You’ll
also explore the data you’ve exposed and add a visualization to a dashboard
so that you get a feel for the end-to-end user experience.</p>
@@ -181,8 +180,8 @@ into a fresh DB, or configure the
we use here.</p>
<p>Under the <strong>Sources</strong> menu, select the <em>Databases</em> option:</p>
<a class="reference internal image-reference" href="_images/tutorial_01_sources_database.png"><img alt="_images/tutorial_01_sources_database.png" src="_images/tutorial_01_sources_database.png" style="width: 316.4px; height: 187.6px;" /></a>
-<p>On the resulting page, click on the green plus sign, near the top left:</p>
-<a class="reference internal image-reference" href="_images/tutorial_02_add_database.png"><img alt="_images/tutorial_02_add_database.png" src="_images/tutorial_02_add_database.png" style="width: 369.6px; height: 232.4px;" /></a>
+<p>On the resulting page, click on the green plus sign, near the top right:</p>
+<a class="reference internal image-reference" href="_images/tutorial_02_add_database.png"><img alt="_images/tutorial_02_add_database.png" src="_images/tutorial_02_add_database.png" style="width: 359.8px; height: 270.2px;" /></a>
<p>You can configure a number of advanced options on this page, but for
this walkthrough, you’ll only need to do <strong>two things</strong>:</p>
<ol class="arabic simple">
diff --git a/videos.html b/videos.html
index d28b93c..2c31885 100644
--- a/videos.html
+++ b/videos.html
@@ -36,7 +36,8 @@
href="genindex.html"/>
<link rel="search" title="Search" href="search.html"/>
<link rel="top" title="Apache Superset documentation" href="index.html"/>
- <link rel="next" title="Gallery" href="gallery.html"/>
+ <link rel="up" title="Misc" href="misc.html"/>
+ <link rel="next" title="Importing and Exporting Datasources" href="import_export_datasources.html"/>
<link rel="prev" title="Visualization Tools" href="visualization.html"/>
@@ -88,22 +89,17 @@
<ul class="current">
<li class="toctree-l1"><a class="reference internal" href="installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1"><a class="reference internal" href="security.html">Security</a></li>
<li class="toctree-l1"><a class="reference internal" href="sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
-<li class="toctree-l1 current"><a class="current reference internal" href="#">Videos</a><ul>
-<li class="toctree-l2"><a class="reference internal" href="#quick-intro">Quick Intro</a></li>
-<li class="toctree-l2"><a class="reference internal" href="#dashboard-creation">Dashboard Creation</a></li>
-<li class="toctree-l2"><a class="reference internal" href="#dashboard-filtering">Dashboard Filtering</a></li>
-<li class="toctree-l2"><a class="reference internal" href="#customize-css-and-dashboard-themes">Customize CSS and dashboard themes</a></li>
-<li class="toctree-l2"><a class="reference internal" href="#slice-annotations">Slice Annotations</a></li>
-<li class="toctree-l2"><a class="reference internal" href="#adding-a-table">Adding a Table</a></li>
-<li class="toctree-l2"><a class="reference internal" href="#define-sql-expressions">Define SQL Expressions</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
+<li class="toctree-l1 current"><a class="reference internal" href="misc.html">Misc</a><ul class="current">
+<li class="toctree-l2"><a class="reference internal" href="visualization.html">Visualization Tools</a></li>
+<li class="toctree-l2 current"><a class="current reference internal" href="#">Videos</a></li>
+<li class="toctree-l2"><a class="reference internal" href="import_export_datasources.html">Importing and Exporting Datasources</a></li>
</ul>
</li>
-<li class="toctree-l1"><a class="reference internal" href="gallery.html">Gallery</a></li>
-<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
</ul>
@@ -149,6 +145,8 @@
<li><a href="index.html">Docs</a> »</li>
+ <li><a href="misc.html">Misc</a> »</li>
+
<li>Videos</li>
@@ -168,60 +166,9 @@
<div class="section" id="videos">
<h1>Videos<a class="headerlink" href="#videos" title="Permalink to this headline">¶</a></h1>
-<p>Here is a collection of short videos showing different aspect
-of Superset.</p>
-<div class="section" id="quick-intro">
-<h2>Quick Intro<a class="headerlink" href="#quick-intro" title="Permalink to this headline">¶</a></h2>
-<p>This video demonstrates how Superset works at a high level, it shows how
-to navigate through datasets and dashboards that are already available.</p>
-<iframe width="640" height="360" src="//www.youtube.com/embed/3Txm_nj_R7M?feature=player_detailpage" frameborder="0" allowfullscreen="1"> </iframe></div>
-<div class="section" id="dashboard-creation">
-<h2>Dashboard Creation<a class="headerlink" href="#dashboard-creation" title="Permalink to this headline">¶</a></h2>
-<p>This video walk you through the creation of a simple dashboard as a
-collection of data slices.</p>
-<ul class="simple">
-<li>Coming soon!</li>
-</ul>
-</div>
-<div class="section" id="dashboard-filtering">
-<h2>Dashboard Filtering<a class="headerlink" href="#dashboard-filtering" title="Permalink to this headline">¶</a></h2>
-<p>This video shows how to create dynamic filters on dashboards, how to
-immunize certain widgets from being affected by filters.</p>
-<ul class="simple">
-<li>Coming soon!</li>
-</ul>
-</div>
-<div class="section" id="customize-css-and-dashboard-themes">
-<h2>Customize CSS and dashboard themes<a class="headerlink" href="#customize-css-and-dashboard-themes" title="Permalink to this headline">¶</a></h2>
-<p>A quick walkthrough on how to apply existing CSS templates, alter them and
-create new ones.</p>
-<ul class="simple">
-<li>Coming soon!</li>
-</ul>
-</div>
-<div class="section" id="slice-annotations">
-<h2>Slice Annotations<a class="headerlink" href="#slice-annotations" title="Permalink to this headline">¶</a></h2>
-<p>A short video on how to annotate your charts, the markdown language and
-to toggle them on dashboards.</p>
-<ul class="simple">
-<li>Coming soon!</li>
-</ul>
-</div>
-<div class="section" id="adding-a-table">
-<h2>Adding a Table<a class="headerlink" href="#adding-a-table" title="Permalink to this headline">¶</a></h2>
-<p>This videos shows you how to expose a new table in Superset, and how to
-define the semantics on how this can be accessed by others in the <code class="docutils literal"><span class="pre">Explore</span></code>
-and <code class="docutils literal"><span class="pre">Dashboard</span></code> views.</p>
-<ul class="simple">
-<li>Coming soon!</li>
-</ul>
-</div>
-<div class="section" id="define-sql-expressions">
-<h2>Define SQL Expressions<a class="headerlink" href="#define-sql-expressions" title="Permalink to this headline">¶</a></h2>
-<p>A walkthrough on how to create your own derived dimensions and metrics.</p>
-<ul class="simple">
-<li>Coming soon!</li>
-</ul>
+<div class="admonition note">
+<p class="first admonition-title">Note</p>
+<p class="last">This section of the documentation has yet to be filled in.</p>
</div>
</div>
@@ -235,7 +182,7 @@ and <code class="docutils literal"><span class="pre">Dashboard</span></code> vie
<div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
- <a href="gallery.html" class="btn btn-neutral float-right" title="Gallery" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
+ <a href="import_export_datasources.html" class="btn btn-neutral float-right" title="Importing and Exporting Datasources" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
<a href="visualization.html" class="btn btn-neutral" title="Visualization Tools" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
diff --git a/visualization.html b/visualization.html
index 940365f..04cfd69 100644
--- a/visualization.html
+++ b/visualization.html
@@ -36,8 +36,9 @@
href="genindex.html"/>
<link rel="search" title="Search" href="search.html"/>
<link rel="top" title="Apache Superset documentation" href="index.html"/>
+ <link rel="up" title="Misc" href="misc.html"/>
<link rel="next" title="Videos" href="videos.html"/>
- <link rel="prev" title="SQL Lab" href="sqllab.html"/>
+ <link rel="prev" title="Misc" href="misc.html"/>
<script src="_static/js/modernizr.min.js"></script>
@@ -88,18 +89,22 @@
<ul class="current">
<li class="toctree-l1"><a class="reference internal" href="installation.html">Installation & Configuration</a></li>
-<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial for Superset Administrators</a></li>
+<li class="toctree-l1"><a class="reference internal" href="tutorial.html">Tutorial - Creating your first dashboard</a></li>
<li class="toctree-l1"><a class="reference internal" href="security.html">Security</a></li>
<li class="toctree-l1"><a class="reference internal" href="sqllab.html">SQL Lab</a></li>
-<li class="toctree-l1 current"><a class="current reference internal" href="#">Visualization Tools</a><ul>
-<li class="toctree-l2"><a class="reference internal" href="#country-map-tools">Country Map Tools</a></li>
-<li class="toctree-l2"><a class="reference internal" href="#list-of-countries">List of Countries</a></li>
-<li class="toctree-l2"><a class="reference internal" href="#you-need-to-add-a-new-country">You need to add a new Country ?</a></li>
+<li class="toctree-l1"><a class="reference internal" href="gallery.html">Visualizations Gallery</a></li>
+<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
+<li class="toctree-l1 current"><a class="reference internal" href="misc.html">Misc</a><ul class="current">
+<li class="toctree-l2 current"><a class="current reference internal" href="#">Visualization Tools</a><ul>
+<li class="toctree-l3"><a class="reference internal" href="#country-map-tools">Country Map Tools</a></li>
+<li class="toctree-l3"><a class="reference internal" href="#list-of-countries">List of Countries</a></li>
+<li class="toctree-l3"><a class="reference internal" href="#you-need-to-add-a-new-country">You need to add a new Country ?</a></li>
+</ul>
+</li>
+<li class="toctree-l2"><a class="reference internal" href="videos.html">Videos</a></li>
+<li class="toctree-l2"><a class="reference internal" href="import_export_datasources.html">Importing and Exporting Datasources</a></li>
</ul>
</li>
-<li class="toctree-l1"><a class="reference internal" href="videos.html">Videos</a></li>
-<li class="toctree-l1"><a class="reference internal" href="gallery.html">Gallery</a></li>
-<li class="toctree-l1"><a class="reference internal" href="druid.html">Druid</a></li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
</ul>
@@ -145,6 +150,8 @@
<li><a href="index.html">Docs</a> »</li>
+ <li><a href="misc.html">Misc</a> »</li>
+
<li>Visualization Tools</li>
@@ -168,7 +175,7 @@
<div class="section" id="country-map-tools">
<h2>Country Map Tools<a class="headerlink" href="#country-map-tools" title="Permalink to this headline">¶</a></h2>
<p>This tool is used in slices for visualization number or string by region, province or department of your countries.
-So, if you want to use tools, you need ISO 3166-2 code of region, province or departmenent.</p>
+So, if you want to use tools, you need ISO 3166-2 code of region, province or department.</p>
<p>ISO 3166-2 is part of the ISO 3166 standard published by the International Organization for Standardization (ISO), and defines codes for identifying the principal subdivisions (e.g., provinces or states) of all countries coded in ISO 3166-1</p>
<p>The purpose of ISO 3166-2 is to establish an international standard of short and unique alphanumeric codes to represent the relevant administrative divisions and dependent territories of all countries in a more convenient and less ambiguous form than their full names. Each complete ISO 3166-2 code consists of two parts, separated by a hyphen:[1]</p>
<p>The first part is the ISO 3166-1 alpha-2 code of the country;
@@ -1259,8 +1266,8 @@ The second part is a string of up to three alphanumeric characters, which is usu
</ul>
<table border="1" class="docutils">
<colgroup>
-<col width="17%" />
-<col width="83%" />
+<col width="19%" />
+<col width="81%" />
</colgroup>
<thead valign="bottom">
<tr class="row-odd"><th class="head">ISO</th>
@@ -1495,8 +1502,8 @@ The second part is a string of up to three alphanumeric characters, which is usu
</ul>
<table border="1" class="docutils">
<colgroup>
-<col width="17%" />
-<col width="83%" />
+<col width="19%" />
+<col width="81%" />
</colgroup>
<thead valign="bottom">
<tr class="row-odd"><th class="head">ISO</th>
@@ -1779,8 +1786,8 @@ The second part is a string of up to three alphanumeric characters, which is usu
</ul>
<table border="1" class="docutils">
<colgroup>
-<col width="17%" />
-<col width="83%" />
+<col width="19%" />
+<col width="81%" />
</colgroup>
<thead valign="bottom">
<tr class="row-odd"><th class="head">ISO</th>
@@ -1951,8 +1958,8 @@ The second part is a string of up to three alphanumeric characters, which is usu
</ul>
<table border="1" class="docutils">
<colgroup>
-<col width="17%" />
-<col width="83%" />
+<col width="19%" />
+<col width="81%" />
</colgroup>
<thead valign="bottom">
<tr class="row-odd"><th class="head">ISO</th>
@@ -2824,11 +2831,11 @@ This action can make with ogr2ogr tools : <a class="reference external" href="ht
<li>Add your country in component ‘select_country’
Example :</li>
</ol>
-<div class="code python highlight-default"><div class="highlight"><pre><span></span><span class="n">select_country</span><span class="p">:</span> <span class="p">{</span>
- <span class="nb">type</span><span class="p">:</span> <span class="s1">'SelectControl'</span><span class="p">,</span>
- <span class="n">label</span><span class="p">:</span> <span class="s1">'Country Name Type'</span><span class="p">,</span>
- <span class="n">default</span><span class="p">:</span> <span class="s1">'France'</span><span class="p">,</span>
- <span class="n">choices</span><span class="p">:</span> <span class="p">[</span>
+<div class="highlight-javascript"><div class="highlight"><pre><span></span><span class="nx">select_country</span><span class="o">:</span> <span class="p">{</span>
+ <span class="nx">type</span><span class="o">:</span> <span class="s1">'SelectControl'</span><span class="p">,</span>
+ <span class="nx">label</span><span class="o">:</span> <span class="s1">'Country Name Type'</span><span class="p">,</span>
+ <span class="k">default</span><span class="o">:</span> <span class="s1">'France'</span><span class="p">,</span>
+ <span class="nx">choices</span><span class="o">:</span> <span class="p">[</span>
<span class="s1">'Belgium'</span><span class="p">,</span>
<span class="s1">'Brazil'</span><span class="p">,</span>
<span class="s1">'China'</span><span class="p">,</span>
@@ -2843,8 +2850,8 @@ Example :</li>
<span class="s1">'Spain'</span><span class="p">,</span>
<span class="s1">'Uk'</span><span class="p">,</span>
<span class="s1">'Usa'</span><span class="p">,</span>
- <span class="p">]</span><span class="o">.</span><span class="n">map</span><span class="p">(</span><span class="n">s</span> <span class="o">=></span> <span class="p">[</span><span class="n">s</span><span class="p">,</span> <span class="n">s</span><span class="p">]),</span>
- <span class="n">description</span><span class="p">:</span> <span class="s1">'The name of country that Superset should display'</span><span class="p">,</span>
+ <span class="p">].</span><span class="nx">map</span><span class="p">(</span><span class="nx">s</span> <span class="p">=></span> <span class="p">[</span><span class="nx">s</span><span class="p">,</span> <span class="nx">s</span><span class="p">]),</span>
+ <span class="nx">description</span><span class="o">:</span> <span class="s1">'The name of country that Superset should display'</span><span class="p">,</span>
<span class="p">},</span>
</pre></div>
</div>
@@ -2864,7 +2871,7 @@ Example :</li>
<a href="videos.html" class="btn btn-neutral float-right" title="Videos" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
- <a href="sqllab.html" class="btn btn-neutral" title="SQL Lab" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+ <a href="misc.html" class="btn btn-neutral" title="Misc" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
</div>