%sql

CREATE OR REPLACE VIEW esprosilver.xxx.encuestas_talleres

AS

SELECT * FROM CSV.`abfss://landing@esproanalyticscenterdl.dfs.core.windows.net/oracle-dwh/encuestas_talleres/encuestas_talleres.csv`

 

It creates the view in unity catalog, but places all data in a column _c0. so I have to tell it that it has headers. But if I run this query:

it returns this error:

ParseException: [PARSE_SYNTAX_ERROR] Syntax error at or near 'USING'(line 2, pos 0) == SQL == CREATE OR REPLACE VIEW esprosilver.realeseguros_dwh.encuestas_talleres
USING csv
^^^
OPTIONS ( path "abfss:REDACTED_LOCAL_PART@esproanalyticscenterdl.dfs.core.windows.net/oracle-dwh/encuestas_talleres/encuestas_talleres.csv", header = "true", inferSchema "true", mode "FAILFAST")

Can someone help me fix it? Thank you in advance