2025-11-12_honey_stinger-hedra_working_session_ac0498fa

Meeting Title: Honey Stinger-Hedra Working Session Date: 2025-11-12 Meeting participants: Demilade Agboola, Uttam Kumaran, Henry Zhao, Mustafa Raja, Casie Aviles, Zoran Selinger

---

WEBVTT

1 00:00:23.230 ⇒ 00:00:24.740 Uttam Kumaran: Hello, sir.

2 00:00:29.130 ⇒ 00:00:31.009 Uttam Kumaran: Can you hear me?

3 00:00:31.010 ⇒ 00:00:31.789 Demilade Agboola: How are you?

4 00:00:32.780 ⇒ 00:00:37.039 Uttam Kumaran: I’m good, I’m tired.

5 00:00:37.700 ⇒ 00:00:39.719 Demilade Agboola: It’s been a long weekend, it’s just Wednesday.

6 00:00:41.210 ⇒ 00:00:45.539 Uttam Kumaran: Yeah, dude. Wow, things are growing, man. I’m just, like, really excited.

7 00:00:45.780 ⇒ 00:00:52.189 Uttam Kumaran: Finally, I feel like we’re cracking something, so I’m just trying to get everything Close, and then…

8 00:00:52.380 ⇒ 00:00:57.709 Uttam Kumaran: Trying… trying not to stress you guys out, but I’m sure it’s like…

9 00:00:57.840 ⇒ 00:01:04.330 Uttam Kumaran: I’m doing my best to try to just make sure everybody’s set up, so… Yeah.

10 00:01:08.170 ⇒ 00:01:10.469 Demilade Agboola: Fair enough, fair enough, like…

11 00:01:10.870 ⇒ 00:01:17.620 Demilade Agboola: Yeah, there’s quite a lot going on, so it’s just kind of, like, keeping tabs on everything and prioritizing the most important

12 00:01:17.820 ⇒ 00:01:18.990 Demilade Agboola: In the moment.

13 00:01:19.560 ⇒ 00:01:27.010 Uttam Kumaran: Yeah, I think we’re gonna go through these periods of, sort of… things…

14 00:01:27.710 ⇒ 00:01:31.839 Uttam Kumaran: escalating, and then I’m gonna be able to fill in

15 00:01:32.310 ⇒ 00:01:42.389 Uttam Kumaran: like, more capacity. So for both these clients, like, I think we’re just trying new ways, like, I come in and I sort of figure out what the roadmap is, that way I don’t waste anybody else’s time.

16 00:01:42.770 ⇒ 00:01:43.280 Demilade Agboola: Yeah.

17 00:01:43.280 ⇒ 00:01:46.849 Uttam Kumaran: And once we have the roadmap, I can start to loop more people in.

18 00:01:47.320 ⇒ 00:02:00.309 Uttam Kumaran: But I do think that’s probably, like, everybody’s sort of maxed out around 2 to 3 clients each, you know, it’s hard to sort of do more than that, so… I feel… feel good, and so as soon as we’re sort of able to start making progress, I can then…

19 00:02:00.740 ⇒ 00:02:05.469 Uttam Kumaran: for me, I can take my free time then and start to say, okay, like.

20 00:02:05.690 ⇒ 00:02:24.379 Uttam Kumaran: do we feel good about… we can talk on Monday, sort of, like, how does everyone feel? Do we want to loop more people in? So I also looped in Casey and, Mustafa to this meeting. I could think we may need a little bit of help on Honey Stinger, just some data engineering help,

21 00:02:24.740 ⇒ 00:02:29.870 Uttam Kumaran: So I want to make sure that, Henry, you have some support there, and then…

22 00:02:30.020 ⇒ 00:02:33.939 Uttam Kumaran: on future, I think it’s a lot more self-explanatory, so give me just…

23 00:02:34.350 ⇒ 00:02:38.829 Uttam Kumaran: Let’s give just… let me give them a couple minutes. I’m just gonna also run and get some water.

24 00:02:39.360 ⇒ 00:02:39.940 Henry Zhao: Okay.

25 00:02:43.050 ⇒ 00:02:45.389 Henry Zhao: Demolati, thanks for your support earlier in the meeting.

26 00:02:46.200 ⇒ 00:02:48.210 Demilade Agboola: No problem, anytime.

27 00:04:51.090 ⇒ 00:04:58.360 Uttam Kumaran: Okay, let’s get started. So let’s talk about, Honey Stinger first, and then down we can talk about,

28 00:04:59.270 ⇒ 00:05:04.930 Uttam Kumaran: stuff for… Idra. So, for Honey Stinger,

29 00:05:05.450 ⇒ 00:05:10.889 Uttam Kumaran: So I’ll kind of share with everybody sort of, like, the objectives for the project.

30 00:05:11.570 ⇒ 00:05:14.920 Uttam Kumaran: And then we can sort of talk through, like, what it is we’re…

31 00:05:15.220 ⇒ 00:05:32.070 Uttam Kumaran: I’m doing. So, I think for this project, I can get some help from both you, Mustafa, and from Henry. I think it’s going to kind of require you both just kind of thinking through each of your skill sets, but I also think it’s a fairly contained project, so I’m kind of… I’m excited. So basically.

32 00:05:32.100 ⇒ 00:05:37.030 Uttam Kumaran: Honey stinger cells in several different channels. We currently have a mother duck set up.

33 00:05:37.670 ⇒ 00:05:46.259 Uttam Kumaran: With a bunch of data landing from Polyatomic and from Fivetran, and we want to start to do, some…

34 00:05:46.700 ⇒ 00:05:50.899 Uttam Kumaran: basic modeling and analysis. So…

35 00:05:51.050 ⇒ 00:05:58.630 Uttam Kumaran: We have several, kind of, tickets here that we’ve, sort of mapped out, so let me just,

36 00:05:59.180 ⇒ 00:06:02.709 Uttam Kumaran: Make sure that these… these have everything, and then we can…

37 00:06:04.330 ⇒ 00:06:06.750 Uttam Kumaran: Britain liaison.

38 00:06:14.460 ⇒ 00:06:15.800 Uttam Kumaran: Specific.

39 00:06:27.770 ⇒ 00:06:30.730 Uttam Kumaran: cool.

40 00:06:30.870 ⇒ 00:06:36.420 Uttam Kumaran: So, yeah, the first thing I kind of am interested in doing is,

41 00:06:36.600 ⇒ 00:06:41.270 Uttam Kumaran: Like, just kind of establishing a simple,

42 00:06:41.670 ⇒ 00:06:51.280 Uttam Kumaran: data warehouse and initializing dbt. I think the output tasks, Henry, here are to start to do this

43 00:06:51.450 ⇒ 00:06:58.850 Uttam Kumaran: customer stitching. And so, in… in Notion, I believe we have…

44 00:06:59.390 ⇒ 00:07:04.630 Uttam Kumaran: some past customer stitching work we did for Javi, or I’ll have to find it.

45 00:07:05.250 ⇒ 00:07:09.910 Uttam Kumaran: A sooner change.

46 00:07:12.520 ⇒ 00:07:12.960 Uttam Kumaran: Mr.

47 00:07:49.680 ⇒ 00:07:52.820 Henry Zhao: Do they have a CDP, or are we doing all of this with the mother duck?

48 00:07:53.460 ⇒ 00:07:55.650 Uttam Kumaran: Yeah, we’re gonna do all this with Mother Duck.

49 00:07:55.650 ⇒ 00:07:56.360 Henry Zhao: Okay.

50 00:08:24.650 ⇒ 00:08:27.999 Uttam Kumaran: Actually, you’re gonna have to just find it sooner.

51 00:08:30.920 ⇒ 00:08:31.650 Uttam Kumaran: Sure.

52 00:08:38.059 ⇒ 00:08:38.979 Henry Zhao: It’s 13.

53 00:08:52.930 ⇒ 00:08:59.309 Uttam Kumaran: We have this somewhere, but I don’t know exactly where it is, but basically it’s a script that we developed

54 00:08:59.520 ⇒ 00:09:06.689 Uttam Kumaran: To stitch together customers from each of these segments?

55 00:09:07.260 ⇒ 00:09:12.210 Uttam Kumaran: I don’t know exactly… I mean, actually, the last place I could check is…

56 00:09:14.410 ⇒ 00:09:18.920 Henry Zhao: Do they only sell their products online, or do they have, like, brick and mortar, like, Walmart, stuff like that?

57 00:09:19.170 ⇒ 00:09:25.370 Uttam Kumaran: Yeah, it’s, it’s Walmart, and they do a lot of business on Amazon, and it’s retail.

58 00:09:25.370 ⇒ 00:09:29.470 Henry Zhao: How do I… so, can people go into a physical Walmart store and buy Honey Stinger?

59 00:09:29.850 ⇒ 00:09:30.590 Uttam Kumaran: Yeah.

60 00:09:30.730 ⇒ 00:09:32.790 Henry Zhao: How do we stitch those people?

61 00:09:33.750 ⇒ 00:09:37.750 Uttam Kumaran: Well, we have to… if there’s no data, then we can’t stitch those people right now.

62 00:09:38.190 ⇒ 00:09:38.580 Henry Zhao: Okay.

63 00:09:38.580 ⇒ 00:09:44.150 Uttam Kumaran: I think the first thing I… maybe I could just make sure that everybody… you guys both, like, have access to…

64 00:09:44.420 ⇒ 00:09:46.860 Uttam Kumaran: Mothered up?

65 00:09:47.490 ⇒ 00:09:50.339 Uttam Kumaran: So, let me just log in and check on that.

66 00:10:05.940 ⇒ 00:10:11.850 Uttam Kumaran: Yeah, so first, just, I would say, go through and, take a look at, like, what’s in here.

67 00:10:12.150 ⇒ 00:10:13.370 Uttam Kumaran: And then…

68 00:10:13.620 ⇒ 00:10:19.429 Uttam Kumaran: I mean, I’m gonna be on, but I’d like us to sort of… we could just take a look at tickets and sort of align on, like, okay, what

69 00:10:21.370 ⇒ 00:10:27.899 Uttam Kumaran: yeah, like, what our kind of initial goals are for Friday. I think… let me just make sure that you guys are invited here.

70 00:10:27.900 ⇒ 00:10:31.150 Henry Zhao: Yeah, that would be great. If you could add my BrainForge account, that would be great.

71 00:10:31.490 ⇒ 00:10:34.450 Uttam Kumaran: Yeah, I actually… Yeah, let’s see…

72 00:10:38.850 ⇒ 00:10:43.670 Henry Zhao: Yeah, anything where we don’t need to share accounts, it’s better to have our own accounts, otherwise it gets so confusing.

73 00:10:43.670 ⇒ 00:10:44.600 Uttam Kumaran: Yeah.

74 00:10:45.060 ⇒ 00:10:49.249 Henry Zhao: And we keep getting logged… like, if me and Zoran are in Tableau at the same time, we keep logging each other out.

75 00:10:51.000 ⇒ 00:10:52.450 Uttam Kumaran: Oh, damn, okay.

76 00:10:52.990 ⇒ 00:10:55.670 Uttam Kumaran: Okay, yeah, check if you guys can access this now.

77 00:10:55.890 ⇒ 00:10:58.580 Henry Zhao: Okay, phew, let’s go. App.motoc.com…

78 00:11:00.570 ⇒ 00:11:02.619 Uttam Kumaran: You’ll see all of this data here.

79 00:11:11.450 ⇒ 00:11:13.150 Henry Zhao: Let’s see if I have Honey Stinger…

80 00:11:25.670 ⇒ 00:11:26.880 Henry Zhao: Action database…

81 00:11:54.730 ⇒ 00:11:55.619 Uttam Kumaran: Value guy.

82 00:11:56.230 ⇒ 00:11:58.100 Uttam Kumaran: That’s iTran, you don’t have it?

83 00:12:00.470 ⇒ 00:12:04.639 Henry Zhao: You need to add it to the database, too.

84 00:12:05.050 ⇒ 00:12:07.779 Uttam Kumaran: Yeah, I mean, run this on your side.

85 00:12:08.280 ⇒ 00:12:09.030 Henry Zhao: Okay.

86 00:12:11.650 ⇒ 00:12:12.200 Uttam Kumaran: Boom.

87 00:12:12.200 ⇒ 00:12:14.109 Henry Zhao: I guess it’s kind of like a Jupyter notebook.

88 00:12:14.670 ⇒ 00:12:15.440 Uttam Kumaran: Yeah.

89 00:12:18.800 ⇒ 00:12:21.430 Henry Zhao: Attach… D.

90 00:12:28.300 ⇒ 00:12:30.660 Henry Zhao: Did you copy and paste it somewhere? Oh, here in a second.

91 00:12:30.660 ⇒ 00:12:31.870 Uttam Kumaran: In Zoom chat, yeah.

92 00:12:38.450 ⇒ 00:12:39.729 Henry Zhao: Okay, I have it now.

93 00:12:40.780 ⇒ 00:12:46.560 Uttam Kumaran: So you should be able to see all their Klaviyo data, all the Shopify, and their Amazon data.

94 00:12:46.710 ⇒ 00:12:48.020 Uttam Kumaran: We don’t have Walmart.

95 00:12:48.020 ⇒ 00:12:48.580 Henry Zhao: Yeah.

96 00:12:48.780 ⇒ 00:12:50.240 Uttam Kumaran: stuff right now.

97 00:12:50.640 ⇒ 00:12:52.840 Uttam Kumaran: we’re kind of figuring it out, but I feel like.

98 00:12:53.280 ⇒ 00:12:57.110 Henry Zhao: How would Walmart data work? Like, how would we know what people bought in a Walmart store?

99 00:12:58.330 ⇒ 00:13:03.279 Uttam Kumaran: Well, they give us… dude, they give us the data. Like, they give us… they tell us what they bought.

100 00:13:03.900 ⇒ 00:13:07.709 Uttam Kumaran: It’s, like, very similar to Amazon. And they also sell on Walmart online, so…

101 00:13:07.850 ⇒ 00:13:08.730 Henry Zhao: Yeah.

102 00:13:11.370 ⇒ 00:13:18.239 Uttam Kumaran: Okay, so I guess my… more of my thoughts is, one, I think.

103 00:13:18.460 ⇒ 00:13:23.129 Uttam Kumaran: Henry, maybe we… I would love if you could send over to Decision Engineering, and we can find…

104 00:13:23.440 ⇒ 00:13:27.589 Uttam Kumaran: Wear this, like, stitching… Script 1…

105 00:13:31.110 ⇒ 00:13:32.380 Henry Zhao: You’re on mute, Uten.

106 00:13:32.380 ⇒ 00:13:39.440 Uttam Kumaran: Sorry, my dog’s barking. Yeah, I’m wondering if we can find out where the stitching script is. So, if you can send a note

