Meeting Title: DE-Planning-Session Date: 2024-07-15 Meeting participants: Nicolas Sucari, Uttam Kumaran, Atharv Gudi, Patrick Trainer


WEBVTT

1 00:02:47.610 00:02:48.600 Uttam Kumaran: Hey darf!

2 00:02:51.140 00:02:52.600 Atharv Gudi: Hey? How’s it going.

3 00:02:52.600 00:02:53.920 Uttam Kumaran: Hey? Good! How are you?

4 00:02:54.070 00:02:55.180 Atharv Gudi: Good, good.

5 00:02:56.210 00:02:59.149 Uttam Kumaran: How’s the how’s last week? How’s this weekend.

6 00:02:59.150 00:03:04.419 Atharv Gudi: It was good. I managed to get the other Pr. As well done.

7 00:03:04.640 00:03:06.179 Uttam Kumaran: Nice. Yeah. I saw that.

8 00:03:06.180 00:03:07.979 Atharv Gudi: Yeah. So Patrick’s now

9 00:03:08.090 00:03:11.759 Atharv Gudi: decided that we are. He’s gonna come up with new stuff for me.

10 00:03:12.110 00:03:14.282 Uttam Kumaran: Cool. Yeah, I think we’re gonna talk about that today.

11 00:03:15.690 00:03:16.470 Atharv Gudi: Okay.

12 00:03:17.520 00:03:18.620 Atharv Gudi: Yow.

13 00:03:19.790 00:03:33.449 Uttam Kumaran: What have you thought about that testing work, or what do you think? You know, after getting that done about like stuff? You’re I don’t know. I think we’ll walk through a couple of things that are still on TV play. But what do you think about like the de work? So far.

14 00:03:34.490 00:03:36.300 Atharv Gudi: I don’t know. I think it’s been.

15 00:03:36.760 00:03:39.519 Atharv Gudi: I can see why

16 00:03:39.680 00:03:43.330 Atharv Gudi: I mean, I see where d work comes into the whole.

17 00:03:44.060 00:03:46.540 Atharv Gudi: you know, process of things

18 00:03:47.270 00:03:48.430 Atharv Gudi: they’re going.

19 00:03:51.090 00:03:52.429 Atharv Gudi: I’ve I’ve definitely.

20 00:03:52.430 00:03:54.339 Uttam Kumaran: It’s definitely like more engineering. But.

21 00:03:54.340 00:03:55.330 Atharv Gudi: Yeah, Dominic.

22 00:03:56.000 00:04:00.979 Atharv Gudi: it also does. I? I feel like it’s still gonna take a while longer for me to get to see

23 00:04:01.890 00:04:05.240 Atharv Gudi: what real obstacles can

24 00:04:05.470 00:04:08.660 Atharv Gudi: come in the way of getting work done.

25 00:04:09.100 00:04:10.320 Uttam Kumaran: Yeah, makes sense.

26 00:04:11.330 00:04:15.651 Uttam Kumaran: Yeah, I’m glad I I saw that you and Patrick are spending more time. So

27 00:04:16.540 00:04:19.798 Uttam Kumaran: I’m happy about that cause. I come in and out of stuff.

28 00:04:20.079 00:04:20.729 Atharv Gudi: Hmm.

29 00:04:21.029 00:04:23.149 Uttam Kumaran: But you know, if you guys can.

30 00:04:23.229 00:04:25.552 Uttam Kumaran: you know, do pair programming and

31 00:04:26.019 00:04:28.559 Uttam Kumaran: you know, you can ask them questions. It’s a

32 00:04:29.089 00:04:30.409 Uttam Kumaran: really really valuable.

33 00:04:31.290 00:04:32.210 Atharv Gudi: Yeah, I’ve been out.

34 00:04:32.440 00:04:34.799 Uttam Kumaran: It’s tough. It’s tough, remote, because we don’t have like.

35 00:04:35.060 00:04:39.785 Uttam Kumaran: You’re not like sitting right next to this person. So you kind of have to think a little bit ahead. But

36 00:04:40.570 00:04:42.169 Uttam Kumaran: yeah, I’d encourage that.

37 00:04:42.710 00:04:45.319 Atharv Gudi: We’re still able to get work done.

38 00:04:45.370 00:04:48.248 Atharv Gudi: I’ve been kind of together, I mean.

39 00:04:48.870 00:04:49.770 Atharv Gudi: with.

40 00:04:50.030 00:04:53.950 Atharv Gudi: I’ve been trying to experiment with other kinds of stuff like

41 00:04:54.000 00:04:56.860 Atharv Gudi: writing scripts instead of manually

42 00:04:57.070 00:04:58.400 Atharv Gudi: doing stuff

43 00:04:58.630 00:05:00.340 Atharv Gudi: to compile 5.

44 00:05:00.870 00:05:02.680 Atharv Gudi: And for Pat it’s been

45 00:05:03.370 00:05:09.650 Atharv Gudi: help there. I’ve he’s been able to. I mean, we really, I think last week we just had a call

46 00:05:11.090 00:05:17.860 Atharv Gudi: actually, immediately after last week’s D meeting, and then got everything sorted for the rest of the week.

47 00:05:19.340 00:05:23.279 Atharv Gudi: So we’re able to think. I think the both of us were able to do stuff.

48 00:05:24.730 00:05:25.840 Uttam Kumaran: Nice, I think.

49 00:05:26.240 00:05:30.389 Uttam Kumaran: Yeah, I think there’s 1 or 2 tasks this week that I think will be

50 00:05:30.590 00:05:35.579 Uttam Kumaran: interesting, kind of like, similarly, and like kind of code optimization style optimization

51 00:05:35.840 00:05:38.610 Uttam Kumaran: that we we really like just need

52 00:05:39.343 00:05:42.749 Uttam Kumaran: so we’ll see. Let me let me check. He’s gonna be joining.

53 00:05:44.290 00:05:45.170 Nicolas Sucari: Hey, guys.

54 00:05:46.860 00:05:47.700 Uttam Kumaran: Tape.

55 00:05:47.700 00:05:48.680 Atharv Gudi: Hello!

56 00:05:49.585 00:05:50.100 Patrick Trainer: Hey!

57 00:05:50.530 00:05:51.230 Uttam Kumaran: Hey! Pat!

58 00:05:53.400 00:05:54.260 Patrick Trainer: How’s it going.

59 00:05:55.760 00:05:57.059 Uttam Kumaran: Good! How are you?

60 00:05:57.560 00:05:58.810 Patrick Trainer: Not too bad.

61 00:06:02.860 00:06:06.980 Uttam Kumaran: Great stuff for this week. I guess I wanted to.

62 00:06:07.090 00:06:12.290 Uttam Kumaran: Maybe we can start talking about stuff for a Thor. But I mean, I know. Mainly

63 00:06:12.660 00:06:16.143 Uttam Kumaran: last week, Pat, we were thinking about stuff for

64 00:06:16.830 00:06:18.232 Uttam Kumaran: we’re thinking about

65 00:06:19.730 00:06:26.520 Uttam Kumaran: the what’s it called the linters like having Dbt and sequel winters.

66 00:06:27.195 00:06:27.580 Patrick Trainer: Case.

67 00:06:27.880 00:06:30.239 Uttam Kumaran: I’m seeing now on the de board.

68 00:06:30.890 00:06:32.269 Uttam Kumaran: Here, let’s share.

69 00:06:34.870 00:06:39.790 Uttam Kumaran: We had this establish our back. It’s not like a high. It’s not the highest priority thing.

70 00:06:40.536 00:06:42.420 Uttam Kumaran: I do think the Dbt

71 00:06:43.140 00:06:46.450 Uttam Kumaran: and SQL. Enters would be nice, because we would immediately

72 00:06:46.860 00:06:48.849 Uttam Kumaran: put that on all repos, basically

73 00:06:49.941 00:06:52.819 Uttam Kumaran: and that could probably start to enforce

74 00:06:53.360 00:06:53.950 Uttam Kumaran: right?

75 00:06:55.340 00:06:57.000 Uttam Kumaran: you know, stuff so.

76 00:06:57.860 00:07:01.776 Patrick Trainer: Yeah, I think that’s a good idea, I think.

77 00:07:02.830 00:07:06.390 Patrick Trainer: I mean using like SQL. Fluff

78 00:07:06.580 00:07:07.410 Patrick Trainer: for SQL.

79 00:07:09.430 00:07:10.870 Patrick Trainer: not sure about.

80 00:07:11.230 00:07:14.050 Patrick Trainer: There’s anything for Dvt to lint that

81 00:07:15.770 00:07:18.270 Uttam Kumaran: I think SQL, Fluff would just be the whole thing. Basically.

