manojchit
New Contributor
Joined 2 years ago
User Profile
User Widgets
Contributions
PostgreSQL Bulk Upload
Is there a way to remove the PRIMARY_KEY from insert query getting triggered from PostgreSQL Bulk Load Snap. Issue is when the Snaplogic trying to insert data into postgreSQL the PRIMARY_COLUMN is going as NULL which is causing while inserting record into postgreSQL database. NOTE: If we remove the ID column which is the primary from been serialized than it will be auto generated as it is set as AUTO INCREMENT. I tried mapper as well to remove the ID column to not included in INSERT query but it didn't worked out. Any suggestions from anyone.1.4KViews0likes1CommentPostgreSQL Bulk Upload
When the INSERT query getting fired from Snaplogic, the PRIMARY_KEY is going as null which is causing issue to insert the data in the destination PostgreSQL database. The primary key column is auto-increment but since from the query we are passing it null, getting primary_key constaint issue as it cannot be null. So is there any way to ignore the ID column from been added in the INSERT query getting triggered from PostgreSQL Bulk Load Snap. I tried Mapper but didn't worked. Any suggestions from anyone...?1.2KViews0likes1Comment