@vulcan-sql/extension-driver-bq NPM | npm.io

0.10.4 • Published 3 months ago

Install

Weekly downloads

-

License

Apache-2.0

Repository

Last release

3 months ago

extension-driver-bq

nodejs-bigquery driver for Vulcan SQL.

Install

Install package
```
npm i @vulcan-sql/extension-driver-bq
```

Update vulcan.yaml, enable the extension.

extensions:
  bq: '@vulcan-sql/extension-driver-bq'

Create a new profile in profiles.yaml or in your profiles' paths.

⚠️ Your service account must have the following permissions to successfully execute queries.
BigQuery Data Viewer
BigQuery Job User

- name: bq # profile name
  type: bq
  connection:
    # Location must match that of the dataset(s) referenced in the query.
    location: US
    # Optional: The max rows we should fetch once.
    chunkSize: 100
    # The project ID from the Google Developer's Console, e.g. 'grape-spaceship-123'. We will also check the environment variable `GCLOUD_PROJECT` for your project ID. If your app is running in an environment which [supports](https://cloud.google.com/docs/authentication/production#providing_credentials_to_your_application) Application Default Credentials), your project ID will be detected.
    projectId: 'your-project-id'
    # Full path to the a .json, .pem, or .p12 key downloaded from the Google Developers Console. If you provide a path to a JSON file, the `projectId` option above is not necessary. NOTE: .pem and .p12 require you to specify the `email` option as well.
    keyFilename: '/path/to/keyfile.json'

Testing

nx test extension-driver-bq

This library was generated with Nx.

To run test, the following environment variables are required:

BQ_LOCATION
BQ_PROJECT_ID
BQ_CLIENT_EMAIL
BQ_PRIVATE_KEY

vulcan vulcan-sql data sql database data-warehouse data-lake api-builder bigquery bq

inversify reflect-metadata class-transformer moment ms lodash toad-scheduler uuid js-yaml nunjucks axios glob tslog joi dayjs koa class-validator duckdb @google-cloud/bigquery @google-cloud/storage tslib

@infinitebrahmanuniverse/nolb-_vul @everything-registry/sub-chunk-995

0.10.4-dev.20240207.0

3 months ago

0.10.4-dev.20240202.0

3 months ago

0.10.4-dev.20240131.0

3 months ago

0.10.4-dev.20240130.0

3 months ago

0.10.4-dev.20240129.0

3 months ago

0.10.4-dev.20240126.0

3 months ago

0.10.4-dev.20240123.0

3 months ago

0.10.4-dev.20240122.0

4 months ago

4 months ago

4 months ago

4 months ago

4 months ago

9 months ago

0.8.1-dev.20230815.0

9 months ago

0.10.0-dev.20231015.0

7 months ago

0.9.1-dev.20230912.0

8 months ago

9 months ago

0.10.1-dev.20231017.0

7 months ago

0.10.0-dev.20231004.0

7 months ago

0.9.1-dev.20230904.0

8 months ago

0.10.0-dev.20230925.0

7 months ago

9 months ago

10 months ago

9 months ago

10 months ago

0.8.1-dev.20230818.0

9 months ago

7 months ago

7 months ago

0.10.0-dev.20231003.0

7 months ago

8 months ago

9 months ago

9 months ago

0.6.0-dev.20230708.0

10 months ago

10 months ago

0.10.0-dev.20231002.0

7 months ago

0.7.1-dev.20230727.0

9 months ago

0.10.0-dev.20231006.0

7 months ago

0.10.0-dev.20230927.0

7 months ago

0.9.1-dev.20230831.0

8 months ago

9 months ago

9 months ago

0.8.0-dev.20230807.0

9 months ago

0.10.0-dev.20231012.0

7 months ago

9 months ago

0.6.0-dev.20230709.0

10 months ago

9 months ago

0.9.1-dev.20230822.0

9 months ago

8 months ago

0.10.1-dev.20231018.0

7 months ago

0.7.2-dev.20230804.0

9 months ago

0.10.0-dev.20231005.0

7 months ago

0.9.1-dev.20230920.0

8 months ago

7 months ago

7 months ago

9 months ago

0.10.0-dev.20230928.0

7 months ago

9 months ago

10 months ago

10 months ago

10 months ago

0.4.0-dev.20230527.0

12 months ago

0.4.0-dev.20230602.0

11 months ago

0.4.0-dev.20230531.0

11 months ago

0.4.0-dev.20230526.0

12 months ago

0.4.0-dev.20230605.0

11 months ago

0.4.0-dev.20230601.0

