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

Issue in post: "JupySQL: Better SQL in Jupyter" #34

Open
prakashperiasamy opened this issue Feb 12, 2023 · 0 comments
Open

Issue in post: "JupySQL: Better SQL in Jupyter" #34

prakashperiasamy opened this issue Feb 12, 2023 · 0 comments

Comments

@prakashperiasamy
Copy link

Hi,
Outset, thank you for the great package and an excellent documentation. Kudos to the team!

I tested all the features and found only one issue so far but rather an important utility for me.
Reg: List columns of a table within a database (snowflake in my case)

  1. Tried %sqlcmd magic extension to list the columns of a table in a database/schema in snowflake
    General syntax I used:
    %sqlcmd columns --table table_name --schema db_name.schema_name

Error message:
ProgrammingError: (snowflake.connector.errors.ProgrammingError) 090105 (22000): Cannot perform SELECT. This session does not have a current database. Call 'USE DATABASE', or use a qualified name.
Background on this error at: https://sqlalche.me/e/14/f405)

Note: the rest of the %sqlcmd features such as get to list of tables works perfect with snowflake

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

No branches or pull requests

1 participant