82 00:07:18.270 00:07:25.320 Patrick Trainer: Yeah. Yeah. So I I think, like getting that set up configured, etc.

83 00:07:25.320 00:07:28.720 Uttam Kumaran: And then for yaml files, too. Or maybe we can use black.

84 00:07:31.230 00:07:32.930 Patrick Trainer: There is.

85 00:07:36.130 00:07:38.249 Patrick Trainer: There is a yamlinter

86 00:07:38.390 00:07:39.170 Patrick Trainer: that

87 00:07:39.860 00:07:41.549 Patrick Trainer: I can’t remember the name of.

88 00:07:41.630 00:07:43.390 Patrick Trainer: I think it’s called Yaml lint

89 00:07:46.980 00:07:49.740 Patrick Trainer: and what is it.

90 00:07:49.740 00:07:53.779 Uttam Kumaran: Yeah, I’ve just used black before, which is just like a python code formatter.

91 00:07:54.720 00:07:55.230 Patrick Trainer: It works for.

92 00:07:55.230 00:07:56.070 Uttam Kumaran: Bible.

93 00:07:56.500 00:07:57.534 Uttam Kumaran: Well,

94 00:07:59.170 00:08:03.340 Uttam Kumaran: yeah, isn’t yaml like part of the python, spec or no? Is it just like a.

95 00:08:03.340 00:08:05.059 Patrick Trainer: No, no, no

96 00:08:06.350 00:08:08.830 Patrick Trainer: Yaml’s part of the

97 00:08:10.340 00:08:12.180 Patrick Trainer: Json spec. It’s a.

98 00:08:12.180 00:08:13.480 Uttam Kumaran: Super Solid Json.

99 00:08:13.710 00:08:14.034 Patrick Trainer: Yeah.

100 00:08:15.422 00:08:17.120 Uttam Kumaran: So we just use something like this, maybe.

101 00:08:18.110 00:08:19.380 Patrick Trainer: Sorry I’m not.

102 00:08:20.300 00:08:21.329 Uttam Kumaran: Guess this is.

103 00:08:21.470 00:08:23.230 Uttam Kumaran: it’s like a random package, but.

104 00:08:26.700 00:08:27.910 Patrick Trainer: Yeah.

105 00:08:32.150 00:08:33.559 Patrick Trainer: And then.

106 00:08:36.409 00:08:38.059 Patrick Trainer: yeah, we can figure that out.

107 00:08:38.110 00:08:39.330 Patrick Trainer: Gamal lint.

108 00:08:40.860 00:08:41.960 Patrick Trainer: a.

109 00:08:43.510 00:08:44.890 Uttam Kumaran: Yeah, that would be

110 00:08:44.960 00:08:46.889 Uttam Kumaran: my suggestion.

111 00:08:47.810 00:08:48.890 Patrick Trainer: Alright!

112 00:08:49.140 00:08:52.130 Patrick Trainer: Let me do that, and then

113 00:08:53.400 00:08:54.570 Patrick Trainer: a

114 00:08:55.730 00:08:58.730 Patrick Trainer: but I made it something last

115 00:08:59.110 00:09:00.390 Patrick Trainer: week.

116 00:09:02.180 00:09:02.880 Uttam Kumaran: So

117 00:09:03.723 00:09:05.979 Uttam Kumaran: the linter would both

118 00:09:06.110 00:09:07.542 Uttam Kumaran: would do both

119 00:09:08.460 00:09:15.499 Uttam Kumaran: like, is it gonna commit commit changes, or like, how does it actually work right before you push your Pr. You should run the.

120 00:09:15.690 00:09:20.719 Patrick Trainer: Yeah, you, we can set it as like like, we can get pre commit

121 00:09:21.240 00:09:21.780 Patrick Trainer: set up.

122 00:09:21.780 00:09:22.999 Uttam Kumaran: Cox, okay, yeah.

123 00:09:23.373 00:09:27.480 Patrick Trainer: Yeah, like, pre commit hooks. And basically what it’ll do, it’ll

124 00:09:28.425 00:09:30.300 Patrick Trainer: like validate it.

125 00:09:30.490 00:09:35.190 Patrick Trainer: And so, like, we, we can do 2 things. We can either have it.

126 00:09:36.305 00:09:37.130 Patrick Trainer: Format!

127 00:09:37.500 00:09:40.274 Patrick Trainer: And validate itself

128 00:09:41.460 00:09:42.700 Patrick Trainer: and then

129 00:09:43.740 00:09:46.149 Patrick Trainer: have it go there, or

130 00:09:46.280 00:09:50.749 Patrick Trainer: we you can have it like, reject the commit altogether

131 00:09:50.960 00:09:52.429 Patrick Trainer: until this.

132 00:09:52.430 00:09:54.400 Uttam Kumaran: To suggest changes. Okay?

133 00:09:55.070 00:09:56.000 Uttam Kumaran: Right?

134 00:09:56.100 00:09:57.859 Uttam Kumaran: I mean, I would go to the 1st route.

135 00:09:59.910 00:10:02.534 Patrick Trainer: Right right right right

136 00:10:08.420 00:10:14.370 Nicolas Sucari: I think. There is like a chrome extent not chrome sorry. Vs code extension of

137 00:10:14.560 00:10:15.590 Nicolas Sucari: Leinter.

138 00:10:15.970 00:10:17.399 Nicolas Sucari: do we? That it’s

139 00:10:17.480 00:10:21.840 Nicolas Sucari: also something we can use. I don’t know about that, Patrick. Maybe you know a little bit more.

140 00:10:21.840 00:10:24.220 Patrick Trainer: Yeah, yeah, I mean, so like, I

141 00:10:24.480 00:10:25.632 Patrick Trainer: use those

142 00:10:27.390 00:10:28.550 Patrick Trainer: it’s just

143 00:10:28.840 00:10:31.889 Patrick Trainer: the only thing is like you. You have to remember

144 00:10:32.120 00:10:32.680 Patrick Trainer: to.

145 00:10:32.680 00:10:33.030 Nicolas Sucari: Okay.

146 00:10:33.030 00:10:33.950 Patrick Trainer: To do it.

147 00:10:34.520 00:10:35.750 Nicolas Sucari: Terrain.

148 00:10:35.750 00:10:37.720 Patrick Trainer: Which, like that’s not that

149 00:10:38.620 00:10:46.329 Patrick Trainer: big of an issue, but like the the more automated way is just to like it allows you to.

150 00:10:47.240 00:10:50.100 Patrick Trainer: I don’t know. Push whatever I

151 00:10:50.120 00:10:52.030 Patrick Trainer: if the

152 00:10:56.140 00:11:01.230 Patrick Trainer: if the yamls, I’m trying to think like if the yaml is like totally misconfigured.

153 00:11:01.460 00:11:03.860 Patrick Trainer: what happens in that case?

154 00:11:07.230 00:11:09.000 Patrick Trainer: it’ll probably just not accept.

155 00:11:09.000 00:11:11.100 Uttam Kumaran: That. Yeah, that won’t. It? Just won’t run.

156 00:11:11.300 00:11:12.030 Patrick Trainer: Yeah, it. It.

157 00:11:12.030 00:11:14.839 Uttam Kumaran: We have, we have the specific, we have the specific

158 00:11:16.440 00:11:25.189 Uttam Kumaran: like, yeah, I guess, like, the only yaml stuff we need is for elementary and then for real. And then for both of those, we’re gonna have

159 00:11:25.220 00:11:29.820 Uttam Kumaran: their own specific validation steps when those files are so.

160 00:11:29.820 00:11:30.330 Patrick Trainer: Right.

161 00:11:30.330 00:11:38.829 Uttam Kumaran: Even if you’re like, even if your like, Yaml is bad and it just gets formatted. It won’t execute when we run those validations.

162 00:11:40.780 00:11:42.220 Patrick Trainer: Right right

163 00:11:45.705 00:11:46.200 Patrick Trainer: k.

164 00:11:50.100 00:11:52.230 Uttam Kumaran: And then so this would just be a Github action, right?

165 00:11:52.490 00:11:55.900 Uttam Kumaran: Or actually, I don’t know. I’ll kinda let you guys probably figure out how to

166 00:11:56.290 00:11:58.050 Uttam Kumaran: actually execute this.

167 00:11:58.230 00:12:00.080 Patrick Trainer: Yeah, it’d be.

168 00:12:00.110 00:12:02.260 Patrick Trainer: I mean, it either be like

169 00:12:03.810 00:12:06.860 Patrick Trainer: in action on deploy or

170 00:12:07.475 00:12:09.789 Patrick Trainer: or just like a pre-commit hook.

