Hi All,
While defining a schema in creating a table using Autoloader and DLT using SQL, I am getting schema mismatch error between the defined schema and inferred schema.
CREATE OR REFRESH STREAMING TABLE csv_test
(a0 STRING
,a1 STRING
,a2 STRING
,a3 STRING
,a4 STRING
,a5 STRING
,a6 STRING
,a7 STRING
,a8 STRING
,a9 STRING
,rescue_data STRING
)
AS SELECT
*
FROM cloud_files("s3://Bucket/test_data/", "csv", map("delimiter", "|", "header", "false"))
Is there a known limitation or am I missing something here?