107 00:13:39.580 ⇒ 00:13:44.130 Uttam Kumaran: In engineering, we can tag Robert and Awash, and we can just ask, like.

108 00:13:44.530 ⇒ 00:13:50.229 Uttam Kumaran: Can we get help finding this customer stitching script? We did it for Johnny Coffee.

109 00:13:50.840 ⇒ 00:13:52.489 Henry Zhao: Jaffe… Jaffe Coffee?

110 00:13:52.490 ⇒ 00:13:55.190 Uttam Kumaran: Javi, J-A-V-V-Y.

111 00:13:55.190 ⇒ 00:13:56.470 Henry Zhao: J-A-V-D-Y.

112 00:13:56.890 ⇒ 00:14:02.820 Uttam Kumaran: So I think they’ll help you find that. Basically, what we want to try to do is… is… that script is just a Python script.

113 00:14:02.820 ⇒ 00:14:07.829 Henry Zhao: And so you input in, like, a bunch of customer-related info, and then it.

114 00:14:08.170 ⇒ 00:14:14.659 Uttam Kumaran: it sort of stitches together Amazon and Shopify through a few different sort of,

115 00:14:14.980 ⇒ 00:14:18.740 Uttam Kumaran: It’s a couple different ways, like, we’ve developed it. It’s… it’s just somewhere.

116 00:14:19.800 ⇒ 00:14:20.460 Henry Zhao: Yep.

117 00:14:20.460 ⇒ 00:14:24.240 Uttam Kumaran: So I would ask them first, and I can also look at it. But, for this…

118 00:14:24.610 ⇒ 00:14:32.860 Uttam Kumaran: project overall, one, we want to start to also, Basically, also build a, like.

119 00:14:33.110 ⇒ 00:14:42.520 Uttam Kumaran: golden customer table, and start to build, sort of, staging models for Shopify, Amazon, and Klaviyo. So, I feel like, in terms of skill set, like, I think

120 00:14:42.760 ⇒ 00:14:44.150 Uttam Kumaran: I’m not sure, Henry, if…

121 00:14:44.280 ⇒ 00:14:52.059 Uttam Kumaran: I feel like that’s kind of probably too much on your side to do, like, I don’t know if you have much experience in dbt, or, like, writing dbt code.

122 00:14:52.330 ⇒ 00:14:53.120 Henry Zhao: I do know.

123 00:14:54.060 ⇒ 00:14:55.300 Henry Zhao: I did some for Eden.

124 00:14:56.360 ⇒ 00:15:00.589 Uttam Kumaran: Yeah, but have you established, like, a new dbt project, like…

125 00:15:01.240 ⇒ 00:15:08.549 Uttam Kumaran: I’m… what I’m nervous about is, like, I don’t want you to take on dbt work if you’ve never done, like, writing these SQL models and, like, building it out.

126 00:15:09.160 ⇒ 00:15:13.240 Henry Zhao: I’ve built the SQL models and, like, changed the YAML, but that’s about it.

127 00:15:13.750 ⇒ 00:15:19.479 Uttam Kumaran: Okay, yeah, that’s, like… that’s definitely not enough. I guess, Mustafa, like, you have some experience

128 00:15:20.030 ⇒ 00:15:23.910 Uttam Kumaran: All from the OmniWork, right? Doing, like, dbt stuff?

129 00:15:27.600 ⇒ 00:15:28.570 Uttam Kumaran: You’re on mute.

130 00:15:35.230 ⇒ 00:15:36.979 Uttam Kumaran: So I may… yeah, go ahead.

131 00:15:37.470 ⇒ 00:15:40.370 Mustafa Raja: Yeah, sorry, I got disconnected from…

132 00:15:42.000 ⇒ 00:15:51.650 Uttam Kumaran: Yeah, mainly I was asking if, like, if you feel comfortable taking on, like, initializing dbt and starting to build out a few, like, SQL models.

133 00:15:51.890 ⇒ 00:15:56.099 Uttam Kumaran: That would be ideal.

134 00:15:56.580 ⇒ 00:15:57.590 Mustafa Raja: And…

135 00:15:57.600 ⇒ 00:15:58.410 Uttam Kumaran: Yeah.

136 00:15:59.110 ⇒ 00:16:03.200 Mustafa Raja: Yeah, so, we would be doing this in data platform repo, right?

137 00:16:04.480 ⇒ 00:16:14.689 Uttam Kumaran: No, this would be… we would have to basically establish a new dbt cloud, and then sort of establishing a brand new, like, dbt project.

138 00:16:15.750 ⇒ 00:16:16.300 Mustafa Raja: Excellent.

139 00:16:16.900 ⇒ 00:16:21.440 Mustafa Raja: I’ll have to look into this, this is new, so… But yeah, native.

140 00:16:22.240 ⇒ 00:16:25.539 Uttam Kumaran: So I think that’s something that maybe we could work on.

141 00:16:25.770 ⇒ 00:16:28.479 Uttam Kumaran: together, but I kind of like to hand that off

142 00:16:29.400 ⇒ 00:16:41.539 Uttam Kumaran: to you, and then basically, Henry, you’ll be sort of the downstream stakeholder of, like, Mustafa’s work, so I think we kind of have, like, two areas we want to go towards. One is, like, we’re trying to build this

143 00:16:42.200 ⇒ 00:16:54.179 Uttam Kumaran: identity stitching between each of these sources, and then second, definitely we’re interested in doing some of the Klaviyo work. So, my question is going to be for the Klaviyo work.

144 00:16:54.320 ⇒ 00:17:00.300 Uttam Kumaran: Like, what do you need, like, technically to accomplish That.

145 00:17:05.180 ⇒ 00:17:09.489 Henry Zhao: I probably need help from the AI team, right? Because this is going to involve a lot of AI.

146 00:17:11.170 ⇒ 00:17:12.029 Uttam Kumaran: Oh, okay.

147 00:17:12.030 ⇒ 00:17:12.579 Henry Zhao: Things…

148 00:17:13.130 ⇒ 00:17:18.570 Uttam Kumaran: Yeah, I guess more of my thing is, like, you’re gonna need just, like… do you feel comfortable, like.

149 00:17:19.380 ⇒ 00:17:23.830 Uttam Kumaran: writing SQL and getting all this data necessary, or, like, is that something…

150 00:17:24.930 ⇒ 00:17:29.000 Henry Zhao: Yeah, it should be in the… it should be in the mother duck in the Klaviyo table, right? Like, all the email data?

151 00:17:29.300 ⇒ 00:17:38.370 Uttam Kumaran: Yeah, so I feel like if you’re able to do that, and then you can work with Mustafa exactly on, like, how we can start to conduct some of these tests, that would be great.

152 00:17:38.810 ⇒ 00:17:39.750 Henry Zhao: Yeah.

153 00:17:40.840 ⇒ 00:17:46.560 Uttam Kumaran: So that’s another thing where I think it would require just both of you to collaborate, but that would be…

154 00:17:46.940 ⇒ 00:17:52.350 Uttam Kumaran: I think that would be really important in, yeah, for…

155 00:17:52.950 ⇒ 00:18:05.750 Uttam Kumaran: just to start looking at that. So, I would say those are the kind of two big objectives right now, is starting this customer stitching, establishing DBT in some, like, core models, and then finally,

156 00:18:06.610 ⇒ 00:18:10.379 Uttam Kumaran: starting on the FIVO analysis, so I’m going to.

157 00:18:10.380 ⇒ 00:18:12.539 Henry Zhao: The one analysis? The one analysis?

158 00:18:12.540 ⇒ 00:18:13.790 Uttam Kumaran: the Klaviyo analysis.

159 00:18:13.790 ⇒ 00:18:14.860 Henry Zhao: Okay.

160 00:18:15.160 ⇒ 00:18:20.170 Uttam Kumaran: So I’m gonna go ahead and move this to… Book.

161 00:18:21.030 ⇒ 00:18:25.070 Uttam Kumaran: Just these to Don…

162 00:18:25.170 ⇒ 00:18:30.720 Uttam Kumaran: So I would say this is done, and then we actually have, like, the execution of this analysis, so…

163 00:19:24.010 ⇒ 00:19:30.030 Uttam Kumaran: Okay, so I think kind of the core tasks, is gonna be…

164 00:19:30.170 ⇒ 00:19:46.969 Uttam Kumaran: establishing dbt, so, Mustafa, like, I can… I mean, you can walk through that, and then I think, Henry, I’ll just… if you can drive towards this, again, like, for analysis work, like, we’re gonna want to put together a deck, so the outcome of this…

165 00:19:47.230 ⇒ 00:20:01.630 Uttam Kumaran: has to be something, like, digestible for the client. So, I don’t… it can be rough, like, while you’re working on stuff, but ideally, we want to arrive kind of a lot… really similar to Amber’s work with, like, what do we find?

166 00:20:02.310 ⇒ 00:20:04.919 Henry Zhao: Okay. Make a deck for Honey Stinger, though, eventually, right?

167 00:20:05.980 ⇒ 00:20:15.129 Uttam Kumaran: Yeah, I mean, again, like, I think I kind of would love for you to give me a sense of, like, if we’re gonna be able to have anything around this by Friday afternoon.

168 00:20:15.130 ⇒ 00:20:15.890 Henry Zhao: Yep, okay.

169 00:20:15.890 ⇒ 00:20:18.930 Uttam Kumaran: So, you let me know, and then, yeah, basically.

170 00:20:19.160 ⇒ 00:20:36.719 Uttam Kumaran: well, we have a weekly deck, so you could just create one or two slides on, like, what we find, but the customer stitching and then this analysis was kind of the most important. The other thing is, like, I kind of want you to just get a really good understanding of their, like, Klaviyo performance to date.

171 00:20:37.330 ⇒ 00:20:40.539 Uttam Kumaran: Okay. They’re already gonna have an understanding of that, but…

172 00:20:40.640 ⇒ 00:20:48.020 Uttam Kumaran: I think this is where I’m kind of leaning on you to sort of just understand what opportunities there are for them. Okay.

173 00:20:48.520 ⇒ 00:20:54.790 Uttam Kumaran: you know, like, they’re gonna have a good understanding of their email rates and things like that, but, I think…

174 00:20:55.040 ⇒ 00:21:00.710 Uttam Kumaran: I guess more of my question is, like, do you kind of have a clear path on, like, how you would conduct this analysis, or is that, like…

175 00:21:02.410 ⇒ 00:21:08.100 Henry Zhao: I have to look at the mother duck day to see what I have in there, but I’ll tell you as soon as possible, like, if I’m missing anything.

176 00:21:08.590 ⇒ 00:21:12.810 Uttam Kumaran: Okay, but I guess even, let’s say you do have, like, all the right data, like, do you kind of…

177 00:21:13.000 ⇒ 00:21:26.739 Uttam Kumaran: I know we talked a little bit on Monday about, like, trying to get a little bit of a clear path on how we do analysis, just haven’t done that yet, but I guess, do you have a good sense of, like, what the next steps are once you take a look at the data, like, how to actually run

178 00:21:27.450 ⇒ 00:21:29.210 Uttam Kumaran: Queries and do that analysis.

179 00:21:29.210 ⇒ 00:21:29.900 Henry Zhao: Yeah.

180 00:21:29.900 ⇒ 00:21:36.860 Uttam Kumaran: It’s going to be a little bit different than what you’re doing in Amplitude or Mixpanel, because there’s no UI, so you have to kind of run queries.

181 00:21:36.970 ⇒ 00:21:37.850 Uttam Kumaran: And, like.

182 00:21:38.560 ⇒ 00:21:40.760 Henry Zhao: Yeah, that’s actually what I’m more comfortable with, honestly.

183 00:21:41.020 ⇒ 00:21:49.470 Uttam Kumaran: Okay, okay. And then my other… my other piece would be to talk to Amber about how to, like, leverage Cursor to do this faster.

184 00:21:49.780 ⇒ 00:21:50.380 Henry Zhao: Okay.

185 00:21:50.990 ⇒ 00:21:52.550 Uttam Kumaran: So she’ll help you there.

186 00:21:54.220 ⇒ 00:21:57.599 Uttam Kumaran: Okay, cool, so maybe, like, yeah, if you… if you guys have time to…

187 00:21:57.760 ⇒ 00:22:11.279 Uttam Kumaran: to poke at this today, and then just, like, send me updates on, like, how you feel. I think… just want to make sure, Henry, like, you have a good understanding of, like, what the client goals are, and, like, kind of all the data we have, and then me, you, and Mustafa will kind of

188 00:22:11.870 ⇒ 00:22:13.500 Uttam Kumaran: I triple team this one.

189 00:22:13.630 ⇒ 00:22:14.280 Mustafa Raja: Yep.

190 00:22:14.280 ⇒ 00:22:14.910 Henry Zhao: Okay.

191 00:22:16.700 ⇒ 00:22:21.789 Uttam Kumaran: Okay, cool. Great, I think that’s probably it for…

192 00:22:22.860 ⇒ 00:22:28.719 Uttam Kumaran: Money Stinger, we can talk about, Kidra now.

193 00:22:30.490 ⇒ 00:22:38.149 Uttam Kumaran: So yeah, I guess demo audit, wondering if you have… if you got a chance to log in to stuff, check out.

194 00:22:38.470 ⇒ 00:22:40.590 Uttam Kumaran: Snowflake, and things like that.

195 00:22:43.020 ⇒ 00:22:48.100 Demilade Agboola: Yes, I’ve been able to log into dbt, the login to Snowflake.

196 00:22:48.710 ⇒ 00:22:49.140 Uttam Kumaran: Okay.

197 00:22:50.090 ⇒ 00:22:53.749 Demilade Agboola: It’s not necessarily, like, created any environments yet.

198 00:22:54.060 ⇒ 00:22:54.860 Uttam Kumaran: Okay.

199 00:22:54.860 ⇒ 00:23:00.029 Demilade Agboola: But like I said, that’s the part I would also just create a stage in.

200 00:23:00.200 ⇒ 00:23:12.220 Demilade Agboola: And then… Yeah, I’ve seen the tickets you… we have for, like, in linear for Hedra.

201 00:23:12.810 ⇒ 00:23:13.460 Uttam Kumaran: Yeah.

202 00:23:13.680 ⇒ 00:23:19.749 Uttam Kumaran: So basically, like, Hydra is this platform where you can just generate a bunch of,

203 00:23:20.530 ⇒ 00:23:34.550 Uttam Kumaran: just generate, like, videos and AI videos. My conversation with their team is in the platform, so it could be worth watching, but basically, they just want to generate a simple, like, revenue table.

204 00:23:35.420 ⇒ 00:23:41.419 Uttam Kumaran: I would say it’s… most of it is going to be built off of, Stripe subscriptions.

