Meeting Title: Data Team Planning Session Date: 2025-01-29 Meeting participants: Luke Daque, Nicolas Sucari, Uttam Kumaran, Sahana Asokan


WEBVTT

1 00:05:00.763 00:05:01.890 Uttam Kumaran: Hey, guys.

2 00:05:07.470 00:05:08.410 Luke Daque: Hi! You, too.

3 00:05:09.560 00:05:10.270 Uttam Kumaran: Hey!

4 00:05:10.920 00:05:11.939 Luke Daque: How’s it going.

5 00:05:13.900 00:05:14.740 Uttam Kumaran: Is it going?

6 00:05:15.060 00:05:20.339 Uttam Kumaran: Bigquery sucks? Dude Corey’s so annoying.

7 00:05:23.000 00:05:23.809 Nicolas Sucari: Yeah, hi guys.

8 00:05:24.600 00:05:26.210 Luke Daque: What’s your problem with it?

9 00:05:27.540 00:05:30.380 Uttam Kumaran: It’s just it’s just too much like

10 00:05:31.470 00:05:37.289 Uttam Kumaran: just too much shit. And then I keep having to click load more. And I keep missing like quotes.

11 00:05:38.470 00:05:45.730 Uttam Kumaran: and like I can’t like it’s like takes takes like 10 steps to like load a Csv like

12 00:05:47.607 00:05:50.639 Uttam Kumaran: I mean, it works. But just taking a while.

13 00:05:51.150 00:05:59.530 Luke Daque: Yeah, even in the in the SQL queries, there’s like some nuances that are different as well.

14 00:06:00.800 00:06:04.110 Uttam Kumaran: Yeah. And like, we can’t do we can’t do

15 00:06:04.410 00:06:08.539 Uttam Kumaran: multiple databases. So we’ll have to do pro, I think we’ll have to create multiple?

16 00:06:08.760 00:06:11.320 Uttam Kumaran: I asked. Remember, Nick Baker.

17 00:06:12.400 00:06:12.760 Luke Daque: Yeah.

18 00:06:13.054 00:06:24.225 Uttam Kumaran: Remember, he was. Yeah. I asked him because he they use they use bigquery at at spotify. And I was like, What do you guys do? He’s like, they create multiple data projects per for each

19 00:06:25.950 00:06:27.330 Uttam Kumaran: whatever each.

20 00:06:27.620 00:06:30.719 Uttam Kumaran: Yeah, you get what I mean, environment. But

21 00:06:37.320 00:06:40.769 Uttam Kumaran: see, Nico. I got my my team.

22 00:06:42.070 00:06:42.410 Nicolas Sucari: Alright.

23 00:06:47.370 00:06:49.330 Nicolas Sucari: You have like a good team this year.

24 00:06:51.030 00:06:56.710 Uttam Kumaran: The Lakers are doing well. I haven’t watched much. Basketball is getting a little boring, yeah, but football.

25 00:06:56.710 00:07:00.834 Uttam Kumaran: I’m locked in on football this year. And so I’ll switch to basketball like soon

26 00:07:05.340 00:07:08.460 Uttam Kumaran: how you are watching football. Luke.

27 00:07:08.460 00:07:10.849 Uttam Kumaran: Yeah, when you guys, yeah, super bowl is soon.

28 00:07:11.530 00:07:12.410 Nicolas Sucari: It’s soon right.

29 00:07:12.410 00:07:16.850 Nicolas Sucari: Do I think I don’t know but chiefs are there right.

30 00:07:17.430 00:07:18.140 Uttam Kumaran: Yeah.

31 00:07:19.760 00:07:20.500 Nicolas Sucari: They are the best.

32 00:07:20.500 00:07:22.530 Uttam Kumaran: Houston eagles. Yeah.

33 00:07:22.710 00:07:23.510 Nicolas Sucari: Yeah.

34 00:07:23.810 00:07:25.110 Luke Daque: Yeah. I haven’t seen one team.

35 00:07:25.110 00:07:26.409 Nicolas Sucari: But with my homes.

36 00:07:27.160 00:07:28.350 Uttam Kumaran: Yes, yes.

37 00:07:29.300 00:07:31.950 Luke Daque: Haven’t been watching much sports lately.

38 00:07:33.010 00:07:33.610 Uttam Kumaran: Okay.

39 00:07:33.610 00:07:42.616 Luke Daque: Yeah, I used to watch basketball a lot. But yeah, like, recently, it’s getting a lot. It’s getting boring, like everybody’s just shooting threes and stuff. But.

40 00:07:42.950 00:07:45.220 Uttam Kumaran: Yeah, I agree.

41 00:08:17.150 00:08:19.180 Nicolas Sucari: Yeah, I don’t know if people is gonna join.

42 00:08:21.570 00:08:27.129 Uttam Kumaran: Yeah, I think bias, said he can’t make it. Maybe we can. Let’s just start. We can talk about Javi.

43 00:08:28.320 00:08:28.950 Nicolas Sucari: Yeah.

44 00:08:42.110 00:08:42.750 Nicolas Sucari: Okay.

45 00:08:43.465 00:08:44.830 Nicolas Sucari: Sorry. I was.

46 00:08:45.920 00:08:46.700 Uttam Kumaran: No worries.

47 00:08:48.010 00:08:51.813 Nicolas Sucari: And just arrived home. I was just answering a lot of things.

48 00:08:52.130 00:08:52.450 Uttam Kumaran: Okay.

49 00:08:52.450 00:08:54.670 Nicolas Sucari: Yeah. So let’s go for Javi.

50 00:08:55.240 00:08:58.850 Nicolas Sucari: Let me see. Compliant. Javi. Okay.

51 00:09:00.420 00:09:09.679 Nicolas Sucari: a lot going on. I need to work on those client pages. I don’t know why the old ones are still there, or why Robert is using the old ones. So I’m gonna check

52 00:09:09.820 00:09:10.970 Nicolas Sucari: on

