btcli

btcli is a CLI client for the Bigtable. Has many read options and auto-completion.

Features

btcli is the cloud bigtable client tool. Connect to your bigtable instances and any read items with auto-completion.

write commands are not implemented yet

Compare to cbt

cbt is an official bigtable client tool

• btcli has auto-completion
• btcli can decode a big-endian values
• btcli has a filter for value, version and family
• A print format that same as the cbt

Installation

go get -u github.com/takashabe/btcli/cmd/btcli

Require go1.11 or later and GO111MODULE environemnts

Usage

Connect to bigtable

btcli -project <GCP_PROJECT_NAME> -instance <BIGTABLE_INSTANCE_ID> -creds <GCP_CREDENTIAL_FILE>

-creds e.g. ~/.config/gcloud/application_default_credentials.json

Subcommand and options

• ls

List tables

ls          List tables

• count

Count rows in a table

count <table>

• lookup

Read from a single row

lookup <table> <row> [family=<column_family>] [version=<n>]
        version        Read only latest <n> columns
        decode         Decode big-endian value
        decode-columns Decode big-endian value with columns. <column_name:<string|int|float>[,<column_name:...>]

• read

Read rows

read <table> [start=<row>] [end=<row>] [prefix=<prefix>] [family=<column_family>] [version=<n>]
        start          Start reading at this row
        end            Stop reading before this row
        prefix         Read rows with this prefix
        value          Read rows with has value
        family         Read only columns family with <columns_family>
        version        Read only latest <n> columns
        from           Read cells whose version is newer than or equal to this unixtime
        to             Read cells whose version is older than this unixtime
        decode         Decode big-endian value
        decode-columns Decode big-endian value with columns. <column_name:<string|int|float>[,<column_name:...>]

Environments

Support commands

Read commands

• [x] ls
• [x] count
• [x] lookup
  • [x] version
  • [x] decode
  • [x] decode-columns
• [x] read
  • [x] start
  • [x] end
  • [x] prefix
  • [x] value
  • [x] family
  • [x] version
  • [x] from
  • [x] to
  • [x] decode
  • [x] decode-columns

Write commands

• [ ] createfamily
• [ ] createtable
• [ ] deletecolumn
• [ ] deletefamily
• [ ] deleterow
• [ ] deletetable
• [ ] set
• [ ] setgcpolicy

Others

• [x] help