wayfair-incubator / bigquery-buildkite-plugin Goto Github PK

This issue lists Renovate updates and detected dependencies. Read the Dependency Dashboard docs to learn more.

Rate-Limited

These updates are currently rate-limited. Click on a checkbox below to force their creation now.

• Update dependency proto-plus to v1.23.0
• Update dependency protobuf to v4.25.3
• Update dependency pyasn1 to v0.6.0
• Update dependency pyasn1-modules to v0.4.0
• Update dependency pyparsing to v3.1.2
• Update dependency pytest to v7.4.4
• Update dependency pytest-cov to v4.1.0
• Update dependency pytest-mock to v3.14.0
• Update dependency python-dateutil to v2.9.0.post0
• Update dependency typing_extensions to v4.11.0
• Update actions/checkout action to v4
• Update actions/setup-python action to v5
• Update actions/stale action to v9
• Update actions/upload-artifact action to v4
• Update codecov/codecov-action action to v4
• Update dependency flake8 to v7
• Update dependency mypy to v1
• Update dependency packaging to v24
• Update dependency protobuf to v5
• Update dependency pytest to v8
• Update dependency pytest-cov to v5
• 🔐 Create all rate-limited PRs at once 🔐

Open

These updates have all been created already. Click a checkbox below to force a retry/rebase of any.

• Update dependency pydantic to v1.10.13 [SECURITY]
• Update dependency idna to v3.7 [SECURITY]
• Update dependency requests to v2.32.0 [SECURITY]
• Update dependency black to v24 [SECURITY]
• Update dependency bandit to v1.7.8
• Update dependency google-api-core to v2.19.0
• Update dependency google-auth to v2.29.0
• Update dependency google-cloud-bigquery to v3.23.0
• Update dependency googleapis-common-protos to v1.63.0
• Update dependency grpcio-status to v1.64.0
• Update dependency isort to v5.13.2
• Click on this checkbox to rebase all open PRs at once

Ignored or Blocked

These are blocked by an existing closed PR and will not be recreated unless you click a checkbox below.

• Update dependency urllib3 to v1.26.18 [SECURITY]
• Update dependency grpcio to v1.53.0 [SECURITY]
• Update dependency wheel to v0.38.1 [SECURITY]
• Update dependency certifi to v2023 [SECURITY]
• Update dependency pip to v23 [SECURITY]
• Update dependency setuptools to v65 [SECURITY]
• Update actions/checkout digest to f43a0e5
• Update actions/setup-python digest to 65d7f2d
• Update actions/stale digest to f7176fd
• Update actions/upload-artifact digest to a8a3f3a
• Update codecov/codecov-action action to v3.1.6
• Update dependency gbq to v1.0.4
• Update dependency cachetools to v5.3.3
• Update dependency flake8 to v6.1.0
• Update dependency google-cloud-core to v2.4.1
• Update dependency google-resumable-media to v2.7.0
• Update dependency charset-normalizer to v3

Detected dependencies

• Check this box to trigger a request for Renovate to run again on this repository

Description

• Currently if pipeline fails to deploy schema for a given object fails, the pipeline still the final result as passed

It would be useful for our project if we could have buildkite create BigQuery database objects using SQL DDL statements rather than json-formatted schema descriptions.

In priority order, it would be helpful for us to have:

• Table creation. CREATE TABLE x ( ) or CREATE TABLE x AS SELECT FROM y We would like to have support for CLUSTER and PARTITION clauses.
• View creation
• Stored procedure creation

We currently use tables and views extensively, and we have used BQ stored procedures in the past. With regard to table creation, our current approach is to drop and rebuild the table upon each merge event. However, other teams might like to see the ability to alter table add column without dropping existing table (ie preserve existing data). Another point to note is that when changing the partition key, BQ does not allow CREATE or REPLACE in one step. In order to change partitioning, a 2-step process is needed, an explicit DROP TABLE, followed by the 2nd step CREATE TABLE.

Description

• Currently the plugin runs all the files in a directory that has changed
• The plugin should only execute files that are changed/updated in the current commit