Meeting Title: Daily-Brainforge-Standup Date: 2024-04-30 Meeting participants: Uttam Kumaran, Agustin, Jakob Kagel, Patrick Trainer, Ryan Luke Daque
WEBVTT
1 00:00:42.740 ⇒ 00:00:43.115 Uttam Kumaran: Yeah.
2 00:00:46.450 ⇒ 00:00:47.360 Patrick Trainer: What’s going on.
3 00:00:48.550 ⇒ 00:00:49.720 Uttam Kumaran: Same old.
4 00:00:50.250 ⇒ 00:00:51.160 Patrick Trainer: Heard that.
5 00:00:52.520 ⇒ 00:00:53.570 Agustin: Hi! Everyone!
6 00:00:53.640 ⇒ 00:00:54.940 Agustin: Oh, what’s up there?
7 00:00:57.050 ⇒ 00:00:58.190 Patrick Trainer: Chilling.
8 00:00:58.990 ⇒ 00:00:59.840 Patrick Trainer: I just.
9 00:00:59.840 ⇒ 00:01:03.116 Uttam Kumaran: Tried to create an azure account. It took me like 15 min.
10 00:01:03.840 ⇒ 00:01:05.050 Patrick Trainer: What are you trying to do.
11 00:01:05.280 ⇒ 00:01:06.583 Uttam Kumaran: Create an azure account.
12 00:01:06.910 ⇒ 00:01:07.660 Patrick Trainer: Oh!
13 00:01:08.320 ⇒ 00:01:08.910 Uttam Kumaran: It’s just like.
14 00:01:08.910 ⇒ 00:01:09.880 Patrick Trainer: Soft man.
15 00:01:11.390 ⇒ 00:01:12.740 Uttam Kumaran: Takes so long.
16 00:01:14.440 ⇒ 00:01:15.080 Agustin: Yeah.
17 00:01:16.360 ⇒ 00:01:22.839 Agustin: I had problem with my credit card, but I’m not sure if it’s from my country, or why.
18 00:01:27.680 ⇒ 00:01:30.149 Uttam Kumaran: Let me know if that works. Augustine. That should be fine.
19 00:01:31.450 ⇒ 00:01:32.160 Agustin: Yeah.
20 00:01:40.420 ⇒ 00:01:44.120 Agustin: I’m not. I may be wrong, but it’s asking me.
21 00:01:44.210 ⇒ 00:01:45.310 Agustin: Let me see.
22 00:01:45.890 ⇒ 00:01:47.849 Agustin: I will say I agree.
23 00:01:50.550 ⇒ 00:01:55.449 Agustin: It’s asking me to provide a credit card again, but I think I can deal with that. I think.
24 00:01:56.460 ⇒ 00:01:58.759 Uttam Kumaran: I already I already I just invited you.
25 00:01:59.970 ⇒ 00:02:01.680 Agustin: Yeah, I saw that. I put a call.
26 00:02:01.680 ⇒ 00:02:02.650 Uttam Kumaran: Credit, card, in.
27 00:02:05.040 ⇒ 00:02:05.870 Agustin: But me.
28 00:02:07.020 ⇒ 00:02:07.590 Uttam Kumaran: Wolf.
29 00:02:10.570 ⇒ 00:02:15.960 Agustin: Yeah, it’s asking me for a car again. Not sure if it’s because I already use this email.
30 00:02:17.050 ⇒ 00:02:18.130 Uttam Kumaran: Oh!
31 00:02:19.980 ⇒ 00:02:21.539 Agustin: Yeah, I can try.
32 00:02:21.930 ⇒ 00:02:23.950 Uttam Kumaran: Okay, let’s stay on. After this we could figure it out.
33 00:02:25.220 ⇒ 00:02:25.600 Agustin: Short.
34 00:02:26.800 ⇒ 00:02:34.140 Uttam Kumaran: Okay, I think Ryan may be finishing an interview, but we can get started. I think the big stuff for
35 00:02:34.580 ⇒ 00:02:37.609 Uttam Kumaran: today. Let me just pull this up.
36 00:02:44.680 ⇒ 00:02:46.610 Uttam Kumaran: Okay, cool. So
37 00:02:47.370 ⇒ 00:02:51.720 Uttam Kumaran: Asset Link side. I could talk to Ryan about this.
38 00:02:53.700 ⇒ 00:02:57.199 Uttam Kumaran: I don’t know. Probably no movement on these, either. Pat.
39 00:03:01.538 ⇒ 00:03:06.690 Patrick Trainer: A little bit, but it’s still kinda it’s still in progress.
40 00:03:08.946 ⇒ 00:03:11.427 Uttam Kumaran: I think. Pool part side.
41 00:03:12.730 ⇒ 00:03:21.230 Uttam Kumaran: the, I guess. Yeah, I was. Gonna ask Jacob how the meeting went, and I know I’m like going back and forth with her on the permissions thing today. So
42 00:03:21.320 ⇒ 00:03:22.400 Uttam Kumaran: gonna hopefully resolve.
43 00:03:22.400 ⇒ 00:03:50.050 Jakob Kagel: No worries. But yeah, the meeting went really. Well, I mean, it’s very positive. You know, she likes what I built and yeah, I just kind of talked to her a little bit, too, I guess, about sort of other things that she will might want to see so she mentioned that she cares a lot about like profitability and like daily profitability. I know we have some views in light desk already that I saw kind of on this. I don’t know
44 00:03:50.060 ⇒ 00:03:56.198 Jakob Kagel: if they’re like ready for consumption or not. So I was gonna kind of run that by you.
45 00:03:57.050 ⇒ 00:04:04.321 Jakob Kagel: But that was something that she like specifically mentioned. Sort of that she’s very interested in seeing
46 00:04:05.360 ⇒ 00:04:07.062 Jakob Kagel: But yeah, as far as the
47 00:04:07.970 ⇒ 00:04:16.640 Jakob Kagel: the actual dashboard like for her weekly report. The only other thing that we could also like still add, that is in there.
48 00:04:17.031 ⇒ 00:04:30.369 Jakob Kagel: That we don’t have is the cost per add. So we would just need for like paid social, like the number of ads, and that’s like the only thing basically that we haven’t been able to replicate
49 00:04:31.470 ⇒ 00:04:32.529 Uttam Kumaran: So on, here.
50 00:04:32.530 ⇒ 00:04:34.440 Jakob Kagel: Yeah, exactly.
51 00:04:34.740 ⇒ 00:04:35.840 Jakob Kagel: So
52 00:04:36.310 ⇒ 00:04:39.618 Jakob Kagel: that’s I don’t know if we wanna try to pull that in
53 00:04:40.170 ⇒ 00:04:42.999 Uttam Kumaran: Let’s do that. I’m just gonna I’ll just create a ticket for it.
54 00:04:43.480 ⇒ 00:04:52.730 Jakob Kagel: Sounds good. Yeah. I imagine it shouldn’t be too too difficult. But yeah, that’s the only last piece that I mentioned to her that like we didn’t have. So yeah.
55 00:04:52.730 ⇒ 00:04:56.070 Uttam Kumaran: So this would be like number like, was it number of active ads?
56 00:04:56.230 ⇒ 00:05:08.324 Jakob Kagel: Yeah, I mean, so the way that it’s like, I mean, I assume that it’s calculated is just like the weekly costs, and then divided by the number of yeah, like ads that week.
57 00:05:10.540 ⇒ 00:05:19.230 Jakob Kagel: And I mean, of course, we can check it, you know, with like sort of historical versions of her weekly to report, to make sure that they tie out
58 00:05:22.050 ⇒ 00:05:24.280 Jakob Kagel: but that would be the last piece there
59 00:05:25.470 ⇒ 00:05:31.790 Jakob Kagel: and then for me, like in evidence just ran into. Unfortunately, one more issue.
60 00:05:32.168 ⇒ 00:05:34.010 Jakob Kagel: There as well, I noticed
61 00:05:34.300 ⇒ 00:05:43.865 Jakob Kagel: slack to Pat. But I can get all my queries will run like in Bs code. But when it goes to evidence I’m getting like an error.
62 00:05:44.240 ⇒ 00:05:47.530 Jakob Kagel: this saying that like the Dbt
63 00:05:47.580 ⇒ 00:05:49.840 Jakob Kagel: like doesn’t exist, or something.
64 00:05:52.690 ⇒ 00:06:14.110 Jakob Kagel: it says the catalog Dbt does not exist. And I don’t know. I’m also like seeing sort of like when I create the queries that, like they’re coming through is like untracked I don’t know if I if you have a couple of minutes, maybe like after the call, we can maybe just jump on real quick again, if that’s all right. Been trying to figure it out this morning.
65 00:06:18.040 ⇒ 00:06:24.039 Patrick Trainer: I don’t have a few minutes after the call, but later today I should
66 00:06:25.370 ⇒ 00:06:28.360 Patrick Trainer: the the untracked stuff that
67 00:06:28.540 ⇒ 00:06:30.119 Patrick Trainer: just sounds like get
68 00:06:30.210 ⇒ 00:06:31.380 Patrick Trainer: being get
69 00:06:32.493 ⇒ 00:06:45.893 Patrick Trainer: so like you’d have to commit those changes. To get the the tracking on on those files. The the other stuff the catalog be not being there like.
70 00:06:46.910 ⇒ 00:06:49.160 Patrick Trainer: just make sure, like.
71 00:06:49.180 ⇒ 00:06:51.330 Patrick Trainer: wherever that query is, if it’s like
72 00:06:52.257 ⇒ 00:06:56.189 Patrick Trainer: like pulling from the sources, and then you’re doing it that way.
73 00:06:56.190 ⇒ 00:07:01.730 Jakob Kagel: It can run fine like it runs in vs, like, no problem. So
74 00:07:01.920 ⇒ 00:07:06.550 Jakob Kagel: that’s why I’m kinda like, it’s weird to me that it like it won’t like
75 00:07:06.770 ⇒ 00:07:09.403 Jakob Kagel: show up like in evidence. But yeah.
76 00:07:09.780 ⇒ 00:07:14.519 Patrick Trainer: Need to update the sources as well like run the
77 00:07:15.485 ⇒ 00:07:18.560 Patrick Trainer: like. The evidence sources command.
78 00:07:19.250 ⇒ 00:07:21.117 Jakob Kagel: Okay, got it?
79 00:07:22.280 ⇒ 00:07:26.090 Patrick Trainer: And so that way it like gets materialized into duct TV.
80 00:07:27.400 ⇒ 00:07:33.960 Jakob Kagel: Sounds good. Well, I’ll give that a try. And yeah, if I can’t figure it out. If we can just jump on later. That’d be great.
81 00:07:35.130 ⇒ 00:07:35.720 Patrick Trainer: Cool.
82 00:07:36.180 ⇒ 00:07:38.340 Jakob Kagel: Awesome. Thanks a lot for your help. With that.
83 00:07:40.720 ⇒ 00:07:42.410 Uttam Kumaran: Cool. So
84 00:07:43.020 ⇒ 00:07:46.045 Uttam Kumaran: that’s a couple of things.
85 00:07:47.572 ⇒ 00:08:03.387 Uttam Kumaran: what else? So this is still open, elementary initial implementation. So, Ryan, I think the is, is this totally complete? I think the only other thing I was gonna ask is, maybe we can create a follow up ticket on making that HTML, like on a live site.
86 00:08:04.086 ⇒ 00:08:05.769 Uttam Kumaran: But is there anything else.
87 00:08:06.090 ⇒ 00:08:14.530 Ryan Luke Daque: Yeah, that should be good. I there’s a Pr open already and just needing review. So basically, what I did there was to
88 00:08:15.870 ⇒ 00:08:25.250 Ryan Luke Daque: like use elementary for source freshness. So it’s like using a normally detection detection for source freshness.
89 00:08:25.330 ⇒ 00:08:27.409 Ryan Luke Daque: But currently I’ve like.
90 00:08:28.200 ⇒ 00:08:34.810 Ryan Luke Daque: I’ve added both the original source freshness that we’re doing in Dbt and the elementary one.
91 00:08:35.525 ⇒ 00:08:36.159 Ryan Luke Daque: Just
92 00:08:36.169 ⇒ 00:08:45.829 Ryan Luke Daque: so. But we can probably decide which one to use once we can see like how it looks like elementary the source precious and normally detection that they have.
93 00:08:46.030 ⇒ 00:08:50.310 Ryan Luke Daque: And see if that works for us. And yeah, so it should
94 00:08:50.350 ⇒ 00:08:56.139 Ryan Luke Daque: work. I did test it out, and for both dev and prod, and it would. It seemed like it worked
95 00:08:56.755 ⇒ 00:08:58.580 Ryan Luke Daque: it did show all the
96 00:08:58.880 ⇒ 00:09:08.189 Ryan Luke Daque: data models that the time spent for for each model. And there’s even one model that was taking so much time, the clavier of events that I I also
97 00:09:08.598 ⇒ 00:09:12.419 Ryan Luke Daque: updated in the same. Pr, just so it will be like, faster.
98 00:09:12.530 ⇒ 00:09:13.470 Ryan Luke Daque: Okay? Awesome.
99 00:09:14.320 ⇒ 00:09:18.170 Ryan Luke Daque: Yeah. And then then currently, it’s gonna it’s going to send the
100 00:09:18.420 ⇒ 00:09:19.460 Ryan Luke Daque: but a
101 00:09:19.650 ⇒ 00:09:22.876 Ryan Luke Daque: HTML in slack at the moment. But yeah,
102 00:09:23.490 ⇒ 00:09:25.489 Ryan Luke Daque: I’ll work, probably
103 00:09:26.383 ⇒ 00:09:30.919 Ryan Luke Daque: work with Augustine on creating an S. 3 bucket, or like S. 3 instance.
104 00:09:31.170 ⇒ 00:09:33.789 Ryan Luke Daque: so we can host it in s. 3.
105 00:09:36.100 ⇒ 00:09:38.940 Agustin: Yeah, I think that’s good idea.
106 00:09:46.580 ⇒ 00:09:54.879 Ryan Luke Daque: And just so, you know. Also, I just added the elementary workflow in the intra day run so that we don’t get spammed by a lot of.
107 00:09:55.840 ⇒ 00:09:56.550 Uttam Kumaran: Oh, nice. Okay.
108 00:09:56.550 ⇒ 00:10:03.719 Ryan Luke Daque: Is it just like for for each Pr and stuff like that? So just it’s just it’s just gonna run in the intra day. One.
109 00:10:03.920 ⇒ 00:10:04.940 Uttam Kumaran: Okay. Okay.
110 00:10:09.220 ⇒ 00:10:15.059 Uttam Kumaran: okay, cool, I think. Yeah, there’s 2 issues that came up. I gotta
111 00:10:16.325 ⇒ 00:10:30.970 Uttam Kumaran: email from pool part saying that there’s some shopify things that are like locked as like pending payments. I’ve worked with them a little bit on like configuring their shopify. So I’m just gonna take a look at
112 00:10:30.990 ⇒ 00:10:36.069 Uttam Kumaran: that. And then, Augustine, I created this ticket on the Primus
113 00:10:36.130 ⇒ 00:10:38.069 Uttam Kumaran: shipping data. So
114 00:10:38.652 ⇒ 00:10:48.169 Uttam Kumaran: Pool parts is moving. One of their shipping providers from Ltl. To Primus, Ltl. Is their freight shipper. They use Ltl. To ship their like large
115 00:10:48.260 ⇒ 00:10:51.573 Uttam Kumaran: pool pumps that are like kind of come on like a flatbed
116 00:10:52.238 ⇒ 00:11:04.421 Uttam Kumaran: to people’s homes. So the kind of the migration that this is gonna require is a little bit of us using the same like rest Api process and Snow Park to call a few Apis.
117 00:11:05.326 ⇒ 00:11:06.300 Uttam Kumaran: I think.
118 00:11:06.840 ⇒ 00:11:10.460 Uttam Kumaran: like the only complication here is they have several
119 00:11:10.520 ⇒ 00:11:17.200 Uttam Kumaran: different Apis that I’m not exactly sure what we need. So this is probably gonna be like a collaboration between
120 00:11:17.220 ⇒ 00:11:23.250 Uttam Kumaran: like Ryan, me, and like Augustine in terms of like, How do we? What is all the data we need?
121 00:11:23.280 ⇒ 00:11:31.214 Uttam Kumaran: So we could specify for Augustine. Like all the columns we need, and then some of these, we may require some of these we may not
122 00:11:33.010 ⇒ 00:11:39.200 Uttam Kumaran: But again, this isn’t like, we kind of have some time to do this, because it’s kind of a larger lift.
123 00:11:39.340 ⇒ 00:11:41.940 Uttam Kumaran: So probably just the next thing up.
124 00:11:45.480 ⇒ 00:11:53.319 Uttam Kumaran: yeah. So I think those are the main stuff. So the marketing weekly report dashboard, I’m just gonna move to review. So that and that’s kind of just like waiting on
125 00:11:53.460 ⇒ 00:12:02.473 Uttam Kumaran: are getting access created the one ticket for a number of ads coming in. So we can schedule that once some of this work gets cleared.
126 00:12:04.283 ⇒ 00:12:05.569 Uttam Kumaran: and then.
127 00:12:06.550 ⇒ 00:12:11.500 Uttam Kumaran: I think, Pat, apart from on the rest of the remaining stuff on pool parts, is
128 00:12:11.880 ⇒ 00:12:12.920 Uttam Kumaran: the
129 00:12:13.580 ⇒ 00:12:15.360 Uttam Kumaran: stuff for
130 00:12:15.600 ⇒ 00:12:16.840 Uttam Kumaran: like, viz.
131 00:12:19.230 ⇒ 00:12:20.450 Uttam Kumaran: Yep, yep.
132 00:12:21.860 ⇒ 00:12:25.909 Uttam Kumaran: probably no update since yesterday, but just a reminder on that.
133 00:12:25.910 ⇒ 00:12:27.660 Patrick Trainer: Yeah, no, not yet.
134 00:12:28.970 ⇒ 00:12:32.339 Uttam Kumaran: And then on the Snowflake side. So
135 00:12:32.620 ⇒ 00:12:35.639 Uttam Kumaran: we talked a little bit about this data share.
136 00:12:36.456 ⇒ 00:12:43.039 Uttam Kumaran: Yesterday, Augustine, I think we could probably just like mark this as what won’t do for now we can come back to it.
137 00:12:44.275 ⇒ 00:12:50.410 Uttam Kumaran: I know we wanted to figure out like what exactly columns we need. And things like that. It’s gonna take quite a bit more time. So
138 00:12:51.257 ⇒ 00:12:55.010 Uttam Kumaran: just gonna mark this as we’ll do for now.
139 00:12:55.790 ⇒ 00:13:00.556 Agustin: Sure. Okay, we will. Let’s pass on that. Then. Yeah, they.
140 00:13:02.210 ⇒ 00:13:05.952 Uttam Kumaran: On the and then the also link side. I know you’re also exploring the
141 00:13:06.720 ⇒ 00:13:09.913 Uttam Kumaran: the snowflake rag. So I’m just gonna create a ticket for that.
142 00:13:11.180 ⇒ 00:13:11.810 Agustin: Yeah.
143 00:13:12.030 ⇒ 00:13:15.052 Agustin: I need the azure account first. But yeah.
144 00:13:34.210 ⇒ 00:13:39.979 Patrick Trainer: Also looks like I added a bunch of arrows and check marks on the screen. I don’t know how to remove them, so.
145 00:13:40.230 ⇒ 00:13:40.910 Uttam Kumaran: Why?
146 00:13:41.950 ⇒ 00:13:45.359 Ryan Luke Daque: Yeah, I know this, I thought, is my my zoom. That was like.
147 00:13:45.980 ⇒ 00:13:50.554 Patrick Trainer: Oh, yeah, no. Oh, okay, yeah. I couldn’t remove that one.
148 00:13:50.970 ⇒ 00:13:51.960 Uttam Kumaran: That’s okay.
149 00:13:54.930 ⇒ 00:13:57.756 Uttam Kumaran: How to derivate. That’s fine. I don’t mind.
150 00:13:58.310 ⇒ 00:14:05.780 Uttam Kumaran: okay, on the Stella side. So we talked to. We had a meeting with all the Stella folks this morning, so
151 00:14:06.413 ⇒ 00:14:11.010 Uttam Kumaran: we’ll do a meeting with Nick on this local Dbt setup tomorrow.
152 00:14:11.574 ⇒ 00:14:15.465 Uttam Kumaran: And and I’m gonna try to meet with him also tomorrow on
153 00:14:15.860 ⇒ 00:14:18.930 Uttam Kumaran: the 5 trend in it. So we can probably try to merge
154 00:14:19.060 ⇒ 00:14:20.579 Uttam Kumaran: those meetings.
155 00:14:22.480 ⇒ 00:14:28.320 Uttam Kumaran: and yeah, I think otherwise. It’s pretty straightforward. All these kind of like are transitioning to Nick.
156 00:14:30.940 ⇒ 00:14:34.249 Uttam Kumaran: I know you’re working on adding Robert to Snowflake, too, but it’s probably not
157 00:14:34.580 ⇒ 00:14:36.790 Uttam Kumaran: a huge thing.
158 00:14:37.317 ⇒ 00:14:41.800 Uttam Kumaran: And then tech tools internal. This is happening right now. So
159 00:14:42.150 ⇒ 00:14:45.519 Uttam Kumaran: Pat and Ryan are in interviews today and tomorrow
160 00:14:45.640 ⇒ 00:14:50.679 Uttam Kumaran: again. Thank you for taking the time to do that. So excited to kind of see this
161 00:14:51.010 ⇒ 00:14:57.152 Uttam Kumaran: reach an ending hopefully this end of the week. And we can kind of start ramping this person.
162 00:14:57.955 ⇒ 00:15:00.959 Uttam Kumaran: That would be an amazing help for me.
163 00:15:02.380 ⇒ 00:15:08.030 Uttam Kumaran: cool. So I think the only other stuff I guess, Jacob, you’re working on like refunds
164 00:15:08.523 ⇒ 00:15:13.046 Uttam Kumaran: and then I’m gonna I’m gonna loop you in on an email with our
165 00:15:13.530 ⇒ 00:15:15.522 Uttam Kumaran: the company that’s doing
166 00:15:16.880 ⇒ 00:15:24.110 Uttam Kumaran: I’m gonna loop you on a 2 emails, actually one, the company that’s like we’re using for Ab, testing that we’ve like started working with
167 00:15:24.600 ⇒ 00:15:28.020 Uttam Kumaran: they keep hounding me to like, try to start the test.
168 00:15:28.150 ⇒ 00:15:55.660 Uttam Kumaran: And I’m like, Yeah, we’re doing like other stuff right now. But I’ll just loop you in. And the second email is, I have a friend of mine who is he has a company that they do predictive revenue analytics. It’s it’s wild pat and they’re looking for like prospective shopify clients to offer their predict analytics for free in order to help them build their shopify connector or something.
169 00:15:56.031 ⇒ 00:15:57.838 Uttam Kumaran: I basically was like, look
170 00:15:58.620 ⇒ 00:16:01.079 Uttam Kumaran: I’m gonna kind of pass you to
171 00:16:01.200 ⇒ 00:16:12.970 Uttam Kumaran: Jacob because he he’s the one that’s gonna kind of own like Ltv, and like revenue prediction. So I’m just gonna loop you in on email. That’s probably like the lowest priority thing.
172 00:16:13.295 ⇒ 00:16:23.279 Uttam Kumaran: Because, like, I don’t want like, we’re not, we don’t. We can use them or not. He’s just a friend of mine thought I would do him a favor. Their their predictive analytics is really really good.
173 00:16:23.699 ⇒ 00:16:26.209 Uttam Kumaran: I just don’t know whether we have enough data
174 00:16:26.340 ⇒ 00:16:27.600 Uttam Kumaran: honestly
175 00:16:27.670 ⇒ 00:16:29.249 Uttam Kumaran: for it to like.
176 00:16:30.300 ⇒ 00:16:39.499 Jakob Kagel: Right? That’s what I was met, too. But yeah, no, definitely. Let’s yeah. I mean, I definitely boot me in. And yeah, we can just start to get the ball rolling there.
177 00:16:39.720 ⇒ 00:16:40.300 Uttam Kumaran: Yeah.
178 00:16:41.754 ⇒ 00:16:43.656 Uttam Kumaran: I think that’s
179 00:16:45.150 ⇒ 00:16:55.439 Uttam Kumaran: that’s it. Otherwise. So I mean, we have a ton of stuff for pool parts, I think, going on in parallel. I guess, Ryan. Maybe like, let me know what you’re planning on
180 00:16:55.860 ⇒ 00:16:59.280 Uttam Kumaran: taking next, whether it’s the asset link stuff or
181 00:16:59.830 ⇒ 00:17:03.680 Uttam Kumaran: the pool part stuff, but I’m glad we’re kind of reaching an end for elementary. So.
182 00:17:05.560 ⇒ 00:17:06.329 Ryan Luke Daque: Yeah,
183 00:17:10.430 ⇒ 00:17:11.610 Ryan Luke Daque: I guess we can.
184 00:17:11.790 ⇒ 00:17:19.120 Ryan Luke Daque: I can. I can start with the pool part stuff because we do. We still don’t have the theme, for
185 00:17:19.380 ⇒ 00:17:24.649 Ryan Luke Daque: as a link right? The the that they wanted. So we can. I can work on the
186 00:17:25.200 ⇒ 00:17:27.689 Ryan Luke Daque: full pipe stuff that we have in the background.
187 00:17:28.349 ⇒ 00:17:32.769 Uttam Kumaran: Yeah, I think the big things is this one would be really great.
188 00:17:34.261 ⇒ 00:17:41.429 Uttam Kumaran: This is that we just put this in today, which is bringing in the number of ads per week for kids. Report.
189 00:17:41.799 ⇒ 00:17:44.949 Uttam Kumaran: I think this is just a count distinct. Add Id.
190 00:17:46.069 ⇒ 00:17:47.419 Uttam Kumaran: where a cost
191 00:17:47.779 ⇒ 00:17:49.779 Uttam Kumaran: is greater than 0.
192 00:17:50.469 ⇒ 00:17:54.759 Uttam Kumaran: Basically, we wanna we want wanna put a cost per, add
193 00:17:55.199 ⇒ 00:17:56.669 Uttam Kumaran: Patrick again.
194 00:17:58.439 ⇒ 00:17:59.044 Uttam Kumaran: pink.
195 00:17:59.650 ⇒ 00:18:00.910 Ryan Luke Daque: And that’s per week.
196 00:18:01.430 ⇒ 00:18:02.270 Uttam Kumaran: Per week.
197 00:18:03.170 ⇒ 00:18:05.940 Ryan Luke Daque: Alright cause we were already doing per week. And
198 00:18:06.100 ⇒ 00:18:07.910 Ryan Luke Daque: and can she be clear upon? Yeah.
199 00:18:08.120 ⇒ 00:18:09.040 Ryan Luke Daque: got you.
200 00:18:10.990 ⇒ 00:18:14.598 Uttam Kumaran: So I think that would be great. And then
201 00:18:17.440 ⇒ 00:18:20.747 Uttam Kumaran: I think the only other stuff is
202 00:18:22.670 ⇒ 00:18:24.809 Uttam Kumaran: yeah, that might be the main
203 00:18:25.550 ⇒ 00:18:32.550 Uttam Kumaran: thing for pool parts right now, and I’m gonna go through, and I’ll like reorganize some of these, because I know there’s a lot of stuff in the backlog.
204 00:18:34.446 ⇒ 00:18:38.431 Uttam Kumaran: Honestly, the shipments table could be really great next. But
205 00:18:40.480 ⇒ 00:18:41.609 Uttam Kumaran: let’s see. Okay.
206 00:18:43.610 ⇒ 00:18:44.460 Uttam Kumaran: okay.
207 00:18:44.850 ⇒ 00:18:47.570 Uttam Kumaran: cool anything
208 00:18:48.060 ⇒ 00:18:49.160 Uttam Kumaran: else.
209 00:18:52.220 ⇒ 00:18:59.030 Agustin: No, I I think I will travel with my card again, and I will let you know a bit later. If that’s okay.
210 00:18:59.290 ⇒ 00:19:04.009 Uttam Kumaran: Okay, yeah, just slack me. I can add there’s another process to add you
211 00:19:04.385 ⇒ 00:19:15.249 Uttam Kumaran: just let me know what happens. I I I’m honestly fine with giving you the our card. I just like, though it’s just like a lot of different accounts, and like the azure setup is really really complicated.
212 00:19:15.560 ⇒ 00:19:19.917 Uttam Kumaran: like to do roles and everything. And I’m just like, don’t have time today. So
213 00:19:20.758 ⇒ 00:19:23.859 Uttam Kumaran: but do you need an open Ike? Or what do you need.
214 00:19:24.980 ⇒ 00:19:31.400 Agustin: Yeah, I need the open AI account and the open AI service inside azure.
215 00:19:31.660 ⇒ 00:19:33.459 Uttam Kumaran: Oh, okay. Okay.
216 00:19:34.470 ⇒ 00:19:36.020 Uttam Kumaran: Okay. Okay. Okay.
217 00:19:36.020 ⇒ 00:19:36.610 Agustin: Health.
218 00:19:36.780 ⇒ 00:19:39.310 Uttam Kumaran: Yeah, just just lock me. Let’s work on it.
219 00:19:42.859 ⇒ 00:19:49.319 Uttam Kumaran: And then I don’t know. Jacob. You want to stay on for a sec. I can help help take a look at that the Dbt issue.
220 00:19:50.500 ⇒ 00:19:52.750 Jakob Kagel: Yeah, sure, that sounds good.
221 00:19:53.823 ⇒ 00:19:54.350 Jakob Kagel: Yeah.
222 00:19:54.630 ⇒ 00:19:55.230 Uttam Kumaran: Alright!
223 00:19:55.500 ⇒ 00:19:56.640 Uttam Kumaran: Thanks everyone.
224 00:19:57.630 ⇒ 00:19:58.917 Ryan Luke Daque: See you. Bye, bye.
225 00:20:01.460 ⇒ 00:20:05.569 Jakob Kagel: Oh, yeah. Just restarted
226 00:20:07.290 ⇒ 00:20:09.160 Jakob Kagel: my Vs code.
227 00:20:09.270 ⇒ 00:20:10.990 Jakob Kagel: and it looks like
228 00:20:11.760 ⇒ 00:20:15.224 Jakob Kagel: the repository like disappeared.
229 00:20:17.750 ⇒ 00:20:19.290 Jakob Kagel: me see?
230 00:20:19.728 ⇒ 00:20:21.420 Jakob Kagel: Here. I’ll share my screen.
231 00:20:24.590 ⇒ 00:20:29.240 Jakob Kagel: But like I don’t think this should happen right like you can see my screen.
232 00:20:29.240 ⇒ 00:20:29.940 Uttam Kumaran: Yes.
233 00:20:30.520 ⇒ 00:20:31.440 Jakob Kagel: Okay.
234 00:20:32.230 ⇒ 00:20:36.854 Jakob Kagel: so right? So like, now, my whole like folder structure is gone back.
235 00:20:37.210 ⇒ 00:20:39.120 Uttam Kumaran: Digital. You could just click on that.
236 00:20:39.300 ⇒ 00:20:41.300 Jakob Kagel: Right, and then it’ll bring it back up.
237 00:20:42.380 ⇒ 00:20:43.300 Jakob Kagel: Okay.
238 00:20:44.680 ⇒ 00:20:46.950 Jakob Kagel: hmm, okay.
239 00:20:49.350 ⇒ 00:20:52.259 Jakob Kagel: So I didn’t even have these ones in. These
240 00:20:52.280 ⇒ 00:20:53.889 Jakob Kagel: can get deleted.
241 00:20:54.570 ⇒ 00:20:57.979 Jakob Kagel: But basically, like, here, I’ll show you what it’s saying
242 00:20:58.410 ⇒ 00:20:59.360 Jakob Kagel: like.
243 00:21:00.950 ⇒ 00:21:05.420 Jakob Kagel: it’s like saying that like catalog Dbt does not exist.
244 00:21:09.140 ⇒ 00:21:10.450 Jakob Kagel: So
245 00:21:10.750 ⇒ 00:21:15.049 Jakob Kagel: I went. And like, I tried like to commit like the changes right?
246 00:21:15.260 ⇒ 00:21:16.320 Jakob Kagel: Yeah.
247 00:21:17.660 ⇒ 00:21:21.178 Jakob Kagel: And so at first it was showing them as like
248 00:21:22.090 ⇒ 00:21:25.220 Jakob Kagel: It was like you. It was like untracked
249 00:21:27.910 ⇒ 00:21:32.880 Jakob Kagel: But then, now it’s showing them as like a which says like index, added
250 00:21:37.030 ⇒ 00:21:41.790 Uttam Kumaran: Yeah, I found that like using Github desktop might be easier.
251 00:21:41.790 ⇒ 00:21:45.100 Jakob Kagel: Okay, I have desktop. Yeah.
252 00:21:45.480 ⇒ 00:21:48.798 Uttam Kumaran: Cause. It’s literally just like 2 buttons, usually to commit.
253 00:21:50.282 ⇒ 00:21:54.940 Uttam Kumaran: So you wanna also be in a you wanna also be in a branch
254 00:21:56.050 ⇒ 00:21:57.200 Uttam Kumaran: right up.
255 00:21:58.010 ⇒ 00:22:02.589 Uttam Kumaran: You could even go ahead and like. So the one thing I can show you is if you go to Github.
256 00:22:03.240 ⇒ 00:22:08.919 Uttam Kumaran: If you just go to github.com, and you go to our our project. I’ll show you how to create a branch for this task.
257 00:22:09.300 ⇒ 00:22:10.210 Jakob Kagel: Okay.
258 00:22:10.480 ⇒ 00:22:11.810 Jakob Kagel: Sounds. Good.
259 00:22:19.520 ⇒ 00:22:20.790 Jakob Kagel: okay.
260 00:22:21.400 ⇒ 00:22:23.439 Uttam Kumaran: Let’s see if you go to. Yep.
261 00:22:24.860 ⇒ 00:22:27.080 Jakob Kagel: And then, yeah, I can just do.
262 00:22:27.080 ⇒ 00:22:32.462 Uttam Kumaran: And if you go to like the issues that like, if you go to issues, and if you go to the issue that you’re working on
263 00:22:34.475 ⇒ 00:22:37.720 Uttam Kumaran: you could probably go to go to assignee.
264 00:22:41.810 ⇒ 00:22:42.990 Jakob Kagel: Yeah.
265 00:22:44.860 ⇒ 00:22:46.160 Uttam Kumaran: And then,
266 00:22:47.820 ⇒ 00:22:49.860 Uttam Kumaran: it’s probably the
267 00:22:50.240 ⇒ 00:22:52.319 Uttam Kumaran: yeah. It’s probably that one.
268 00:22:52.800 ⇒ 00:22:55.680 Uttam Kumaran: So on the bottom. Right?
269 00:22:57.030 ⇒ 00:22:58.680 Uttam Kumaran: So actually, is it that one?
270 00:23:08.180 ⇒ 00:23:11.869 Uttam Kumaran: yeah, okay, it’s the one that says, like, what is the overall?
271 00:23:14.760 ⇒ 00:23:21.499 Uttam Kumaran: Okay, this is this is like, Yeah, if you want to go the other one, it says, like, what is the overall rate of it’s like a big question, I guess. Yeah.
272 00:23:22.080 ⇒ 00:23:22.840 Jakob Kagel: Oh, this one! Here.
273 00:23:23.030 ⇒ 00:23:28.130 Uttam Kumaran: Yeah. So on the bottom right of the screen. Scroll down.
274 00:23:28.130 ⇒ 00:23:28.980 Jakob Kagel: Yeah, it’s like.
275 00:23:28.980 ⇒ 00:23:30.190 Uttam Kumaran: Create a branch.
276 00:23:30.930 ⇒ 00:23:34.359 Uttam Kumaran: So you go ahead and create that branch and say, open branch with github, desktop.
277 00:23:38.736 ⇒ 00:23:40.030 Uttam Kumaran: and open.
278 00:23:41.970 ⇒ 00:23:44.220 Uttam Kumaran: and there it is. So
279 00:23:44.350 ⇒ 00:23:46.410 Uttam Kumaran: this is like your.
280 00:23:46.460 ⇒ 00:23:50.000 Uttam Kumaran: this is like a branch. So now, if you hit preview pull request.
281 00:23:52.330 ⇒ 00:23:53.220 Uttam Kumaran: there’s
282 00:23:53.470 ⇒ 00:23:54.709 Uttam Kumaran: actually, if you hit.
283 00:23:56.340 ⇒ 00:23:59.390 Uttam Kumaran: okay, these are all like new ones
284 00:23:59.570 ⇒ 00:24:01.030 Uttam Kumaran: hit cancel.
285 00:24:01.870 ⇒ 00:24:09.940 Uttam Kumaran: and then if you just go to the top like top left of your screen, where it says repository or branch, you can hit, pull from Main
286 00:24:10.090 ⇒ 00:24:12.329 Uttam Kumaran: all the way in the top of like your monitor.
287 00:24:16.010 ⇒ 00:24:19.619 Uttam Kumaran: Like where it says, Get up, desktop the apple symbol, and, like the Github.
288 00:24:20.180 ⇒ 00:24:22.300 Jakob Kagel: Github desktop. Oh, up here.
289 00:24:22.300 ⇒ 00:24:23.189 Uttam Kumaran: On the left.
290 00:24:23.190 ⇒ 00:24:26.109 Jakob Kagel: On the left, oh, right, right, right branch, and then.
291 00:24:26.110 ⇒ 00:24:28.130 Uttam Kumaran: If you just do update for main.
292 00:24:29.720 ⇒ 00:24:30.060 Jakob Kagel: Day, from.
293 00:24:30.060 ⇒ 00:24:34.260 Uttam Kumaran: You’re gonna get, like, basically all the like most recent
294 00:24:34.290 ⇒ 00:24:37.060 Uttam Kumaran: code. And then if you hit preview, pull request
295 00:24:37.620 ⇒ 00:24:41.199 Uttam Kumaran: and you can just do create pull request.
296 00:24:44.565 ⇒ 00:24:48.050 Uttam Kumaran: It’s going to create one, I’m pretty sure.
297 00:24:48.050 ⇒ 00:24:51.399 Jakob Kagel: Give me this. I mean, it said. There’s nothing to compare.
298 00:24:51.700 ⇒ 00:24:56.121 Uttam Kumaran: Yeah. So now it’s like, one thing is like, Where is that?
299 00:24:56.520 ⇒ 00:25:00.417 Uttam Kumaran: I don’t know what repository you’re making changes in.
300 00:25:00.850 ⇒ 00:25:03.849 Jakob Kagel: Pool parts one. It should just be pool parts to go.
301 00:25:04.240 ⇒ 00:25:06.620 Uttam Kumaran: So if you go back to your Vs code.
302 00:25:07.190 ⇒ 00:25:08.040 Jakob Kagel: Yeah.
303 00:25:09.410 ⇒ 00:25:10.870 Uttam Kumaran: Okay?
304 00:25:15.500 ⇒ 00:25:19.160 Uttam Kumaran: so these are all staged changes.
305 00:25:26.740 ⇒ 00:25:32.860 Uttam Kumaran: can I? Can I click around for a sec? How do I do? How do I do that?
306 00:25:33.201 ⇒ 00:25:38.319 Jakob Kagel: It should be a thing on zoom, that’s like, take control of the screen here.