Snowflake Bulk Loader output error 'field does not exist'

Question

Hello,

I got the error 'field does not exist' when adding a new column to a snowflake table. I am using the option to "Delete Data & Append" in a Snowflake Bulk Loader output.

I also tried the "Overwrite Table (Drop)" option but that produced the same error.

Does anyone know how to resolve this?

Many thanks in advance!

nataliamiteva · Answer

Hi @danilang, yes, I changed it to DealType

danilang · Answer

Hi @nataliamiteva

The error mentioned the field deal_type, but you added DealType(no underscore).  Did you change the name of the field in your workflow to match?

Dan

nataliamiteva · Answer

Thanks for the reply @danilang!

I tried the following syntax but still getting the same error :( (

ALTER WAREHOUSE xxx RESUME IF SUSPENDED;

USE WAREHOUSE xxx;

ALTER TABLE xx ADD COLUMN DealType VARCHAR(60);

alter session set client_timestamp_type_mapping=timestamp_ntz

Am I missing something?

Thanks!!!