53 00:09:11.230 00:09:18.049 Nicolas Sucari: worries all of the data and try to consolidate and delete the old one so that it doesn’t mess up with everything that we have. Okay.

54 00:09:18.450 00:09:19.730 Nicolas Sucari: cool, perfect.

55 00:09:20.340 00:09:32.490 Nicolas Sucari: Okay. In order according the the data there north beam data is already in, I think, right with them. We just need to validate if we have everything there on the spend

56 00:09:33.284 00:09:40.559 Nicolas Sucari: stuff, or we should on or we should add, like another endpoint. So we need to ask Ethan.

57 00:09:40.560 00:09:48.499 Uttam Kumaran: Yeah, we need. We need some time on the north beam. I sent some details to him on anyways. So let’s just mark

58 00:09:49.155 00:09:53.220 Uttam Kumaran: let’s just mark this as blocked, for now, because I need some more details from him to test.

59 00:09:54.450 00:09:55.140 Nicolas Sucari: Okay.

60 00:09:57.180 00:10:06.160 Nicolas Sucari: perfect. Okay, so we have north team and Amazon kind of locked from Amazon. They didn’t share any timeline right from portable. I see.

61 00:10:06.410 00:10:08.550 Uttam Kumaran: Hmm, not yet. We have the ticket. But

62 00:10:09.210 00:10:13.590 Uttam Kumaran: I think we’re gonna go ahead with just using 5. Transfer that for now. Yeah.

63 00:10:14.840 00:10:15.606 Nicolas Sucari: Okay. Cool.

64 00:10:16.120 00:10:21.150 Nicolas Sucari: Then. Shopify, I think. Look you already finished. Dpr, right.

65 00:10:21.580 00:10:29.260 Luke Daque: Yeah. Finally, we’ve merged that. So I did the variance. Analysis, like the differences between

66 00:10:29.450 00:10:32.510 Luke Daque: the one we had in with 5 ran versus portable.

67 00:10:33.255 00:10:42.019 Luke Daque: There was the fact orders. Table was fine, but the we did find some variances in the order in the fact order lines. Table.

68 00:10:42.751 00:10:45.710 Luke Daque: but yeah, upon further investigation.

69 00:10:45.820 00:10:53.390 Luke Daque: looks like it was because those we stopped the 5 train integration like some time ago, and the orders weren’t up to date

70 00:10:54.148 00:10:57.200 Luke Daque: already now so like fulfilled

71 00:10:57.480 00:11:06.040 Luke Daque: orders that weren’t fulfilled yet during that time showed as not fulfilled, but in portable. It already shows us fulfilled the same refund.

72 00:11:06.040 00:11:06.410 Nicolas Sucari: Okay.

73 00:11:06.410 00:11:08.029 Luke Daque: Like that. So yeah, we should be good.

74 00:11:09.040 00:11:10.140 Uttam Kumaran: Okay, so yeah.

75 00:11:10.430 00:11:16.240 Luke Daque: I’m I’m just updating the the notion document now. So we can also include the

76 00:11:16.930 00:11:22.379 Luke Daque: investigation that we did for for this one, for the variants.

77 00:11:24.010 00:11:32.940 Nicolas Sucari: Okay. But if if we update all of the data that so there is no difference between 5 portable right, we can say that.

78 00:11:33.110 00:11:38.149 Luke Daque: If, yeah, if you don’t include those not up to date data, we should be good.

79 00:11:39.920 00:11:45.959 Nicolas Sucari: Okay, so can we? Yeah, should I mark it as done that one, the one that shopify to programming creation.

80 00:11:46.860 00:11:47.620 Luke Daque: Yeah, we can.

81 00:11:47.620 00:11:52.280 Uttam Kumaran: I wanna I wanna I wanna send over the I wanna send over the variances for all of those.

82 00:11:53.355 00:11:56.449 Uttam Kumaran: So I kind of want to wait until we’re done with that.

83 00:11:56.820 00:11:59.490 Luke Daque: Yeah, I can. I can add the stuff. I just.

84 00:11:59.490 00:12:04.970 Uttam Kumaran: I’m gonna blast him with everything and be like we went through. Each of these is good. Send it, and then mark it as done

85 00:12:05.100 00:12:07.299 Uttam Kumaran: like, and then that’ll wrap this up.

86 00:12:09.250 00:12:09.930 Luke Daque: Cool.

87 00:12:09.930 00:12:10.520 Nicolas Sucari: Okay.

88 00:12:11.600 00:12:14.960 Nicolas Sucari: After this we are going to continue with the gorgeous.

89 00:12:15.700 00:12:19.199 Nicolas Sucari: or we are still blocked on gorgeous because we’re missing some of the.

90 00:12:19.200 00:12:26.560 Luke Daque: Yeah, we’re still missing some of the tables, the messages, and the ticket custom fields. We’re still blocked with that.

91 00:12:26.720 00:12:27.609 Luke Daque: Oh, good.

92 00:12:27.610 00:12:29.540 Uttam Kumaran: And they were. They said they were adding it.

93 00:12:29.540 00:12:32.849 Luke Daque: Yeah. And it’s like taking a while, because, like, it’s it.

94 00:12:33.380 00:12:35.850 Uttam Kumaran: Oh, they’re syncing our data or something, right?

95 00:12:36.420 00:12:41.575 Luke Daque: Our data. And like for those specific endpoints, they were like it needed to be pulled

96 00:12:42.400 00:12:43.740 Luke Daque: for each ticket.

97 00:12:44.330 00:12:47.790 Nicolas Sucari: And like, yeah, it’s hitting the the.

98 00:12:48.180 00:12:56.240 Luke Daque: The that the cap basically for gorgeous Api. So it’s taking a while because we have like a million

99 00:12:56.560 00:12:57.850 Luke Daque: rows or something.

100 00:12:59.330 00:12:59.850 Uttam Kumaran: Okay.

101 00:13:00.300 00:13:17.189 Luke Daque: So yeah, so we’re we’re still blocked for gorgeous. But for the rest of the sources that are already available, I’ve already updated that. And it’s already in the yeah. I just pushed them to the Pr, I’m just waiting for the 2 other sources to be available and then be.

