I am trying to create a new table and export to s3 source. the source is map to a s3 bucket
CREATE TABLE s3.FOLDERNAME.test
AS select * from testData.testData LIMIT 4
the CTAS will work if I have another bucket named FOLDERNAME, otherwise it would fail. complainting “Cannot create the table because ‘FOLDERNAME’ bucket does not exist”
what do i missed ?
Attached two query profile below: one failed one sucess, only difference is I have created another bucket named dremiotest123 in s3 account.