Meeting Title: Uttam-Kumaran’s-Personal-Meeting-Room Date: 2024-08-15 Meeting participants: Patrick Trainer, Uttam Kumaran
WEBVTT
1 00:00:33.380 ⇒ 00:00:34.110 Uttam Kumaran: Yo.
2 00:00:36.480 ⇒ 00:00:37.360 Patrick Trainer: Go.
3 00:00:39.090 ⇒ 00:00:40.100 Uttam Kumaran: How’s it going.
4 00:00:41.010 ⇒ 00:00:43.680 Patrick Trainer: Doing alright. So you just want to say fuck it.
5 00:00:44.680 ⇒ 00:00:51.939 Uttam Kumaran: I mean, yeah, dude. I don’t know. I I think it’s like Week 6. I’m kind of done with it like I don’t. Wanna. I don’t. Wanna have you spend more time on this.
6 00:00:51.940 ⇒ 00:00:52.400 Patrick Trainer: Right.
7 00:00:52.400 ⇒ 00:00:53.459 Uttam Kumaran: Yeah, you can.
8 00:00:53.460 ⇒ 00:00:55.950 Patrick Trainer: I mean, there’s been so many different like
9 00:00:57.552 ⇒ 00:00:59.450 Patrick Trainer: unknowns, you know.
10 00:01:00.980 ⇒ 00:01:07.980 Uttam Kumaran: Yeah, I just think it’s like, I think we should still use it to basically grab the one attentive file that you have to click into.
11 00:01:08.590 ⇒ 00:01:14.640 Uttam Kumaran: But and if if that’s still possible, then let’s do that, otherwise, I think we should. I’m just gonna let’s just
12 00:01:14.670 ⇒ 00:01:18.429 Uttam Kumaran: set up the 5 train connectors, and then, like.
13 00:01:18.560 ⇒ 00:01:21.109 Uttam Kumaran: we can also set up 5 train to S. 3,
14 00:01:21.340 ⇒ 00:01:25.820 Uttam Kumaran: or for the. We can also set up 5, 10 s. 3 for that one attentive connector.
15 00:01:25.820 ⇒ 00:01:27.723 Patrick Trainer: Right. Well, so there’s
16 00:01:29.570 ⇒ 00:01:32.000 Patrick Trainer: thing called Magic Folder.
17 00:01:32.480 ⇒ 00:01:32.920 Uttam Kumaran: Yeah.
18 00:01:32.920 ⇒ 00:01:33.520 Patrick Trainer: Friend.
19 00:01:33.900 ⇒ 00:01:36.369 Patrick Trainer: I think that’s what we’re gonna need to use.
20 00:01:37.020 ⇒ 00:01:40.420 Uttam Kumaran: Yeah, exactly. So we’ll use a magic folder hooked up to S. 3
21 00:01:40.710 ⇒ 00:01:41.390 Uttam Kumaran: for.
22 00:01:42.190 ⇒ 00:01:42.890 Patrick Trainer: It
23 00:01:43.460 ⇒ 00:01:45.449 Patrick Trainer: doesn’t connect to S. 3.
24 00:01:45.770 ⇒ 00:01:48.026 Patrick Trainer: But we can do
25 00:01:52.800 ⇒ 00:01:53.930 Patrick Trainer: Google, drive.
26 00:01:55.950 ⇒ 00:01:57.539 Uttam Kumaran: And no, it does connect s. 3.
27 00:01:58.490 ⇒ 00:01:59.120 Patrick Trainer: Does it?
28 00:01:59.580 ⇒ 00:02:00.250 Uttam Kumaran: Yeah.
29 00:02:00.690 ⇒ 00:02:04.440 Uttam Kumaran: it’s always connect. Yeah, there’s like, S, 3 box dropbox.
30 00:02:04.580 ⇒ 00:02:05.820 Uttam Kumaran: Everything we can do.
31 00:02:05.820 ⇒ 00:02:07.840 Patrick Trainer: Okay. I guess their docs are just.
32 00:02:08.620 ⇒ 00:02:11.969 Uttam Kumaran: If you go to connectors and under files, then you’ll see s. 3 there
33 00:02:13.240 ⇒ 00:02:15.300 Uttam Kumaran: and then at the topmost
34 00:02:15.720 ⇒ 00:02:17.020 Uttam Kumaran: you’ll see.
35 00:02:17.120 ⇒ 00:02:21.900 Uttam Kumaran: So magic folder is just the blanket for any of those
36 00:02:24.080 ⇒ 00:02:25.500 Uttam Kumaran: storage types.
37 00:02:26.880 ⇒ 00:02:27.890 Patrick Trainer: Right? Okay.
38 00:02:37.210 ⇒ 00:02:43.520 Uttam Kumaran: So the the attentive one is working. Can you? Just you want to go ahead and I’m just gonna log into 5 train. Do you want to set up
39 00:02:43.650 ⇒ 00:02:45.929 Uttam Kumaran: the attentive s. 3 1
40 00:02:47.760 ⇒ 00:02:48.989 Uttam Kumaran: s. 3 bucket.
41 00:02:48.990 ⇒ 00:02:50.103 Patrick Trainer: The like.
42 00:02:51.770 ⇒ 00:02:54.739 Patrick Trainer: like when we’re parsing the emails and sending them up.
43 00:02:55.840 ⇒ 00:02:59.062 Uttam Kumaran: Yeah, well, no, no. So we have. We have
44 00:03:00.230 ⇒ 00:03:02.260 Uttam Kumaran: how many? We have 5 emails.
45 00:03:03.240 ⇒ 00:03:04.360 Patrick Trainer: Something like that. Yeah.
46 00:03:05.280 ⇒ 00:03:08.210 Uttam Kumaran: Okay, let me just get all of them in front of me.
47 00:03:22.980 ⇒ 00:03:26.700 Uttam Kumaran: Do we have a list of those like what all the emails are anywhere.
48 00:03:28.660 ⇒ 00:03:29.450 Patrick Trainer: No!
49 00:03:31.420 ⇒ 00:03:34.699 Uttam Kumaran: Okay, that would be great. To have
50 00:03:37.831 ⇒ 00:03:39.589 Uttam Kumaran: okay, I mean, I don’t.
51 00:03:40.920 ⇒ 00:03:43.080 Uttam Kumaran: I have not been looking at this.
52 00:03:43.110 ⇒ 00:03:44.879 Uttam Kumaran: I don’t know where it is.
53 00:03:55.610 ⇒ 00:03:56.500 Uttam Kumaran: Okay.
54 00:04:00.290 ⇒ 00:04:02.582 Uttam Kumaran: So so I guess just for the
55 00:04:03.460 ⇒ 00:04:06.369 Uttam Kumaran: which are the emails that you have to click into.
56 00:04:08.281 ⇒ 00:04:11.980 Patrick Trainer: There’s the attentive one, and then the Klavia one.
57 00:04:13.190 ⇒ 00:04:20.509 Patrick Trainer: Clavia, I don’t think like they. Klavia still puts it behind a like a login wall
58 00:04:21.168 ⇒ 00:04:24.199 Patrick Trainer: off so like, I don’t think that’s gonna
59 00:04:25.090 ⇒ 00:04:26.490 Patrick Trainer: unless we can get
60 00:04:26.870 ⇒ 00:04:31.069 Patrick Trainer: Clavia to like. Just send a Csv rather than a link.
61 00:04:33.390 ⇒ 00:04:34.290 Patrick Trainer: So for.
62 00:04:34.770 ⇒ 00:04:36.210 Uttam Kumaran: For the Clavio.
63 00:04:36.640 ⇒ 00:04:43.370 Uttam Kumaran: for the Clavio, and attentive! Can you handle that on your side, and just drop it into into a separate S 2 folder.
64 00:04:43.370 ⇒ 00:04:44.749 Patrick Trainer: Eclavia. I can’t.
65 00:04:45.710 ⇒ 00:04:46.440 Patrick Trainer: The earth.
66 00:04:46.440 ⇒ 00:04:47.280 Uttam Kumaran: A week.
67 00:04:47.280 ⇒ 00:04:48.839 Patrick Trainer: Yeah, the attentive.
68 00:04:48.860 ⇒ 00:04:53.870 Patrick Trainer: It can, because I’ve got like the direct link to the S. 3 bucket.
69 00:04:55.010 ⇒ 00:04:55.660 Uttam Kumaran: Okay.
70 00:04:56.080 ⇒ 00:04:56.990 Patrick Trainer: Clavio.
71 00:04:57.460 ⇒ 00:05:00.209 Patrick Trainer: like you have to like log in and off
72 00:05:00.700 ⇒ 00:05:02.560 Patrick Trainer: and do all this other stuff.
73 00:05:03.610 ⇒ 00:05:05.309 Uttam Kumaran: Oh, okay. I didn’t know that.
74 00:05:08.560 ⇒ 00:05:09.310 Uttam Kumaran: Yeah.
75 00:05:09.520 ⇒ 00:05:15.220 Patrick Trainer: Like at all. It like it seems easy on the surface, but like it’s turned out to be like.
76 00:05:16.080 ⇒ 00:05:21.430 Uttam Kumaran: No, that’s fine. I I just like, yeah, I just want to ditch it like, I just want to get out of this.
77 00:05:22.120 ⇒ 00:05:23.299 Uttam Kumaran: So fuck it.
78 00:05:23.750 ⇒ 00:05:26.550 Uttam Kumaran: Okay, so let’s just leave Clavio for now.
79 00:05:28.710 ⇒ 00:05:33.449 Uttam Kumaran: so I just wanna make like a list. And let’s just I just want to close this out today.
80 00:05:33.860 ⇒ 00:05:35.292 Uttam Kumaran: So we have
81 00:05:36.610 ⇒ 00:05:40.269 Uttam Kumaran: I’m just gonna create a list and documentation called.
82 00:05:46.230 ⇒ 00:05:46.990 Uttam Kumaran: okay.
83 00:05:52.200 ⇒ 00:05:55.530 Uttam Kumaran: okay. So we have direct mail.
84 00:05:55.780 ⇒ 00:06:01.160 Uttam Kumaran: one direct mail, 2 attentive
85 00:06:03.240 ⇒ 00:06:04.750 Uttam Kumaran: and Clavio.
86 00:06:05.470 ⇒ 00:06:09.589 Uttam Kumaran: and let me just make sure I have the names of them.
87 00:06:15.370 ⇒ 00:06:18.230 Uttam Kumaran: The attentive one is just
88 00:06:21.320 ⇒ 00:06:23.690 Uttam Kumaran: campaign. Spend report
89 00:06:24.030 ⇒ 00:06:26.530 Uttam Kumaran: into report.
90 00:06:27.180 ⇒ 00:06:35.609 Uttam Kumaran: So for the attentive. Can you just drop? Can you just handle that one and put that into an S. 3 bucket? And then, if you can make the 5 trend for that.
91 00:06:36.580 ⇒ 00:06:40.039 Patrick Trainer: Yeah, that should be doable.
92 00:06:42.420 ⇒ 00:06:44.527 Patrick Trainer: will you forward
93 00:06:45.370 ⇒ 00:06:46.800 Patrick Trainer: like the latest
94 00:06:47.230 ⇒ 00:06:49.569 Patrick Trainer: attentive to that mailbox
95 00:06:50.290 ⇒ 00:06:51.940 Patrick Trainer: still have the
96 00:06:52.020 ⇒ 00:06:57.019 Patrick Trainer: the only one that’s in there is that one from like last month, and the link is expired.
97 00:06:57.990 ⇒ 00:06:59.085 Uttam Kumaran: Okay. So
98 00:07:03.490 ⇒ 00:07:06.660 Uttam Kumaran: both parts to go dash receiving at Brainforge.
99 00:07:08.670 ⇒ 00:07:09.220 Patrick Trainer: Sounds, right.
100 00:07:09.220 ⇒ 00:07:09.900 Uttam Kumaran: That’s it.
101 00:07:10.110 ⇒ 00:07:10.810 Uttam Kumaran: Yeah.
102 00:07:12.670 ⇒ 00:07:15.369 Uttam Kumaran: okay, I just sent it so that one
103 00:07:18.677 ⇒ 00:07:23.330 Uttam Kumaran: ingestion is gonna be femad. And then the the
104 00:07:25.620 ⇒ 00:07:27.691 Uttam Kumaran: gmad, plus 5 Tran
105 00:07:28.750 ⇒ 00:07:30.110 Uttam Kumaran: play video
106 00:07:31.720 ⇒ 00:07:36.149 Uttam Kumaran: congestion in a for now.
107 00:07:36.750 ⇒ 00:07:39.440 Uttam Kumaran: Tavia, we can figure out later. I mean.
108 00:07:41.500 ⇒ 00:07:43.819 Uttam Kumaran: yeah, we could figure that out later.
109 00:07:45.240 ⇒ 00:07:46.809 Uttam Kumaran: Post pilot.
110 00:07:51.300 ⇒ 00:07:54.046 Uttam Kumaran: And then are we able to run this?
111 00:07:55.430 ⇒ 00:08:00.680 Uttam Kumaran: Are we able to run the job any like? It’s the attentive stuff is only gonna come in.
112 00:08:06.220 ⇒ 00:08:08.660 Uttam Kumaran: looks like it comes in once a day.
113 00:08:10.230 ⇒ 00:08:11.510 Uttam Kumaran: Yeah, so are you.
114 00:08:11.510 ⇒ 00:08:14.790 Patrick Trainer: I mean we can run it like on a schedule or.
115 00:08:17.340 ⇒ 00:08:21.879 Uttam Kumaran: Yeah, that would be great. Just like it comes in at 5 Am.
116 00:08:22.480 ⇒ 00:08:23.900 Uttam Kumaran: For the most part.
117 00:08:24.050 ⇒ 00:08:24.430 Patrick Trainer: Okay.
118 00:08:24.430 ⇒ 00:08:28.379 Uttam Kumaran: And then what what happens if if it if it has multiple, if it’s like, let’s say.
119 00:08:28.390 ⇒ 00:08:30.809 Uttam Kumaran: like, today, looks like it came in.
120 00:08:32.230 ⇒ 00:08:36.250 Uttam Kumaran: Yeah, it’s all coming in like 501-50-2503, like, let’s say.
121 00:08:36.250 ⇒ 00:08:36.640 Patrick Trainer: Okay.
122 00:08:36.640 ⇒ 00:08:38.440 Uttam Kumaran: We miss it. What happens?
123 00:08:40.270 ⇒ 00:08:43.840 Uttam Kumaran: Like, let’s say there’s 2 emails in the back in the backlog, in the inbox.
124 00:08:48.290 ⇒ 00:08:53.129 Patrick Trainer: Well, so the thing about these attentive emails is they, I believe they replace
125 00:08:53.420 ⇒ 00:08:55.860 Patrick Trainer: everything like it’s it’s
126 00:08:56.200 ⇒ 00:08:57.620 Patrick Trainer: the entire.
127 00:09:00.200 ⇒ 00:09:02.099 Uttam Kumaran: It looks like it’s just one month. Yeah.
128 00:09:02.100 ⇒ 00:09:03.160 Patrick Trainer: Yeah. It’s just one month.
129 00:09:06.710 ⇒ 00:09:10.949 Uttam Kumaran: But that’s also fine, because we can. We can dedupe like as long as you’re.
130 00:09:10.950 ⇒ 00:09:15.960 Patrick Trainer: Yeah, I think, yeah, I think that’s fine. I think it’s fine, because, like, each file is going to have a unique
131 00:09:16.110 ⇒ 00:09:17.050 Patrick Trainer: name.
132 00:09:17.260 ⇒ 00:09:19.880 Patrick Trainer: And each file is going to go up into S. 3,
133 00:09:20.160 ⇒ 00:09:23.180 Patrick Trainer: and then snowflakes going to
134 00:09:23.670 ⇒ 00:09:25.100 Patrick Trainer: assign it. A key.
135 00:09:26.480 ⇒ 00:09:32.730 Uttam Kumaran: But that’s also the thing we don’t. We don’t really even need to use. We don’t. Even after after S. 3 we’ll just use 5 train to do the ingestion.
136 00:09:32.730 ⇒ 00:09:35.389 Patrick Trainer: Yeah. Well, like 5, Tran will assign it a key.
137 00:09:35.920 ⇒ 00:09:36.290 Uttam Kumaran: Yeah.
138 00:09:36.290 ⇒ 00:09:38.399 Patrick Trainer: And then and then do it that way.
139 00:09:39.050 ⇒ 00:09:42.699 Uttam Kumaran: So I guess my question is, if we have 2 emails in the backlog.
140 00:09:43.170 ⇒ 00:09:46.890 Uttam Kumaran: what is your is your service able to to process that?
141 00:09:48.700 ⇒ 00:09:49.310 Uttam Kumaran: Yeah.
142 00:09:49.310 ⇒ 00:09:50.040 Patrick Trainer: Yeah.
143 00:09:50.590 ⇒ 00:09:51.270 Uttam Kumaran: Okay.
144 00:09:53.310 ⇒ 00:09:55.450 Uttam Kumaran: okay, that just didn’t sound so confident.
145 00:09:55.450 ⇒ 00:09:58.349 Patrick Trainer: I like, yeah, it’s I. I believe. So.
146 00:09:58.820 ⇒ 00:10:00.120 Uttam Kumaran: Okay. Well.
147 00:10:00.120 ⇒ 00:10:01.390 Patrick Trainer: I guess we’ll find out.
148 00:10:02.570 ⇒ 00:10:07.020 Uttam Kumaran: Okay, I mean, can we like, try that out like, if I support another one like.
149 00:10:07.100 ⇒ 00:10:08.829 Uttam Kumaran: I just want to make sure this works.
150 00:10:09.060 ⇒ 00:10:18.229 Uttam Kumaran: Yeah, like, if there’s what. So what happens if there’s 2 and does it process all emails in the inbox? And then basically, if it’s an attentive one, it takes a certain action.
151 00:10:18.230 ⇒ 00:10:18.860 Patrick Trainer: Yeah.
152 00:10:19.730 ⇒ 00:10:20.640 Uttam Kumaran: Okay.
153 00:10:25.750 ⇒ 00:10:27.980 Patrick Trainer: like. Are you asking if
154 00:10:28.750 ⇒ 00:10:31.679 Patrick Trainer: the 2 emails with the attachment are the same
155 00:10:32.200 ⇒ 00:10:32.780 Patrick Trainer: or.
156 00:10:32.780 ⇒ 00:10:35.650 Uttam Kumaran: No, if there’s 2 different ones
157 00:10:35.960 ⇒ 00:10:37.740 Uttam Kumaran: like, for example, let’s say it comes in late.
158 00:10:37.740 ⇒ 00:10:39.799 Patrick Trainer: So it’s going to loop through every single one.
159 00:10:39.800 ⇒ 00:10:42.979 Uttam Kumaran: And then it archives the ones that it it finishes
160 00:10:43.850 ⇒ 00:10:46.820 Uttam Kumaran: or like. How does it? Does it delete them.
161 00:10:46.990 ⇒ 00:10:49.640 Patrick Trainer: No, it’s just grabbing like the most recent ones.
162 00:10:51.430 ⇒ 00:10:53.380 Uttam Kumaran: But then it’s not gonna work right?
163 00:10:57.810 ⇒ 00:10:58.770 Patrick Trainer: You know. Send a
164 00:10:59.670 ⇒ 00:11:00.180 Patrick Trainer: central.
165 00:11:00.180 ⇒ 00:11:04.120 Uttam Kumaran: I mean, I’ll send it again. But yeah, this is a case I just wanna make sure is like handled.
166 00:11:05.430 ⇒ 00:11:07.060 Patrick Trainer: Do? We have the one from yesterday.
167 00:11:07.690 ⇒ 00:11:08.400 Uttam Kumaran: Yeah.
168 00:11:08.630 ⇒ 00:11:10.399 Patrick Trainer: Okay, yeah. Send that one over to.
169 00:11:23.110 ⇒ 00:11:24.599 Uttam Kumaran: Okay, I sent it.
170 00:11:51.110 ⇒ 00:11:54.750 Uttam Kumaran: Yeah. So basically, then all it needs to do is
171 00:11:55.750 ⇒ 00:11:57.339 Uttam Kumaran: read the email.
172 00:11:57.810 ⇒ 00:11:59.000 Uttam Kumaran: upload
173 00:11:59.200 ⇒ 00:12:00.240 Uttam Kumaran: the
174 00:12:02.540 ⇒ 00:12:06.300 Uttam Kumaran: click on the the URL, upload that file, too.
175 00:12:06.650 ⇒ 00:12:08.250 Uttam Kumaran: S. 3.
176 00:12:40.010 ⇒ 00:12:44.380 Uttam Kumaran: I mean, worst case, we’ll just switch to Zapier, because
177 00:12:45.380 ⇒ 00:12:50.070 Uttam Kumaran: I think there’s just an email parser that will. I mean again. I’m just Googling now.
178 00:12:50.610 ⇒ 00:12:51.460 Uttam Kumaran: But
179 00:12:52.410 ⇒ 00:12:53.350 Uttam Kumaran: yeah.
180 00:12:54.590 ⇒ 00:12:56.250 Patrick Trainer: Alright. Let’s
181 00:12:57.850 ⇒ 00:12:59.669 Patrick Trainer: see what we’ve got.
182 00:13:21.390 ⇒ 00:13:22.110 Patrick Trainer: Okay.
183 00:13:22.250 ⇒ 00:13:23.179 Patrick Trainer: Be the 3rd one.
184 00:16:16.730 ⇒ 00:16:17.470 Patrick Trainer: Okay?
185 00:16:18.990 ⇒ 00:16:21.549 Patrick Trainer: And then let’s check the
186 00:16:22.450 ⇒ 00:16:23.460 Patrick Trainer: S. 3.
187 00:16:40.430 ⇒ 00:16:42.490 Patrick Trainer: I guess I can share my screen real quick.
188 00:16:45.180 ⇒ 00:16:48.739 Uttam Kumaran: Yeah, I’m just setting up the 5 trans stuff. But.
189 00:16:48.740 ⇒ 00:16:50.629 Patrick Trainer: Yeah, the 2 that you just sent.
190 00:16:52.890 ⇒ 00:16:53.739 Patrick Trainer: Can you see my screen.
191 00:16:53.740 ⇒ 00:16:54.665 Uttam Kumaran: Okay.
192 00:16:55.930 ⇒ 00:16:56.720 Uttam Kumaran: Yeah.
193 00:16:56.950 ⇒ 00:16:59.870 Patrick Trainer: Okay, yeah. See this pull parts to go. Udum.
194 00:17:00.330 ⇒ 00:17:01.629 Uttam Kumaran: Oh, nice. Okay.
195 00:17:01.630 ⇒ 00:17:03.050 Patrick Trainer: There’s 8, 14.
196 00:17:03.500 ⇒ 00:17:03.980 Uttam Kumaran: Cool.
197 00:17:03.980 ⇒ 00:17:07.110 Patrick Trainer: We’ve got the Excel file in there. We’ve got our
198 00:17:08.130 ⇒ 00:17:09.520 Patrick Trainer: conversions list.
199 00:17:10.290 ⇒ 00:17:11.260 Uttam Kumaran: I agree.
200 00:17:13.750 ⇒ 00:17:14.329 Patrick Trainer: Yeah.
201 00:17:15.430 ⇒ 00:17:18.880 Uttam Kumaran: Okay. So we can probably just delete everything apart from
202 00:17:19.010 ⇒ 00:17:21.310 Uttam Kumaran: the campaign spend.
203 00:17:21.960 ⇒ 00:17:22.829 Uttam Kumaran: And then.
204 00:17:22.839 ⇒ 00:17:24.929 Patrick Trainer: Yeah, we we can just run that
205 00:17:25.079 ⇒ 00:17:27.349 Patrick Trainer: part of the action that should be fun.
206 00:17:28.560 ⇒ 00:17:34.722 Uttam Kumaran: Okay, yeah, let’s do that, do you? Wanna just get rid of those, then, and then, if you can, you set up the 5 train to
207 00:17:35.970 ⇒ 00:17:39.149 Uttam Kumaran: to pull that into stuff like
208 00:17:40.780 ⇒ 00:17:42.010 Uttam Kumaran: from S. 3.
209 00:17:42.010 ⇒ 00:17:43.930 Patrick Trainer: Yeah, just the campaigns. Then.
210 00:17:44.970 ⇒ 00:17:46.160 Uttam Kumaran: Yeah.
211 00:17:50.580 ⇒ 00:17:52.830 Uttam Kumaran: okay. So I got one done.
212 00:18:06.250 ⇒ 00:18:07.440 Patrick Trainer: Well, it works.
213 00:18:09.637 ⇒ 00:18:13.572 Uttam Kumaran: It works dude. But I’m done with you working on this.
214 00:18:14.190 ⇒ 00:18:16.070 Uttam Kumaran: I need some help on other stuff.
215 00:18:16.070 ⇒ 00:18:16.820 Patrick Trainer: Yeah.
216 00:18:18.350 ⇒ 00:18:19.980 Uttam Kumaran: Some more interesting stuff.
217 00:18:23.760 ⇒ 00:18:25.710 Patrick Trainer: I mean, this has been plenty interesting.
218 00:18:26.620 ⇒ 00:18:33.259 Uttam Kumaran: Yeah, but I can’t spend like I just I think you, you know what I’m gonna say. But I just can’t spend more money
219 00:18:33.290 ⇒ 00:18:37.160 Uttam Kumaran: or going towards doing this like, I just need this to be done.
220 00:18:40.010 ⇒ 00:18:41.840 Uttam Kumaran: I know it’s been interesting, but
221 00:18:43.410 ⇒ 00:18:48.919 Uttam Kumaran: at some point it’s like I I can’t spend their money on doing this sort of stuff. So we gotta move on.
222 00:18:53.430 ⇒ 00:18:57.160 Patrick Trainer: They would only just email Us. Csv, so that everything would be okay.
223 00:18:57.520 ⇒ 00:18:58.420 Uttam Kumaran: Yeah.
224 00:19:06.310 ⇒ 00:19:06.990 Uttam Kumaran: okay.
225 00:19:12.630 ⇒ 00:19:13.330 Patrick Trainer: To
226 00:19:21.150 ⇒ 00:19:22.630 Patrick Trainer: Great body
227 00:19:45.570 ⇒ 00:19:46.280 Patrick Trainer: oops.
228 00:19:47.810 ⇒ 00:19:48.880 Patrick Trainer: Okay.
229 00:19:59.230 ⇒ 00:19:59.900 Uttam Kumaran: Yeah.
230 00:21:21.730 ⇒ 00:21:22.630 Patrick Trainer: Right.
231 00:21:23.750 ⇒ 00:21:24.920 Patrick Trainer: These
232 00:22:31.980 ⇒ 00:22:32.390 Patrick Trainer: shit
233 00:22:32.730 ⇒ 00:22:33.450 Patrick Trainer: chop
234 00:24:03.420 ⇒ 00:24:04.620 Patrick Trainer: alright cool.
235 00:26:56.660 ⇒ 00:26:57.889 Patrick Trainer: I guess I can
236 00:26:58.630 ⇒ 00:26:59.600 Patrick Trainer: stop sharing.
237 00:27:07.240 ⇒ 00:27:11.180 Patrick Trainer: alright. Well, yeah, getting the message bodies that’s
238 00:27:11.880 ⇒ 00:27:12.670 Patrick Trainer: working.
239 00:27:13.940 ⇒ 00:27:15.110 Uttam Kumaran: Okay. Cool.
240 00:27:15.110 ⇒ 00:27:16.530 Patrick Trainer: Go to there.
241 00:27:18.170 ⇒ 00:27:21.460 Patrick Trainer: Now, what do we need to do? 5. Trade?
242 00:27:43.890 ⇒ 00:27:45.810 Patrick Trainer: Whoa! Their thing changed.
243 00:27:47.970 ⇒ 00:27:49.630 Uttam Kumaran: What thing? Oh, the layout.
244 00:27:49.630 ⇒ 00:27:50.970 Patrick Trainer: Yeah. The layout.
245 00:27:53.710 ⇒ 00:28:00.550 Uttam Kumaran: They’re getting better, but still their product is so contained like they kind of fucking dropped the ball on this thing so hard.
246 00:28:18.080 ⇒ 00:28:19.620 Uttam Kumaran: I don’t even think I can see that.
247 00:28:19.620 ⇒ 00:28:21.699 Patrick Trainer: Only have access to the
248 00:28:22.770 ⇒ 00:28:24.449 Patrick Trainer: Stella fucked friend.
249 00:28:25.680 ⇒ 00:28:26.550 Uttam Kumaran: Oh, really.
250 00:28:31.000 ⇒ 00:28:32.120 Uttam Kumaran: Oh, you’re in here.
251 00:28:36.490 ⇒ 00:28:37.689 Uttam Kumaran: Oh, wait! Hold on.
252 00:28:43.950 ⇒ 00:28:46.509 Uttam Kumaran: Okay, yeah. Let me add, you come on.
253 00:28:57.960 ⇒ 00:28:59.720 Uttam Kumaran: Okay. I invited you
254 00:29:00.795 ⇒ 00:29:01.430 Uttam Kumaran: sweet.
255 00:29:04.150 ⇒ 00:29:10.980 Uttam Kumaran: Also. There’s a service account like in one password. I think it’s just called pool parts ago@brainforge.ai.
256 00:29:30.460 ⇒ 00:29:31.790 Patrick Trainer: Okay, there we go.
257 00:30:06.590 ⇒ 00:30:09.620 Patrick Trainer: So wait. So there’s the attentive
258 00:30:10.020 ⇒ 00:30:13.460 Patrick Trainer: connector. Why, why weren’t we just using that.
259 00:30:14.401 ⇒ 00:30:18.970 Uttam Kumaran: This. This is some data that doesn’t come through in the tenant connector.
260 00:30:19.850 ⇒ 00:30:22.500 Uttam Kumaran: like a tenant connector, doesn’t give us revenue data.
261 00:30:24.060 ⇒ 00:30:25.030 Uttam Kumaran: Yeah.
262 00:30:31.230 ⇒ 00:30:35.356 Uttam Kumaran: but to set up a customer. We were just bringing that in.
263 00:30:35.920 ⇒ 00:30:37.100 Uttam Kumaran: manually.
264 00:31:42.960 ⇒ 00:31:44.310 Patrick Trainer: But where’s the
265 00:31:45.010 ⇒ 00:31:46.760 Patrick Trainer: like? The magic folder.
266 00:31:48.300 ⇒ 00:31:52.479 Uttam Kumaran: You just have to search. S. 3. There’s no, there’s no magic folder like it’s just s. 3.
267 00:31:53.000 ⇒ 00:31:53.660 Patrick Trainer: Well.
268 00:31:54.610 ⇒ 00:31:57.589 Patrick Trainer: so it’s it’s saying that S. 3 doesn’t
269 00:31:59.290 ⇒ 00:32:01.010 Patrick Trainer: like you can’t sync.
270 00:32:03.010 ⇒ 00:32:04.130 Uttam Kumaran: Why not?
271 00:32:06.050 ⇒ 00:32:06.410 Patrick Trainer: Doesn’t.
272 00:32:06.410 ⇒ 00:32:07.430 Uttam Kumaran: What does that mean?
273 00:32:07.430 ⇒ 00:32:09.440 Patrick Trainer: Like it done. Wait! Hold on!
274 00:32:10.000 ⇒ 00:32:11.230 Uttam Kumaran: Amazon, s. 3.
275 00:32:11.930 ⇒ 00:32:12.560 Patrick Trainer: Yeah.
276 00:32:12.820 ⇒ 00:32:14.830 Patrick Trainer: like you can get it. But the connector.
277 00:32:15.350 ⇒ 00:32:16.560 Patrick Trainer: it says, must.
278 00:32:17.050 ⇒ 00:32:19.459 Patrick Trainer: Okay. You must specify a file type.
279 00:32:21.080 ⇒ 00:32:23.039 Patrick Trainer: I’ll type this optional for other phone.
280 00:32:23.810 ⇒ 00:32:27.510 Uttam Kumaran: Are you looking? Are you just? Are you in the Amazon? S. 3. Connector.
281 00:32:27.510 ⇒ 00:32:29.739 Patrick Trainer: Here, hold on! I I forgot I wouldn’t.
282 00:32:29.900 ⇒ 00:32:30.740 Patrick Trainer: Sharon.
283 00:32:34.880 ⇒ 00:32:35.510 Uttam Kumaran: Yeah.
284 00:32:35.870 ⇒ 00:32:37.449 Patrick Trainer: Yeah, so like.
285 00:32:37.760 ⇒ 00:32:39.440 Patrick Trainer: what I’m reading is this
286 00:32:39.950 ⇒ 00:32:41.659 Patrick Trainer: specified file type.
287 00:32:41.930 ⇒ 00:32:42.490 Patrick Trainer: But the.
288 00:32:42.490 ⇒ 00:32:44.629 Uttam Kumaran: If you just if you just put.
289 00:32:44.650 ⇒ 00:32:46.979 Uttam Kumaran: I think if you just put in fur, it’ll work.
290 00:32:47.160 ⇒ 00:32:47.950 Patrick Trainer: Infer.
291 00:32:48.300 ⇒ 00:32:49.120 Uttam Kumaran: Yeah.
292 00:32:50.080 ⇒ 00:32:51.550 Uttam Kumaran: let’s try that.
293 00:32:52.040 ⇒ 00:32:54.099 Uttam Kumaran: Maybe they just don’t have on the dropdown.
294 00:32:56.690 ⇒ 00:32:57.910 Patrick Trainer: So
295 00:32:59.640 ⇒ 00:33:00.690 Patrick Trainer: what do we want
296 00:33:02.090 ⇒ 00:33:04.230 Patrick Trainer: schema table to be.
297 00:33:04.654 ⇒ 00:33:06.775 Uttam Kumaran: You can just call it
298 00:33:07.860 ⇒ 00:33:09.010 Uttam Kumaran: email.
299 00:33:10.110 ⇒ 00:33:10.710 Patrick Trainer: Okay.
300 00:33:12.600 ⇒ 00:33:18.509 Uttam Kumaran: Cause. There’s already an email table. There’s already an email schema. And then you can just name it whatever the attentive report is.
301 00:33:20.000 ⇒ 00:33:21.989 Uttam Kumaran: figure out what the name of it is.
302 00:33:22.170 ⇒ 00:33:22.980 Patrick Trainer: Is
303 00:33:23.450 ⇒ 00:33:26.989 Patrick Trainer: pull parts to go udum campaign, spend.
304 00:33:27.450 ⇒ 00:33:33.169 Uttam Kumaran: You can just do attentive. You can just do attentive underscore campaign underscore spend. Yeah, okay, cool.
305 00:33:46.910 ⇒ 00:33:49.620 Patrick Trainer: Actually turned down a job at attentive.
306 00:33:50.830 ⇒ 00:33:53.939 Uttam Kumaran: Oh, really, a friend of mine worked there, she said. It was kind of crazy.
307 00:33:54.160 ⇒ 00:33:54.640 Patrick Trainer: Yeah, it’s like.
308 00:33:54.640 ⇒ 00:33:55.270 Uttam Kumaran: Yeah.
309 00:33:55.600 ⇒ 00:33:56.860 Patrick Trainer: 3 years ago I
310 00:33:57.140 ⇒ 00:34:00.069 Patrick Trainer: accepted the job at Socure instead.
311 00:34:00.570 ⇒ 00:34:01.660 Uttam Kumaran: Oh, nice!
312 00:34:05.490 ⇒ 00:34:08.480 Patrick Trainer: Okay, the rocket.
313 00:34:26.030 ⇒ 00:34:26.850 Patrick Trainer: Okay.
314 00:35:32.400 ⇒ 00:35:33.220 Patrick Trainer: pay.
315 00:36:53.730 ⇒ 00:36:56.489 Patrick Trainer: Wait. So these come in every single day.
316 00:36:59.550 ⇒ 00:37:00.470 Patrick Trainer: And they
317 00:37:00.730 ⇒ 00:37:04.530 Patrick Trainer: do. They only contain like net new data? Or does.
318 00:37:04.530 ⇒ 00:37:07.429 Uttam Kumaran: No, they contain the last 30 days.
319 00:37:09.190 ⇒ 00:37:12.592 Uttam Kumaran: So but then I’m pretty sure that, like the
320 00:37:13.240 ⇒ 00:37:14.630 Patrick Trainer: Okay, that should be fun.
321 00:37:14.630 ⇒ 00:37:17.279 Uttam Kumaran: In Snowflake. It’ll just append, and then we can
322 00:37:17.670 ⇒ 00:37:19.300 Uttam Kumaran: dedupe it later.
323 00:37:19.470 ⇒ 00:37:20.190 Uttam Kumaran: right.
324 00:38:12.650 ⇒ 00:38:14.500 Patrick Trainer: Should I sync it to a
325 00:38:16.110 ⇒ 00:38:18.069 Patrick Trainer: specific, like attentive
326 00:38:18.650 ⇒ 00:38:20.960 Patrick Trainer: path, or.
327 00:38:22.660 ⇒ 00:38:24.330 Patrick Trainer: I guess it doesn’t matter right now.
328 00:38:24.840 ⇒ 00:38:27.759 Uttam Kumaran: I guess, for now it doesn’t matter. That’s only one.
329 00:38:28.310 ⇒ 00:38:32.700 Uttam Kumaran: I mean, unless you can get the Klavio thing working. I don’t know what we’re gonna do about Klavio. But.
330 00:38:35.210 ⇒ 00:38:35.960 Patrick Trainer: I’m not getting that.
331 00:38:35.960 ⇒ 00:38:36.870 Uttam Kumaran: About it.
332 00:38:36.870 ⇒ 00:38:37.819 Patrick Trainer: Right now then.
333 00:38:39.680 ⇒ 00:38:49.479 Uttam Kumaran: The Klavio thing. I have an I have another idea, but it will require some AI like basically, what we’ll do is we can have a click into it and then log in. But I’ll have to do that later.
334 00:40:07.260 ⇒ 00:40:07.960 Patrick Trainer: Okay.
335 00:40:10.530 ⇒ 00:40:12.440 Patrick Trainer: and the widgets.
336 00:40:16.700 ⇒ 00:40:18.460 Uttam Kumaran: Judgment, touch.
337 00:41:35.280 ⇒ 00:41:36.860 Patrick Trainer: I got it.
338 00:41:37.110 ⇒ 00:41:38.420 Patrick Trainer: create.
339 00:41:42.720 ⇒ 00:41:44.950 Patrick Trainer: external. I am.
340 00:42:34.040 ⇒ 00:42:36.050 Uttam Kumaran: Nice. Okay. Cool. Done.
341 00:43:05.800 ⇒ 00:43:06.690 Patrick Trainer: Okay.
342 00:45:46.430 ⇒ 00:45:47.130 Patrick Trainer: Time.
343 00:49:26.540 ⇒ 00:49:27.280 Uttam Kumaran: Okay.
344 00:54:08.181 ⇒ 00:54:14.050 Uttam Kumaran: okay, these 2 emails are good. So so direct mail is good to go.
345 00:54:23.760 ⇒ 00:54:24.550 Patrick Trainer: Talking with
346 00:54:25.270 ⇒ 00:54:26.550 Patrick Trainer: aws.
347 00:54:39.800 ⇒ 00:54:46.723 Uttam Kumaran: Dude. You know. The most brutal part about like being on the business side of this is that people call my phone like all fucking day
348 00:54:47.230 ⇒ 00:54:51.300 Uttam Kumaran: like like they can’t email me. They’re like, call my phone like, Hey.
349 00:54:51.900 ⇒ 00:54:58.650 Uttam Kumaran: because salespeople, they like they know that their whole goal is to get you on the phone which respect it’s also our goal.
350 00:54:58.660 ⇒ 00:55:04.673 Uttam Kumaran: But like these guys are like in software, they call me like any moment of the day to call me like.
351 00:55:05.140 ⇒ 00:55:13.159 Uttam Kumaran: And I’m literally like, Hey, I can’t. I can’t pick up your phone email. Me, they’re like, Hey, just want to check. If you have this, I said, email me.
352 00:55:13.320 ⇒ 00:55:21.309 Uttam Kumaran: I just said, email me right, don’t fucking. I’m gonna block you like. Don’t don’t call my personal cell without working.
353 00:55:21.310 ⇒ 00:55:22.030 Patrick Trainer: Stuff.
354 00:55:22.030 ⇒ 00:55:23.870 Uttam Kumaran: Like, unless you work
355 00:55:23.920 ⇒ 00:55:30.719 Uttam Kumaran: at Brain Forge shouldn’t be calling my cell phone unless we’re unless we’re like about to make some money. Otherwise, let’s not talk like
356 00:55:30.790 ⇒ 00:55:33.419 Uttam Kumaran: slack me or email me, there’s nothing to talk about.
357 00:55:34.900 ⇒ 00:55:36.490 Uttam Kumaran: This is ridiculous.
358 00:55:39.920 ⇒ 00:55:45.339 Uttam Kumaran: Some guys literally like just calling some recruiters like calling and like dude just fucking slack. Me, Bro.
359 00:55:45.850 ⇒ 00:55:46.970 Uttam Kumaran: you doing?
360 00:55:52.050 ⇒ 00:55:53.940 Uttam Kumaran: Okay? So notion.
361 00:55:55.060 ⇒ 00:55:57.330 Uttam Kumaran: I go to documentation.
362 00:55:59.470 ⇒ 00:56:02.339 Uttam Kumaran: And I’m gonna go to manual emails.
363 00:56:02.710 ⇒ 00:56:05.760 Uttam Kumaran: And the direct mail is hand says.
364 00:56:18.260 ⇒ 00:56:18.930 Uttam Kumaran: Okay.
365 00:59:24.340 ⇒ 00:59:29.230 Uttam Kumaran: okay, so we’re good on direct mail. What else on your side.
366 00:59:29.900 ⇒ 00:59:31.859 Patrick Trainer: I’m just going through the
367 00:59:33.385 ⇒ 00:59:35.004 Patrick Trainer: creating the 5 trend
368 00:59:35.410 ⇒ 00:59:36.050 Uttam Kumaran: Oh, okay.
369 00:59:36.050 ⇒ 00:59:39.750 Patrick Trainer: Role in IM user in aws.
370 00:59:40.300 ⇒ 00:59:41.020 Uttam Kumaran: Okay.
371 00:59:41.550 ⇒ 00:59:42.560 Patrick Trainer: And
372 01:01:19.470 ⇒ 01:01:21.261 Uttam Kumaran: Okay, I’m also setting the the
373 01:01:22.560 ⇒ 01:01:24.150 Uttam Kumaran: query timeout.
374 01:01:25.590 ⇒ 01:01:27.019 Patrick Trainer: Oh, yeah, that’s a good idea.
375 01:01:27.760 ⇒ 01:01:32.660 Uttam Kumaran: Yeah, it’s I. Just, I’m just gonna set it on this, the service user for the transfer.
376 01:01:42.690 ⇒ 01:01:43.950 Patrick Trainer: I see.
377 01:01:58.820 ⇒ 01:02:03.510 Uttam Kumaran: And then where your your your snowflake scripts are in brainforge actions.
378 01:02:06.243 ⇒ 01:02:07.690 Patrick Trainer: Which ones?
379 01:02:08.340 ⇒ 01:02:11.832 Uttam Kumaran: The ones to like do our back and like, create the
380 01:02:15.470 ⇒ 01:02:17.080 Patrick Trainer: Yes, they should be.
381 01:02:17.410 ⇒ 01:02:21.030 Patrick Trainer: if not, I can. There’s probably more, I need to add, but.
382 01:02:21.030 ⇒ 01:02:23.584 Uttam Kumaran: At the bottom of it. I’m just gonna add this,
383 01:02:26.190 ⇒ 01:02:27.620 Uttam Kumaran: query timeout.
384 01:02:27.770 ⇒ 01:02:28.690 Uttam Kumaran: Okay, cool.
385 01:02:46.970 ⇒ 01:02:51.399 Uttam Kumaran: Actually, I guess I can just do on when you. When you do the create user, I’m just gonna do this
386 01:02:55.070 ⇒ 01:02:59.140 Uttam Kumaran: statement time on second 600. That’ll be 10 min.
387 01:03:05.820 ⇒ 01:03:06.810 Patrick Trainer: All right.
388 01:03:08.140 ⇒ 01:03:10.630 Patrick Trainer: All of that S. 3 is connected.
389 01:03:12.250 ⇒ 01:03:15.758 Patrick Trainer: and stuff looks like it’s
390 01:03:17.140 ⇒ 01:03:18.249 Patrick Trainer: starting to sink.
391 01:03:48.080 ⇒ 01:03:51.105 Patrick Trainer: and it is some bullshit that
392 01:03:52.180 ⇒ 01:03:55.380 Patrick Trainer: I’ve Tran took out the the logs, tab.
393 01:03:55.670 ⇒ 01:03:57.389 Uttam Kumaran: I know it’s fucked.
394 01:03:57.390 ⇒ 01:03:57.820 Patrick Trainer: Yeah.
395 01:03:57.820 ⇒ 01:04:00.069 Uttam Kumaran: Not understand really why, but maybe they.
396 01:04:00.300 ⇒ 01:04:00.970 Patrick Trainer: They also.
397 01:04:02.420 ⇒ 01:04:04.229 Uttam Kumaran: took off like the.
398 01:04:04.230 ⇒ 01:04:05.250 Patrick Trainer: Data dog
399 01:04:05.570 ⇒ 01:04:06.760 Patrick Trainer: connector like.
400 01:04:06.830 ⇒ 01:04:07.859 Patrick Trainer: we used to
401 01:04:07.970 ⇒ 01:04:11.279 Patrick Trainer: push all of those logs into data dog. And it was great.
402 01:04:12.200 ⇒ 01:04:14.120 Patrick Trainer: And then they like they killed it
403 01:04:32.310 ⇒ 01:04:33.150 Patrick Trainer: right?
404 01:06:39.110 ⇒ 01:06:39.980 Patrick Trainer: All right.
405 01:06:41.960 ⇒ 01:06:45.209 Patrick Trainer: Table or 5 transync has worked.
406 01:06:46.870 ⇒ 01:06:49.610 Uttam Kumaran: Okay. So Ryan probably just needs to move that in. Then I.
407 01:07:00.000 ⇒ 01:07:02.660 Patrick Trainer: And so all we should need to do
408 01:07:03.910 ⇒ 01:07:05.090 Patrick Trainer: is.
409 01:07:08.210 ⇒ 01:07:11.790 Patrick Trainer: I guess, nothing. I guess we’re done because we got the
410 01:07:12.150 ⇒ 01:07:13.720 Patrick Trainer: got the attentive stuff.
411 01:07:15.750 ⇒ 01:07:19.680 Patrick Trainer: Up industry, and that just needs to run on a
412 01:07:20.930 ⇒ 01:07:21.860 Patrick Trainer: schedule
413 01:08:02.600 ⇒ 01:08:03.360 Patrick Trainer: cool.
414 01:08:05.220 ⇒ 01:08:06.320 Patrick Trainer: you want to give a
415 01:08:06.330 ⇒ 01:08:07.950 Patrick Trainer: thumbs up on
416 01:08:09.100 ⇒ 01:08:10.340 Patrick Trainer: this Pr.
417 01:08:11.510 ⇒ 01:08:14.030 Uttam Kumaran: Give me one second. Here we go.
418 01:08:53.260 ⇒ 01:08:54.210 Patrick Trainer: Oof.
419 01:11:37.290 ⇒ 01:11:42.119 Uttam Kumaran: Can we? While I got in the phone? Can we clean up actually sorry? What pr should I check.
420 01:11:42.846 ⇒ 01:11:44.030 Patrick Trainer: Put it in the chat.
421 01:11:45.000 ⇒ 01:11:45.860 Uttam Kumaran: Oh, okay.
422 01:11:46.720 ⇒ 01:11:49.250 Uttam Kumaran: maybe we can just clean up the Github issues.
423 01:11:50.550 ⇒ 01:11:52.360 Uttam Kumaran: Ugly Github actions.
424 01:11:58.830 ⇒ 01:11:59.520 Uttam Kumaran: Thank you.
425 01:12:14.980 ⇒ 01:12:16.910 Uttam Kumaran: Nice. Okay. And this posts to slack.
426 01:12:18.030 ⇒ 01:12:18.650 Patrick Trainer: Yes.
427 01:12:19.060 ⇒ 01:12:20.240 Uttam Kumaran: Okay. Cool. Sick.
428 01:12:20.880 ⇒ 01:12:23.530 Patrick Trainer: When it yeah, when it’s done there, when it fails.
429 01:12:25.620 ⇒ 01:12:26.810 Uttam Kumaran: Nice.
430 01:12:27.460 ⇒ 01:12:28.840 Uttam Kumaran: Okay, dope
431 01:12:30.950 ⇒ 01:12:31.860 Uttam Kumaran: back?
432 01:12:32.090 ⇒ 01:12:33.500 Uttam Kumaran: I approved.
433 01:12:37.850 ⇒ 01:12:38.809 Patrick Trainer: All right
434 01:12:47.760 ⇒ 01:12:49.000 Patrick Trainer: merged.
435 01:18:56.380 ⇒ 01:18:58.599 Patrick Trainer: Why is there like so little
436 01:18:58.800 ⇒ 01:18:59.710 Patrick Trainer: data
437 01:19:00.380 ⇒ 01:19:02.159 Patrick Trainer: in these attentive reports?
438 01:19:05.570 ⇒ 01:19:07.670 Uttam Kumaran: What does that mean? Like.
439 01:19:08.350 ⇒ 01:19:11.650 Patrick Trainer: The last one you sent only has 8 rows.
440 01:19:16.148 ⇒ 01:19:17.789 Patrick Trainer: Same with the one before.
441 01:19:18.780 ⇒ 01:19:22.280 Uttam Kumaran: I guess, like, what is that like 8 rows per day, or like I don’t. I don’t have the report.
442 01:19:22.280 ⇒ 01:19:23.470 Patrick Trainer: No, it’s just like
443 01:19:23.680 ⇒ 01:19:26.769 Patrick Trainer: the like. The whole file is 8 rows.
444 01:19:31.520 ⇒ 01:19:36.680 Uttam Kumaran: I don’t know. I’m not exactly sure. I don’t remember exactly what’s supposed to be in there. But
445 01:19:37.470 ⇒ 01:19:40.520 Uttam Kumaran: is it? I don’t know you can open the
446 01:19:41.490 ⇒ 01:19:48.529 Uttam Kumaran: there’s a Google sheet for it right now. You can just compare it to that. But I don’t. Maybe there’s we’re not running any attentive campaigns. I’m not exactly sure.
447 01:19:48.530 ⇒ 01:19:49.860 Patrick Trainer: Maybe that’s it.
448 01:19:51.540 ⇒ 01:19:54.670 Uttam Kumaran: But probably good question for Ryan. I would just ask him.
449 01:19:55.240 ⇒ 01:19:57.109 Uttam Kumaran: I don’t really remember.
450 01:20:00.640 ⇒ 01:20:01.490 Patrick Trainer: Guess it’s
451 01:20:01.930 ⇒ 01:20:03.890 Patrick Trainer: okay. It’s looking like there’s like.
452 01:20:05.260 ⇒ 01:20:07.700 Patrick Trainer: it’s aggregated on the message.
453 01:20:08.390 ⇒ 01:20:12.429 Patrick Trainer: And so there’s a send date. Okay, yeah, it’s aggregated on the send date
454 01:20:12.810 ⇒ 01:20:14.209 Patrick Trainer: and the message.
455 01:20:14.510 ⇒ 01:20:17.099 Uttam Kumaran: Oh, okay, so it’s probably some values change.
456 01:20:17.100 ⇒ 01:20:18.219 Patrick Trainer: And so.
457 01:20:21.080 ⇒ 01:20:23.749 Patrick Trainer: okay, yeah, then there’s fees.
458 01:20:24.580 ⇒ 01:20:26.260 Patrick Trainer: carrier fees. Okay.
459 01:20:27.390 ⇒ 01:20:28.479 Patrick Trainer: that makes sense.
460 01:20:57.200 ⇒ 01:21:00.309 Patrick Trainer: Alright. I’m gonna hop for a bit. Get something to eat.
461 01:21:00.990 ⇒ 01:21:06.980 Uttam Kumaran: Okay, cool? Yeah. If you get a chance, you want to clean up the pool parts like work flows.
462 01:21:06.980 ⇒ 01:21:07.880 Patrick Trainer: Yeah.
463 01:21:08.740 ⇒ 01:21:16.382 Uttam Kumaran: And then actually food for thought. I’m gonna send you something that I saw today, and maybe take a look at that
464 01:21:17.450 ⇒ 01:21:19.609 Uttam Kumaran: one sec. One. Sec. One. Sec.
465 01:22:13.650 ⇒ 01:22:17.349 Uttam Kumaran: I am thinking of seeing whether you can
466 01:22:18.040 ⇒ 01:22:19.749 Uttam Kumaran: look at this.
467 01:22:20.280 ⇒ 01:22:22.219 Uttam Kumaran: I’m going to send it to you on slack.
468 01:22:22.980 ⇒ 01:22:24.880 Uttam Kumaran: but give these a read
469 01:22:26.360 ⇒ 01:22:28.169 Uttam Kumaran: and dug some of these up.
470 01:22:32.230 ⇒ 01:22:34.530 Uttam Kumaran: and I was just researching this problem. But.
471 01:22:34.530 ⇒ 01:22:35.170 Patrick Trainer: Hmm.
472 01:22:40.920 ⇒ 01:22:43.100 Uttam Kumaran: I think that we can do
473 01:22:43.790 ⇒ 01:22:48.540 Uttam Kumaran: both Pr. Reviewers and adding the Pr. Description pretty easily.
474 01:22:48.920 ⇒ 01:22:50.280 Uttam Kumaran: That’s probably.
475 01:22:50.280 ⇒ 01:22:52.360 Patrick Trainer: It’s actually a thing on
476 01:22:52.660 ⇒ 01:22:54.990 Patrick Trainer: in Vs code, like, if you have
477 01:22:55.130 ⇒ 01:22:56.120 Patrick Trainer: co-pilot
478 01:22:56.960 ⇒ 01:23:00.902 Patrick Trainer: like that, I’ve it. I just discovered this yesterday.
479 01:23:01.480 ⇒ 01:23:05.660 Patrick Trainer: and it just like automatically populates when you create a Pr.
480 01:23:06.740 ⇒ 01:23:07.670 Uttam Kumaran: Oh! Sick!
481 01:23:07.670 ⇒ 01:23:09.030 Patrick Trainer: Yeah, yeah.
482 01:23:09.090 ⇒ 01:23:12.310 Patrick Trainer: like, so that that pr, that I opened earlier.
483 01:23:12.860 ⇒ 01:23:18.699 Uttam Kumaran: Yeah, I read it, and I was like they could definitely just copy. I thought you copied the diff into github or something. But.
484 01:23:18.700 ⇒ 01:23:20.630 Patrick Trainer: Yeah, no, no, that was like
485 01:23:20.990 ⇒ 01:23:22.210 Patrick Trainer: I didn’t even
486 01:23:22.310 ⇒ 01:23:26.930 Patrick Trainer: I guess I didn’t even really read it. But like all I did, but like it’s
487 01:23:26.960 ⇒ 01:23:29.530 Patrick Trainer: once I click, clicked.
488 01:23:29.950 ⇒ 01:23:31.160 Patrick Trainer: create. Pr
489 01:23:31.510 ⇒ 01:23:33.139 Patrick Trainer: was just there and then I
490 01:23:33.220 ⇒ 01:23:34.350 Patrick Trainer: committed it up.
491 01:23:34.800 ⇒ 01:23:47.669 Uttam Kumaran: Yeah, the reason I want to have it as an external thing out of the S is because everything we do is going to be tailored towards Brainforge. So actually, like, instead of just being like, look at this and give me the Pr, I’m actually, gonna
492 01:23:47.990 ⇒ 01:23:51.149 Uttam Kumaran: we’re gonna have it be like, we’re doing data work
493 01:23:51.570 ⇒ 01:23:52.310 Uttam Kumaran: and.
494 01:23:52.310 ⇒ 01:23:52.790 Patrick Trainer: Say, yeah.
495 01:23:52.790 ⇒ 01:23:55.119 Uttam Kumaran: Then we’re gonna start. We’re gonna start to build on top of it.
496 01:23:55.120 ⇒ 01:23:55.860 Patrick Trainer: You want a prompt Yeah.
497 01:23:56.630 ⇒ 01:24:11.839 Uttam Kumaran: Yeah. So I’m so basically, I’m thinking about having it. Like, if we get this Github action working, then what we’ll do is when we send it to Openai instead, I’ll send it somewhere else, and then it’ll it’ll be even more tailored to the work we do, which is like we do data work
498 01:24:11.960 ⇒ 01:24:17.819 Uttam Kumaran: here. Maybe here’s context about some of the stuff we’re doing that way. It’s like, really tailored. And then also, I wanted to give
499 01:24:17.830 ⇒ 01:24:23.520 Uttam Kumaran: pr descriptions, and like a specific pattern and stuff like that. So this is like the 1st building block towards that
500 01:24:23.680 ⇒ 01:24:26.160 Uttam Kumaran: in my mind is like, if we can do
501 01:24:26.470 ⇒ 01:24:39.880 Uttam Kumaran: get the if we can comment on the issue with the Pr descript comment on the Pr with the description and comment like a reviewer like a like a review. Basically, just like you should think about this. You should think about this.
502 01:24:40.130 ⇒ 01:24:43.790 Uttam Kumaran: That’ll be like, that’d be like an insane step one
503 01:24:46.310 ⇒ 01:24:57.959 Uttam Kumaran: and then, ideally, what we will do is the review will actually start to have a ideally have the context of the repo to do the review and then have the context of like the issue.
504 01:24:58.110 ⇒ 01:25:05.539 Uttam Kumaran: So it’ll continue to build on itself to the. And then the final stage of that is, can we go straight from issue
505 01:25:05.590 ⇒ 01:25:22.799 Uttam Kumaran: to propose solution in the on the comments of the issue. So when an issue gets created, the requirements get passed, and on every update to the issue as well. Those new sets of requirements get passed to to an AI, and then a comment appears with like this is probably what you should do.
506 01:25:22.970 ⇒ 01:25:24.236 Patrick Trainer: Okay. Okay.
507 01:25:26.460 ⇒ 01:25:40.395 Uttam Kumaran: So I wanted to see whether you can start poking around at like and the Github actions, for this is actually pretty easy also, what we can do is I’m we. We can try to write this in Zapier or in something else.
508 01:25:42.170 ⇒ 01:25:45.980 Uttam Kumaran: because we don’t really necessarily need to do it in issues.
509 01:25:49.410 ⇒ 01:25:52.040 Uttam Kumaran: we don’t really need to necessarily do it as an action.
510 01:25:52.790 ⇒ 01:25:59.700 Uttam Kumaran: You can. Basically what you can do is github issues. It’s it’s it’s actually you can have web hook events get published.
511 01:25:59.700 ⇒ 01:26:00.580 Patrick Trainer: Yeah, yeah.
512 01:26:00.580 ⇒ 01:26:04.800 Uttam Kumaran: So you can listen in. And we can listen in on that within Zapier.
513 01:26:05.180 ⇒ 01:26:09.199 Uttam Kumaran: We’re also using this tool called relevance, like on any number of these tools.
514 01:26:09.540 ⇒ 01:26:10.170 Patrick Trainer: Right.
515 01:26:10.170 ⇒ 01:26:11.100 Uttam Kumaran: So
516 01:26:11.330 ⇒ 01:26:18.330 Uttam Kumaran: and then, yeah, so basically, it’s like you would, you would listen for a Pr gather the specific data and then resubmit something.
517 01:26:18.330 ⇒ 01:26:19.920 Patrick Trainer: Right? Right?
518 01:26:20.250 ⇒ 01:26:22.049 Patrick Trainer: And it’s like you can
519 01:26:22.530 ⇒ 01:26:26.950 Patrick Trainer: use those like events and web those event web hooks to trigger
520 01:26:27.130 ⇒ 01:26:28.900 Patrick Trainer: other actions, too.
521 01:26:29.030 ⇒ 01:26:29.430 Uttam Kumaran: Totally.
522 01:26:29.430 ⇒ 01:26:30.950 Patrick Trainer: And so.
523 01:26:31.360 ⇒ 01:26:33.930 Patrick Trainer: And what’s nice about that is like
524 01:26:33.960 ⇒ 01:26:38.179 Patrick Trainer: in actions like actions, is already like hydrated, with
525 01:26:38.230 ⇒ 01:26:40.359 Patrick Trainer: all of like the metadata of
526 01:26:40.910 ⇒ 01:26:42.430 Patrick Trainer: the repo itself.
527 01:26:42.670 ⇒ 01:26:43.190 Uttam Kumaran: Yeah.
528 01:26:43.190 ⇒ 01:26:45.609 Patrick Trainer: So there’s yeah. There’s a couple of ways.
529 01:26:46.600 ⇒ 01:26:51.489 Uttam Kumaran: Yeah, the if it’s like, unless if we need the contents of the repo
530 01:26:51.570 ⇒ 01:26:55.349 Uttam Kumaran: that I’m okay using actions. But I’m also
531 01:26:55.460 ⇒ 01:26:59.317 Uttam Kumaran: kind of like fuck actions for a while.
532 01:26:59.830 ⇒ 01:27:02.300 Uttam Kumaran: and I kind of just want to work outside of it
533 01:27:02.410 ⇒ 01:27:03.460 Uttam Kumaran: like
534 01:27:03.600 ⇒ 01:27:05.647 Uttam Kumaran: alright in some way.
535 01:27:06.480 ⇒ 01:27:08.049 Uttam Kumaran: but I get it, I mean, like
536 01:27:08.070 ⇒ 01:27:10.690 Uttam Kumaran: the the examples that I sent you.
537 01:27:11.920 ⇒ 01:27:14.020 Uttam Kumaran: like. These actions are pretty.
538 01:27:16.740 ⇒ 01:27:18.470 Uttam Kumaran: are pretty manageable.
539 01:27:21.240 ⇒ 01:27:22.650 Uttam Kumaran: It’s not that bad.
540 01:27:24.250 ⇒ 01:27:30.490 Uttam Kumaran: But again, the quality is not going to be great unless the the quality of all these tools are. They’re they’re so generic
541 01:27:30.780 ⇒ 01:27:35.570 Uttam Kumaran: that I want to make it ours because we do have a distinct thing that we do.
542 01:27:35.620 ⇒ 01:27:51.759 Uttam Kumaran: and there and like we can really push it towards like exactly what we need, instead of being like generated. Pr, it’s like we do. SQL, dbt, data work it. It really will improve it. So that’s why I’m inclined to like. See whether maybe we should do some of this in Zapier or another tool where we can add those prompts.
543 01:27:51.940 ⇒ 01:27:58.239 Uttam Kumaran: And then basically, our work is gonna be like prompting and like kind of like more prompt engineering related stuff.
544 01:27:59.450 ⇒ 01:28:00.060 Patrick Trainer: Cool.
545 01:28:01.340 ⇒ 01:28:02.040 Patrick Trainer: cool, cool, but.
546 01:28:02.040 ⇒ 01:28:04.770 Uttam Kumaran: Take a look at some of those, and then I’m gonna send you
547 01:28:06.100 ⇒ 01:28:11.059 Uttam Kumaran: I’ll send you one more, just like I just like found a bunch of blog posts like on this. So.
548 01:28:11.378 ⇒ 01:28:13.289 Patrick Trainer: Sweet. Yeah, yeah. Send them over.
549 01:28:15.220 ⇒ 01:28:18.769 Uttam Kumaran: Okay, cool. I’ll be here if you need anything. Alright, man.
550 01:28:19.630 ⇒ 01:28:21.280 Uttam Kumaran: I did. Thank you.