Meeting Title: US x BF | Standup Date: 2025-09-04 Meeting participants: Emily Giant, Emily’s Fellow Note Taker, Uttam Kumaran, Demilade Agboola
WEBVTT
1 00:00:09.980 ⇒ 00:00:13.399 Emily Giant: God, this fucking note-taker. No.
2 00:02:05.260 ⇒ 00:02:06.490 Uttam Kumaran: Hello?
3 00:02:07.090 ⇒ 00:02:08.220 Emily Giant: Hi, how’s it going?
4 00:02:08.220 ⇒ 00:02:09.110 Uttam Kumaran: Good.
5 00:02:11.070 ⇒ 00:02:12.570 Emily Giant: I’m excited about this.
6 00:02:13.160 ⇒ 00:02:17.570 Uttam Kumaran: Yes, me too. We could just hop into stuff.
7 00:02:17.570 ⇒ 00:02:23.220 Emily Giant: Let’s do it, let’s record it, and then anyone who’s late to the ballgame can watch the video.
8 00:02:24.300 ⇒ 00:02:35.949 Uttam Kumaran: So I’ll probably start maybe by just confirming that both of you guys have Cursor installed, and you also have the dbt CLI installed.
9 00:02:36.480 ⇒ 00:02:40.980 Uttam Kumaran: And so you’re able to run things like dbt run, and it’s working.
10 00:02:43.530 ⇒ 00:02:56.319 Uttam Kumaran: Okay, so do you mind sharing your screen, and I can just confirm the, like, that you have the folders added, and that you have, like, terminal open, and you have, like, cursor updated?
11 00:02:57.170 ⇒ 00:03:00.050 Emily Giant: I definitely don’t have any of that right now, but…
12 00:03:00.050 ⇒ 00:03:00.690 Uttam Kumaran: Okay.
13 00:03:00.690 ⇒ 00:03:02.930 Emily Giant: Let’s do it. Okay, so go to Cursor.
14 00:03:07.960 ⇒ 00:03:14.400 Uttam Kumaran: So, I’m gonna ask for you to install the actual cursor thing onto your machine.
15 00:03:14.400 ⇒ 00:03:15.260 Emily Giant: Okay.
16 00:03:16.440 ⇒ 00:03:17.140 Emily Giant: So…
17 00:03:17.140 ⇒ 00:03:21.789 Uttam Kumaran: So, if you go… back home, I think.
18 00:03:22.470 ⇒ 00:03:26.009 Uttam Kumaran: Like, go to cursor.com, or… yeah, just go back there.
19 00:03:27.930 ⇒ 00:03:29.420 Uttam Kumaran: And click download.
20 00:03:34.060 ⇒ 00:03:34.880 Emily Giant: Okay.
21 00:03:39.510 ⇒ 00:03:40.569 Emily Giant: That’s the light.
22 00:03:41.000 ⇒ 00:03:45.169 Emily Giant: Okay, so it went somewhere.
23 00:03:52.060 ⇒ 00:03:55.340 Emily Giant: Just gonna continue clicking it until something happens. How’s that sound?
24 00:03:55.340 ⇒ 00:03:56.989 Uttam Kumaran: No problem, that’s fine.
25 00:03:59.210 ⇒ 00:04:05.659 Uttam Kumaran: This will be a… this will be a slow meeting as we get everything set up, because some of these configurations are finicky, so that’s no problem.
26 00:04:10.280 ⇒ 00:04:12.210 Emily Giant: Okay, it’s happening now.
27 00:04:28.620 ⇒ 00:04:29.610 Emily Giant: Okay.
28 00:04:30.850 ⇒ 00:04:32.489 Emily Giant: But it’s now on my dock.
29 00:04:35.860 ⇒ 00:04:37.409 Uttam Kumaran: Okay, great.
30 00:04:45.930 ⇒ 00:04:49.920 Uttam Kumaran: So, as soon as that opens… Yeah, just log in.
31 00:04:55.490 ⇒ 00:04:56.750 Emily Giant: Okay…
32 00:05:07.500 ⇒ 00:05:11.679 Emily Giant: Okay, I probably just gave all of our company data away, but let’s keep going.
33 00:05:13.960 ⇒ 00:05:16.680 Emily Giant: Whenever I click those quickly, I’m like, what have I done?
34 00:05:18.950 ⇒ 00:05:23.040 Emily Giant: Feel free to return to cursor, okay? I will.
35 00:05:23.710 ⇒ 00:05:24.540 Emily Giant: Alright.
36 00:05:25.610 ⇒ 00:05:31.559 Uttam Kumaran: Okay, great. So… now, do you typically use, like, have you used GitHub Desktop before?
37 00:05:31.930 ⇒ 00:05:32.880 Emily Giant: -
38 00:05:32.880 ⇒ 00:05:34.459 Uttam Kumaran: Okay, so let’s also…
39 00:05:34.770 ⇒ 00:05:37.040 Emily Giant: You mean just GitHub, but from a…
40 00:05:37.740 ⇒ 00:05:41.039 Uttam Kumaran: Yeah, they have, like, a very convenient desktop app that just helps…
41 00:05:41.200 ⇒ 00:05:44.049 Uttam Kumaran: So let’s install that too, that’ll make this process…
42 00:05:44.720 ⇒ 00:05:46.210 Uttam Kumaran: also really nice.
43 00:05:46.580 ⇒ 00:05:48.040 Emily Giant: Should I go to GitHub?
44 00:05:48.040 ⇒ 00:05:52.200 Uttam Kumaran: Yes, you just type in GitHub Desktop, and Google, and…
45 00:05:52.400 ⇒ 00:05:54.100 Emily Giant: Oh, so not from there.
46 00:05:55.190 ⇒ 00:05:57.160 Uttam Kumaran: Yeah, you can just search for the application.
47 00:06:07.060 ⇒ 00:06:07.900 Uttam Kumaran: Perfect.
48 00:06:12.200 ⇒ 00:06:14.319 Emily Giant: Do you use a Mac or a PC?
49 00:06:14.320 ⇒ 00:06:15.040 Uttam Kumaran: Mac.
50 00:06:16.780 ⇒ 00:06:20.330 Emily Giant: when people try to tell me that PCs are somehow…
51 00:06:20.670 ⇒ 00:06:23.780 Emily Giant: superior. I don’t even know what to think.
52 00:06:24.030 ⇒ 00:06:27.820 Uttam Kumaran: It’s been a long time since that’s been the case.
53 00:06:28.430 ⇒ 00:06:31.999 Emily Giant: I don’t think I could do a single thing on a PC. Not one.
54 00:06:33.550 ⇒ 00:06:34.440 Emily Giant: Okay.
55 00:06:34.440 ⇒ 00:06:38.899 Uttam Kumaran: So you can drag that to applications, or… yeah, that’s fine.
56 00:06:39.180 ⇒ 00:06:43.070 Emily Giant: Already in my dock, looking like… okay, here. Excuse me.
57 00:06:44.590 ⇒ 00:06:46.539 Uttam Kumaran: Cool, and then, yep, just sign in.
58 00:06:52.230 ⇒ 00:06:57.410 Emily Giant: Okay… When you’re ready, authenticate using the button.
59 00:06:57.950 ⇒ 00:07:00.100 Emily Giant: Hmm? Okay.
60 00:07:20.530 ⇒ 00:07:23.280 Emily Giant: I don’t even know what I said, I’d just move, but…
61 00:07:24.510 ⇒ 00:07:27.960 Uttam Kumaran: That’s fine. So now, if you want to go back, open GitHub Desktop.
62 00:07:29.570 ⇒ 00:07:35.079 Uttam Kumaran: It should… okay, so what we’re going to want to do is click on Urban Stems dbt.
63 00:07:37.750 ⇒ 00:07:41.609 Uttam Kumaran: And then clone that one, and then just make sure it’s in…
64 00:07:41.890 ⇒ 00:07:45.160 Uttam Kumaran: Yeah, so this is just where all your GitHub stuff is gonna go.
65 00:07:45.200 ⇒ 00:07:46.550 Emily Giant: That’s fine.
66 00:07:46.550 ⇒ 00:07:48.009 Uttam Kumaran: So you can hit clone.
67 00:07:48.940 ⇒ 00:07:55.519 Uttam Kumaran: And now, you have a visual view of, like, GitHub. So, a couple things you can do here. One, you can click on Current Branch.
68 00:07:58.690 ⇒ 00:07:59.980 Uttam Kumaran: Right here.
69 00:08:00.360 ⇒ 00:08:03.660 Emily Giant: Thank you. Where? Where? Oh, Current Branch, yep.
70 00:08:03.800 ⇒ 00:08:10.009 Uttam Kumaran: And so you can actually just here, drop down, select, like, any branch that you’re working on, or create a new branch.
71 00:08:10.220 ⇒ 00:08:15.899 Uttam Kumaran: As you make changes, your changes will appear here on the left.
72 00:08:16.150 ⇒ 00:08:16.600 Emily Giant: Hmm.
73 00:08:16.600 ⇒ 00:08:31.040 Uttam Kumaran: So you’ll start to see the change files, you can select the changes you want, you can commit them. It’s just, like, much easier than doing this via, like, the CLI, but probably very similar to what you’re used to. It’s actually probably a little bit more…
74 00:08:31.080 ⇒ 00:08:44.419 Uttam Kumaran: features than what you’re used to in dbt. But basically, we’re going to be going back and forth between Cursor and, GitHub Desktop today. So another thing now, if you want to go back to Cursor.
75 00:08:47.410 ⇒ 00:08:54.879 Uttam Kumaran: And you can hit… X out of this, I guess, yeah.
76 00:08:55.430 ⇒ 00:08:58.549 Emily Giant: Thank you. That little drawing thing is awesome.
77 00:08:58.550 ⇒ 00:09:03.240 Uttam Kumaran: It’s nice, yeah, I use it in a lot of meetings, saves a couple seconds.
78 00:09:03.240 ⇒ 00:09:05.110 Emily Giant: Another person feeling idiotic, too.
79 00:09:05.110 ⇒ 00:09:06.360 Uttam Kumaran: Yeah. Yeah.
80 00:09:06.460 ⇒ 00:09:10.319 Uttam Kumaran: So you can hit… you can hit File, and you can hit Open Folder.
81 00:09:12.990 ⇒ 00:09:18.610 Uttam Kumaran: And then navigate to your new GitHub folder, which should be in your documents.
82 00:09:20.200 ⇒ 00:09:24.420 Uttam Kumaran: Yep, and you just click on that, and then op… you just hit open.
83 00:09:25.840 ⇒ 00:09:34.809 Uttam Kumaran: And so now we are in our repo. So yes, hit Allow, it’s gonna ask you to set a couple things. And then, yes, hit download Git.
84 00:09:34.930 ⇒ 00:09:36.460 Uttam Kumaran: This is gonna be important.
85 00:09:37.730 ⇒ 00:09:39.110 Uttam Kumaran: Yes.
86 00:09:40.940 ⇒ 00:09:45.520 Uttam Kumaran: Yes, you can just do download for Mac, you’re gonna want this.
87 00:09:46.290 ⇒ 00:09:53.160 Uttam Kumaran: You’re gonna… okay, so we’re gonna have to… we’re gonna have to walk through… this…
88 00:09:53.630 ⇒ 00:09:54.190 Emily Giant: Okay.
89 00:09:54.570 ⇒ 00:09:58.070 Uttam Kumaran: So, if you go back to cursor…
90 00:10:01.030 ⇒ 00:10:05.239 Uttam Kumaran: And you go to Terminal at the top here.
91 00:10:06.600 ⇒ 00:10:08.370 Uttam Kumaran: And you do New Terminal.
92 00:10:09.780 ⇒ 00:10:16.629 Uttam Kumaran: And so, one thing that I think we could just do is, actually, let’s have cursor install Git for us.
93 00:10:16.910 ⇒ 00:10:20.680 Uttam Kumaran: So, on the right here, you can just say.
94 00:10:21.340 ⇒ 00:10:27.199 Uttam Kumaran: I need to install Git… And then just hit enter.
95 00:10:29.970 ⇒ 00:10:41.620 Uttam Kumaran: And then you can hit Allow… and then also I would hit Allow List. So what… basically, cursor can start doing a couple things automatically, and you’re just gonna want it to start to do that. It’s gonna go see that you can’t…
96 00:10:41.770 ⇒ 00:10:45.470 Uttam Kumaran: Install Git, you’re gonna need Xcode, so you can just hit run.
97 00:10:47.290 ⇒ 00:10:52.290 Uttam Kumaran: And so it’s gonna start, like, doing what we probably would have taken another 20 minutes to go.
98 00:10:52.290 ⇒ 00:10:54.289 Emily Giant: Yeah. Wow, okay.
99 00:10:54.290 ⇒ 00:10:59.959 Uttam Kumaran: So then it says, okay, cool, if you prefer alternative installation methods.
100 00:11:01.350 ⇒ 00:11:03.829 Uttam Kumaran: So, can you… if you scroll up now…
101 00:11:04.000 ⇒ 00:11:08.719 Uttam Kumaran: What did it say? Okay, perfect. It says, perfect, I initiated the installation of Xcode.
102 00:11:08.920 ⇒ 00:11:10.210 Uttam Kumaran: Down here.
103 00:11:11.650 ⇒ 00:11:14.360 Uttam Kumaran: So… Yeah, just scroll up.
104 00:11:15.850 ⇒ 00:11:19.750 Uttam Kumaran: Wait, can I… can you just, scroll a little slower, please?
105 00:11:20.670 ⇒ 00:11:24.210 Uttam Kumaran: Click Install in the dialog.
106 00:11:26.520 ⇒ 00:11:31.540 Uttam Kumaran: So, is there any, like, Xcode thing… is there anything that popped up in, like, your…
107 00:11:32.400 ⇒ 00:11:35.740 Uttam Kumaran: screen for installing Xcode.
108 00:11:37.260 ⇒ 00:11:41.400 Uttam Kumaran: Like, if you scroll to your menu bar, is there… do you see, like, anything new there?
109 00:11:42.620 ⇒ 00:11:43.740 Emily Giant: No.
110 00:11:45.210 ⇒ 00:11:50.270 Uttam Kumaran: Okay, if you scroll… okay, here, yeah.
111 00:11:50.530 ⇒ 00:11:52.340 Uttam Kumaran: Gotcha. So I would install, yes.
112 00:11:53.780 ⇒ 00:11:54.590 Uttam Kumaran: Yep.
113 00:11:54.710 ⇒ 00:11:56.199 Uttam Kumaran: And just hit agree.
114 00:12:00.220 ⇒ 00:12:03.030 Uttam Kumaran: So we’re gonna need Git installed.
115 00:12:03.280 ⇒ 00:12:05.790 Uttam Kumaran: To be able to do version control locally.
116 00:12:34.450 ⇒ 00:12:36.810 Uttam Kumaran: Okay, wait for this to finish.
117 00:13:18.730 ⇒ 00:13:19.670 Uttam Kumaran: Ugh.
118 00:13:19.980 ⇒ 00:13:22.119 Emily Giant: I know. Okay, well…
119 00:13:22.120 ⇒ 00:13:26.839 Uttam Kumaran: Let’s… let’s just put this guy in the corner, and I can start doing more cursor stuff.
120 00:13:28.650 ⇒ 00:13:38.919 Uttam Kumaran: Yeah, so you can just put it so we keep an eye on it, but, cool. So, now, if you go back to cursor, let’s try a couple things. So, if you click on,
121 00:13:39.330 ⇒ 00:13:41.319 Uttam Kumaran: The plus here… oh.
122 00:13:41.660 ⇒ 00:13:42.400 Emily Giant: Sorry.
123 00:13:42.400 ⇒ 00:13:43.949 Uttam Kumaran: Yeah, if you click on the plus.
124 00:13:44.090 ⇒ 00:13:46.250 Uttam Kumaran: And you can start a new session.
125 00:13:47.740 ⇒ 00:13:53.190 Uttam Kumaran: So, one thing is, you can just… let’s ask it, like, a basic question, like…
126 00:13:54.600 ⇒ 00:13:58.029 Uttam Kumaran: I don’t know, you can say, like, tell me what macros are in this project.
127 00:14:12.260 ⇒ 00:14:16.799 Emily Giant: So basically, one great use case for this is just, like, chatting over the…
128 00:14:16.800 ⇒ 00:14:17.710 Uttam Kumaran: So, like…
129 00:14:17.860 ⇒ 00:14:26.609 Uttam Kumaran: tell me where this is. Does this exist? It’ll start to iterate through things. Another way to use this is to actually, like, make modifications. So let’s go into, like.
130 00:14:26.890 ⇒ 00:14:29.729 Uttam Kumaran: Some… so one thing we can… we can have it do…
131 00:14:30.310 ⇒ 00:14:39.150 Uttam Kumaran: Yeah, we don’t have to do this thing. So, one thing we can do is, let’s just say, okay, I need help creating a new
132 00:14:39.420 ⇒ 00:14:40.940 Uttam Kumaran: dbt model.
133 00:14:41.190 ⇒ 00:14:45.869 Uttam Kumaran: The goal… is it… is just to do a select one.
134 00:14:46.880 ⇒ 00:14:51.670 Uttam Kumaran: And I want to show you the process by which it’s actually creating this new file.
135 00:15:01.800 ⇒ 00:15:03.329 Emily Giant: Just, do I put in, like, any…
136 00:15:03.330 ⇒ 00:15:06.139 Uttam Kumaran: the one. Yeah, you can just put the number 1, yeah, perfect.
137 00:15:06.310 ⇒ 00:15:07.509 Uttam Kumaran: You can hit enter.
138 00:15:12.930 ⇒ 00:15:21.810 Uttam Kumaran: Great. So, at this point, what you can do is, if you scroll up here and go back up, you’ll see there’s a little file here that it created.
139 00:15:21.910 ⇒ 00:15:24.459 Emily Giant: And it’s a plus one, so you can just click on that.
140 00:15:25.910 ⇒ 00:15:29.189 Uttam Kumaran: And you can see here, it created Test Select 1.
141 00:15:29.720 ⇒ 00:15:46.730 Uttam Kumaran: And this is the value. So, basically what it did is it took our instructions, it said, great, I know what to do, it went into the models folder, right, so it knows where to put the models, and then it went ahead and just wrote it. At this point, if you open up GitHub Desktop again.
142 00:15:49.210 ⇒ 00:16:02.320 Uttam Kumaran: you’ll see that our file change is now being captured, but it hasn’t been pushed yet, right? So… so we can walk through the process of creating, like, a fake PR for this eventually, but let’s go back into cursor.
143 00:16:03.110 ⇒ 00:16:09.189 Uttam Kumaran: And I’ll show you another thing you can do. So one is, like, you want to either say keep or undo, so let’s just say keep.
144 00:16:10.360 ⇒ 00:16:20.950 Uttam Kumaran: And you can just click, yeah, keep there, and then one thing you can do is, let’s just go ahead and highlight this line, like, with your… with your cursor, yep, and then hit Command-K,
145 00:16:23.480 ⇒ 00:16:29.260 Uttam Kumaran: And then now you can just, like, literally say something here. So you can say, add another column to…
146 00:16:30.270 ⇒ 00:16:31.810 Uttam Kumaran: Like, just the number 2.
147 00:16:33.810 ⇒ 00:16:34.660 Uttam Kumaran: Great.
148 00:16:35.430 ⇒ 00:16:52.549 Uttam Kumaran: Nice. So, you can start to do, like, more rapid editing right in the file, if you’re, like, add a column here, or you select multiple things, add columns, change these to include underscores. So, like, anything where you have to edit a bunch of stuff, you can now do here pretty simply.
149 00:16:52.710 ⇒ 00:16:55.740 Uttam Kumaran: Let’s go ahead and just hit keep again.
150 00:16:57.920 ⇒ 00:17:01.499 Uttam Kumaran: And then another thing we can do is we go back to here.
151 00:17:03.940 ⇒ 00:17:13.990 Uttam Kumaran: If you go back to the plan search, like, if you go back for your type in this area, yep, one thing let’s do is, let’s actually… let’s go through the example of, like.
152 00:17:14.410 ⇒ 00:17:22.170 Uttam Kumaran: how I used it to build, like, Dim Calendar, for example. So, one thing we can do is, if you hit plus, and let’s open a new session.
153 00:17:22.280 ⇒ 00:17:24.249 Uttam Kumaran: So you can go back to the top here.
154 00:17:24.250 ⇒ 00:17:24.810 Emily Giant: Oh.
155 00:17:25.710 ⇒ 00:17:26.390 Emily Giant: Yes.
156 00:17:26.700 ⇒ 00:17:28.539 Uttam Kumaran: And we can just say.
157 00:17:29.320 ⇒ 00:17:39.010 Uttam Kumaran: Today, I’d like to build a new table called Dim Calendar. This is going to be our catch-all table for
158 00:17:39.900 ⇒ 00:17:47.029 Uttam Kumaran: Anything related to calendars, dates, like… Days of the week, etc.
159 00:17:51.840 ⇒ 00:17:55.490 Uttam Kumaran: And then one thing I like to do is I like to ask it to explain
160 00:17:56.090 ⇒ 00:17:59.470 Uttam Kumaran: Like, what it’s going to do before it starts to do things.
161 00:18:00.830 ⇒ 00:18:02.000 Uttam Kumaran: Exactly.
162 00:18:04.750 ⇒ 00:18:05.700 Uttam Kumaran: Perfect.
163 00:18:07.690 ⇒ 00:18:12.199 Uttam Kumaran: Yep, and then what you’ll see is it’ll start to walk through that. It’ll think about
164 00:18:13.110 ⇒ 00:18:16.989 Uttam Kumaran: Is there other… it’ll look through, is there other div calendars, like…
165 00:18:17.340 ⇒ 00:18:23.289 Uttam Kumaran: do we need, like, what types of calendar dimensions do we need? It’s then gonna build this.
166 00:18:38.120 ⇒ 00:18:39.010 Emily Giant: So fast!
167 00:18:40.250 ⇒ 00:18:41.269 Uttam Kumaran: It’s really good.
168 00:18:41.410 ⇒ 00:18:42.130 Emily Giant: Yeah.
169 00:18:44.540 ⇒ 00:18:56.389 Uttam Kumaran: So, basically, at this point, I usually read through, and I’m like, okay, if I was to ask… the way I look at it is, I think about if I was to ask, like, an intern, or, like, someone very junior to do something.
170 00:18:56.390 ⇒ 00:18:59.610 Emily Giant: And I say, explain to me how you would do it, this is kind of how I’m judging.
171 00:18:59.610 ⇒ 00:19:17.040 Uttam Kumaran: Because typically, we don’t give it enough information, and so there’s a good chance it’ll get it wrong. And so I read through, it’s like, look, are we gonna build a new calendar and new model structure, intermediate calendars, fiscal calendar, business context, this is the plan, it’s gonna create these columns.
172 00:19:17.320 ⇒ 00:19:26.209 Uttam Kumaran: And so, at this point, you can either say, like, I don’t like that, or I like this, or you can add this, so you can iterate with it, and then you can say, basically, go, and then it’ll go create that.
173 00:19:26.490 ⇒ 00:19:35.439 Uttam Kumaran: So Ashley, if you go back to the top, like, just scroll a little bit up, there’s… there should be a section after it starts where it has a little checklist.
174 00:19:37.170 ⇒ 00:19:55.729 Uttam Kumaran: Yep. So here’s the checklist. So what Cursor does behind the scenes, it actually creates, like, okay, what are the steps here I need to do? So one, it’s, like, analyze, it’s gonna design. As soon as you now give it the thumbs up, it’s gonna go create, create, and then test, which is basically, like, gonna… it’s gonna try to run this in dbt.
175 00:19:55.840 ⇒ 00:20:04.929 Uttam Kumaran: So let’s actually see if we can get it to that point. So if you’re okay with what Doom Calendar looks like now, you can go in and say, okay, please create it.
176 00:20:54.130 ⇒ 00:21:03.890 Uttam Kumaran: Great. It’s gonna always go overboard, by the way, so, like, if you want to, at any point, be like, I don’t need you to do that, what you can do is, you can take a look at the to-dos here.
177 00:21:06.500 ⇒ 00:21:11.479 Uttam Kumaran: And then you could say stop or skip that step. You know, you could interject if it’s like.
178 00:21:11.590 ⇒ 00:21:13.529 Uttam Kumaran: You don’t have to wait for it to finish.
179 00:21:13.690 ⇒ 00:21:19.989 Uttam Kumaran: So at this point, it looks like it just did dim calendar. It’s gonna go ahead and create a schema.yaml. At this point, I would just cancel it.
180 00:21:20.310 ⇒ 00:21:25.499 Uttam Kumaran: Because we don’t need… we don’t need to do… we don’t need to do that. So yeah, you can just reject it, that’s fine.
181 00:21:25.860 ⇒ 00:21:34.629 Uttam Kumaran: And then it’s gonna run… it’s gonna do tests. So what it’s gonna do now… okay, so this is actually a good… probably a good place to stop. Let’s go look at the dim calendar table it created.
182 00:21:36.020 ⇒ 00:21:38.190 Uttam Kumaran: Which is… you could just click right here.
183 00:21:38.690 ⇒ 00:21:39.610 Emily Giant: Oh, that’s right.
184 00:21:42.610 ⇒ 00:21:44.729 Uttam Kumaran: And then… yep, so…
185 00:21:45.220 ⇒ 00:21:52.030 Uttam Kumaran: Seems, like, okay. I don’t know whether it knows that we’re on Redshift, so it may not have gotten the functions correct.
186 00:21:52.160 ⇒ 00:21:58.949 Uttam Kumaran: But, like, for what it’s worth, looks decent. So let’s just hit… let’s just hit keep for now.
187 00:21:59.570 ⇒ 00:22:14.500 Uttam Kumaran: And I guess my question that I asked in the beginning is, like, have you… have you launched dbt from, like, terminal on your machine before? Okay, so one thing we wanna… we were gonna wanna do is install the dbt CLI. Thankfully, I do have…
188 00:22:15.110 ⇒ 00:22:22.110 Uttam Kumaran: I’m pretty sure I do have some type of document on that.
189 00:22:28.940 ⇒ 00:22:30.700 Uttam Kumaran: Let me see, okay.
190 00:22:33.950 ⇒ 00:22:35.660 Uttam Kumaran: Okay…
191 00:22:49.020 ⇒ 00:23:00.069 Uttam Kumaran: Okay, I’m gonna send this link in the Zoom chat. So if you could open this, this is our documentation that we have on how to…
192 00:23:01.500 ⇒ 00:23:04.740 Uttam Kumaran: Set dbt CLI.
193 00:23:05.060 ⇒ 00:23:06.370 Uttam Kumaran: And so…
194 00:23:06.490 ⇒ 00:23:16.489 Uttam Kumaran: we should walk through this, and we have… we don’t have that much time, so I want to make sure we do this, and then we can push our first PR through cursor. So,
195 00:23:16.920 ⇒ 00:23:28.379 Uttam Kumaran: One thing that we can do, honestly, you could probably just copy-paste this and have Kirscher do this, now that I think about it. So let’s try that. Copy-paste this whole thing.
196 00:23:28.620 ⇒ 00:23:32.840 Uttam Kumaran: And then open up a new… open up a new,
197 00:23:33.510 ⇒ 00:23:37.769 Uttam Kumaran: thing in cursor, like a new chat session, and then…
198 00:23:38.000 ⇒ 00:23:46.920 Uttam Kumaran: these chat sessions don’t… like, you don’t lose them, so that’s fine, you can just tap back. Paste it in, and just say, like, please help me do this. Please help me install the dbt CLI.
199 00:23:49.980 ⇒ 00:23:56.299 Uttam Kumaran: One thing that you’re going to need, though, and this is where, again, like, what you’ll find with Cursor is that, like.
200 00:23:57.830 ⇒ 00:24:11.210 Uttam Kumaran: you… you’re, like, still worth reading the instructions, is you’re gonna need to make sure that you have the dbt config, but let’s just run through it, and we can get that when it… when it asks you. So you could put allow list python.
201 00:24:11.340 ⇒ 00:24:15.040 Uttam Kumaran: That way, it can start to allow, this thing right here.
202 00:24:15.250 ⇒ 00:24:16.720 Uttam Kumaran: Yeah, perfect.
203 00:24:16.970 ⇒ 00:24:22.299 Uttam Kumaran: Okay, so it’s gonna find that you need… so also do this, like, you could hit Allow List down here, yep.
204 00:24:26.490 ⇒ 00:24:28.269 Uttam Kumaran: Yep, you can hit Allow List.
205 00:24:28.400 ⇒ 00:24:29.550 Uttam Kumaran: Perfect.
206 00:24:30.630 ⇒ 00:24:31.819 Uttam Kumaran: Perfect, yep.
207 00:24:33.960 ⇒ 00:24:34.750 Uttam Kumaran: Yep.
208 00:24:37.790 ⇒ 00:24:42.519 Uttam Kumaran: And then it’s going to ask you here, so you can hit open in terminal.
209 00:24:42.990 ⇒ 00:24:52.089 Uttam Kumaran: In order to install Homebrew, which is just, like, an installation package, you just have to put in your password. So you just type in your password. It’s not gonna show up, it’s gonna all be…
210 00:24:52.200 ⇒ 00:24:53.520 Uttam Kumaran: blank, so…
211 00:24:54.710 ⇒ 00:24:55.949 Emily Giant: Where’s this that I typed it in?
212 00:24:55.950 ⇒ 00:25:01.800 Uttam Kumaran: You could hit X on this, yeah, and then literally just cursor here, it’s not gonna appear, so just…
213 00:25:02.040 ⇒ 00:25:04.630 Uttam Kumaran: You’re just gonna wanna get it right.
214 00:25:04.790 ⇒ 00:25:06.889 Emily Giant: I have no idea… what… what password?
215 00:25:06.890 ⇒ 00:25:08.340 Uttam Kumaran: Your computer password.
216 00:25:08.340 ⇒ 00:25:08.970 Emily Giant: Okay.
217 00:25:11.040 ⇒ 00:25:12.639 Emily Giant: Is anything happening?
218 00:25:12.640 ⇒ 00:25:14.320 Uttam Kumaran: No, no, no, it won’t show up.
219 00:25:14.320 ⇒ 00:25:15.020 Emily Giant: Oh, oh.
220 00:25:15.020 ⇒ 00:25:18.550 Uttam Kumaran: what I mean. So… You’re just gonna have to type it.
221 00:25:19.030 ⇒ 00:25:20.019 Uttam Kumaran: Unless you’re, like.
222 00:25:20.020 ⇒ 00:25:20.790 Emily Giant: pregnant, and now I…
223 00:25:20.790 ⇒ 00:25:21.760 Uttam Kumaran: Neat to see it.
224 00:25:22.820 ⇒ 00:25:25.989 Uttam Kumaran: Or just back a bunch of times and then start again, yeah.
225 00:25:27.380 ⇒ 00:25:28.090 Uttam Kumaran: Yeah.
226 00:25:28.610 ⇒ 00:25:29.190 Emily Giant: Okay.
227 00:25:29.410 ⇒ 00:25:31.129 Emily Giant: I’m scared.
228 00:25:33.770 ⇒ 00:25:35.749 Demilade Agboola: Don’t worry, you’re not about to be hacked.
229 00:25:37.370 ⇒ 00:25:40.339 Uttam Kumaran: Yeah, so I wouldn’t press anything.
230 00:25:40.530 ⇒ 00:25:41.310 Emily Giant: Okay.
231 00:25:44.230 ⇒ 00:25:46.089 Uttam Kumaran: It’s gonna install all this stuff.
232 00:25:46.480 ⇒ 00:25:50.350 Uttam Kumaran: But while we’re looking at this, let’s take a look at this Xcode thing.
233 00:25:51.080 ⇒ 00:25:52.559 Uttam Kumaran: See if that finished.
234 00:25:52.710 ⇒ 00:25:54.960 Emily Giant: Okay, perfect. We can hit done.
235 00:25:55.540 ⇒ 00:25:57.139 Uttam Kumaran: We should be good there.
236 00:25:57.560 ⇒ 00:26:00.209 Uttam Kumaran: Can you scroll up here? Is it, like…
237 00:26:00.560 ⇒ 00:26:04.049 Uttam Kumaran: It’s saying, the script will install… okay.
238 00:26:05.180 ⇒ 00:26:07.789 Emily Giant: Do I have to click run or anything? To press…
239 00:26:07.790 ⇒ 00:26:09.969 Uttam Kumaran: Oh, press enter to continue, yeah.
240 00:26:10.410 ⇒ 00:26:11.910 Uttam Kumaran: Okay, cool.
241 00:26:15.530 ⇒ 00:26:19.009 Uttam Kumaran: You should tell Alex that you installed Homebrew today, he’ll be happy.
242 00:26:19.010 ⇒ 00:26:20.660 Emily Giant: I will. What is it again?
243 00:26:21.020 ⇒ 00:26:22.450 Uttam Kumaran: Home… homebrew?
244 00:26:22.450 ⇒ 00:26:23.210 Emily Giant: Yeah.
245 00:26:23.360 ⇒ 00:26:25.099 Emily Giant: I should remember that.
246 00:26:30.430 ⇒ 00:26:32.710 Uttam Kumaran: Okay, perfect. So…
247 00:26:32.910 ⇒ 00:26:37.220 Uttam Kumaran: Great, and then let’s go ahead and hit run here on the… on the… on the right.
248 00:26:39.530 ⇒ 00:26:50.099 Uttam Kumaran: I would spend time explaining to you what all these are doing. It’s not super crucial at this point, so it’s fine. But I just want to get your whole machine set up to actually start using this.
249 00:26:50.450 ⇒ 00:26:56.330 Uttam Kumaran: While we’re on the call. The other… I feel like you have a good sense of, like, what you could do with cursor, and you’ll start to push it, and then…
250 00:26:56.330 ⇒ 00:26:56.770 Emily Giant: Yeah.
251 00:26:56.770 ⇒ 00:27:02.480 Uttam Kumaran: We can do a… we can do a 102 session after you… you try to rip through it for a while.
252 00:27:02.480 ⇒ 00:27:04.900 Emily Giant: Installing things is my…
253 00:27:05.180 ⇒ 00:27:11.759 Uttam Kumaran: Yeah, that’s what I want to help you out for, because this could easily be intimidating, so I’ll get you through this.
254 00:27:23.710 ⇒ 00:27:25.260 Uttam Kumaran: Okay, great.
255 00:27:26.740 ⇒ 00:27:27.870 Uttam Kumaran: Great.
256 00:27:33.380 ⇒ 00:27:37.890 Uttam Kumaran: So while this is working, can you go to dbt Cloud?
257 00:27:40.040 ⇒ 00:27:43.860 Uttam Kumaran: And… we can go back to, like, the home area.
258 00:27:46.200 ⇒ 00:27:50.609 Uttam Kumaran: And… yeah, and go in here, click Setup CLI, there at the bottom.
259 00:27:51.250 ⇒ 00:27:52.350 Uttam Kumaran: Perfect.
260 00:27:52.930 ⇒ 00:27:56.779 Uttam Kumaran: What you’re gonna wanna do is click this.
261 00:27:58.260 ⇒ 00:28:00.289 Uttam Kumaran: Download the CLI, yep.
262 00:28:00.730 ⇒ 00:28:04.239 Uttam Kumaran: Okay, and you just… just make sure we have that, like, open in a finder.
263 00:28:05.020 ⇒ 00:28:06.330 Emily Giant: Conveniently.
264 00:28:06.410 ⇒ 00:28:08.820 Uttam Kumaran: Okay, yeah, let’s, let’s… we could just leave this here.
265 00:28:08.990 ⇒ 00:28:14.609 Uttam Kumaran: So, it’s running this… Installing… yeah, so this is fine, yep.
266 00:28:14.950 ⇒ 00:28:20.190 Uttam Kumaran: The open cursor again… It’s installing this…
267 00:28:22.070 ⇒ 00:28:24.649 Uttam Kumaran: Okay, yeah, this is gonna probably take a sec.
268 00:28:27.000 ⇒ 00:28:31.560 Uttam Kumaran: Okay, let’s just let it go for a sec.
269 00:28:32.910 ⇒ 00:28:42.989 Uttam Kumaran: Basically, what we’re doing is we’re gonna create a connection between your machine and the dbt cloud, so that you can start to issue commands like dbt run directly from cursor.
270 00:28:43.480 ⇒ 00:28:43.929 Emily Giant: Oh, sweet.
271 00:28:43.930 ⇒ 00:28:54.249 Uttam Kumaran: So, similarly, like, you know, in dbt Cloud, you run, like, dbt run dash dash whatever, you could start to do that here. So you don’t… basically, I don’t use dbt Cloud at all.
272 00:28:54.480 ⇒ 00:28:58.850 Uttam Kumaran: All my development and testing is now all within Cursor.
273 00:28:58.980 ⇒ 00:29:00.990 Uttam Kumaran: So that should streamline a little bit.
274 00:29:01.210 ⇒ 00:29:05.420 Emily Giant: Yeah, that sounds like a dream. dbt Cloud is not the easiest to use.
275 00:29:05.590 ⇒ 00:29:06.370 Uttam Kumaran: Yeah.
276 00:29:07.240 ⇒ 00:29:09.459 Emily Giant: It’s not hard, it’s just clunky.
277 00:29:10.580 ⇒ 00:29:19.120 Uttam Kumaran: So maybe while this is running, we could parallel path another task. So let’s just… let’s go through GitHub Desktop, and I’ll show you how to make a first PR.
278 00:29:19.280 ⇒ 00:29:21.960 Uttam Kumaran: So, go ahead and open… Odessa?
279 00:29:21.960 ⇒ 00:29:22.480 Emily Giant: Let’s name.
280 00:29:22.480 ⇒ 00:29:25.859 Uttam Kumaran: Go ahead and create… go to Current Branch.
281 00:29:26.660 ⇒ 00:29:28.370 Uttam Kumaran: Click on New Branch.
282 00:29:29.100 ⇒ 00:29:32.140 Uttam Kumaran: And let’s just do, like, Emily cursor test or something.
283 00:29:34.500 ⇒ 00:29:36.380 Uttam Kumaran: So this is creating a new branch.
284 00:29:37.320 ⇒ 00:29:39.420 Uttam Kumaran: You can bring your changes with you.
285 00:29:40.540 ⇒ 00:29:41.740 Uttam Kumaran: Perfect.
286 00:29:42.630 ⇒ 00:29:51.850 Uttam Kumaran: And a couple things that are gonna be really nice. So one is, let’s commit these two separately. So let’s just deselect this one.
287 00:29:54.000 ⇒ 00:30:00.879 Uttam Kumaran: And what you can do here is you can just write, creating test, Just say, like, creating…
288 00:30:01.080 ⇒ 00:30:03.340 Uttam Kumaran: Yeah, whatever. And then you can hit commit.
289 00:30:05.140 ⇒ 00:30:08.650 Uttam Kumaran: And then now you can say, creating DIM Calendar.
290 00:30:09.510 ⇒ 00:30:13.070 Uttam Kumaran: As another one. Just make sure to select that box.
291 00:30:13.600 ⇒ 00:30:14.220 Emily Giant: Okay.
292 00:30:15.640 ⇒ 00:30:17.980 Emily Giant: How does it al- it already says that.
293 00:30:18.120 ⇒ 00:30:22.979 Uttam Kumaran: Yeah, like, if you… if you commit it, it’ll say that, but, like, I just… just for…
294 00:30:23.430 ⇒ 00:30:29.499 Uttam Kumaran: just for exercise sake, worth trying to type something in. It’s not always going to be that standard, right? So…
295 00:30:30.030 ⇒ 00:30:35.890 Uttam Kumaran: Another thing you… before you hit commit, one thing I also want to show you is hit deselect here.
296 00:30:37.500 ⇒ 00:30:48.399 Uttam Kumaran: So let me show you an example of, like, let’s say we’re modifying just part of a file, or in several places, and you’re making several different types of changes. Go ahead and click and drag your cursor on this CTE.
297 00:30:51.430 ⇒ 00:30:54.540 Emily Giant: Sorry, I was telling someone I’m gonna be 2 minutes late to our meeting.
298 00:30:54.540 ⇒ 00:30:55.449 Uttam Kumaran: No problem.
299 00:30:55.560 ⇒ 00:31:01.480 Uttam Kumaran: And I, I could… we could continue this, later, too, but, just if you click on 13 and drag.
300 00:31:02.200 ⇒ 00:31:04.170 Emily Giant: Dragged down to just 19.
301 00:31:04.280 ⇒ 00:31:06.449 Uttam Kumaran: Yeah, literally just drag your cursor down.
302 00:31:07.350 ⇒ 00:31:08.630 Emily Giant: Oh, drag it down, sorry.
303 00:31:08.630 ⇒ 00:31:13.870 Uttam Kumaran: Drag it. Yeah. Well, like, hold 13 and down.
304 00:31:18.840 ⇒ 00:31:20.249 Uttam Kumaran: Wait, click it once…
305 00:31:20.610 ⇒ 00:31:20.930 Emily Giant: Okay.
306 00:31:20.930 ⇒ 00:31:21.680 Uttam Kumaran: drag down.
307 00:31:22.340 ⇒ 00:31:25.299 Emily Giant: It is not… it hates me. But if I do it… oh my god.
308 00:31:25.300 ⇒ 00:31:26.649 Uttam Kumaran: Try it on the Plus.
309 00:31:30.220 ⇒ 00:31:30.850 Emily Giant: It doesn’t even…
310 00:31:32.000 ⇒ 00:31:39.080 Uttam Kumaran: Basically, what I’m trying to… I don’t know, it works on my machine, but basically, if you click 13, 14, 15, 16, like, let’s run… we’ll run through this last example.
311 00:31:39.210 ⇒ 00:31:42.829 Uttam Kumaran: You can just commit, like, a couple of lines of changes.
312 00:31:42.830 ⇒ 00:31:43.600 Emily Giant: Oh, okay, cool.
313 00:31:43.600 ⇒ 00:31:49.169 Uttam Kumaran: So, let’s say here, you’re gonna say, creating my first CTE as a commit message.
314 00:31:52.430 ⇒ 00:31:59.730 Uttam Kumaran: So I would actually put that in here, in the commit message. So this is what’ll show up, like, in the PR as, like, the commit. So creating my first CTE,
315 00:32:00.460 ⇒ 00:32:01.960 Uttam Kumaran: And then you could hit commit.
316 00:32:05.890 ⇒ 00:32:15.919 Uttam Kumaran: And then, so that’s gonna… that’s gonna just commit that piece. Now you still have, of course, this whole file, so we can go ahead and just do the whole thing. You can hit commit, and…
317 00:32:16.670 ⇒ 00:32:20.929 Uttam Kumaran: So, now that we have those two changes, we’re gonna do a couple things. One, you’re gonna hit Publish Branch.
318 00:32:21.890 ⇒ 00:32:22.560 Uttam Kumaran: That’s gonna pop.