Set up github actions worflow in your data-access-requests repository
Create a service account in Bigquery Data Warehouse for terraform execution with the following permissions :
Download and save the secrets .json file from the terraform service account in Bigquery. Store the secrets in GITHUB actions secrets
Raise a JIRA ticket/task with the summary for access request. The agent analysis, code generation and PR creation flow begins.
Further, if you want to grant access to the user based on the analysis + the terraform code, then go ahead and merge the PR. If not, close the PR.