Repository navigation
try-except block for %%sql #198
Description
How can I handle exceptions under %%sql ?
Below statement works:
try:
%sql DROP INDEX index_name;
%sql CREATE INDEX index_name ON table_name(column1, column2);
except:
%sql CREATE INDEX index_name ON table_name(column1, column2);
But, below statement fails with syntax error
try:
%%sql
DROP INDEX index_name;
CREATE INDEX index_name ON table_name(column1, column2);
except:
CREATE INDEX index_name ON table_name(column1, column2);`
Below statement fails too with error as shown below
%%sql
try:
DROP INDEX index_name;
CREATE INDEX index_name ON table_name(column1, column2);
except:
CREATE INDEX index_name ON table_name(column1, column2);
Activity
Updating license (catherinedevlin#198)