Information about "The structure of the table X is different from the query configured in the schedule" error

Have you ever received this error or similar when trying to insert your data in Big Query or AWS destination?

Don't worry, here we explain why it happens and how to fix it.

New UI - FAQ Getting started BQ

Error inserting data in "projectname_datasetname_databasename".
The structure of the "databasename" table is different from the query configured in the schedule.

What is the cause of this error?

This error appears when you try to insert data into a table whose configuration and characteristics are different from those of the data you are trying to insert.


In other words, most likely you have modified the metrics/dimensions/options or other transfer settings and these do not correspond to the ones you had in the table.

For example, if you have a table with 10 metrics and 3 dimensions in the table, and in Dataslayer you want to insert data into that table, the Dataslayer transfer must have exactly the same structure, that is, those 10 metrics and 3 dimensions. If it has more or fewer columns the error will appear.

If you have checked all the above and still get the error

Please send us through our web chat screenshots of the table on the platform and the transfer you have configured in Dataslayer and our technical team will check it thoroughly.

 

As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!