Example script to export DynamoDB table data

export_dynamodb_data_script.py

import json
import boto3

# Specify your table name and the region your table is in
export_table_name = "ExportDataTable"
dynamodb = boto3.resource('dynamodb', region_name='us-east-1')
table = dynamodb.Table(export_table_name)

def export_table_data():
    print(f"Exporting data from {export_table_name}")
    response = table.scan()
    data = response['Items']

    # Paginate through DynamoDB table response
    while 'LastEvaluatedKey' in response:
        response = table.scan(ExclusiveStartKey=response['LastEvaluatedKey'])
        data.extend(response['Items'])
    
    # Create or open a text file to save exported data
    with open(f"data_export_{export_table_name}.json","w+") as f:
        json_data = json.dumps(data)
        f.write(json_data)

    print("Export complete!")

export_table_data()