search

kestra-io / plugin-gcp

Apache License 2.0
6 stars 10 forks source link

Support BigQuery JSON columns #340

Closed zerobearing2 closed 7 months ago

zerobearing2 commented 7 months ago

Feature description

We'd like to "select" JSON columns from BigQuery into the output. Currently when attempting a simple select that contains JSON column, we get the following error:

Example select:

select data from my_table limit 1

Error:

Invalid type 'JSON'

Example task:

  - id: "query"
    type: "io.kestra.plugin.gcp.bigquery.Query"
    projectId: my-project
    serviceAccount: "{{secret('GCP_SERVICE_JSON')}}"
    fetchOne: true
    sql: |
      select data from my_table limit 1