posts icon indicating copy to clipboard operation
posts copied to clipboard

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

Open prakashperiasamy opened this issue 2 years ago • 0 comments

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

prakashperiasamy avatar Feb 12 '23 04:02 prakashperiasamy