I am running copy jobs from snowflake tables to S3, and few of the tables are empty. Is there a way to generate an empty parquet file for these tables?
Below is the COPY command:
COPY INTO @athena_s3_stage_accounts
FROM (select * from athena_test_db.s3_connect_demo.accounts)
FILE_FORMAT = s3_parquet_file_format
OVERWRITE=TRUE;
Currently for the tables having data, the parquet file is generated correctly. But there is No file generated for tables having empty data. I am expecting at least the column data to be present in the parquet file.