embulk-slack-historyを使ってみる

slack-to-bigquery.yml

in:
    type: slack_history
    token: xxxxxxx
out:
    type: bigquery
    service_account_email: xxxxx@developer.gserviceaccount.com
    p12_keyfile_path: ./key.p12
    project: mysamplebqproject
    dataset: slack
    auto_create_table: true
    table: slack_forme
    schema_path: ./schema.json
    allow_quoted_newlines: 1 #このオプションを追加
    formatter:
        type: csv
        header_line: false
    path_prefix: /tmp
    encoders:
        - {type: gzip}
    file_ext: csv.gz