205 00:23:41.680 ⇒ 00:23:46.830 Uttam Kumaran: And then I’m gonna… I’m gonna… I’m working on the users table right now, so… .

206 00:23:46.830 ⇒ 00:23:47.560 Demilade Agboola: Okay.

207 00:23:48.180 ⇒ 00:23:54.680 Demilade Agboola: Quick question. Is there any, like, is data straightforward? Is it more of, like, a subscription thing?

208 00:23:56.450 ⇒ 00:24:09.129 Demilade Agboola: like, what I mean by data is the process of revenue calculation, is it straightforward, or is it, like, one of those things where it’s, you know, like, you know how, like, urban sims can be really tricky with concepts of re-delivery and all that?

209 00:24:09.430 ⇒ 00:24:13.439 Uttam Kumaran: There are, like, caveats to it, or is it just straight up, like, if they subscribe.

210 00:24:13.560 ⇒ 00:24:17.090 Demilade Agboola: It counts as revenue every single month that they pay.

211 00:24:17.380 ⇒ 00:24:22.810 Demilade Agboola: Until they cancel, or refund? Like, are there more complex things to, like, look out for?

212 00:24:23.430 ⇒ 00:24:28.799 Uttam Kumaran: Not really. Like, and I just shared this with you, here are, like, the requirements.

213 00:24:29.570 ⇒ 00:24:33.480 Uttam Kumaran: for the master revenue table,

214 00:24:34.890 ⇒ 00:24:40.050 Uttam Kumaran: So it’s… it’s actually pretty… it’s… there’s no, like, kind of hiccups as of now.

215 00:24:40.530 ⇒ 00:24:45.899 Uttam Kumaran: should be all built. So we just have to kind of build the staging layer for…

216 00:24:46.370 ⇒ 00:24:50.630 Uttam Kumaran: Stripe, basically, which I feel like we… we may even have…

217 00:24:52.090 ⇒ 00:24:54.760 Uttam Kumaran: Some of that code somewhere, but yeah, like…

218 00:24:55.770 ⇒ 00:24:56.960 Demilade Agboola: Also, do we have…

219 00:24:57.010 ⇒ 00:24:59.030 Uttam Kumaran: All of the data being ingested right now.

220 00:24:59.510 ⇒ 00:25:02.000 Uttam Kumaran: Yeah, so if you go into Snowflake.

221 00:25:02.300 ⇒ 00:25:05.690 Uttam Kumaran: You should see all that.

222 00:25:06.100 ⇒ 00:25:06.690 Demilade Agboola: Correct.

223 00:25:07.410 ⇒ 00:25:15.370 Uttam Kumaran: Yeah, you’ll see in RAW, you’ll see all of the… Stripe data here.

224 00:25:17.780 ⇒ 00:25:25.449 Uttam Kumaran: So basically, you should be able to build most things from… subscriptions and invoices, I think.

225 00:25:25.840 ⇒ 00:25:27.090 Demilade Agboola: Right, where’s the raw?

226 00:25:27.750 ⇒ 00:25:28.340 Uttam Kumaran: Yeah.

227 00:25:29.820 ⇒ 00:25:34.960 Demilade Agboola: Okay, so… Dude, I can’t seem to see that, though.

228 00:25:35.890 ⇒ 00:25:41.620 Uttam Kumaran: What’s your, what is your role? Sysadmin?

229 00:25:42.750 ⇒ 00:25:47.150 Demilade Agboola: So it’s…

230 00:25:50.800 ⇒ 00:25:52.810 Demilade Agboola: Girl, it’s not… it’s not admin, though.

231 00:25:57.900 ⇒ 00:25:59.259 Demilade Agboola: Then I go to, like.

232 00:26:02.430 ⇒ 00:26:07.019 Demilade Agboola: Projects… And then the objects account team to see…

233 00:26:12.250 ⇒ 00:26:14.140 Uttam Kumaran: Okay, give me one sec.

234 00:26:18.030 ⇒ 00:26:19.630 Uttam Kumaran: What is your username?

235 00:26:20.660 ⇒ 00:26:24.920 Demilade Agboola: It’s… demlade.agbola.

236 00:26:34.790 ⇒ 00:26:35.670 Uttam Kumaran: No one…

237 00:26:39.180 ⇒ 00:26:39.870 Uttam Kumaran: Well…

238 00:26:57.630 ⇒ 00:26:59.789 Uttam Kumaran: Okay, try using this role developer.

239 00:27:04.200 ⇒ 00:27:05.130 Demilade Agboola: Okay.

240 00:27:05.570 ⇒ 00:27:06.780 Demilade Agboola: I’m gonna refresh.

241 00:27:12.370 ⇒ 00:27:13.550 Demilade Agboola: Yeah, I can see now.

242 00:27:16.000 ⇒ 00:27:16.540 Uttam Kumaran: Okay.

243 00:27:17.230 ⇒ 00:27:18.449 Demilade Agboola: I can see the pod.

244 00:27:18.590 ⇒ 00:27:21.099 Demilade Agboola: I think you see the brawl.

245 00:27:23.930 ⇒ 00:27:29.390 Demilade Agboola: Alright, so we have Google Ads, we have Google Analytics, post hoc.

246 00:27:30.460 ⇒ 00:27:32.839 Demilade Agboola: TO, and then the Hedra.

247 00:27:38.540 ⇒ 00:27:45.040 Uttam Kumaran: Yo, so I’ll be working on… users,

248 00:27:45.220 ⇒ 00:27:47.830 Uttam Kumaran: I’m sort of stitching IDs together, and then…

249 00:27:49.580 ⇒ 00:27:52.410 Uttam Kumaran: Yeah, the revenue table is probably…

250 00:27:53.100 ⇒ 00:27:56.070 Uttam Kumaran: That… that’s, like, kind of, like, where I would… I could use some help.

251 00:27:56.840 ⇒ 00:28:02.040 Uttam Kumaran: And then also, if you want to watch the last

252 00:28:02.820 ⇒ 00:28:09.330 Uttam Kumaran: meeting I had with them that was pretty good. We kind of walked through the product also.

253 00:28:11.470 ⇒ 00:28:12.140 Demilade Agboola: Okay.

254 00:28:13.080 ⇒ 00:28:17.899 Demilade Agboola: Just quick questions, though. You have 3 things assigned to me. What are the other priorities?

255 00:28:19.270 ⇒ 00:28:22.560 Uttam Kumaran: Like, in terms of long-term?

256 00:28:23.000 ⇒ 00:28:30.470 Demilade Agboola: like, right now. So we have the fact revenues transactions, we have the subscriptions, periods, and status, trust models.

257 00:28:30.710 ⇒ 00:28:35.700 Demilade Agboola: And then MRR movements, new, expansion, contraction, reactivation, and churn.

258 00:28:36.020 ⇒ 00:28:37.979 Demilade Agboola: What’s the priority for each of them?

259 00:28:38.700 ⇒ 00:28:46.540 Uttam Kumaran: This is… Yeah.

260 00:28:49.740 ⇒ 00:28:51.470 Uttam Kumaran: indices.

261 00:28:52.800 ⇒ 00:28:53.920 Uttam Kumaran: Both of these.

262 00:28:54.370 ⇒ 00:28:57.419 Uttam Kumaran: I feel like for the revenue table, you’re gonna need this, so…

263 00:28:59.260 ⇒ 00:28:59.970 Demilade Agboola: Oh, okay.

264 00:29:00.410 ⇒ 00:29:07.900 Uttam Kumaran: And the requirements for those, for this, are basically here, so…

265 00:29:11.120 ⇒ 00:29:18.700 Uttam Kumaran: They just basically want something to start to… start to, report on, like, Revenue by customer.

266 00:29:18.930 ⇒ 00:29:24.689 Uttam Kumaran: Outside. Gotcha. Yeah. So that’s the start, and then we’ll layer on more. And then I’ll,

267 00:29:26.650 ⇒ 00:29:29.219 Uttam Kumaran: I’ll, I’ll make sure you’re added to GitHub.

268 00:29:29.750 ⇒ 00:29:32.070 Uttam Kumaran: And that, and then I’ll…

269 00:29:32.470 ⇒ 00:29:37.469 Uttam Kumaran: Give me a sense once you start poking around, and then I’ll… If we’re able to…

270 00:29:37.700 ⇒ 00:29:44.149 Uttam Kumaran: If we’re able to ship any PR, I’ll then loop you in to the team. They’re very chill, just wanna, like, make sure you’re…

271 00:29:45.010 ⇒ 00:29:45.690 Uttam Kumaran: You’re a guy.

272 00:29:45.690 ⇒ 00:29:48.069 Demilade Agboola: Alright, sounds good. So, like.

273 00:29:48.380 ⇒ 00:29:55.179 Uttam Kumaran: We have one core stakeholder, like, this woman, Sandra, and then we work directly, kind of, with the CEO and CTO, so…

274 00:29:55.810 ⇒ 00:30:04.929 Uttam Kumaran: pure modeling. So, dbt should be set up, in all the service accounts, so I’m gonna go ahead and work on our users table now for a bit.

275 00:30:06.110 ⇒ 00:30:09.810 Demilade Agboola: Okay, can I get added to the GitHub, like, now, so I…

276 00:30:09.810 ⇒ 00:30:13.729 Uttam Kumaran: Yes, yeah, can you send me your.

277 00:30:15.460 ⇒ 00:30:18.970 Demilade Agboola: Dog, it’s… Damien King.

278 00:30:19.730 ⇒ 00:30:21.229 Uttam Kumaran: Oh, all one word? Okay.

279 00:30:21.650 ⇒ 00:30:22.340 Demilade Agboola: there.

280 00:30:23.480 ⇒ 00:30:24.929 Demilade Agboola: Just answering the chat.

281 00:30:27.540 ⇒ 00:30:28.070 Uttam Kumaran: Here.

282 00:30:47.210 ⇒ 00:30:49.800 Uttam Kumaran: You got out a profile photo, dude, in Slack.

283 00:30:52.220 ⇒ 00:30:52.920 Demilade Agboola: I’m sorry?

284 00:30:53.360 ⇒ 00:30:55.959 Uttam Kumaran: I said, you gotta add a profile phone on Slack.

285 00:30:56.190 ⇒ 00:30:56.870 Demilade Agboola: Oh.

286 00:30:58.000 ⇒ 00:31:01.100 Demilade Agboola: I mean… I’m a huge fan of anonymity.

287 00:31:03.440 ⇒ 00:31:08.300 Demilade Agboola: If I could, if I could, I will truly just go off the grid permanently, like…

288 00:31:08.650 ⇒ 00:31:12.060 Demilade Agboola: no, like, social media, no footprints or anything.

289 00:31:12.060 ⇒ 00:31:18.549 Uttam Kumaran: I don’t even use… only I use Twitter, but it’s not even, like… yeah, I don’t use any social media anymore.

290 00:31:27.480 ⇒ 00:31:29.379 Demilade Agboola: Usually, there’s this, there’s this meme.

291 00:31:29.830 ⇒ 00:31:30.510 Demilade Agboola: Hmm.

292 00:31:31.650 ⇒ 00:31:35.489 Demilade Agboola: Three… three stages of… of LinkedIn.

293 00:31:36.780 ⇒ 00:31:41.050 Demilade Agboola: Joins LinkedIn, adds profile picture, makes enough money.

294 00:31:41.560 ⇒ 00:31:43.060 Demilade Agboola: Most profile picture.

295 00:31:43.370 ⇒ 00:31:44.830 Uttam Kumaran: That’s funny.

296 00:31:44.830 ⇒ 00:31:47.030 Demilade Agboola: Yeah.

297 00:31:47.030 ⇒ 00:31:49.819 Uttam Kumaran: It’s like the midwed meme, right?

298 00:31:51.060 ⇒ 00:31:56.489 Demilade Agboola: Yeah, it’s just one of those things where, like, you know what, like, I totally see it, like, there’s a point in which you’re just like, you know what?

299 00:31:57.100 ⇒ 00:31:58.670 Demilade Agboola: I don’t need a profile picture.

300 00:32:01.360 ⇒ 00:32:06.200 Uttam Kumaran: I mean, dude, once you make it… once we get baller enough, it doesn’t matter, you know, I’m just…

301 00:32:07.850 ⇒ 00:32:14.890 Uttam Kumaran: I just, like, I’m someone who’s just like, we can’t lose for, like, those reasons, so I’m just like, you know, let’s just make sure we’re good.

302 00:32:15.440 ⇒ 00:32:16.459 Demilade Agboola: Fair enough.

303 00:32:20.870 ⇒ 00:32:24.639 Uttam Kumaran: Cool. Okay, alright, I’m gonna lock in for a bit,

304 00:32:24.680 ⇒ 00:32:43.719 Uttam Kumaran: Casey, I think where I could also use your help as we start on HEDRA is to start to loop you in a little bit on the data side. So, for now, I just wanted you to kind of get an overview of, like, what we’re doing for them, and then I’ll slowly start to loop you in as things stabilize. So, I think for… kind of for…

305 00:32:43.900 ⇒ 00:32:58.440 Uttam Kumaran: for the folks on here that are new to, like, dbt data modeling work, Henry, Mustafa, and Casey, like, I kind of want this to be a little bit of, like, upskilling for y’all to see, like, end-to-end how we establish dbt, establish Snowflake.

306 00:32:59.120 ⇒ 00:33:16.990 Uttam Kumaran: great marts and then start to run analysis. For Mustafa and Casey, you guys are coming from the data engineering side, so… and then for Henry, you’re coming from the analysis side. So ask a lot of questions, and if you’re spending more than 2 hours or something, you’re not getting anywhere, ask a question.

307 00:33:17.110 ⇒ 00:33:22.299 Uttam Kumaran: That should be an indicator that you’re stuck, you know, so…

308 00:33:22.300 ⇒ 00:33:23.080 Henry Zhao: Ask already.

309 00:33:23.490 ⇒ 00:33:24.860 Uttam Kumaran: Yeah, please, yeah.

310 00:33:25.390 ⇒ 00:33:26.539 Uttam Kumaran: I’m gonna be… I’m just gonna

311 00:33:26.900 ⇒ 00:33:30.229 Uttam Kumaran: I can stay here all day, I’m just gonna be working.

312 00:33:31.210 ⇒ 00:33:32.279 Uttam Kumaran: Do you guys want to chill, huh?

313 00:33:32.280 ⇒ 00:33:33.140 Henry Zhao: Okay.

314 00:33:34.300 ⇒ 00:33:36.690 Henry Zhao: I just want to ask you about the Klaviyo data.

315 00:33:37.140 ⇒ 00:33:38.520 Henry Zhao: I’m gonna share my screen.

