posts
posts copied to clipboard
Issue in post: "JupySQL: Better SQL in Jupyter"
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)
- 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