102 00:13:17.670 00:13:19.819 Luke Daque: should be able to continue with that.

103 00:13:20.330 00:13:24.219 Uttam Kumaran: So, Nico, can we? Can we put anything that’s blocked by portable? Just put it.

104 00:13:24.220 00:13:24.820 Nicolas Sucari: Yeah.

105 00:13:25.370 00:13:26.980 Uttam Kumaran: And let’s just have the status there.

106 00:13:26.980 00:13:30.471 Nicolas Sucari: More than blocked, blocked by portable team

107 00:13:30.970 00:13:31.320 Uttam Kumaran: And.

108 00:13:31.320 00:13:39.480 Nicolas Sucari: Data ingestion for ticket, please taking to

109 00:13:46.260 00:13:52.769 Nicolas Sucari: okay. And often data is also blocked by the portable team.

110 00:13:55.800 00:13:56.590 Nicolas Sucari: Hey?

111 00:14:01.560 00:14:03.850 Nicolas Sucari: Okay, and that’s it.

112 00:14:05.040 00:14:12.769 Nicolas Sucari: And right now, this is this one, and this one is just blocked.

113 00:14:12.900 00:14:13.900 Nicolas Sucari: Alright. Perfect.

114 00:14:15.190 00:14:15.890 Nicolas Sucari: Okay.

115 00:14:17.450 00:14:25.760 Nicolas Sucari: So Burgess is blocked. Amazon is blocked, and north theme is blocked. We have okendo and recharge there on the backlog, also

116 00:14:26.050 00:14:27.300 Nicolas Sucari: to start working with.

117 00:14:27.300 00:14:29.390 Luke Daque: Working on that. Those 2.

118 00:14:30.670 00:14:31.860 Nicolas Sucari: Yeah, okay.

119 00:14:32.000 00:14:35.779 Nicolas Sucari: And the cog stuff is, I guess, is still looking at that one. Right?

120 00:14:36.040 00:14:44.029 Luke Daque: It’s also merged, I think, by us. Just merge it early like yesterday, I guess. Late. Yeah, late yesterday.

121 00:14:44.340 00:14:45.329 Luke Daque: so we should be.

122 00:14:45.330 00:14:47.580 Nicolas Sucari: Okay, so we can close that one. Yep.

123 00:14:48.040 00:14:49.960 Nicolas Sucari: okay, I’ll mark it as done

124 00:14:51.640 00:15:05.109 Nicolas Sucari: perfect. Okay, yeah. And then, we only have, okay, yeah. So we can start with Oquendo or recharge, maybe, and then pay us everything regarding the address. Matching stuff.

125 00:15:05.760 00:15:09.199 Nicolas Sucari: and the gross margin. Dashboard. B, 2. Okay.

126 00:15:09.860 00:15:10.370 Luke Daque: Sounds good.

127 00:15:10.370 00:15:14.529 Uttam Kumaran: Can you share can you share your screen? So just I can see.

128 00:15:27.900 00:15:28.849 Nicolas Sucari: Can you see there.

129 00:15:30.340 00:15:31.090 Uttam Kumaran: Yes.

130 00:15:35.530 00:15:45.049 Nicolas Sucari: So we have gorgeous Amazon and Northum. This one. These 3 are blocked. Blocked are this. One is by portable team because of the ingestion is taking too long

131 00:15:46.310 00:15:46.700 Uttam Kumaran: Okay.

132 00:15:46.700 00:15:59.710 Nicolas Sucari: Here is Amazon, let’s say team no connector developed it, and here is north beam.

133 00:16:01.490 00:16:10.579 Nicolas Sucari: then we have planned. We have the 2 from pay us the address matching and the gross margin dashboard, and then we have the recharge under candle stuff, or the engineering.

134 00:16:10.580 00:16:15.739 Uttam Kumaran: This matching is in progress. I think he’s done. I think he’s basically like it’s in review.

135 00:16:16.620 00:16:19.549 Uttam Kumaran: Well, let’s move that to in review there. He sent a message.

136 00:16:20.022 00:16:23.200 Uttam Kumaran: While you’re out to them. So that’s in review.

137 00:16:24.662 00:16:45.620 Uttam Kumaran: So I just want to wait until basically they respond and then gross margin. Dash, yeah, I guess we need to get an update from him on. If this gonna happen today. He, I just messaged him. He said. It’s in development. I think so. Let’s just move to in development, modeling okendo and recharge. So my broader conversation is, I need some help

138 00:16:45.960 00:16:47.500 Uttam Kumaran: on Eden

139 00:16:49.470 00:17:00.600 Uttam Kumaran: and I need some help on stack Blitz. So are these 2 like break priorities like, should we do? We need to close these out today, Nico, or like, how? What do we communicate to him.

140 00:17:01.520 00:17:19.809 Nicolas Sucari: I I mean, we we didn’t communicate when we were gonna finish with this, but we we communicated we were gonna spend only 10 h on modeling all of these stuff that we had there, because these ones were already in 5 turn. That’s why, like we were expecting to have everything ready from in portable and model.

141 00:17:19.810 00:17:20.170 Uttam Kumaran: Okay.

142 00:17:20.170 00:17:21.319 Nicolas Sucari: Like in 10 weeks

143 00:17:21.450 00:17:27.019 Nicolas Sucari: in 10 h. Sorry during this week. But I don’t know if this is like urgent, we can.

144 00:17:27.220 00:17:38.340 Nicolas Sucari: Just yeah, if if you need to work on something else, that’s fine, if we have shopify. Yeah. And and if we can unblock any of the other ones, I think it’s gonna be fine

145 00:17:40.840 00:17:57.039 Nicolas Sucari: for for end of the week. I mean, if if you, if you still, if you need to work on Eden or stack leads on something urgent. Let’s go for that. If we can then make pay us deliver the gross margin dashboard. I think that’s gonna be enough for one

146 00:17:57.160 00:17:57.790 Nicolas Sucari: for this week.