171 00:12:10.590 00:12:13.409 Patrick Trainer: I think pre-commits probably.

172 00:12:15.810 00:12:17.429 Uttam Kumaran: It’s probably pre-commit hook.

173 00:12:18.010 00:12:20.150 Patrick Trainer: Yeah, I think pre-commit would be

174 00:12:20.750 00:12:21.820 Patrick Trainer: the better

175 00:12:22.450 00:12:23.640 Patrick Trainer: of the 2.

176 00:12:24.110 00:12:24.860 Uttam Kumaran: Yeah.

177 00:12:25.150 00:12:27.769 Uttam Kumaran: Yeah. Then I again, I would prefer because

178 00:12:28.380 00:12:29.850 Uttam Kumaran: we’re gonna

179 00:12:30.200 00:12:31.790 Uttam Kumaran: I mean, like

180 00:12:32.010 00:12:36.780 Uttam Kumaran: Pat, it’s all data people. So for linting and stuff like this is going to be flow before end.

181 00:12:37.400 00:12:38.700 Uttam Kumaran: On average.

182 00:12:39.059 00:12:42.200 Uttam Kumaran: I want this just to be something that comes out of the box for everybody

183 00:12:42.350 00:12:44.900 Uttam Kumaran: like I think longer term. We will

184 00:12:45.330 00:12:47.300 Uttam Kumaran: like we can think about ways of.

185 00:12:47.450 00:12:52.689 Uttam Kumaran: you know, just I mean, of course, like, the reason for this is just so we can enforce styling and things like that.

186 00:12:52.730 00:12:54.560 Uttam Kumaran: But hopefully, this actually takes

187 00:12:55.070 00:12:56.860 Uttam Kumaran: takes care of like

188 00:12:57.510 00:13:03.859 Uttam Kumaran: just a whole, like a subset of issues that typically comes from just like badly formatted. The animal and stuff that I know is really annoying.

189 00:13:04.480 00:13:05.070 Patrick Trainer: Right.

190 00:13:05.070 00:13:07.359 Uttam Kumaran: And this just becomes part of our platform. So.

191 00:13:07.670 00:13:08.480 Patrick Trainer: Right?

192 00:13:09.420 00:13:10.550 Patrick Trainer: Yeah, I mean, we all.

193 00:13:10.550 00:13:13.714 Uttam Kumaran: Also, we also established the naming convention and

194 00:13:14.430 00:13:17.810 Uttam Kumaran: like style format rules already. So like, basically.

195 00:13:17.870 00:13:23.510 Uttam Kumaran: the a team will own, like, what does stuff need to actually look like. And then we’ll use this to enforce

196 00:13:23.770 00:13:24.820 Uttam Kumaran: the rules.

197 00:13:25.610 00:13:30.219 Patrick Trainer: Okay, yeah, yeah. I think the yeah, that that sounds good.

198 00:13:30.780 00:13:32.230 Patrick Trainer: I think the

199 00:13:33.030 00:13:40.210 Patrick Trainer: like the higher of the 2. Like, if I had to pick one like sequel or yaml. It would be the sequel.

200 00:13:40.550 00:13:41.190 Uttam Kumaran: Yeah, for sure.

201 00:13:41.190 00:13:44.480 Patrick Trainer: To? Yeah, just to, so that we have

202 00:13:44.510 00:13:46.180 Patrick Trainer: consistent format

203 00:13:48.090 00:13:50.809 Patrick Trainer: as well as. And so they’ve they’ve

204 00:13:50.870 00:13:53.620 Patrick Trainer: came up with naming conventions and everything too.

205 00:13:54.110 00:13:58.619 Uttam Kumaran: Yeah, we have a. We have a document on that again, like, that’s

206 00:13:58.670 00:14:03.449 Uttam Kumaran: the documents are only helpful as a guide now. But I would like that to get enforced.

207 00:14:03.510 00:14:04.194 Uttam Kumaran: Yeah,

208 00:14:04.880 00:14:06.750 Patrick Trainer: Yeah, so, okay.

209 00:14:08.810 00:14:11.780 Uttam Kumaran: And and doing it, doing it on a pre-commit hook.

210 00:14:12.040 00:14:12.734 Uttam Kumaran: And

211 00:14:15.180 00:14:18.650 Uttam Kumaran: yeah, I don’t know how it’s gonna handle like renaming things. But

212 00:14:18.780 00:14:23.189 Uttam Kumaran: here’s an example like if someone’s committing stuff. And they’re like, Oh, it’s not working.

213 00:14:23.410 00:14:24.770 Uttam Kumaran: Basically

214 00:14:24.990 00:14:29.209 Uttam Kumaran: one of the alerts. One of the kind of errors now will be like your formatting is wrong.

215 00:14:29.280 00:14:32.699 Uttam Kumaran: And that way it guides people to kind of go to that, Doc, and say, like, Okay, how do I format.

216 00:14:32.700 00:14:33.340 Patrick Trainer: Right. I mean.

217 00:14:33.340 00:14:34.400 Uttam Kumaran: And things like that

218 00:14:34.550 00:14:36.839 Uttam Kumaran: right? I don’t know if that’s part of this

219 00:14:38.740 00:14:40.250 Uttam Kumaran: like will SQL. Fluff

220 00:14:40.860 00:14:42.489 Uttam Kumaran: handle like yell

221 00:14:43.000 00:14:44.529 Uttam Kumaran: if you’re like column

222 00:14:45.020 00:14:47.569 Uttam Kumaran: has like dashes. For example.

223 00:14:49.550 00:14:50.620 Patrick Trainer: Add.

224 00:14:51.740 00:14:54.380 Uttam Kumaran: Or like, if it’s not camel, or if it’s like camel case.

225 00:14:54.400 00:14:56.249 Uttam Kumaran: that’s the kind of stuff that like maybe is like, well.

226 00:14:56.250 00:15:00.619 Patrick Trainer: Yeah, there’s there’s so there’s rules that you can set.

227 00:15:01.595 00:15:04.869 Patrick Trainer: I imagine. So like, that’s

228 00:15:07.040 00:15:14.430 Patrick Trainer: like, you can change that like in in black, or any of the other like python linters. So I imagine

229 00:15:14.660 00:15:17.030 Patrick Trainer: that SQL. Fluff is similar.

230 00:15:19.600 00:15:25.371 Uttam Kumaran: Yeah. And I think there’s like a in in the Dbt slack. There’s a pretty big. There’s a channel on

231 00:15:26.520 00:15:27.260 Uttam Kumaran: People fall.

232 00:15:27.260 00:15:28.869 Patrick Trainer: Golf, itself, yeah.

233 00:15:29.160 00:15:29.609 Uttam Kumaran: Yeah.

234 00:15:39.100 00:15:42.289 Uttam Kumaran: I remember joining that like a couple of years ago.

235 00:15:42.290 00:15:43.240 Patrick Trainer: Right.

236 00:15:47.610 00:15:53.475 Uttam Kumaran: Okay, I guess afar is this kind of make sense? I know we’re kind of talking a little bit all over the place, but

237 00:15:53.900 00:15:56.870 Uttam Kumaran: It may require a a little bit of time between

238 00:15:57.070 00:16:05.799 Uttam Kumaran: you and Pat would. Probably you can start initially by just researching some of these tools and kind of like, what linting is that’ll give you a good sense of

239 00:16:06.340 00:16:08.910 Uttam Kumaran: like, why, basically, why, we’re doing this

240 00:16:09.477 00:16:15.209 Uttam Kumaran: and if you can articulate that, then then it’s basically, where do we kind of like write

241 00:16:15.500 00:16:19.620 Uttam Kumaran: a SQL fuck code? And then actually, how does it get the process of executing it?

242 00:16:19.880 00:16:22.230 Uttam Kumaran: As like right before people commit code.

243 00:16:22.850 00:16:24.780 Atharv Gudi: Yeah, I get

244 00:16:25.270 00:16:32.469 Atharv Gudi: a general idea of it. I don’t think I can fully get my head around how to specifically go about it yet. But I get the idea.

245 00:16:32.930 00:16:37.949 Uttam Kumaran: Cool. Yeah, no, take your time. But I think this will give you a good sense of like

246 00:16:38.080 00:16:40.029 Uttam Kumaran: we enforce code quality.

247 00:16:40.200 00:16:41.280 Uttam Kumaran: And

248 00:16:41.500 00:16:48.480 Uttam Kumaran: again, how do we try to avoid a subset of issues that kind of happens with which is just like formatting code and making sure it can execute

249 00:16:49.434 00:16:54.120 Uttam Kumaran: and then also kind of bring you a little bit into the world of like the stuff we’re trying to

