Meeting Title: [HOLD] EOD Delivery Standup Date: 2025-11-20 Meeting participants: Mustafa Raja, Uttam Kumaran, Rico Rejoso


WEBVTT

1 00:00:53.670 00:00:54.820 Uttam Kumaran: Hello!

2 00:00:57.310 00:00:58.220 Mustafa Raja: Hey, how are you?

3 00:01:05.120 00:01:06.470 Uttam Kumaran: I am good.

4 00:01:54.420 00:01:55.170 Mustafa Raja: Hmm.

5 00:01:55.290 00:02:02.260 Mustafa Raja: Yeah, so… How does the SOW look to you?

6 00:02:04.120 00:02:06.929 Mustafa Raja: Did you take a look at, look at that?

7 00:02:11.740 00:02:20.179 Uttam Kumaran: Yeah, but we don’t need an SOW, dude, we kinda need, like, what to tell Victor, like, what do you need them to do in S3?

8 00:02:20.340 00:02:22.570 Uttam Kumaran: Like, that’s what you need to write about.

9 00:02:23.830 00:02:24.700 Uttam Kumaran: You know.

10 00:02:28.780 00:02:31.899 Uttam Kumaran: Like, we’re not trying to put together a scope of work, like…

11 00:02:32.030 00:02:36.379 Uttam Kumaran: you need to just put… give them instructions on what to do in S3 to test.

12 00:02:37.230 00:02:41.099 Mustafa Raja: Okay, okay, for now we are only going to test two, right?

13 00:02:42.220 00:02:43.830 Mustafa Raja: Yeah, I would give them…

14 00:02:44.070 00:02:49.129 Uttam Kumaran: both pieces, like, I would tell them what to test, and tell them, like, okay, if the test…

15 00:02:49.340 00:02:52.800 Uttam Kumaran: Succeeds, then here’s what we’re doing in the next phase.

16 00:02:53.020 00:02:56.110 Uttam Kumaran: Basically, we’re not gonna get access to S3, so…

17 00:02:56.960 00:02:59.459 Uttam Kumaran: You’re gonna need to get them to do whatever we need.

18 00:02:59.460 00:03:04.070 Mustafa Raja: Oh… Oh, we’re not getting the access, okay.

19 00:03:07.220 00:03:13.829 Mustafa Raja: Okay, then, I believe we would need some sort of transformation layer, to convert,

20 00:03:14.000 00:03:22.850 Mustafa Raja: the existing tables into some KPI tables that we can then, ingesting S3.

21 00:03:22.980 00:03:27.330 Mustafa Raja: And then S3 could then connect to, Catalyst.

22 00:03:28.270 00:03:29.010 Uttam Kumaran: Yes.

23 00:03:29.540 00:03:35.560 Mustafa Raja: So, I’m just wondering, for… for this transformation layer.

24 00:03:35.560 00:03:37.030 Uttam Kumaran: So you should use this.

25 00:03:38.040 00:03:39.579 Uttam Kumaran: To write to S3.

26 00:03:39.820 00:03:42.750 Uttam Kumaran: And you should use dbt to schedule it.

27 00:03:42.750 00:03:44.910 Mustafa Raja: Yes, I was thinking the same.

28 00:03:45.340 00:03:51.770 Mustafa Raja: For, Dbt for… for the transformation, right? Into KPIs and all.

29 00:03:52.580 00:03:53.280 Uttam Kumaran: Correct.

30 00:03:53.770 00:03:56.099 Mustafa Raja: Okay, yeah, I was thinking the same, yeah.

31 00:03:56.500 00:03:59.349 Uttam Kumaran: But you don’t need that for them to test the integration.

32 00:03:59.770 00:04:08.529 Mustafa Raja: Yeah, I believe I could just give them the CSV that I had created before.

33 00:04:08.640 00:04:12.859 Mustafa Raja: And they could just put that in and,

34 00:04:13.160 00:04:17.020 Mustafa Raja: I could also give them the documentation on,

35 00:04:17.360 00:04:20.720 Mustafa Raja: how they can connect S3 with the catalyst.

36 00:04:21.130 00:04:26.970 Mustafa Raja: To create the sync, right?

37 00:04:30.840 00:04:33.930 Uttam Kumaran: What do you mean?

38 00:04:35.210 00:04:51.060 Mustafa Raja: So, I created a, I created a CSV with 15 teams, right? To test it out. I could just give that to Victor, so they could put it in S3, and then, using this documentation.