316 00:33:38.850 ⇒ 00:33:39.659 Uttam Kumaran: Yeah, yeah, yeah.

317 00:33:39.660 ⇒ 00:33:42.979 Henry Zhao: First of all, I can connect this to a cursor, right?

318 00:33:45.440 ⇒ 00:33:49.510 Uttam Kumaran: Yeah, you can do that, but I think… I don’t know how to do that, I haven’t done it before.

319 00:33:49.760 ⇒ 00:33:59.160 Henry Zhao: Okay, but there’s, like, there’s pretty much no data in here. So the things that would be relevant are, like, campaigns, but I don’t have any data except for the name of the campaign.

320 00:33:59.420 ⇒ 00:34:08.509 Henry Zhao: And then metrics. It’s like, there’s only 127 rows, and it’s just, like, there’s no actual metric data. There’s no, like, opens, closes, clicks, nothing, really.

321 00:34:08.510 ⇒ 00:34:18.770 Uttam Kumaran: Yep, so let’s… let’s… let’s, like, diagnose. So, did you… so one, at this point, I would suggest you go to the source. So, this data’s coming from Polyatomic, so I would suggest…

322 00:34:19.370 ⇒ 00:34:22.459 Uttam Kumaran: Logging in there, and then let’s go look at, like, what they have.

323 00:34:23.199 ⇒ 00:34:23.889 Henry Zhao: Okay.

324 00:34:25.409 ⇒ 00:34:25.929 Uttam Kumaran: Yeah.

325 00:34:25.929 ⇒ 00:34:27.139 Henry Zhao: Alright.

326 00:34:32.209 ⇒ 00:34:35.359 Henry Zhao: How do I log into Polytomic? Oh, I’ll figure it out. Polyatomic…

327 00:34:37.590 ⇒ 00:34:39.099 Uttam Kumaran: And I believe you should have.

328 00:34:40.270 ⇒ 00:34:42.369 Henry Zhao: I think… I think Awash gave me access once.

329 00:34:46.020 ⇒ 00:34:55.129 Uttam Kumaran: Well, you’ll have access to Eden, but it’s… you won’t have access… you may not have access to Honey Stinger. Oh yeah, I invited you, so yeah, I’m not… I’m not seeing it on your screen, though, anymore.

330 00:34:57.060 ⇒ 00:34:57.820 Henry Zhao: Oh, okay.

331 00:35:23.980 ⇒ 00:35:26.780 Henry Zhao: metrics… 127…

332 00:35:30.790 ⇒ 00:35:33.080 Henry Zhao: Okay, I’m gonna go to, like, connections, maybe?

333 00:35:39.150 ⇒ 00:35:40.790 Henry Zhao: Models?

334 00:36:03.880 ⇒ 00:36:08.890 Uttam Kumaran: No, don’t do that. Go to Connections.

335 00:36:09.610 ⇒ 00:36:10.879 Henry Zhao: All I get is this.

336 00:36:11.290 ⇒ 00:36:12.750 Uttam Kumaran: Go to Klaviyo.

337 00:36:14.210 ⇒ 00:36:19.479 Uttam Kumaran: Yep, you’re not… well, no. Okay, Henry, you just gotta slow down. Just follow me, step by step.

338 00:36:19.480 ⇒ 00:36:20.239 Henry Zhao: Heck, you know?

339 00:36:20.240 ⇒ 00:36:21.300 Uttam Kumaran: of the best.

340 00:36:21.530 ⇒ 00:36:30.899 Uttam Kumaran: Okay, so this is the Klaviyo connection, this is how we’re accessing Klaviyos. There’s no configurations here. So now let’s go to Bulk Syncs on the left.

341 00:36:31.270 ⇒ 00:36:36.259 Uttam Kumaran: And bulk links indicates how Klaviyo gets landed into Mother Ducks, so you can click on that.

342 00:36:36.840 ⇒ 00:36:37.740 Henry Zhao: So, okay.

343 00:36:38.140 ⇒ 00:36:45.989 Uttam Kumaran: And it looks like, one, there’s, like, some type of issue, so if you hover over that little, error thing, click on details.

344 00:36:46.860 ⇒ 00:36:51.639 Uttam Kumaran: And you can just scroll here and see, like, what table had issues, potentially.

345 00:36:51.820 ⇒ 00:36:54.330 Uttam Kumaran: Okay, profiles had issues.

346 00:36:54.600 ⇒ 00:37:02.270 Uttam Kumaran: Okay, but I don’t… okay, this is maybe something… Else…

347 00:37:02.420 ⇒ 00:37:06.019 Uttam Kumaran: I guess one thing we can do is you can go ahead and hit close.

348 00:37:07.730 ⇒ 00:37:10.650 Uttam Kumaran: We can go ahead and check the configuration.

349 00:37:11.370 ⇒ 00:37:11.960 Henry Zhao: Okay.

350 00:37:12.240 ⇒ 00:37:13.140 Henry Zhao: Success?

351 00:37:14.240 ⇒ 00:37:16.610 Uttam Kumaran: You can see, like, what the table… oh, right here.

352 00:37:17.170 ⇒ 00:37:17.870 Henry Zhao: This one?

353 00:37:18.410 ⇒ 00:37:19.299 Uttam Kumaran: Right here.

354 00:37:19.960 ⇒ 00:37:21.409 Henry Zhao: Oh, configuration, okay.

355 00:37:22.280 ⇒ 00:37:25.740 Uttam Kumaran: And these are all the things that you get access to.

356 00:37:25.950 ⇒ 00:37:32.020 Uttam Kumaran: So, right now, every… it looks like everything is selected, so you should have all the data in Klaviyo.

357 00:37:32.180 ⇒ 00:37:36.570 Henry Zhao: And this is, like, all the data that you should be getting. So did you go ahead and check.

358 00:37:36.650 ⇒ 00:37:38.559 Uttam Kumaran: Did you check all these tables?

359 00:37:38.880 ⇒ 00:37:40.449 Henry Zhao: Yeah, I did. Checked all of them.

360 00:37:40.450 ⇒ 00:37:41.810 Uttam Kumaran: And you checked events?

361 00:37:43.710 ⇒ 00:37:44.519 Henry Zhao: Yeah.

362 00:37:44.830 ⇒ 00:37:47.030 Henry Zhao: So maybe it’s an events, let’s see.

363 00:37:47.030 ⇒ 00:37:48.799 Uttam Kumaran: Well, did you check events, or no?

364 00:37:48.800 ⇒ 00:37:49.380 Henry Zhao: Yeah.

365 00:37:50.090 ⇒ 00:37:51.410 Uttam Kumaran: And what was in events?

366 00:37:53.430 ⇒ 00:37:59.499 Uttam Kumaran: And never run… don’t run a select like this without a limit, because this table is…

367 00:37:59.500 ⇒ 00:38:00.020 Henry Zhao: Sorry.

368 00:38:00.230 ⇒ 00:38:05.210 Uttam Kumaran: 50 million rows, so I would just… Okay, and so…

369 00:38:05.690 ⇒ 00:38:09.130 Uttam Kumaran: I guess I’m, I’m, like, confused, like, what data do you need?

370 00:38:10.380 ⇒ 00:38:12.050 Uttam Kumaran: Cause this, like…

371 00:38:12.890 ⇒ 00:38:18.590 Henry Zhao: Because if we’re gonna run analysis on, like, the email content, right, we need to have the email content.

372 00:38:20.490 ⇒ 00:38:24.569 Uttam Kumaran: Okay, but, like… I guess what I’m trying to understand is, like.

373 00:38:25.350 ⇒ 00:38:28.450 Uttam Kumaran: Do you know what object that should be in?

374 00:38:30.000 ⇒ 00:38:32.740 Henry Zhao: I thought it was gonna be in campaigns.

375 00:38:33.090 ⇒ 00:38:35.860 Uttam Kumaran: like, well, I would just go to the Klaviyo docs.

376 00:38:36.140 ⇒ 00:38:36.860 Henry Zhao: Huh.

377 00:38:36.860 ⇒ 00:38:40.439 Uttam Kumaran: And start looking into, like, where that’s coming from.

378 00:38:41.260 ⇒ 00:38:47.049 Henry Zhao: Yeah. So… But showing this mother, this, polyatomic stuff was helpful.

379 00:38:47.230 ⇒ 00:38:48.810 Henry Zhao: So I know where to start.

380 00:38:48.810 ⇒ 00:38:59.929 Uttam Kumaran: Let’s keep… well, are you dropping? Let’s keep going. Like, I don’t… I still don’t feel like you’re… you’re there. So, let’s open up Klaviyo campaigns, like, the documentation, and confirm first

381 00:39:00.200 ⇒ 00:39:10.399 Uttam Kumaran: you first gotta just know what you’re looking for. And so, I would go into Klaviyo Docs and try to find out, like, what endpoint has the email data you’re looking for.

382 00:39:10.790 ⇒ 00:39:11.380 Henry Zhao: Okay.

383 00:39:12.750 ⇒ 00:39:17.319 Uttam Kumaran: And then, that’ll help you understand Is anything actually missing?

384 00:39:47.010 ⇒ 00:39:49.500 Henry Zhao: Yeah, so it would be campaign messages, content, right?

385 00:39:53.010 ⇒ 00:39:54.320 Henry Zhao: Yes. You know, so… Yes.

386 00:39:57.070 ⇒ 00:40:01.820 Henry Zhao: I’m just gonna embarrassing, but not limited to subject line, sending address, reply to address,

387 00:40:06.140 ⇒ 00:40:07.590 Henry Zhao: What did ChatGP say?

388 00:40:09.220 ⇒ 00:40:10.390 Henry Zhao: Excuse me about that.

389 00:40:44.760 ⇒ 00:40:45.680 Henry Zhao: I ain’t…

390 00:41:27.380 ⇒ 00:41:28.769 Henry Zhao: Not much info there.

391 00:41:50.920 ⇒ 00:41:51.740 Henry Zhao: Okay.

392 00:41:52.780 ⇒ 00:41:54.400 Henry Zhao: Which is… which is fine.

393 00:41:55.000 ⇒ 00:41:59.220 Henry Zhao: We don’t want… we don’t need the dynamic. We can just see that it is dynamic.

394 00:42:06.760 ⇒ 00:42:12.669 Uttam Kumaran: So, yeah, now I would go back into Mother Duck and see… If you have this.

395 00:42:13.310 ⇒ 00:42:14.699 Henry Zhao: I have the template, right?

396 00:42:16.210 ⇒ 00:42:16.910 Uttam Kumaran: Yep.

397 00:42:21.550 ⇒ 00:42:24.830 Uttam Kumaran: Well, open up the… open up the table, like…

398 00:42:25.050 ⇒ 00:42:27.049 Henry Zhao: Just run a select on the table.

399 00:42:36.080 ⇒ 00:42:36.610 Uttam Kumaran: So…

400 00:42:36.610 ⇒ 00:42:40.409 Henry Zhao: I was wondering if maybe it’s in the links?

401 00:42:40.410 ⇒ 00:42:45.029 Uttam Kumaran: Well, let’s just look. So, there’s a name, there’s some type of name here.

402 00:42:45.360 ⇒ 00:42:47.810 Uttam Kumaran: There’s some relationships, so keep going.

403 00:42:51.930 ⇒ 00:43:00.440 Uttam Kumaran: Yep, so there’s… But, so you’re sure that this is gonna be in the campaigns object?

404 00:43:03.040 ⇒ 00:43:06.189 Henry Zhao: I’m not sure, but I thought it was. I’m pretty sure in the past…

405 00:43:06.190 ⇒ 00:43:07.690 Uttam Kumaran: Let’s go back to the docs.

406 00:43:08.860 ⇒ 00:43:09.540 Henry Zhao: Okay.

407 00:43:11.420 ⇒ 00:43:17.910 Uttam Kumaran: And… it looks like in the Campaigns API, you have campaigns, you have messages.

408 00:43:19.940 ⇒ 00:43:21.609 Henry Zhao: Maybe it’s in chemical messages, right?

409 00:43:22.910 ⇒ 00:43:26.420 Uttam Kumaran: Well, I don’t know, it’s gonna be… let’s just… let’s… let’s find out, so…

410 00:43:27.110 ⇒ 00:43:33.490 Uttam Kumaran: Scroll through this, and let’s just check out. So, it looks like there’s some type of, like, Cam.

411 00:43:34.170 ⇒ 00:43:38.369 Uttam Kumaran: Well, is there a messages table? Like, is that what we’re supposed to be looking for?

412 00:43:39.050 ⇒ 00:43:40.530 Henry Zhao: I don’t think there’s a messages table.

413 00:43:40.790 ⇒ 00:43:43.069 Uttam Kumaran: No, no, no, like, in the API.

414 00:43:43.530 ⇒ 00:43:49.600 Uttam Kumaran: So first, this is where I start with the most upstream, which is Klaviyo, right? So where… which endpoint

415 00:43:49.890 ⇒ 00:43:52.759 Uttam Kumaran: should have this data. It’s, like, the simple question I’m asking.

416 00:43:52.770 ⇒ 00:43:56.609 Henry Zhao: No, this one, right? This, campaign slash blah blah blah campaign messages?

417 00:43:57.160 ⇒ 00:44:02.729 Uttam Kumaran: No, no, no, but, like, I want to see in the docs an example of the, like.

418 00:44:03.460 ⇒ 00:44:11.079 Uttam Kumaran: what you’re looking for, like, the actual, like, text of the copy, so… Looks like there’s campaign messages.

419 00:44:11.240 ⇒ 00:44:12.010 Henry Zhao: Right? Yep.

420 00:44:12.710 ⇒ 00:44:19.979 Uttam Kumaran: So… one thing, I would go back to Polytomic and go… you could go look into the campaigns.

421 00:44:21.510 ⇒ 00:44:26.570 Uttam Kumaran: Thing to see if there’s… if we see anything around campaign messages.

422 00:44:27.790 ⇒ 00:44:28.330 Henry Zhao: I shouldn’t.

423 00:44:28.330 ⇒ 00:44:30.540 Uttam Kumaran: Looks like there’s anything here, right?

424 00:44:31.910 ⇒ 00:44:33.609 Uttam Kumaran: And if you go under events.

425 00:44:35.660 ⇒ 00:44:39.280 Uttam Kumaran: It doesn’t look like there’s anything here, right, around messages?

426 00:44:39.690 ⇒ 00:44:40.490 Henry Zhao: No.

427 00:44:41.080 ⇒ 00:44:42.909 Henry Zhao: It’s like a metric, timestamp.

428 00:44:43.350 ⇒ 00:44:48.950 Uttam Kumaran: So my next ask is, like, if you… can you go to the polyatomic documentation on Klaviyo?