250 00:16:54.230 00:16:59.249 Uttam Kumaran: automate, enforce using github actions and like, pre commit hooks and stuff like that. So I think this will be great.

251 00:17:00.240 00:17:01.070 Uttam Kumaran: Okay.

252 00:17:07.280 00:17:08.315 Uttam Kumaran: cool.

253 00:17:09.439 00:17:12.359 Patrick Trainer: And then I added, one.

254 00:17:12.759 00:17:18.749 Patrick Trainer: yeah, think like Friday night, the the volume anomaly stuff.

255 00:17:19.128 00:17:20.671 Patrick Trainer: just like I was getting

256 00:17:21.359 00:17:22.449 Patrick Trainer: just tired of.

257 00:17:22.649 00:17:23.139 Patrick Trainer: Okay.

258 00:17:23.140 00:17:23.540 Uttam Kumaran: Yeah.

259 00:17:23.540 00:17:26.890 Patrick Trainer: Pop up. So just changing it to warn.

260 00:17:26.890 00:17:27.440 Uttam Kumaran: Cool.

261 00:17:27.920 00:17:30.800 Patrick Trainer: But then that, like there’s also

262 00:17:31.060 00:17:35.398 Patrick Trainer: like I, I’d left a comment like a little down on the

263 00:17:35.790 00:17:37.140 Patrick Trainer: Oh, yeah, there.

264 00:17:37.590 00:17:38.020 Uttam Kumaran: Yeah.

265 00:17:38.020 00:17:38.980 Patrick Trainer: And have a zoom.

266 00:17:38.980 00:17:40.379 Uttam Kumaran: This is correct, for sure.

267 00:17:44.950 00:17:45.500 Patrick Trainer: is.

268 00:17:45.500 00:17:47.709 Uttam Kumaran: So this situation we should just have. No.

269 00:17:48.070 00:17:49.460 Uttam Kumaran: we just shut down.

270 00:17:49.460 00:17:53.349 Patrick Trainer: Le like, if we take out the the date key

271 00:17:53.830 00:18:00.799 Patrick Trainer: or like the date definition in how we’re defining the the elementary test.

272 00:18:00.920 00:18:05.860 Patrick Trainer: then what it will do Will. It’ll take the

273 00:18:08.370 00:18:10.430 Patrick Trainer: count of the entire table.

274 00:18:11.350 00:18:13.210 Patrick Trainer: like all of the rows.

275 00:18:13.740 00:18:16.750 Patrick Trainer: and then that will be the basis of

276 00:18:18.220 00:18:20.150 Patrick Trainer: the anomaly. So it

277 00:18:20.310 00:18:23.400 Patrick Trainer: that may be a little bit different than

278 00:18:24.900 00:18:26.699 Patrick Trainer: what we’re thinking

279 00:18:27.260 00:18:28.590 Patrick Trainer: or what we’re.

280 00:18:29.190 00:18:31.460 Patrick Trainer: I don’t. So

281 00:18:33.620 00:18:35.069 Patrick Trainer: let’s think through this.

282 00:18:35.540 00:18:38.100 Uttam Kumaran: I guess, like I’m more, I’m fine with them, putting

283 00:18:38.290 00:18:40.939 Uttam Kumaran: the everything to warn. But for this

284 00:18:40.950 00:18:42.070 Uttam Kumaran: logic.

285 00:18:42.720 00:18:47.229 Uttam Kumaran: I’m gonna pass back to ae team to basically figure out. Cause again, they’re gonna be.

286 00:18:47.230 00:18:47.610 Patrick Trainer: Yeah.

287 00:18:47.610 00:18:53.690 Uttam Kumaran: There, we’re we’re going through today. We’re supposed to do that before this meeting. But we’re going through today

288 00:18:53.730 00:19:01.269 Uttam Kumaran: and look, basically auditing all the existing tests, and then establishing that like from this point forward, if there are failures.

289 00:19:01.900 00:19:04.470 Uttam Kumaran: so we will. We will honestly likely.

290 00:19:04.560 00:19:08.420 Uttam Kumaran: I said, to remove all volume anomaly tests

291 00:19:08.550 00:19:09.770 Uttam Kumaran: because

292 00:19:10.760 00:19:12.620 Uttam Kumaran: it’s just like kind of

293 00:19:12.680 00:19:14.629 Uttam Kumaran: Od right now, meaning.

294 00:19:14.630 00:19:15.070 Patrick Trainer: Right.

295 00:19:15.070 00:19:17.499 Uttam Kumaran: Just a lot of tests, and

296 00:19:17.840 00:19:21.830 Uttam Kumaran: if we’re not confident yet on volume anomalies, I don’t wanna just set up tests.

297 00:19:23.200 00:19:24.970 Patrick Trainer: Test for tests sake.

298 00:19:25.510 00:19:30.530 Uttam Kumaran: Yeah. And like, we had a conversation back and forth about, like how many tests to have and how that can affect, like.

299 00:19:30.590 00:19:33.443 Uttam Kumaran: you know, started this like cry, wolf problem. But

300 00:19:33.760 00:19:38.990 Patrick Trainer: Yeah, no, that I mean, that’s totally true. And eventually you become numb to it.

301 00:19:39.230 00:19:39.890 Patrick Trainer: and.

302 00:19:39.890 00:19:41.450 Uttam Kumaran: That’s the thing. Yeah. So.

303 00:19:41.450 00:19:44.400 Patrick Trainer: And then you just start to ignore it.

304 00:19:45.290 00:19:48.329 Uttam Kumaran: So it’s like, what if they’re volume and always sure. But

305 00:19:48.400 00:19:50.049 Uttam Kumaran: like, are we even

306 00:19:50.110 00:19:51.740 Uttam Kumaran: adept at? Just like

307 00:19:51.990 00:19:55.580 Uttam Kumaran: primary key nulls? Stuff like that first, st you know.

308 00:19:55.710 00:19:56.420 Uttam Kumaran: Yeah,

309 00:19:57.750 00:19:59.199 Patrick Trainer: Cover low hanging stuff.

310 00:19:59.720 00:20:05.579 Uttam Kumaran: Because, yeah, if it’s like, if it’s yeah, I just think like a lot of the tables are gonna end up being like this where there’s just.

311 00:20:05.940 00:20:07.140 Uttam Kumaran: It’s just kind of like

312 00:20:07.740 00:20:10.910 Uttam Kumaran: the volume of rows coming in aren’t exactly standard.

313 00:20:11.080 00:20:13.210 Uttam Kumaran: But unless this is just like

314 00:20:13.300 00:20:14.919 Uttam Kumaran: a super wide

315 00:20:17.490 00:20:18.700 Uttam Kumaran: time bucket

316 00:20:19.320 00:20:21.420 Uttam Kumaran: like, I don’t even know whether it matters.

317 00:20:22.280 00:20:26.290 Uttam Kumaran: And that’s for like volume analysis, meaning, like, is every table coming in?

318 00:20:26.690 00:20:30.700 Uttam Kumaran: Is is every row coming in? I think there’s also anomalies where it’s like

319 00:20:30.790 00:20:38.230 Uttam Kumaran: is sales down. But that’s like an analysis related thing. So for that sort of stuff, I also said, I’m gonna kick that to Jacob because

320 00:20:38.550 00:20:41.350 Uttam Kumaran: the Ae team isn’t going to.

321 00:20:42.280 00:20:47.789 Uttam Kumaran: They’re they’re not gonna be able to say like, Oh, sales is down like they’re not gonna be on the hook for getting that to the client.

322 00:20:48.180 00:20:48.920 Patrick Trainer: Right.

323 00:20:48.920 00:20:51.399 Uttam Kumaran: So I’m like, unless Jacob can handle like

324 00:20:52.400 00:20:54.760 Uttam Kumaran: taking a look at those. Then.

325 00:20:55.150 00:20:57.260 Uttam Kumaran: yeah, I don’t know where that.

326 00:20:57.680 00:20:59.709 Patrick Trainer: So. So the way

327 00:21:00.940 00:21:08.940 Patrick Trainer: I think about it, or or the I totally agree with what you said. There is.

328 00:21:08.980 00:21:18.289 Patrick Trainer: or if if I understand elementaries, docs correctly. And then I was going through their issues as well like they do have some

329 00:21:18.996 00:21:25.850 Patrick Trainer: like people complaining about volume anomalies in general, just because, like they’re either buggy or

330 00:21:26.070 00:21:27.510 Patrick Trainer: they’re confusing.

331 00:21:28.725 00:21:29.699 Patrick Trainer: But

