Database Reference
In-Depth Information
data.
Run 'ebq help' to see the list of available commands.
Run 'ebq help <command>' to get help for <command>.
Using Encrypted BigQuery
To start, get some data that you want to encrypt. For our examples, we
export the public Shakespeare table and re-import it with encryption. Note
that you have to download the data locally—the encryption must happen on
the client side, so you can't encrypt a file that is already stored in Google
Cloud Storage.
$ GCS_BUKET=biquery-e2e
$ bq extract
--destination_format=NEWLINE_DELIMITED_JSON \
publicdata:samples.shakespeare \
gs://${GCS_BUCKET}/shakespeare.json
Waiting on bqjob_ … (26s) Current status: DONE
$ gsutil cp gs://${GCS_BUCKET}/shakespeare.json .
Now look up the schema of the table and save it in a file named table.txt .
$ bq --format=prettyjson show \
publicdata:samples.shakespeare > table.txt
$ cat table.txt
"schema": {
"fields": [
{
"name": "word",
"type": "STRING"
},
{
"name": "word_count",
"type": "INTEGER"
},
{
"name": "corpus",
"type": "STRING"
Search WWH ::




Custom Search