11 months ago

11 months ago

11 months ago

11 months ago

0.4.0-dev.20230519.0

12 months ago

0.3.2-internal.1

12 months ago

0.3.2-internal.2

12 months ago

0.4.0-dev.20230530.0

11 months ago

12 months ago

0.4.0-dev.20230525.0

12 months ago

0.4.0-dev.20230529.0

11 months ago

0.4.0-dev.20230604.0

11 months ago

0.4.0-dev.20230518.0

12 months ago

11 months ago

11 months ago

0.4.0-dev.20230524.0

12 months ago

0.4.0-dev.20230528.0

11 months ago

0.4.0-dev.20230603.0

11 months ago

0.4.0-dev.20230607.0

11 months ago

0.3.2-dev.20230414.0

1 year ago

0.3.2-dev.20230416.0

1 year ago

0.3.2-dev.20230225.0

1 year ago

0.3.2-dev.20230227.0

1 year ago

0.3.2-dev.20230412.0

1 year ago

0.3.2-dev.20230418.0

1 year ago

0.3.2-dev.20230424.0

1 year ago

0.3.2-dev.20230420.0

1 year ago

0.3.2-dev.20230422.0

1 year ago

0.3.2-dev.20230428.0

1 year ago

0.3.2-dev.20230503.0

1 year ago

0.3.2-dev.20230501.0

1 year ago

0.3.2-dev.20230509.0

12 months ago

0.3.2-dev.20230507.0

1 year ago

0.3.2-dev.20230505.0

1 year ago

0.3.2-dev.20230413.0

1 year ago

0.3.2-dev.20230415.0

1 year ago

0.3.2-dev.20230224.0

1 year ago

0.3.1-dev.20230508.0

12 months ago

0.3.2-dev.20230226.0

1 year ago

0.3.2-dev.20230228.0

1 year ago

0.3.2-dev.20230417.0

1 year ago

0.3.2-dev.20230419.0

1 year ago

0.3.2-dev.20230301.0

1 year ago

12 months ago

0.3.2-dev.20230430.0

1 year ago

0.3.2-dev.20230425.0

1 year ago

0.3.2-internal.0

1 year ago

0.3.2-dev.20230427.0

1 year ago

0.3.2-dev.20230421.0

1 year ago

0.3.2-dev.20230423.0

1 year ago

0.4.0-dev.20230511.0

12 months ago

0.3.2-dev.20230429.0

1 year ago

0.3.2-dev.20230504.0

1 year ago

0.3.2-dev.20230502.0

1 year ago

0.3.2-dev.20230508.0

12 months ago

0.3.2-dev.20230506.0

1 year ago

0.3.2-dev.20230220.0

1 year ago

0.3.2-dev.20230221.0

1 year ago

0.3.2-dev.20230217.0

1 year ago

0.3.2-dev.20230218.0

1 year ago

0.3.2-dev.20230219.0

1 year ago

1 year ago

0.3.1-dev.20230213.0

1 year ago

0.3.1-dev.20230216.0

1 year ago

0.3.1-dev.20230215.0

1 year ago

1 year ago

0.3.1-dev.20230122.0

1 year ago

0.3.1-dev.20230123.0

1 year ago

0.3.1-dev.20230124.0

1 year ago

0.3.1-dev.20230125.0

1 year ago

0.3.1-dev.20230126.0

1 year ago

0.3.1-dev.20230127.0

1 year ago

0.3.1-dev.20230128.0

1 year ago

0.3.1-dev.20230129.0

1 year ago

0.3.1-dev.20230202.0

1 year ago

0.3.1-dev.20230206.0

1 year ago

0.3.1-dev.20230205.0

1 year ago

0.3.1-dev.20230204.0

1 year ago

0.3.1-dev.20230209.0

1 year ago

0.3.1-dev.20230208.0

1 year ago

0.3.1-dev.20230207.0

1 year ago

0.3.1-dev.20230120.0

1 year ago

0.3.1-dev.20230121.0

1 year ago

0.3.1-dev.20230131.0

1 year ago

0.3.1-dev.20230130.0

1 year ago

0.3.1-dev.20230117.0

1 year ago

0.3.1-dev.20230118.0

1 year ago

0.3.1-dev.20230119.0

1 year ago

0.3.1-dev.20230212.0

1 year ago

0.3.1-dev.20230210.0

1 year ago

0.3.1-dev.20230211.0

1 year ago

1 year ago

1 year ago

0.3.0-dev.20221103.0

2 years ago

2 years ago

2 years ago