Insert data to Bigquery through AppSheet

[isaac-alaluf]

I have managed to make a connection between Appsheet and Bigquery. However, even though I can now see my dataset's tables in AppSheet, when I try to log data to those tables, it doesn't sync. I get the following error:

Unable to add row to table 'Data'. → The service bigquery has thrown an exception. No HttpStatusCode was specified. Job bq-appsheet-418804/US/job_1c83ac17_b605_4ad2_97e4_ba60d2a7c01c contained 2 error(s). First error message: Access Denied: Table bq-appsheet-418804:Dataset_Appsheet.Data: Permission bigquery.tables.updateData denied on table bq-appsheet-418804:Dataset_Appsheet.Data (or it may not exist).: Message[Access Denied: Table bq-appsheet-418804:Dataset_Appsheet.Datos: Permission bigquery.tables.updateData denied on table bq-appsheet-418804:Dataset_Appsheet.Datos (or it may not exist).] Location[ - ] Reason[accessDenied] Domain[], Message[Access Denied: Table bq-appsheet-418804:Dataset_Appsheet.Data: Permission bigquery.tables.updateData denied on table bq-appsheet-418804:Dataset_Appsheet.Data (or it may not exist).] Location[ - ] Reason[accessDenied ] Domain[]

I understand that if I can insert new records into BQ tables, is it correct?

[Stefi_Oancea]

Hi, 

Did you find a solution? I'm facing with the same problem...

[isaac-alaluf]

Yes, I did

Thank you so much

[amitk]

@isaac-alaluf 
Can you please share the solution? I am trying to implement something similar.

[isaac-alaluf]

For sure @amitk @Stefi_Oancea 

Actually I made two different steps:

1. Follow the instructions related on this link: https://support.google.com/appsheet/answer/11905680?hl=en#:~:text=The%20BigQuery%20data%20source%20p....

2. Verify that, when you finally connect to BQ through AppSheet, check the tables are not as "non-editable mode". 

That´s pretty much it