147 00:17:57.790 00:18:02.689 Uttam Kumaran: Okay, cool. So then let’s can we move these to Monday?

148 00:18:02.840 00:18:09.346 Uttam Kumaran: And then, yeah, I need some help. Luke on

149 00:18:10.730 00:18:14.019 Nicolas Sucari: So look, maybe we can leave this one as planned. Okay.

150 00:18:14.563 00:18:19.160 Nicolas Sucari: one that you just moved. I’m gonna move it back to planned. And

151 00:18:19.310 00:18:21.269 Nicolas Sucari: I’m gonna put this for Monday. Okay?

152 00:18:21.270 00:18:21.910 Luke Daque: Check

153 00:18:22.220 00:18:29.600 Luke Daque: and maybe the shopify one we can move to. Done. I just I already updated the ticket with all the

154 00:18:30.890 00:18:31.560 Luke Daque: screenshot.

155 00:18:31.560 00:18:34.676 Uttam Kumaran: I want. We want. I wanted to. Oh, okay, cool. Then.

156 00:18:37.900 00:18:41.519 Uttam Kumaran: yeah. Nico, do you want to? Just I mean, or I can take this and send

157 00:18:45.514 00:18:49.769 Nicolas Sucari: What I understand of this one. What I understand of this is

158 00:18:50.000 00:18:54.620 Nicolas Sucari: we found some differences because we stopped the syncing right.

159 00:18:54.620 00:18:58.210 Uttam Kumaran: Well, the well, the the overall thing is, there’s no there’s no, there’s no difference.

160 00:18:58.950 00:19:01.750 Nicolas Sucari: Yeah, exactly. There’s no difference that everything is fine.

161 00:19:01.750 00:19:05.140 Uttam Kumaran: That’s but that’s just what that’s what we’re trying to share. Yeah, yeah, I wouldn’t share like.

162 00:19:05.140 00:19:05.910 Nicolas Sucari: Okay, perfect.

163 00:19:06.740 00:19:09.539 Uttam Kumaran: Share that this is. These are the things we verified.

164 00:19:10.230 00:19:10.990 Uttam Kumaran: Go

165 00:19:12.290 00:19:12.980 Nicolas Sucari: Text me.

166 00:19:12.980 00:19:16.680 Uttam Kumaran: Like right at at this moment. We’re good. So that’s probably what I would share.

167 00:19:16.680 00:19:17.140 Nicolas Sucari: Okay.

168 00:19:17.355 00:19:17.999 Uttam Kumaran: I think that.

169 00:19:18.000 00:19:19.079 Nicolas Sucari: I’ll take care.

170 00:19:19.080 00:19:27.430 Uttam Kumaran: This context is here. But you can. Yeah, if you’re gonna send a message and just mark it as done. And basically I just want him to see something that we did a variance.

171 00:19:28.100 00:19:49.069 Nicolas Sucari: Yeah, yeah, that’s fine. I’m gonna mark it as done. I’m gonna share a message. I’m gonna prepare something saying that we did. We did this variance analysis between Portable and Fiveran and see that there was no difference at all. But yeah, maybe I’m gonna write up something and send it to you. Look, you can validate that. What I’m saying is correct and I’ll send it. Okay.

172 00:19:49.700 00:19:50.260 Luke Daque: Yep.

173 00:19:51.420 00:19:52.130 Nicolas Sucari: Perfect

174 00:19:53.600 00:20:14.070 Nicolas Sucari: cool. Yeah, I think for Javi. We have those ones. And then we have these. That was this, that new request that I want sent yesterday about creating that Amazon dashboard in database. I need to to talk to pay us to see when he could like work on this, because I know he has like a lot of things

175 00:20:14.210 00:20:15.370 Nicolas Sucari: in his plate right now.

176 00:20:15.370 00:20:17.150 Uttam Kumaran: I would try to get a date. Yeah, try.

177 00:20:17.150 00:20:17.560 Nicolas Sucari: Yeah.

178 00:20:17.560 00:20:18.650 Uttam Kumaran: Date for that.

179 00:20:20.135 00:20:20.700 Nicolas Sucari: Didn’t.

180 00:20:21.210 00:20:28.509 Nicolas Sucari: This is yeah, I added, Sunday this week. But maybe I can clear this out. And just yeah, ask him to do it. Yeah.

181 00:20:31.560 00:20:53.489 Nicolas Sucari: cool. And all of these ones are old ones. It would be good to check what we need to close on these ones, because, for example, this one on order Id and order number. This was something old that we have there for shopify. Look, I don’t know. We we have the Github issue, and I think there is a full request open here.

182 00:20:53.750 00:20:54.689 Nicolas Sucari: I’m not sure.

183 00:20:54.690 00:21:02.260 Uttam Kumaran: I think this is still open. I think this is still, these are still fair. I just don’t think these are like priority, like I think all of these we should still do.

184 00:21:03.399 00:21:06.810 Nicolas Sucari: You see, we we already worked on something here.

185 00:21:07.190 00:21:09.289 Luke Daque: We are there. And yeah, play us.

186 00:21:09.290 00:21:09.870 Nicolas Sucari: Yeah.

187 00:21:09.870 00:21:10.460 Luke Daque: Yeah.

188 00:21:11.200 00:21:14.729 Uttam Kumaran: Oh, okay, then close this out. Then, if we’re oh, but this is this needs review.

189 00:21:14.920 00:21:18.349 Luke Daque: Yeah, it just needs review. I can ask for pay us to.

190 00:21:18.350 00:21:21.756 Uttam Kumaran: Okay, then move this ticket to review, and then that way, it’s

191 00:21:23.110 00:21:24.070 Luke Daque: We’re good.

192 00:21:29.400 00:21:34.540 Nicolas Sucari: Perfect. Okay? And let’s have a due date for end of the week. Yeah, okay.

193 00:21:37.210 00:21:38.810 Nicolas Sucari: But yeah, nobody else.

