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 8122d97867ab6114e1bb4b066cac9c7b4af50f29 Author: Maxime Beauchemin <[email protected]> AuthorDate: Tue Sep 18 15:47:55 2018 -0700 Latest docs --- _images/apache_feather.png | Bin 0 -> 138140 bytes _modules/index.html | 7 +++-- _modules/superset/jinja_context.html | 52 +++++++++++++++++++++++++++++++++-- _sources/index.rst.txt | 30 ++++++++++++++++---- _sources/installation.rst.txt | 24 ++++++++++++++-- _sources/sqllab.rst.txt | 2 ++ _static/img/apache_feather.png | Bin 0 -> 138140 bytes _static/s.png | Bin 0 -> 11833 bytes druid.html | 7 +++-- faq.html | 7 +++-- gallery.html | 7 +++-- genindex.html | 18 ++++++++++-- import_export_datasources.html | 7 +++-- index.html | 36 +++++++++++++++++------- installation.html | 32 +++++++++++++++++---- misc.html | 7 +++-- objects.inv | 4 +-- search.html | 7 +++-- searchindex.js | 2 +- security.html | 7 +++-- sqllab.html | 48 ++++++++++++++++++++++++++++++-- tutorial.html | 7 +++-- videos.html | 7 +++-- visualization.html | 7 +++-- 24 files changed, 267 insertions(+), 58 deletions(-) diff --git a/_images/apache_feather.png b/_images/apache_feather.png new file mode 100644 index 0000000..744b8d7 Binary files /dev/null and b/_images/apache_feather.png differ diff --git a/_modules/index.html b/_modules/index.html index 5f63f27..ab7afb7 100644 --- a/_modules/index.html +++ b/_modules/index.html @@ -58,6 +58,9 @@ + + <img src="../_static/s.png" class="logo" /> + </a> @@ -170,10 +173,10 @@ <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/_modules/superset/jinja_context.html b/_modules/superset/jinja_context.html index b359dd3..b19b2e1 100644 --- a/_modules/superset/jinja_context.html +++ b/_modules/superset/jinja_context.html @@ -59,6 +59,9 @@ + + <img src="../../_static/s.png" class="logo" /> + </a> @@ -221,8 +224,50 @@ <span class="k">return</span> <span class="n">g</span><span class="o">.</span><span class="n">user</span><span class="o">.</span><span class="n">username</span> -<span class="k">class</span> <span class="nc">BaseTemplateProcessor</span><span class="p">(</span><span class="nb">object</span><span class="p">):</span> +<div class="viewcode-block" id="filter_values"><a class="viewcode-back" href="../../sqllab.html#superset.jinja_context.filter_values">[docs]</a><span class="k">def</span> <span class="nf">filter_values</span><span class="p">(</span><span class="n">column</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">""" Gets a values for a particular filter as a list</span> + +<span class="sd"> This is useful if:</span> +<span class="sd"> - you want to use a filter box to filter a query where the name of filter box</span> +<span class="sd"> column doesn't match the one in the select statement</span> +<span class="sd"> - you want to have the ability for filter inside the main query for speed purposes</span> +<span class="sd"> This searches for "filters" and "extra_filters" in form_data for a match</span> + +<span class="sd"> Usage example:</span> +<span class="sd"> SELECT action, count(*) as times</span> +<span class="sd"> FROM logs</span> +<span class="sd"> WHERE action in ( {{ "'" + "','".join(filter_values('action_type')) + "'" )</span> +<span class="sd"> GROUP BY 1</span> + +<span class="sd"> :param column: column/filter name to lookup</span> +<span class="sd"> :type column: str</span> +<span class="sd"> :param default: default value to return if there's no matching columns</span> +<span class="sd"> :type default: str</span> +<span class="sd"> :return: returns a list of filter values</span> +<span class="sd"> :type: list</span> +<span class="sd"> """</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="s1">'</span><span class="si">{}</span><span class="s1">'</span><span class="p">))</span> + <span class="n">return_val</span> <span class="o">=</span> <span class="p">[]</span> + <span class="k">for</span> <span class="n">filter_type</span> <span class="ow">in</span> <span class="p">[</span><span class="s1">'filters'</span><span class="p">,</span> <span class="s1">'extra_filters'</span><span class="p">]:</span> + <span class="k">if</span> <span class="n">filter_type</span> <span class="ow">not</span> <span class="ow">in</span> <span class="n">form_data</span><span class="p">:</span> + <span class="k">continue</span> + + <span class="k">for</span> <span class="n">f</span> <span class="ow">in</span> <span class="n">form_data</span><span class="p">[</span><span class="n">filter_type</span><span class="p">]:</span> + <span class="k">if</span> <span class="n">f</span><span class="p">[</span><span class="s1">'col'</span><span class="p">]</span> <span class="o">==</span> <span class="n">column</span><span class="p">:</span> + <span class="k">for</span> <span class="n">v</span> <span class="ow">in</span> <span class="n">f</span><span class="p">[</span><span class="s1">'val'</span><span class="p">]:</span> + <span class="n">return_val</span><span class="o">.</span><span class="n">append</span><span class="p">(</span><span class="n">v</span><span class="p">)</span> + + <span class="k">if</span> <span class="n">return_val</span><span class="p">:</span> + <span class="k">return</span> <span class="n">return_val</span> + + <span class="k">if</span> <span class="n">default</span><span class="p">:</span> + <span class="k">return</span> <span class="p">[</span><span class="n">default</span><span class="p">]</span> + <span class="k">else</span><span class="p">:</span></div> + <span class="k">return</span> <span class="p">[]</span> + + +<span class="k">class</span> <span class="nc">BaseTemplateProcessor</span><span class="p">(</span><span class="nb">object</span><span class="p">):</span> <span class="sd">"""Base class for database-specific jinja context</span> <span class="sd"> There's this bit of magic in ``process_template`` that instantiates only</span> @@ -250,6 +295,7 @@ <span class="s1">'url_param'</span><span class="p">:</span> <span class="n">url_param</span><span class="p">,</span> <span class="s1">'current_user_id'</span><span class="p">:</span> <span class="n">current_user_id</span><span class="p">,</span> <span class="s1">'current_username'</span><span class="p">:</span> <span class="n">current_username</span><span class="p">,</span> + <span class="s1">'filter_values'</span><span class="p">:</span> <span class="n">filter_values</span><span class="p">,</span> <span class="s1">'form_data'</span><span class="p">:</span> <span class="p">{},</span> <span class="p">}</span> <span class="bp">self</span><span class="o">.</span><span class="n">context</span><span class="o">.</span><span class="n">update</span><span class="p">(</span><span class="n">kwargs</span><span class="p">)</span> @@ -327,10 +373,10 @@ <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/_sources/index.rst.txt b/_sources/index.rst.txt index 8aa2c49..534bdea 100644 --- a/_sources/index.rst.txt +++ b/_sources/index.rst.txt @@ -1,4 +1,12 @@ -.. image:: images/s.png +|apache_img| |superset_img| + +.. |apache_img| image:: images/apache_feather.png + :width: 7% + :target: http://www.apache.org/ + :alt: The Apache Software Foundation + +.. |superset_img| image:: images/s.png + :width: 25% Apache Superset (incubating) '''''''''''''''''''''''''''' @@ -9,9 +17,6 @@ intelligence web application ---------------- -.. warning:: This project was originally named Panoramix, was renamed to - Caravel in March 2016, and is currently named Superset as of November 2016 - .. important:: **Disclaimer**: Apache Superset is an effort undergoing incubation at The @@ -24,8 +29,13 @@ intelligence web application the code, it does indicate that the project has yet to be fully endorsed by the ASF. -Resources -========= +.. note:: Apache Superset, Superset, Apache, the Apache feather logo, and + the Apache Superset project logo are either registered trademarks or + trademarks of The Apache Software Foundation in the United States + and other countries. + +Superset Resources +================== - `Superset's Github <https://github.com/apache/incubator-superset>`_, note that `we use Github for issue tracking <https://github.com/apache/incubator-superset/issues>`_ - Superset's @@ -37,6 +47,14 @@ Resources To subscribe, send an email to ``[email protected]`` - `Join our Slack <https://join.slack.com/t/apache-superset/shared_invite/enQtNDMxMDY5NjM4MDU0LTc2Y2QwYjE4NGYwNzQyZWUwYTExZTdiZDMzMWQwZjc2YmJmM2QyMDkwMGVjZTA4N2I2MzUxZTk2YmE5MWRhZWE>`_ +Apache Software Foundation Resources +==================================== +- `The Apache Software Foundation Website <http://www.apache.org>`_ +- `Current Events <http://www.apache.org/events/current-event>`_ +- `Licenses <http://www.apache.org/licenses/>`_ +- `Thanks to the ASF's sponsors <http://www.apache.org/foundation/thanks.html>`_ +- `Sponsor Apache! <http://www.apache.org/foundation/sponsorship.html>`_ + Overview ======== diff --git a/_sources/installation.rst.txt b/_sources/installation.rst.txt index 7529323..963d273 100644 --- a/_sources/installation.rst.txt +++ b/_sources/installation.rst.txt @@ -4,9 +4,9 @@ Installation & Configuration Getting Started --------------- -Superset is tested against Python ``2.7`` and Python ``3.6``. -Airbnb currently uses 2.7.* in production. We do not plan on supporting -Python ``2.6``. +Superset is currently tested against Python ``2.7`` and Python ``3.6``. +Python 3.6 is preferred. Support for Python ``<=3.6`` is planned to get +phased out. Cloud-native! ------------- @@ -354,6 +354,8 @@ Here's a list of some of the recommended packages. +---------------+-------------------------------------+-------------------------------------------------+ | BigQuery | ``pip install pybigquery`` | ``bigquery://`` | +---------------+-------------------------------------+-------------------------------------------------+ +| Teradata | ``pip install sqlalchemy-teradata`` | ``teradata://`` | ++---------------+-------------------------------------+-------------------------------------------------+ Note that many other database are supported, the main criteria being the existence of a functional SqlAlchemy dialect and Python driver. Googling @@ -399,6 +401,22 @@ use version 1.1.0 or try a newer version. See `Snowflake SQLAlchemy <https://github.com/snowflakedb/snowflake-sqlalchemy>`_. +Teradata +--------- + +The connection string for Teradata looks like this :: + + teradata://{user}:{password}@{host} + +*Note*: Its required to have Teradata ODBC drivers installed and environment variables configured for proper work of sqlalchemy dialect. Teradata ODBC Drivers available here: https://downloads.teradata.com/download/connectivity/odbc-driver/linux + +Required environment variables: :: + + export ODBCINI=/.../teradata/client/ODBC_64/odbc.ini + export ODBCINST=/.../teradata/client/ODBC_64/odbcinst.ini + +See `Teradata SQLAlchemy <https://github.com/Teradata/sqlalchemy-teradata>`_. + Caching ------- diff --git a/_sources/sqllab.rst.txt b/_sources/sqllab.rst.txt index 9230b2c..2ba9ac2 100644 --- a/_sources/sqllab.rst.txt +++ b/_sources/sqllab.rst.txt @@ -67,6 +67,8 @@ Superset's Jinja context: .. autofunction:: superset.jinja_context.url_param +.. autofunction:: superset.jinja_context.filter_values + Extending macros '''''''''''''''' diff --git a/_static/img/apache_feather.png b/_static/img/apache_feather.png new file mode 100644 index 0000000..744b8d7 Binary files /dev/null and b/_static/img/apache_feather.png differ diff --git a/_static/s.png b/_static/s.png new file mode 100644 index 0000000..2031b86 Binary files /dev/null and b/_static/s.png differ diff --git a/druid.html b/druid.html index 6c24c89..15a1f85 100644 --- a/druid.html +++ b/druid.html @@ -60,6 +60,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -228,10 +231,10 @@ some input.</p> <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/faq.html b/faq.html index 405a2be..eba0d2d 100644 --- a/faq.html +++ b/faq.html @@ -59,6 +59,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -438,10 +441,10 @@ and should be able to things that are typical in basic SQL:</p> <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/gallery.html b/gallery.html index f544fc8..a3b4286 100644 --- a/gallery.html +++ b/gallery.html @@ -60,6 +60,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -229,10 +232,10 @@ <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/genindex.html b/genindex.html index 423649e..1915f1f 100644 --- a/genindex.html +++ b/genindex.html @@ -59,6 +59,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -159,10 +162,19 @@ <h1 id="index">Index</h1> <div class="genindex-jumpbox"> - <a href="#P"><strong>P</strong></a> + <a href="#F"><strong>F</strong></a> + | <a href="#P"><strong>P</strong></a> | <a href="#U"><strong>U</strong></a> </div> +<h2 id="F">F</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.filter_values">filter_values() (in module superset.jinja_context)</a> +</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> @@ -193,10 +205,10 @@ <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/import_export_datasources.html b/import_export_datasources.html index 0dc1f88..3594105 100644 --- a/import_export_datasources.html +++ b/import_export_datasources.html @@ -61,6 +61,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -293,10 +296,10 @@ by saving the following YAML to file and then running the <code class="docutils <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/index.html b/index.html index 73039e6..83eb7b9 100644 --- a/index.html +++ b/index.html @@ -59,6 +59,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -155,17 +158,12 @@ <div role="main" class="document" itemscope="itemscope" itemtype="http://schema.org/Article";> <div itemprop="articleBody"> - <img alt="_images/s.png" src="_images/s.png" /> + <p><a class="reference external" href="http://www.apache.org/";><img alt="The Apache Software Foundation" src="_images/apache_feather.png" style="width: 7%;" /></a> <a class="reference internal" href="_images/s.png"><img alt="superset_img" src="_images/s.png" style="width: 25%;" /></a></p> <div class="section" id="apache-superset-incubating"> <h1>Apache Superset (incubating)<a class="headerlink" href="#apache-superset-incubating" title="Permalink to this headline">¶</a></h1> <p>Apache Superset (incubating) is a modern, enterprise-ready business intelligence web application</p> <hr class="docutils" /> -<div class="admonition warning"> -<p class="first admonition-title">Warning</p> -<p class="last">This project was originally named Panoramix, was renamed to -Caravel in March 2016, and is currently named Superset as of November 2016</p> -</div> <div class="admonition important"> <p class="first admonition-title">Important</p> <p class="last"><strong>Disclaimer</strong>: Apache Superset is an effort undergoing incubation at The @@ -178,8 +176,15 @@ necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.</p> </div> -<div class="section" id="resources"> -<h2>Resources<a class="headerlink" href="#resources" title="Permalink to this headline">¶</a></h2> +<div class="admonition note"> +<p class="first admonition-title">Note</p> +<p class="last">Apache Superset, Superset, Apache, the Apache feather logo, and +the Apache Superset project logo are either registered trademarks or +trademarks of The Apache Software Foundation in the United States +and other countries.</p> +</div> +<div class="section" id="superset-resources"> +<h2>Superset Resources<a class="headerlink" href="#superset-resources" title="Permalink to this headline">¶</a></h2> <ul class="simple"> <li><a class="reference external" href="https://github.com/apache/incubator-superset";>Superset’s Github</a>, note that <a class="reference external" href="https://github.com/apache/incubator-superset/issues";>we use Github for issue tracking</a></li> @@ -193,6 +198,16 @@ To subscribe, send an email to <code class="docutils literal notranslate"><span <li><a class="reference external" href="https://join.slack.com/t/apache-superset/shared_invite/enQtNDMxMDY5NjM4MDU0LTc2Y2QwYjE4NGYwNzQyZWUwYTExZTdiZDMzMWQwZjc2YmJmM2QyMDkwMGVjZTA4N2I2MzUxZTk2YmE5MWRhZWE";>Join our Slack</a></li> </ul> </div> +<div class="section" id="apache-software-foundation-resources"> +<h2>Apache Software Foundation Resources<a class="headerlink" href="#apache-software-foundation-resources" title="Permalink to this headline">¶</a></h2> +<ul class="simple"> +<li><a class="reference external" href="http://www.apache.org";>The Apache Software Foundation Website</a></li> +<li><a class="reference external" href="http://www.apache.org/events/current-event";>Current Events</a></li> +<li><a class="reference external" href="http://www.apache.org/licenses/";>Licenses</a></li> +<li><a class="reference external" href="http://www.apache.org/foundation/thanks.html";>Thanks to the ASF’s sponsors</a></li> +<li><a class="reference external" href="http://www.apache.org/foundation/sponsorship.html";>Sponsor Apache!</a></li> +</ul> +</div> <div class="section" id="overview"> <h2>Overview<a class="headerlink" href="#overview" title="Permalink to this headline">¶</a></h2> <div class="section" id="features"> @@ -244,6 +259,7 @@ to the user</li> <li class="toctree-l2"><a class="reference internal" href="installation.html#database-dependencies">Database dependencies</a></li> <li class="toctree-l2"><a class="reference internal" href="installation.html#aws-athena">(AWS) Athena</a></li> <li class="toctree-l2"><a class="reference internal" href="installation.html#snowflake">Snowflake</a></li> +<li class="toctree-l2"><a class="reference internal" href="installation.html#teradata">Teradata</a></li> <li class="toctree-l2"><a class="reference internal" href="installation.html#caching">Caching</a></li> <li class="toctree-l2"><a class="reference internal" href="installation.html#deeper-sqlalchemy-integration">Deeper SQLAlchemy integration</a></li> <li class="toctree-l2"><a class="reference internal" href="installation.html#schemas-postgres-redshift">Schemas (Postgres & Redshift)</a></li> @@ -347,10 +363,10 @@ to the user</li> <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/installation.html b/installation.html index abc4769..e50fc91 100644 --- a/installation.html +++ b/installation.html @@ -60,6 +60,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -102,6 +105,7 @@ <li class="toctree-l2"><a class="reference internal" href="#database-dependencies">Database dependencies</a></li> <li class="toctree-l2"><a class="reference internal" href="#aws-athena">(AWS) Athena</a></li> <li class="toctree-l2"><a class="reference internal" href="#snowflake">Snowflake</a></li> +<li class="toctree-l2"><a class="reference internal" href="#teradata">Teradata</a></li> <li class="toctree-l2"><a class="reference internal" href="#caching">Caching</a></li> <li class="toctree-l2"><a class="reference internal" href="#deeper-sqlalchemy-integration">Deeper SQLAlchemy integration</a></li> <li class="toctree-l2"><a class="reference internal" href="#schemas-postgres-redshift">Schemas (Postgres & Redshift)</a></li> @@ -191,9 +195,9 @@ <h1>Installation & Configuration<a class="headerlink" href="#installation-configuration" title="Permalink to this headline">¶</a></h1> <div class="section" id="getting-started"> <h2>Getting Started<a class="headerlink" href="#getting-started" title="Permalink to this headline">¶</a></h2> -<p>Superset is tested against Python <code class="docutils literal notranslate"><span class="pre">2.7</span></code> and Python <code class="docutils literal notranslate"><span class="pre">3.6</span></code>. -Airbnb currently uses 2.7.* in production. We do not plan on supporting -Python <code class="docutils literal notranslate"><span class="pre">2.6</span></code>.</p> +<p>Superset is currently tested against Python <code class="docutils literal notranslate"><span class="pre">2.7</span></code> and Python <code class="docutils literal notranslate"><span class="pre">3.6</span></code>. +Python 3.6 is preferred. Support for Python <code class="docutils literal notranslate"><span class="pre"><=3.6</span></code> is planned to get +phased out.</p> </div> <div class="section" id="cloud-native"> <h2>Cloud-native!<a class="headerlink" href="#cloud-native" title="Permalink to this headline">¶</a></h2> @@ -559,6 +563,10 @@ connect to the databases you want to access through Superset.</p> <td><code class="docutils literal notranslate"><span class="pre">pip</span> <span class="pre">install</span> <span class="pre">pybigquery</span></code></td> <td><code class="docutils literal notranslate"><span class="pre">bigquery://</span></code></td> </tr> +<tr class="row-even"><td>Teradata</td> +<td><code class="docutils literal notranslate"><span class="pre">pip</span> <span class="pre">install</span> <span class="pre">sqlalchemy-teradata</span></code></td> +<td><code class="docutils literal notranslate"><span class="pre">teradata://</span></code></td> +</tr> </tbody> </table> <p>Note that many other database are supported, the main criteria being the @@ -600,6 +608,20 @@ snowflake-sqlalchemy package that causes problems when used with Superset. It is use version 1.1.0 or try a newer version.</p> <p>See <a class="reference external" href="https://github.com/snowflakedb/snowflake-sqlalchemy";>Snowflake SQLAlchemy</a>.</p> </div> +<div class="section" id="teradata"> +<h2>Teradata<a class="headerlink" href="#teradata" title="Permalink to this headline">¶</a></h2> +<p>The connection string for Teradata looks like this</p> +<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">teradata</span><span class="p">:</span><span class="o">//</span><span class="p">{</span><span class="n">user</span><span class="p">}:{</span><span class="n">password</span><span class="p">}</span><span class="o">@</span><span class="p">{</span><span class="n">host</span><span class="p">}</span> +</pre></div> +</div> +<p><em>Note</em>: Its required to have Teradata ODBC drivers installed and environment variables configured for proper work of sqlalchemy dialect. Teradata ODBC Drivers available here: <a class="reference external" href="https://downloads.teradata.com/download/connectivity/odbc-driver/linux";>https://downloads.teradata.com/download/connectivity/odbc-driver/linux</a></p> +<p>Required environment variables:</p> +<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">export</span> <span class="n">ODBCINI</span><span class="o">=/.../</span><span class="n">teradata</span><span class="o">/</span><span class="n">client</span><span class="o">/</span><span class="n">ODBC_64</span><span class="o">/</span><span class="n">odbc</span><span class="o">.</span><span class="n">ini</span> +<span class="n">export</span> <span class="n">ODBCINST</span><span class="o">=/.../</span><span class="n">teradata</span><span class="o">/</span><span class="n">client</span><span class="o">/</span><span class="n">ODBC_64</span><span class="o">/</span><span class="n">odbcinst</span><span class="o">.</span><span class="n">ini</span> +</pre></div> +</div> +<p>See <a class="reference external" href="https://github.com/Teradata/sqlalchemy-teradata";>Teradata SQLAlchemy</a>.</p> +</div> <div class="section" id="caching"> <h2>Caching<a class="headerlink" href="#caching" title="Permalink to this headline">¶</a></h2> <p>Superset uses <a class="reference external" href="https://pythonhosted.org/Flask-Cache/";>Flask-Cache</a> for @@ -966,10 +988,10 @@ located in <code class="docutils literal notranslate"><span class="pre">install/ <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/misc.html b/misc.html index a35da64..fb4cad5 100644 --- a/misc.html +++ b/misc.html @@ -60,6 +60,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -204,10 +207,10 @@ <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/objects.inv b/objects.inv index 4180264..5482292 100644 --- a/objects.inv +++ b/objects.inv @@ -2,6 +2,4 @@ # Project: Apache Superset # Version: # The remainder of this file is compressed using zlib. -x�uR�n�0 ��)�����[ѬÀH�`׀�hG�,��4${�ɒ��Xv��PE�#y��������@��y��4����<��Gi� �?��vs -����F��Jћ� ���E+�v��]��pP��Ih ����?�|J ���.z4��e��P��� ��?8���p�'���s��v�d���)z�G:�Ca@vѧ�,���h��im{@����f۫P\۩5��<�(O�y��U[[�j|KF�U��k��Z(������Ϲ4˥}ʋ�-Ebp����KS�Y�T44��S�g�"�Q��k�? �%CS M6l� RF���:͊ �<���t�/�{JZ�� �XU�L��\ �� -��Wx�V���h����*x��� .雡Ӟ(�S��+�[+r�E*H]�)N���� �ƶ��9��/�+kD \ No newline at end of file +xڍR͊�0 ��)[J{��^��촥��Yf�5(�����Y�^f��u�$tJ{���Ȳ,�y��{��k�l�K� <qp'����Ibv ��4� ��o�`�;���}�J��J�6�|��&��6Z���_"zS���]��pP�I��!������|J ���Eth �뚟����9�ѿp���[�DGV[E��K��� -��c(t?8 j��Ca@vѧ�����h��im;@���e���P,��5�N �g��4h���� �5>'#��������� ���Vw��\���>���#E�w����k5�֩hh��6ϢA�Z��[� �%C5�l�O��RQ+u�zy�V+X��X�v��2z 62c��d�l�F��* _��bp^�Y�f�(O���'O����Z�9�B>7��Z��,RA�� �$Zm�V�"nl;��3,~a�� \ No newline at end of file diff --git a/search.html b/search.html index 8c68375..dc9f83a 100644 --- a/search.html +++ b/search.html @@ -58,6 +58,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -178,10 +181,10 @@ <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/searchindex.js b/searchindex.js index 967c6f2..272f1f5 100644 --- a/searchindex.js +++ b/searchindex.js @@ -1 +1 @@ -Search.setIndex({docnames:["druid","faq","gallery","import_export_datasources","index","installation","misc","security","sqllab","tutorial","videos","visualization"],envversion:53,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 +Search.setIndex({docnames:["druid","faq","gallery","import_export_datasources","index","installation","misc","security","sqllab","tutorial","videos","visualization"],envversion:53,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,""],filter_values:[8,1,1,""],url_param:[8,1,1,"" [...] \ No newline at end of file diff --git a/security.html b/security.html index bdead0a..306c94e 100644 --- a/security.html +++ b/security.html @@ -60,6 +60,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -341,10 +344,10 @@ is dependent on revenue.</p> <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/sqllab.html b/sqllab.html index 5ee4eb5..bf31dd6 100644 --- a/sqllab.html +++ b/sqllab.html @@ -60,6 +60,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -247,6 +250,47 @@ jinja context as in <code class="docutils literal notranslate"><span class="pre" </table> </dd></dl> +<dl class="function"> +<dt id="superset.jinja_context.filter_values"> +<code class="descclassname">superset.jinja_context.</code><code class="descname">filter_values</code><span class="sig-paren">(</span><em>column</em>, <em>default=None</em><span class="sig-paren">)</span><a class="reference internal" href="_modules/superset/jinja_context.html#filter_values"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#superset.jinja_context.filter_values" title="Permalink to this definition">¶</a></dt> +<dd><p>Gets a values for a particular filter as a list</p> +<dl class="docutils"> +<dt>This is useful if:</dt> +<dd><ul class="first last simple"> +<li>you want to use a filter box to filter a query where the name of filter box +column doesn’t match the one in the select statement</li> +<li>you want to have the ability for filter inside the main query for speed purposes</li> +</ul> +</dd> +</dl> +<p>This searches for “filters” and “extra_filters” in form_data for a match</p> +<dl class="docutils"> +<dt>Usage example:</dt> +<dd>SELECT action, count(*) as times +FROM logs +WHERE action in ( {{ “’” + “’,’”.join(filter_values(‘action_type’)) + “’” ) +GROUP BY 1</dd> +</dl> +<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 simple"> +<li><strong>column</strong> (<em>str</em>) – column/filter name to lookup</li> +<li><strong>default</strong> (<em>str</em>) – default value to return if there’s no matching columns</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Returns:</th><td class="field-body"><p class="first">returns a list of filter values</p> +</td> +</tr> +<tr class="field-odd field"><th class="field-name">Type:</th><td class="field-body"><p class="first last">list</p> +</td> +</tr> +</tbody> +</table> +</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> @@ -281,10 +325,10 @@ to integrate in their queries in <strong>SQL Lab</strong>.</p> <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/tutorial.html b/tutorial.html index 2fc7cb0..226727e 100644 --- a/tutorial.html +++ b/tutorial.html @@ -60,6 +60,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -392,10 +395,10 @@ please start exploring and creating slices and dashboards of your own.</p> <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/videos.html b/videos.html index 2c31885..5adde10 100644 --- a/videos.html +++ b/videos.html @@ -61,6 +61,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -194,10 +197,10 @@ <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer> diff --git a/visualization.html b/visualization.html index c856664..0776085 100644 --- a/visualization.html +++ b/visualization.html @@ -61,6 +61,9 @@ + + <img src="_static/s.png" class="logo" /> + </a> @@ -2880,10 +2883,10 @@ Example :</li> <div role="contentinfo"> <p> + © Copyright Copyright © 2018 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.. </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>. + </div> </footer>
