Meeting Title: Data Office Hours Date: 2025-04-02 Meeting participants: Annie Yu, Uttam Kumaran
WEBVTT
1 00:06:32.260 ⇒ 00:06:33.760 Annie Yu: Oh! Hi!
2 00:06:35.710 ⇒ 00:06:36.960 Uttam Kumaran: Hey? Can you hear me?
3 00:06:37.140 ⇒ 00:06:37.750 Annie Yu: Yeah.
4 00:06:37.990 ⇒ 00:06:44.920 Annie Yu: Well, Ryan dropped, cause we were not sure if you’re you’ll be here
5 00:06:45.510 ⇒ 00:06:47.910 Uttam Kumaran: Is he still? Is he still working?
6 00:06:47.910 ⇒ 00:06:49.010 Annie Yu: Apparently.
7 00:06:52.060 ⇒ 00:06:56.080 Annie Yu: Oh, wait! I saw your dog. Who’s that?
8 00:06:57.600 ⇒ 00:06:59.090 Uttam Kumaran: He’s down here. I’ll show you
9 00:06:59.920 ⇒ 00:07:01.050 Annie Yu: Oh.
10 00:07:04.670 ⇒ 00:07:05.660 Annie Yu: sweetie!
11 00:07:06.520 ⇒ 00:07:09.789 Annie Yu: Oh, what’s is it he or she
12 00:07:09.790 ⇒ 00:07:10.750 Uttam Kumaran: The he.
13 00:07:11.710 ⇒ 00:07:15.633 Annie Yu: Oh, he’s so cute! He he knows he’s cute
14 00:07:16.080 ⇒ 00:07:19.159 Uttam Kumaran: I know he’s he has a lot. There’s a lot of eye contact
15 00:07:19.480 ⇒ 00:07:19.775 Annie Yu: Yeah.
16 00:07:20.070 ⇒ 00:07:21.089 Uttam Kumaran: Not eye contact
17 00:07:24.000 ⇒ 00:07:31.739 Uttam Kumaran: cool. Well, thank you so much for making the time. And I have one question. But I think this should be an easy fix.
18 00:07:31.980 ⇒ 00:07:37.529 Uttam Kumaran: Okay, let’s go for it. Okay? So I owe you. There’s some snowflake issue, right? Or what happened earlier.
19 00:07:37.844 ⇒ 00:07:42.240 Annie Yu: No, that’s actually the one I wanted to ask and I think it’s
20 00:07:42.530 ⇒ 00:07:50.300 Annie Yu: just the github. Let me see, I’m gonna screen.
21 00:07:52.770 ⇒ 00:07:53.720 Annie Yu: Okay.
22 00:07:54.220 ⇒ 00:07:55.890 Annie Yu: So here.
23 00:07:56.960 ⇒ 00:08:05.240 Annie Yu: So I’m I’m just trying to add that call logs data to our repository.
24 00:08:05.780 ⇒ 00:08:08.919 Annie Yu: And then I did the change committed.
25 00:08:10.470 ⇒ 00:08:15.230 Annie Yu: But then I’m not able to push it, and I’m not sure if it’s a
26 00:08:15.350 ⇒ 00:08:18.556 Uttam Kumaran: Okay, wait. Oh, yeah, okay, this is it. So give me one sec. Let me
27 00:08:19.070 ⇒ 00:08:20.690 Uttam Kumaran: Let me make this change
28 00:08:20.690 ⇒ 00:08:21.330 Annie Yu: Okay.
29 00:08:48.370 ⇒ 00:08:52.460 Annie Yu: So that’s an access issue. Right? Just okay?
30 00:08:56.610 ⇒ 00:09:02.950 Uttam Kumaran: It’s just because we haven’t used this repo in a while. So okay, let me do this import data team. Right?
31 00:09:07.810 ⇒ 00:09:09.940 Uttam Kumaran: Okay, can you try? Now.
32 00:09:10.450 ⇒ 00:09:16.570 Annie Yu: Okay, do I need to refresh or not? Oh, looks like it’s doing this thing.
33 00:09:19.790 ⇒ 00:09:23.420 Annie Yu: Wait cool.
34 00:09:38.300 ⇒ 00:09:43.080 Annie Yu: So do I wait for someone to review or
35 00:09:43.080 ⇒ 00:09:45.530 Uttam Kumaran: Yes, so I mean, I can review right now
36 00:09:45.530 ⇒ 00:09:46.649 Annie Yu: Okay. Cool.
37 00:09:47.299 ⇒ 00:09:51.270 Uttam Kumaran: So let me just take a look. So one thing you can do is you can tag me as a reviewer.
38 00:09:53.618 ⇒ 00:09:56.570 Uttam Kumaran: Yeah, you can just type in my name.
39 00:09:58.530 ⇒ 00:10:01.189 Uttam Kumaran: Yeah? And then I will take a look
40 00:10:01.990 ⇒ 00:10:02.630 Annie Yu: Okay.
41 00:10:04.950 ⇒ 00:10:05.470 Annie Yu: Yes.
42 00:10:05.470 ⇒ 00:10:08.979 Uttam Kumaran: And then. So I guess one of my one of my questions is
43 00:10:09.320 ⇒ 00:10:12.260 Uttam Kumaran: for this. Pr. It would be helpful if you.
44 00:10:12.480 ⇒ 00:10:15.719 Uttam Kumaran: if you have a screenshot of what the dashboard looks like.
45 00:10:16.450 ⇒ 00:10:17.160 Annie Yu: Oh, wait!
46 00:10:17.160 ⇒ 00:10:17.790 Uttam Kumaran: Luckily.
47 00:10:17.790 ⇒ 00:10:21.470 Annie Yu: I actually haven’t had a dashboard yet
48 00:10:22.130 ⇒ 00:10:24.740 Uttam Kumaran: Well, I guess like, how did you? Did you test this?
49 00:10:25.380 ⇒ 00:10:27.309 Uttam Kumaran: Oh, so this is just a model
50 00:10:27.310 ⇒ 00:10:28.140 Annie Yu: Yeah.
51 00:10:28.760 ⇒ 00:10:34.250 Uttam Kumaran: Okay, okay, okay, that’s fine. I mean, did it? Did it like give any errors, though?
52 00:10:35.190 ⇒ 00:10:36.759 Annie Yu: I don’t think so. No.
53 00:10:36.760 ⇒ 00:10:37.580 Uttam Kumaran: Okay.
54 00:10:37.580 ⇒ 00:10:40.259 Annie Yu: Let me but then.
55 00:10:41.990 ⇒ 00:10:50.089 Annie Yu: since you also mentioned the dashboard, I think 1 1 thing I’m experiencing now is
56 00:10:50.860 ⇒ 00:10:53.810 Annie Yu: let me see, where’s my other?
57 00:10:57.020 ⇒ 00:10:58.649 Annie Yu: Wait. Okay, cool.
58 00:10:59.400 ⇒ 00:11:02.470 Uttam Kumaran: And then what is what is? Try to interval
59 00:11:04.700 ⇒ 00:11:05.780 Annie Yu: What do you mean?
60 00:11:06.440 ⇒ 00:11:08.719 Uttam Kumaran: Do you have this function? Try to interval
61 00:11:11.900 ⇒ 00:11:20.619 Annie Yu: Oh, I was trying to cause when I loaded that data to Snowflake. I could only use.
62 00:11:21.090 ⇒ 00:11:24.400 Annie Yu: I can only make those duration characters.
63 00:11:25.630 ⇒ 00:11:28.249 Annie Yu: and I actually want them to be interval
64 00:11:28.490 ⇒ 00:11:29.869 Uttam Kumaran: But what is an interval?
65 00:11:34.010 ⇒ 00:11:39.510 Annie Yu: Isn’t it like what you use for like duration or not?
66 00:11:40.800 ⇒ 00:11:44.320 Uttam Kumaran: I don’t know. I’m asking you. I don’t know. I’ve never used this function
67 00:11:44.970 ⇒ 00:11:49.170 Annie Yu: Or I I think my or it could be time to
68 00:11:50.480 ⇒ 00:11:52.879 Uttam Kumaran: But like, I guess, what does the function do?
69 00:11:54.400 ⇒ 00:11:59.110 Annie Yu: Oh, it’s the same thing as 2 interval, but then, if it’s
70 00:12:00.440 ⇒ 00:12:02.439 Uttam Kumaran: What does 2 interval do?
71 00:12:04.540 ⇒ 00:12:06.159 Annie Yu: I’m gonna find out
72 00:12:06.430 ⇒ 00:12:11.340 Uttam Kumaran: Yeah, I just never. I’ve never used. I’ve never used interval before. I don’t know what it is
73 00:12:11.530 ⇒ 00:12:18.260 Annie Yu: I think I was debating on using interval or time, but I just know that
74 00:12:18.540 ⇒ 00:12:23.849 Annie Yu: with them being character, I can’t visualize them in real
75 00:12:24.490 ⇒ 00:12:26.819 Uttam Kumaran: Oh, I see. Okay.
76 00:12:29.440 ⇒ 00:12:33.580 Uttam Kumaran: But I guess my question is like, What is the like? What is the value of the column? Then
77 00:12:34.975 ⇒ 00:12:40.680 Annie Yu: I can show you, but it’s just what’s this
78 00:12:41.320 ⇒ 00:12:45.510 Uttam Kumaran: Yeah, like, if you have your local rail, then we can. I just. It would be cool just to see
79 00:12:46.410 ⇒ 00:12:58.170 Annie Yu: Yeah. And it’s I also do have another question about real, too. Okay, let me see, I’m I’m just opening too many windows.
80 00:12:59.050 ⇒ 00:12:59.819 Annie Yu: Let’s see.
81 00:13:03.510 ⇒ 00:13:04.950 Annie Yu: it’s a real.
82 00:13:10.880 ⇒ 00:13:14.870 Annie Yu: Let me try real start.
83 00:13:16.790 ⇒ 00:13:17.580 Annie Yu: Nope.
84 00:13:26.080 ⇒ 00:13:27.150 Annie Yu: hmm!
85 00:13:30.590 ⇒ 00:13:32.440 Annie Yu: Am I in the right one?
86 00:13:33.320 ⇒ 00:13:34.230 Annie Yu: See?
87 00:13:37.390 ⇒ 00:13:38.410 Annie Yu: Thank you.
88 00:13:44.900 ⇒ 00:13:47.429 Annie Yu: No, wait! What did I do wrong?
89 00:13:52.630 ⇒ 00:13:54.630 Uttam Kumaran: You’re there. You can just run real start
90 00:13:55.310 ⇒ 00:13:56.030 Annie Yu: Yeah.
91 00:13:59.700 ⇒ 00:14:00.450 Annie Yu: okay.
92 00:14:07.470 ⇒ 00:14:11.049 Uttam Kumaran: So then, where is your latest call? Logs. March model.
93 00:14:11.940 ⇒ 00:14:12.710 Uttam Kumaran: Okay?
94 00:14:14.224 ⇒ 00:14:16.550 Annie Yu: Source, this one
95 00:14:16.980 ⇒ 00:14:20.269 Uttam Kumaran: But if you go to the call logs march metrics
96 00:14:20.270 ⇒ 00:14:20.990 Annie Yu: Yep.
97 00:14:21.710 ⇒ 00:14:22.420 Uttam Kumaran: Okay?
98 00:14:25.090 ⇒ 00:14:27.060 Uttam Kumaran: Oh, but then you do have a dashboard
99 00:14:28.030 ⇒ 00:14:29.790 Annie Yu: I, I
100 00:14:29.970 ⇒ 00:14:38.299 Annie Yu: the AI generated it for me. But then I can’t see the data here. And I think it’s because of the data type
101 00:14:38.900 ⇒ 00:14:40.590 Uttam Kumaran: Well, that’s because well.
102 00:14:40.590 ⇒ 00:14:41.200 Annie Yu: Yeah.
103 00:14:41.200 ⇒ 00:14:47.600 Uttam Kumaran: Oh, so that’s what I’m saying like, can you go to? Can you go to the
104 00:14:48.790 ⇒ 00:14:54.890 Uttam Kumaran: okay? So you don’t have a wait? What?
105 00:14:55.760 ⇒ 00:14:59.809 Uttam Kumaran: So this, isn’t it? This you’re what you’re seeing doesn’t match what your Pr is
106 00:15:00.870 ⇒ 00:15:04.179 Annie Yu: Oh, yeah, yeah, I think that’s another
107 00:15:04.940 ⇒ 00:15:10.420 Annie Yu: problem. I I don’t think my real is connected to good.
108 00:15:10.780 ⇒ 00:15:12.190 Annie Yu: For some reason
109 00:15:12.950 ⇒ 00:15:14.299 Uttam Kumaran: Oh, why not?
110 00:15:14.720 ⇒ 00:15:17.659 Annie Yu: I I don’t. I’m not so sure
111 00:15:17.870 ⇒ 00:15:22.539 Uttam Kumaran: So where is? Where is your local github like? Where are your files?
112 00:15:25.230 ⇒ 00:15:26.240 Annie Yu: Oh!
113 00:15:26.240 ⇒ 00:15:29.000 Uttam Kumaran: Like. Open open your github, desktop
114 00:15:29.960 ⇒ 00:15:30.830 Annie Yu: Okay.
115 00:15:32.690 ⇒ 00:15:37.960 Uttam Kumaran: And then click on this, and then right click.
116 00:15:38.330 ⇒ 00:15:41.160 Uttam Kumaran: So yeah, do reveal and finder.
117 00:15:45.560 ⇒ 00:15:50.449 Uttam Kumaran: Okay, so then open a terminal here, like, where is your? Where is your other terminal
118 00:15:52.034 ⇒ 00:15:53.329 Annie Yu: What do you mean?
119 00:15:53.330 ⇒ 00:15:55.899 Uttam Kumaran: Like your the terminal window that you have
120 00:15:56.220 ⇒ 00:15:56.840 Annie Yu: Here.
121 00:15:56.840 ⇒ 00:15:58.549 Uttam Kumaran: Like? Where is this? Pointing to
122 00:16:00.900 ⇒ 00:16:03.100 Annie Yu: I think it’s in here right
123 00:16:05.700 ⇒ 00:16:09.540 Uttam Kumaran: But I guess like so I see. Call logs March model.
124 00:16:10.690 ⇒ 00:16:14.349 Uttam Kumaran: But I don’t see that here. Call logs March model
125 00:16:14.610 ⇒ 00:16:15.560 Annie Yu: Yeah.
126 00:16:16.830 ⇒ 00:16:20.950 Uttam Kumaran: So click on this, like click on this
127 00:16:20.950 ⇒ 00:16:21.720 Annie Yu: Yeah.
128 00:16:21.720 ⇒ 00:16:23.020 Uttam Kumaran: And go to models.
129 00:16:24.750 ⇒ 00:16:35.530 Uttam Kumaran: Okay, see? So this is this is not pointing to this, because it’s not here right now. So right? So go back right, go back one so you could just you could just exit out of the current rail
130 00:16:36.602 ⇒ 00:16:37.850 Annie Yu: Okay, do? I just
131 00:16:37.850 ⇒ 00:16:41.410 Uttam Kumaran: Like you have to do control. C, like, you can pull it down. Basically
132 00:16:42.140 ⇒ 00:16:43.110 Annie Yu: Okay.
133 00:16:43.680 ⇒ 00:16:47.770 Uttam Kumaran: Yep, and then go back to finder.
134 00:16:49.330 ⇒ 00:16:51.699 Uttam Kumaran: and then right click here and then do open.
135 00:16:52.370 ⇒ 00:16:55.369 Uttam Kumaran: Can you open a terminal? Or is that a thing.
136 00:16:56.270 ⇒ 00:16:58.719 Uttam Kumaran: Okay, here’s another way. Go open, github desktop
137 00:16:59.000 ⇒ 00:16:59.800 Annie Yu: Okay.
138 00:17:01.190 ⇒ 00:17:04.939 Uttam Kumaran: And then, if you right, click, if you right, click on brain, forge analytics
139 00:17:05.880 ⇒ 00:17:07.939 Uttam Kumaran: and then do open and terminal
140 00:17:11.740 ⇒ 00:17:17.819 Uttam Kumaran: cool from here. Now CD. Into into the ABC. Home
141 00:17:22.145 ⇒ 00:17:22.659 Annie Yu: Okay.
142 00:17:27.660 ⇒ 00:17:28.569 Uttam Kumaran: Just hit tab
143 00:17:29.260 ⇒ 00:17:30.110 Annie Yu: Okay.
144 00:17:30.300 ⇒ 00:17:31.680 Annie Yu: Wait. Oh, yeah.
145 00:17:33.600 ⇒ 00:17:35.350 Uttam Kumaran: Yeah, and then do real start.
146 00:17:44.250 ⇒ 00:17:48.440 Uttam Kumaran: Yeah, okay. So that the old terminal was probably pointing to something else.
147 00:17:48.590 ⇒ 00:17:54.420 Uttam Kumaran: So now you have to run real and full again, because click on sources
148 00:17:54.630 ⇒ 00:17:55.440 Annie Yu: Hmm.
149 00:17:56.090 ⇒ 00:17:57.470 Uttam Kumaran: And click on one of them.
150 00:17:58.170 ⇒ 00:18:01.129 Uttam Kumaran: So do you remember what we did yesterday when this happened?
151 00:18:03.350 ⇒ 00:18:04.499 Annie Yu: You mean all red
152 00:18:05.060 ⇒ 00:18:06.940 Uttam Kumaran: Like this. This is the error down here
153 00:18:18.920 ⇒ 00:18:21.310 Uttam Kumaran: But we ran. We had to pull down the credentials.
154 00:18:23.870 ⇒ 00:18:26.310 Uttam Kumaran: remember, we ran rail and pull
155 00:18:29.040 ⇒ 00:18:31.250 Annie Yu: In the real end pool. Yeah.
156 00:18:32.160 ⇒ 00:18:35.690 Uttam Kumaran: Yep. So if you just run that again, they
157 00:18:35.820 ⇒ 00:18:38.849 Uttam Kumaran: so yeah, 1st thing is, I would close this one
158 00:18:38.850 ⇒ 00:18:39.450 Annie Yu: Okay.
159 00:18:39.450 ⇒ 00:18:40.200 Uttam Kumaran: Hold on!
160 00:18:40.200 ⇒ 00:18:41.040 Annie Yu: This one.
161 00:18:41.330 ⇒ 00:18:42.010 Uttam Kumaran: Yeah.
162 00:18:42.010 ⇒ 00:18:45.839 Annie Yu: So does that mean? I, I probably have a local file
163 00:18:45.840 ⇒ 00:18:49.470 Uttam Kumaran: You probably have a clone somewhere. That’s that’s like stale
164 00:18:49.470 ⇒ 00:18:50.320 Annie Yu: Okay.
165 00:18:50.540 ⇒ 00:18:54.870 Uttam Kumaran: Yeah, so control C, and then roll, run real and pull
166 00:18:58.920 ⇒ 00:19:04.790 Uttam Kumaran: cool. Oh, go go. So do CD dot dot.
167 00:19:05.970 ⇒ 00:19:13.419 Uttam Kumaran: or actually, so you need to. You have to actually specify the project. Sorry. So if you’ve done real and pull, and then do dash, dash, project.
168 00:19:14.620 ⇒ 00:19:15.190 Annie Yu: Yeah.
169 00:19:17.250 ⇒ 00:19:21.480 Uttam Kumaran: And then you just need to do you need to just type in the yeah, the project
170 00:19:23.370 ⇒ 00:19:26.150 Uttam Kumaran: which is like ABC home and commercial dash, real
171 00:19:27.110 ⇒ 00:19:28.360 Annie Yu: Dash reward?
172 00:19:28.480 ⇒ 00:19:29.270 Annie Yu: Yeah.
173 00:19:29.620 ⇒ 00:19:33.750 Uttam Kumaran: Yeah, cool. Now do real start
174 00:19:39.220 ⇒ 00:19:44.859 Uttam Kumaran: great. So now it looks like you have an issue in your model. So click, so click on your model.
175 00:19:45.300 ⇒ 00:19:49.909 Uttam Kumaran: And then, yep. So this is what I’m saying is like I. If I had reviewed the Pr.
176 00:19:49.910 ⇒ 00:19:50.300 Annie Yu: Yeah.
177 00:19:50.300 ⇒ 00:19:54.890 Uttam Kumaran: You need to make sure that all all of your stuff is running and real before
178 00:19:55.780 ⇒ 00:19:59.669 Uttam Kumaran: before pushing the Pr. So it looks like right now. There’s some syntax error.
179 00:20:01.400 ⇒ 00:20:03.620 Uttam Kumaran: and it’s probably because you’re missing a comma here
180 00:20:04.340 ⇒ 00:20:05.890 Annie Yu: Oh, okay.
181 00:20:07.380 ⇒ 00:20:11.669 Annie Yu: Still, could it be these ones
182 00:20:12.090 ⇒ 00:20:14.419 Uttam Kumaran: Yeah, I mean, I’ve never seen.
183 00:20:15.320 ⇒ 00:20:21.640 Uttam Kumaran: I don’t know. I’ve never used a function, so I’m not sure but it looks like.
184 00:20:27.970 ⇒ 00:20:31.140 Uttam Kumaran: like, are these in your in their source.
185 00:20:34.390 ⇒ 00:20:36.779 Uttam Kumaran: So check, yeah, click on, call logs. March
186 00:20:39.050 ⇒ 00:20:43.439 Uttam Kumaran: And look. It says, row type as space.
187 00:20:43.980 ⇒ 00:20:44.790 Uttam Kumaran: So
188 00:20:44.850 ⇒ 00:20:45.540 Annie Yu: Oh!
189 00:20:47.760 ⇒ 00:20:53.669 Uttam Kumaran: Yeah. And then other thing is like we shouldn’t have call like we should rename these in the Csv, probably
190 00:20:54.490 ⇒ 00:20:59.719 Uttam Kumaran: These are all like this is gonna be tough like you don’t. Wanna you want all these to be lower case
191 00:21:00.520 ⇒ 00:21:01.280 Uttam Kumaran: right?
192 00:21:01.420 ⇒ 00:21:02.170 Annie Yu: Yeah.
193 00:21:02.820 ⇒ 00:21:08.059 Uttam Kumaran: So you can either probably re upload the Csv and change the columns or
194 00:21:08.250 ⇒ 00:21:16.230 Uttam Kumaran: you’ll have to. You’ll have to do. Just change it to. Yeah, I guess it’s either one works or you have to select and change the column name. Basically
195 00:21:17.910 ⇒ 00:21:20.512 Annie Yu: I actually, somehow,
196 00:21:26.970 ⇒ 00:21:31.870 Annie Yu: had a problem just uploading it. So I wrote.
197 00:21:36.010 ⇒ 00:21:38.069 Annie Yu: oh, not this one.
198 00:21:39.940 ⇒ 00:21:41.590 Uttam Kumaran: Yeah. If you click this, you’ll switch
199 00:21:42.670 ⇒ 00:21:46.570 Annie Yu: So you click here, yeah.
200 00:21:46.840 ⇒ 00:21:47.990 Uttam Kumaran: And then account.
201 00:21:49.520 ⇒ 00:21:50.700 Uttam Kumaran: Then you can switch
202 00:21:51.340 ⇒ 00:21:54.450 Annie Yu: Okay, cool.
203 00:21:55.340 ⇒ 00:22:03.369 Annie Yu: Yeah. I I created like a like, empty table. And then bring that data in
204 00:22:03.750 ⇒ 00:22:05.830 Uttam Kumaran: Yeah. But I guess what I’m saying is like
205 00:22:06.050 ⇒ 00:22:09.549 Uttam Kumaran: having column names with spaces like
206 00:22:09.900 ⇒ 00:22:12.250 Uttam Kumaran: you should just make everything underscore
207 00:22:12.660 ⇒ 00:22:13.620 Annie Yu: Yeah, right?
208 00:22:14.010 ⇒ 00:22:17.699 Annie Yu: Yeah, then, can I change? Can I just change it? Here?
209 00:22:17.700 ⇒ 00:22:18.310 Uttam Kumaran: Yeah.
210 00:22:19.180 ⇒ 00:22:25.820 Uttam Kumaran: But then you you may have. You may have to. You may have to reload the data, or
211 00:22:26.510 ⇒ 00:22:33.120 Uttam Kumaran: like, if you Google, if you Google like, how to alter, don’t play column names. Maybe you can run alters. I’m not sure
212 00:22:37.550 ⇒ 00:22:47.089 Annie Yu: I think I I think I make some change after loading the data. And then
213 00:22:47.980 ⇒ 00:22:49.579 Annie Yu: the data is still there.
214 00:22:50.450 ⇒ 00:22:53.710 Uttam Kumaran: Yeah. But you can, if you Google like, how to alter, take like.
215 00:22:53.930 ⇒ 00:22:58.185 Uttam Kumaran: I guess. Do you get what I mean? Like the column names are not great
216 00:22:58.990 ⇒ 00:23:00.350 Annie Yu: Yeah, I know.
217 00:23:01.060 ⇒ 00:23:06.450 Uttam Kumaran: Okay? So you can do alter. Just look up how to alter a column named Snowflake might get some.
218 00:23:11.310 ⇒ 00:23:12.220 Uttam Kumaran: Yeah.
219 00:23:13.770 ⇒ 00:23:20.659 Uttam Kumaran: so alter table. And then, if you just look up like yeah column action. So down here, there’s gonna be
220 00:23:21.665 ⇒ 00:23:25.929 Uttam Kumaran: rename column right right here
221 00:23:27.330 ⇒ 00:23:30.309 Uttam Kumaran: So you can alter the table and rename the columns if you want
222 00:23:40.320 ⇒ 00:23:43.640 Annie Yu: What would the syntax be like?
223 00:23:43.750 ⇒ 00:23:45.080 Annie Yu: The entire
224 00:24:07.880 ⇒ 00:24:10.905 Uttam Kumaran: This is also something you should probably just ask Chat gpt
225 00:24:11.840 ⇒ 00:24:14.890 Annie Yu: Okay. Yeah, I’m I’m I’m stuck
226 00:24:14.890 ⇒ 00:24:16.949 Uttam Kumaran: Well, why don’t you just ask chat? Gpt
227 00:24:17.580 ⇒ 00:24:18.340 Annie Yu: Okay.
228 00:24:27.720 ⇒ 00:24:36.190 Annie Yu: I think, can I? Actually, I I think I’m gonna change the name in the Csv, if that’s okay.
229 00:24:36.760 ⇒ 00:24:53.970 Uttam Kumaran: That’s fine. But I guess I want to share that like, you have to Google, your way out of these like I, it’s gonna be hard. I can give you all the answers but you should use. You should use chat gpt, for all of these questions like, you know, just immediately ask it. Do you have like the desk? You can install the desktop app? It’s pretty easy
230 00:24:54.550 ⇒ 00:24:56.330 Annie Yu: Yeah, okay.
231 00:24:56.330 ⇒ 00:24:58.120 Uttam Kumaran: Like you can just say, How do I?
232 00:24:58.320 ⇒ 00:25:01.079 Uttam Kumaran: Here’s my tape. Here’s my table. I want to
233 00:25:01.690 ⇒ 00:25:05.739 Uttam Kumaran: change all the column names in Snowflake to be underscore
234 00:25:06.510 ⇒ 00:25:09.719 Uttam Kumaran: right? But again, like this is where again, like, I can’t.
235 00:25:10.390 ⇒ 00:25:15.049 Uttam Kumaran: you have to sort of figure it out like it’s it’s like I can give you all the answers, but
236 00:25:15.200 ⇒ 00:25:20.000 Annie Yu: Yeah, okay, then I think I’m gonna go do that
237 00:25:20.190 ⇒ 00:25:23.260 Uttam Kumaran: Okay, just ping me. I’ll be on for a bit
238 00:25:23.260 ⇒ 00:25:24.040 Annie Yu: Okay.
239 00:25:24.820 ⇒ 00:25:30.090 Uttam Kumaran: Yeah, I think the biggest thing is like I I want. If I I want to get a screenshot of the dashboard that you make
240 00:25:30.090 ⇒ 00:25:30.650 Annie Yu: Yeah.
241 00:25:31.830 ⇒ 00:25:35.829 Uttam Kumaran: But then I think it looks like they currently the error here is that
242 00:25:35.960 ⇒ 00:25:38.219 Uttam Kumaran: some of these column types aren’t
243 00:25:38.500 ⇒ 00:25:44.019 Uttam Kumaran: like, for example, the column name here is like has a space. But then, in your models
244 00:25:44.160 ⇒ 00:25:45.860 Uttam Kumaran: I think you’re just selecting it.
245 00:25:46.120 ⇒ 00:25:47.190 Uttam Kumaran: An underscore
246 00:25:48.870 ⇒ 00:25:52.529 Uttam Kumaran: So you just have to make sure that the columns name match what you’re selecting
247 00:25:52.820 ⇒ 00:25:53.680 Annie Yu: Yeah.
248 00:25:53.680 ⇒ 00:25:54.260 Uttam Kumaran: Yeah.
249 00:25:54.720 ⇒ 00:25:57.090 Annie Yu: Okay, I’m gonna go try that.
250 00:25:57.090 ⇒ 00:25:58.979 Uttam Kumaran: Okay, try it out. Just ping me.
251 00:25:59.240 ⇒ 00:25:59.879 Annie Yu: All right.
252 00:26:00.200 ⇒ 00:26:01.849 Uttam Kumaran: Use. Chat. Gpt for stuff.
253 00:26:02.440 ⇒ 00:26:05.417 Annie Yu: Yeah, I I do have it. I just
254 00:26:07.430 ⇒ 00:26:08.409 Uttam Kumaran: It’ll be helpful
255 00:26:08.410 ⇒ 00:26:10.169 Annie Yu: A desk Desktop
256 00:26:11.030 ⇒ 00:26:14.839 Uttam Kumaran: Yeah, it’ll be helpful, Joe, if you have like how to do. How do I do this in Snowflake?
257 00:26:15.440 ⇒ 00:26:19.829 Uttam Kumaran: You know it’s a it should be pretty easy
258 00:26:19.830 ⇒ 00:26:20.779 Annie Yu: All right.
259 00:26:22.150 ⇒ 00:26:24.080 Uttam Kumaran: Okay, thank you. Let me know if you get stuck.
260 00:26:24.280 ⇒ 00:26:26.130 Uttam Kumaran: Yeah, thank you.