39 00:04:53.650 00:04:58.379 Mustafa Raja: I’d need some keys from them, and then I could.

40 00:04:58.380 00:04:59.890 Uttam Kumaran: But what keys do you need?

41 00:05:00.690 00:05:04.779 Mustafa Raja: For S3, to connect S3 with, Catalyst, right?

42 00:05:05.830 00:05:08.379 Uttam Kumaran: No, no, no, but you have to tell them to do it.

43 00:05:10.290 00:05:13.980 Mustafa Raja: I have to tell them to connect S3 with Catalyst.

44 00:05:14.580 00:05:15.270 Uttam Kumaran: Yes.

45 00:05:15.820 00:05:24.489 Uttam Kumaran: Okay, yeah, I could… then I could just give them this documentation, this has all of it. That’s what I’m saying, they’re… assume that we’re not gonna get any S3 access, so you need to…

46 00:05:24.710 00:05:29.100 Uttam Kumaran: What we need is just, like, a step-by-step instruction of, like, what they need to do.

47 00:05:29.390 00:05:30.560 Mustafa Raja: Okay. So…

48 00:05:30.560 00:05:35.100 Uttam Kumaran: Give them the CSV, tell them we want to use this test, tell them to go through these steps.

49 00:05:35.260 00:05:44.770 Uttam Kumaran: And then, to let you know when the test is done. And then, in the second phase, talk to them about, hey, once the test is done, I will be consistently populating

50 00:05:45.080 00:05:47.519 Uttam Kumaran: the S3 bucket with this new file.

51 00:05:48.040 00:05:53.249 Uttam Kumaran: Every day. And so that’s the second test, is to then, once the first one works, you can then

52 00:05:53.390 00:05:57.260 Uttam Kumaran: Run your copy commands, and then test whether it’s gonna be working ongoing.

53 00:05:59.860 00:06:00.380 Mustafa Raja: Oh, okay.

54 00:06:00.380 00:06:01.000 Uttam Kumaran: You know?

55 00:06:01.390 00:06:01.990 Mustafa Raja: Yeah.

56 00:06:02.170 00:06:06.919 Mustafa Raja: Yeah, I have, I have just, one problem that is…

57 00:06:07.110 00:06:12.260 Mustafa Raja: The test CSV for now, has…

58 00:06:13.860 00:06:25.399 Mustafa Raja: what’s it called? Salesforce IDs for the teams, to, you know, stitch between, the source data and then the, team in,

59 00:06:25.900 00:06:26.990 Mustafa Raja: Catalyst?

60 00:06:27.520 00:06:32.619 Mustafa Raja: I, I wanted to use the domain, but…

61 00:06:33.990 00:06:38.010 Mustafa Raja: That isn’t good enough also for all of the teams.

62 00:06:38.770 00:06:42.270 Mustafa Raja: So, could we have them, you know…

63 00:06:42.370 00:06:46.629 Mustafa Raja: Do something about this stitching, or do we need to figure that out also?

64 00:06:49.570 00:06:52.599 Uttam Kumaran: But is that step half of an S3 or in Catalyst?

65 00:06:53.540 00:07:03.199 Mustafa Raja: So the tables we have right now, the team table we have right now, does not have a Salesforce ID, right?

66 00:07:04.670 00:07:05.370 Uttam Kumaran: Okay.

67 00:07:06.120 00:07:13.570 Mustafa Raja: And we need, we need a common identifier. But how did, how did you get, how did you get the Salesforce IDs for the test?

68 00:07:14.610 00:07:16.959 Mustafa Raja: Yeah, I manually switched them.

69 00:07:19.080 00:07:21.129 Uttam Kumaran: Oh, but… you can do in SQL.

70 00:07:21.600 00:07:22.800 Uttam Kumaran: And dbt.

71 00:07:27.510 00:07:33.089 Mustafa Raja: Hmm… Yeah, but I got that from Salesforce itself, though, right?

72 00:07:33.220 00:07:33.900 Mustafa Raja: Isn’t quite…

73 00:07:33.900 00:07:38.379 Uttam Kumaran: Oh, you’re saying… yeah, so we’ll have to land data from Salesforce into the mother duck.

74 00:07:38.380 00:07:40.260 Mustafa Raja: Oh, yeah, yeah, yeah.

