-
Goal: I want to update dynamically a table and it's fields with GUI mode using Bulk update but it seems I cant use it.
I'm using Google Cloud platform, GCStorage and Big Query. -
Steps: I checked authorizations and it seems both reading and writing in the table is enabled, is the problem linked to Big Query directly ?
-
Details: It seems GUI mode is enabled on Retool Database but not for Big Query.
-
Screenshots: I've shared a screenshot of my problem.
-
App json export: (here's how to get a json export)
1 Like
Hey @Archyve! Thanks for reaching out.
How are you authenticating the resource? I ask because the GUI mode is only supported when using the Service Account option.
Hi Darren, thanks for your reply,
The ressource is authenticated as such in the image, I hope it helps.
You may have attached the wrong screenshot. You should be able to see the two authentication options as shown below.
1 Like
Yes! Thank you. Do you happen to know if this particular resource was ever configured to use OAuth authentication? I'm pretty sure there's a bug causing GUI mode to remain disabled even after switching to use Service Account authentication.
The other possibility here is that the service account you've defined and specified here doesn't have the requisite permissions, but you specifically mention that you checked those.
1 Like
I think I ran into this today. I made a new Resource a few days ago. At first I was trying to set up this Resource to use oAuth, but then switched to Basic Auth. When I write queries with this Resource, the GUI option is always disabled. I found this post, so I decided to create a new Resource (same config, but never set it to oAuth) and the GUI option is enabled! Thanks for sharing!
2 Likes