To run queries and export data using the BigQuery web UI, proceed as follows:

1. Open Google Cloud Console. Make sure you use an account that was previously added to your Open Data access-group. You can double-check the active account in the top right corner.
2. Select your Open Data project.
3. Open BigQuery from the menu.
4. Click the name of the view you want to work with.
5. Click the Query view button and compose your query.
6. Click the Run button to execute your query.
7. Download the results by clicking the Save results button.

To make programmatically data fetching possible from Open Data, we prepared a Service Account. You can generate a new API key for your Service Account by following the steps in the Creating an API key section.

By default, we provide the possibility to use Big Query API with Open Data to make direct HTTP requests to BigQuery. Google provides client library code for all their Cloud APIs that make it easier to access them from your favorite languages. You can access the detailed REST documentation here or the available client libraries here.

If you want to export result sets larger than 16.000 rows or 10 MB, you’ll need to save the data into the editable_dataset and then export it into a bucket before downloading. To export large result sets, proceed as follows:

1. Follow steps 1-6. in the Exporting data manually section.
2. Click Save results and choose the BigQuery table.
3. Choose editable_dataset as target and specify the Table name.
4. Click Save and wait until the export is ready.
5. Choose the table on the left pane under editable_dataset.
6. Click Export and choose Export to GCS.
7. Configure your export, click the Export button, and wait until the export is ready.
8. To browse your exports, follow the steps in the Cloud Storage Bucket section.

To learn more about BigQuery exports, refer to Google’s support pages.

• Open Data - End-user guide
• Managing access
• Imports and the editable dataset
• Working with Open Data