Skip to content

How to Migrate from Amazon DynamoDB to Google BigQuery

Skippr is the easiest way to migrate from DynamoDB to BigQuery and get fully cleansed and modeled data in one run command.

Source: DynamoDB. Destination: BigQuery.

Sample config

yaml
skippr:
  workspace: dynamodb_to_bigquery
pipelines:
  dynamodb_to_bigquery:
    data_source: data_sources.source
    data_sink: data_sinks.warehouse
data_sources:
  source:
    Dynamodb:
      table_name: my-table
      region: us-east-1
data_sinks:
  warehouse:
    Bigquery:
      project: my-gcp-project
      dataset: raw_data
      location: US

Environment

bash
export GOOGLE_APPLICATION_CREDENTIALS="/path/to/service-account.json"
export AWS_ACCESS_KEY_ID="your-key"
export AWS_SECRET_ACCESS_KEY="your-secret"

Source connector: dynamodb. Destination connector: bigquery.

See Quick start.