I created a table1 with some data. Then I truncated it to load new dataset.

When I do

select * from table

. I get row count 0.

But when I am trying to copy into using following command. I get error saying target table must be delta table:

COPY INTO databse.tabl1   FROM '/mnt/blob/path/tday'  

FILEFORMAT = CSV 

  --PATTERN = 'folder1/file_[a-g].csv'
  FORMAT_OPTIONS('header' = 'true')

I can also see the table in SHOW TABLES.

Please tell me if I am missing anything??