429 00:44:49.300 ⇒ 00:44:49.990 Henry Zhao: Okay.

430 00:45:50.710 ⇒ 00:45:57.610 Uttam Kumaran: So if you just go to… if you just type in, well, this is the Polytomic API, so you just type…

431 00:45:57.880 ⇒ 00:46:07.910 Uttam Kumaran: what we’re not looking for the polyatomic… we’re just looking for polyatomic docks, like the docks on their connectors. So you just type in polyatomic Klaviyo, yep.

432 00:46:08.360 ⇒ 00:46:16.539 Uttam Kumaran: And this is what… Not that one, actually, like, type in integrations.

433 00:46:17.080 ⇒ 00:46:18.149 Uttam Kumaran: Like, here.

434 00:46:18.570 ⇒ 00:46:20.160 Uttam Kumaran: Oh, right here, right here, right here.

435 00:46:22.020 ⇒ 00:46:25.500 Uttam Kumaran: And just type in Klaviyo and see if you can see the docs.

436 00:46:36.570 ⇒ 00:46:37.710 Uttam Kumaran: No docs.

437 00:46:38.680 ⇒ 00:46:40.029 Henry Zhao: Nothing happens when I cook it.

438 00:46:40.920 ⇒ 00:46:42.750 Uttam Kumaran: Can you click on resources?

439 00:46:43.820 ⇒ 00:46:45.850 Henry Zhao: Mmm… resources, okay.

440 00:46:47.380 ⇒ 00:46:48.600 Henry Zhao: Documentation?

441 00:46:48.980 ⇒ 00:46:49.570 Uttam Kumaran: Yep.

442 00:46:51.130 ⇒ 00:46:56.500 Uttam Kumaran: And so… Try to look for here, like, they should have docs on all their integrations.

443 00:47:12.650 ⇒ 00:47:17.360 Uttam Kumaran: Okay, so I would take a look at this and see if there’s anything that helps helpful here.

444 00:47:21.010 ⇒ 00:47:22.279 Henry Zhao: Like, there’s not much here.

445 00:47:22.980 ⇒ 00:47:24.300 Henry Zhao: Oh my god…

446 00:47:31.580 ⇒ 00:47:32.639 Henry Zhao: That’s all they have.

447 00:47:35.050 ⇒ 00:47:37.820 Uttam Kumaran: Okay, then this is where I… this is where I would…

448 00:47:38.070 ⇒ 00:47:48.590 Uttam Kumaran: at this point, given, like, we’ve… this is where, like, when you go to ask Polyatomic a question, you should indicate all the stuff we’ve tried, right? Okay.

449 00:47:48.760 ⇒ 00:47:57.619 Uttam Kumaran: One is we looked at… you should note down, like, where… which exact API endpoint we’re looking for, which is the campaign messages.

450 00:47:57.940 ⇒ 00:47:59.970 Uttam Kumaran: Right? Yeah.

451 00:48:00.360 ⇒ 00:48:11.619 Uttam Kumaran: Second, what we’re looking for is… we’ve looked into our sinks, and it’s not… basically not there. And so you can ask, hey, can… is there any way we can get access to this?

452 00:48:12.160 ⇒ 00:48:17.650 Henry Zhao: Okay, and another thing I would do first is I would check, like, if Segment has it. If they have the same fields, it’s probably, like,

453 00:48:17.820 ⇒ 00:48:19.490 Henry Zhao: Like, those are the only things available.

454 00:48:21.710 ⇒ 00:48:27.590 Uttam Kumaran: Yeah, I mean, if you could send them… if Segment has documentation on… on what it is, but, like, at that…

455 00:48:28.380 ⇒ 00:48:33.769 Uttam Kumaran: Polytomic is pretty good, so as long as you just give them as much info as possible, they’ll be helpful.

456 00:48:34.450 ⇒ 00:48:35.160 Henry Zhao: Okay.

457 00:48:35.480 ⇒ 00:48:38.979 Henry Zhao: Okay, that was helpful to show, like, how you would do this train of thought.

458 00:48:39.250 ⇒ 00:48:45.719 Uttam Kumaran: Oh, yeah, so if you go up… so if you… let’s close this out. So let’s go… if you go to the Polyatomic channel, vendor polyatomic.

459 00:48:46.140 ⇒ 00:48:59.680 Uttam Kumaran: I would just go ahead and send a note in there, and at… at Golib, who’s the CEO, you can just go ahead and send a note saying, hey, we’re working on this… we’re working on Klaviyo data for Honey Stinger.

460 00:49:00.740 ⇒ 00:49:02.530 Uttam Kumaran: And you can just mention…

461 00:49:02.990 ⇒ 00:49:09.800 Uttam Kumaran: Kind of, like, what we’re missing, what we’re looking to do, and then you can link to all the stuff that we found.

462 00:49:14.050 ⇒ 00:49:15.010 Henry Zhao: Okay.

463 00:49:21.710 ⇒ 00:49:28.020 Henry Zhao: I want to think also about what other data I need, though. So, like you said, just looking at opens, clicks, and unsubscribes is not enough.

464 00:49:28.380 ⇒ 00:49:36.060 Henry Zhao: Because they probably already have a sense of that, and it’s already in the Klaviyo UI. But besides, email text…

465 00:49:36.190 ⇒ 00:49:41.110 Henry Zhao: I probably also kind of want to know, like, what the purpose is, and what metrics those drove, right?

466 00:49:42.320 ⇒ 00:49:45.829 Uttam Kumaran: Yeah, but again, I would say polyatomic is not…

467 00:49:46.230 ⇒ 00:49:49.610 Uttam Kumaran: they’re not gonna be able to help on, like, strategy.

468 00:49:49.610 ⇒ 00:49:50.480 Henry Zhao: Right, buddy.

469 00:49:50.480 ⇒ 00:49:56.469 Uttam Kumaran: landing data, right? So, yeah, if you can batch as many requests as possible, I would go ahead, but…

470 00:49:58.000 ⇒ 00:50:03.229 Henry Zhao: Yeah, but, like, right now, this metrics table is not helpful for me, because there’s no information in it.

471 00:50:03.750 ⇒ 00:50:08.010 Henry Zhao: So I probably need to look into the metrics table also and figure out what I need there.

472 00:50:08.210 ⇒ 00:50:10.949 Henry Zhao: And then… and then message polyatomic.

473 00:50:11.890 ⇒ 00:50:16.999 Uttam Kumaran: Exactly, yeah, and I would say, again, like, as long as it’s indicated in the Klaviyo API,

474 00:50:17.360 ⇒ 00:50:20.029 Uttam Kumaran: And you see that there’s a distance, they’ll build it for you.

475 00:50:21.120 ⇒ 00:50:21.760 Henry Zhao: Yeah.

476 00:50:23.140 ⇒ 00:50:32.790 Henry Zhao: I mean, if Honey Stinger is just trying to sell their product, like, what other metrics should we… let’s… I just want to think this, like, think out loud, like, what other metrics should we be looking at that are Klaviyo-related?

477 00:50:33.560 ⇒ 00:50:51.229 Henry Zhao: I mean, there’s two things, right? One is awareness, one is actual converting to purchases, right? So, are they reading the emails? In other words, like, being aware of the offers that are going on, that Honey Stinger exists? And then number two, are they then actually converting into purchasing, which ties into the customer stitching, right?

478 00:50:53.610 ⇒ 00:51:02.479 Uttam Kumaran: Exactly, yeah. I mean, basically, you want to just get a, like… I think otherwise, you should have all the information, like, the events should all ideally be, like.

479 00:51:03.250 ⇒ 00:51:08.650 Uttam Kumaran: I don’t know, the types of emails that are, like, basically, like, email sent, email open, right? Is that what’s in events?

480 00:51:10.030 ⇒ 00:51:11.650 Henry Zhao: I thought it would be in metrics.

481 00:51:15.850 ⇒ 00:51:21.880 Henry Zhao: Actually, I was more used to it being separate tables. There was, like, a clicks table, an opens table.

482 00:51:21.880 ⇒ 00:51:24.749 Uttam Kumaran: Go to Event Properties, like, click on one of those.

483 00:51:25.010 ⇒ 00:51:27.969 Uttam Kumaran: Like, yeah, just click on one of the values.

484 00:51:28.810 ⇒ 00:51:31.550 Uttam Kumaran: And just see, like, what’s in here. So it looks like…

485 00:51:32.210 ⇒ 00:51:33.299 Henry Zhao: That’s pretty cool.

486 00:51:33.300 ⇒ 00:51:35.519 Uttam Kumaran: And then click on Items, the bottom.

487 00:51:35.970 ⇒ 00:51:36.720 Henry Zhao: Okay…

488 00:51:39.160 ⇒ 00:51:50.300 Uttam Kumaran: Let’s see, some of these events, I don’t know what these are, but again, you just have to go discover, so, like, I would say make sure to go through every table and all the columns before jumping to the conclusion, because.

489 00:51:50.300 ⇒ 00:51:51.070 Henry Zhao: Yep, I will.

490 00:51:51.070 ⇒ 00:51:54.979 Uttam Kumaran: It’s most likely in there, just may not be modeled, and so this is where

491 00:51:55.310 ⇒ 00:52:00.140 Uttam Kumaran: if you need it modeled in a certain way, then that’s where, like, Mustafa will sort of support.

492 00:52:00.960 ⇒ 00:52:09.509 Henry Zhao: Okay, so I’m gonna go through the… it’s probably in the events table, because it looks like this is pretty robust. So, before I method polyatomic, I’m… this is good guidance, I’m gonna look through the events table.

493 00:52:10.810 ⇒ 00:52:12.880 Henry Zhao: It’s probably… a lot of stuff’s probably in there.

494 00:52:13.090 ⇒ 00:52:14.130 Uttam Kumaran: Okay, okay.

495 00:52:21.170 ⇒ 00:52:33.400 Henry Zhao: Actually, now that I think of it, I think some of those tables that I used in the past, like opens, clicks, they probably were modeled from the events table. They were probably parsed from the properties and created that stuff. Yeah, so, I will look into events. That’s a good point. Okay.

496 00:52:34.020 ⇒ 00:52:36.390 Henry Zhao: Alright, thanks for this working session, that was really helpful.

497 00:52:36.560 ⇒ 00:52:39.119 Uttam Kumaran: Yeah, dude, I’m just gonna… I’m gonna try to do as many…

498 00:52:39.550 ⇒ 00:52:48.410 Uttam Kumaran: I’m just gonna be working on stuff, so… yeah, I think this is, like, really helpful. I just want to walk everybody through, like, how I would solve some of these, and then…

499 00:52:49.080 ⇒ 00:52:51.219 Uttam Kumaran: Yeah, I feel like this is effective.

500 00:52:53.060 ⇒ 00:53:07.169 Henry Zhao: Yeah, and I, like, to be completely honest, I feel like that I kind of, like, fell off on README, is because, like, when I got stuck like this, I would kind of just, like, move on to Eden, and kind of, like, try to think about it, but if I just took some time to kind of try and unblock it like this…

501 00:53:07.300 ⇒ 00:53:09.930 Henry Zhao: I would’ve… unblocked it, if I had asked for help.

502 00:53:09.930 ⇒ 00:53:10.770 Uttam Kumaran: Yeah.

503 00:53:10.930 ⇒ 00:53:16.319 Uttam Kumaran: Yeah, so I’ll try… I’m gonna try my best to do these, but yeah, I… I… I feel like,

504 00:53:16.890 ⇒ 00:53:19.449 Uttam Kumaran: Yeah, we just gotta do more of these, so… no problem.

505 00:53:19.450 ⇒ 00:53:26.100 Henry Zhao: Yeah, but I learned from that experience, I learned that, like, I shouldn’t be using Eden as an excuse to basically, like, procrastinate, right, like, when I got stuck on something.

506 00:53:26.480 ⇒ 00:53:31.300 Uttam Kumaran: Yeah, like, for all these, we have to push forward, or basically say, like, hey, I’m stuck, you know? So… Yeah.

507 00:53:33.250 ⇒ 00:53:34.100 Uttam Kumaran: Yeah.

508 00:53:35.880 ⇒ 00:53:36.750 Uttam Kumaran: Okay.

509 00:53:37.130 ⇒ 00:53:37.940 Uttam Kumaran: Cool.

510 00:53:41.260 ⇒ 00:53:50.189 Uttam Kumaran: Yeah, let me think about what’s next. So, maybe, Mustafa, I can ask you to go ahead and set up, like, dbt Cloud for…

511 00:53:50.530 ⇒ 00:53:59.700 Uttam Kumaran: Or, what’s it called? Honey Singer?

512 00:54:04.930 ⇒ 00:54:05.590 Mustafa Raja: Yeah, I mean.

513 00:54:06.000 ⇒ 00:54:09.670 Mustafa Raja: how do we set up in this marathon?

514 00:55:17.760 ⇒ 00:55:21.029 Mustafa Raja: So this is going to be, a repository, right? So…

515 00:55:22.950 ⇒ 00:55:23.920 Uttam Kumaran: Huh?

516 00:55:24.470 ⇒ 00:55:28.979 Mustafa Raja: This is going… the code is going to live on some GitHub repo, right?

517 00:55:28.980 ⇒ 00:55:31.339 Uttam Kumaran: GitHub, so we’ll need to create a new GitHub repo.

518 00:55:32.130 ⇒ 00:55:32.890 Mustafa Raja: Yeah.

519 00:55:33.860 ⇒ 00:55:38.369 Mustafa Raja: So, let me know what you should call it, I mean, I’ll go ahead and do that.

520 00:55:41.260 ⇒ 00:55:43.359 Uttam Kumaran: Yeah, feel free, go ahead. You can go ahead.

521 00:55:45.310 ⇒ 00:55:48.539 Demilade Agboola: These stuff are just random, but there’s an echo when you talk.

522 00:55:50.120 ⇒ 00:55:50.590 Uttam Kumaran: Oh, me?

523 00:55:50.590 ⇒ 00:55:51.480 Mustafa Raja: when I talk.

524 00:55:51.720 ⇒ 00:55:54.640 Demilade Agboola: Yeah, Mustavo was, like, static, I don’t know how to explain, but…

525 00:55:54.640 ⇒ 00:55:58.030 Uttam Kumaran: Oh yeah, I feel like your audio’s usually good, it sounds a little bit staticky.

526 00:55:59.310 ⇒ 00:56:01.049 Mustafa Raja: Is this better?

527 00:56:01.500 ⇒ 00:56:02.190 Uttam Kumaran: Yes.

528 00:56:02.190 ⇒ 00:56:03.259 Demilade Agboola: In Bits, yeah.

529 00:56:04.280 ⇒ 00:56:08.440 Mustafa Raja: Yeah, I was, I was using my Mac’s microphone.

