Migrate Dynamodb Data to CloudSQL

DynamoDB to CloudSQL
aws dynamodb scan   \  
--table-name Prod.Country
--query "Items[*].[CountryCode.S,CountryName.S,RegionCode.N,IsdCode.S]" \
--output text \
--profile=aws-prod \
--region=ap-southeast-1 > country_dynamodb.tsv
gcloud sql connect common-service-01  --project=myproject -u trust
Allowlisting your IP for incoming connection for 5 minutes...done.
load data local infile '~/country_dynamodb.tsv' into table country;

--

--

--

Working as Cloud Architect & Software enthusiastic

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Deploying Openstack(private cloud) on AWS(public cloud)

How to be Successful in a New Software Engineering Role

How to generate a grid over Google Earth

Raising awareness of project costs in a software development team

Why I Quit Mailchimp

The app is now up, please join us.

How to Set Up Single Sign-On Between FusionAuth and Joomla

FastAPI: Testing a Database

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
NIRAV SHAH

NIRAV SHAH

Working as Cloud Architect & Software enthusiastic

More from Medium

How to build an event driven application on Google Cloud using cloud functions

The architecture, showing what cloud functions are triggered by what events

Apache drill with zookeeper in GCP dataproc + GCS bucket configuration with automation scripts

Elasticsearch Workshop #2: ingest pipelines

Migrating Transactional Data to MongoDB in AWS with the Zaloni Arena Data Governance Platform