Hello I am trying load data in to bigquery from mysql. So when I do meltano run then it's giving me success. It's creating schema also but it's not inserting any values. I am new to bigquery. Any help will be appreciated. Here is the extractor and loader configuration.

- name: tap-mysql_1_xxxxx
    inherit_from: tap-mysql    
    config:
      database: xxxx
      engine: mysql
      filter_dbs: xxxx
      host: xxxxxx
      port: 3306      
      ssl: false
      use_gtid: false
      user: xxxxx
      select:
      - xxxx.*

- name: target-bigquery_1_xxxx
    inherit_from: target-bigquery    
    config:
      project: xxxxxxx
      dataset: xxxxx
      credentials_path: 
        /xxx/meltanoxxxxx.json
      location: xxxx
      batch_size: 1000
      method: storage_write_api
      denormalized: true

which target version are you using?

@Love Eklund yeah I am using that one https://hub.meltano.com/loaders/target-bigquery/

then its probably the one i linked

@Love Eklund okay found it thanks.

If you see failed jobs then it is probably the bug I noticed, I have a fix on it on a fork I've created, I'll try to raise a PR so it can be merged into the main repo

yes I see it's failed

you can try changing your target to this

name: target-bigquery
  variant: z3z1ma
  pip_url:
    git+<https://github.com/loveeklund-osttra/target-bigquery.git@b1302d5>

and reinstalling it and see if that raises a proper error.

yeah sure I will have a look

@Love Eklund Yeah your fork works for the storage write api while the default one shows success but writes nothing