530 00:56:08.700 ⇒ 00:56:10.409 Mustafa Raja: Not my headphones, so…

531 00:56:42.580 ⇒ 00:56:46.279 Mustafa Raja: I’m calling this any single data platform in the report.

532 00:56:48.270 ⇒ 00:56:50.789 Uttam Kumaran: Yeah, you can just say… yeah, you can… that’s fine.

533 01:00:29.870 ⇒ 01:00:32.560 Henry Zhao: Okay, yeah, that was right, it’s all in the events table.

534 01:00:33.600 ⇒ 01:00:34.330 Uttam Kumaran: Cool.

535 01:00:38.470 ⇒ 01:00:42.579 Uttam Kumaran: But you still need that messages content, right? So I would send that to them.

536 01:00:42.580 ⇒ 01:00:44.480 Henry Zhao: I think I found it, actually. I think…

537 01:00:44.480 ⇒ 01:00:45.200 Uttam Kumaran: Oh.

538 01:00:45.350 ⇒ 01:00:53.320 Henry Zhao: So just for people to learn, out of curiosity. So basically, this metrics table is literally just actually the mapping of metric type, so…

539 01:00:53.790 ⇒ 01:00:54.630 Uttam Kumaran: Oh, okay.

540 01:00:54.630 ⇒ 01:00:59.379 Henry Zhao: that I want… if I want to see people that received an email, it’s in events.

541 01:00:59.650 ⇒ 01:01:01.810 Henry Zhao: Where, like, the idea is this.

542 01:01:02.310 ⇒ 01:01:09.420 Henry Zhao: So, if I just look at metricData.id as that, these are all the opened emails, and so then everything is in event properties.

543 01:01:12.000 ⇒ 01:01:12.680 Uttam Kumaran: Okay.

544 01:01:13.460 ⇒ 01:01:14.240 Henry Zhao: I think.

545 01:01:16.880 ⇒ 01:01:19.949 Henry Zhao: Yeah, so somebody opened the email, 3 Tips to Tackle Life’s Hurdles.

546 01:01:20.850 ⇒ 01:01:26.559 Henry Zhao: The message is not here, but it’s probably somewhere else. I’ll do some more digging, but yeah, feel like I made some progress.

547 01:01:27.040 ⇒ 01:01:28.019 Uttam Kumaran: Cool, okay.

548 01:02:12.650 ⇒ 01:02:13.300 Demilade Agboola: No, Tom.

549 01:02:14.840 ⇒ 01:02:15.630 Uttam Kumaran: Hey!

550 01:02:15.630 ⇒ 01:02:19.509 Demilade Agboola: I’m trying to set up the dev environment for Hydra.

551 01:02:19.720 ⇒ 01:02:20.620 Demilade Agboola: And I’m trying to set up.

552 01:02:20.620 ⇒ 01:02:20.940 Uttam Kumaran: Okay.

553 01:02:20.940 ⇒ 01:02:26.290 Demilade Agboola: an access token using my account, and it’s saying it’s not allowed.

554 01:02:29.950 ⇒ 01:02:33.329 Uttam Kumaran: When, which one, what, what software?

555 01:02:36.230 ⇒ 01:02:36.860 Demilade Agboola: Pardon?

556 01:02:37.320 ⇒ 01:02:40.029 Uttam Kumaran: In, like, in… in what tool, in dbt?

557 01:02:40.890 ⇒ 01:02:41.780 Demilade Agboola: And Snowflake.

558 01:02:43.470 ⇒ 01:02:49.319 Demilade Agboola: So, right here… So here’s the Heartini, so I’m trying to set up a devo.

559 01:02:49.720 ⇒ 01:02:55.210 Demilade Agboola: It says, okay, so I… I tried using his name and password, didn’t work.

560 01:02:55.600 ⇒ 01:02:57.349 Demilade Agboola: Let’s use a key pair.

561 01:02:58.820 ⇒ 01:02:59.470 Uttam Kumaran: Okay.

562 01:03:00.480 ⇒ 01:03:02.279 Demilade Agboola: So I’m trying to set up,

563 01:03:06.850 ⇒ 01:03:09.349 Demilade Agboola: I set up, this token.

564 01:03:12.910 ⇒ 01:03:13.630 Uttam Kumaran: Oh.

565 01:03:13.910 ⇒ 01:03:15.749 Mustafa Raja: This is for DBT, though?

566 01:03:16.160 ⇒ 01:03:16.930 Demilade Agboola: Yeah.

567 01:03:16.930 ⇒ 01:03:21.910 Uttam Kumaran: Oh, my suggestion is to just use… let’s just use the service account.

568 01:03:22.230 ⇒ 01:03:32.890 Uttam Kumaran: I… I did this last night, actually, I had the same issue. So, I… my suggestion is just to… don’t use your… your, your creds for… for dbt Cloud.

569 01:03:33.060 ⇒ 01:03:37.400 Uttam Kumaran: Use, the service user…

570 01:03:38.010 ⇒ 01:03:39.550 Demilade Agboola: Is that one pass?

571 01:03:40.180 ⇒ 01:03:44.899 Uttam Kumaran: Yeah, let me just… Let me just confirm that it’s in 1Password for you.

572 01:03:45.740 ⇒ 01:03:49.660 Demilade Agboola: Also, I don’t think there’s a Hedra or a Vault. Don’t have access to doublet.

573 01:03:49.980 ⇒ 01:03:50.880 Demilade Agboola: does exist.

574 01:03:53.000 ⇒ 01:03:55.099 Uttam Kumaran: Yeah, let me cut you in there, too.

575 01:05:36.950 ⇒ 01:05:43.530 Mustafa Raja: So, for dbt account, do we have, dbt Cloud? Do we have a dbt account?

576 01:05:43.780 ⇒ 01:05:45.219 Mustafa Raja: that I need to log in.

577 01:05:46.100 ⇒ 01:05:52.880 Uttam Kumaran: This is for Honey Stinger? No, so I would… I would make one with the Honey Stinger email.

578 01:05:58.610 ⇒ 01:06:01.729 Uttam Kumaran: Okay, let me… and let me make sure you guys have groups created.

579 01:06:18.660 ⇒ 01:06:21.370 Uttam Kumaran: And yeah, ask any questions while you’re going through them, Stoffa.

580 01:06:50.440 ⇒ 01:06:57.420 Uttam Kumaran: Okay, I added you guys to the vault, but let me… sorry, it’s the passphrase is in my laptop, so let me grab that.

581 01:08:44.710 ⇒ 01:08:49.280 Uttam Kumaran: Demolat, I also looped you in in Slack, so if you want to just say hi to the team there.

582 01:08:53.720 ⇒ 01:08:56.230 Demilade Agboola: Leah, I’m just asking a message to Cinder.

583 01:08:57.020 ⇒ 01:08:57.710 Uttam Kumaran: Okay.

584 01:09:04.790 ⇒ 01:09:08.350 Mustafa Raja: Can I add… can I be added to the…

585 01:09:09.569 ⇒ 01:09:12.709 Uttam Kumaran: Mustafa, it’s still, like, your mic is still, like, kind of messed up.

586 01:09:19.479 ⇒ 01:09:21.029 Mustafa Raja: Is this better?

587 01:09:21.029 ⇒ 01:09:22.909 Uttam Kumaran: He.

588 01:09:22.910 ⇒ 01:09:24.889 Mustafa Raja: Okay, let me get new headphones.

589 01:09:24.919 ⇒ 01:09:26.259 Uttam Kumaran: Okay, okay.

590 01:09:27.520 ⇒ 01:09:34.100 Demilade Agboola: It kind of sounds like, you know when someone is, like, plugged… plugged in? Like, there’s an electric car flowing through at the same time.

591 01:09:34.109 ⇒ 01:09:35.640 Uttam Kumaran: Yeah… That’s result.

592 01:09:35.640 ⇒ 01:09:36.250 Demilade Agboola: It’s like…

593 01:09:40.840 ⇒ 01:09:42.560 Mustafa Raja: How is this one?

594 01:09:44.140 ⇒ 01:09:44.850 Uttam Kumaran: Better?

595 01:09:46.010 ⇒ 01:09:47.330 Demilade Agboola: Much better.

596 01:09:49.029 ⇒ 01:09:53.239 Mustafa Raja: Yeah, can I be added to any single vault in OnePlus?

597 01:09:53.970 ⇒ 01:09:55.330 Uttam Kumaran: Yeah, you should be in there now.

598 01:09:56.220 ⇒ 01:09:56.960 Mustafa Raja: Okay.

599 01:10:46.230 ⇒ 01:10:49.490 Uttam Kumaran: Okay, I’ve added the service user transform.

600 01:10:49.790 ⇒ 01:10:50.600 Uttam Kumaran: There.

601 01:14:38.850 ⇒ 01:14:40.979 Uttam Kumaran: Thank you, appreciate it.

602 01:18:10.330 ⇒ 01:18:16.030 Mustafa Raja: Do we want to set up, Postgres on… Docker for this?

603 01:18:22.430 ⇒ 01:18:23.660 Uttam Kumaran: Do we have to do that?

604 01:18:24.710 ⇒ 01:18:33.450 Mustafa Raja: Yeah, so the documents that you, for the mother duck connection you’ve shared, they… they need pg.tb.

605 01:18:34.050 ⇒ 01:18:38.870 Mustafa Raja: And that is a Postgres instance with pg.db installed.

606 01:18:42.670 ⇒ 01:18:52.740 Mustafa Raja: So, we need to run Postgres somewhere. It doesn’t have to be on Docker, but somewhere, and we have to have pg.dp installed.

607 01:18:57.270 ⇒ 01:19:00.830 Mustafa Raja: And then we can, connect with dbt Cloud.

608 01:19:02.700 ⇒ 01:19:04.769 Uttam Kumaran: Oh, I didn’t know.

609 01:19:05.050 ⇒ 01:19:10.609 Mustafa Raja: Postgres would connect, and the Postgres would then be linking to MotherDuck.

610 01:19:21.140 ⇒ 01:19:25.519 Mustafa Raja: I guess I can ask, Abhiish if he has any context on this.

611 01:19:28.790 ⇒ 01:19:31.460 Uttam Kumaran: I just didn’t know we’re gonna need to install…

612 01:19:32.790 ⇒ 01:19:33.640 Mustafa Raja: Who’s nice.

613 01:19:34.520 ⇒ 01:19:35.330 Uttam Kumaran: Yeah.

614 01:20:38.520 ⇒ 01:20:40.159 Uttam Kumaran: That’s kinda stupid.

615 01:20:46.550 ⇒ 01:20:49.270 Mustafa Raja: I believe we have the data in Snowflake.

616 01:20:49.270 ⇒ 01:20:54.580 Uttam Kumaran: Actually, like, maybe we shouldn’t do… dbt Cloud, then.

617 01:20:55.160 ⇒ 01:20:57.490 Uttam Kumaran: Maybe we just have to get it set up locally.

618 01:20:57.820 ⇒ 01:20:58.520 Uttam Kumaran: For now.

619 01:20:58.520 ⇒ 01:20:59.930 Mustafa Raja: dbt Core?

620 01:21:00.290 ⇒ 01:21:01.070 Uttam Kumaran: Yeah.

621 01:21:02.030 ⇒ 01:21:07.629 Mustafa Raja: Okay, just for the context, I created a dbt Cloud account.

622 01:21:08.380 ⇒ 01:21:11.960 Mustafa Raja: For Honey Stinger in their profile.

623 01:21:13.220 ⇒ 01:21:14.299 Uttam Kumaran: Okay, that’s fine.

624 01:21:14.300 ⇒ 01:21:18.109 Mustafa Raja: I’ll just go ahead with the… dbt Core for now, then.

625 01:21:20.210 ⇒ 01:21:24.729 Uttam Kumaran: Yeah, I feel like it says you still need S3, right?

626 01:21:27.250 ⇒ 01:21:28.570 Uttam Kumaran: Or… oh.

627 01:21:31.120 ⇒ 01:21:32.990 Mustafa Raja: dbt.db…

628 01:21:36.240 ⇒ 01:21:37.350 Mustafa Raja: Yeah.

629 01:21:40.300 ⇒ 01:21:42.610 Mustafa Raja: The settings have… dot…

630 01:22:08.920 ⇒ 01:22:11.339 Mustafa Raja: Why do we need an S3 there, though?

631 01:22:17.640 ⇒ 01:22:18.960 Uttam Kumaran: Hmm, I don’t know.

632 01:22:35.020 ⇒ 01:22:37.679 Uttam Kumaran: Maybe try it, try it without S3, see what happens.

633 01:22:37.680 ⇒ 01:22:38.670 Mustafa Raja: Yeah.

634 01:22:39.060 ⇒ 01:22:40.960 Mustafa Raja: This is that.

635 01:22:59.600 ⇒ 01:23:00.300 Demilade Agboola: Bye, Tom.

636 01:23:03.510 ⇒ 01:23:04.290 Uttam Kumaran: Sorry?

637 01:23:04.680 ⇒ 01:23:11.289 Demilade Agboola: So the… Key pair doesn’t seem to be working. The private key, for some reason, keeps saying…

638 01:23:12.220 ⇒ 01:23:14.550 Demilade Agboola: But not deserialize the key data.

639 01:23:18.370 ⇒ 01:23:22.740 Uttam Kumaran: Try to do it without the strings at the top and the bottom.

640 01:23:23.250 ⇒ 01:23:25.050 Demilade Agboola: Yeah, did,

641 01:23:28.290 ⇒ 01:23:29.869 Demilade Agboola: Still got the same error.

642 01:23:30.000 ⇒ 01:23:31.669 Demilade Agboola: Let me try that again.

643 01:23:37.840 ⇒ 01:23:39.020 Uttam Kumaran: Hmm, okay.

644 01:23:39.790 ⇒ 01:23:41.530 Demilade Agboola: Yeah, literally just a vent now.

645 01:23:44.480 ⇒ 01:23:45.590 Demilade Agboola: Oh…

646 01:23:47.430 ⇒ 01:23:53.070 Uttam Kumaran: Service user transform private key… oh, passphrase. So, in the passphrase, put PASS.

647 01:23:53.180 ⇒ 01:23:54.270 Uttam Kumaran: Just pass.

648 01:23:54.640 ⇒ 01:23:55.640 Uttam Kumaran: Capital P.

649 01:23:57.720 ⇒ 01:23:58.500 Demilade Agboola: Okay.

650 01:23:59.060 ⇒ 01:24:01.260 Demilade Agboola: It was optional, so I didn’t…

651 01:24:02.080 ⇒ 01:24:07.579 Uttam Kumaran: Yeah, the problem is it’s opti- it says it’s optional, but,