332 00:21:29.950 00:21:33.569 Patrick Trainer: you we can like.

333 00:21:34.940 00:21:45.900 Patrick Trainer: take out some of these keys like this, the timestamp column, and then all of the detection training time bucket stuff. We can remove that.

334 00:21:46.360 00:21:56.339 Patrick Trainer: And so like, the only 2 yeah required keys are like that sensitivity, and that the direction. And so, when you take out

335 00:21:56.630 00:22:01.109 Patrick Trainer: like the time buckets as well as the timestamp column.

336 00:22:01.660 00:22:03.290 Patrick Trainer: instead of like

337 00:22:03.640 00:22:08.680 Patrick Trainer: bucketing on each day and counting the rows within that bucket.

338 00:22:08.950 00:22:12.110 Patrick Trainer: It’s going to count the rows in the in the in the

339 00:22:12.340 00:22:16.490 Patrick Trainer: table entirely. Yeah. And so and so

340 00:22:17.660 00:22:22.210 Patrick Trainer: what I think that may be beneficial to is like, say.

341 00:22:22.730 00:22:27.030 Patrick Trainer: somewhere upstream, like they make like a code, change

342 00:22:27.190 00:22:31.210 Patrick Trainer: right like, add like a filter or something, and it

343 00:22:31.510 00:22:34.729 Patrick Trainer: that has like an unintended effect, where, like

344 00:22:35.680 00:22:37.550 Patrick Trainer: half of the rows

345 00:22:37.580 00:22:38.730 Patrick Trainer: are gone.

346 00:22:38.750 00:22:44.519 Patrick Trainer: let’s say they filter out like half the half the table, and they just don’t realize it.

347 00:22:45.320 00:22:53.629 Patrick Trainer: the volume anomaly would would catch that because it’s like, typically like, oh, this table usually has a million rows. And now it

348 00:22:54.150 00:22:55.900 Patrick Trainer: has a hundred 1,000

349 00:22:57.780 00:23:02.329 Patrick Trainer: instead of so we look at it like as a catch, for

350 00:23:03.500 00:23:04.990 Patrick Trainer: almost like like

351 00:23:06.090 00:23:09.129 Patrick Trainer: logic quality rather than

352 00:23:10.570 00:23:11.850 Patrick Trainer: I’ve

353 00:23:13.590 00:23:19.400 Patrick Trainer: like on the client of like. Oh, you’re not! You haven’t gotten enough orders or something like that.

354 00:23:19.400 00:23:20.259 Uttam Kumaran: Yeah, just.

355 00:23:20.410 00:23:21.439 Patrick Trainer: Does that make sense.

356 00:23:21.800 00:23:22.999 Uttam Kumaran: That makes sense. Yeah.

357 00:23:27.000 00:23:31.340 Patrick Trainer: But yeah, either way, I’d still like to turn it to Warren.

358 00:23:32.460 00:23:32.845 Uttam Kumaran: Yeah.

359 00:23:33.460 00:23:34.720 Patrick Trainer: Just so we yeah.

360 00:23:36.190 00:23:36.970 Uttam Kumaran: Fetco

361 00:23:43.410 00:23:45.560 Uttam Kumaran: So let’s look at this week.

362 00:23:45.610 00:23:50.060 Uttam Kumaran: this. These 2 have been open for a while. So I’m just gonna move these back.

363 00:23:50.900 00:23:55.320 Uttam Kumaran: Because we still have a bunch of stuff that’s in progress. The 2 fa, one is done.

364 00:23:55.670 00:23:56.910 Uttam Kumaran: Look on me.

365 00:23:57.419 00:24:02.679 Uttam Kumaran: That was very timely. Looks like after the news this morning. They just said, like all of

366 00:24:03.430 00:24:06.059 Uttam Kumaran: at and T like a hundred 10 million

367 00:24:06.470 00:24:11.919 Uttam Kumaran: user record breach, which is basically all of their and everybody from like a 6 month period.

368 00:24:11.930 00:24:13.850 Uttam Kumaran: my 2022. So.

369 00:24:14.030 00:24:14.670 Patrick Trainer: Yeah.

370 00:24:14.670 00:24:15.500 Uttam Kumaran: Yeah.

371 00:24:17.070 00:24:17.920 Patrick Trainer: And apparently.

372 00:24:17.920 00:24:19.010 Uttam Kumaran: And for sales, like.

373 00:24:19.430 00:24:20.390 Uttam Kumaran: yeah.

374 00:24:21.150 00:24:21.520 Patrick Trainer: Right.

375 00:24:21.520 00:24:22.589 Uttam Kumaran: Kind of brutal.

376 00:24:22.590 00:24:23.370 Patrick Trainer: Yeah.

377 00:24:23.890 00:24:28.450 Patrick Trainer: yeah, every everybody’s phone and

378 00:24:28.510 00:24:36.039 Patrick Trainer: text like records. So not necessarily the like the content of the text. But

379 00:24:36.120 00:24:38.120 Patrick Trainer: think of like every

380 00:24:38.130 00:24:39.840 Patrick Trainer: phone number that you’ve

381 00:24:40.060 00:24:42.549 Patrick Trainer: called or answered to

382 00:24:42.810 00:24:46.900 Patrick Trainer: that. That’s what’s leaked. And so people you can then like

383 00:24:47.630 00:24:51.799 Patrick Trainer: piece together like networks of communication

384 00:24:52.550 00:24:53.910 Patrick Trainer: as well as like

385 00:24:54.460 00:24:58.580 Patrick Trainer: you kind of figure out who people people are

386 00:24:58.700 00:24:59.799 Patrick Trainer: based on that.

387 00:24:59.800 00:25:01.160 Uttam Kumaran: It’s kind of insane.

388 00:25:01.160 00:25:03.650 Patrick Trainer: Yeah, it’s it’s absolutely insane.

389 00:25:05.060 00:25:05.860 Patrick Trainer: And then they

390 00:25:06.360 00:25:14.610 Patrick Trainer: at T earlier, like last year, number of months ago, they had another breach right where.

391 00:25:14.610 00:25:15.170 Uttam Kumaran: Yeah.

392 00:25:16.131 00:25:18.139 Patrick Trainer: Yeah, they had to reset

393 00:25:18.680 00:25:22.870 Patrick Trainer: everyone’s like account. Password, something.

394 00:25:22.870 00:25:23.840 Uttam Kumaran: And yeah, is there.

395 00:25:23.840 00:25:25.170 Patrick Trainer: They’re all leaked.

396 00:25:25.850 00:25:26.929 Uttam Kumaran: No, it’s

397 00:25:27.110 00:25:28.350 Uttam Kumaran: it’s brutal.

398 00:25:28.850 00:25:29.940 Patrick Trainer: Crazy.

399 00:25:32.780 00:25:36.640 Uttam Kumaran: okay, cool. And then I guess to talk about stuff in progress. So

400 00:25:36.820 00:25:38.469 Uttam Kumaran: this key pair one

401 00:25:38.560 00:25:41.479 Uttam Kumaran: like, I think we should probably do this similar to?

402 00:25:41.810 00:25:44.849 Uttam Kumaran: Well, I just did for 2 fa, which is just basically

403 00:25:45.510 00:25:49.739 Uttam Kumaran: go one by one. Do we know who else? I think I’m actually still probably

404 00:25:49.920 00:25:52.279 Uttam Kumaran: on the hook, but does it? Is anyone else.

405 00:25:54.630 00:25:57.030 Patrick Trainer: I believe Ryan’s good to go.

406 00:25:57.750 00:25:59.210 Patrick Trainer: Okay. I

407 00:26:00.060 00:26:02.050 Patrick Trainer: feel like I haven’t even seen

408 00:26:02.670 00:26:04.090 Patrick Trainer: Augustine like

409 00:26:05.330 00:26:05.880 Patrick Trainer: a month.

410 00:26:05.880 00:26:06.430 Nicolas Sucari: Yeah, I know.

411 00:26:06.430 00:26:10.470 Uttam Kumaran: Augustine’s Augustine is fine, cause we can leave him off.

412 00:26:10.790 00:26:12.870 Uttam Kumaran: I think everybody else.

413 00:26:13.160 00:26:17.470 Patrick Trainer: Okay and then, Jacob, I was working with

414 00:26:18.304 00:26:20.510 Patrick Trainer: like Friday, he.

415 00:26:20.600 00:26:23.370 Patrick Trainer: for whatever reason it wasn’t

416 00:26:24.735 00:26:29.484 Patrick Trainer: working with them. And so I’ll we’ll talk. I’ll talk with them today.

417 00:26:30.090 00:26:32.710 Patrick Trainer: And then, Nick.