194 00:21:38.810 00:21:49.980 Uttam Kumaran: Let’s do it. Let’s just let’s just put it. Just put it for today and close. Let’s close it out because this is just needs to be reviewed. There’s nothing else that needs to happen here. So just put the due date for today and be like, can we get this reviewed? It’ll take them 5 min.

195 00:21:59.520 00:22:07.619 Uttam Kumaran: Prs are always going to be like this, so we’ll open it up. They’ll be back and forth. We’ll we’re gonna we’ll build something that’s like a little bit of a Pr reminder longer term. But

196 00:22:08.000 00:22:10.300 Uttam Kumaran: this is this is normal, you know.

197 00:22:23.570 00:22:24.200 Nicolas Sucari: Okay.

198 00:22:43.450 00:22:44.130 Nicolas Sucari: cool.

199 00:22:44.940 00:22:46.530 Nicolas Sucari: Okay.

200 00:22:47.460 00:22:58.829 Nicolas Sucari: yes. So that’s joby, I think. That’s all we have for now I need to meet with the with a man to try to like scope out the

201 00:22:59.150 00:23:27.590 Nicolas Sucari: next week’s priorities so I I asked him some if he was available at some time. She. He didn’t answer. But I’m gonna push again and see if I can meet today or tomorrow with him and try to get that kind of roadmap everything that we talked about. We yesterday with Robert. Do you want me to like? I’ll I’ll prepare like a text. And do you want me to validate that with a man, or is is it just

202 00:23:27.850 00:23:29.700 Nicolas Sucari: like, Hey, we’re gonna work on this.

203 00:23:30.430 00:23:34.509 Nicolas Sucari: or or do you want me to ask him if there is any other priority.

204 00:23:35.330 00:23:45.789 Uttam Kumaran: I think it’s I think it’s this, I mean, I I basically he just. He’s already sent a note today, which is like, here’s the next weeks of stuff like we wanna work on this Amazon thing. So, looking at this list, we at least have.

205 00:23:47.090 00:23:50.480 Uttam Kumaran: I mean, we at least probably have stuff until the end of next week. Right?

206 00:23:50.730 00:23:56.480 Uttam Kumaran: Cause if we have to bring in North North Beam all these things, I think the next big thing here is figuring out

207 00:23:57.120 00:23:58.200 Uttam Kumaran: the next step.

208 00:23:59.740 00:24:01.120 Nicolas Sucari: Yeah. Okay.

209 00:24:05.010 00:24:05.800 Nicolas Sucari: Okay.

210 00:24:09.474 00:24:11.590 Uttam Kumaran: Okay, can we look at? Yeah, go ahead.

211 00:24:11.790 00:24:19.499 Luke Daque: Yeah. Pay us. Also wanted us to, maybe. Tell Aman as well on the blockers for the Georges.

212 00:24:20.520 00:24:25.329 Luke Daque: Yeah, the the rate limits for portable. It’s taking quite a while.

213 00:24:27.140 00:24:29.289 Uttam Kumaran: Okay, we could just say that it’s syncing.

214 00:24:29.670 00:24:30.300 Luke Daque: Yeah.

215 00:24:48.070 00:24:48.680 Nicolas Sucari: Okay.

216 00:25:05.040 00:25:07.339 Nicolas Sucari: okay, do you want to go for full parts.

217 00:25:08.943 00:25:10.010 Uttam Kumaran: Sure, yeah.

218 00:25:14.320 00:25:24.119 Nicolas Sucari: So we still haven’t reviewed this one look the one for the adding new shipping provider. This is something that we should be able to close this week.

219 00:25:24.120 00:25:29.429 Uttam Kumaran: This is like I still I still don’t. I still don’t know, like I’m still unclear, whether

220 00:25:32.230 00:25:37.200 Luke Daque: This is the the one where you saw like duplicates right? And I like removed it.

221 00:25:38.350 00:25:43.878 Uttam Kumaran: Yeah, I I guess, like, if you look like, I just put a question there, which is basically like,

222 00:25:44.290 00:25:49.469 Uttam Kumaran: this is, yeah, I. It’s not like a this isn’t like a D dupe. It’s more like.

223 00:25:49.790 00:25:54.710 Uttam Kumaran: I want to know whether shipments can there be 2 shipments

224 00:25:54.840 00:25:58.660 Uttam Kumaran: like for for one order, and then also, can you be

225 00:25:58.660 00:26:01.330 Uttam Kumaran: 2 skews per? Can there be 2 skews.

226 00:26:01.670 00:26:02.370 Luke Daque: And then.

227 00:26:03.670 00:26:06.519 Uttam Kumaran: Because if there’s 2 skews per shipment you’re gonna get dupes right.

228 00:26:06.730 00:26:08.200 Luke Daque: Yeah, exactly. Yeah.

229 00:26:08.966 00:26:12.179 Luke Daque: I didn’t check the skews part, but there are

230 00:26:12.330 00:26:18.559 Luke Daque: times when there are like multiple shipments for a single order. And this was one of them. When the one where you like.

231 00:26:19.490 00:26:20.560 Uttam Kumaran: That’s okay.

232 00:26:20.560 00:26:21.190 Luke Daque: So, yeah.

233 00:26:21.190 00:26:27.640 Uttam Kumaran: Multiple ship multiple shipments per order is fine. I’m more worried about multiples.

234 00:26:27.640 00:26:28.530 Luke Daque: And it’s like.

235 00:26:28.530 00:26:30.830 Uttam Kumaran: Use per for shipment.

236 00:26:31.190 00:26:31.870 Luke Daque: Yeah.

237 00:26:32.050 00:26:36.669 Nicolas Sucari: But but that’s that’s the same. I mean multiple skews meaning different skews or same skews.

238 00:26:36.670 00:26:43.100 Uttam Kumaran: No, it’s like, if you get a box with 2 different things in it. If we add this skew dimension, you’re gonna get 2 rows.

239 00:26:43.580 00:26:43.970 Uttam Kumaran: Yeah.

240 00:26:43.970 00:26:45.029 Uttam Kumaran: Same shipment. Id.

241 00:26:45.030 00:26:45.460 Nicolas Sucari: So, so.

