# Google BigQuery access share

#### Select correct project 

1. Login into Google Cloud Console (BigQuery). \
   <https://console.cloud.google.com/bigquery&#x20>;
2. Select a project which contains datasets. \
   Select the correct project with the top left button.

![](https://lh6.googleusercontent.com/ceWBJSgTru2ijYGO5QcaDzV9INcl-IEWEXCxbrbuRFU6ttk_JCb_da6CGObVuq9BFVeRiL2SuIqmfRlPY8aWiLN-uaYf5_1_92asSFnfvcZPXd8ofkBJdJc8OjcsYyt6q_NBQnFOPB-G1Tw-qw)

#### Create Service Account&#x20;

1. Navigate to the “Service Account” section and press the “Create service account” button.

![](https://lh4.googleusercontent.com/spbCwLAabFguMCCjxdvcYgja5rU-qFZMzVp76C_h9qVvdr2UxgiGphSBpkZO2FmkBsPKeBDoQ21RI5lYec2w6M7hh4t6CqHDL-ajn0lOx3OLGHPkjYtMF8k3nP-xb4EPZyn_q4KX380UrFPUkw)

&#x20;  2\. Fill in required fields and press the “Create and continue” button.

![](https://lh3.googleusercontent.com/vB3t4uvpuiWqlxuG-XfNjjeCPzebi7OzdbbptXNQMTD4dOK1yF50wmGYn6HDlv7jLfoqltj-aea0h8AYMWoZaz4RTYajzW90VUYKgb1Cm48ZQ4IZugH26-9hclEGj1lQfuTrHKF7CDP-zswi2w)

&#x20;  3\. Select the required roles (DataViewer, ReadSessionUser, JobUser).

![](https://lh5.googleusercontent.com/r_NPdMPMGin-cPPDlNBXyKYMk_d5i9ykWKwhokgSxfuArZzNdKcj2PsHzsVvQRFxAUzlGz6mHoZLSssS6o7lwJDlOwRheReo3aB59dCJMzA4LO3bn_eEP56VnXESwenRhw5GMygsPiXFCV17_g)

&#x20;  4\. Finish account creation.&#x20;

![](https://lh3.googleusercontent.com/bdZpnrJs00XY8kveLQ8qL8sfdsAIBJUI7OEwqcrk1iUy_upqWRbxz_mNRPJ_6qBWybS2jQXPjeVDNPVt5-g9gapaLLp71-DvSKiXqCPT3ZXS2HREuZ8pBrZKkrRrQNZDc-KH2Jdg-E0klzkb3w)

&#x20;  5\. Navigate to the “Manage keys” section of the newly created account.

![](https://lh3.googleusercontent.com/qY1uVDuGiC4yo0TYo_hC1F_8sMXX5EGL7j4EBtG8w508ckEBmXbCyBR0T4dH7FFKcl4pUJigaRhV9x24A4Cd1kN99QimdYzNW5jzvPIaTzYpspUZ_T6EoTVVLPigEO2cCHn7lLqWEX7BDP_ZQQ)

&#x20;  6\. Create new key.

![](https://lh5.googleusercontent.com/DmF5-OG2q8cKfUxWrTJ3_A_K3XVGSb2MxB5O6GHyEuk2DJGbdEmYQrzfQZcbG-4tzS3IpfM7mSfsm2Q16cN5fTeqNPvMYxYFL2i9PKi7_YuDfEVTFHlbeuY7MvC6cqveI0im2J5trTYwsB1Sjg)

&#x20;  7\. Export key as json, downloaded json file is required for Assetario integration.

![](https://lh6.googleusercontent.com/HJac5zu7rR5Rs8gAU_YHnyvnC1pcACHx-7X4PqigLIevtwsRurg3tiGN_qsy_GFXo2o3YauUo6I8fzYW3O4g3R6lPoyZEqCRnA4OmJfJYLEa01Huw-AcTE9srrjAoJIwFhDwh92DFT56jgO-ow)

#### **Sharing BigQuery dataset with Assetario role**

1. Create a new dataset for Assetario - it will only be used for materialized views, created by running queries in BigQuery, which will expire once not needed anymore.

![](https://lh3.googleusercontent.com/b64wx3lxMeFlm8APc00Aix-YQeinkXVUUaKWgD5mjMR8kkdcwesfND9IFj1SbFlOoxwHr6RbIftoBmol1cu_AUPm7qv7X9UXCQo6XRoA8XAbAIb1aLHWiQbf5L2u1vAhbQDe_MmQzS8xqfSUJA)

2\. Fill in required fields and press the “Create dataset” button.

![](/files/p0c8krQvqS6IJ4Souq0s)

&#x20;  3\. Open the newly created dataset.

![](https://lh3.googleusercontent.com/e7Re83wVBTYxWtPb8KQ3aarq5Y5YDz2WzXNFckRem4a516ISyfnkMBftKwB9804AUtE6icM9IgNqKpSYp3z2QAta3gmR9hyG0VJK99MZZrtnZ6Kb2b0JxJhyv3_2-24yr5cWI6bioH-CgpmE3g)

&#x20;  4\. Press the “Share Dataset” button.

![](https://lh6.googleusercontent.com/x3b9xC6H_VMvW1fboytw7cr4UxPzBa7N1RQ2xyoMjX6QfCjqiMYNqDq1_779m7HBcy7GRFGbfXOIULPEofitXMI07RaDm4tmCuwFa-bKS2j94R7MczOvjSHvYmBOvZ08HxK2pjp2lWDugiAVPA)

&#x20;  5\. Fill in service account id and “BigQuery Data Editor” role.

![](/files/8QJHkwTfOVrGMQj83QJZ)

&#x20;  6\. Press “Add” to add permissions and check if the service account is added to the “BigQuery Data Editor” section. Press “Done” if the service account is shown in the section.

![](/files/iPUVWclbDkt28PCJI0aE)

![](/files/fhJWuo42J57xGMS6hIO6)

#### **Sharing BigQuery access with integration\@assetario account**

1. Open dataset.

![](https://lh3.googleusercontent.com/e7Re83wVBTYxWtPb8KQ3aarq5Y5YDz2WzXNFckRem4a516ISyfnkMBftKwB9804AUtE6icM9IgNqKpSYp3z2QAta3gmR9hyG0VJK99MZZrtnZ6Kb2b0JxJhyv3_2-24yr5cWI6bioH-CgpmE3g)

&#x20;  2\. Press the “Sharing” button and select “Permissions” option.

![](https://lh3.googleusercontent.com/cZmJY24_96U4i9sdwLJZlOcY4UqBxkfYrNW3OP4R_wjyuBFLHaN-eZACPtlcD4_s94rCUrleQ8pbdpN33A7uGKWbzZte7SUxZMXbY6lUgf96fKNEI2F_2Abg9GnzyE5JJILAS7FmzwRPWHmWQA)

&#x20;  3\. Click on “Add Principal” button.

![](/files/ZgZjZdIogofMPuqfDv99)

&#x20;  4\. Fill in “<integration@assetario.com>” and select “BigQuery Data Viewer” role.

![](https://lh4.googleusercontent.com/PpSOei5FizXl_lrLtuff3_N3dL08kaQDvDxVlviEVtEfarWNnfTuMQbX9VrxvhQn4mZt6VAj2jJZOsQ-bO0Vi6FLwNzoBzFIi0xAzkz_rDbDrO7DzRiuZ2NCDMZlSFMotTULr20IySujqY0AqQ)

![](https://lh4.googleusercontent.com/V3wRAe1IZ0AwL9NrCnA9Z5rSDhptf3AO2ibt2LVmGb4lbz0QhA-uF7rE1PACCM6ZG6lMSBdZ-gAqQC305yQcy9RDzM3pJ1SN1KnjyV27el3e9B3aPSi2SuxzvL2TQ9U-TCpv1oqHJltJu16h2Q)

&#x20;  5\. To add a write permissions, follow the same process, but choose “BigQuery Data Editor” instead of “BigQuery Data Viewer”.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.assetario.com/docs/integration/data-input-integration-guides/google-bigquery-access-share.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.