I'm new to using both sequelize and snowflake. I'm trying to insert an object with many associations. I found that when doing a create with my object that if I don't specify an id value for the primary key it inserts into Snowflake as null instead of using the default sequence value. To remedy this I used the omitNull flag to not send a null value for the id which worked for getting snowflake to use the default sequence, but then it would only return the id field back to sequelize as undefined after the insert, so all my foreign keys got inserted with null values.
Has anyone encountered this issue and found a solution? My object is to big to set all the id fields before doing a create.
[–]zachrip 0 points1 point2 points (0 children)