Databricks

DaniW · 08-01-2023

Hello, if i run this code: %sqlCREATE OR REPLACE VIEW esprosilver.xxx.encuestas_talleresASSELECT * FROM CSV.`abfss://landing@esproanalyticscenterdl.dfs.core.windows.net/oracle-dwh/encuestas_talleres/encuestas_talleres.csv` It creates the view in unit...

DaniW · 08-01-2023

I finally used the managed table creation and works perfectly. So I don't need to schedule. I leave the code here in case is of any use for someone:%sqlCREATE TABLE IF NOT EXISTS esprosilver.XXXX.encuestas_talleresUSING CSVOPTIONS ( path "abfss://la...

DaniW · 08-01-2023

Hello Mo,Thank you for the prompt reply. I require the data and schema to be accessible to all users at all times. Considering this, I'm thinking of creating a managed table that would function similarly to a view. If I create a table first and then...

DaniW · 08-01-2023

I forgot to mention that the csv delimiter is ';'

Databricks

User Stats

User Activity

PARSE_SYNTAX_ERROR creating view from CSV

Re: PARSE_SYNTAX_ERROR creating view from CSV

Re: PARSE_SYNTAX_ERROR creating view from CSV

Re: PARSE_SYNTAX_ERROR creating view from CSV