Meeting Title: Uttam-Kumaran’s-Personal-Meeting-Room Date: 2024-07-09 Meeting participants: Ryan Luke Daque, Uttam Kumaran


WEBVTT

1 00:00:35.750 00:00:36.470 Uttam Kumaran: Hey, Ryan?

2 00:00:38.880 00:00:40.310 Uttam Kumaran: Hey? Yeah, I hear you.

3 00:00:45.750 00:00:49.379 Ryan Luke Daque: So what what seems to be the issue in like.

4 00:00:50.160 00:00:50.959 Uttam Kumaran: Yeah. So the.

5 00:00:50.960 00:00:56.909 Ryan Luke Daque: Like it looks like it’s a very like long thread already, and it like started with like real, not

6 00:00:57.520 00:00:58.690 Ryan Luke Daque: functioning.

7 00:00:58.690 00:01:04.080 Uttam Kumaran: Let me let me share with you what the what I’m seeing.

8 00:01:04.430 00:01:06.870 Uttam Kumaran: and then you can go from there.

9 00:01:10.990 00:01:17.479 Ryan Luke Daque: So was it like it. It worked before. And then when we added the Otp, it didn’t work anymore.

10 00:01:17.810 00:01:18.490 Ryan Luke Daque: or.

11 00:01:18.916 00:01:21.899 Uttam Kumaran: I honestly don’t know what triggered it.

12 00:01:22.640 00:01:25.307 Uttam Kumaran: But basically, this is what we’re seeing.

13 00:01:28.090 00:01:33.170 Uttam Kumaran: And if I go to the actual S 3 object itself.

14 00:01:33.560 00:01:34.210 Ryan Luke Daque: Yeah.

15 00:01:38.460 00:01:39.399 Uttam Kumaran: Hold on!

16 00:01:48.720 00:01:52.259 Uttam Kumaran: I think it’s something like it’s not selecting the right

17 00:01:52.860 00:02:01.269 Uttam Kumaran: tables or something, but like, Let’s go. I’ll go through with you, because you may have seen one thing that’s different, because I tried to look through the workflow as well.

18 00:02:02.285 00:02:02.720 Ryan Luke Daque: Sure

19 00:02:03.270 00:02:05.890 Ryan Luke Daque: would, you know? Like, when they started.

20 00:02:07.850 00:02:08.620 Ryan Luke Daque: Started.

21 00:02:10.709 00:02:16.869 Uttam Kumaran: I honestly don’t know exactly. I I know Nick has been talking about it for like a week or 2.

22 00:02:17.260 00:02:18.010 Ryan Luke Daque: Just had me go.

23 00:02:18.010 00:02:19.420 Uttam Kumaran: To it. So

24 00:02:20.182 00:02:23.290 Uttam Kumaran: so you can see this was last modified. On July 8th

25 00:02:23.440 00:02:24.969 Uttam Kumaran: I open this

26 00:02:26.537 00:02:28.360 Uttam Kumaran: snow test results.

27 00:02:29.610 00:02:30.560 Ryan Luke Daque: Right.

28 00:02:31.120 00:02:35.150 Uttam Kumaran: So if I go to these, if I go to Snowflake.

29 00:02:59.460 00:03:03.999 Uttam Kumaran: so if I go here, and then I for example, I I look at like

30 00:03:04.350 00:03:07.199 Uttam Kumaran: this is from dev elementary. And if I look at

31 00:03:08.030 00:03:09.310 Uttam Kumaran: Broad.

32 00:03:10.670 00:03:12.979 Uttam Kumaran: he said, says, June 17.th

33 00:03:13.280 00:03:13.950 Ryan Luke Daque: Right.

34 00:03:13.950 00:03:18.649 Uttam Kumaran: If you look at Prod, it’s this. So the dev elementary is probably the issue.

35 00:03:19.060 00:03:19.860 Ryan Luke Daque: Yeah.

36 00:03:20.720 00:03:23.448 Ryan Luke Daque: yeah, I just when I looked at the

