AUTOINCREMENT primary key for snowflake bulk loading
I would like to upload data into snowflake table. The snowflake table has a primary key field with AUTOINCREMENT.
When I tried to upload data into snowflake without a primary key field, I've received following error message:
The COPY failed with error: Number of columns in file (2) does not match that of the corresponding table (3), use file format option error_on_column_count_mismatch=false to ignore this error
Does anyone know if I can bulk load data into a table that has an AUTOINCREMENT primary key?
knozawa
You can query the stage file using file format to load your data. I have created sample table like below. First column set autoincrement:
-- Create the target table
create or replace table Employee (
empidnumber autoincrement start 1 increment 1,
name varchar,
salary varchar
);
I have staged one sample file into snowflake internal stage to load data into table and I have queried stage file using following 
and then I have executed following copy cmd:
copy into mytable (name, salary )from (select $1, $2 from @test/test.csv.gz );
And it loaded the table with incremented values.
- Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object
- SQL Server: drop table primary key, without knowing its name
- SQL function to convert ulid stored as VARCHAR(255) to binary(16)
- Duplicate Entry Key error when initial 6 characters match
- automatically insert auto increment primary key and values into existing table
- SQL Server add auto increment primary key to existing table
- alter table drop column syntax error using sqlite
- Do I need to declare a unique constraint for `bigint generated always as identity`?
- How to retrieve the last autoincremented ID from a SQLite table?
- Inserting a row and returning its primary key
- Some sort of “different auto-increment indexes” per a primary key values
- Is there AUTO INCREMENT in SQLite?
- Paging results from a table having a varchar as PK
- Difference between primary key and unique key
- How to reset Postgres' primary key sequence when it falls out of sync?
- Create view with primary key?
- How to add an auto-incrementing primary key to an existing table in PostgreSQL?
- Primary key effect on performance
- Disabling primary key index while inserting
- Foreign Key Used in Composite Primary Key
- Using Rails, how can I set my primary key to not be an integer-typed column?
- Extending IntIdTable in Kotlin Exposed PSQL does not inherit primary key
- What is the difference between a primary key and an index key
- Django queries when to use "id" vs "pk"?
- How do I correctly set the GENERATED BY DEFAULT AS IDENTITY sequence after inserting manual ids?
- Insert inserted id to another table
- Oracle (ORA-02270) : no matching unique or primary key for this column-list error
- spatie/laravel-medialibrary change primary key
- How to delete all the entries in the database and reinitialize it completely including the primary keys when reinstalling the app in Android, Room?
- Is this the correct way of making primary keys in django?