> For the complete documentation index, see [llms.txt](https://docs.assetario.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.assetario.com/docs/integration/data-input-integration-guides/google-bigquery-access-share.md).

# 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”.