Saving and Sharing Queries in BigQuery

BigQuery allows users to save queries for future use and share them with collaborators. This guide explains how to save queries, manage permissions, and share them effectively.

 

1. Saving a Query in BigQuery

Open the BigQuery Query Editor and type your query.

 

Execute the query to ensure it runs successfully (It is optional step).

Click on the "Save query" button -> select Save query option.

 

In the "Save query" popup, enter:

 

·      Name: A meaningful name for your query.

·      Region: Choose the region where the query should be stored.

 

Click the "Save" button.

 

The saved query will now be available under the Queries section.

 

2. Sharing a Saved Query

Click on the three vertical dots next to the saved query.

 

Select "Share" from the dropdown menu. 

 

You will see two sharing options:

a.   Manage Permissions

b.   Copy link

 

2.1 Manage Permissions

Click "Manage Permissions" to open a sharing form.

 

Click on the button ‘Add User/Group’ to add users or groups who need access.

 

Assign roles:

·      Code Owner – Full access, including sharing.

·      Code Editor – Edit access.

·      Code Viewer – Read-only access.

Click "Save" to apply changes.

 

b. Copy Link

Click "Copy Link" to copy the query's shareable link. You can send this link to collaborators for quick access.

 

Previous                                                    Next                                                    Home