About JAG

JAG · 11-09-2022

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 ...

JAG · 09-20-2022

This little piece of information seems to be missing.

JAG · 01-17-2023

Easy to say but the management of permissions is totally out of control. There's nothing easy about this environment.

JAG · 11-15-2022

From the Support team...It's clear now that dropping a column using the CLI caused the BigQuery schema to be in a state where the schema json was out of sync with the actual table, so when Appsheet receives the API response from BigQuery, this differ...

JAG · 11-14-2022

From the Support team...We have reproduced the error with your app while adding the 'broker_accounts' table. The issue is thrown from the BigQuery provider itself when adding the table to Appsheet, and Appsheet is displaying that message verbatim. Co...

JAG · 11-09-2022

OK. I deleted the old AppSheet application. And created a totally new AppSheet application. But I still cannot use the table; broker_accountsData table 'broker_accounts' is not accessible due to: The service bigquery has thrown an exception. No HttpS...

JAG · 10-05-2022

@julianjones Thanks for the fixes.I ran a few simple tests of all data types, and confirmed that values are being inserted into BQ tables correctly. I also confirmed that NULL values can also be inserted.

My Stats

JAG's Bio

Badges JAG Earned

Recent Activity

Failure Regenerate Structure after changing BigQuery table

How to file a bug?

Re: Why should you move from self-hosted Airflow to Google Cloud Composer?

Re: Failure Regenerate Structure after changing BigQuery table

Re: Failure Regenerate Structure after changing BigQuery table

Re: Failure Regenerate Structure after changing BigQuery table

Re: Data Types for Decimals/Currency Appsheet > Bigquery