README.md in bigquery_migration-0.1.3 vs README.md in bigquery_migration-0.1.4
- old
+ new
@@ -74,9 +74,20 @@
migrator = BigqueryMigration.new(config)
migrator.migrate_table(columns: columns)
# migrator.migrate_table(schema_file: '/path/to/schema.json')
```
+## LIMITATIONS
+
+There are serveral limitations because of BigQuery API limitations:
+
+* Can not handle `mode: REPEATED` columns
+* Can add only `mode: NULLABLE` columns
+* Columns become `mode: NULLABLE` after type changing
+* Will be charged because a query is issued (If only adding columns, it is not charged because it uses patch_table API)
+
+This tool has an advantage that it is **faster** than reloading data entirely.
+
## Further Details
* See [BigQueryテーブルのスキーマを変更する - sonots:blog](http://blog.livedoor.jp/sonots/archives/47294596.html) (Japanese)
## Development