search

catherinedevlin / ipython-sql

%%sql magic for IPython, hopefully evolving into full SQL client
MIT License
1.79k stars 368 forks source link

Suppress message "Returning data to local variable" #210

Open ellipticview opened 2 years ago

ellipticview commented 2 years ago

Example:

In:

%%sql result <<
select col_name
from table_name

Out:

Returning data to local variable result

I don't want this message to clutter my output for the document I am producing. It would be useful to have a setting to suppress this message.

Current workaround for this issue (needs to be applied for each cell):

%%capture
%%sql result <<
select col_name
from table_name
idomic commented 1 year ago

@ellipticview @charlie-sanders @laowantong @N-Wouda We just pushed a fix which will be available in the next Jupysql release! Jupysql is a fork that we're trying to maintain to keep the support/bug fixes/feature requests going for the community.

idomic commented 1 year ago

Just released a version with the fix!

qharlie commented 1 year ago

Rock on! @max-sixty This will help the jupyter prql integrations