Empty columns when importing from snowflake

I am trying to import data from a snowflake database table. When the data is imported 4 of the 10 columns are imported as completely empty ( all null values), however the column headers are correct.

I have also noticed that the columns which are empty are all obtained from a calculated function in SQL such as AVG or MIN. I don't know if this is related or not, but the table in snowflake shows the data correctly.

When I download the data from snowflake to csv and then import into snowflake, the data works just fine.