37 00:03:25.590 00:03:34.669 Ryan Luke Daque: the the yaml profile profiles. Yaml, it looks like it was like, I mean the the workflow file. It was pointing to dev elementary. So maybe that’s why.

38 00:03:35.270 00:03:38.500 Uttam Kumaran: Okay. So let me add you, I’m gonna add you to the

39 00:03:40.550 00:03:42.270 Uttam Kumaran: Stella team

40 00:03:43.430 00:03:46.410 Uttam Kumaran: that way. You’re just there already.

41 00:03:48.390 00:03:49.190 Ryan Luke Daque: MK,

42 00:03:49.780 00:03:51.119 Ryan Luke Daque: yeah, I can

43 00:03:51.200 00:03:52.600 Ryan Luke Daque: create a Pr.

44 00:03:52.880 00:03:55.450 Uttam Kumaran: Yeah, maybe just push your like.

45 00:03:55.940 00:04:00.299 Uttam Kumaran: maybe make put. Make your Pr and I’ll approve it, and then we can just try it out.

46 00:04:00.670 00:04:03.699 Ryan Luke Daque: Yeah, sure, let me do that real quick.

47 00:04:06.210 00:04:09.300 Ryan Luke Daque: I need to jump back to Stella cause I

48 00:04:09.960 00:04:12.760 Ryan Luke Daque: jump back to poor parts again.

49 00:04:13.400 00:04:15.000 Ryan Luke Daque: So let me see.

50 00:04:21.600 00:04:24.410 Ryan Luke Daque: did I fix this already?

51 00:04:26.000 00:04:27.290 Ryan Luke Daque: Hmm!

52 00:04:27.400 00:04:30.200 Ryan Luke Daque: What dB version are you using for Stella.

53 00:04:31.342 00:04:34.300 Uttam Kumaran: It’s let me check. It should be.

54 00:04:36.630 00:04:39.280 Ryan Luke Daque: One cause mine

55 00:04:39.780 00:04:42.050 Ryan Luke Daque: has, like an error on the dpt.

56 00:04:42.220 00:04:42.620 Uttam Kumaran: Yes.

57 00:04:43.135 00:04:43.650 Ryan Luke Daque: Right.

58 00:04:43.650 00:04:44.969 Uttam Kumaran: 1.7.

59 00:04:45.760 00:04:51.079 Ryan Luke Daque: Nice. Yeah, it should be fine, cause I’m using 1.7 3.

60 00:04:51.080 00:04:54.619 Uttam Kumaran: Oh, so like. If you’re running the test locally, you have.

61 00:04:54.620 00:04:55.120 Ryan Luke Daque: Yeah.

62 00:04:55.120 00:04:55.910 Uttam Kumaran: Off.

63 00:04:56.120 00:04:59.490 Uttam Kumaran: So actually, okay, maybe I should just try to make the Pr maybe.

64 00:05:02.920 00:05:07.330 Ryan Luke Daque: Let me let me try it, because it’s just. It’s just a schema

65 00:05:08.150 00:05:11.980 Ryan Luke Daque: profiles. It’s now prod elementary

66 00:05:13.310 00:05:14.525 Ryan Luke Daque: and

67 00:05:16.810 00:05:18.240 Ryan Luke Daque: daily

68 00:05:18.380 00:05:20.169 Ryan Luke Daque: ride elementary.

69 00:05:23.430 00:05:24.250 Ryan Luke Daque: and

70 00:05:25.060 00:05:27.159 Ryan Luke Daque: I’ll I’ll add

71 00:05:28.570 00:05:30.409 Ryan Luke Daque: a manual trigger for

72 00:05:30.790 00:05:35.750 Ryan Luke Daque: the Daily Cron job, so we can like manually trigger it as well.

73 00:05:38.080 00:05:39.590 Uttam Kumaran: I think it’s already there, right.

74 00:05:40.200 00:05:41.140 Ryan Luke Daque: Is it?

75 00:05:41.760 00:05:43.160 Ryan Luke Daque: Let me see.

