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.
