1
00:00:00,390 --> 00:00:06,960
In this video, we are going to create a global secondary index on Amazon Dynamic TV table with using

2
00:00:06,960 --> 00:00:08,460
a measurement console.

3
00:00:08,610 --> 00:00:12,720
So it takes almost 5 minutes to create a global secondary index.

4
00:00:12,750 --> 00:00:20,370
In this step, we will query a global secondary index on the our order table using the DB console.

5
00:00:20,520 --> 00:00:29,850
So we are going to go to the order tables orders and verify that your index is active and click the

6
00:00:29,850 --> 00:00:35,070
explore table items and scroll scan command and run this command.

7
00:00:35,100 --> 00:00:41,430
You can see that we have two item, but the first item has no value on order that let's modify the first

8
00:00:41,430 --> 00:00:44,940
item and add these attributes.

9
00:00:44,970 --> 00:00:46,590
We can see in here.

10
00:00:50,360 --> 00:00:53,660
Order date and give the value.

11
00:00:53,660 --> 00:00:56,120
Is this kind of value and save this value?

12
00:00:56,120 --> 00:00:56,690
Yes.

13
00:00:56,690 --> 00:01:03,680
So as you can see that we have basically add order date of any item of our order table.

14
00:01:03,680 --> 00:01:09,410
Now we can query over these items with using the Global Secondary Index.

15
00:01:09,410 --> 00:01:12,320
To do that, please click the query button.

16
00:01:12,320 --> 00:01:20,810
And this time I'm going to select our index file, which is the when I first try, I can't see the index

17
00:01:21,020 --> 00:01:22,400
in this dropdown list.

18
00:01:22,400 --> 00:01:26,570
So after that I have control f five this page.

19
00:01:26,570 --> 00:01:29,030
So that means how to load the page.

20
00:01:29,030 --> 00:01:34,970
And you can also click the F 12 and come here right click and make harder load.

21
00:01:34,970 --> 00:01:42,170
So after the harder load you can see that in the query section we can see the our index list in here.

22
00:01:42,170 --> 00:01:47,870
So this time I'm going to select order date index, which is the our global secondary index and we are

23
00:01:47,870 --> 00:01:50,260
going to perform all.

24
00:01:51,280 --> 00:01:51,820
Holiday do.

25
00:01:52,240 --> 00:01:55,870
Okay, so I'm providing this information and run this query.

26
00:01:56,050 --> 00:02:02,260
So as you can see that we can run query over the global secondary index and get back response from the

27
00:02:02,260 --> 00:02:06,160
Dynamo DB and see the item is come from the order date.

28
00:02:06,340 --> 00:02:12,850
So as you can see that now we can query our global secondary index on the order table with using the

29
00:02:13,420 --> 00:02:14,260
measurement console.