75 00:07:40.970 00:07:41.740 Mustafa Raja: I can work.

76 00:07:41.740 00:07:42.620 Uttam Kumaran: I can work…

77 00:07:56.110 00:08:00.019 Uttam Kumaran: Yeah, I mean, basically, I mean, I can tell that to,

78 00:08:00.600 00:08:10.300 Uttam Kumaran: We can do that in a number of different ways, so that’s not a problem. But for now, again, you can just test with a manual export. The goal here is to solve the S3 problem.

79 00:08:10.570 00:08:19.760 Uttam Kumaran: We can land more data into Mother Duck and do more transformations in Mother Duck, but the piece to get right here is that they set up S3 and the connector in a correct way.

80 00:08:20.040 00:08:22.750 Mustafa Raja: Yeah, I’ll just edit this document then for…

81 00:08:23.080 00:08:28.219 Mustafa Raja: For a step-by-step instructions on how to get this test running then.

82 00:08:30.430 00:08:33.630 Mustafa Raja: Yeah, I thought we were doing it as SOW, sorry.

83 00:08:33.860 00:08:35.160 Uttam Kumaran: No, no, all good.

84 00:08:37.000 00:08:37.720 Mustafa Raja: Yeah.

85 00:08:37.960 00:08:40.670 Mustafa Raja: I’ll do this, tomorrow then.

86 00:08:43.090 00:08:43.669 Uttam Kumaran: Okay.

87 00:08:46.230 00:08:50.660 Mustafa Raja: Yep, for the rest of the day, I was, so we had an auth bug.

88 00:08:50.840 00:08:52.690 Mustafa Raja: I looked into that.

89 00:08:53.200 00:08:56.739 Mustafa Raja: I believe, Michael…

90 00:08:57.000 00:09:02.480 Mustafa Raja: We have a new member, try to log in, and, he couldn’t… that is how…

91 00:09:03.150 00:09:04.010 Mustafa Raja: Okay, Mickey.

92 00:09:04.010 00:09:05.500 Uttam Kumaran: Oh, okay, yeah.

93 00:09:06.230 00:09:12.199 Mustafa Raja: So, that is how we found out, and then, I pinged the team, and…

94 00:09:12.450 00:09:17.800 Mustafa Raja: We found the issue, and resolved that, and…

95 00:09:18.050 00:09:25.450 Mustafa Raja: Apart from that, I worked on some… Internal, stuff.

96 00:09:26.620 00:09:27.290 Uttam Kumaran: Okay.

97 00:09:27.870 00:09:28.490 Mustafa Raja: Yeah.

98 00:09:28.810 00:09:31.870 Mustafa Raja: I’m going to work a little more on internal stuff for the day.

99 00:09:32.880 00:09:33.540 Uttam Kumaran: Okay.

100 00:09:33.730 00:09:34.810 Uttam Kumaran: Yeah, I don’t…

101 00:09:35.310 00:09:40.249 Uttam Kumaran: Anyone else? I think other folks, I’m not sure who else is on, but it might just be us.

102 00:09:42.130 00:09:44.000 Mustafa Raja: Mmm, yeah.

103 00:09:46.040 00:09:48.490 Mustafa Raja: This is… this is nice, actually, huh?

104 00:09:49.060 00:09:51.270 Mustafa Raja: This… and…

105 00:09:54.150 00:10:01.090 Mustafa Raja: I couldn’t have gotten this FaceTime with you, and I would just be, you know, yeah, SOW is ready.

106 00:10:05.230 00:10:08.930 Uttam Kumaran: No, I agree. I like to do this, too. I’m gonna… I’m gonna hang on. I have a meeting…

107 00:10:09.670 00:10:11.909 Uttam Kumaran: I have 2 more meetings after this, so…

108 00:10:13.000 00:10:14.230 Mustafa Raja: That’s a long day.

109 00:10:15.460 00:10:19.489 Uttam Kumaran: Yeah, long day, dude. Looks like one more client is gonna sign, though.

110 00:10:20.090 00:10:24.589 Mustafa Raja: Oh, that’s super nice. A lot of… the clients are, like, pouring in, right?

111 00:10:25.430 00:10:29.789 Uttam Kumaran: I know, but it’s so pain… it’s just so much work, dude, I haven’t slept at all.

112 00:10:30.580 00:10:33.399 Uttam Kumaran: I feel, like, tired just, like, being awake.

