How load data in table with AUTO_INCREMENT

Help Connectors and Pipelines
1

We are currently moving data from SqlServer i to SingleStore. Some tables have an Identity PK. We map this to AUTO_INCREMENT however it is not possible to load existing values into the PK through the pipeline (json format). Is there a way to temporary switch of the auto increment column in such a way that we can load existing pks into the table?

2

You can’t turn off generation, but if the external data specifies an auto increment, we won’t overwrite it / generate new ones, instead just use the one in that data.

1 Like