242 00:26:45.460 00:26:46.909 Luke Daque: I think I found.

243 00:26:46.910 00:26:48.949 Nicolas Sucari: Choosing the same order you’re talking about.

244 00:26:49.250 00:26:50.040 Luke Daque: Like 2 shipment.

245 00:26:50.040 00:26:58.119 Luke Daque: Yes, box dimensions. And that’s yeah, that that might be a problem. Because it would like.

246 00:26:59.860 00:27:03.610 Luke Daque: yeah, we can average the dimensions or something. Right? We.

247 00:27:03.910 00:27:08.220 Uttam Kumaran: No, but can. But like the biggest thing I want to know is like, Can you just run a select?

248 00:27:09.090 00:27:14.509 Uttam Kumaran: Can you just run us like a select like shipment id.

249 00:27:14.740 00:27:17.480 Uttam Kumaran: and then basically tell me, like

250 00:27:18.874 00:27:24.019 Uttam Kumaran: like, if there are shipment ids attached to multiple skews.

251 00:27:24.740 00:27:27.720 Uttam Kumaran: that’s it. That’s what I want to know, like, Okay, okay.

252 00:27:27.720 00:27:29.929 Uttam Kumaran: And they ship 2 different things in one shipment.

253 00:27:30.360 00:27:33.729 Uttam Kumaran: because then adding a adding a product skew here is not valid.

254 00:27:35.710 00:27:46.519 Nicolas Sucari: The only thing is that these this was just focused on heat pumps like on skews for heat pumps in Florida. That’s why I think Luke went and did it directly.

255 00:27:46.520 00:27:51.079 Uttam Kumaran: But the but the broad, but the broader code change is affects all shipments

256 00:27:51.270 00:27:54.039 Uttam Kumaran: like. If you go, Nico, if you go into the code here.

257 00:27:54.200 00:27:59.710 Uttam Kumaran: There’s a change in the shipments in the shipments table.

258 00:28:01.330 00:28:04.870 Uttam Kumaran: If you go to shipments dot SQL. This change.

259 00:28:05.090 00:28:13.100 Uttam Kumaran: this. This is this means we’re adding skew to the shipping stable. My question is that if if there can be multiple

260 00:28:13.320 00:28:18.819 Uttam Kumaran: skews for a single shipment, then you’re gonna start to get more than one shipment.

261 00:28:18.820 00:28:20.219 Nicolas Sucari: More than one shipment value.

262 00:28:20.220 00:28:24.689 Uttam Kumaran: You’re gonna start seeing 2. Yeah. So instead, it’s like, I want to know, is that happening?

263 00:28:24.830 00:28:25.710 Uttam Kumaran: That’s it.

264 00:28:27.880 00:28:29.538 Luke Daque: Yeah. And if it’s happening

265 00:28:30.540 00:28:33.060 Luke Daque: yeah, let let me do that real quick.

266 00:28:34.710 00:28:42.240 Uttam Kumaran: If it’s happening, then it’s not like you will have to create a skew array or something, and that’s the solve.

267 00:28:42.240 00:28:42.750 Nicolas Sucari: Yeah, so we need.

268 00:28:43.284 00:28:43.819 Luke Daque: Yeah.

269 00:28:43.820 00:28:50.840 Nicolas Sucari: What what you’re saying. Utam is we need to check per shipment. Id. How many skews they? They have right.

270 00:28:51.770 00:28:54.720 Nicolas Sucari: If they have more than one per shipment. Id

271 00:28:55.533 00:29:02.250 Nicolas Sucari: it means that we are getting like 2 different costs per skew on that shipment right.

272 00:29:02.500 00:29:09.140 Luke Daque: Not just cost, but also like dimensions. If ever they have different dimensions, because we do have that.

273 00:29:10.740 00:29:11.255 Luke Daque: Yeah.

274 00:29:14.810 00:29:20.890 Luke Daque: But yeah, I’ll I’ll look into that, maybe after the the call, because we don’t get stuck there.

275 00:29:20.890 00:29:24.690 Nicolas Sucari: Okay, so I’ll I’ll move it to in development, maybe

276 00:29:25.228 00:29:29.940 Nicolas Sucari: so that we know that it’s no one is reviewing. We just need to work on that one. Okay.

277 00:29:30.150 00:29:42.470 Nicolas Sucari: let me add here a status that is checking, that we don’t of more than

278 00:29:44.560 00:29:50.790 Nicolas Sucari: duplicates. Now that we don’t have, and values for the same.

279 00:30:03.830 00:30:04.610 Nicolas Sucari: Okay.

280 00:30:16.650 00:30:19.607 Nicolas Sucari: when we have that one to close.

281 00:30:20.310 00:30:26.340 Nicolas Sucari: there is this task which one that says clean up all pull requests. I don’t know if we already did this, but.

282 00:30:31.025 00:30:31.270 Uttam Kumaran: No.

283 00:30:31.270 00:30:31.780 Nicolas Sucari: Yeah, maybe.

284 00:30:31.780 00:30:32.370 Uttam Kumaran: Done this yet.

285 00:30:32.370 00:30:32.900 Nicolas Sucari: See all there.

286 00:30:32.900 00:30:35.040 Uttam Kumaran: Just move it to just move it to plan.

287 00:30:36.520 00:30:38.570 Uttam Kumaran: Yeah, I haven’t done this ever.

288 00:30:39.440 00:30:42.079 Luke Daque: I’ll just move the due date for next week. Maybe.

289 00:30:43.590 00:30:45.290 Nicolas Sucari: This is not our agenda at all.

290 00:30:45.630 00:30:49.240 Nicolas Sucari: Okay, chess.

291 00:30:49.240 00:30:52.440 Nicolas Sucari: Yeah. I told you already started perfect

292 00:30:55.820 00:31:00.649 Nicolas Sucari: and then on modeling side for pull parts. I don’t know we have. I don’t think we have like

293 00:31:00.870 00:31:05.430 Nicolas Sucari: anything else, for now look.