76 00:05:44.240 00:05:47.749 Ryan Luke Daque: I tried, or maybe it’s my access. I tried

77 00:05:47.980 00:05:50.420 Ryan Luke Daque: retriggering it earlier, and I can find it.

78 00:05:53.010 00:05:55.419 Ryan Luke Daque: So let me just double check.

79 00:06:05.150 00:06:08.939 Ryan Luke Daque: Oh, yeah, it looks like it’s sort of there workflow dispatch. Yep.

80 00:06:33.030 00:06:36.049 Ryan Luke Daque: And I just created the pull request.

81 00:06:41.950 00:06:44.830 Ryan Luke Daque: Oh, it looks like Stella doesn’t have a

82 00:06:46.940 00:06:50.730 Ryan Luke Daque: and like you can merge it without even any reviewer.

83 00:06:52.420 00:06:53.120 Uttam Kumaran: Yeah.

84 00:06:56.470 00:06:58.640 Ryan Luke Daque: Should I just go ahead and merge.

85 00:06:59.150 00:07:00.050 Uttam Kumaran: Yeah. Go ahead.

86 00:07:00.800 00:07:01.500 Ryan Luke Daque: Cool.

87 00:07:04.270 00:07:06.320 Ryan Luke Daque: Yeah, let’s try

88 00:07:06.980 00:07:09.289 Ryan Luke Daque: retriggering the action. Then

89 00:07:16.840 00:07:18.460 Ryan Luke Daque: daily run.

90 00:07:19.060 00:07:24.320 Ryan Luke Daque: Yeah, I can run it. Now I’m I’m retriggering the action by the workflow.

91 00:07:27.570 00:07:28.290 Uttam Kumaran: Echo.

92 00:07:34.300 00:07:35.999 Ryan Luke Daque: It’s running. Let’s see what

93 00:07:38.400 00:07:40.320 Ryan Luke Daque: hopefully this fixes it.

94 00:09:02.240 00:09:04.919 Ryan Luke Daque: Now doing the Dbt run.

95 00:09:05.420 00:09:06.010 Uttam Kumaran: You’ll get.

96 00:09:25.840 00:09:26.900 Ryan Luke Daque: Yeah, it does.

97 00:09:27.090 00:09:32.799 Ryan Luke Daque: So it’s going to prod elementary. The schema prod underscore elementary.

98 00:09:33.110 00:09:34.590 Uttam Kumaran: Okay, it’s different now.

99 00:09:34.750 00:09:37.130 Uttam Kumaran: or it’s it looks like, looks right now.

100 00:09:38.940 00:09:41.740 Ryan Luke Daque: So far it looks

101 00:09:42.750 00:09:44.900 Ryan Luke Daque: fine, but we’ll see

102 00:10:13.450 00:10:21.040 Ryan Luke Daque: it’s running the test. So it’s running the now it’s getting the correct schema. So let’s see here

103 00:11:11.580 00:11:13.710 Ryan Luke Daque: now, running elementary

104 00:11:14.490 00:11:15.230 Ryan Luke Daque: book.

105 00:11:26.560 00:11:29.465 Ryan Luke Daque: So it looks like when I I looked at the history

106 00:11:30.230 00:11:31.810 Ryan Luke Daque: the prod.

107 00:11:32.330 00:11:35.609 Ryan Luke Daque: like initially the prod elementary, I mean

108 00:11:35.710 00:11:40.450 Ryan Luke Daque: broad target for elementary was still the dev schema. So

109 00:11:40.690 00:11:41.950 Ryan Luke Daque: maybe that was also.

110 00:11:41.950 00:11:47.259 Uttam Kumaran: I wonder like what? I wonder if maybe they were. They switched it, and then it like.

111 00:11:48.520 00:11:50.510 Ryan Luke Daque: Yeah, I’m not sure. Yeah.

112 00:11:50.510 00:11:51.180 Uttam Kumaran: And know.

113 00:12:07.070 00:12:12.780 Ryan Luke Daque: Hey? It looks like it successfully uploaded it to S. 3. Can you like refresh or something?

