Grant access to BigQuery datasets
Last updated
Last updated
By default, Whaly will only have access to the Datasets created by Whaly connectors. In order to grant access to already existing BigQuery Datasets, you should follow those steps:
Go to the BigQuery Admin Console
On the left panel, click on one Dataset name (ex. "Days") to open it
On the Dataset page, click on "Sharing > Permissions" menu item
In the side panel that opens, click on "Add Principal"
In the "New principals" search bar, select the Service Account configured in Whaly. And in the "Assign roles", select the "BigQuery Data Viewer" role.
Click on "Save"
And that's it! Whaly will now let users import tables from this BigQuery Dataset ๐