I use stitch to send data to big query, it appears than on some table I get duplicates row.
For instance I have a table user, in this table the email column is unique
if I run
SELECT count(*) FROMuser
group by email order by 1 desc
on my database I get only 1 user for each email
in big query I get 970 users for 1 email
it seems the column “_sdc_extracted_at” is creating duplicates…
Does anyone know how to fix that?