@Lorenzo Rondan​ , So it seems that this syntax USING com.databricks.spark.redshift is working only in notebook/standard workspace.

Databricks SQL endpoints have a different runtime. So let's hope that the unity catalog mentioned in error will include external systems.