SQL Server
SQL Server
DynamoDB - CreateTable
See more Amazon DynamoDB Examples
The CreateTable operation adds a new table to your account. In an AWS account, table names must be unique within each Region. That is, you can have two tables with same name if you create the tables in different Regions.CreateTable is an asynchronous operation. Upon receiving a CreateTable request, DynamoDB immediately returns a response with a TableStatus of CREATING. After the table is created, DynamoDB sets the TableStatus to ACTIVE. You can perform read and write operations only on an ACTIVE table.
You can use the DescribeTable action to check the table status.
Chilkat SQL Server Downloads
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
DECLARE @success int
SELECT @success = 0
DECLARE @rest int
EXEC @hr = sp_OACreate 'Chilkat.Rest', @rest OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
-- Implements the following CURL command:
-- curl -X POST https://dynamodb.us-west-2.amazonaws.com/ \
-- -H "Accept-Encoding: identity" \
-- -H "Content-Type: application/x-amz-json-1.0" \
-- -H "Authorization: AWS4-HMAC-SHA256 Credential=<Credential>, SignedHeaders=<Headers>, Signature=<Signature>" \
-- -H "X-Amz-Date: <Date>" \
-- -H "X-Amz-Target: DynamoDB_20120810.CreateTable" \
-- -d '{
-- "AttributeDefinitions": [
-- {
-- "AttributeName": "ForumName",
-- "AttributeType": "S"
-- },
-- {
-- "AttributeName": "Subject",
-- "AttributeType": "S"
-- },
-- {
-- "AttributeName": "LastPostDateTime",
-- "AttributeType": "S"
-- }
-- ],
-- "TableName": "Thread",
-- "KeySchema": [
-- {
-- "AttributeName": "ForumName",
-- "KeyType": "HASH"
-- },
-- {
-- "AttributeName": "Subject",
-- "KeyType": "RANGE"
-- }
-- ],
-- "LocalSecondaryIndexes": [
-- {
-- "IndexName": "LastPostIndex",
-- "KeySchema": [
-- {
-- "AttributeName": "ForumName",
-- "KeyType": "HASH"
-- },
-- {
-- "AttributeName": "LastPostDateTime",
-- "KeyType": "RANGE"
-- }
-- ],
-- "Projection": {
-- "ProjectionType": "KEYS_ONLY"
-- }
-- }
-- ],
-- "ProvisionedThroughput": {
-- "ReadCapacityUnits": 5,
-- "WriteCapacityUnits": 5
-- },
-- "Tags": [
-- {
-- "Key": "Owner",
-- "Value": "BlueTeam"
-- }
-- ]
-- }'
-- Use the following online tool to generate REST code from a CURL command
-- Convert a cURL Command to REST Source Code
DECLARE @authAws int
EXEC @hr = sp_OACreate 'Chilkat.AuthAws', @authAws OUT
EXEC sp_OASetProperty @authAws, 'AccessKey', 'AWS_ACCESS_KEY'
EXEC sp_OASetProperty @authAws, 'SecretKey', 'AWS_SECRET_KEY'
-- Don't forget to change the region to your particular region. (Also make the same change in the call to Connect below.)
EXEC sp_OASetProperty @authAws, 'Region', 'us-west-2'
EXEC sp_OASetProperty @authAws, 'ServiceName', 'dynamodb'
-- SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
EXEC sp_OAMethod @rest, 'SetAuthAws', @success OUT, @authAws
-- URL: https://dynamodb.us-west-2.amazonaws.com/
DECLARE @bTls int
SELECT @bTls = 1
DECLARE @port int
SELECT @port = 443
DECLARE @bAutoReconnect int
SELECT @bAutoReconnect = 1
-- Don't forget to change the region domain (us-west-2.amazonaws.com) to your particular region.
EXEC sp_OAMethod @rest, 'Connect', @success OUT, 'dynamodb.us-west-2.amazonaws.com', @port, @bTls, @bAutoReconnect
IF @success <> 1
BEGIN
EXEC sp_OAGetProperty @rest, 'ConnectFailReason', @iTmp0 OUT
PRINT 'ConnectFailReason: ' + @iTmp0
EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @authAws
RETURN
END
-- Note: The above code does not need to be repeatedly called for each REST request.
-- The rest object can be setup once, and then many requests can be sent. Chilkat will automatically
-- reconnect within a FullRequest* method as needed. It is only the very first connection that is explicitly
-- made via the Connect method.
-- Use this online tool to generate code from sample JSON:
-- Generate Code to Create JSON
-- The following JSON is sent in the request body.
-- {
-- "AttributeDefinitions": [
-- {
-- "AttributeName": "ForumName",
-- "AttributeType": "S"
-- },
-- {
-- "AttributeName": "Subject",
-- "AttributeType": "S"
-- },
-- {
-- "AttributeName": "LastPostDateTime",
-- "AttributeType": "S"
-- }
-- ],
-- "TableName": "Thread",
-- "KeySchema": [
-- {
-- "AttributeName": "ForumName",
-- "KeyType": "HASH"
-- },
-- {
-- "AttributeName": "Subject",
-- "KeyType": "RANGE"
-- }
-- ],
-- "LocalSecondaryIndexes": [
-- {
-- "IndexName": "LastPostIndex",
-- "KeySchema": [
-- {
-- "AttributeName": "ForumName",
-- "KeyType": "HASH"
-- },
-- {
-- "AttributeName": "LastPostDateTime",
-- "KeyType": "RANGE"
-- }
-- ],
-- "Projection": {
-- "ProjectionType": "KEYS_ONLY"
-- }
-- }
-- ],
-- "ProvisionedThroughput": {
-- "ReadCapacityUnits": 5,
-- "WriteCapacityUnits": 5
-- },
-- "Tags": [
-- {
-- "Key": "Owner",
-- "Value": "BlueTeam"
-- }
-- ]
-- }
DECLARE @json int
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT
DECLARE @i int
SELECT @i = 0
EXEC sp_OASetProperty @json, 'I', @i
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'AttributeDefinitions[i].AttributeName', 'ForumName'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'AttributeDefinitions[i].AttributeType', 'S'
SELECT @i = @i + 1
EXEC sp_OASetProperty @json, 'I', @i
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'AttributeDefinitions[i].AttributeName', 'Subject'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'AttributeDefinitions[i].AttributeType', 'S'
SELECT @i = @i + 1
EXEC sp_OASetProperty @json, 'I', @i
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'AttributeDefinitions[i].AttributeName', 'LastPostDateTime'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'AttributeDefinitions[i].AttributeType', 'S'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'TableName', 'Thread'
SELECT @i = 0
EXEC sp_OASetProperty @json, 'I', @i
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KeySchema[i].AttributeName', 'ForumName'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KeySchema[i].KeyType', 'HASH'
SELECT @i = @i + 1
EXEC sp_OASetProperty @json, 'I', @i
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KeySchema[i].AttributeName', 'Subject'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KeySchema[i].KeyType', 'RANGE'
SELECT @i = 0
EXEC sp_OASetProperty @json, 'I', @i
DECLARE @j int
SELECT @j = 0
EXEC sp_OASetProperty @json, 'J', @j
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'LocalSecondaryIndexes[i].IndexName', 'LastPostIndex'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'LocalSecondaryIndexes[i].KeySchema[j].AttributeName', 'ForumName'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'LocalSecondaryIndexes[i].KeySchema[j].KeyType', 'HASH'
SELECT @j = @j + 1
EXEC sp_OASetProperty @json, 'J', @j
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'LocalSecondaryIndexes[i].KeySchema[j].AttributeName', 'LastPostDateTime'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'LocalSecondaryIndexes[i].KeySchema[j].KeyType', 'RANGE'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'LocalSecondaryIndexes[i].Projection.ProjectionType', 'KEYS_ONLY'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'ProvisionedThroughput.ReadCapacityUnits', 5
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'ProvisionedThroughput.WriteCapacityUnits', 5
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'Tags[0].Key', 'Owner'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'Tags[0].Value', 'BlueTeam'
EXEC sp_OAMethod @rest, 'AddHeader', @success OUT, 'Content-Type', 'application/x-amz-json-1.0'
EXEC sp_OAMethod @rest, 'AddHeader', @success OUT, 'X-Amz-Target', 'DynamoDB_20120810.CreateTable'
EXEC sp_OAMethod @rest, 'AddHeader', @success OUT, 'Accept-Encoding', 'identity'
DECLARE @sbRequestBody int
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbRequestBody OUT
EXEC sp_OAMethod @json, 'EmitSb', @success OUT, @sbRequestBody
DECLARE @sbResponseBody int
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @rest, 'FullRequestSb', @success OUT, 'POST', '/', @sbRequestBody, @sbResponseBody
IF @success <> 1
BEGIN
EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @authAws
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbRequestBody
EXEC @hr = sp_OADestroy @sbResponseBody
RETURN
END
DECLARE @respStatusCode int
EXEC sp_OAGetProperty @rest, 'ResponseStatusCode', @respStatusCode OUT
PRINT 'response status code = ' + @respStatusCode
IF @respStatusCode >= 400
BEGIN
PRINT 'Response Status Code = ' + @respStatusCode
PRINT 'Response Header:'
EXEC sp_OAGetProperty @rest, 'ResponseHeader', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Response Body:'
EXEC sp_OAMethod @sbResponseBody, 'GetAsString', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @authAws
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbRequestBody
EXEC @hr = sp_OADestroy @sbResponseBody
RETURN
END
DECLARE @jsonResponse int
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jsonResponse OUT
EXEC sp_OAMethod @jsonResponse, 'LoadSb', @success OUT, @sbResponseBody
EXEC sp_OASetProperty @jsonResponse, 'EmitCompact', 0
EXEC sp_OAMethod @jsonResponse, 'Emit', @sTmp0 OUT
PRINT @sTmp0
-- Sample Response:
-- {
-- "TableDescription": {
-- "TableArn": "arn:aws:dynamodb:us-west-2:123456789012:table/Thread",
-- "AttributeDefinitions": [
-- {
-- "AttributeName": "ForumName",
-- "AttributeType": "S"
-- },
-- {
-- "AttributeName": "LastPostDateTime",
-- "AttributeType": "S"
-- },
-- {
-- "AttributeName": "Subject",
-- "AttributeType": "S"
-- }
-- ],
-- "CreationDateTime": 1.36372808007E9,
-- "ItemCount": 0,
-- "KeySchema": [
-- {
-- "AttributeName": "ForumName",
-- "KeyType": "HASH"
-- },
-- {
-- "AttributeName": "Subject",
-- "KeyType": "RANGE"
-- }
-- ],
-- "LocalSecondaryIndexes": [
-- {
-- "IndexArn": "arn:aws:dynamodb:us-west-2:123456789012:table/Thread/index/LastPostIndex",
-- "IndexName": "LastPostIndex",
-- "IndexSizeBytes": 0,
-- "ItemCount": 0,
-- "KeySchema": [
-- {
-- "AttributeName": "ForumName",
-- "KeyType": "HASH"
-- },
-- {
-- "AttributeName": "LastPostDateTime",
-- "KeyType": "RANGE"
-- }
-- ],
-- "Projection": {
-- "ProjectionType": "KEYS_ONLY"
-- }
-- }
-- ],
-- "ProvisionedThroughput": {
-- "NumberOfDecreasesToday": 0,
-- "ReadCapacityUnits": 5,
-- "WriteCapacityUnits": 5
-- },
-- "TableName": "Thread",
-- "TableSizeBytes": 0,
-- "TableStatus": "CREATING"
-- }
-- }
-- Sample code for parsing the JSON response...
-- Use the following online tool to generate parsing code from sample JSON:
-- Generate Parsing Code from JSON
DECLARE @AttributeName nvarchar(4000)
DECLARE @AttributeType nvarchar(4000)
DECLARE @KeyType nvarchar(4000)
DECLARE @IndexArn nvarchar(4000)
DECLARE @IndexName nvarchar(4000)
DECLARE @IndexSizeBytes int
DECLARE @ItemCount int
DECLARE @ProjectionProjectionType nvarchar(4000)
DECLARE @count_j int
DECLARE @TableDescriptionTableArn nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @TableDescriptionTableArn OUT, 'TableDescription.TableArn'
DECLARE @TableDescriptionCreationDateTime nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @TableDescriptionCreationDateTime OUT, 'TableDescription.CreationDateTime'
DECLARE @TableDescriptionItemCount int
EXEC sp_OAMethod @jsonResponse, 'IntOf', @TableDescriptionItemCount OUT, 'TableDescription.ItemCount'
DECLARE @TableDescriptionProvisionedThroughputNumberOfDecreasesToday int
EXEC sp_OAMethod @jsonResponse, 'IntOf', @TableDescriptionProvisionedThroughputNumberOfDecreasesToday OUT, 'TableDescription.ProvisionedThroughput.NumberOfDecreasesToday'
DECLARE @TableDescriptionProvisionedThroughputReadCapacityUnits int
EXEC sp_OAMethod @jsonResponse, 'IntOf', @TableDescriptionProvisionedThroughputReadCapacityUnits OUT, 'TableDescription.ProvisionedThroughput.ReadCapacityUnits'
DECLARE @TableDescriptionProvisionedThroughputWriteCapacityUnits int
EXEC sp_OAMethod @jsonResponse, 'IntOf', @TableDescriptionProvisionedThroughputWriteCapacityUnits OUT, 'TableDescription.ProvisionedThroughput.WriteCapacityUnits'
DECLARE @TableDescriptionTableName nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @TableDescriptionTableName OUT, 'TableDescription.TableName'
DECLARE @TableDescriptionTableSizeBytes int
EXEC sp_OAMethod @jsonResponse, 'IntOf', @TableDescriptionTableSizeBytes OUT, 'TableDescription.TableSizeBytes'
DECLARE @TableDescriptionTableStatus nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @TableDescriptionTableStatus OUT, 'TableDescription.TableStatus'
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @jsonResponse, 'SizeOfArray', @count_i OUT, 'TableDescription.AttributeDefinitions'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jsonResponse, 'I', @i
EXEC sp_OAMethod @jsonResponse, 'StringOf', @AttributeName OUT, 'TableDescription.AttributeDefinitions[i].AttributeName'
EXEC sp_OAMethod @jsonResponse, 'StringOf', @AttributeType OUT, 'TableDescription.AttributeDefinitions[i].AttributeType'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jsonResponse, 'SizeOfArray', @count_i OUT, 'TableDescription.KeySchema'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jsonResponse, 'I', @i
EXEC sp_OAMethod @jsonResponse, 'StringOf', @AttributeName OUT, 'TableDescription.KeySchema[i].AttributeName'
EXEC sp_OAMethod @jsonResponse, 'StringOf', @KeyType OUT, 'TableDescription.KeySchema[i].KeyType'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jsonResponse, 'SizeOfArray', @count_i OUT, 'TableDescription.LocalSecondaryIndexes'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jsonResponse, 'I', @i
EXEC sp_OAMethod @jsonResponse, 'StringOf', @IndexArn OUT, 'TableDescription.LocalSecondaryIndexes[i].IndexArn'
EXEC sp_OAMethod @jsonResponse, 'StringOf', @IndexName OUT, 'TableDescription.LocalSecondaryIndexes[i].IndexName'
EXEC sp_OAMethod @jsonResponse, 'IntOf', @IndexSizeBytes OUT, 'TableDescription.LocalSecondaryIndexes[i].IndexSizeBytes'
EXEC sp_OAMethod @jsonResponse, 'IntOf', @ItemCount OUT, 'TableDescription.LocalSecondaryIndexes[i].ItemCount'
EXEC sp_OAMethod @jsonResponse, 'StringOf', @ProjectionProjectionType OUT, 'TableDescription.LocalSecondaryIndexes[i].Projection.ProjectionType'
SELECT @j = 0
EXEC sp_OAMethod @jsonResponse, 'SizeOfArray', @count_j OUT, 'TableDescription.LocalSecondaryIndexes[i].KeySchema'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jsonResponse, 'J', @j
EXEC sp_OAMethod @jsonResponse, 'StringOf', @AttributeName OUT, 'TableDescription.LocalSecondaryIndexes[i].KeySchema[j].AttributeName'
EXEC sp_OAMethod @jsonResponse, 'StringOf', @KeyType OUT, 'TableDescription.LocalSecondaryIndexes[i].KeySchema[j].KeyType'
SELECT @j = @j + 1
END
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @authAws
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbRequestBody
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jsonResponse
END
GO