Add support for vim-dadbod BiqQuery adapter

mbhynes commented 7 months ago

Summary

This PR adds support for BigQuery, an OLAP database provided by Google, as a BigQuery adapter was recently added to vim-dadbod with https://github.com/tpope/vim-dadbod/pull/125
This PR adds functionality for bigquery::// connections

Notes for Reviewers

Dependencies for Running / Testing

The new adapter depends on having the bq CLI provided by the google cloud CLI is in the user's $PATH, configured to authenticate with some google identity credentials
As such, running & testing this requires installing the gcloud CLI (installation instructions) and having a google account. (Users interested in using vim-dadbod-ui for running queries against BigQuery will almost surely have gcloud and bq installed already)

Added variable

I've added a global variable g:db_adapter_bigquery_region, to allow users to parameterize the schema query against the INFORMATION_SCHEMA.TABLES (the default is region-us)
```
let s:bigquery_schema_tables_query = printf("
  \ SELECT table_schema, table_name
  \ FROM `%s`.INFORMATION_SCHEMA.TABLES
  \ ", g:db_adapter_bigquery_region)
```

Example Screenshot

vim-dadbod-ui2

mbhynes commented 7 months ago

Hi @kristijanhusak, I'm wondering if you might review this & consider adding it to the project?

kristijanhusak commented 7 months ago

I waited for upstream PR to be merged. I didn't test this since I'm not a BigQuery user, but I assume it works. If there are any issues please open up a separate PR. Thanks!

guilhermeprokisch commented 4 months ago

I'm still not able to list my databases and tables even setting the db_adapter_bigquery_region varaible which is "region-eu" in my case.

I'm missing something?

kristijanhusak / vim-dadbod-ui