Skip to main content

Inconsistent count results on the same table in different columns

Comments

1 comment

  • Alon Brody

    The most likely explanation for this outcome is that you configured your data source to send your data to one static destination table, and also did not define a Primary Key (PK).

    The reason this would cause a problem is because the default PK is the id column. If an id column exists in the source, it will be used as the PK of the destination table. If you have data with the same id value in each table, the second ingested record with that id overrides the first (existing) record with that id.

    In terms of solutions, one approach is to upload each of the tables into a different destination tables. Note that you can also configure dynamic destination tables.

    Regardless of how many source tables you have, the important thing to ensure is that the records on the destination table(s) each have a unique primary key.

    For more detail, see the documentation on these topics:

    0

Please sign in to leave a comment.

Powered by Zendesk