Segment to BigQuery integration permission issue
As the title says, I'm having some permission issues integrating Segment with BigQuery using these docs here: https://segment.com/docs/connections/storage/catalog/bigquery/
My main issue is in the section labeled `Create a Service Account for Segment` and more specifically, step 4. When I try to assign those two roles to the Service Account in BigQuery, I cannot, as they do not appear in the drop down, see screenshot:
When I navigate to `Manage Roles` I am able to see these roles exist and are enabled:
This is the error I am getting in Segment when the connection is attempted:
We were unable to ensure that the "ruby" dataset exists. The error was: googleapi: Error 403: Access Denied: Project data-warehouse-#######: User does not have bigquery.datasets.create permission in project data-warehouse-######., accessDenied.
What am I doing wrong here? How can I get these roles assigned correctly?
Posted Dec 6, 2023, 5:32 PM UTC
20