[GitHub] [incubator-superset] cachafla commented on issue #5915: Google spreadsheets

[GitBox <gi...@apache.org>]

cachafla commented on issue #5915: Google spreadsheets
URL: https://github.com/apache/incubator-superset/pull/5915#issuecomment-574415824
 
 
   @betodealmeida ping. I'd like some help setting this up as well. I tried setting up a datasource with a URL such as:
   
   ```
   gsheets://docs.google.com/spreadsheets/d/<spreadsheet-id>/edit#gid=0
   ```
   
   But I get the following error:
   
   ```
   2020-01-14 22:51:53,769:ERROR:root:'from'
   Traceback (most recent call last):
     File "/usr/local/lib/python3.6/site-packages/superset/views/core.py", line 1705, in testconn
       conn.scalar(select([1]))
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 920, in scalar
       return self.execute(object_, *multiparams, **params).scalar()
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 988, in execute
       return meth(self, multiparams, params)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
       return connection._execute_clauseelement(self, multiparams, params)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement
       distilled_params,
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
       e, statement, parameters, cursor, context
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1468, in _handle_dbapi_exception
       util.reraise(*exc_info)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
       raise value
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
       cursor, statement, parameters, context
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
       cursor.execute(statement, parameters)
     File "/home/superset/.local/lib/python3.6/site-packages/gsheetsdb/db.py", line 36, in g
       return f(self, *args, **kwargs)
     File "/home/superset/.local/lib/python3.6/site-packages/gsheetsdb/db.py", line 137, in execute
       query, headers, self.credentials)
     File "/home/superset/.local/lib/python3.6/site-packages/gsheetsdb/query.py", line 96, in execute
       from_ = extract_url(query)
     File "/home/superset/.local/lib/python3.6/site-packages/gsheetsdb/url.py", line 51, in extract_url
       return parse_sql(sql)['from']
   KeyError: 'from'
   ```
   
   I haven't found any documentation that shows how to setup GSheets a data source, even though this PR shows it's possible.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org