Using SQL to create delta live tables but column headers from csv have spaces

vanessafvg — Tue, 15 Aug 2023 15:10:01 GMT

I know this has probably been asked many times, although I have struggled to find the answer using sql

CREATE STREAMING LIVE TABLE bronze_site_usage COMMENT "ingest latest snapshot from api"

TBLPROPERTIES ("layer" = "bronze")

AS SELECT * FROM cloud_files("server/url", "csv", map("overwriteschema","true"));

however my columns have spaces in them so this has failed. For the first round of this i actually manually renamed them in the file, and obviously that worked so the table was created... is there anyway to ignore the schema / first row in the source file completely and just use the schema of the target table using SQL.

topic Using SQL to create delta live tables but column headers from csv have spaces in Get Started Discussions

Using SQL to create delta live tables but column headers from csv have spaces