114 00:12:14.470 00:12:16.109 Ryan Luke Daque: Yeah, there you go.

115 00:12:19.410 00:12:20.350 Uttam Kumaran: Nice.

116 00:12:20.580 00:12:23.029 Ryan Luke Daque: Perfect. So yeah, I think that was new.

117 00:12:23.650 00:12:26.718 Uttam Kumaran: Okay. So if I go to

118 00:12:27.570 00:12:28.600 Ryan Luke Daque: Website.

119 00:12:29.520 00:12:30.410 Uttam Kumaran: Yeah.

120 00:12:36.450 00:12:37.990 Ryan Luke Daque: Should be up to date as well.

121 00:12:41.650 00:12:44.210 Uttam Kumaran: Me see if I can clear this cache.

122 00:12:50.180 00:12:51.700 Uttam Kumaran: A.

123 00:12:52.920 00:12:54.590 Uttam Kumaran: How do I?

124 00:12:56.950 00:12:59.500 Uttam Kumaran: And I just like clear this cache.

125 00:13:45.840 00:13:46.780 Uttam Kumaran: know why.

126 00:13:46.780 00:13:47.599 Ryan Luke Daque: And know why.

127 00:13:47.600 00:13:51.560 Uttam Kumaran: Browser. It’s like all messed up. Let me try a different browser.

128 00:13:52.720 00:14:02.510 Ryan Luke Daque: Yeah, that’s 1 of my problems with elementary as well. I mean, like the website, you need to clear cash. Sometimes it gets stuck with the old.

129 00:14:03.370 00:14:05.580 Uttam Kumaran: Yeah, I always have this problem.

130 00:14:21.920 00:14:23.634 Uttam Kumaran: I still see the old one.

131 00:14:25.900 00:14:31.240 Ryan Luke Daque: Yeah, even the date. The time says says, 11 pm, so it’s not

132 00:14:32.000 00:14:33.290 Ryan Luke Daque: cleared in.

133 00:15:28.126 00:15:32.419 Uttam Kumaran: How do I like clear this cash, though?

134 00:15:50.160 00:15:54.489 Ryan Luke Daque: In the website. Can you just like, maybe.

135 00:15:58.370 00:16:01.960 Uttam Kumaran: I think there’s something that I have to clear the cache here.

136 00:16:05.640 00:16:08.580 Uttam Kumaran: Oh, create and validate. Okay, that’s what it is.

137 00:16:28.200 00:16:30.069 Ryan Luke Daque: Yeah, that makes sense.

138 00:16:41.972 00:16:44.870 Uttam Kumaran: I don’t know exactly what the.

139 00:16:47.410 00:16:48.520 Ryan Luke Daque: Path.

140 00:16:48.850 00:16:50.600 Ryan Luke Daque: Yeah, try try that.

141 00:17:28.210 00:17:28.790 Uttam Kumaran: Great.

142 00:17:29.570 00:17:30.680 Ryan Luke Daque: Nice.

143 00:17:35.920 00:17:37.000 Ryan Luke Daque: cool.

144 00:17:37.970 00:17:42.430 Uttam Kumaran: Okay, thank you. Let’s look at the real stuff. Maybe while you’re here.

145 00:17:42.570 00:17:46.950 Ryan Luke Daque: Yeah, sure. I haven’t completed anything yet. But yeah, we can check

146 00:17:47.767 00:17:51.249 Ryan Luke Daque: kim’s weekly report and the warranties one.

147 00:17:51.510 00:17:55.970 Uttam Kumaran: Yeah, so on Kim’s, I added. I. I requested a bunch of changes.

148 00:17:55.970 00:17:57.610 Ryan Luke Daque: Oh, okay, yeah. I didn’t see that.

149 00:17:57.965 00:18:08.880 Uttam Kumaran: So to walk you through kind of the reasoning. Let me just I’m gonna pull your branch up locally, and then I’ll kind of show you, because you’re going to be in real all day. So.

150 00:18:09.040 00:18:09.540 Ryan Luke Daque: Yeah, sure.

