Snowflake Bulk Loader output error 'field does not exist'

[nataliamiteva]

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!

[danilang]

Hi @nataliamiteva 

Before you can add data including the new column you'll have to add the column.  Since it looks like you're okay with deleting the existing data with overwrite/drop, you might want to check out this post and adapt the syntax to Snowflake  

Dan

[nataliamiteva]

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!!! 

[danilang]

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]

Hi @danilang, yes, I changed it to DealType