Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Didn't manage to apply query on public google spreadsheet #242

Closed
Renat2001 opened this issue May 23, 2022 · 2 comments
Closed

Didn't manage to apply query on public google spreadsheet #242

Renat2001 opened this issue May 23, 2022 · 2 comments
Labels

Comments

@Renat2001
Copy link

Renat2001 commented May 23, 2022

Good day everyone! Currently I'm using shillelagh package to access my google spreadsheet. But I'm getting error:
Unsupported table: https://docs.google.com/spreadsheets/d/1Z8rDIh5Xu1QbrMU7afdT3kQB-75uHXwZ76AVJhTDH4w/edit#gid=1732117799. I'm leaving here link:https://docs.google.com/spreadsheets/d/1Z8rDIh5Xu1QbrMU7afdT3kQB-75uHXwZ76AVJhTDH4w/edit#gid=1732117799, so you can see where is my mistake.
Code I used:

cursor = connection.cursor()
mydf = pd.read_csv('C:\\Users\\R.Abdrakhmanov\\Desktop\\diploma_at_drive\\data\\ways.csv')
SQL = """
    SELECT *
    FROM "https://docs.google.com/spreadsheets/d/1Z8rDIh5Xu1QbrMU7afdT3kQB-75uHXwZ76AVJhTDH4w/edit#gid=1732117799"
"""
rows = cursor.execute(SQL)```
@betodealmeida
Copy link
Owner

@Renat2001 what version are you using and how did you install it? It works fine for me

% shillelagh
sql> SELECT * FROM "https://docs.google.com/spreadsheets/d/1Z8rDIh5Xu1QbrMU7afdT3kQB-75uHXwZ76AVJhTDH4w/edit#gid=1732117799";
  id
----
   0
   1
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
sql>

Make sure you install shillelagh with the optional dependencies that are needed for GSheets:

pip install "shillelagh[gsheetsapi]"

@Renat2001
Copy link
Author

I have the latest version of shillelagh. But I haven't install dependencies for GSheets. Now I got the point. Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: Done
Development

No branches or pull requests

2 participants