294 00:31:07.620 00:31:11.929 Luke Daque: Yeah, I don’t. Yeah. We don’t have anything for new for us.

295 00:31:12.140 00:31:12.810 Luke Daque: No problem.

296 00:31:12.810 00:31:18.699 Nicolas Sucari: You know, we we just have all of the skew stuff, the other stuff that we talked about with them.

297 00:31:18.950 00:31:20.179 Nicolas Sucari: and we just need.

298 00:31:20.180 00:31:22.920 Uttam Kumaran: It’s all good. It’s all gonna come out of the stuff from pious. Yeah.

299 00:31:23.580 00:31:24.500 Uttam Kumaran: it’s gonna come out of that place.

300 00:31:25.950 00:31:30.080 Uttam Kumaran: Okay, okay, okay, cool. So yeah, let’s let’s talk about stack Blitz.

301 00:31:31.023 00:31:32.189 Uttam Kumaran: We can.

302 00:31:33.430 00:31:38.739 Uttam Kumaran: So I need help. With stripe data modeling. Luke.

303 00:31:39.872 00:31:42.190 Uttam Kumaran: We have all the data there.

304 00:31:42.696 00:31:46.179 Uttam Kumaran: I just need help to create some of the core metrics.

305 00:31:47.044 00:31:54.269 Uttam Kumaran: Do you want to take that on like it’s basically like creating Mrr arr like

306 00:31:55.642 00:32:10.309 Uttam Kumaran: that would be great, and I can. We can talk in the Channel. I think you should have all the if you 5 train has a pretty good stripe sort of boilerplate code you can look at, but we’re using polytomic so it won’t be identical.

307 00:32:10.310 00:32:10.710 Luke Daque: Oh!

308 00:32:10.710 00:32:19.899 Uttam Kumaran: But basically, basically like where we get transactions from stripe. And we’re just trying to like attribute revenue and subscriptions to customers.

309 00:32:21.650 00:32:25.599 Luke Daque: Yeah, what do we need like, what metrics do we need for?

310 00:32:26.720 00:32:31.820 Luke Daque: Yeah, maybe we can like, add the details to the ticket. Maybe I can like can work on that.

311 00:32:32.230 00:32:33.309 Uttam Kumaran: Okay. And we’re.

312 00:32:33.540 00:32:34.370 Luke Daque: Just to confirm.

313 00:32:34.370 00:32:34.960 Nicolas Sucari: Oh, yeah.

314 00:32:34.960 00:32:37.979 Luke Daque: We’re not using 5 grand for stripe yet. Right? It’s like.

315 00:32:37.980 00:32:43.319 Uttam Kumaran: We’re no, we’re using polytomic. Or, yeah, it’s just like not. It’s just.

316 00:32:43.900 00:32:45.630 Luke Daque: Yeah for the Etl piece.

317 00:32:47.040 00:32:52.400 Luke Daque: Yeah, that’s sucks we we could have. We could have used the

318 00:32:53.170 00:33:00.859 Luke Daque: maybe looking at the document, the the Dbt package from 5 10. But yeah, I don’t think it’s the same.

319 00:33:01.700 00:33:11.699 Uttam Kumaran: Yeah, they want. They they wanted to go with this. So that’s fine. It’s it’s not that hard. But and I think you should just try to use cursor as much as possible to write it.

320 00:33:12.200 00:33:12.810 Luke Daque: Yeah.

321 00:33:13.180 00:33:14.729 Uttam Kumaran: But I’ll give you the requirements.

322 00:33:15.140 00:33:15.690 Luke Daque: Cool.

323 00:33:16.770 00:33:20.840 Luke Daque: When is this due? Is this like the highest priority right now.

324 00:33:22.000 00:33:25.919 Uttam Kumaran: Yeah, that’s the biggest thing I wanna try to get something for stripe out this week.

325 00:33:26.570 00:33:27.840 Uttam Kumaran: Cool.

326 00:33:30.720 00:33:39.810 Nicolas Sucari: I agree with these. Maybe you can add then the details, Utam. But yeah, let’s set due date for tomorrow. Friday. Would you say.

327 00:33:43.876 00:33:45.060 Uttam Kumaran: Sure, yeah, Friday’s fine.

328 00:33:48.050 00:33:50.040 Uttam Kumaran: I’ll add the details, and we can break this up.

329 00:33:55.960 00:33:58.959 Nicolas Sucari: What else do we have there? For start with.

330 00:34:00.600 00:34:06.909 Uttam Kumaran: That’s the number one thing. The second thing is user data modeling. Let’s just put that as needs requirements.

331 00:34:07.310 00:34:10.710 Uttam Kumaran: And then I’ll fill out the requirements. You can just do user data modeling.

332 00:34:15.239 00:34:18.120 Uttam Kumaran: Postgres. Cdc, you can mark as done.

333 00:34:20.810 00:34:21.840 Uttam Kumaran: Yeah.

334 00:34:24.340 00:34:28.820 Uttam Kumaran: And then for user data modeling, you can set Friday as well.

335 00:34:29.830 00:34:32.049 Uttam Kumaran: I’m gonna do this this afternoon.

336 00:34:40.909 00:34:41.449 Nicolas Sucari: Great.

337 00:34:47.289 00:34:47.989 Nicolas Sucari: think.

338 00:34:49.699 00:34:56.409 Luke Daque: By the way, going back to the poor parts shipments one, it looks like we’re not getting any duplicated products queues.

339 00:34:56.919 00:35:00.239 Luke Daque: maybe because we are in the shipments table. We are

340 00:35:00.619 00:35:06.079 Luke Daque: already breaking it down by order. Item id, and like one order item, Id can.

341 00:35:06.080 00:35:06.660 Uttam Kumaran: Oh, okay.

342 00:35:06.660 00:35:11.430 Luke Daque: We have one product skew, so I think we should be good. Then.

343 00:35:13.320 00:35:18.360 Uttam Kumaran: I just wanna make really make sure that we don’t check this in a month. And we have duplicate.