151 00:18:12.610 00:18:14.320 Uttam Kumaran: Let me pull this up.

152 00:18:35.048 00:18:38.879 Uttam Kumaran: So I think I have the right one

153 00:19:28.140 00:19:29.580 Uttam Kumaran: seated here.

154 00:19:30.980 00:19:31.750 Uttam Kumaran: Hello.

155 00:19:46.410 00:19:51.220 Uttam Kumaran: okay. So a couple of things.

156 00:19:58.610 00:20:00.935 Uttam Kumaran: so the 1st thing is

157 00:20:02.130 00:20:04.020 Uttam Kumaran: I wanted to change his title.

158 00:20:04.660 00:20:05.020 Ryan Luke Daque: Yeah.

159 00:20:05.020 00:20:06.883 Uttam Kumaran: Thing. Second thing is

160 00:20:08.960 00:20:12.280 Uttam Kumaran: this there’s no need for this week, actually, because

161 00:20:14.540 00:20:18.799 Uttam Kumaran: you’re able to actually see it here. Like, if you filter by week, basically.

162 00:20:19.200 00:20:21.790 Uttam Kumaran: You get, you get every single thing here. So no need to have

163 00:20:21.930 00:20:26.070 Uttam Kumaran: no need to have additional time series dimensions, basically cause

164 00:20:27.050 00:20:28.180 Uttam Kumaran: automatically.

165 00:20:28.760 00:20:30.520 Uttam Kumaran: So that’s this one

166 00:20:31.720 00:20:33.489 Uttam Kumaran: campaign name. So

167 00:20:33.791 00:20:38.680 Uttam Kumaran: this isn’t for the campaign, and this is for open rate. So if I do, showing open rate.

168 00:20:39.150 00:20:41.319 Uttam Kumaran: you can see these come in at

169 00:20:42.240 00:20:44.800 Uttam Kumaran: like these, come in at numbers.

170 00:20:45.300 00:20:45.920 Uttam Kumaran: I want that.

171 00:20:45.920 00:20:46.530 Ryan Luke Daque: Right.

172 00:20:46.530 00:20:47.720 Uttam Kumaran: Percentages.

173 00:20:50.640 00:20:53.310 Uttam Kumaran: so this just changes this to a percentage.

174 00:20:55.610 00:21:01.120 Uttam Kumaran: the other thing is, this is 48. So for revenue, if I do revenue here.

175 00:21:02.145 00:21:04.760 Uttam Kumaran: You can’t do percent of total.

176 00:21:05.310 00:21:05.930 Ryan Luke Daque: Right.

177 00:21:06.165 00:21:07.339 Uttam Kumaran: Did. If I did a

178 00:21:07.430 00:21:12.789 Uttam Kumaran: like purchases, or 1 1 of the ones that you have percent of total, you get this.

179 00:21:13.020 00:21:15.319 Uttam Kumaran: So anytime. It’s like a sum

180 00:21:15.870 00:21:24.720 Uttam Kumaran: and it’s not like an average. Or like a yeah, basically, anytime, it’s a sum. And you want to look at the constituency of the category.

181 00:21:24.970 00:21:25.440 Ryan Luke Daque: No, it is.

182 00:21:25.753 00:21:27.319 Uttam Kumaran: Percent of total to true.

183 00:21:27.470 00:21:29.340 Ryan Luke Daque: Maybe count as well right. If.

184 00:21:29.670 00:21:31.609 Uttam Kumaran: Account as well. Yeah.

185 00:21:31.800 00:21:33.709 Uttam Kumaran: So that’s these 2.

186 00:21:33.800 00:21:35.026 Uttam Kumaran: And then,

187 00:21:36.230 00:21:39.260 Uttam Kumaran: yeah, I think that’s it. So you could probably honestly just go

188 00:21:40.330 00:21:43.010 Uttam Kumaran: commit all these, and then, yeah, ship it.

189 00:21:43.010 00:21:43.440 Ryan Luke Daque: Sense.

190 00:21:43.786 00:21:47.253 Uttam Kumaran: The other thing I wanted to share with you is

