I'm trying to create an external location from notebook, and I got this kind of error
[PARSE_SYNTAX_ERROR] Syntax error at or near 'LOCATION'(line 1, pos 16)
== SQL ==
CREATE EXTERNAL LOCATION IF NOT EXISTS test_location URL 's3://test-bronze/db/test_schema/test_table' WITH (STORAGE CREDENTIAL test-credential)
----------------^^^
I tried with DBR10.4, DBR11.1 and DBR11.2, unfortunately, none of them worked.
However, SHOW EXTERNAL LOCATIONS and DESCRIBE EXTERNAL LOCATION *** work just fine.
Also, I can create an external location from the UI without any problem
Anyone knows how to solve this issue?