344 00:35:18.900 00:35:19.410 Uttam Kumaran: So yeah.

345 00:35:19.410 00:35:20.160 Luke Daque: I I did.

346 00:35:20.160 00:35:21.319 Uttam Kumaran: What can we do?

347 00:35:21.550 00:35:28.779 Luke Daque: Like, I just counted all the distinct product skews for each order. Item. Id, because we don’t have a shipment. Id

348 00:35:29.864 00:35:37.619 Luke Daque: and it’s all unique, so nothing’s more than one. So I think we should be good unless there’s anything else I missed here.

349 00:35:38.330 00:35:42.315 Uttam Kumaran: Can we add this to to like a test, or something like

350 00:35:43.600 00:35:46.309 Luke Daque: Yeah, that would be great. And then, okay, we can push this through.

351 00:35:46.560 00:35:49.579 Luke Daque: Cool. Sounds good. I’ll I’ll create a test for this one. Then.

352 00:35:50.330 00:35:51.060 Uttam Kumaran: Okay.

353 00:35:54.590 00:35:54.935 Nicolas Sucari: Okay.

354 00:35:56.365 00:36:00.920 Nicolas Sucari: Okay. Hi, Sahana just saw you joined here.

355 00:36:01.250 00:36:05.469 Sahana Asokan: Sorry I was. I had another meeting run over so I just wanted.

356 00:36:05.470 00:36:06.080 Nicolas Sucari: Don’t worry.

357 00:36:09.200 00:36:16.499 Nicolas Sucari: Just letting you know I created these ticket you requested yesterday about moving from Looker to the blow. Okay.

358 00:36:16.500 00:36:24.109 Sahana Asokan: Yeah, yeah, so yeah, I’m working on that right now. And I guess just for context for everyone else. So because we’re trying to push

359 00:36:24.470 00:36:40.330 Sahana Asokan: for tableau. All the current dashboard work and looker studio will just be on hold for now. However, I did want to just get a status update on the product plan type modeling. I think that’s done right.

360 00:36:41.550 00:36:48.150 Uttam Kumaran: Yeah, so that’s all sort of wrapped up into this like product.

361 00:36:48.370 00:36:57.919 Uttam Kumaran: like, basically product summary table. And yeah, you’ll basically, you’ll have cogs after like an hour, and then we’re also working on all the ad. Spend attribution.

362 00:36:59.560 00:37:03.199 Uttam Kumaran: See? That should all be ready, and you’ll have the plan type. The plan ids in there.

363 00:37:03.820 00:37:10.820 Sahana Asokan: Okay, sounds good. Yeah. We’ll probably won’t start doing any of that next week. But yeah, thank you. That’s good. Sounds good.

364 00:37:17.030 00:37:17.710 Nicolas Sucari: Okay.

365 00:37:19.900 00:37:24.410 Nicolas Sucari: What else do we have anything else.

366 00:37:26.010 00:37:30.089 Uttam Kumaran: For Eden. Can you just scroll down to what’s active right? Now?

367 00:37:35.610 00:37:38.729 Uttam Kumaran: Okay, yeah. If you just go scroll down even further

368 00:37:46.740 00:37:52.439 Uttam Kumaran: plan for core data models. Let’s just let’s let’s just kick this back.

369 00:37:56.580 00:38:08.699 Uttam Kumaran: Just a yeah backlog and then, right now, I’m working on that one. Yeah.

370 00:38:10.250 00:38:10.820 Nicolas Sucari: Okay.

371 00:38:11.690 00:38:17.959 Uttam Kumaran: Yeah. So I think, just yeah, we’re just getting we get, we just get learning new stuff every

372 00:38:18.390 00:38:23.080 Uttam Kumaran: 15 min or so. So I’m working on it right now. It should. I should have a version done by the hour.

373 00:38:25.010 00:38:25.690 Nicolas Sucari: Okay?

374 00:38:26.560 00:38:34.620 Nicolas Sucari: And, sah, for that document on moving looker to the law what due date should I set for the for that one.

375 00:38:35.870 00:38:38.870 Sahana Asokan: Yeah, by Friday should be done.

376 00:38:40.000 00:38:41.149 Sahana Asokan: Yeah, thank you.

377 00:38:44.030 00:38:44.660 Nicolas Sucari: Okay.

378 00:38:51.420 00:38:53.470 Nicolas Sucari: Okay. Anything. Else.

379 00:38:55.010 00:39:05.090 Uttam Kumaran: I think that’s it. I I know there’s there was some conversation in the our helper channel. So I think that’s all covered. And yeah, I think we should have more work for Eden after

380 00:39:05.580 00:39:09.000 Uttam Kumaran: basically going into next week. So we’ll plan that with Robert

381 00:39:09.422 00:39:12.140 Uttam Kumaran: and maybe meet on Friday, to to discuss those.

382 00:39:12.880 00:39:19.853 Sahana Asokan: Yeah on art helper. Essentially like just small update to. They gave us the green flag to start some of the basic

383 00:39:20.300 00:39:24.549 Sahana Asokan: dashboard work in amplitude, but none of their events were fired. Yet.

384 00:39:24.550 00:39:25.140 Uttam Kumaran: Sorry.

385 00:39:25.540 00:39:26.370 Uttam Kumaran: Okay.

386 00:39:26.780 00:39:33.420 Sahana Asokan: Yeah. So I don’t really know why they gave us that green light. But Robert’s aware of that so just giving you a heads up.

387 00:39:33.860 00:39:34.500 Uttam Kumaran: Okay.

388 00:39:38.580 00:39:41.490 Nicolas Sucari: Okay, cool.

389 00:39:42.100 00:39:48.210 Nicolas Sucari: Thanks, guys. So if there’s nothing else, yeah, we can keep talking through slack. Okay.

390 00:39:48.470 00:39:49.040 Uttam Kumaran: Okay.

391 00:39:49.930 00:39:52.280 Luke Daque: Sounds good. Thanks. Guys. See? You.

392 00:39:52.280 00:39:53.330 Nicolas Sucari: You. Bye-bye.