191 00:21:48.050 00:21:52.230 Uttam Kumaran: If you go to if you go to the repo

192 00:21:53.850 00:21:58.889 Uttam Kumaran: and you go into real, and you go into real dot ymo. I actually have a bunch of defaults.

193 00:21:59.300 00:21:59.860 Ryan Luke Daque: Hmm.

194 00:21:59.860 00:22:05.049 Uttam Kumaran: Similarly, in Dbt project, where you can have like default configs, I have default dashboard configs.

195 00:22:05.200 00:22:06.610 Uttam Kumaran: Basically

196 00:22:06.710 00:22:15.500 Uttam Kumaran: these we don’t need to specify these in every single dashboard anymore. They get specified here. So the default time range is the past one month.

197 00:22:16.053 00:22:21.300 Uttam Kumaran: The time zone is America. La, although this needs to be New York.

198 00:22:21.760 00:22:23.300 Uttam Kumaran: That’s an issue.

199 00:22:26.830 00:22:28.160 Uttam Kumaran: just make this

200 00:22:28.220 00:22:29.650 Uttam Kumaran: change, this.

201 00:22:47.940 00:22:53.809 Uttam Kumaran: okay, great. And then, basically, I have these times time ranges. So the time ranges. You see here.

202 00:22:54.090 00:22:54.630 Ryan Luke Daque: Yeah. The.

203 00:22:54.630 00:22:55.869 Uttam Kumaran: These are all

204 00:22:55.910 00:22:57.049 Uttam Kumaran: based on this.

205 00:22:57.610 00:22:58.670 Ryan Luke Daque: Cool.

206 00:23:00.208 00:23:02.299 Uttam Kumaran: So you you won’t need to specify.

207 00:23:02.300 00:23:03.050 Ryan Luke Daque: Specify.

208 00:23:03.050 00:23:03.510 Uttam Kumaran: In any.

209 00:23:03.510 00:23:03.900 Ryan Luke Daque: Yeah.

210 00:23:05.850 00:23:06.590 Uttam Kumaran: so.

211 00:23:07.220 00:23:08.770 Ryan Luke Daque: Okay. Nice.

212 00:23:10.170 00:23:14.640 Uttam Kumaran: Yeah. And the other thing is, if there’s currency like these are purchases.

213 00:23:15.141 00:23:21.260 Uttam Kumaran: let’s see, this is revenue. Just. I would just look at the all the formats basically for any of the measures.

214 00:23:21.907 00:23:26.509 Uttam Kumaran: To just make sure that if it’s a dollar it has a dollar sign. And yeah.

215 00:23:26.510 00:23:27.220 Ryan Luke Daque: Yeah.

216 00:23:27.380 00:23:34.269 Uttam Kumaran: Kind of the way I do is I usually just go in. Once I take a pass, I go in here. I look at all them. I click like, I try to

217 00:23:34.480 00:23:37.330 Uttam Kumaran: do a bunch of analyses and basically see? Like, Okay.

218 00:23:37.550 00:23:39.489 Uttam Kumaran: am I missing anything? So.

219 00:23:41.180 00:23:42.090 Ryan Luke Daque: Okay.

220 00:23:45.970 00:23:46.720 Uttam Kumaran: Okay.

221 00:23:47.160 00:23:48.110 Ryan Luke Daque: Cool.

222 00:23:48.460 00:23:53.169 Uttam Kumaran: Cool. Thank you for the help on elementary. I’m gonna go put the invalidation on

223 00:23:54.930 00:23:56.800 Ryan Luke Daque: But everyone as well. Yeah.

224 00:23:56.800 00:23:58.980 Uttam Kumaran: And I’ll just throw that to docs as well. So.

225 00:23:59.320 00:24:01.340 Ryan Luke Daque: Sounds good thanks thanks again.

226 00:24:01.340 00:24:02.909 Uttam Kumaran: Okay, thanks guys.

227 00:24:03.410 00:24:04.030 Ryan Luke Daque: Bye.