README.md in embulk-output-bigquery-0.2.0 vs README.md in embulk-output-bigquery-0.2.1
- old
+ new
@@ -26,11 +26,11 @@
#### Original options
| name | type | required? | default | description |
|:--------------------------|:------------|:-----------|:-------------|:-----------------------|
-| mode | string | optional | append | [See below](#mode) |
+| mode | string | optional | "append" | [See below](#mode) |
| auth_method | string | optional | "private_key" | `private_key` , `json_key` or `compute_engine`
| service_account_email | string | required when auth_method is private_key | | Your Google service account email
| p12_keyfile | string | required when auth_method is private_key | | Fullpath of private key in P12(PKCS12) format |
| json_keyfile | string | required when auth_method is json_key | | Fullpath of json key |
| sequence_format | string | optional | %03d.%02d | |
@@ -63,10 +63,11 @@
### Example
```yaml
out:
type: bigquery
+ mode: append
auth_method: private_key # default
service_account_email: ABCXYZ123ABCXYZ123.gserviceaccount.com
p12_keyfile: /path/to/p12_keyfile.p12
path_prefix: /path/to/output
file_ext: csv.gz
@@ -83,29 +84,29 @@
### mode
4 modes are provided.
-#### append
+##### append
default. When append mode, plugin will insert data into existing table.
-#### replace
+##### replace
1. Load to temporary table.
2. Copy temporary table to destination table. (WRITE_TRUNCATE)
```is_skip_job_result_check``` must be false when replace mode
-#### replace_backup
+##### replace_backup
1. Load to temporary table.
2. Copy destination table to backup table. (table_name_old)
3. Copy temporary table to destination table. (WRITE_TRUNCATE)
```is_skip_job_result_check``` must be false when replace_backup mode.
-#### delete_in_advance
+##### delete_in_advance
1. Delete destination table, if it exists.
2. Load to destination table.
```auto_create_table``` must be true when delete_in_advance mode.