Original subtitles

1

In this section, we're going to start learning the most fundamental sequel commands and clauses that

2

we can write in the bakery interface.

3

And we're also going to upload our first dataset and create a table out of it.

4

Now, if you recall, in Section one, we were exploring the Chicago taxi file and table.

5

And what I've done is because there were a lot of records, I've created a sample data set and downloaded

6

that in a CSB format.

7

And so we're gonna take that CSB format and basically upload it here.

8

Now, the first thing that you can see here is the left hand side.

9

We have our project, big course demo and nothing within it.

10

So I step one, we have to create a dataset so you can simply click create data set here.

11

And it's fairly simple to do.

12

We just have to put a data set I.D. that would be taxi.

13

Data set.

14

And you have to use underscores.

15

You cannot have spaces when you're creating those ideas.

16

That's just good, good practice.

17

The default table expiration because we're using the sandbox account, it defaults to 60 days.

18

So we're going to keep that there and create a data set.

19

And almost instantly, you'll see that the data set has been created by expand here.

20

We have our data set and we can click through in the data set and now we have the option to create a

21

table table is what hosts the data.

22

So we're going to create a table here and we will have a couple of options.

23

So this menu pops up a create table.

24

If I click create table from here, there are a few options.

25

There is the drive.

26

So you could upload a Google Drive, Google Sheets, a file.

27

You could use Google cloud storage or in our case, you can also upload a C as V, so click, upload

28

and I'll click select file here.

29

Now I've you would have this file available in your resource section so you can download it on your

30

local machine and you should be able to follow through this section.

31

So you will simply click, browse and wherever you store that file, you will find it and click on Chicago

32

trips.

33

Ten thousand records sample.

34

And what that does is one site click it immediately to file format changes to see ASV.

35

Google actually recognized that that's a CSB file.

36

And the destination here project, we've already have that data set.

37

We simply created that the table here would be taxi trips.

38

And I will put sample because all I've done is from the million and million records of that public data

39

set.

40

I've taken that and I've just picked ten thousand records that are now, you know, randomized.

41

Once we have the table ready, then we go to the schema.

42

So we we talked a lot about the schema.

43

And there's a couple of options here when you're uploading.

44

Now, the easy one that we're going to use here is auto detect.

45

So relieving it up to big query to detect each each value that is within that data set.

46

What type of what is the format?

47

And it's using, you know, what are the input parameters.

48

And that's all happening automatic.

49

Now, you could do that manually either by editing this text.

50

So if I click edit this text, I could do this whole process manually, or I can add the fields here

51

simply by typing the name of the column.

52

Choosing the type and you have string, integer, float and etc. and in choosing the mode.

53

But we're not gonna do this in this in this case because we can auto detect.

54

So we'll click on Detect.

55

And we're going to move on to partitioning.

56

So partitioning.

57

We're gonna explore that in our first project.

58

But it has to do with how much data do you want to load?

59

Because when you create tables, you don't really want to query the whole table where there's millions

60

and millions of records.

61

If you just want to look at a subset, you can what is called a partition, that subset of data.

62

But we're gonna see this in action in our project.

63

Now, last but not least, advanced options here.

64

When you click, then you'll expanded writing preference.

65

Now, there's three options here because we're creating a brand new table.

66

Right.

67

If empty.

68

So all the data that you're uploading will be written into the table.

69

And there's going to be no problem because that table is anyways empty.

70

Now, you can also choose a pen to table.

71

And this could be used in a scenario where you have all the January data file and you want to upload

72

the February data.

73

So if you have a separate file, if you upload, then file in your keeping the same schema.

74

And that's very important.

75

If you're keeping the same schema, you can click append to table and all that will be appended as opposed

76

to overwritten in some way.

77

And that obviously brings us to option three.

78

If we do want to override completely and change the entire table with new data.

79

We can simply override would our new file.

80

So if you've actually consolidated your, let's say, data for January and February already in a S.A.C.

81

file and you just want to override the main table, you could do that by picking the overwrite table

82

option.

83

But in our case, right of empty because it's a brand new table.

84

So we're all set here.

85

We're going to click create table.

86

It's going to take a little bit of time to compute the table, and that would show you can see Loja

87

job created and immediately says taxi trips, sample, create it and you can see it reflected here.

88

So taxi trips.

89

And if I click on this, what we're going to see is our familiar type mode and the entire data schema.

90

So it becomes very similar to what you saw in the public dataset.

91

Now, in the next part, we're actually going to dive a little bit deeper into this and write our very

92

first query.