652 01:24:08.880 ⇒ 01:24:14.209 Uttam Kumaran: I don’t think it was, like, because I did this last night, and it was… ended up not being optional.

653 01:24:18.530 ⇒ 01:24:20.099 Demilade Agboola: If it’s not.

654 01:24:20.100 ⇒ 01:24:24.310 Uttam Kumaran: If it’s not capital P, try lower… try lowercase p. Sorry.

655 01:24:24.310 ⇒ 01:24:27.899 Demilade Agboola: Or actually, I think you just… you had it, so I just copied it in there.

656 01:24:28.830 ⇒ 01:24:31.440 Uttam Kumaran: Okay, yeah, try lowercase p-as-s.

657 01:24:38.420 ⇒ 01:24:44.810 Uttam Kumaran: But, could not deserialize the data. Oh, okay, something else is happening then.

658 01:24:44.970 ⇒ 01:24:47.459 Uttam Kumaran: Can you go… can you scroll up?

659 01:24:52.090 ⇒ 01:25:00.619 Uttam Kumaran: Service user transform… Okay, maybe…

660 01:25:05.280 ⇒ 01:25:05.809 Uttam Kumaran: Mmm…

661 01:25:15.210 ⇒ 01:25:16.730 Uttam Kumaran: That should be it.

662 01:25:16.960 ⇒ 01:25:19.669 Uttam Kumaran: And you did try with the string, also?

663 01:25:20.570 ⇒ 01:25:21.260 Demilade Agboola: Yeah.

664 01:25:21.860 ⇒ 01:25:22.800 Uttam Kumaran: What the heck?

665 01:25:23.370 ⇒ 01:25:25.759 Demilade Agboola: This was… this was what was dead before.

666 01:25:26.780 ⇒ 01:25:32.100 Demilade Agboola: Confirming that… I got this in.

667 01:25:46.660 ⇒ 01:25:47.530 Uttam Kumaran: Boom.

668 01:25:53.800 ⇒ 01:25:59.409 Uttam Kumaran: Okay, let me… I guess check it out on my side.

669 01:26:24.450 ⇒ 01:26:27.029 Uttam Kumaran: Yeah, it is capital P-A-S-S.

670 01:26:28.390 ⇒ 01:26:30.030 Demilade Agboola: Thus.

671 01:26:30.030 ⇒ 01:26:35.910 Uttam Kumaran: Capital… just capital P, yeah, and then lowercase ASS. And then try the private key with everything.

672 01:26:36.390 ⇒ 01:26:39.019 Uttam Kumaran: With the strings, also?

673 01:26:39.920 ⇒ 01:26:40.850 Demilade Agboola: Oh, okay.

674 01:26:50.480 ⇒ 01:26:53.369 Demilade Agboola: And then… let me try the public key.

675 01:26:56.500 ⇒ 01:27:00.080 Demilade Agboola: There’s… Seeing if anything works.

676 01:27:05.760 ⇒ 01:27:08.649 Uttam Kumaran: What in the world?

677 01:27:10.480 ⇒ 01:27:17.569 Uttam Kumaran: Hmm… Okay, let’s try something else, maybe.

678 01:27:19.100 ⇒ 01:27:26.700 Demilade Agboola: As it goes… I mean, it does say interpersonal development credentials here, not deployment credentials.

679 01:27:28.630 ⇒ 01:27:29.350 Demilade Agboola: Dude, don’t.

680 01:27:29.350 ⇒ 01:27:33.600 Uttam Kumaran: Yeah, I guess it doesn’t, but, like, I don’t… I don’t know, it’s like…

681 01:27:34.710 ⇒ 01:27:37.939 Uttam Kumaran: I guess technically, sure, but.

682 01:27:39.090 ⇒ 01:27:39.610 Demilade Agboola: benchmark.

683 01:27:41.270 ⇒ 01:27:48.830 Uttam Kumaran: For the role at the top, can you put role… Underscore prod underscore write.

684 01:28:19.620 ⇒ 01:28:21.790 Uttam Kumaran: And then try a test with yours.

685 01:28:24.440 ⇒ 01:28:25.070 Demilade Agboola: Pardon?

686 01:28:26.440 ⇒ 01:28:29.280 Uttam Kumaran: Yeah, go ahead and try to test with your credentials, what does it say?

687 01:28:29.830 ⇒ 01:28:32.660 Demilade Agboola: Yes, anytime I say we’ll blah blah blah.

688 01:28:34.880 ⇒ 01:28:35.489 Demilade Agboola: And it costs.

689 01:28:35.490 ⇒ 01:28:43.729 Uttam Kumaran: So, the other thing you can do is you can go and set up… so, you said you were trying to set up MFA, you can go ahead and set up with Duo.

690 01:28:44.710 ⇒ 01:28:45.930 Demilade Agboola: Yeah, so I…

691 01:28:46.310 ⇒ 01:28:50.609 Uttam Kumaran: The default method you should select to the right there is the TOTP.

692 01:28:51.390 ⇒ 01:28:52.410 Uttam Kumaran: On the right.

693 01:28:53.110 ⇒ 01:28:53.980 Uttam Kumaran: Select a method.

694 01:28:56.900 ⇒ 01:28:57.560 Demilade Agboola: It’s all okay.

695 01:28:57.560 ⇒ 01:28:58.830 Uttam Kumaran: Yeah. Yeah.

696 01:29:02.380 ⇒ 01:29:05.069 Uttam Kumaran: Yeah, now… now go tr… now try it again?

697 01:29:46.770 ⇒ 01:29:51.490 Demilade Agboola: First indicator, please provide both your password and your current COTP password.

698 01:29:51.850 ⇒ 01:29:54.000 Demilade Agboola: Basically, any spot for that?

699 01:29:56.330 ⇒ 01:29:57.749 Uttam Kumaran: Yeah, I don’t know either.

700 01:30:54.700 ⇒ 01:30:56.390 Uttam Kumaran: WTF, I don’t know.

701 01:30:57.930 ⇒ 01:30:59.350 Demilade Agboola: Right.

702 01:30:59.560 ⇒ 01:31:00.570 Demilade Agboola: Weird one.

703 01:31:05.420 ⇒ 01:31:10.260 Uttam Kumaran: I can try to, log in with your,

704 01:31:11.700 ⇒ 01:31:15.559 Uttam Kumaran: on my end and do it, because I just did it last night for me. Do you want me to try that?

705 01:31:16.970 ⇒ 01:31:19.180 Demilade Agboola: For the dev environment.

706 01:31:19.180 ⇒ 01:31:19.960 Uttam Kumaran: Yeah.

707 01:31:21.270 ⇒ 01:31:22.139 Demilade Agboola: Yeah, sure.

708 01:31:22.140 ⇒ 01:31:24.419 Uttam Kumaran: I don’t know, maybe I copied and pasted some… I don’t know.

709 01:31:27.750 ⇒ 01:31:32.650 Uttam Kumaran: You have your credentials for dbt?

710 01:31:33.460 ⇒ 01:31:36.650 Uttam Kumaran: Or is it just… yeah, if you wanna…

711 01:31:39.920 ⇒ 01:31:43.049 Uttam Kumaran: Send those to me, I can try to do it on my laptop.

712 01:31:43.430 ⇒ 01:31:45.270 Uttam Kumaran: I don’t know what the heck is going on.

713 01:32:00.490 ⇒ 01:32:02.110 Demilade Agboola: get a T…

714 01:33:26.810 ⇒ 01:33:29.760 Uttam Kumaran: Oh, I saw your message, Zoran. Yeah, just lurk, dude.

715 01:33:29.890 ⇒ 01:33:32.650 Uttam Kumaran: We’re just lurking, everybody’s just lurking.

716 01:33:35.120 ⇒ 01:33:37.680 Uttam Kumaran: Maybe I’ll play some music or something.

717 01:33:53.700 ⇒ 01:33:56.649 Demilade Agboola: Oh, sorry, I just sent you the login details.

718 01:33:58.040 ⇒ 01:33:59.100 Uttam Kumaran: Thank you!

719 01:34:04.800 ⇒ 01:34:08.479 Uttam Kumaran: It’s so funny how this is harder than the whole job itself, you know?

720 01:34:09.640 ⇒ 01:34:10.500 Demilade Agboola: Yeah.

721 01:34:10.870 ⇒ 01:34:11.480 Uttam Kumaran: It’s not a reason.

722 01:34:11.480 ⇒ 01:34:17.629 Demilade Agboola: why I… part of the reason why I actually have, like, whenever I think of, let’s getting a new computer.

723 01:34:17.790 ⇒ 01:34:20.850 Demilade Agboola: I’m just like, no, because, like, just setting up every.

724 01:34:20.850 ⇒ 01:34:22.680 Uttam Kumaran: I know!

725 01:34:22.680 ⇒ 01:34:24.550 Demilade Agboola: It’s like, I’m not doing that shit.

726 01:34:27.350 ⇒ 01:34:28.340 Uttam Kumaran: That’s funny.

727 01:34:34.700 ⇒ 01:34:37.080 Uttam Kumaran: It’s forcing me to add a,

728 01:34:37.750 ⇒ 01:34:40.860 Uttam Kumaran: an auth to your dbt account. Do you already have one?

729 01:34:42.020 ⇒ 01:34:42.709 Uttam Kumaran: like.

730 01:34:42.710 ⇒ 01:34:44.739 Demilade Agboola: Passkey? Or something?

731 01:34:45.400 ⇒ 01:34:48.329 Demilade Agboola: I’m not sure I do. Give me one second.

732 01:34:48.530 ⇒ 01:34:50.840 Demilade Agboola: I’m just quickly adding to…

733 01:34:58.520 ⇒ 01:34:59.220 Demilade Agboola: is much.

734 01:34:59.220 ⇒ 01:35:01.549 Uttam Kumaran: Or you can… or you… or you can tell it to me.

735 01:35:04.550 ⇒ 01:35:10.960 Demilade Agboola: Oh, gotcha, I think that’s the issue. I needed to set up one.

736 01:35:11.110 ⇒ 01:35:12.150 Demilade Agboola: Myself.

737 01:35:12.560 ⇒ 01:35:17.139 Demilade Agboola: my local… Like, on my account itself.

738 01:35:17.860 ⇒ 01:35:19.010 Uttam Kumaran: Oh.

739 01:35:20.770 ⇒ 01:35:21.950 Uttam Kumaran: Okay, try it.

740 01:35:21.950 ⇒ 01:35:23.549 Demilade Agboola: I didn’t get in there.

741 01:35:42.710 ⇒ 01:35:45.130 Uttam Kumaran: Henry, let me know if you need help with the deck stuff.

742 01:35:49.650 ⇒ 01:35:53.519 Henry Zhao: Thanks, I mean, this is not mine, so… but I think I know what it’s talking about, so I’m just gonna…

743 01:35:53.630 ⇒ 01:35:54.870 Henry Zhao: Put what I think on that?

744 01:35:58.710 ⇒ 01:36:01.829 Henry Zhao: But I’ve already asked, Polytomic the question I need.

745 01:36:02.730 ⇒ 01:36:03.230 Uttam Kumaran: Whoa.

746 01:36:03.480 ⇒ 01:36:07.079 Henry Zhao: So, pretty much there for Polytomic. I have the data I need now.

747 01:36:11.130 ⇒ 01:36:12.960 Henry Zhao: Oh, that’s a good response he said.

748 01:37:43.210 ⇒ 01:37:45.369 Demilade Agboola: Oh, Tim, did you set up, one tag?

749 01:37:46.680 ⇒ 01:37:48.070 Demilade Agboola: You set up an MFA?

750 01:37:49.460 ⇒ 01:37:52.120 Uttam Kumaran: for Snowflake, or for dbt?

751 01:37:52.120 ⇒ 01:37:52.950 Demilade Agboola: dbt.

752 01:37:53.250 ⇒ 01:37:55.140 Uttam Kumaran: No, not for your account, no.

753 01:37:55.700 ⇒ 01:37:59.680 Demilade Agboola: Okay, because it’s asking me to verify, not set up, which is weird.

754 01:38:04.820 ⇒ 01:38:05.950 Demilade Agboola: Second.

755 01:38:11.100 ⇒ 01:38:14.230 Uttam Kumaran: Yeah, I don’t know, unless you already… I don’t… I didn’t set one up.

756 01:38:15.150 ⇒ 01:38:21.879 Demilade Agboola: Yeah, yeah, I think I’ll just try signing out, and then sign back in, and let’s see if it forces me to do that.

757 01:38:27.510 ⇒ 01:38:30.569 Uttam Kumaran: I mean, you may have set it up, like, way back when, I don’t know.

758 01:38:32.220 ⇒ 01:38:33.810 Demilade Agboola: No.

759 01:39:13.790 ⇒ 01:39:16.800 Demilade Agboola: Yeah, so that’s gonna be set up now. Yeah, I haven’t done it before.

760 01:39:18.240 ⇒ 01:39:18.810 Uttam Kumaran: Okay.

761 01:41:13.710 ⇒ 01:41:16.899 Demilade Agboola: Okay, it’s all good now. It was just the MF18.

762 01:41:17.960 ⇒ 01:41:19.750 Uttam Kumaran: Oh, really? Great. Sick.

763 01:41:20.020 ⇒ 01:41:23.350 Uttam Kumaran: Nice. It worked. Alright.

764 01:45:16.190 ⇒ 01:45:18.039 Demilade Agboola: Okay, folks, I need to drop now.

765 01:45:18.770 ⇒ 01:45:19.430 Uttam Kumaran: Okay.

766 01:45:19.580 ⇒ 01:45:22.410 Demilade Agboola: But I’ll be back in, like, 2 hours, 3 hours.

767 01:45:23.300 ⇒ 01:45:24.910 Uttam Kumaran: Okay, no worries.

768 02:00:23.150 ⇒ 02:00:26.929 Henry Zhao: For Honey Stinger, do you know if Customer Hub is, like, their Zendesk?

769 02:00:28.970 ⇒ 02:00:32.649 Uttam Kumaran: I have no clue why.

770 02:00:32.650 ⇒ 02:00:36.769 Henry Zhao: Is this something that the AI that… yeah, is this something that the AIU wrote to help us, like…

771 02:00:37.500 ⇒ 02:00:41.949 Henry Zhao: Learn about new clients, something that couldn’t… Like, understand that?

772 02:00:42.090 ⇒ 02:00:43.049 Henry Zhao: Just curious.

773 02:00:45.160 ⇒ 02:00:45.829 Henry Zhao: The one you shot?

774 02:00:45.830 ⇒ 02:00:49.330 Uttam Kumaran: I don’t think they mention Customer Hub at all.

775 02:00:49.510 ⇒ 02:00:50.120 Henry Zhao: Okay.