113 00:10:34.230 00:10:34.810 Mustafa Raja: Oh.

114 00:10:36.350 00:10:39.829 Mustafa Raja: Did the… did the README meeting go through?

115 00:10:40.590 00:10:44.980 Uttam Kumaran: Yeah, it went well. It was really good, so I appreciate your work.

116 00:10:44.980 00:10:53.120 Mustafa Raja: Oh, thanks. Yeah, it was first… it was like, I was working with MongoDB after a very long time, so it was nice.

117 00:10:53.460 00:10:55.979 Mustafa Raja: Getting… getting back into that phase.

118 00:10:57.690 00:11:00.639 Mustafa Raja: I was a big fan of NoSQL back in the day.

119 00:11:00.960 00:11:01.680 Mustafa Raja: When I say.

120 00:11:01.680 00:11:02.190 Uttam Kumaran: study.

121 00:11:03.280 00:11:05.250 Mustafa Raja: And I’m not anymore.

122 00:11:06.420 00:11:09.070 Mustafa Raja: Sql is much better, maybe.

123 00:11:10.150 00:11:11.170 Mustafa Raja: What do you think?

124 00:11:12.080 00:11:13.510 Uttam Kumaran: I love SQL.

125 00:11:47.150 00:11:52.670 Uttam Kumaran: Yeah, we have… we have Element signing, and we have this other client signing, too, so…

126 00:11:56.800 00:11:58.389 Mustafa Raja: What’s the other one?

127 00:11:59.540 00:12:01.179 Uttam Kumaran: Lilo Social.

128 00:12:01.460 00:12:03.739 Mustafa Raja: Oh, yeah. That’s nice.

129 00:12:06.830 00:12:14.650 Rico Rejoso: Yeah, are they gonna be… do you have, do you have the agreement for, like, contract yet for Belo Social?

130 00:12:15.450 00:12:18.089 Uttam Kumaran: Yeah, I guess I can tell you,

131 00:12:20.940 00:12:24.999 Uttam Kumaran: Well, we basically said the 30K, and then…

132 00:12:25.410 00:12:28.880 Uttam Kumaran: What is the… what does the SOW say?

133 00:12:30.240 00:12:41.870 Rico Rejoso: It says you have two options, which is the phase one only for 10K fixed, and the other one for full build for 30K… 10K for 3 months.

134 00:12:42.950 00:12:49.229 Uttam Kumaran: Yeah, I would like to do the, the 10K for 3 months.

135 00:12:50.920 00:12:51.500 Rico Rejoso: Yeah.

136 00:12:52.510 00:13:00.400 Rico Rejoso: They haven’t confirmed yet, right? So, I’ll… Yeah. But I basically have the contract prepared and everything, just let me know, or reply to the comment.

137 00:13:00.580 00:13:01.150 Rico Rejoso: Once that.

138 00:13:01.150 00:13:02.070 Uttam Kumaran: Okay, okay.

139 00:13:02.760 00:13:04.190 Uttam Kumaran: Yeah, I just called them.

140 00:13:04.340 00:13:05.500 Uttam Kumaran: Before this.

141 00:13:06.510 00:13:11.249 Uttam Kumaran: Sure. Yeah, dude, but clients… but… Rico, what do you think? Look how many deals are coming in.

142 00:13:11.890 00:13:16.010 Rico Rejoso: Like, we… just this month, we signed, like, around 4 already.

143 00:13:16.550 00:13:17.960 Uttam Kumaran: Crazy, dude.

144 00:13:18.290 00:13:22.839 Rico Rejoso: The crazy part will be this coming December, since I think most of them are long-term.

145 00:13:24.660 00:13:27.819 Mustafa Raja: Yeah, that’s super nice. Brain food is growing.

146 00:13:28.430 00:13:29.779 Mustafa Raja: I love to hear this.

147 00:13:30.010 00:13:36.409 Uttam Kumaran: Rico and I are the only ones up late and early, I feel like.

148 00:13:36.410 00:13:38.179 Mustafa Raja: I work until my eyes close.

149 00:13:38.180 00:13:40.729 Uttam Kumaran: I work until my eyes close.

150 00:13:40.900 00:13:46.339 Uttam Kumaran: And I’m always sending something in Slack, like, okay, I call these guys, they’re ready, or this is ready.

151 00:13:46.840 00:13:49.299 Mustafa Raja: Yeah, I’m sometimes up early.

