amaliujia commented on a change in pull request #13319: URL: https://github.com/apache/beam/pull/13319#discussion_r530100435
########## File path: website/www/site/content/en/documentation/dsls/sql/extensions/create-external-table.md ########## @@ -204,6 +205,131 @@ TYPE bigquery LOCATION 'testing-integration:apache.users' ``` +## Cloud Bigtable + +### Syntax + +``` +CREATE EXTERNAL TABLE [ IF NOT EXISTS ] tableName ( + key VARCHAR NOT NULL, + family ROW<qualifier cells [, qualifier cells ]* > + [, family ROW< qualifier cells [, qualifier cells ]* > ]* +) +TYPE bigtable +LOCATION 'googleapis.com/bigtable/projects/[PROJECT_ID]/instances/[INSTANCE_ID]/tables/[TABLE]' +``` + +* `key`: key of the Bigtable row +* `family`: name of the column family +* `qualifier`: the column qualifier +* `cells`: Either of each value: + * `TYPE` + * `ARRAY<SIMPLE_TYPE>` +* `LOCATION`: + * `PROJECT_ID`: ID of the Google Cloud Project. + * `INSTANCE_ID`: Bigtable instance ID. + * `TABLE`: Bigtable Table ID. +* `TYPE`: `SIMPLE_TYPE` or `CELL_ROW` +* `CELL_ROW`: `ROW<val SIMPLE_TYPE [, timestampMicros BIGINT [NOT NULL]] [, labels ARRAY<VARCHAR> [NOT NULL]]` +* `SIMPLE_TYPE`: on of the following: + * `BINARY` + * `VARCHAR` + * `BIGINT` + * `DOUBLE` + * `BOOLEAN` Review comment: Maybe just do that in this PR to make this feature complete? ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org