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: USEnvironment
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.