152 00:13:49.710 00:14:00.280 Mustafa Raja: So, like, 12 p.m. or, 1pm or 2PM my time, and I’m, I open up Slack, and I see you online.

153 00:14:00.450 00:14:02.679 Mustafa Raja: And then I wonder, when do you sleep?

154 00:14:03.140 00:14:07.419 Rico Rejoso: Yeah, yesterday, Utah was online until 12 AM.

155 00:14:07.830 00:14:09.700 Rico Rejoso: Central Day? Yeah.

156 00:14:09.830 00:14:11.679 Uttam Kumaran: I’m working hard for you guys.

157 00:14:12.190 00:14:13.420 Uttam Kumaran: I’m trying my best.

158 00:14:14.680 00:14:22.510 Uttam Kumaran: I want it to be a good… I wanna… I mean, I was gonna tell everybody, but I wanna try to figure out some type of Christmas gifts for everybody, so I’m planning something.

159 00:14:22.510 00:14:23.789 Mustafa Raja: That’s super nice.

160 00:14:25.060 00:14:29.209 Uttam Kumaran: I don’t know, I know in the Philippines, there’s a big Christmas celebration, right, usually?

161 00:14:29.430 00:14:33.149 Rico Rejoso: Yeah, we’re… we’re celebrating it from September to December.

162 00:14:35.580 00:14:36.580 Mustafa Raja: that long.

163 00:14:36.580 00:14:37.520 Uttam Kumaran: That’s funny.

164 00:14:37.770 00:14:38.590 Rico Rejoso: We just…

165 00:14:38.780 00:14:46.640 Rico Rejoso: When it’s, you know, Halloween, because we are a very religious country. November 1 and 2, we don’t do a Christmas suck, just…

166 00:14:46.910 00:14:48.539 Rico Rejoso: Saint Soul stuff.

167 00:14:51.340 00:14:52.820 Uttam Kumaran: That makes sense.

168 00:14:58.080 00:15:06.000 Uttam Kumaran: Yeah, and so tomorrow is a friend… friend of mine has, her birthday party, so we’re going to a birthday party. They’re going… we’re going dancing, so I’m gonna…

169 00:15:08.480 00:15:09.099 Rico Rejoso: It’s nice.

170 00:15:09.100 00:15:10.120 Mustafa Raja: Did you dance?

171 00:15:10.670 00:15:12.470 Uttam Kumaran: And I know, I don’t dance at all, guys.

172 00:15:12.470 00:15:12.820 Mustafa Raja: Anyhow.

173 00:15:12.820 00:15:14.250 Uttam Kumaran: Oh, damn.

174 00:15:14.250 00:15:14.960 Mustafa Raja: What dangles.

175 00:15:15.730 00:15:18.570 Mustafa Raja: Yeah, why not?

176 00:15:19.840 00:15:23.480 Uttam Kumaran: I’m just tired, and I’m dead, I’m sorry. No happiness.

177 00:15:26.240 00:15:28.020 Uttam Kumaran: Happiness is data.

178 00:15:28.200 00:15:30.769 Uttam Kumaran: I can just work on my data, I’d be happy.

179 00:15:31.390 00:15:32.590 Mustafa Raja: No.

180 00:15:32.720 00:15:34.620 Mustafa Raja: SQL makes us happy.

181 00:15:35.360 00:15:37.529 Uttam Kumaran: Yeah, I used to dream in a…

182 00:15:37.530 00:15:40.500 Mustafa Raja: No way.

183 00:15:40.500 00:15:47.099 Uttam Kumaran: I would be writing so much. All day, I’d be writing SQL, and I would just be thinking about it, like…

184 00:15:48.660 00:15:50.850 Uttam Kumaran: So stupid, so sad.

185 00:15:52.990 00:15:53.859 Uttam Kumaran: You know?

186 00:21:39.420 00:21:44.610 Mustafa Raja: Okay, then, I’m gonna go get a snack, and then… Get back on.

187 00:21:44.610 00:21:45.240 Uttam Kumaran: Alright.

188 00:21:46.660 00:21:47.300 Mustafa Raja: Thank you.

189 00:21:47.300 00:21:49.529 Uttam Kumaran: Alright, thanks you guys. Talk to you soon.

190 00:21:50.030 00:21:51.210 Uttam Kumaran: Okay, bye.