This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

Failure Regenerate Structure after changing BigQuery table

Posted on 11-09-2022 06:06 PM
JAG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

So... looks like there are some more issues with have BigQuery tables as a data source. In my case, a table has been altered to remove a column. Trying to 'Regenerate Structure' fails with...

Data table 'broker_accounts' is not accessible due to: The service bigquery has thrown an exception. No HttpStatusCode was specified. Job hi-internal-dev-ef04/US/job_0a36f9a8_1b02_4790_9d4c_86fac18f344e contained 2 error(s). First error message: Unrecognized name: bbg_routing_id at [1:276].

I suspect that any kind of change to a table will result in the same.

0 4 832
Topic Labels
0 Likes
Reply
4 REPLIES 4
Top Labels in this Space