I’m not sure if it’s related, but I can’t get the BigQuery Denormalized destination to work from the Instagram source either, but mine says `sync worker failed.`:

I think there's a chance it is a similar issue, can you please share a bit more info about your issue ?

Oh there’s not much to it. I was intrigued to get denormalized data from instagram into BigQuery to see if it is easier to manipulate with data studio, but I can’t even get the connection to work at all. I’ve updated airbyte to the latest version, updated the BigQuery Denormalized destination, but I just don’t understand the logs enough to know why it’s not sending data over.

@Jordan Scott if you change to use the other Bigquery connector the sync works? Looks there is an error in a data type conversion.

Yes I already have the other BigQuery destination syncing well. Let me see if I can compare

Hey can you compare the date column values and see if they are getting stored in the same format

Hey @Harshith (Airbyte) seems that all of the fields that contain timestamps are appearing in the following format - 1647268924985 I believe that this is the core of the problem, is there any solution for that?

@Tamir Spector did you try to use the Bigquery not denormalized connector?