CETAS failing on SQL On demand pool
The following script is able to create an external table, but the select on the external table fails:
REATE EXTERNAL TABLE weather2
DATASOURCE = demoMalta,
FILEFORMAT = parquetformat
top 100 *
) AS [weather]
By changing slightly the location, everything works: LOCATION='/weather2/"
This seems a bug. The table should not be created in the first place if the select over the table will fail. The creation managed to understand the location, but the select doesn't.
This is now fixed.