418 00:26:36.370 00:26:37.900 Patrick Trainer: I don’t think he’s done it yet.

419 00:26:38.460 00:26:40.009 Uttam Kumaran: Okay. Cool. If anything. Like.

420 00:26:40.010 00:26:42.736 Patrick Trainer: I I actually, I know. Yeah, no, he hasn’t.

421 00:26:43.040 00:26:47.789 Uttam Kumaran: So like I’m I’m gonna let me see if I can just like grab 30 min sometime

422 00:26:48.700 00:26:52.170 Uttam Kumaran: tomorrow, cause I’ll I need to walk through as well, so I’ll just see if he has like

423 00:26:52.190 00:26:53.879 Uttam Kumaran: time to just walk through with me.

424 00:26:54.490 00:26:55.090 Patrick Trainer: Yeah.

425 00:26:55.320 00:26:56.969 Patrick Trainer: yeah, maybe we

426 00:26:57.010 00:27:00.779 Patrick Trainer: yeah, we should just get everybody yeah on at the same time

427 00:27:02.260 00:27:05.110 Patrick Trainer: should have done that from the from the start. But.

428 00:27:06.300 00:27:09.040 Nicolas Sucari: I I can try and set that up if you want to. Guys.

429 00:27:09.260 00:27:09.800 Patrick Trainer: Okay.

430 00:27:09.800 00:27:15.349 Nicolas Sucari: I. I already have the keypad, and it is easy as following the dog that we created Patrick right? But.

431 00:27:15.350 00:27:17.679 Patrick Trainer: See? Yeah, yeah, that’s why I said, like.

432 00:27:17.680 00:27:19.420 Uttam Kumaran: No, yeah, I’ve like, I, yeah. So.

433 00:27:19.420 00:27:21.330 Patrick Trainer: Confused about with with.

434 00:27:21.330 00:27:22.180 Nicolas Sucari: I know.

435 00:27:22.430 00:27:24.609 Patrick Trainer: But and it is like like

436 00:27:24.740 00:27:31.209 Patrick Trainer: Nico did it like it is like you can do it like I. We know it works, and then, like

437 00:27:31.590 00:27:33.569 Patrick Trainer: it just worked. I don’t know

438 00:27:34.000 00:27:35.060 Patrick Trainer: whatever. Yeah.

439 00:27:35.060 00:27:35.820 Nicolas Sucari: And worry.

440 00:27:38.415 00:27:42.770 Uttam Kumaran: Okay, cool. And then, Pat, how’s the email stuff going.

441 00:27:42.920 00:27:46.289 Patrick Trainer: Oh, that’s nearly done like the

442 00:27:47.690 00:27:49.199 Patrick Trainer: being able to get it.

443 00:27:49.647 00:27:53.920 Patrick Trainer: That’s all like, get the email or text that’s good

444 00:27:54.725 00:27:58.354 Patrick Trainer: now the last piece is

445 00:28:02.807 00:28:06.800 Patrick Trainer: dropping it into dbt, so setting up that action.

446 00:28:07.940 00:28:10.800 Uttam Kumaran: Okay. So I’m gonna actually, I’m gonna start forwarding these.

447 00:28:10.990 00:28:12.290 Uttam Kumaran: I didn’t do it.

448 00:28:13.040 00:28:15.140 Uttam Kumaran: although I said I did. I did not do that.

449 00:28:16.640 00:28:17.570 Patrick Trainer: So it’s all good.

450 00:28:17.910 00:28:23.480 Uttam Kumaran: So let me forward, and you were able to look. You’re able to see this like login and see the account.

451 00:28:24.415 00:28:29.204 Patrick Trainer: I have, honestly no, not yet. I haven’t. I haven’t

452 00:28:31.380 00:28:32.819 Patrick Trainer: logged into it yet.

453 00:28:33.190 00:28:34.009 Uttam Kumaran: Okay, cool.

454 00:28:34.610 00:28:39.920 Uttam Kumaran: So I’m gonna I’ll go ahead and just forward everything. And that way I think mine or the bargain is done.

455 00:28:42.070 00:28:44.219 Patrick Trainer: Trying to think. When do those come in.

456 00:28:45.630 00:28:49.219 Uttam Kumaran: Like mornings, like Monday mornings, and some of them are like

457 00:28:49.470 00:28:53.300 Uttam Kumaran: every day 6 Am. Or 4 or 5 Am.

458 00:28:55.230 00:28:58.259 Nicolas Sucari: Isn’t better to go into post pilot

459 00:28:58.767 00:29:02.750 Nicolas Sucari: configuration and add this email for parting, coming.

460 00:29:03.190 00:29:04.280 Uttam Kumaran: I,

461 00:29:05.430 00:29:06.300 Uttam Kumaran: it’s currently.

462 00:29:06.300 00:29:06.930 Nicolas Sucari: So set up.

463 00:29:06.930 00:29:07.980 Uttam Kumaran: Their end.

464 00:29:08.890 00:29:10.210 Nicolas Sucari: Okay. Okay.

465 00:29:11.790 00:29:15.419 Uttam Kumaran: Which is why I kind of like wanna just forward it, for now and then.

466 00:29:15.710 00:29:16.750 Patrick Trainer: Yeah, I think the.

467 00:29:16.750 00:29:22.849 Uttam Kumaran: I’ll ask them to switch it over later, because that way you don’t. We’re not like waiting on them. I don’t know when they’re gonna get back to me.

468 00:29:24.700 00:29:25.320 Nicolas Sucari: Way.

469 00:29:26.100 00:29:29.949 Uttam Kumaran: I’ll forward these, and then we’ll start to. We’ll just try to transition everything over but

470 00:29:31.400 00:29:35.439 Uttam Kumaran: cool moving forward. We’ll go. Everything that new will go straight to here.

471 00:29:36.440 00:29:37.140 Uttam Kumaran: Yeah.

472 00:29:38.600 00:29:41.879 Uttam Kumaran: So the step after this is done will be to

473 00:29:47.450 00:29:51.650 Uttam Kumaran: archive. The Google sheets models, renew

474 00:29:52.740 00:29:54.450 Uttam Kumaran: sources.

475 00:29:56.000 00:29:56.970 Patrick Trainer: Right, which.

476 00:30:00.600 00:30:03.190 Uttam Kumaran: Which can probably get done by the Ae team.

477 00:30:05.030 00:30:07.520 Uttam Kumaran: I think the biggest thing.

478 00:30:09.990 00:30:11.290 Uttam Kumaran: yeah, we’ll just be.

479 00:30:11.390 00:30:13.110 Uttam Kumaran: I guess we should probably set

480 00:30:13.718 00:30:18.819 Uttam Kumaran: because we know when these files are gonna come in, Pat, we can set some sort of freshness alert.

481 00:30:19.110 00:30:20.190 Uttam Kumaran: cause the

482 00:30:20.250 00:30:24.529 Uttam Kumaran: I would, just because it’s a new service. I just wanna make sure that these records come in every week.

483 00:30:25.290 00:30:26.120 Uttam Kumaran: Yeah.

484 00:30:26.120 00:30:27.279 Patrick Trainer: Yeah, right.

485 00:30:32.450 00:30:33.130 Uttam Kumaran: Okay.

486 00:30:34.020 00:30:38.030 Uttam Kumaran: cool, I think. The only other thing that’s new is this real

487 00:30:38.210 00:30:40.109 Uttam Kumaran: project refresh switch

488 00:30:40.610 00:30:41.580 Uttam Kumaran: ripped

489 00:30:42.580 00:30:44.159 Uttam Kumaran: basically like

490 00:30:45.260 00:30:51.069 Uttam Kumaran: when there’s a change to like a real files. We just need to run this like cli command.

491 00:30:51.220 00:30:54.230 Uttam Kumaran: which is probably just gonna be which should just be a Github action.

492 00:30:54.727 00:30:57.529 Uttam Kumaran: And then also real project status.

493 00:30:57.970 00:31:00.580 Uttam Kumaran: a lot is basically like the validation

494 00:31:00.620 00:31:02.685 Uttam Kumaran: right now, we don’t have like a

495 00:31:04.800 00:31:07.390 Uttam Kumaran: We don’t have a

496 00:31:08.010 00:31:10.309 Uttam Kumaran: like a dev environment for real.

497 00:31:10.790 00:31:12.090 Uttam Kumaran: So

498 00:31:13.660 00:31:17.370 Uttam Kumaran: I don’t. I’m trying to think through like, exactly how we do

499 00:31:17.860 00:31:19.780 Uttam Kumaran: like on Pr checks.

500 00:31:26.220 00:31:27.180 Uttam Kumaran: yeah.

