Meeting Title: Friday-Brainforge-Demos-&-Retro Date: 2024-05-10 Meeting participants: Uttam Kumaran, Agustin, Jakob Kagel, Patrick Trainer, Ryan Luke Daque
WEBVTT
1 00:00:15.320 ⇒ 00:00:16.100 What’s on.
2 00:00:16.830 ⇒ 00:00:17.460 Uttam Kumaran: A.
3 00:00:20.290 ⇒ 00:00:23.430 Jakob Kagel: Alright! How’s it going beyond? Can you hear me? Okay?
4 00:00:23.730 ⇒ 00:00:24.380 Uttam Kumaran: Yeah.
5 00:00:25.320 ⇒ 00:00:31.319 Jakob Kagel: Is there? Is there like any like music feedback in the back? I’m just at lunch. So I was one of my friends.
6 00:00:31.560 ⇒ 00:00:32.390 Uttam Kumaran: Not really good.
7 00:00:32.390 ⇒ 00:00:32.890 Patrick Trainer: Pretty good.
8 00:00:32.890 ⇒ 00:00:33.530 Jakob Kagel: So that
9 00:00:33.710 ⇒ 00:00:36.480 Jakob Kagel: alright cool sounds good sounds good.
10 00:00:38.080 ⇒ 00:00:43.400 Uttam Kumaran: Cool, I guess today maybe we could quickly run through like, stand up items.
11 00:00:43.520 ⇒ 00:00:50.921 Uttam Kumaran: And then I wanted to do a little bit of a demo. If people want to demo stuff we’ve worked on. And then
12 00:00:51.520 ⇒ 00:00:55.595 Uttam Kumaran: I could do a little retro about the week, basically, for without as much time as we have left.
13 00:00:57.377 ⇒ 00:00:59.219 Uttam Kumaran: I’m gonna share.
14 00:01:02.150 ⇒ 00:01:03.020 Uttam Kumaran: bush
15 00:01:07.070 ⇒ 00:01:10.390 Uttam Kumaran: cool so we look at stuff in review.
16 00:01:11.694 ⇒ 00:01:19.930 Uttam Kumaran: Jacob. So this meeting with Cody. I talked to Ben this morning. He basically is like slack Cody, and he’s like, start a channel with Cody in their slack.
17 00:01:20.090 ⇒ 00:01:21.250 Uttam Kumaran: So I’m gonna do that.
18 00:01:21.250 ⇒ 00:01:22.150 Jakob Kagel: Got it.
19 00:01:23.230 ⇒ 00:01:25.729 Uttam Kumaran: So the other thing is we have like.
20 00:01:26.070 ⇒ 00:01:30.530 Uttam Kumaran: So the other thing I wanted to share is like we have there’s like a slack connect.
21 00:01:30.610 ⇒ 00:01:32.700 Uttam Kumaran: and there’s like being in their channel.
22 00:01:33.310 ⇒ 00:01:40.599 Uttam Kumaran: I’m gonna try to get everything on slack connect, because I think I’m having a hard time switching between all the different channels.
23 00:01:40.730 ⇒ 00:01:46.370 Uttam Kumaran: So what I did is that we have a testing channel, Jacob, I invited myself.
24 00:01:47.391 ⇒ 00:01:51.320 Uttam Kumaran: And I mean they’re actually from our slack.
25 00:01:51.520 ⇒ 00:01:56.139 Uttam Kumaran: so I’ll probably do. The same thing is, I’ll invite your brain for Gmail. You’ll get a slack connect.
26 00:01:56.150 ⇒ 00:01:57.240 Uttam Kumaran: and that way
27 00:01:57.420 ⇒ 00:02:00.999 Uttam Kumaran: you can just have it here like you don’t have to keep going back and forth.
28 00:02:02.840 ⇒ 00:02:03.840 Jakob Kagel: Sounds good to me.
29 00:02:04.320 ⇒ 00:02:32.610 Uttam Kumaran: Cool. So that was just one thing. So I’ll start that I’m gonna start that slack channel with us, Cody and Ben, and then we can ask them for questions. I shared the refund stuff. I actually got a lot of I got a lot of interesting feedback from Ben, basically, also on like, why Tech and Florida buy different pumps. It’s a lot. It’s something to do. It’s also to do with the fact that in Texas a lot of people don’t have heaters.
30 00:02:32.630 ⇒ 00:02:39.330 Uttam Kumaran: So they basically just turn off the. But in Florida it gets cold. So they need heat pumps.
31 00:02:39.420 ⇒ 00:02:41.389 Uttam Kumaran: So they buy more heat pumps.
32 00:02:41.430 ⇒ 00:02:53.589 Uttam Kumaran: This is all things that we should basically like corroborate with data. But I got a lot of good anecdotal evidence. I’m gonna send you the blue, the Zoom Meeting section for that where we talked about that
33 00:02:53.790 ⇒ 00:02:55.600 Uttam Kumaran: and then he’s like, but he has also, like Cody.
34 00:02:55.600 ⇒ 00:02:56.600 Jakob Kagel: Sounds good.
35 00:02:58.500 ⇒ 00:03:01.629 Jakob Kagel: I mean, that’s basically what I saw to like when I
36 00:03:03.170 ⇒ 00:03:09.010 Jakob Kagel: went through and added, like the splits of like product class, like by state and whatnot. So.
37 00:03:09.020 ⇒ 00:03:11.879 Jakob Kagel: yeah, that’s exactly so as well.
38 00:03:14.251 ⇒ 00:03:17.370 Uttam Kumaran: Create s 3 bucket for netsuite. So I created, this
39 00:03:17.440 ⇒ 00:03:19.383 Uttam Kumaran: looks like we got
40 00:03:20.850 ⇒ 00:03:22.050 Uttam Kumaran: I think we got
41 00:03:22.110 ⇒ 00:03:23.529 Uttam Kumaran: whatever the
42 00:03:24.440 ⇒ 00:03:32.870 Uttam Kumaran: yeah, we got some files from them that I’m gonna that I’m gonna send to put into netsuite into S. 3, and then just bring into
43 00:03:33.817 ⇒ 00:03:36.319 Uttam Kumaran: Snowflake. So that should be pretty easy.
44 00:03:38.860 ⇒ 00:03:41.820 Uttam Kumaran: and then this is still blocked.
45 00:03:45.500 ⇒ 00:03:50.569 Uttam Kumaran: I’m probably gonna send a follow up on this august thing, cause I don’t know. They’re not really responding.
46 00:03:50.660 ⇒ 00:03:52.889 Uttam Kumaran: I told the client that we’re kind of waiting.
47 00:03:53.590 ⇒ 00:03:54.320 Agustin: Okay.
48 00:03:56.190 ⇒ 00:03:56.610 Uttam Kumaran: Yeah.
49 00:03:56.610 ⇒ 00:04:01.090 Agustin: Today we receive an email from a snowflake, business partner?
50 00:04:01.570 ⇒ 00:04:02.210 Uttam Kumaran: Yeah.
51 00:04:03.280 ⇒ 00:04:04.699 Agustin: Meet with him. Yeah.
52 00:04:05.060 ⇒ 00:04:09.952 Uttam Kumaran: I saw that. Yeah, I don’t know. I don’t really wanna meet with anybody about this but
53 00:04:10.240 ⇒ 00:04:11.940 Agustin: I can do it if you want, but
54 00:04:12.790 ⇒ 00:04:13.749 Agustin: I just stay.
55 00:04:13.750 ⇒ 00:04:17.550 Uttam Kumaran: We have. We have snowflake cortex. So like, what does he wanna talk about?
56 00:04:17.970 ⇒ 00:04:21.550 Agustin: Yeah, that’s right. But is it a available right now?
57 00:04:23.050 ⇒ 00:04:24.239 Uttam Kumaran: I’m pretty sure.
58 00:04:25.090 ⇒ 00:04:27.500 Agustin: Okay, I would try, yeah.
59 00:04:27.500 ⇒ 00:04:30.670 Patrick Trainer: Yeah, cortex is. Ga, now, I think that was their big
60 00:04:32.430 ⇒ 00:04:32.950 Uttam Kumaran: Yeah, well.
61 00:04:32.950 ⇒ 00:04:34.029 Patrick Trainer: Like the other day.
62 00:04:38.360 ⇒ 00:04:40.699 Uttam Kumaran: I think we I mean, we could see all this stuff.
63 00:04:43.720 ⇒ 00:04:47.309 Uttam Kumaran: I think there’s also another. Is there another? Is there a
64 00:04:49.370 ⇒ 00:04:56.958 Uttam Kumaran: okay? I don’t know there’s some other ones. But okay, I mean, we’ll just. I’ll I’ll follow up on the email. It’s not that urgent, though.
65 00:04:57.640 ⇒ 00:05:00.031 Uttam Kumaran: I guess. Pat, you go on
66 00:05:01.440 ⇒ 00:05:04.649 Patrick Trainer: Yeah, the storage integration stuff. So
67 00:05:04.820 ⇒ 00:05:09.089 Patrick Trainer: all of these, like, I mean, if you filter
68 00:05:09.340 ⇒ 00:05:15.270 Patrick Trainer: by storage integration just up there like a bunch of tickets are gonna pop, like in the
69 00:05:15.330 ⇒ 00:05:17.759 Patrick Trainer: filter thing up on the top.
70 00:05:18.950 ⇒ 00:05:20.980 Patrick Trainer: we can probably just type storage.
71 00:05:22.735 ⇒ 00:05:29.979 Patrick Trainer: All of those are going to be wrapped up into one Pr. And I’m just gonna drop in the script for it
72 00:05:30.010 ⇒ 00:05:42.899 Patrick Trainer: ultimately, though, it’s it’s blocked on Robert so we could move all these to blocked just to keep the status up, or we can keep it in progress. But like all the work
73 00:05:42.990 ⇒ 00:05:47.670 Patrick Trainer: is done it’s like everything’s out of my hands. At this point.
74 00:05:48.860 ⇒ 00:05:50.977 Uttam Kumaran: Okay, cool. Then I’m going to
75 00:05:52.380 ⇒ 00:05:55.179 Uttam Kumaran: But you haven’t created, though you created the role and stuff.
76 00:05:55.670 ⇒ 00:06:01.160 Patrick Trainer: Yeah, yeah, I created the role, added the grants. I’ve got the integration up
77 00:06:01.925 ⇒ 00:06:06.600 Patrick Trainer: the external stage. And then if we want to create
78 00:06:09.110 ⇒ 00:06:09.770 Patrick Trainer: tasks
79 00:06:09.970 ⇒ 00:06:13.989 Patrick Trainer: and whatnot to, or snow pipe like that can come. But the
80 00:06:14.556 ⇒ 00:06:20.150 Patrick Trainer: the last piece is just permissions on on the Stella side.
81 00:06:20.460 ⇒ 00:06:21.890 Patrick Trainer: and
82 00:06:21.960 ⇒ 00:06:23.320 Patrick Trainer: once they
83 00:06:23.400 ⇒ 00:06:27.960 Patrick Trainer: figure that out like it might be just like an IP allow list
84 00:06:28.510 ⇒ 00:06:31.750 Patrick Trainer: or something similar or something more complex. But like
85 00:06:32.170 ⇒ 00:06:34.869 Patrick Trainer: it’s it balls in there for it. Basically.
86 00:06:35.250 ⇒ 00:06:38.350 Uttam Kumaran: Okay, we just got a thing about meeting on Monday.
87 00:06:39.280 ⇒ 00:06:40.080 Uttam Kumaran: So.
88 00:06:40.080 ⇒ 00:06:40.980 Patrick Trainer: Yeah.
89 00:06:41.950 ⇒ 00:06:44.060 Patrick Trainer: I think that should work for me, too.
90 00:06:49.400 ⇒ 00:06:50.110 Uttam Kumaran: Great
91 00:06:52.263 ⇒ 00:06:53.959 Uttam Kumaran: Jacob, you wanna go.
92 00:06:53.960 ⇒ 00:06:58.949 Patrick Trainer: Oh, and then sorry we have 8 days left on Snowflake
93 00:06:59.100 ⇒ 00:07:00.959 Patrick Trainer: free trial.
94 00:07:01.040 ⇒ 00:07:02.550 Patrick Trainer: and then we also got like
95 00:07:03.000 ⇒ 00:07:08.950 Patrick Trainer: 400 $390 left to spend as well. So.
96 00:07:08.950 ⇒ 00:07:12.129 Uttam Kumaran: What happens after the trial is over. We just have to put a card down.
97 00:07:12.130 ⇒ 00:07:14.070 Patrick Trainer: I think you gotta put a card down. Yeah.
98 00:07:16.060 ⇒ 00:07:16.880 Uttam Kumaran: Okay.
99 00:07:19.160 ⇒ 00:07:21.489 Patrick Trainer: But yeah, yesterday was 9 days.
100 00:07:21.740 ⇒ 00:07:24.070 Patrick Trainer: So if my maths correctly.
101 00:07:24.760 ⇒ 00:07:25.809 Patrick Trainer: they’re correct.
102 00:07:26.230 ⇒ 00:07:27.660 Patrick Trainer: We have 8 days now.
103 00:07:28.390 ⇒ 00:07:29.510 Uttam Kumaran: Okay. Cool.
104 00:07:29.900 ⇒ 00:07:30.750 Patrick Trainer: 8 days.
105 00:07:35.580 ⇒ 00:07:36.610 Patrick Trainer: Okay.
106 00:07:36.610 ⇒ 00:07:37.290 Uttam Kumaran: Great.
107 00:07:37.530 ⇒ 00:07:39.826 Uttam Kumaran: I’ll we’ll let’s
108 00:07:41.880 ⇒ 00:07:42.630 Uttam Kumaran: Let’s
109 00:07:43.130 ⇒ 00:07:44.180 Uttam Kumaran: tee this up.
110 00:07:48.140 ⇒ 00:07:49.390 Patrick Trainer: I think there’s a
111 00:07:50.260 ⇒ 00:07:51.910 Patrick Trainer: yeah, yeah, that yeah.
112 00:07:52.000 ⇒ 00:07:53.200 Patrick Trainer: or 16.
113 00:08:01.550 ⇒ 00:08:02.205 Uttam Kumaran: Okay.
114 00:08:03.100 ⇒ 00:08:06.780 Uttam Kumaran: nice. Yeah. I’m also like confirming the 5 tran
115 00:08:08.690 ⇒ 00:08:09.460 Uttam Kumaran: usage.
116 00:08:14.740 ⇒ 00:08:18.409 Uttam Kumaran: I think I’m wait. It’s like one more day before it gives us, like a good usage
117 00:08:18.880 ⇒ 00:08:20.510 Uttam Kumaran: estimator of everything
118 00:08:23.070 ⇒ 00:08:23.645 Uttam Kumaran: the
119 00:08:25.290 ⇒ 00:08:27.930 Uttam Kumaran: full story connectors are a lot, though.
120 00:08:30.900 ⇒ 00:08:33.419 Uttam Kumaran: so we’ll figure out how much this ends up being
121 00:08:34.440 ⇒ 00:08:35.329 Uttam Kumaran: but great.
122 00:08:35.980 ⇒ 00:08:37.699 Uttam Kumaran: We also have 7 days in this.
123 00:08:38.659 ⇒ 00:08:39.700 Uttam Kumaran: Okay? Cool
124 00:08:40.924 ⇒ 00:08:42.750 Uttam Kumaran: Jacob, if you wanna go.
125 00:08:44.330 ⇒ 00:08:57.249 Jakob Kagel: Yeah, sure thing. So like we mentioned, like, with the Ab testing, had a meeting like with Tim yesterday. It was just like one additional sort of pricing test doing so.
126 00:08:57.300 ⇒ 00:09:01.899 Jakob Kagel: I’m meeting with the Intelligence people with Hannah on Monday.
127 00:09:02.320 ⇒ 00:09:05.479 Jakob Kagel: just to get all that set up, and we’ll get that up and running
128 00:09:05.870 ⇒ 00:09:07.169 Jakob Kagel: on the retail
129 00:09:08.590 ⇒ 00:09:11.539 Jakob Kagel: return refunds analysis. So
130 00:09:11.730 ⇒ 00:09:27.089 Jakob Kagel: all the stuff that I’ve added in now, I’ve added in the product class splits like for the different States. Texas, in Florida, product class splits for the different channels like Amazon, and shopify the month over month for those the average days for return.
131 00:09:27.090 ⇒ 00:09:43.679 Jakob Kagel: like month over month, and then also, like the distribution of the average days to return. So all that’s been added in now. Into the analysis. And yeah, I’ll definitely take a look at the reporting to see like whatever feedback they had on that
132 00:09:45.030 ⇒ 00:09:46.954 Jakob Kagel: sort of what we can
133 00:09:47.450 ⇒ 00:09:49.440 Jakob Kagel: like iterate on top of
134 00:09:50.000 ⇒ 00:09:57.666 Jakob Kagel: already. Have to make it better. And then you have the meeting this afternoon with plant on like the revenue forecasting tool.
135 00:09:58.820 ⇒ 00:10:02.810 Jakob Kagel: that’s at like 2 30, so I’ll be meeting with him as well.
136 00:10:03.677 ⇒ 00:10:06.600 Jakob Kagel: Think that’s it for me right now.
137 00:10:07.208 ⇒ 00:10:15.811 Jakob Kagel: Oh, I did. Yeah, Kim. I I yesterday I did go ahead and send over, like the Amazon addresses that we did have for the people that bought filters in the past.
138 00:10:16.090 ⇒ 00:10:25.610 Jakob Kagel: so I wanna add those over to her. And she was really understand. Like, I mean, of course, I just basically explained. You know, Amazon’s like redacted addresses.
139 00:10:26.930 ⇒ 00:10:29.763 Jakob Kagel: It’s not really that much that we can do there. But we
140 00:10:31.960 ⇒ 00:10:38.070 Jakob Kagel: but we have. So she she was appreciative. And yeah, went ahead and sent that over as well.
141 00:10:38.550 ⇒ 00:10:39.260 Uttam Kumaran: Okay.
142 00:10:39.980 ⇒ 00:10:43.184 Uttam Kumaran: okay, cool. The only other thing I had was,
143 00:10:45.310 ⇒ 00:10:48.169 Uttam Kumaran: can you push all of your evidence stuff to a Pr.
144 00:10:48.550 ⇒ 00:10:49.560 Uttam Kumaran: so we can get that.
145 00:10:49.560 ⇒ 00:10:50.950 Jakob Kagel: Yeah, same thing.
146 00:10:54.550 ⇒ 00:10:59.220 Uttam Kumaran: Yeah, just whenever that way we can have all that live for Cody to take a look at.
147 00:11:00.350 ⇒ 00:11:01.110 Jakob Kagel: But they.
148 00:11:01.640 ⇒ 00:11:02.240 Uttam Kumaran: Okay. Cool.
149 00:11:02.240 ⇒ 00:11:05.300 Jakob Kagel: Just published it. That should be good, you know.
150 00:11:06.520 ⇒ 00:11:07.400 Uttam Kumaran: Yeah, just
151 00:11:08.010 ⇒ 00:11:11.179 Uttam Kumaran: I guess I’ll probably see it in slack when the Pr is made.
152 00:11:11.590 ⇒ 00:11:12.330 Jakob Kagel: Yeah.
153 00:11:12.890 ⇒ 00:11:14.140 Uttam Kumaran: Oh, yeah, there it is. Okay.
154 00:11:16.569 ⇒ 00:11:17.249 Uttam Kumaran: Cool.
155 00:11:18.880 ⇒ 00:11:20.192 Uttam Kumaran: yeah, I think.
156 00:11:20.670 ⇒ 00:11:23.822 Uttam Kumaran: I’ll talk about next week at the end. I guess, Ryan. If you wanna go.
157 00:11:25.110 ⇒ 00:11:28.885 Ryan Luke Daque: Yeah, sure. My end. I think I finally got me
158 00:11:29.470 ⇒ 00:11:32.730 Ryan Luke Daque: Google ads and Facebook ads ready. So I
159 00:11:32.800 ⇒ 00:11:34.970 Ryan Luke Daque: just merge the Pr for that one.
160 00:11:35.080 ⇒ 00:11:37.620 Ryan Luke Daque: So yeah, we should be good moving.
161 00:11:37.620 ⇒ 00:11:38.559 Uttam Kumaran: Both of them.
162 00:11:38.810 ⇒ 00:11:40.049 Ryan Luke Daque: Yeah, both of them.
163 00:11:40.050 ⇒ 00:11:40.879 Uttam Kumaran: Oh, nice!
164 00:11:40.880 ⇒ 00:11:43.900 Ryan Luke Daque: Yeah, the Facebook one was a bit tricky because it was like
165 00:11:44.200 ⇒ 00:11:48.850 Ryan Luke Daque: in different tables. So you had to like join them somehow. Basically. So.
166 00:11:48.900 ⇒ 00:11:52.470 Ryan Luke Daque: But the Google ads, one was pretty straightforward, though. So yeah.
167 00:11:52.810 ⇒ 00:12:04.039 Ryan Luke Daque: I might need to clean up, though, the Snowflake custom reports that I like, I, I created multiple just to figure out. So yeah, I might need to delete some of those. And I’m also not sure like
168 00:12:04.570 ⇒ 00:12:14.810 Ryan Luke Daque: we I I did note, I did see, like 3 other custom reports, or 4 that maybe was created before. But I’m not sure if, like, we are using them. So
169 00:12:15.670 ⇒ 00:12:21.140 Uttam Kumaran: I would delete everything if we’re not. I don’t think we’re. I don’t share what we’re using, but I don’t think we’re using any of them.
170 00:12:21.330 ⇒ 00:12:23.150 Ryan Luke Daque: Okay. Sounds good. Yeah. Sure.
171 00:12:23.474 ⇒ 00:12:28.660 Uttam Kumaran: You’re you’re making that change in the Facebook ads table. Or is that change in the.
172 00:12:29.810 ⇒ 00:12:30.230 Ryan Luke Daque: More.
173 00:12:30.560 ⇒ 00:12:31.440 Ryan Luke Daque: It’s
174 00:12:31.890 ⇒ 00:12:37.619 Ryan Luke Daque: well, basically, the custom reports are automatically created by 5 grand. So they they are in
175 00:12:37.700 ⇒ 00:12:41.920 Ryan Luke Daque: the 5 Tran Google ad schema and the 5 Tran Facebook ad schema.
176 00:12:42.220 ⇒ 00:12:47.970 Ryan Luke Daque: So there are like different source tables, basically. And then I created, I updated Kim’s Weekly
177 00:12:48.240 ⇒ 00:12:49.750 Ryan Luke Daque: dashboard model
178 00:12:50.298 ⇒ 00:12:57.059 Ryan Luke Daque: in dbt, to incorporate those, basically. So instead of us getting it from the spreadsheets, which is the manual way.
179 00:12:57.571 ⇒ 00:13:00.619 Ryan Luke Daque: It’s getting directly from face 5 grand.
180 00:13:00.680 ⇒ 00:13:02.319 Ryan Luke Daque: Now, so yeah, that’s cool.
181 00:13:02.320 ⇒ 00:13:08.250 Uttam Kumaran: I guess my question would be if we can keep. If we can put that into the Facebook ads table
182 00:13:08.470 ⇒ 00:13:10.750 Uttam Kumaran: that way. It’s not just
183 00:13:11.370 ⇒ 00:13:16.439 Uttam Kumaran: I mean, you could do both. But I will also like I we’re gonna I wanna be able to use that for other.
184 00:13:16.660 ⇒ 00:13:18.768 Ryan Luke Daque: Yeah, that makes sense. Yeah.
185 00:13:19.190 ⇒ 00:13:23.939 Jakob Kagel: I I I agree with that. I mean, I think this is really important to have those tables high out.
186 00:13:23.940 ⇒ 00:13:24.260 Uttam Kumaran: Yeah, now.
187 00:13:24.260 ⇒ 00:13:27.700 Jakob Kagel: And we definitely don’t wanna run into in the future of.
188 00:13:28.660 ⇒ 00:13:38.699 Ryan Luke Daque: Yeah, I I can. I’ll I’ll do that. I can do that. So there’s the Facebook ads model as well as the Google ads, leave, do we have Google ads, Google analytics.
189 00:13:40.110 ⇒ 00:13:44.419 Uttam Kumaran: There is Google ads, one. Yeah. So like, for example.
190 00:13:44.920 ⇒ 00:13:45.860 Uttam Kumaran: this
191 00:13:47.270 ⇒ 00:13:49.944 Uttam Kumaran: we can just bring into
192 00:13:51.920 ⇒ 00:13:53.779 Uttam Kumaran: we can bring into here.
193 00:13:55.910 ⇒ 00:13:59.269 Ryan Luke Daque: Analytics. I believe Google adwords. Yeah.
194 00:13:59.630 ⇒ 00:14:00.330 Uttam Kumaran: Yeah.
195 00:14:02.580 ⇒ 00:14:03.230 Ryan Luke Daque: And okay.
196 00:14:04.140 ⇒ 00:14:04.900 Ryan Luke Daque: sure.
197 00:14:05.080 ⇒ 00:14:07.309 Uttam Kumaran: Do you have? Do you have that on a date.
198 00:14:07.660 ⇒ 00:14:10.210 Ryan Luke Daque: Yep, it’s on. It’s a it’s by date.
199 00:14:10.720 ⇒ 00:14:12.120 Uttam Kumaran: Date and campaign.
200 00:14:12.590 ⇒ 00:14:13.990 Ryan Luke Daque: And campaigners.
201 00:14:14.760 ⇒ 00:14:17.310 Ryan Luke Daque: Campaign name. There’s campaign. Id.
202 00:14:17.520 ⇒ 00:14:18.319 Ryan Luke Daque: Okay, the top.
203 00:14:18.320 ⇒ 00:14:21.099 Uttam Kumaran: The thing here is we have. This goes down to the add level.
204 00:14:23.010 ⇒ 00:14:24.410 Ryan Luke Daque: In
205 00:14:24.430 ⇒ 00:14:27.749 Ryan Luke Daque: which is more granular, the campaign or the Ad. I.
206 00:14:28.271 ⇒ 00:14:31.920 Uttam Kumaran: It’s goes, it goes. Add set campaign.
207 00:14:32.870 ⇒ 00:14:37.640 Ryan Luke Daque: So the most granular is the campaign or the add the ad gotcha.
208 00:14:37.800 ⇒ 00:14:42.400 Ryan Luke Daque: Okay, yeah, I think that should be fine. Let me just double check, because I don’t think I.
209 00:14:43.510 ⇒ 00:14:45.040 Uttam Kumaran: Brought it into Custom report.
210 00:14:45.760 ⇒ 00:14:51.399 Ryan Luke Daque: Yeah, like the add Id. But I think in Facebook there is add Id.
211 00:14:52.480 ⇒ 00:14:53.840 Ryan Luke Daque: but yeah, Google.
212 00:14:53.840 ⇒ 00:14:55.880 Uttam Kumaran: If we get to the Add, I date
213 00:14:56.410 ⇒ 00:14:58.100 Uttam Kumaran: campaign ad Id.
214 00:14:58.230 ⇒ 00:15:01.790 Uttam Kumaran: I mean you’ll you can see all the other fields here. I’ll just. I’ll send it to you.
215 00:15:01.790 ⇒ 00:15:03.660 Ryan Luke Daque: Yeah, yeah, add.
216 00:15:04.725 ⇒ 00:15:05.350 Ryan Luke Daque: stuff.
217 00:15:07.660 ⇒ 00:15:13.589 Uttam Kumaran: Whatever we I mean. If it’s gonna take another few days, don’t worry about it. Let’s just get whatever we need for Kim right now. But then.
218 00:15:13.590 ⇒ 00:15:14.380 Ryan Luke Daque: Sure.
219 00:15:14.380 ⇒ 00:15:15.830 Uttam Kumaran: And create a backlog for it.
220 00:15:16.320 ⇒ 00:15:17.770 Ryan Luke Daque: Sure. Yeah, I’ll.
221 00:15:18.900 ⇒ 00:15:21.360 Uttam Kumaran: So just so you can get past it.
222 00:15:21.570 ⇒ 00:15:22.260 Ryan Luke Daque: Sure.
223 00:15:25.360 ⇒ 00:15:26.420 Uttam Kumaran: This ticket.
224 00:15:29.510 ⇒ 00:15:30.400 Uttam Kumaran: Okay.
225 00:15:34.840 ⇒ 00:15:39.179 Agustin: I think sorry. I think I should create some tickets for myself or
226 00:15:40.115 ⇒ 00:15:40.850 Agustin: because
227 00:15:40.880 ⇒ 00:15:43.140 Agustin: I don’t. I don’t see any. But
228 00:15:43.570 ⇒ 00:15:46.299 Agustin: yeah, I think I have some stuff to
229 00:15:46.930 ⇒ 00:15:48.549 Agustin: priority. Yeah, religious.
230 00:15:48.820 ⇒ 00:15:50.750 Uttam Kumaran: Yeah, there’s some some follow ups.
231 00:15:51.447 ⇒ 00:15:54.419 Uttam Kumaran: I guess. Ryan, is there anything else you’re working on?
232 00:15:54.790 ⇒ 00:15:58.129 Ryan Luke Daque: Not at the moment. Just cleaning up the
233 00:15:58.730 ⇒ 00:16:00.219 Ryan Luke Daque: like schemas and stuff.
234 00:16:00.390 ⇒ 00:16:01.920 Ryan Luke Daque: Okay, I go ahead. Okay, yeah.
235 00:16:03.806 ⇒ 00:16:11.169 Uttam Kumaran: Yeah, we can talk about some of the stuff for real coming up and then for Augustine. So yeah, this promised thing is blocked.
236 00:16:11.593 ⇒ 00:16:15.590 Uttam Kumaran: We have a couple of things we wanna do on the
237 00:16:15.870 ⇒ 00:16:23.019 Uttam Kumaran: on the Zendesk side, Augustine. So I’m gonna make a ticket for the Zendesk AI stuff we wanna do.
238 00:16:24.930 ⇒ 00:16:25.720 Uttam Kumaran: Okay.
239 00:16:27.920 ⇒ 00:16:37.975 Uttam Kumaran: alright. So basically, what we guys we’re gonna do is like, actually take all the response back and forth and categorize them into a refund reason or a ticket reason, basically. So
240 00:16:39.280 ⇒ 00:16:40.030 Uttam Kumaran: that’d be very useful.
241 00:16:41.820 ⇒ 00:16:43.159 Uttam Kumaran: So we’re gonna
242 00:16:43.190 ⇒ 00:16:45.049 Uttam Kumaran: we’re gonna do that next week.
243 00:16:47.660 ⇒ 00:16:52.291 Uttam Kumaran: I told that to Ben. And he was like, yeah, like, fuck. Yeah, let’s do that.
244 00:16:53.620 ⇒ 00:16:54.933 Uttam Kumaran: And then
245 00:16:55.780 ⇒ 00:17:00.707 Uttam Kumaran: The other thing Augustine is, we have much a bunch of other tasks for
246 00:17:01.320 ⇒ 00:17:02.790 Uttam Kumaran: the asset link
247 00:17:03.520 ⇒ 00:17:04.440 Uttam Kumaran: AI stuff.
248 00:17:07.680 ⇒ 00:17:10.362 Uttam Kumaran: so I’m just gonna create a ticket for that
249 00:17:17.410 ⇒ 00:17:20.489 Uttam Kumaran: august things is becoming an AI engineer. Now, which is great.
250 00:17:21.500 ⇒ 00:17:22.150 Agustin: Yeah.
251 00:17:23.510 ⇒ 00:17:26.599 Uttam Kumaran: You’re having the most. You’re unfortunately having the most fun out of everybody.
252 00:17:26.630 ⇒ 00:17:27.900 Uttam Kumaran: That’s the like.
253 00:17:27.900 ⇒ 00:17:30.920 Ryan Luke Daque: The blue ocean, basically like nobody like, there’s only.
254 00:17:30.920 ⇒ 00:17:31.260 Patrick Trainer: Right.
255 00:17:31.260 ⇒ 00:17:32.930 Ryan Luke Daque: 12 people who knows?
256 00:17:32.930 ⇒ 00:17:35.460 Agustin: I’m using the newest features.
257 00:17:35.740 ⇒ 00:17:36.460 Uttam Kumaran: Yeah.
258 00:17:37.460 ⇒ 00:17:38.530 Uttam Kumaran: so
259 00:17:38.640 ⇒ 00:17:46.734 Uttam Kumaran: have fun. Have fun while you, while you’re working on it. We’ll be here doing data, boring data. Shit
260 00:17:48.028 ⇒ 00:17:55.490 Uttam Kumaran: cool. So let’s let’s talk about this. I just had 2 meetings on this today, Augustine, so I need a little bit more time
261 00:17:55.600 ⇒ 00:17:59.049 Uttam Kumaran: to fill all this stuff with info, but I think either
262 00:17:59.537 ⇒ 00:18:02.390 Uttam Kumaran: we talk later today or for Monday.
263 00:18:03.169 ⇒ 00:18:06.869 Uttam Kumaran: But these should both be plenty of stuff to do.
264 00:18:07.930 ⇒ 00:18:10.530 Agustin: Okay, great. That’s great.
265 00:18:10.887 ⇒ 00:18:13.740 Agustin: I have a question regarding the website. The the.
266 00:18:13.740 ⇒ 00:18:14.220 Uttam Kumaran: Yeah.
267 00:18:14.220 ⇒ 00:18:15.840 Agustin: An example of our side.
268 00:18:15.900 ⇒ 00:18:17.809 Agustin: You said that
269 00:18:17.900 ⇒ 00:18:22.570 Agustin: you want to that the format you suggested, which is the client that
270 00:18:22.940 ⇒ 00:18:25.220 Agustin: brainfurst AI slash
271 00:18:25.600 ⇒ 00:18:27.070 Agustin: evidence right.
272 00:18:28.070 ⇒ 00:18:29.120 Uttam Kumaran: Elementary.
273 00:18:30.120 ⇒ 00:18:30.960 Agustin: Oh! Oh!
274 00:18:30.960 ⇒ 00:18:32.349 Uttam Kumaran: Yeah, for elementary. Right?
275 00:18:33.590 ⇒ 00:18:34.379 Uttam Kumaran: I thought you said.
276 00:18:34.380 ⇒ 00:18:37.910 Agustin: So evidence. But yeah, it’s so the same. I mean.
277 00:18:40.470 ⇒ 00:18:43.000 Uttam Kumaran: So what I what I was saying is like this.
278 00:18:43.280 ⇒ 00:18:49.239 Uttam Kumaran: Well, let me. I let me. My one password doesn’t work on this because I think it’s the Cloud Walk, or whatever
279 00:18:53.130 ⇒ 00:18:55.990 Ryan Luke Daque: You have to like manually copy and paste it from
280 00:18:56.650 ⇒ 00:18:59.219 Ryan Luke Daque: one password, which is, yeah.
281 00:18:59.680 ⇒ 00:19:02.569 Uttam Kumaran: So you see how this redirects to
282 00:19:03.610 ⇒ 00:19:05.520 Uttam Kumaran: brain Forge AI.
283 00:19:06.040 ⇒ 00:19:06.810 Agustin: Yeah.
284 00:19:06.810 ⇒ 00:19:08.480 Uttam Kumaran: Oh, but it goes to this.
285 00:19:09.530 ⇒ 00:19:13.539 Uttam Kumaran: Can can we make this Brainforge? AI slash elementary?
286 00:19:13.900 ⇒ 00:19:16.960 Uttam Kumaran: Sorry. This is such like a net? I don’t. It’s just like whatever.
287 00:19:16.960 ⇒ 00:19:17.730 Patrick Trainer: Right.
288 00:19:18.060 ⇒ 00:19:22.950 Uttam Kumaran: But kind of like while we’re in there making these changes cause we’re gonna scale this to every client.
289 00:19:23.450 ⇒ 00:19:30.159 Agustin: Sorry can I ask you, or can you please put the window a bit lower? Not sure why I cannot see the URL.
290 00:19:30.160 ⇒ 00:19:31.020 Uttam Kumaran: Any good.
291 00:19:33.980 ⇒ 00:19:35.840 Agustin: Oh, thank you! Oh, sorry!
292 00:19:35.840 ⇒ 00:19:37.659 Uttam Kumaran: This is the URL right now.
293 00:19:38.390 ⇒ 00:19:39.910 Agustin: Yeah, yeah, yeah, yeah.
294 00:19:39.910 ⇒ 00:19:40.769 Uttam Kumaran: Great if it’s like.
295 00:19:41.460 ⇒ 00:19:43.909 Uttam Kumaran: or if it’s good. Sorry elementary.
296 00:19:45.150 ⇒ 00:19:47.910 Agustin: Inventory. Okay? Yeah, we’ll try to do that.
297 00:19:48.330 ⇒ 00:19:52.540 Uttam Kumaran: I have a feeling we’re gonna have people go to multiple things
298 00:19:52.730 ⇒ 00:19:53.850 Uttam Kumaran: per client.
299 00:19:55.640 ⇒ 00:19:58.340 Uttam Kumaran: So kind of want to section it off.
300 00:20:00.280 ⇒ 00:20:05.069 Agustin: Okay, yeah, I will. I will try to do that. I do not want to spend too much time on that.
301 00:20:05.070 ⇒ 00:20:10.399 Uttam Kumaran: Yeah, if it’s if it’s if it’s what if you have just cause while you’re in there doing all this stuff.
302 00:20:10.490 ⇒ 00:20:12.519 Uttam Kumaran: it’d be great just to close it all out.
303 00:20:13.125 ⇒ 00:20:16.050 Uttam Kumaran: Because I wanna I wanna immediately bring it to asset Link.
304 00:20:16.710 ⇒ 00:20:18.539 Uttam Kumaran: The same functionality.
305 00:20:19.460 ⇒ 00:20:25.710 Patrick Trainer: Click, click into the lineage. Real quick. I haven’t. I haven’t played. I was trying to play with this on my phone.
306 00:20:26.510 ⇒ 00:20:29.999 Patrick Trainer: but I couldn’t. But this is sit. This is tight.
307 00:20:31.150 ⇒ 00:20:36.975 Uttam Kumaran: It’s good. I wish you could see the the the sequel here, though.
308 00:20:37.340 ⇒ 00:20:39.120 Patrick Trainer: Can you go go into node info.
309 00:20:39.120 ⇒ 00:20:40.260 Ryan Luke Daque: I think.
310 00:20:40.260 ⇒ 00:20:41.940 Jakob Kagel: Yeah, I agree with some of those.
311 00:20:42.750 ⇒ 00:20:43.850 Ryan Luke Daque: Yeah, I I can’t.
312 00:20:48.390 ⇒ 00:20:50.580 Ryan Luke Daque: I think there’s a way I can’t remember that I’m.
313 00:20:51.100 ⇒ 00:20:51.520 Uttam Kumaran: And then
314 00:20:51.730 ⇒ 00:20:52.830 Ryan Luke Daque: The sequel.
315 00:20:53.040 ⇒ 00:20:57.951 Uttam Kumaran: Oh, okay, yeah, that would be great. And then the other thing I had a question about
316 00:20:59.040 ⇒ 00:21:04.280 Uttam Kumaran: is that when the job fails this doesn’t run. But this can this alert us of job failures.
317 00:21:06.330 ⇒ 00:21:07.569 Patrick Trainer: Should be able to.
318 00:21:07.900 ⇒ 00:21:08.440 Ryan Luke Daque: Hmm.
319 00:21:09.270 ⇒ 00:21:12.369 Uttam Kumaran: Or is this like? What like is it supposed to do that?
320 00:21:13.070 ⇒ 00:21:13.750 Uttam Kumaran: It.
321 00:21:14.740 ⇒ 00:21:16.280 Ryan Luke Daque: Good.
322 00:21:17.690 ⇒ 00:21:18.550 Ryan Luke Daque: weighing.
323 00:21:19.080 ⇒ 00:21:21.119 Uttam Kumaran: You know what I mean, because this
324 00:21:21.880 ⇒ 00:21:22.660 Uttam Kumaran: of
325 00:21:23.130 ⇒ 00:21:25.735 Uttam Kumaran: this is not all I wanted.
326 00:21:26.170 ⇒ 00:21:27.609 Patrick Trainer: Elementary school
327 00:21:28.770 ⇒ 00:21:30.196 Patrick Trainer: teaching sucks.
328 00:21:37.010 ⇒ 00:21:38.331 Uttam Kumaran: Do you know what I mean? Like
329 00:21:38.820 ⇒ 00:21:42.150 Ryan Luke Daque: Yeah, like the recent one, the failure that you had.
330 00:21:42.150 ⇒ 00:21:44.380 Uttam Kumaran: How does this tell me? Yeah.
331 00:21:45.910 ⇒ 00:21:46.660 Ryan Luke Daque: I think.
332 00:21:48.840 ⇒ 00:21:51.829 Ryan Luke Daque: I wonder if it shows them in the next run, though?
333 00:21:52.540 ⇒ 00:21:53.630 Ryan Luke Daque: Does that
334 00:21:53.820 ⇒ 00:21:55.090 Ryan Luke Daque: failure never.
335 00:21:58.860 ⇒ 00:22:01.730 Uttam Kumaran: Well, yeah, like it. Almost like.
336 00:22:03.140 ⇒ 00:22:07.630 Patrick Trainer: I’m thinking of something like similar to air flow like when you have that
337 00:22:07.880 ⇒ 00:22:10.900 Patrick Trainer: an immediate job. Failure, like everything, turns red.
338 00:22:12.200 ⇒ 00:22:13.150 Ryan Luke Daque: Yeah.
339 00:22:13.150 ⇒ 00:22:18.219 Uttam Kumaran: Or I’m like, if we take a look at that job today that that fail.
340 00:22:19.700 ⇒ 00:22:21.089 Ryan Luke Daque: Yeah. That was Walmart.
341 00:22:22.380 ⇒ 00:22:24.100 Uttam Kumaran: Let’s take a look at this example.
342 00:22:24.600 ⇒ 00:22:25.940 Uttam Kumaran: So
343 00:22:26.420 ⇒ 00:22:28.219 Uttam Kumaran: Dbc Build failed.
344 00:22:28.540 ⇒ 00:22:31.769 Uttam Kumaran: There’s a Walmart test that field. But then elementary doesn’t run.
345 00:22:32.490 ⇒ 00:22:33.590 Ryan Luke Daque: Right.
346 00:22:33.590 ⇒ 00:22:34.200 Patrick Trainer: We so.
347 00:22:34.200 ⇒ 00:22:35.470 Uttam Kumaran: So how can we.
348 00:22:35.470 ⇒ 00:22:39.539 Patrick Trainer: We can. Yeah, we can add, in the in the workflow
349 00:22:39.690 ⇒ 00:22:43.830 Patrick Trainer: to continue on failure like it does like you don’t.
350 00:22:43.830 ⇒ 00:22:44.230 Ryan Luke Daque: It does-.
351 00:22:44.230 ⇒ 00:22:46.029 Patrick Trainer: Have to fail the entire job.
352 00:22:46.030 ⇒ 00:22:47.460 Uttam Kumaran: Yeah, I wanna do that.
353 00:22:48.575 ⇒ 00:22:48.900 Patrick Trainer: Yeah.
354 00:22:48.900 ⇒ 00:22:54.270 Ryan Luke Daque: Yeah, cause, currently, it’s like, serial, right? It waits for to finish. Yeah.
355 00:22:55.040 ⇒ 00:22:59.369 Patrick Trainer: If you like. I can take care of that. I’ve got some time to do that. If you want.
356 00:23:00.190 ⇒ 00:23:01.899 Uttam Kumaran: Yeah, I’m just gonna put that in here
357 00:23:33.910 ⇒ 00:23:35.349 Uttam Kumaran: that didn’t really work.
358 00:23:45.560 ⇒ 00:23:49.279 Uttam Kumaran: Okay, yeah, that’d be great. I think it uses it to probably continue so.
359 00:23:49.610 ⇒ 00:23:51.229 Patrick Trainer: Yeah, I think that’s the key.
360 00:23:53.760 ⇒ 00:24:03.561 Uttam Kumaran: Okay, I guess I’ll talk a little bit about next week, and I know August, and you probably have to drop. So I’ll just talk a little bit about next week, but then we’ll probably still do some Demos.
361 00:24:04.040 ⇒ 00:24:05.580 Agustin: But 5 min. Okay.
362 00:24:06.183 ⇒ 00:24:27.710 Uttam Kumaran: So so for next week the big things are gonna be this AI work. So we have 2 AI things we’re working on the Zendesk AI for pull parts. And we’re also working on an asset link AI Asset link. They’re trying to use AI in their product on our snowflake data like the snowflake data, we’re managing basically to do things like, tell me about this user. It then
363 00:24:27.730 ⇒ 00:24:34.749 Uttam Kumaran: is able to go into the database and find that user record and then provide them with all that. So we’ll be working on those things.
364 00:24:35.129 ⇒ 00:24:41.420 Uttam Kumaran: Ryan, the big stuff for next week for us to link to is also getting them up to speed on real.
365 00:24:41.811 ⇒ 00:24:50.169 Uttam Kumaran: So I basically want their real implementation to be like super clean with and basically start to move everything from light dash to real for them.
366 00:24:50.916 ⇒ 00:24:51.970 Uttam Kumaran: So that
367 00:24:52.070 ⇒ 00:24:55.150 Uttam Kumaran: would be ideal. That’s gonna be the big task.
368 00:24:55.925 ⇒ 00:24:57.469 Uttam Kumaran: Next next week
369 00:24:57.650 ⇒ 00:25:04.695 Uttam Kumaran: for pool parts. We’re gonna hopefully be able to have the intelligence test running and the
370 00:25:05.790 ⇒ 00:25:07.529 Uttam Kumaran: meeting about refunds.
371 00:25:08.034 ⇒ 00:25:19.819 Uttam Kumaran: And that should kick off hopefully a couple of more things. We do have some future analysis, wanna do. But I wanna close out refunds while we’re on the subject with them before moving on to anything else. So.
372 00:25:20.242 ⇒ 00:25:23.200 Jakob Kagel: Sounds good. Yeah, sure I may not.
373 00:25:23.640 ⇒ 00:25:25.189 Jakob Kagel: Obviously we can always do.
374 00:25:25.240 ⇒ 00:25:37.309 Jakob Kagel: But it’s good executives. We’re not just like, always kind of doing these like little small, you know, piecemeal balls and kind of like you said like, close it out. At least, that’s what it’s gonna be.
375 00:25:37.900 ⇒ 00:25:55.969 Uttam Kumaran: Yeah. And I, wanna kind of just go down every rabbit hole and refunds, because this is the first time that we can. Probably we probably ask all these questions to them. So let’s just like chase it for a while until we’re kind of hit an end. And hopefully they can make some decisions. If they need to, so that’ll be great. There are.
376 00:25:56.230 ⇒ 00:26:06.784 Uttam Kumaran: There’s one additional client that I am scoping that hasn’t signed yet, but has given me some information, and like kind of putting together proposal.
377 00:26:08.090 ⇒ 00:26:12.889 Uttam Kumaran: I will actually probably schedule time for Monday to review with you guys, I was gonna
378 00:26:13.150 ⇒ 00:26:16.200 Uttam Kumaran: try and do today. But it’s probably a lot.
379 00:26:17.646 ⇒ 00:26:22.110 Uttam Kumaran: it’s this company called Curry. They’re actually based in Austin
380 00:26:22.555 ⇒ 00:26:25.120 Uttam Kumaran: the guy I’m meeting was actually based in Austin.
381 00:26:25.270 ⇒ 00:26:26.185 Uttam Kumaran: Jacob,
382 00:26:27.330 ⇒ 00:26:28.430 Uttam Kumaran: and bye.
383 00:26:28.530 ⇒ 00:26:32.009 Uttam Kumaran: they’re a logistics platform for distributors. Basically.
384 00:26:32.499 ⇒ 00:26:36.910 Uttam Kumaran: You you can set use them for like last mile distribution of like
385 00:26:37.020 ⇒ 00:26:41.550 Uttam Kumaran: of like construction related goods, home development related goods.
386 00:26:41.885 ⇒ 00:26:45.170 Uttam Kumaran: And they have a bunch. They have a software that’s doing that. They need some help
387 00:26:45.390 ⇒ 00:26:47.999 Uttam Kumaran: integrating some erp data.
388 00:26:48.080 ⇒ 00:26:50.560 Uttam Kumaran: creating some like SQL logic.
389 00:26:50.850 ⇒ 00:26:54.260 Uttam Kumaran: It’s like a kind of specific problem. So I’ll share more about that.
390 00:26:55.960 ⇒ 00:26:58.969 Uttam Kumaran: and then, yeah, I think that’s the big stuff for
391 00:26:59.665 ⇒ 00:27:05.550 Uttam Kumaran: next? Oh, the last thing is, yeah. We should be able to meet with Dan Patrick and get all that stuff from him. So cool.
392 00:27:06.740 ⇒ 00:27:07.540 Jakob Kagel: So good.
393 00:27:08.070 ⇒ 00:27:08.920 Uttam Kumaran: Cool.
394 00:27:09.800 ⇒ 00:27:14.850 Uttam Kumaran: I just wanted to do a little bit of like Demos
395 00:27:14.880 ⇒ 00:27:16.999 Uttam Kumaran: does everybody have like 10 min.
396 00:27:18.460 ⇒ 00:27:19.300 Jakob Kagel: Yeah, for sure.
397 00:27:19.470 ⇒ 00:27:20.940 Jakob Kagel: Okay. Great. That knows it.
398 00:27:21.470 ⇒ 00:27:23.329 Uttam Kumaran: So I guess the first thing.
399 00:27:23.470 ⇒ 00:27:27.510 Agustin: I don’t sorry. See I I I come to.
400 00:27:27.690 ⇒ 00:27:28.769 Uttam Kumaran: Oh, all good, all good.
401 00:27:29.500 ⇒ 00:27:30.200 Uttam Kumaran: Okay.
402 00:27:31.138 ⇒ 00:27:36.230 Uttam Kumaran: This first thing I wanted to share was a bit about on my end. I’m working on the shipping
403 00:27:36.330 ⇒ 00:27:39.354 Uttam Kumaran: data issue. Basically,
404 00:27:41.690 ⇒ 00:27:44.892 Uttam Kumaran: basically, the problem we’ve been having before.
405 00:27:45.370 ⇒ 00:27:49.820 Uttam Kumaran: is that our shipping data is all coming from the All orders table.
406 00:27:50.589 ⇒ 00:27:53.940 Uttam Kumaran: and what that kind of looks like is
407 00:27:56.820 ⇒ 00:27:57.910 Uttam Kumaran: -Oh!
408 00:28:00.860 ⇒ 00:28:06.180 Uttam Kumaran: All orders is just like a beefy table, basically not this one.
409 00:28:07.010 ⇒ 00:28:08.330 Uttam Kumaran: All.
410 00:28:17.960 ⇒ 00:28:24.849 Uttam Kumaran: So all orders is like taking everything from shopify Amazon Walmart combining it.
411 00:28:25.020 ⇒ 00:28:31.930 Uttam Kumaran: then bringing in some Zip code cleaning, then bringing in all the shipment data from ship station
412 00:28:32.535 ⇒ 00:28:36.549 Uttam Kumaran: and then kind of like creating one massive table.
413 00:28:37.047 ⇒ 00:28:43.479 Uttam Kumaran: The problem with this table is that it contains both information about the orders and information about shipping.
414 00:28:43.925 ⇒ 00:28:45.650 Uttam Kumaran: The problem is is that
415 00:28:46.030 ⇒ 00:28:49.979 Uttam Kumaran: like a single order may have multiple shipments associated with it.
416 00:28:50.030 ⇒ 00:28:56.599 Uttam Kumaran: because if they order like a pump and like 10 brushes, those come on separate shipments
417 00:28:56.680 ⇒ 00:28:58.040 Uttam Kumaran: logically.
418 00:28:58.140 ⇒ 00:29:03.879 Uttam Kumaran: this is bad, because if we’re talking about shipments and we’d see dupes. So we there are some dips happening on
419 00:29:04.010 ⇒ 00:29:05.669 Uttam Kumaran: the shipments themselves.
420 00:29:05.720 ⇒ 00:29:21.140 Uttam Kumaran: We get a lot of questions about shipments. And we have a lot of questions that we’re gonna answer as we open up more 3 Tls as pull parts opens up more third party, like logistic providers to basically do shipments. So the kind of the goal here was to create a shipments table.
421 00:29:21.160 ⇒ 00:29:37.010 Uttam Kumaran: basically taking out information like the shipping platform, the order id, but also where it’s going. And then number shipments and attributes about the shipment like, who’s shipping it? And the shipment dimensions, getting rid of shit about refunds.
422 00:29:37.100 ⇒ 00:29:41.500 Uttam Kumaran: discounts all that stuff and creating like one holistic shipment stable.
423 00:29:42.010 ⇒ 00:29:44.458 Uttam Kumaran: The complication here is
424 00:29:47.300 ⇒ 00:29:49.229 Uttam Kumaran: The complication here is that
425 00:29:49.460 ⇒ 00:29:56.919 Uttam Kumaran: any an order from Amazon or shopify may or may not go through one or many shipment providers.
426 00:29:57.690 ⇒ 00:30:03.690 Uttam Kumaran: So, for example we we use. Unisunus is shipping out of Florida.
427 00:30:03.710 ⇒ 00:30:07.929 Uttam Kumaran: We use the Yap Hank which is coming shipping out of New York.
428 00:30:08.000 ⇒ 00:30:13.369 Uttam Kumaran: It’s their warehouse in New York. We’re shipping from both shopify Walmart and Amazon.
429 00:30:13.943 ⇒ 00:30:17.750 Uttam Kumaran: And then ship station manages, creating shipments
430 00:30:17.960 ⇒ 00:30:18.955 Uttam Kumaran: for
431 00:30:20.720 ⇒ 00:30:30.990 Uttam Kumaran: ups and Fedex and Ltl, so as you can see there’s like multiple different chains. An order comes in a ship station records created.
432 00:30:31.130 ⇒ 00:30:42.173 Uttam Kumaran: If it’s unus, it’s not created. So there’s one bifurcation there. Ship station, then can go to one or many different service codes. You can go to Ups Fedex, Ltl.
433 00:30:42.730 ⇒ 00:30:55.110 Uttam Kumaran: so basically, we’re trying to re-architect this starting from the shipments themselves, then joining in the Amazon and shopify information there. So the code I’ve been working.
434 00:30:55.110 ⇒ 00:30:55.910 Jakob Kagel: And.
435 00:30:57.630 ⇒ 00:30:58.820 Uttam Kumaran: kind of
436 00:31:00.100 ⇒ 00:31:02.356 Uttam Kumaran: in the yesterday was
437 00:31:03.975 ⇒ 00:31:06.470 Uttam Kumaran: gonna make this a bit smaller.
438 00:31:07.600 ⇒ 00:31:12.750 Jakob Kagel: Can you do you? Can you drop a link to that dashboard like in the chat? For in slack? Maybe.
439 00:31:12.950 ⇒ 00:31:13.750 Uttam Kumaran: Yes.
440 00:31:20.875 ⇒ 00:31:21.320 Jakob Kagel: Though.
441 00:31:21.900 ⇒ 00:31:27.929 Jakob Kagel: Yeah, I mean, do we have any idea? Basically, like how many duplicates like we have in our orders.
442 00:31:28.800 ⇒ 00:31:30.899 Uttam Kumaran: We don’t have duplicates, and all like.
443 00:31:30.900 ⇒ 00:31:33.130 Jakob Kagel: Or is that something we still have to figure.
444 00:31:33.390 ⇒ 00:31:38.060 Uttam Kumaran: No, I I just. I would just be careful with, like what is duplicated. So
445 00:31:38.430 ⇒ 00:31:44.060 Uttam Kumaran: a single order can have multiple shipments. So there are some orders with multiple shipments
446 00:31:44.280 ⇒ 00:31:45.360 Uttam Kumaran: meaning
447 00:31:45.430 ⇒ 00:31:50.659 Uttam Kumaran: meaning, it’s hard for me to get a sense of like how many distinct shipments there are.
448 00:31:52.080 ⇒ 00:31:54.070 Uttam Kumaran: so while we were like, but we don’t have.
449 00:31:54.594 ⇒ 00:31:56.690 Jakob Kagel: Duplicate like order values.
450 00:31:56.690 ⇒ 00:31:57.401 Uttam Kumaran: No, no, no, there’s.
451 00:31:57.580 ⇒ 00:31:59.070 Jakob Kagel: Dollar amount. It’s not good.
452 00:31:59.070 ⇒ 00:32:13.029 Uttam Kumaran: Yeah, yeah, yeah, it’s mainly duplicates in terms of like, I can’t just see distinct amount of shipments really easily. And there’s a lot of ancillary information that I don’t need orders when I want to. Just look at shipments. And then when we look at shipments, we’re looking.
453 00:32:13.030 ⇒ 00:32:13.900 Jakob Kagel: Yeah, right.
454 00:32:13.900 ⇒ 00:32:24.580 Uttam Kumaran: The zones. It’s going to how much it cost, how fast it got there, where it’s coming from. I don’t need a lot of the same. I don’t need to know, like, what was the tax on the order. I just need to know Price, of what it was in the box.
455 00:32:24.580 ⇒ 00:32:25.310 Jakob Kagel: Mittens
456 00:32:25.922 ⇒ 00:32:33.460 Jakob Kagel: that definitely has the impact on returns analysis to just because all of that stuff comes from the wall orders table, too.
457 00:32:33.460 ⇒ 00:32:33.909 Uttam Kumaran: Yeah.
458 00:32:34.360 ⇒ 00:32:38.099 Jakob Kagel: Like has has returned flag, or whatever, like.
459 00:32:38.100 ⇒ 00:32:43.989 Uttam Kumaran: Yeah. So, for example, like, if return is 2 shipments, they only return one. It’s a partial. It could be a partial refund.
460 00:32:44.350 ⇒ 00:32:45.410 Uttam Kumaran: But, like, yeah, there’s.
461 00:32:45.410 ⇒ 00:32:48.480 Jakob Kagel: Right. We don’t really have a way to mark that out.
462 00:32:48.580 ⇒ 00:32:51.579 Jakob Kagel: Yeah, we don’t have the way to mark that out. Really.
463 00:32:51.890 ⇒ 00:32:52.280 Uttam Kumaran: Yeah.
464 00:32:52.280 ⇒ 00:32:53.729 Jakob Kagel: Like. I don’t think.
465 00:32:54.680 ⇒ 00:32:57.054 Uttam Kumaran: So what we’re doing is basically
466 00:32:59.017 ⇒ 00:33:02.729 Uttam Kumaran: sorry. Let me search branches. I was like where the fuck is all my stuff.
467 00:33:04.930 ⇒ 00:33:05.700 Uttam Kumaran: pull.
468 00:33:06.550 ⇒ 00:33:15.539 Uttam Kumaran: So what I, what we’re basically doing is I’ve just done this on Amazon. I’m gonna kind of do this for shopify, too. Is I bring brought in all the Amazon data.
469 00:33:15.919 ⇒ 00:33:20.399 Uttam Kumaran: So basically, I’m getting the order, weight and order quantity for every single order.
470 00:33:20.799 ⇒ 00:33:27.820 Uttam Kumaran: I’m then bringing in the shipping amount. So there’s some logic here on actually how we calculate shipping amount.
471 00:33:27.850 ⇒ 00:33:29.750 Uttam Kumaran: Basically, if
472 00:33:30.040 ⇒ 00:33:32.920 Uttam Kumaran: the order itself doesn’t have a weight.
473 00:33:32.960 ⇒ 00:33:36.410 Uttam Kumaran: I’m gonna take the shipping amount from ship station.
474 00:33:36.879 ⇒ 00:33:45.979 Uttam Kumaran: If the order doesn’t have a quantity ordered, then I’m gonna take it from ship station and then again, it’s like there’s some logic for
475 00:33:48.530 ⇒ 00:33:53.429 Uttam Kumaran: There’s some. There’s some logic for figuring out the shipping amount which is
476 00:33:53.440 ⇒ 00:34:00.340 Uttam Kumaran: taking this, the individual order item, shipping amount, which is like the cost for one filter, for example, times the amount
477 00:34:01.630 ⇒ 00:34:10.119 Uttam Kumaran: times times the wait the top. Yeah. Times the wait divided by the order weight to figure out like the shipping amount.
478 00:34:10.656 ⇒ 00:34:17.060 Uttam Kumaran: Basically like we. There’s some cases where Amazon gives you this information versus it doesn’t
479 00:34:18.610 ⇒ 00:34:32.919 Uttam Kumaran: ship station always has it because they’re the one that’s where the packaging actually happens. But we also sometimes get this information from Amazon. So there’s some logic here. I’m also gonna re review a lot of this logic. Basically, when I go through this
480 00:34:35.730 ⇒ 00:34:41.280 Uttam Kumaran: and so next I’m I’m bringing in all the ship station order items.
481 00:34:41.330 ⇒ 00:34:44.669 Uttam Kumaran: Then the last thing I’m doing is I’m actually gonna be joining
482 00:34:45.202 ⇒ 00:34:52.390 Uttam Kumaran: ship station order items to Amazon to get all of the shipments from Amazon from ship station.
483 00:34:52.699 ⇒ 00:34:58.120 Uttam Kumaran: I’ll then need to do the same thing for Ltl. And for Unis, and then do the same thing
484 00:34:58.170 ⇒ 00:34:59.450 Uttam Kumaran: for shopify.
485 00:35:00.020 ⇒ 00:35:18.000 Uttam Kumaran: So the the trouble is, we sell shipments through multiple, different, like shipment providers. But they’re all coming from this 2 different channels. So there’s a little bit of like kind of like it’s a little bit backwards. So I’m kind of like reversing how all orders works, basically reversing the join, almost
486 00:35:20.100 ⇒ 00:35:23.379 Uttam Kumaran: so need to sit and finish this up.
487 00:35:23.790 ⇒ 00:35:25.280 Ryan Luke Daque: Bit, complicated, right?
488 00:35:25.560 ⇒ 00:35:35.887 Uttam Kumaran: Really complicated and just wanna make sure. But then the kind of decision I was wrangling with was like, Do I join orders to ship station or the other way, I actually want
489 00:35:36.490 ⇒ 00:35:37.899 Patrick Trainer: Yeah, I’d go upstream.
490 00:35:38.690 ⇒ 00:35:44.120 Uttam Kumaran: Yeah, I was like, I well, it’s kind of 2 things. I wanna make sure that every order
491 00:35:44.370 ⇒ 00:35:46.989 Uttam Kumaran: has a shipment associated with it.
492 00:35:47.790 ⇒ 00:35:56.119 Uttam Kumaran: At the same time, I wanna make sure every shipment has an order associated. But I’m actually less worried about that. I’m more worried about missing
493 00:35:56.510 ⇒ 00:36:03.469 Uttam Kumaran: stuff that shipments because we’re adding more shipment providers, Amazon and shopify is the source of truth for everything.
494 00:36:03.480 ⇒ 00:36:09.730 Uttam Kumaran: So I have more confidence that their data is right. So I’m either gonna do. I’m either gonna do a full join.
495 00:36:10.040 ⇒ 00:36:14.559 Uttam Kumaran: Yeah, I’m probably gonna do full join so that those no show up so we can catch them. There’s an error.
496 00:36:14.690 ⇒ 00:36:16.867 Uttam Kumaran: Instead of doing like a left join between
497 00:36:17.380 ⇒ 00:36:19.380 Uttam Kumaran: with this first table being
498 00:36:19.420 ⇒ 00:36:27.970 Uttam Kumaran: Amazon, the second table being ship station, I’ll do full join just to see if there’s any issues. Cause the join logic. Complicated.
499 00:36:31.430 ⇒ 00:36:33.340 Uttam Kumaran: cool. That’s
500 00:36:33.690 ⇒ 00:36:35.300 Uttam Kumaran: kind of like what I’ve been
501 00:36:35.570 ⇒ 00:36:42.140 Uttam Kumaran: one of the things I’ve been doing the other thing I’ve been doing, so I’ll sorry for hogging all the time, but I’ll share it myself.
502 00:36:42.570 ⇒ 00:36:47.390 Patrick Trainer: I was. Gonna say, I can go if we want to show the slim Ci stuff.
503 00:36:47.760 ⇒ 00:36:50.560 Uttam Kumaran: Yeah, I’ll show one more thing.
504 00:36:50.600 ⇒ 00:36:58.470 Uttam Kumaran: And I’m just finishing this up today. Our new like, homepage is basically live.
505 00:36:58.870 ⇒ 00:36:59.820 Patrick Trainer: Oh, nice!
506 00:37:00.380 ⇒ 00:37:01.190 Ryan Luke Daque: Nice.
507 00:37:01.420 ⇒ 00:37:03.609 Uttam Kumaran: So you can come on here.
508 00:37:04.170 ⇒ 00:37:05.790 Uttam Kumaran: You can see all our stuff.
509 00:37:06.000 ⇒ 00:37:07.630 Uttam Kumaran: This thing moves.
510 00:37:07.750 ⇒ 00:37:17.910 Uttam Kumaran: This thing is gonna have not athletic greens 4 times, but it’s gonna have each of these will be able to click into a case study that’s getting developed on.
511 00:37:18.170 ⇒ 00:37:21.369 Uttam Kumaran: This is nice and moves. This will be clickable.
512 00:37:21.890 ⇒ 00:37:26.179 Uttam Kumaran: You can see a little bit about like why, brain forge
513 00:37:27.960 ⇒ 00:37:33.812 Uttam Kumaran: I’m the head of copy. So this is all me. You can come in here and download our
514 00:37:34.180 ⇒ 00:37:40.679 Uttam Kumaran: like overview document. You just have to put in like your email here. And then this comes into like a little collection.
515 00:37:41.097 ⇒ 00:37:45.359 Uttam Kumaran: I put in, like some of our partners, I’ll probably change.
516 00:37:45.470 ⇒ 00:37:51.079 Uttam Kumaran: Wanna I’ll probably add real onto here, and like, add some of the you know as we start to work with more vendors.
517 00:37:51.120 ⇒ 00:37:58.500 Uttam Kumaran: One of the pitches from our side is that like we, we’re gonna put you on our site and things like that. And then we have some fa ques
518 00:37:58.630 ⇒ 00:38:02.749 Uttam Kumaran: kind of things that like I get asked all the time that are kind of written on here.
519 00:38:03.100 ⇒ 00:38:05.810 Uttam Kumaran: and then you can directly schedule a call from here.
520 00:38:06.140 ⇒ 00:38:09.809 Uttam Kumaran: and then, or you can also click on book a call, and it’ll just take you down here.
521 00:38:10.170 ⇒ 00:38:12.419 Uttam Kumaran: This took a long time, not because.
522 00:38:12.950 ⇒ 00:38:13.479 Jakob Kagel: Goodness!
523 00:38:14.120 ⇒ 00:38:17.169 Uttam Kumaran: Yeah, appreciate it, not because it’s necessarily hard.
524 00:38:17.180 ⇒ 00:38:20.445 Uttam Kumaran: It’s been really hard for me.
525 00:38:21.150 ⇒ 00:38:23.060 Uttam Kumaran: but it’s out there.
526 00:38:23.170 ⇒ 00:38:25.760 Uttam Kumaran: This is the last thing I need to change, but
527 00:38:25.820 ⇒ 00:38:30.500 Uttam Kumaran: feel free to send this to whoever or people talk about us or interested in sharing
528 00:38:30.865 ⇒ 00:38:33.549 Uttam Kumaran: this is gonna continue to get beefed up
529 00:38:33.840 ⇒ 00:38:40.330 Uttam Kumaran: with a lot more stuff, but I’m like very happy cause this took a fucking long time to to get done.
530 00:38:40.640 ⇒ 00:38:41.649 Patrick Trainer: And let’s see.
531 00:38:43.494 ⇒ 00:38:47.889 Uttam Kumaran: And then for the design, it’s all kudos to my friend Ivana. She runs her own
532 00:38:49.150 ⇒ 00:38:54.414 Uttam Kumaran: design studio. She’s a friend of mine that I worked with closely at
533 00:38:55.160 ⇒ 00:38:58.969 Uttam Kumaran: at a flow code. So she did all the design.
534 00:38:59.570 ⇒ 00:39:05.420 Uttam Kumaran: basically, for free. I paid her a little bit, but she’s just a good friend. So she’s like, I’ll just do everything.
535 00:39:07.590 ⇒ 00:39:08.340 Uttam Kumaran: yeah.
536 00:39:08.580 ⇒ 00:39:09.530 Uttam Kumaran: So.
537 00:39:09.780 ⇒ 00:39:10.670 Patrick Trainer: Hell, yeah.
538 00:39:10.970 ⇒ 00:39:11.560 Uttam Kumaran: It it looks.
539 00:39:11.560 ⇒ 00:39:12.380 Jakob Kagel: Very nice.
540 00:39:12.380 ⇒ 00:39:13.230 Uttam Kumaran: Legit.
541 00:39:15.810 ⇒ 00:39:16.790 Jakob Kagel: The moon.
542 00:39:18.760 ⇒ 00:39:19.290 Jakob Kagel: But yeah.
543 00:39:19.290 ⇒ 00:39:26.170 Uttam Kumaran: Yeah, of course. But I, I was like, yeah, our website needs to look so crisp because I I have a list of
544 00:39:26.770 ⇒ 00:39:28.278 Uttam Kumaran: I have a list of
545 00:39:29.210 ⇒ 00:39:31.730 Uttam Kumaran: all the other like
546 00:39:32.620 ⇒ 00:39:33.917 Uttam Kumaran: show. You guys.
547 00:39:36.460 ⇒ 00:39:38.640 Uttam Kumaran: I have a list of all the
548 00:39:38.840 ⇒ 00:39:42.370 Uttam Kumaran: like, a whole list of data consulting companies that I.
549 00:39:42.370 ⇒ 00:39:44.939 Patrick Trainer: And what their, what their websites look like.
550 00:39:44.940 ⇒ 00:39:48.959 Uttam Kumaran: Yeah. And so I’ve gone through every single one of these. And basically, it was like
551 00:39:49.840 ⇒ 00:39:55.849 Uttam Kumaran: Web, our website, just the way it is now is way better than every single one of theirs.
552 00:39:55.900 ⇒ 00:40:03.499 Uttam Kumaran: which is great. That was like my baseline where I was like. It needs to just look better than everybody. And then, now add stuff. It’s gonna look really slick.
553 00:40:03.740 ⇒ 00:40:10.159 Uttam Kumaran: Cause this is what people see when they see us, you know. So I wanted to look fresh. I wanted to look super fresh. I wanted to look really good, so
554 00:40:12.645 ⇒ 00:40:16.480 Uttam Kumaran: but if you have any feedback on anything we’ll we’ll make a lot of this better. But.
555 00:40:17.250 ⇒ 00:40:17.610 Patrick Trainer: Yeah.
556 00:40:18.900 ⇒ 00:40:19.630 Patrick Trainer: Well.
557 00:40:21.070 ⇒ 00:40:32.440 Jakob Kagel: You know, just share the one like the data party that some people uses. I don’t know if you have them on the list or whatnot, but they’re called sigma. This is gonna sort of compare against them, too.
558 00:40:32.960 ⇒ 00:40:37.600 Uttam Kumaran: Oh, oh, that you mean Sigma, like for their for their like data analytics.
559 00:40:38.660 ⇒ 00:40:40.580 Jakob Kagel: Yeah, exactly.
560 00:40:40.980 ⇒ 00:40:45.451 Uttam Kumaran: Yeah, we like, Sigma is probably similar to real. It’s like similar to looker like in terms of
561 00:40:45.700 ⇒ 00:40:52.229 Jakob Kagel: Oh, no, I’m talking about like the the company like that. They hire like they outsource like a lot of their data work, too.
562 00:40:52.230 ⇒ 00:40:52.855 Uttam Kumaran: Oh!
563 00:40:53.480 ⇒ 00:41:03.130 Jakob Kagel: It’s called mute. It’s called mute sigma. Yeah. So I saw you had the whole list of companies like, I don’t know if you have them on there or whatnot, but I don’t know if you just wanted to take a look at like what they do or what.
564 00:41:03.530 ⇒ 00:41:04.750 Uttam Kumaran: Mute. Sigma. Yeah.
565 00:41:06.670 ⇒ 00:41:09.089 Uttam Kumaran: I mean, I probably looked at it.
566 00:41:13.070 ⇒ 00:41:14.479 Jakob Kagel: I’ll send it.
567 00:41:17.800 ⇒ 00:41:18.650 Jakob Kagel: Who.
568 00:41:23.350 ⇒ 00:41:25.970 Uttam Kumaran: I mean, dude, what is this is crazy?
569 00:41:27.402 ⇒ 00:41:30.139 Uttam Kumaran: Yeah, I’m gonna go to someone like this.
570 00:41:31.030 ⇒ 00:41:35.755 Uttam Kumaran: I’m gonna go to the I’m gonna go to Yvonne and be like, Where do you have something like this? Some crazy.
571 00:41:42.200 ⇒ 00:41:46.620 Uttam Kumaran: I mean. But the thing is, you know, these guys make up a jelly and dollars. They’re working with home.
572 00:41:46.620 ⇒ 00:41:49.331 Jakob Kagel: Oh, for sure, for sure. Yeah, I mean
573 00:41:50.342 ⇒ 00:41:59.389 Jakob Kagel: I mean, I will say, like, their website might be covering your light, you know, whatever pines got, but like they definitely get shunned like, for sure. But yeah.
574 00:42:00.520 ⇒ 00:42:02.640 Uttam Kumaran: Yeah, I mean, so we’ll get there. I mean, look.
575 00:42:02.900 ⇒ 00:42:04.600 Uttam Kumaran: I am. But I
576 00:42:04.820 ⇒ 00:42:05.355 Uttam Kumaran: I
577 00:42:06.650 ⇒ 00:42:14.670 Uttam Kumaran: I think our shit needs to be the best design website. I want it to look the best. I want to be like, you come on there like I have the exact same problem.
578 00:42:15.032 ⇒ 00:42:21.490 Uttam Kumaran: It’s gonna help everything get smoother like you wouldn’t believe some of the sites that I’ve gone to look at
579 00:42:21.640 ⇒ 00:42:22.259 Uttam Kumaran: like
580 00:42:25.760 ⇒ 00:42:27.559 Uttam Kumaran: Ph data.
581 00:42:29.640 ⇒ 00:42:31.439 Patrick Trainer: You’re not sharing your screen. By the way.
582 00:42:31.590 ⇒ 00:42:33.779 Uttam Kumaran: Oh, I’m not. Oh, sorry! Sorry! Sorry! Sorry.
583 00:42:38.820 ⇒ 00:42:40.419 Uttam Kumaran: I was just looking at
584 00:42:41.130 ⇒ 00:42:42.904 Patrick Trainer: Hey? This that just looks like
585 00:42:43.890 ⇒ 00:42:45.240 Uttam Kumaran: This is mu sigma.
586 00:42:51.260 ⇒ 00:42:52.280 Patrick Trainer: It’s weird that like
587 00:42:52.370 ⇒ 00:42:54.820 Patrick Trainer: mood doesn’t come before
588 00:42:56.050 ⇒ 00:42:58.916 Patrick Trainer: Sigma in the Greek alphabet.
589 00:43:03.310 ⇒ 00:43:04.950 Uttam Kumaran: These are all questions I have.
590 00:43:05.550 ⇒ 00:43:06.350 Patrick Trainer: Yeah.
591 00:43:09.020 ⇒ 00:43:14.750 Uttam Kumaran: But yeah, I was looking at Ph data. But I can see a lot of these guys. They talk about themselves a lot.
592 00:43:14.970 ⇒ 00:43:17.669 Uttam Kumaran: And they have these like weird, consultant pictures of like
593 00:43:18.280 ⇒ 00:43:18.860 Uttam Kumaran: like.
594 00:43:18.860 ⇒ 00:43:20.889 Patrick Trainer: Yeah. Just stock. Images.
595 00:43:21.540 ⇒ 00:43:24.749 Patrick Trainer: It looks like like an enterprise kinda.
596 00:43:25.550 ⇒ 00:43:27.849 Jakob Kagel: Dog images are crazy. Yeah, that’s.
597 00:43:27.850 ⇒ 00:43:33.090 Uttam Kumaran: Dude. I don’t want one. I want a picture of us, maybe, but it’s not even about us, really. It’s like
598 00:43:38.420 ⇒ 00:43:39.370 Uttam Kumaran: like, Here’s, here’s.
599 00:43:39.370 ⇒ 00:43:41.444 Patrick Trainer: Yeah, yeah, that looks like, shit.
600 00:43:41.790 ⇒ 00:43:43.460 Uttam Kumaran: Yeah, I don’t like it at all.
601 00:43:49.170 ⇒ 00:43:50.650 Uttam Kumaran: Got a laptop.
602 00:43:54.850 ⇒ 00:43:58.910 Uttam Kumaran: Yeah, I don’t know. So I I spent like a long time looking through a lot of these
603 00:44:00.042 ⇒ 00:44:02.697 Uttam Kumaran: and just basically like, basically like
604 00:44:03.340 ⇒ 00:44:14.071 Uttam Kumaran: sketching, being like, this is good. This is not good. This is good. This is not good. So we have like a lot. I mean, this took a lot of work to just kind of get engineered and done, but like we’re getting closer, so cool. Alright.
605 00:44:14.300 ⇒ 00:44:15.710 Jakob Kagel: Vision. Let me press your business.
606 00:44:16.110 ⇒ 00:44:17.819 Uttam Kumaran: Yeah. Appreciate it.
607 00:44:19.280 ⇒ 00:44:21.100 Uttam Kumaran: Pat. I’ll let you go if you want.
608 00:44:21.100 ⇒ 00:44:24.101 Patrick Trainer: Cool, cool, cool. Yeah. So I’ll share
609 00:44:26.103 ⇒ 00:44:29.120 Patrick Trainer: the like. Slim ci workflows.
610 00:44:29.570 ⇒ 00:44:30.760 Patrick Trainer: And
611 00:44:31.360 ⇒ 00:44:32.100 Patrick Trainer: the
612 00:44:32.440 ⇒ 00:44:33.690 Patrick Trainer: can you all see.
613 00:44:36.740 ⇒ 00:44:38.000 Patrick Trainer: It’s like, Vs code.
614 00:44:38.400 ⇒ 00:44:42.039 Patrick Trainer: Okay, cool. So basically, the way it’s gonna work
615 00:44:42.350 ⇒ 00:44:47.640 Patrick Trainer: or way it does work is we have like our main branch that’s running Dbt on a Chron.
616 00:44:48.230 ⇒ 00:44:50.180 Patrick Trainer: And so then.
617 00:44:50.250 ⇒ 00:44:52.479 Patrick Trainer: after it runs, dbt.
618 00:44:52.490 ⇒ 00:44:58.020 Patrick Trainer: it uploads that manifest file into Sm, or it creates an artifact.
619 00:44:58.160 ⇒ 00:45:13.389 Patrick Trainer: and it’s that artifact. Instead of being stored on the repo, it’s actually stored on the workflow run. So it’s it. It’s kinda to pull it down. You have to find all this stuff about it and then get it. So anyway, that’s kind of the nuts and bolts
620 00:45:14.014 ⇒ 00:45:20.810 Patrick Trainer: but what we can do here is, we can come into our actions, and we can
621 00:45:21.280 ⇒ 00:45:26.750 Patrick Trainer: just run that from the main branch, and I’ll actually, I’ll pull up
622 00:45:27.395 ⇒ 00:45:31.109 Patrick Trainer: Github here, too, and bring that down just so we can see that.
623 00:45:33.980 ⇒ 00:45:35.140 Patrick Trainer: And then
624 00:45:37.090 ⇒ 00:45:38.800 Patrick Trainer: so we have.
625 00:45:38.850 ⇒ 00:45:41.039 Patrick Trainer: Where am I, brand forge actions?
626 00:45:42.290 ⇒ 00:45:45.319 Patrick Trainer: And so we can see that we’ve got.
627 00:45:50.660 ⇒ 00:45:52.939 Patrick Trainer: We got this action running right now.
628 00:45:55.000 ⇒ 00:45:57.719 Patrick Trainer: And so we’re installing. Dbt.
629 00:45:58.990 ⇒ 00:46:00.280 Patrick Trainer: it’s running.
630 00:46:00.580 ⇒ 00:46:01.720 Patrick Trainer: Dbt.
631 00:46:03.740 ⇒ 00:46:07.009 Patrick Trainer: it’s doing this. It’s gonna create these 3 models.
632 00:46:07.890 ⇒ 00:46:09.880 Patrick Trainer: It’s going to upload this manifest.
633 00:46:10.290 ⇒ 00:46:11.240 Patrick Trainer: clean up.
634 00:46:11.480 ⇒ 00:46:12.749 Patrick Trainer: complete the job.
635 00:46:13.120 ⇒ 00:46:14.359 Patrick Trainer: etc, etc.
636 00:46:14.740 ⇒ 00:46:19.459 Patrick Trainer: And then you can see like this summary, and then it creates this artifact.
637 00:46:19.470 ⇒ 00:46:21.999 Patrick Trainer: and then it creates this Dbt manifest
638 00:46:22.845 ⇒ 00:46:29.180 Patrick Trainer: and so the entire idea behind it is to when we
639 00:46:29.750 ⇒ 00:46:40.330 Patrick Trainer: change or edit a model, we don’t wanna run the entire job. We just wanna run that model. And it’s dependencies and so the way we do that
640 00:46:40.900 ⇒ 00:46:42.340 Patrick Trainer: is.
641 00:46:43.626 ⇒ 00:46:44.820 Patrick Trainer: I’m sorry.
642 00:46:45.465 ⇒ 00:46:49.830 Patrick Trainer: We are going to fetch the most recent artifact
643 00:46:50.315 ⇒ 00:46:58.329 Patrick Trainer: from a specific branch. And that’s main and so that’s what like this Jq query is doing.
644 00:46:58.370 ⇒ 00:46:59.939 Patrick Trainer: We’re using
645 00:46:59.950 ⇒ 00:47:02.589 Patrick Trainer: like the Github cli
646 00:47:02.840 ⇒ 00:47:06.400 Patrick Trainer: to one setup. Get but then also
647 00:47:06.775 ⇒ 00:47:14.340 Patrick Trainer: just look at our repo to get all artifacts. It’s like their endpoint, and it gets all of them returns this huge Json blob
648 00:47:14.985 ⇒ 00:47:19.739 Patrick Trainer: which then we parse out for the main branch
649 00:47:19.790 ⇒ 00:47:23.650 Patrick Trainer: out of like the out of the head branch, and then
650 00:47:24.060 ⇒ 00:47:26.299 Patrick Trainer: filter down to the Id.
651 00:47:26.460 ⇒ 00:47:31.939 Patrick Trainer: And so what we can do here is we can go back to actions.
652 00:47:32.350 ⇒ 00:47:36.199 Patrick Trainer: and we can, or first, what we’ll do.
653 00:47:36.845 ⇒ 00:47:38.869 Patrick Trainer: Is, we’ll create a branch
654 00:47:39.480 ⇒ 00:47:42.400 Patrick Trainer: we’ll shift into there.
655 00:47:42.970 ⇒ 00:47:44.420 Patrick Trainer: We will
656 00:47:44.600 ⇒ 00:47:49.770 Patrick Trainer: come into our Dbt project over here. Here are those 3 models.
657 00:47:49.800 ⇒ 00:47:51.620 Patrick Trainer: Let’s create like a
658 00:47:53.880 ⇒ 00:47:57.609 Patrick Trainer: We’ll create a model called Baz dot SQL,
659 00:47:57.640 ⇒ 00:48:01.079 Patrick Trainer: and that’s just going to select Star from
660 00:48:01.787 ⇒ 00:48:03.160 Patrick Trainer: what is it?
661 00:48:03.560 ⇒ 00:48:04.460 Patrick Trainer: Ref
662 00:48:06.580 ⇒ 00:48:07.780 Patrick Trainer: Boo bar
663 00:48:09.700 ⇒ 00:48:10.710 Patrick Trainer: right.
664 00:48:10.900 ⇒ 00:48:13.110 Patrick Trainer: that all that? All right. Yeah. Left.
665 00:48:14.450 ⇒ 00:48:17.610 Patrick Trainer: Made it being quotes, oh, yeah. And it’s being quotes, right.
666 00:48:19.330 ⇒ 00:48:20.469 Patrick Trainer: get there.
667 00:48:20.780 ⇒ 00:48:23.480 Patrick Trainer: okay? And we’ll save that.
668 00:48:23.810 ⇒ 00:48:25.690 Patrick Trainer: We’ll come in here.
669 00:48:27.133 ⇒ 00:48:28.740 Patrick Trainer: New like.
670 00:48:28.810 ⇒ 00:48:30.090 Patrick Trainer: add new
671 00:48:30.160 ⇒ 00:48:31.250 Patrick Trainer: model.
672 00:48:32.010 ⇒ 00:48:36.319 Patrick Trainer: We’ll stage these changes, commit that shit.
673 00:48:36.630 ⇒ 00:48:40.179 Patrick Trainer: and then we will publish the branch
674 00:48:40.640 ⇒ 00:48:42.340 Patrick Trainer: and create a Pr.
675 00:48:42.800 ⇒ 00:48:45.990 Patrick Trainer: And so we have that
676 00:48:47.280 ⇒ 00:48:48.969 Patrick Trainer: we will do that.
677 00:48:49.410 ⇒ 00:48:50.870 Patrick Trainer: Got that Pr
678 00:48:50.900 ⇒ 00:48:52.060 Patrick Trainer: created.
679 00:48:52.330 ⇒ 00:48:55.160 Patrick Trainer: and then we can come back.
680 00:48:55.660 ⇒ 00:48:56.949 Patrick Trainer: And to Github
681 00:48:57.820 ⇒ 00:48:59.320 Patrick Trainer: we can go back here.
682 00:49:00.400 ⇒ 00:49:02.470 Patrick Trainer: We can check out this pull request.
683 00:49:02.960 ⇒ 00:49:04.880 Patrick Trainer: And we have this add new model.
684 00:49:04.950 ⇒ 00:49:08.430 Patrick Trainer: And what it’s going to do here we can come into into here.
685 00:49:08.450 ⇒ 00:49:11.950 Patrick Trainer: This is the it’s it’s gonna run. This
686 00:49:13.520 ⇒ 00:49:15.390 Patrick Trainer: we put in.
687 00:49:20.240 ⇒ 00:49:23.909 Patrick Trainer: But the artifact, I think we actually have 2 actions running.
688 00:49:35.300 ⇒ 00:49:36.410 Patrick Trainer: We got that.
689 00:49:37.310 ⇒ 00:49:39.060 Patrick Trainer: And then
690 00:49:40.870 ⇒ 00:49:45.970 Patrick Trainer: let’s come back into here. Okay, we? Okay? Oh, yeah, I have it pushed
691 00:49:46.040 ⇒ 00:49:49.750 Patrick Trainer: on main. And so when we’re on the Pr.
692 00:49:50.040 ⇒ 00:49:51.160 Patrick Trainer: you can
693 00:49:52.060 ⇒ 00:49:54.160 Patrick Trainer: like, you can have all your checks
694 00:49:54.180 ⇒ 00:49:58.549 Patrick Trainer: and all your actions and whatnot, and that just does that.
695 00:49:58.600 ⇒ 00:50:02.310 Patrick Trainer: And when we merge the pull request
696 00:50:02.880 ⇒ 00:50:05.130 Patrick Trainer: into the main branch
697 00:50:05.400 ⇒ 00:50:07.389 Patrick Trainer: we can come back over here.
698 00:50:07.590 ⇒ 00:50:11.060 Patrick Trainer: and that’s going to create this new
699 00:50:12.680 ⇒ 00:50:13.690 Patrick Trainer: action
700 00:50:14.070 ⇒ 00:50:15.080 Patrick Trainer: going on.
701 00:50:15.360 ⇒ 00:50:17.370 Patrick Trainer: And so we can actually.
702 00:50:19.930 ⇒ 00:50:22.299 Patrick Trainer: what is this fish, most recent artifact?
703 00:50:24.740 ⇒ 00:50:27.750 Patrick Trainer: And so we have this get artifact workflow.
704 00:50:28.730 ⇒ 00:50:30.949 Patrick Trainer: It’s gonna go through. It’s gonna fetch.
705 00:50:31.800 ⇒ 00:50:33.279 Patrick Trainer: It’s going to find this.
706 00:50:34.640 ⇒ 00:50:35.700 Patrick Trainer: Find this.
707 00:50:35.840 ⇒ 00:50:38.590 Patrick Trainer: We got the artifact id from there.
708 00:50:38.800 ⇒ 00:50:40.819 Patrick Trainer: We’re going to use the artifact. Id.
709 00:50:41.030 ⇒ 00:50:44.350 Patrick Trainer: We’re getting to get that and download it into this environment.
710 00:50:45.870 ⇒ 00:50:47.809 Patrick Trainer: This is going to run dbt.
711 00:50:50.600 ⇒ 00:50:52.900 Patrick Trainer: and look at that. It only ran
712 00:50:53.500 ⇒ 00:50:54.709 Patrick Trainer: the bass model
713 00:51:00.130 ⇒ 00:51:02.650 Patrick Trainer: good of. You’re muted if you’re talking.
714 00:51:02.650 ⇒ 00:51:08.005 Uttam Kumaran: Yeah. So for the so for the pool parts actions, we’ll just need to add.
715 00:51:08.690 ⇒ 00:51:09.760 Uttam Kumaran: be
716 00:51:10.500 ⇒ 00:51:14.019 Uttam Kumaran: create, manifest, and the get artifact steps.
717 00:51:16.700 ⇒ 00:51:17.210 Uttam Kumaran: Yep.
718 00:51:17.210 ⇒ 00:51:18.599 Patrick Trainer: We’ll just have to
719 00:51:18.780 ⇒ 00:51:21.100 Patrick Trainer: add this. And because
720 00:51:22.314 ⇒ 00:51:26.060 Patrick Trainer: everything’s already running like the like on the daily run
721 00:51:26.160 ⇒ 00:51:32.969 Patrick Trainer: that’s gonna create that manifest, upload it, and then this will find it, and then run the difference.
722 00:51:33.265 ⇒ 00:51:39.460 Uttam Kumaran: I see. So we have the we have the intra day run, create the manifest every time. Okay, cool, great.
723 00:51:39.770 ⇒ 00:51:50.020 Patrick Trainer: Yeah. And so like, if we saw on the like, the first one, how it ran like all 4 models when we pushed the main this one. When we pushed the main
724 00:51:50.530 ⇒ 00:51:52.010 Patrick Trainer: we only brought
725 00:51:52.210 ⇒ 00:51:54.429 Patrick Trainer: the model that we had updated.
726 00:51:54.430 ⇒ 00:51:55.470 Uttam Kumaran: That’s great!
727 00:51:55.470 ⇒ 00:51:56.450 Patrick Trainer: From the pr.
728 00:51:59.070 ⇒ 00:52:00.020 Uttam Kumaran: That’s perfect.
729 00:52:01.110 ⇒ 00:52:02.850 Patrick Trainer: And
730 00:52:02.950 ⇒ 00:52:04.230 Patrick Trainer: yeah, that’s it.
731 00:52:05.950 ⇒ 00:52:06.470 Patrick Trainer: Me? So.
732 00:52:06.470 ⇒ 00:52:10.246 Uttam Kumaran: It’s gonna make the. It’s gonna make the Prs. Now run.
733 00:52:10.590 ⇒ 00:52:16.550 Patrick Trainer: And it’s gonna save a shit ton of compute on the on the Snowflake side, because we’re not running
734 00:52:17.276 ⇒ 00:52:17.873 Patrick Trainer: everything
735 00:52:18.580 ⇒ 00:52:20.290 Patrick Trainer: every single time.
736 00:52:20.290 ⇒ 00:52:20.920 Uttam Kumaran: Yeah.
737 00:52:21.510 ⇒ 00:52:22.240 Jakob Kagel: Very nicely.
738 00:52:25.160 ⇒ 00:52:25.800 Patrick Trainer: Bool.
739 00:52:26.610 ⇒ 00:52:32.030 Patrick Trainer: I’m glad that live Demo went without any any problem.
740 00:52:32.410 ⇒ 00:52:35.369 Patrick Trainer: But yeah, that’s that’s that’s that.
741 00:52:38.243 ⇒ 00:52:40.359 Uttam Kumaran: Anyone else. Wanna demo anything.
742 00:52:41.890 ⇒ 00:52:43.719 Jakob Kagel: I really got a drop. I actually
743 00:52:44.240 ⇒ 00:52:52.239 Jakob Kagel: for another call in a second. But I’m definitely happy to walk through the refund stuff. Like the additions.
744 00:52:52.620 ⇒ 00:52:53.840 Uttam Kumaran: Yeah. Maybe walk through next week.
745 00:52:53.840 ⇒ 00:52:55.469 Jakob Kagel: There like another time.
746 00:52:55.830 ⇒ 00:52:56.350 Uttam Kumaran: Yeah.
747 00:52:56.350 ⇒ 00:52:57.840 Jakob Kagel: Okay, hold on
748 00:52:58.560 ⇒ 00:52:59.330 Jakob Kagel: so
749 00:53:01.590 ⇒ 00:53:03.889 Jakob Kagel: alright. Y’all got it on trial.
750 00:53:03.890 ⇒ 00:53:04.779 Uttam Kumaran: They have both.
751 00:53:07.330 ⇒ 00:53:09.629 Uttam Kumaran: Ryan. I was gonna ask if there’s anything you wanted to demo.
752 00:53:10.210 ⇒ 00:53:13.385 Ryan Luke Daque: I don’t know if there’s anything I can. Demo at the moment.
753 00:53:13.920 ⇒ 00:53:16.869 Uttam Kumaran: I think mix big stuff was elementary. Last time.
754 00:53:16.870 ⇒ 00:53:19.282 Ryan Luke Daque: Yeah, let me try we already did that
755 00:53:19.810 ⇒ 00:53:22.490 Ryan Luke Daque: but I don’t know. Maybe I can. Demo
756 00:53:22.910 ⇒ 00:53:31.960 Ryan Luke Daque: like it would be great if pat was there like, I can demo the Dbt extension like power user in Vs code. Just so you know.
757 00:53:31.960 ⇒ 00:53:33.269 Patrick Trainer: Oh, yeah. Yeah.
758 00:53:34.340 ⇒ 00:53:35.780 Uttam Kumaran: Oh, yeah, maybe.
759 00:53:36.030 ⇒ 00:53:36.730 Ryan Luke Daque: Wish it.
760 00:53:37.890 ⇒ 00:53:41.949 Uttam Kumaran: Yeah, maybe I should set up time, or we can do it. And I wanted to stand up next week.
761 00:53:42.520 ⇒ 00:53:46.519 Ryan Luke Daque: Oh, yeah, sure it would be great like Pat would be there as well, cause like
762 00:53:46.580 ⇒ 00:53:48.680 Ryan Luke Daque: he’s pretty new to it as well. So like you.
763 00:53:48.680 ⇒ 00:53:49.850 Uttam Kumaran: Jacob, Jacob.
764 00:53:50.270 ⇒ 00:53:51.320 Ryan Luke Daque: I mean, I mean, yeah, Jake.
765 00:53:51.320 ⇒ 00:53:53.200 Patrick Trainer: Just like I’m I’m I’m here.
766 00:53:53.200 ⇒ 00:53:54.179 Uttam Kumaran: Nicely pat.
767 00:53:54.180 ⇒ 00:53:55.050 Patrick Trainer: Ahead.
768 00:53:55.050 ⇒ 00:53:59.306 Ryan Luke Daque: I was like thinking about Jacob, but I kept on seeing Pat’s name so.
769 00:54:00.050 ⇒ 00:54:02.080 Uttam Kumaran: Do you wanna do like maybe Tuesday.
770 00:54:02.660 ⇒ 00:54:03.399 Ryan Luke Daque: Yeah, sure
771 00:54:04.129 ⇒ 00:54:10.840 Ryan Luke Daque: it should be a pretty quick one, but it’s like, I don’t even use all of the functionalities. I just like use it for
772 00:54:11.920 ⇒ 00:54:16.549 Ryan Luke Daque: looking at the lineage and like doing queries and stuff. So yeah.
773 00:54:23.530 ⇒ 00:54:27.150 Uttam Kumaran: Okay, cool. Well, good week. Everybody. I’m gonna be online.
774 00:54:28.560 ⇒ 00:54:30.620 Uttam Kumaran: I’m gonna be online working on stuff
775 00:54:30.670 ⇒ 00:54:32.850 Uttam Kumaran: for a bit longer. So
776 00:54:33.700 ⇒ 00:54:40.790 Uttam Kumaran: yeah, let me know if you need it. Yeah, Pat, maybe I think we should take like a we should just maybe take like
777 00:54:41.070 ⇒ 00:54:48.150 Uttam Kumaran: I do attack that period next week, sometime to just move over asset, link, and cool parts to this new manifest
778 00:54:48.570 ⇒ 00:54:49.870 Uttam Kumaran: type thing. But.
779 00:54:50.010 ⇒ 00:54:52.309 Patrick Trainer: Yeah, yeah, yeah, we should be able to.
780 00:54:52.310 ⇒ 00:54:55.169 Uttam Kumaran: Well, actually, we should just point to the we should point to our.
781 00:54:55.550 ⇒ 00:55:08.059 Patrick Trainer: Yeah, because, like this, the repo is like, that’s it’s in that github actions. And we’ll be able to like there’s a uses key where you can drop in like a full link
782 00:55:09.910 ⇒ 00:55:13.349 Patrick Trainer: to our repo, and it’ll it’ll take that job.
783 00:55:13.390 ⇒ 00:55:15.700 Patrick Trainer: And then we can just call that job.
784 00:55:16.740 ⇒ 00:55:22.199 Uttam Kumaran: So maybe we do it like after, yeah, maybe we do it. I don’t know. When do you? Wanna when do you wanna do that next week?
785 00:55:24.040 ⇒ 00:55:24.955 Uttam Kumaran: Like an hour.
786 00:55:26.040 ⇒ 00:55:32.991 Patrick Trainer: Yeah, I can. I’ll I’ll probably be playing around with it today just to see if I can get it working. And then we can.
787 00:55:33.990 ⇒ 00:55:38.110 Patrick Trainer: yeah, make that move edit, all of those files.
788 00:55:38.180 ⇒ 00:55:40.439 Patrick Trainer: And but yeah, sometime next week.
789 00:55:40.720 ⇒ 00:55:41.320 Uttam Kumaran: Okay.
790 00:55:42.230 ⇒ 00:55:43.100 Uttam Kumaran: Okay.
791 00:55:43.350 ⇒ 00:55:46.950 Ryan Luke Daque: Yeah, I might be off earlier today, because, like, I have a
792 00:55:47.540 ⇒ 00:55:51.370 Ryan Luke Daque: I don’t typically to join tomorrow. But yeah.
793 00:55:51.390 ⇒ 00:55:53.839 Ryan Luke Daque: just let me know if there’s anything I need to
794 00:55:54.150 ⇒ 00:55:55.330 Ryan Luke Daque: any urgent thing.
795 00:55:55.760 ⇒ 00:55:56.910 Uttam Kumaran: Cool. Okay.
796 00:55:58.010 ⇒ 00:55:58.520 Ryan Luke Daque: That was good.
797 00:55:58.915 ⇒ 00:55:59.310 Uttam Kumaran: Bye.
798 00:55:59.310 ⇒ 00:56:00.110 Ryan Luke Daque: Thanks guys.
799 00:56:00.450 ⇒ 00:56:01.760 Uttam Kumaran: Hey, guys, be nice.
800 00:56:01.760 ⇒ 00:56:02.570 Ryan Luke Daque: Friday.
801 00:56:02.910 ⇒ 00:56:03.790 Uttam Kumaran: You too, bye.
802 00:56:04.080 ⇒ 00:56:04.860 Ryan Luke Daque: Bye-bye.