unexpected ''

[tekumara]

What happens?

This valid Snowflake SQL:

%sql show terse objects in db1.schema1 starts with 'a' limit 1 from 'b';

Errors with:

RuntimeError: If using snippets, you may pass the --with argument explicitly.
For more details please refer: https://jupysql.ploomber.io/en/latest/compose.html#with-argument


Original error message from DB driver:
(snowflake.connector.errors.ProgrammingError) 001003 (42000): SQL compilation error:
syntax error line 1 at position 5 unexpected ''a''.
[SQL: with 'a' limit 1 from 'b' ;]

To Reproduce

%sql show terse objects in db1.schema1 starts with 'a' limit 1 from 'b';

OS:

Linux

JupySQL Version:

0.10.7

Full Name:

Oliver Mannion

Affiliation:

Xero

[edublancas]

@tekumara does it also error if you use the %%sql cell magic?

[tekumara]

%%sql works fine.

[edublancas]

thanks for reporting this, we'll get to it!