501 00:31:27.610 00:31:29.260 Uttam Kumaran: I don’t know whether it’s like

502 00:31:30.940 00:31:31.920 Uttam Kumaran: running

503 00:31:32.260 00:31:35.779 Uttam Kumaran: real start, and then, if it just runs successfully.

504 00:31:36.020 00:31:37.260 Uttam Kumaran: it’s like good.

505 00:31:37.520 00:31:38.240 Uttam Kumaran: 5.th

506 00:31:40.140 00:31:41.180 Uttam Kumaran: But I don’t know. I’ll.

507 00:31:41.180 00:31:43.669 Patrick Trainer: Yeah, I’m not. I’m yeah. I’m not sure yet.

508 00:31:45.680 00:31:50.490 Uttam Kumaran: I talked to them in in here, so you can probably continue that thread if there’s any questions.

509 00:31:50.490 00:31:51.480 Patrick Trainer: Oh, sweet!

510 00:31:54.130 00:31:58.580 Uttam Kumaran: Basically, I just don’t think anybody else is doing this. Or if they are, it’s not that like common. So

511 00:32:01.160 00:32:07.820 Uttam Kumaran: there’s like a deploy which is based real project refresh. And then there’s the project status check.

512 00:32:08.160 00:32:10.730 Uttam Kumaran: which ideally we do on every Pr

513 00:32:11.280 00:32:14.840 Uttam Kumaran: or worst case. We run it on a schedule, because

514 00:32:15.300 00:32:19.530 Uttam Kumaran: if there’s a real issue, they don’t have any alerts right now to tell us that so.

515 00:32:21.560 00:32:24.119 Patrick Trainer: Oh, so like real status check is like

516 00:32:24.810 00:32:26.259 Patrick Trainer: checking, if.

517 00:32:26.550 00:32:28.570 Patrick Trainer: like real, the service

518 00:32:28.860 00:32:29.740 Patrick Trainer: this up.

519 00:32:29.740 00:32:36.590 Uttam Kumaran: No, no, this it’s like. So, for example, I I like, I like push some bad like ammo like a month ago.

520 00:32:36.750 00:32:41.239 Uttam Kumaran: and then I didn’t know that it actually like brought the dashboard down. Basically.

521 00:32:41.740 00:32:42.280 Patrick Trainer: You go into.

522 00:32:42.280 00:32:43.170 Uttam Kumaran: Rail.

523 00:32:47.120 00:32:48.899 Uttam Kumaran: if you go into real

524 00:32:49.040 00:32:50.939 Uttam Kumaran: and you go to the status.

525 00:32:51.600 00:32:53.310 Uttam Kumaran: Oh, yeah, this is the status

526 00:32:53.380 00:32:57.839 Uttam Kumaran: before there’d be like one red thing here. It’d be like some column is messed up.

527 00:32:58.840 00:33:00.420 Patrick Trainer: Yeah, okay.

528 00:33:01.790 00:33:05.800 Uttam Kumaran: like you. I can’t get alert. I don’t. I won’t get alerted by that.

529 00:33:05.980 00:33:11.939 Uttam Kumaran: because, for example, if I just like make the change, push it, and I don’t run it locally to test it. They’ll make it in.

530 00:33:12.650 00:33:14.070 Patrick Trainer: Right? Okay.

531 00:33:15.413 00:33:16.539 Uttam Kumaran: So real

532 00:33:17.800 00:33:19.440 Uttam Kumaran: project status?

533 00:33:25.820 00:33:28.840 Uttam Kumaran: yeah, it just shows like the deployment status. Basically.

534 00:33:29.260 00:33:30.110 Patrick Trainer: Okay.

535 00:33:30.530 00:33:31.250 Patrick Trainer: Cool.

536 00:33:35.810 00:33:37.590 Uttam Kumaran: So, and it’s kind of net new stuff.

537 00:33:37.919 00:33:44.959 Uttam Kumaran: But this will probably this kind of rounds out because we’re out rounds out us kind of switching from light dash. But

538 00:33:45.090 00:33:47.019 Uttam Kumaran: Ryan just finished all the

539 00:33:47.520 00:33:49.860 Uttam Kumaran: real stuff. The migration today.

540 00:33:49.860 00:33:51.290 Patrick Trainer: Oh, so sweet!

541 00:33:51.350 00:33:53.310 Patrick Trainer: Wait from light, dash.

542 00:33:53.310 00:33:55.610 Uttam Kumaran: From like, dash. Yeah. So like, basically, we have all.

543 00:33:55.940 00:33:56.270 Patrick Trainer: Yeah.

544 00:33:56.270 00:33:58.119 Uttam Kumaran: Team models in real now.

545 00:33:58.460 00:33:58.890 Patrick Trainer: Oh! That!

546 00:34:00.010 00:34:00.980 Uttam Kumaran: like.

547 00:34:01.650 00:34:03.439 Uttam Kumaran: yeah, we have, like all these now

548 00:34:05.020 00:34:08.009 Uttam Kumaran: and then a bunch of them. He he has like hidden as well, because

549 00:34:08.170 00:34:09.750 Uttam Kumaran: there were just stuff that I want.

550 00:34:10.219 00:34:10.629 Patrick Trainer: Right.

551 00:34:10.857 00:34:12.679 Uttam Kumaran: But we have a lot in here. Yeah.

552 00:34:13.610 00:34:22.630 Nicolas Sucari: I was. I was talking to Ryan about this last week, and what it will. It will be good if we can like. I create different projects.

553 00:34:23.291 00:34:24.649 Nicolas Sucari: If you, if you go.

554 00:34:24.659 00:34:25.169 Uttam Kumaran: Yeah.

555 00:34:25.170 00:34:25.949 Nicolas Sucari: That’s yeah.

556 00:34:26.860 00:34:33.339 Nicolas Sucari: But I I don’t know how to do that. I think that in the code we need to create like different real folders, right?

557 00:34:34.190 00:34:38.640 Uttam Kumaran: Yeah, no, you can. You just have to create like real project new.

558 00:34:38.730 00:34:41.579 Uttam Kumaran: And then it’ll create like a new project.

559 00:34:41.719 00:34:47.300 Uttam Kumaran: Yeah, I guess if we if we if we have like a good overview of like what products we want to create and stuff.

560 00:34:47.690 00:34:49.030 Uttam Kumaran: yeah, they can totally do that.

561 00:34:49.030 00:34:49.699 Nicolas Sucari: Okay.

562 00:34:50.159 00:34:59.500 Nicolas Sucari: I was, I was thinking that we can separate like the dashboards in shipping, marketing. And I don’t know something about business, probably.

563 00:34:59.530 00:35:09.599 Nicolas Sucari: So we can like hand everything on business to Ben and Dan. And we have shipments and everything related to that with chuck and marketing with Kim.

564 00:35:09.610 00:35:11.989 Nicolas Sucari: But yeah, I think we can. We can discuss it.

565 00:35:12.610 00:35:12.915 Uttam Kumaran: Okay.

566 00:35:15.250 00:35:17.479 Uttam Kumaran: okay, cool. So let’s

567 00:35:18.490 00:35:22.843 Uttam Kumaran: yeah. The biggest thing I would love to see is the email stuff getting done. And then,

568 00:35:23.720 00:35:27.649 Uttam Kumaran: I think. Yeah, I I’m excited to see the sequel flaw

569 00:35:28.113 00:35:32.349 Uttam Kumaran: and, like Linkedin, get into, because I think that’ll be good. Be a huge help for the a team.

570 00:35:35.600 00:35:39.900 Uttam Kumaran: I think the extra credit stuff is, we’re still having some issues with evidence.

571 00:35:42.073 00:35:42.879 Patrick Trainer: Yeah, right?

572 00:35:44.765 00:35:45.210 Uttam Kumaran: So.

573 00:35:46.080 00:35:49.379 Patrick Trainer: And then like row 3 in the backlog. That

574 00:35:49.690 00:35:51.219 Patrick Trainer: implement our back.

575 00:35:51.700 00:35:52.540 Uttam Kumaran: Yeah.

576 00:35:52.540 00:35:53.130 Patrick Trainer: That

577 00:35:53.560 00:35:55.790 Patrick Trainer: like, I’ve got all this stuff

578 00:35:55.980 00:35:57.930 Patrick Trainer: from a

579 00:35:59.050 00:36:01.309 Patrick Trainer: Stella. That’s what I’m thinking of.

580 00:36:01.600 00:36:02.880 Patrick Trainer: So yeah, so.

581 00:36:03.215 00:36:03.550 Uttam Kumaran: So!

582 00:36:03.960 00:36:05.809 Uttam Kumaran: So, Stella! This is fine!

