piperider icon indicating copy to clipboard operation
piperider copied to clipboard

Officially supports BigQuery

Open yu-iskw opened this issue 3 years ago • 3 comments

Is your feature request related to a problem? Please describe. We use BigQuery with dbt. It would be awesome for piperider to officially support it.

Describe the solution you'd like I would like piperider to support BigQuery.

Describe alternatives you've considered NA

Additional context NA

yu-iskw avatar Jul 21 '22 03:07 yu-iskw

Thanks for your feature request. This is our first priority in terms of data source integration. We will reply here if the integration is ready.

popcornylu avatar Jul 21 '22 05:07 popcornylu

Currently, dbt BigQuery supports 4 types of auth methods. ref: https://docs.getdbt.com/reference/warehouse-profiles/bigquery-profile#authentication-methods

However, sqlAlchemy bigquery hasn't supported access token. We decide not to support dbt method 'oauth-secrets' now. There was already a feature PR in sqlAlchemy bigquery project. Once this PR is merged, we can start to support dbt bigquery method oauth-secrets ref: https://github.com/googleapis/python-bigquery-sqlalchemy/pull/459

kentwelcome avatar Aug 11 '22 09:08 kentwelcome

PipeRider will start to support BigQuery from the next release.

kentwelcome avatar Aug 12 '22 02:08 kentwelcome

The PipeRider 0.7.0 had been released!

kentwelcome avatar Aug 25 '22 06:08 kentwelcome

Shortcut story sc-27764

popcornylu avatar Aug 26 '22 08:08 popcornylu