本文介绍了如何在Python中连接到AWS DynamoDB数据库。由于SQL Server的Express版本限制，作者转向了DynamoDB。首先，确保已在AWS上创建了DynamoDB表并设置了访问密钥。然后，使用boto3库指定访问密钥、密钥ID和区域名来建立连接。通过将数据转换为JSON格式（Python字典），可以保存到DynamoDB表中。
1. Background
I need to insert 20 billion rows of data into SQL server, but the limit for Express SQL version is only 10 GB. So I tried AWS DynamoDB, which is a NoSQL database.
2. Prerequisites
- A DynamoDB table on AWS, which can be done on the website.
- aws_access_key_id and aws_secret_access_key, which are set up from your AWS account.
3. Examples
boto3 is the package to connect to DynamoDB, like the following:
import boto3We need to specify 3 parameters, which are aws_access_key_id, aws_secret_access_key and region_name, like the following:
dynamodb = boto3.resource('dynamodb', aws_access_key_id='accessid',
aws_secret_access_key= 'accesskey', region_name='us-east-1'
最低0.47元/天 解锁文章
扫一扫
793
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
