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

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

hemantaggarwal commented on issue #5915: Google spreadsheets
URL: https://github.com/apache/incubator-superset/pull/5915#issuecomment-574496800
 
 
   > @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.
   
   In data source put only "gsheets://" instead of full link. If you test it may give error but just save the data source and query the google sheet in SQL editor using full sheet link. But sheet should be public.

----------------------------------------------------------------
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