BigQuery language server

• Go 1.16 or later
• CGO enabled (CGO_ENABLED=1)
• Recommended to use clang++ compiler
• Set CXX environment variable if needed (e.g., export CXX=clang++)

Download the latest binary from GitHub Releases and place it in your PATH.

export CGO_ENABLED=1
export CXX=clang++
go install

gcloud auth login
gcloud auth application-default login

You can use bqls.nvim to integrate BigQuery with Neovim.

You can specify your BigQuery Project ID and location in the configuration. If not specified, the plugin will use gcloud config get project for the Project ID and US as the default location.

require("lspconfig").bqls.setup({
  settings = {
    project_id = "YOUR_PROJECT_ID",
    location = "YOUR_LOCATION",
  },
})

You can change project_id with workspace/didChangeConfiguration.

vim.lsp.buf_notify(0, "workspace/didChangeConfiguration", { settings = { project_id = "ANOTHER_PROJECT_ID", location = "ANOTHER_LOCATION" } })

You can use bqls-vscode.

In order to save for spreadsheet, you should enable Google Drive API.

1. Enable Google Drive API and Google Sheets API
2. gcloud auth application-default login --scopes=https://www.googleapis.com/auth/cloud-platform,https://www.googleapis.com/auth/drive

• textDocument/formatting
• textDocument/hover
• textDocument/completion
• textDocument/definition
• textDocument/codeAction
• workspace/executeCommand
  • bqls.executeQuery
  • bqls.listDatasets
  • bqls.listTables
  • bqls.listJobHistories
  • bqls.saveResult
• workspace/didChangeConfiguration
• bqls/virtualTextDocument