Issue

BigQuery Warehouse syncs failing with "Provided Schema does not match Table" error.

Product

Twilio Segment

Environment

Segment Console

Cause

We use Views in BigQuery warehouse to de-duplicate your data at query time. These errors usually occur due to a conflict with a table name when creating these BigQuery Views.

Resolution

1. You will have to rename the event that ends with view in your implementation, so it stops being generated.
   1. Changing it to anything other than view should address the issue. e.g. from page_view to page_views. 
2. Once that's done, you will have to disable the original table from syncing to your Segment warehouse.
   1. The renamed event will then create a new table in your warehouse, and allow syncs to go through.
3. Reach out to Segment Support for any questions or further issues.