superset-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From maximebeauche...@apache.org
Subject [incubator-superset] branch master updated: Add Snowflake connection string instructions (#5443)
Date Fri, 20 Jul 2018 22:19:20 GMT
This is an automated email from the ASF dual-hosted git repository.

maximebeauchemin pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-superset.git


The following commit(s) were added to refs/heads/master by this push:
     new 670b145  Add Snowflake connection string instructions (#5443)
670b145 is described below

commit 670b145b1edd068663c3e0a3e8f5762934ef803c
Author: Ville Brofeldt <33317356+villebro@users.noreply.github.com>
AuthorDate: Sat Jul 21 01:19:18 2018 +0300

    Add Snowflake connection string instructions (#5443)
---
 docs/installation.rst | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

diff --git a/docs/installation.rst b/docs/installation.rst
index fc8d075..2ea5200 100644
--- a/docs/installation.rst
+++ b/docs/installation.rst
@@ -370,6 +370,24 @@ You can also use `PyAthena` library
 
 _(See more details at https://github.com/laughingman7743/PyAthena#sqlalchemy.)_
 
+Snowflake
+---------
+
+The connection string for Snowflake looks like this ::
+
+    snowflake://{user}:{password}@{account}.{region}/{database}?role={role}&warehouse={warehouse}
+
+The schema is not necessary in the connection string, as it is defined per table/query.
+The role and warehouse can be omitted if defaults are defined for the user, i.e.
+
+    snowflake://{user}:{password}@{account}.{region}/{database}
+
+Make sure the user has privileges to access and use all required
+databases/schemas/tables/views/warehouses, as the Snowflake SQLAlchemy engine does
+not test for user rights during engine creation.
+
+_(See more details at https://github.com/snowflakedb/snowflake-sqlalchemy.)_
+
 Caching
 -------
 


Mime
View raw message