1
00:00:00,240 --> 00:00:05,850
In this video, we are going to create an madeby table bit using a slide.

2
00:00:06,450 --> 00:00:12,720
So we are in here and we are going to use a select command to perform create Dynamo DB using the Dynamo

3
00:00:12,720 --> 00:00:13,710
DB APIs.

4
00:00:14,160 --> 00:00:19,530
For that purpose, please open the visual pseudocode and create a new section file, which is section

5
00:00:19,530 --> 00:00:22,650
16, and our lecture is 134.

6
00:00:22,980 --> 00:00:29,100
And under the command text, I have put two commands that require one creating table, using the SQL

7
00:00:29,100 --> 00:00:29,760
commands.

8
00:00:29,820 --> 00:00:30,830
To do that.

9
00:00:30,840 --> 00:00:37,950
You can see in here basically we will use CLI command for creating the DB table and a double SLA example

10
00:00:37,950 --> 00:00:41,970
creates an order table using the Create Table command.

11
00:00:42,000 --> 00:00:48,900
You can see that we will use a dynamic DB and create table select command and specify the attributes

12
00:00:48,900 --> 00:00:50,970
like table name as a order.

13
00:00:51,060 --> 00:00:54,570
And this attribute definition is dynamo DB attributes.

14
00:00:54,570 --> 00:01:01,570
We are specifying the attribute, our name is the ID and attribute type is a string and again attribute

15
00:01:01,590 --> 00:01:04,770
name is a status and attribute type is string.

16
00:01:05,460 --> 00:01:10,770
So we should also provide the case schema, which means the partition and the source key.

17
00:01:10,770 --> 00:01:14,250
So we are providing the ID information as a partition key.

18
00:01:14,280 --> 00:01:21,680
Key type equal means that this is the partition key and key type equal range means that this status

19
00:01:21,780 --> 00:01:23,910
attribute is sort key.

20
00:01:23,910 --> 00:01:29,850
So we can also specify another configurations, which is the provision throughput we are specifying

21
00:01:29,850 --> 00:01:34,680
read and write capacity is a five and table clause is standard.

22
00:01:34,680 --> 00:01:39,630
So we will run this command to create our order table on Dynamo DB.

23
00:01:39,660 --> 00:01:45,630
To perform this I will use the Windows one because we are using the multi-line characters so you can

24
00:01:45,630 --> 00:01:46,740
choose one of them.

25
00:01:46,800 --> 00:01:54,600
Let me copy these commands and paste into the related to our section folder and I'm going to hit enter.

26
00:01:55,110 --> 00:01:58,500
So this will be create a table.

27
00:01:58,500 --> 00:02:03,780
You can see in here it is returning the result of the table create operation.

28
00:02:03,930 --> 00:02:07,140
Here you can see the example response.

29
00:02:07,140 --> 00:02:15,150
So it is give the table description, attribute definition to table name, key schema provision, throughput,

30
00:02:15,210 --> 00:02:16,860
table size and so on.

31
00:02:16,860 --> 00:02:25,440
So these are the examples response from the me running the self commands and we can also check these

32
00:02:25,440 --> 00:02:32,130
results from the main console, but before that we can also check the status of this table, create

33
00:02:32,130 --> 00:02:35,400
operation with using the described table command.

34
00:02:35,400 --> 00:02:41,940
So when we create a table which using the commands, it is dynamic DB is status table.

35
00:02:41,940 --> 00:02:49,800
So this is creating so we can verify this status is complete or not with using the described table commands.

36
00:02:49,800 --> 00:02:56,310
So that means in order to verify dynamic DB has finished creating table, we can use describe table

37
00:02:56,310 --> 00:02:56,850
command.

38
00:02:56,850 --> 00:02:59,310
So please open the command text and scroll down.

39
00:02:59,310 --> 00:03:05,040
You can see that this command will be described table for the giving table name, which is the order,

40
00:03:05,040 --> 00:03:06,930
and we will check the tables.

41
00:03:06,930 --> 00:03:08,280
So this is complete or not.

42
00:03:08,280 --> 00:03:11,520
In order to do that, I am copy and paste this command and hit enter.

43
00:03:11,550 --> 00:03:19,920
So we will see that the table status is active, so that means our table is created successfully.

44
00:03:20,010 --> 00:03:22,440
Let's check from the management console.

45
00:03:22,470 --> 00:03:23,790
Go to Dynamo DB.

46
00:03:24,700 --> 00:03:28,750
And verify that we have create a table which name is order.

47
00:03:28,750 --> 00:03:33,250
And so this is active and we create this order table which using these commands.