Skip to content
Branch: master
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
examples
Dockerfile
README.md
cloudbuild.yaml

README.md

bq

This is a tool builder to simply invoke bq commands.

Arguments passed to this builder will be passed to bq directly, allowing callers to run any bq command.

When executed in the Cloud Build environment, commands are executed with credentials of the builder service account for the project.

The latest available version of bq is used.

Examples

The following examples demonstrate build request that use this builder:

For these to work, the builder service account must have permission to create tables on the test dataset.

Load a BigQuery table from a local file

This cloudbuild.yaml invokes bq load to load a table from a file in the build's workspace.

steps:
- name: gcr.io/community-builders/bq
  args: ['load', 'my_dataset.my_table', 'local-file.csv', 'local-schema.json']

Save query results to destination table

This cloudbuild.yaml invokes bq query to run a query and write results to a BigQuery table.

steps:
- name: gcr.io/community-builders/bq
  args:
  - query
  - --use_legacy_sql=false
  - --destination_table=test_dataset.bobs_from_builder
  - >
    SELECT SUM(number) AS total_bobs, year
    FROM `bigquery-public-data.usa_names.usa_1910_current`
    WHERE name = 'Bob'
    GROUP BY year

Building this builder

To build and test this builder the builder service account must have permissions to create BigQuery query jobs for the project, such as with the BigQuery User Role.

You can’t perform that action at this time.