Hey @fordicejw!
Given that the account has admin access it BigQuery I'd imagine it has sufficient permissions to show GUI mode. Would you mind sharing a screenshot of your resource setup screen as well as how you have permissions configured on the BigQuery side?
You can DM me as well or write in to us from within your Retool instance if there are any parts you're willing to share just not publicly.