776 02:00:50.120 ⇒ 02:00:52.259 Uttam Kumaran: I don’t even know what that is. Where are you seeing that?

777 02:00:52.700 ⇒ 02:00:55.520 Henry Zhao: It’s just a bunch of columns regarding Customer Hub.

778 02:00:56.200 ⇒ 02:00:57.070 Uttam Kumaran: I can ask.

779 02:01:00.260 ⇒ 02:01:01.740 Uttam Kumaran: Is that application or something?

780 02:01:02.880 ⇒ 02:01:11.450 Henry Zhao: They have… they have open customer hub, customer hub login, view product, it might just be, like, their accounts or something. I don’t know if there is an account, let me see.

781 02:01:12.860 ⇒ 02:01:16.750 Uttam Kumaran: Okay, I can… Yeah, let me just ping and ask.

782 02:01:17.700 ⇒ 02:01:20.190 Henry Zhao: You don’t have to. I was just curious if you knew on the top of your head.

783 02:01:21.040 ⇒ 02:01:22.199 Henry Zhao: Since you’re here.

784 02:01:26.020 ⇒ 02:01:27.979 Henry Zhao: I also wanted to break the silence for a little bit.

785 02:01:29.950 ⇒ 02:01:33.730 Mustafa Raja: I have a question. So,

786 02:01:34.620 ⇒ 02:01:41.340 Mustafa Raja: The, Honey Singer database only has, read permissions.

787 02:01:41.530 ⇒ 02:01:52.279 Mustafa Raja: And when I, test my… a tester test model, it fails because, because the database is in lead-only mode.

788 02:01:53.260 ⇒ 02:01:55.270 Mustafa Raja: I can share my screen so we can…

789 02:01:55.270 ⇒ 02:02:00.100 Uttam Kumaran: But yeah, I guess, like, you shouldn’t need to write back to it, right?

790 02:02:01.470 ⇒ 02:02:04.229 Uttam Kumaran: Like, you should be writing to a new database.

791 02:02:05.130 ⇒ 02:02:08.940 Mustafa Raja: Okay, so I need to set target as that, right?

792 02:02:12.230 ⇒ 02:02:19.350 Uttam Kumaran: Yeah, like, for example, Honey Stinger is just a read-only, and then you can create another database. So basically, I would… I would just create another database

793 02:02:19.720 ⇒ 02:02:22.170 Uttam Kumaran: just called… like…

794 02:02:22.490 ⇒ 02:02:28.909 Uttam Kumaran: I mean, you can just… you can call it, prod underscore dbt. You can just… or you should call it prod underscore dbt.

795 02:02:33.720 ⇒ 02:02:34.660 Uttam Kumaran: Yep.

796 02:02:36.460 ⇒ 02:02:40.090 Uttam Kumaran: And then you can write dbt to here. So it’ll read from that one and write it here.

797 02:02:41.620 ⇒ 02:02:43.300 Mustafa Raja: Oh, okay, thank you.

798 02:02:53.240 ⇒ 02:02:54.230 Mustafa Raja: Oops, thank you.

799 02:02:57.140 ⇒ 02:03:01.189 Uttam Kumaran: All good. I’ll just… I’m happy to share my screen as I’m doing stuff, too.

800 02:10:47.580 ⇒ 02:10:53.600 Mustafa Raja: Okay, the, the connection, is done now. We didn’t need S3 at all, I don’t know why they had.

801 02:10:53.600 ⇒ 02:10:54.420 Uttam Kumaran: Oh, nice, okay.

802 02:10:55.920 ⇒ 02:11:02.090 Mustafa Raja: Let me know, so let me share my screen also… Let me know,

803 02:11:02.470 ⇒ 02:11:06.319 Mustafa Raja: Some more context on… on this stuff.

804 02:11:06.940 ⇒ 02:11:13.270 Uttam Kumaran: Yeah, so I think number one thing is if there’s any code, we can go ahead and create a PR and merge it into the repo.

805 02:11:13.890 ⇒ 02:11:14.680 Mustafa Raja: Yeah.

806 02:11:15.820 ⇒ 02:11:20.630 Mustafa Raja: And then CI in GitHub would be… And also Dockside.

807 02:11:22.660 ⇒ 02:11:24.000 Mustafa Raja: Also, this one.

808 02:11:24.320 ⇒ 02:11:26.690 Mustafa Raja: See, to mean this.

809 02:11:26.690 ⇒ 02:11:35.809 Uttam Kumaran: Yeah, that’s fine for now. I don’t think… yeah, I feel like that’s not… that’s not the most important now. So the biggest thing is, as long as dbt is able to run.

810 02:11:36.080 ⇒ 02:11:38.130 Uttam Kumaran: Locally, I feel like we’re good.

811 02:11:39.210 ⇒ 02:11:41.729 Mustafa Raja: Yeah, I just created this test model.

812 02:11:42.040 ⇒ 02:11:48.309 Mustafa Raja: And then in the mother dock, we have in ProdDbT.

813 02:11:48.450 ⇒ 02:11:53.133 Mustafa Raja: We have this… Oh, you

814 02:11:56.640 ⇒ 02:11:58.070 Mustafa Raja: Yeah, so that’s running.

815 02:12:00.990 ⇒ 02:12:03.980 Mustafa Raja: So I’ll create the PR, and…

816 02:12:04.440 ⇒ 02:12:07.989 Mustafa Raja: This will be done in PR review, right?

817 02:12:10.150 ⇒ 02:12:11.030 Uttam Kumaran: Correct.

818 02:12:11.660 ⇒ 02:12:17.010 Henry Zhao: And my question is, when I have the data I need in Mother Duck, do we want to make

819 02:12:17.290 ⇒ 02:12:19.429 Henry Zhao: model tables in dbt.

820 02:12:20.560 ⇒ 02:12:21.880 Uttam Kumaran: Correct.

821 02:12:21.930 ⇒ 02:12:23.730 Henry Zhao: Okay. So as soon as you’re like, hey, I have…

822 02:12:24.330 ⇒ 02:12:29.790 Uttam Kumaran: I have model tables, like, yeah, you can just basically submit those to get modeled and put into dbt.

823 02:12:30.230 ⇒ 02:12:30.840 Henry Zhao: Okay.

824 02:12:31.280 ⇒ 02:12:32.030 Uttam Kumaran: Great.

825 02:12:32.310 ⇒ 02:12:33.400 Uttam Kumaran: Nice, guys.

826 02:12:37.650 ⇒ 02:12:41.680 Henry Zhao: Yeah, so pretty much everything we need is in the event table, just need…

827 02:12:42.200 ⇒ 02:12:45.550 Henry Zhao: the body, email body from Polyatomic.

828 02:12:46.060 ⇒ 02:12:50.049 Henry Zhao: That’ll give us the Klaviyo stuff that I mentioned in the Notion doc.

829 02:12:50.720 ⇒ 02:12:51.480 Uttam Kumaran: Okay.

830 02:12:52.440 ⇒ 02:12:55.319 Mustafa Raja: One question, Henry. Do you see this?

831 02:12:55.490 ⇒ 02:12:58.500 Mustafa Raja: ProdBT on your side, on Mother Duck?

832 02:12:58.730 ⇒ 02:12:59.679 Henry Zhao: Let me check.

833 02:13:00.500 ⇒ 02:13:01.560 Henry Zhao: Do-do-do…

834 02:13:01.950 ⇒ 02:13:06.240 Mustafa Raja: If not, I’ve created a share, so you should be able to then attach.

835 02:13:06.240 ⇒ 02:13:08.690 Henry Zhao: I need to attach… I need to run that attach script, though, right?

836 02:13:08.690 ⇒ 02:13:12.660 Mustafa Raja: Okay, I’ve shared that in Zoom chat.

837 02:13:12.840 ⇒ 02:13:13.500 Henry Zhao: Okay.

838 02:13:22.760 ⇒ 02:13:23.879 Henry Zhao: Yeah, I see it.

839 02:13:24.590 ⇒ 02:13:26.609 Henry Zhao: Give me 10 main analytics stuff.

840 02:13:26.740 ⇒ 02:13:27.480 Henry Zhao: Right?

841 02:13:28.760 ⇒ 02:13:29.770 Mustafa Raja: Yes.

842 02:13:30.030 ⇒ 02:13:30.730 Henry Zhao: Yeah, okay.

843 02:13:32.150 ⇒ 02:13:36.420 Mustafa Raja: For now, there’s only the test model, but I guess we’ll be building stuff.

844 02:13:38.490 ⇒ 02:13:41.369 Henry Zhao: So, okay, so we’re building stuff into ProdDbT, like we do for Eden.

845 02:13:42.630 ⇒ 02:13:43.540 Uttam Kumaran: Yes.

846 02:13:43.540 ⇒ 02:13:44.140 Henry Zhao: Okay.

847 02:15:12.900 ⇒ 02:15:19.459 Henry Zhao: Okay, I’m gonna drop to get some Eden stuff done, and then I’ll get back to Honey Stinger later, and then… Okay. Maybe, Gustafa, you and I can sing tomorrow on Honey Stinger stuff.

848 02:15:19.460 ⇒ 02:15:20.659 Mustafa Raja: Yeah, yeah, I’d love that.

849 02:15:20.970 ⇒ 02:15:22.479 Henry Zhao: Okay, sounds good. Thanks, guys.

850 02:15:23.050 ⇒ 02:15:23.930 Uttam Kumaran: Thank you.

851 02:15:23.930 ⇒ 02:15:24.500 Henry Zhao: Right.

852 02:15:46.410 ⇒ 02:15:55.610 Mustafa Raja: So the only thing, here is that the mother. token that I’ve, added in one pass for Honey Stinger needs to be in…

853 02:15:55.810 ⇒ 02:15:57.460 Mustafa Raja: in the CLI.

854 02:15:59.560 ⇒ 02:16:07.140 Mustafa Raja: So .env file isn’t going to work, or I guess we can look at it, how to get it working, so it needs to be in the terminal.

855 02:16:14.050 ⇒ 02:16:15.290 Uttam Kumaran: Wait, say that one more time?

856 02:16:16.370 ⇒ 02:16:22.140 Mustafa Raja: the mother that… ENV needs to be, set in terminal.

857 02:16:22.740 ⇒ 02:16:27.490 Uttam Kumaran: Oh, so then I would just keep the ENV in one pass, And then anyone.

858 02:16:27.490 ⇒ 02:16:28.719 Mustafa Raja: Yeah, I’m done.

859 02:16:29.330 ⇒ 02:16:29.940 Uttam Kumaran: Yeah.

860 02:16:30.910 ⇒ 02:16:32.139 Mustafa Raja: I’ve done that.

861 02:16:35.230 ⇒ 02:16:36.110 Mustafa Raja: Okay.

862 02:16:46.110 ⇒ 02:16:47.559 Mustafa Raja: Yeah, this was good.

863 02:16:47.680 ⇒ 02:16:49.660 Mustafa Raja: I like, I like this task.

864 02:16:50.030 ⇒ 02:16:50.820 Mustafa Raja: Yeah.

865 02:16:52.549 ⇒ 02:16:58.389 Uttam Kumaran: Yeah, I think I’ll… we’ll have a couple more clients starting, so I’ll get you guys… involved there.

866 02:16:59.510 ⇒ 02:17:00.639 Mustafa Raja: Yeah, this is nice.

867 02:19:30.969 ⇒ 02:19:37.489 Mustafa Raja: So it looks like I have to push to the main branch, because the main branch isn’t published yet.

868 02:19:38.110 ⇒ 02:19:39.119 Uttam Kumaran: Okay, go ahead.

869 02:19:39.770 ⇒ 02:19:40.469 Mustafa Raja: Okay.

870 02:19:42.219 ⇒ 02:19:44.269 Mustafa Raja: I should’ve looked down before.

871 02:20:28.290 ⇒ 02:20:29.290 Mustafa Raja: And this is good.

872 02:20:30.010 ⇒ 02:20:35.870 Mustafa Raja: I guess for tomorrow, I’ll be syncing with… Henry, to then…

873 02:20:36.620 ⇒ 02:20:40.899 Mustafa Raja: work on the models for Shopify, Amazon, and Klaviyo.

874 02:20:41.640 ⇒ 02:20:42.270 Uttam Kumaran: Okay.

875 02:20:43.000 ⇒ 02:20:43.630 Mustafa Raja: Yeah.

876 02:20:51.770 ⇒ 02:20:57.490 Uttam Kumaran: Great, yeah, what else, you guys? Anything else I can be helpful with, I think?

877 02:20:57.690 ⇒ 02:21:13.260 Uttam Kumaran: Yeah, once I start getting stuff going on Hedra, Casey, I can loop you in to start helping me with, some modeling stuff there, and then, same thing, Mustafa, I think if you can help Henry on Honey Stinger, then I can start to hand, kind of, both of those off. I feel like that’ll be…

878 02:21:14.050 ⇒ 02:21:19.299 Uttam Kumaran: Pretty solid, yeah, it’s probably the main stuff for me.

879 02:21:22.010 ⇒ 02:21:23.770 Mustafa Raja: Yeah, I’m excited on this.

880 02:21:25.620 ⇒ 02:21:26.230 Uttam Kumaran: Okay.

881 02:21:28.660 ⇒ 02:21:31.430 Uttam Kumaran: Okay, cool. Alright, I’m gonna go get some lunch, then.

882 02:21:32.430 ⇒ 02:21:38.429 Mustafa Raja: Can I be added to Honey Singer on Clockify?

883 02:21:39.990 ⇒ 02:21:42.609 Uttam Kumaran: Yes, I will send it to,

884 02:21:43.160 ⇒ 02:21:45.399 Uttam Kumaran: I’ll send it to, yeah.

885 02:21:45.980 ⇒ 02:21:47.700 Mustafa Raja: Okay, let me do that.

886 02:21:47.940 ⇒ 02:21:48.640 Mustafa Raja: Hmm.

887 02:21:51.430 ⇒ 02:21:53.680 Mustafa Raja: Okay, yeah, enjoy your… enjoy your lunch.

888 02:21:55.490 ⇒ 02:21:59.130 Uttam Kumaran: Hey guys, I’ll talk to you soon. I’m gonna click something, I don’t know, I have to check what’s

889 02:21:59.480 ⇒ 02:22:00.120 Uttam Kumaran: coverage.

890 02:22:00.940 ⇒ 02:22:05.240 Mustafa Raja: That’s really nice. I need to restart doing some healthy stuff, too.

891 02:22:05.730 ⇒ 02:22:06.590 Mustafa Raja: Okay.

892 02:22:07.590 ⇒ 02:22:09.349 Uttam Kumaran: Alright, thank you guys, talk soon.

893 02:22:09.350 ⇒ 02:22:10.030 Mustafa Raja: Bye.