# YAML equivalent of `faucet-stream/examples/mysql_to_bigquery.rs`.
version: 1
name: mysql_to_bigquery
pipeline:
source:
type: mysql
config:
connection_url: mysql://user:pass@localhost/sales
query: SELECT order_id, customer_id, total, ordered_at FROM orders
max_connections: 16
sink:
type: bigquery
config:
project_id: my-gcp-project
dataset_id: warehouse
table_id: orders
auth:
type: service_account_key_path
config:
path: service-account.json
batch_size: 1000