583 00:36:06.400 00:36:08.280 Patrick Trainer: Yeah. Stella’s already done.

584 00:36:09.230 00:36:11.684 Uttam Kumaran: Oh, but you’re saying you have this the same like

585 00:36:12.370 00:36:17.389 Patrick Trainer: Yeah. Yeah. So yeah, if if we go into

586 00:36:18.370 00:36:19.450 Patrick Trainer: the

587 00:36:19.710 00:36:23.139 Patrick Trainer: stellar repo here, I’ve actually got the

588 00:36:23.270 00:36:23.970 Patrick Trainer: oh

589 00:36:25.600 00:36:31.139 Patrick Trainer: in the Scripts Directory, I should actually move this outside of Stella.

590 00:36:34.480 00:36:38.059 Patrick Trainer: But I’ve got all of the like role creation

591 00:36:39.980 00:36:41.830 Patrick Trainer: assignment. All of that.

592 00:36:43.620 00:36:45.719 Uttam Kumaran: I think the biggest thing here is like

593 00:36:46.170 00:36:50.941 Uttam Kumaran: the the worry I have is that like we, I wanna do this cause this may

594 00:36:51.870 00:36:54.680 Uttam Kumaran: it may like affect the a team stuff.

595 00:36:55.280 00:36:56.550 Uttam Kumaran: So.

596 00:36:56.730 00:36:57.430 Patrick Trainer: Yeah.

597 00:36:57.600 00:36:58.669 Patrick Trainer: so what I can do.

598 00:36:58.670 00:36:59.830 Uttam Kumaran: Table ownership.

599 00:37:00.040 00:37:00.720 Patrick Trainer: Yeah.

600 00:37:03.490 00:37:04.420 Patrick Trainer: it should.

601 00:37:05.610 00:37:11.400 Uttam Kumaran: You may just have to sit and do this for like an hour or 2. Just make sure it’s like, cross. T,

602 00:37:18.820 00:37:24.329 Uttam Kumaran: yeah, this would be great. Cause right now. It’s kind of a little bit all over the place. Stella is great.

603 00:37:24.708 00:37:28.540 Uttam Kumaran: We we we still actually simplify. We put everything into Mart.

604 00:37:29.880 00:37:30.620 Patrick Trainer: No awesome.

605 00:37:30.620 00:37:32.510 Uttam Kumaran: We just have like analytics.

606 00:37:33.670 00:37:36.879 Uttam Kumaran: marts and raw, and it’s like pretty easy.

607 00:37:39.330 00:37:41.180 Patrick Trainer: Yeah, yeah, that’s

608 00:37:41.590 00:37:44.962 Patrick Trainer: gonna be huge. Bryce was at asking me about that

609 00:37:45.893 00:37:46.699 Uttam Kumaran: Cool. Okay.

610 00:37:46.700 00:37:48.391 Patrick Trainer: Friday, and he was like.

611 00:37:49.290 00:37:51.220 Patrick Trainer: Where where are?

612 00:37:51.220 00:37:52.000 Uttam Kumaran: Where’s everything?

613 00:37:52.000 00:37:54.389 Patrick Trainer: Like, yeah, it’s it’s a mess.

614 00:37:54.680 00:37:55.200 Patrick Trainer: The.

615 00:37:55.200 00:37:55.800 Uttam Kumaran: Death.

616 00:37:58.760 00:38:08.070 Uttam Kumaran: Okay, cool. Yeah. I think, for some of these probably set to carve out some time. So maybe on Wednesday, Nico, just double check on some of these. If we’re going to be able to get them done, it may just be

617 00:38:08.130 00:38:09.810 Uttam Kumaran: meetings, so.

618 00:38:10.190 00:38:10.880 Nicolas Sucari: Yeah, I’m

619 00:38:12.000 00:38:12.760 Nicolas Sucari: great.

620 00:38:15.990 00:38:18.570 Uttam Kumaran: Okay. Cool. Anything else. Guys.

621 00:38:20.190 00:38:25.989 Nicolas Sucari: Oh, I just added that the tag for that engineering to the netlify

622 00:38:26.200 00:38:28.329 Nicolas Sucari: for deploying evidence that was.

623 00:38:28.490 00:38:28.880 Uttam Kumaran: Oh no!

624 00:38:28.880 00:38:30.189 Nicolas Sucari: Logging last week.

625 00:38:30.842 00:38:36.629 Nicolas Sucari: We have that one, and that is with this, no context, almost.

626 00:38:36.630 00:38:37.010 Uttam Kumaran: Yeah.

627 00:38:37.010 00:38:38.580 Nicolas Sucari: And if you scroll up a little bit.

628 00:38:38.600 00:38:40.979 Nicolas Sucari: there is one that you created with them, I think.

629 00:38:41.880 00:38:48.830 Nicolas Sucari: That says, Yeah, this one, yeah, we can delete one and leave and leave the other one. If you want.

630 00:38:49.410 00:38:51.670 Uttam Kumaran: Yeah, let me let me leave you this one.

631 00:38:52.735 00:38:53.050 Nicolas Sucari: Yeah.

632 00:38:53.650 00:38:55.720 Uttam Kumaran: Okay, let me move this one here.

633 00:38:55.880 00:38:56.766 Uttam Kumaran: and then

634 00:38:58.030 00:38:59.520 Uttam Kumaran: you know, archive, this.

635 00:39:00.530 00:39:10.530 Nicolas Sucari: Yeah, because we have. Yeah, it will be good to fix that so that we can deploy to evidence and see what actually has been working on right.

636 00:39:12.160 00:39:13.180 Uttam Kumaran: Yeah.

637 00:39:14.130 00:39:20.570 Uttam Kumaran: yeah, this one is pretty big. I mean, pat, actually, like this one is probably more important than the real stuff.

638 00:39:20.930 00:39:21.610 Patrick Trainer: Okay.

639 00:39:24.150 00:39:29.339 Uttam Kumaran: I’m just gonna move this somehow. Cause we’re not when I mean, we’re not making a ton of updates surreal at the moment. So

640 00:39:34.950 00:39:39.690 Uttam Kumaran: yeah, like, basically, if this doesn’t work, then

641 00:39:41.240 00:39:44.229 Uttam Kumaran: I don’t know. I would consider moving us to evidence Cloud. But

642 00:39:45.900 00:39:48.489 Uttam Kumaran: it’s like quite a bit more expensive.

643 00:39:48.490 00:39:49.530 Patrick Trainer: Yeah, right?

644 00:39:49.650 00:39:53.010 Patrick Trainer: What? Exactly or what’s wrong with it?

645 00:39:54.840 00:39:55.575 Patrick Trainer: The

646 00:39:56.310 00:39:59.219 Uttam Kumaran: There was just yeah, this is just all there was just.

647 00:39:59.220 00:39:59.720 Patrick Trainer: Yeah.

648 00:39:59.720 00:40:00.832 Uttam Kumaran: Probably look through the

649 00:40:01.900 00:40:02.380 Patrick Trainer: Right.

650 00:40:02.380 00:40:03.740 Uttam Kumaran: Slack, but

651 00:40:04.000 00:40:06.139 Uttam Kumaran: there was just some bill there.

652 00:40:07.460 00:40:09.779 Patrick Trainer: Right? Yeah. Like wasn’t populating.

653 00:40:10.290 00:40:11.580 Patrick Trainer: It’s internal.

654 00:40:12.250 00:40:12.830 Uttam Kumaran: Yeah.

655 00:40:12.830 00:40:13.879 Patrick Trainer: I remember that.

656 00:40:17.530 00:40:17.925 Uttam Kumaran: Okay.

657 00:40:22.636 00:40:26.343 Uttam Kumaran: Cool. So yeah, probably a couple of meetings this week. But

658 00:40:27.390 00:40:28.170 Uttam Kumaran: great

659 00:40:28.500 00:40:29.680 Uttam Kumaran: anything else.

660 00:40:31.330 00:40:32.170 Patrick Trainer: So about it.

661 00:40:34.400 00:40:35.300 Patrick Trainer: Cool? Yep.

662 00:40:36.440 00:40:38.449 Uttam Kumaran: Okay, I’ll talk to you guys on slack.

663 00:40:39.190 00:40:39.890 Patrick Trainer: Arthur.

664 00:40:39.890 00:40:40.879 Nicolas Sucari: Thank you. Guys.

665 00:40:41.100 00:40:41.820 Uttam Kumaran: Thanks us!

666 00:40:41.820 00:40:42.490 Nicolas Sucari: I like.

667 00:40:43.360 00:40:44.170 Atharv Gudi: Bye, bye.