Meeting Title: Weekly-Sprint-Review Date: 2024-01-22 Meeting participants: Ryan Luke Daque, Uttam Kumaran
WEBVTT
1 00:10:20.550 ⇒ 00:10:21.530 Uttam Kumaran: Hey, Ryan?
2 00:10:21.880 ⇒ 00:10:23.020 Ryan Luke Daque: Hello, Poole.
3 00:10:23.230 ⇒ 00:10:24.260 Uttam Kumaran: hey?
4 00:10:24.480 ⇒ 00:10:25.600 Ryan Luke Daque: How’s it going?
5 00:10:25.710 ⇒ 00:10:29.610 Uttam Kumaran: Good! How are you doing? Good as well? How was your weekend
6 00:10:30.420 ⇒ 00:10:35.229 Uttam Kumaran: weekend was good? Yeah, not much. Just it’s
7 00:10:35.310 ⇒ 00:10:38.279 Uttam Kumaran: I don’t know, do you? Are you you heard of like
8 00:10:38.290 ⇒ 00:10:45.330 Uttam Kumaran: American football? And it’s like playoffs this
9 00:10:45.490 ⇒ 00:10:50.940 Uttam Kumaran: this month. So everybody’s watching a lot of football. I see.
10 00:10:51.720 ⇒ 00:10:56.760 Ryan Luke Daque: I feel like they’re they’re getting bigger internationally. But I don’t know if it’s even like a thing
11 00:10:57.300 ⇒ 00:10:58.970 Uttam Kumaran: in India, nobody knows.
12 00:10:59.170 ⇒ 00:11:04.440 Ryan Luke Daque: Yeah, here it’s not as it’s I don’t know. Nobody plays that here, I guess.
13 00:11:04.990 ⇒ 00:11:08.170 Uttam Kumaran: What are they? Is it mainly like soccer?
14 00:11:08.700 ⇒ 00:11:28.610 Ryan Luke Daque: like basketball. They like playing basketball here in the Philippines, even though they’re not like Filipinos or not. Naturally tall guys. But basketball’s like the number one sport that’s crazy. Number one. Yeah, it’s weird. But
15 00:11:28.950 ⇒ 00:11:32.889 Ryan Luke Daque: yeah, Mba, yeah. Nba, mostly.
16 00:11:33.740 ⇒ 00:11:35.150 Oh, no way
17 00:11:35.190 ⇒ 00:11:55.829 Ryan Luke Daque: is there like one team that everybody or one person that everybody likes. Well, I guess the the main ones like Liberal and James and Steph Curry, and like even even new guys like Luka. And I don’t know if you follow basketball and be, I do. Yeah, I’m a I’m a big lakers fan. Oh, yeah, cool. I grew up
18 00:11:55.840 ⇒ 00:12:08.469 Ryan Luke Daque: I grew up like a huge Kobe fan. Nice. Yeah, I grew up. I guess I’m I’m a lot older than you. I guess this I grew up watching June. Mj, that’s crazy.
19 00:12:08.560 ⇒ 00:12:16.400 Uttam Kumaran: That’s awesome. I wish I my dad, you know he, my dad, grew up in India, and he would tell me that
20 00:12:17.010 ⇒ 00:12:20.200 Uttam Kumaran: Growing up, he would watch. He would
21 00:12:21.090 ⇒ 00:12:28.810 Uttam Kumaran: read the Hindu Times, and then follow Mj. And like just in a newspaper.
22 00:12:28.850 ⇒ 00:12:34.800 Uttam Kumaran: you know, and I thought that was crazy. II wish I had a chance like, Kobe was like, my Mj, you know.
23 00:12:35.630 ⇒ 00:12:36.630 Ryan Luke Daque: Yeah, like.
24 00:12:36.880 ⇒ 00:12:47.109 Ryan Luke Daque: Kobe’s prime was like, what when you were in high school or something. College. Yeah, it was like, well, I mean again, they won in like early. They had the 3, Pete. And then they yeah, they won again.
25 00:12:47.230 ⇒ 00:12:48.570 Ryan Luke Daque: Yeah.
26 00:12:49.000 ⇒ 00:12:56.470 Uttam Kumaran: But like, I’ve I’ve watched like a lot. I’ve rewatched so many. I watch every documentary like, yeah.
27 00:12:56.860 ⇒ 00:13:01.639 Ryan Luke Daque: that’s it’s really big here in the Philippines basketball. But yeah.
28 00:13:01.900 ⇒ 00:13:02.560 Ryan Luke Daque: it
29 00:13:07.100 ⇒ 00:13:08.540 Uttam Kumaran: cool? Yeah.
30 00:13:08.560 ⇒ 00:13:10.709 Uttam Kumaran: yeah. How’s the day been going so far?
31 00:13:10.840 ⇒ 00:13:15.610 Ryan Luke Daque: Yeah, it’s been. It’s been great last week. It was also like a a big.
32 00:13:15.630 ⇒ 00:13:22.570 Ryan Luke Daque: It was this this huge festival last weekend here in the city? I mean. So
33 00:13:22.630 ⇒ 00:13:28.680 Ryan Luke Daque: yeah, it’s pretty. very. It’s it’s very. It was very festive. The weekend, basically
34 00:13:28.880 ⇒ 00:13:30.340 Uttam Kumaran: oh, nice. Okay.
35 00:13:31.470 ⇒ 00:13:32.200 Ryan Luke Daque: yeah.
36 00:13:33.660 ⇒ 00:13:37.070 Ryan Luke Daque: I did. I did watch your Zoom Meeting with Ben.
37 00:13:37.110 ⇒ 00:13:43.429 Ryan Luke Daque: Oh, yeah, what did you think? I’m really happy? Yeah, it’s cool. Yeah, it looks like he, he! He! Really.
38 00:13:44.510 ⇒ 00:13:51.840 Ryan Luke Daque: Well, there’s still lots of things to do, of course, like updates to do. But yeah, I’m I’m glad, like he liked it.
39 00:13:51.890 ⇒ 00:14:02.080 Ryan Luke Daque: Like most of like, it cannot. The dashboard can answer like questions that they would like, maybe the basically data that were visible to them before.
40 00:14:02.290 ⇒ 00:14:06.040 Ryan Luke Daque: Yeah. So it’s gonna be able to answer. If
41 00:14:06.980 ⇒ 00:14:23.110 Ryan Luke Daque: you know questions that they wanted to know, like how to drive their business and stuff like that improve profitability and stuff like that. So yeah, it’s cool. No, that’s awesome. I I’m really happy to hear that you. I was just gonna send. I you know I didn’t know if you had time. But yeah, that’s awesome. I will.
42 00:14:23.220 ⇒ 00:14:38.889 Uttam Kumaran: you know I I’ll I’ll maybe even send you the one from the previous week. Because, yeah, that one, this one it was just me and Ben, and it was a lot quicker. The last one was like an hour or 2, and me and Dan Dan. Dan is the CEO of the company.
43 00:14:39.020 ⇒ 00:15:00.119 Uttam Kumaran: And we really went through a lot of really detailed things. We’ll send it to you also, and you could maybe watch it in background. But yeah, I’m I’m I sent a long email to them kind of outlining some changes. We’re gonna make but I think this week I want us to start working on some data around marketing.
44 00:15:00.370 ⇒ 00:15:15.069 Uttam Kumaran: So kind of 2 things. One, I want to close out any remaining tickets. There’s a couple of things I’m still blocked on 5 train with, like the refunds but I think we’re gonna move forward and
45 00:15:15.450 ⇒ 00:15:25.610 Uttam Kumaran: try to work on some things in on marketing. Primarily, we want to get an understanding of
46 00:15:26.120 ⇒ 00:15:35.179 Uttam Kumaran: all the sources that are driving customers to the platform. And this is gonna be primarily shopify because
47 00:15:35.260 ⇒ 00:15:42.990 Uttam Kumaran: we can’t really get analytics. A ton of analytics from Amazon at the moment. So
48 00:15:43.270 ⇒ 00:15:52.060 Uttam Kumaran: there is one table, and I will just let me just even like, look where it is.
49 00:15:53.230 ⇒ 00:16:02.690 Uttam Kumaran: There’s a table we get from from 5 train from shopify called
50 00:16:04.400 ⇒ 00:16:14.270 Uttam Kumaran: I think it’s like, customer. Yeah, customer visit. I think, is what it’s called
51 00:16:16.780 ⇒ 00:16:21.369 Ryan Luke Daque: occupied. Right?
52 00:16:23.850 ⇒ 00:16:26.640 Uttam Kumaran: Yeah, it’s just outlines where people came from.
53 00:16:26.850 ⇒ 00:16:34.079 Ryan Luke Daque: And so we’re gonna work on building like a little bit of an attribution model to understand where the customers are coming from.
54 00:16:34.210 ⇒ 00:16:41.259 Uttam Kumaran: and then I also want to understand where the money is being spent. so that we already have right. We have where the money is being spent.
55 00:16:41.300 ⇒ 00:16:49.630 Uttam Kumaran: And then the next thing is to figure out how that’s leading to customer sales. Okay? And so this customer visit
56 00:16:50.720 ⇒ 00:16:56.450 Uttam Kumaran: table and a lot of the customers table is what I want to really focus on
57 00:16:57.170 ⇒ 00:17:07.140 Uttam Kumaran: and so let me just pull up the projects.
58 00:17:12.710 ⇒ 00:17:14.010 Uttam Kumaran: So
59 00:17:14.349 ⇒ 00:17:21.400 Uttam Kumaran: that’s this ticket. So create a first customer attribution table using shopify data. So I’m just gonna add some notes here.
60 00:17:21.480 ⇒ 00:17:24.299 Uttam Kumaran: I’m gonna say, take a look.
61 00:17:25.410 ⇒ 00:17:29.080 Uttam Kumaran: This table called customer visit
62 00:17:33.710 ⇒ 00:17:38.530 Uttam Kumaran: fine. I also don’t know whether there’s out there shopify
63 00:17:48.460 ⇒ 00:17:55.290 Uttam Kumaran: like 5 train has some DBT. Transformed models, but I don’t know whether there’s anything around.
64 00:17:55.880 ⇒ 00:18:00.769 Uttam Kumaran: There’s customer, yeah, customer email cohorts.
65 00:18:02.690 ⇒ 00:18:06.340 Uttam Kumaran: Yeah, this is none of this is around like,
66 00:18:09.390 ⇒ 00:18:11.680 Uttam Kumaran: yeah, none of this is around
67 00:18:15.120 ⇒ 00:18:17.020 Uttam Kumaran: marketing. But
68 00:18:17.120 ⇒ 00:18:30.200 Uttam Kumaran: so we’ll probably have to. So take a look at customer visit table. Second thing is, we can create. So one, I wanna one thing I wanna do is create shopify
69 00:18:30.440 ⇒ 00:18:45.780 Uttam Kumaran: customers table. So this should have all the customer info as well as to all the customer. Info. In one place
70 00:18:47.870 ⇒ 00:18:52.389 Uttam Kumaran: it says. first order.
71 00:18:53.100 ⇒ 00:18:55.780 Uttam Kumaran: state location.
72 00:18:56.100 ⇒ 00:18:58.110 Uttam Kumaran: recent order.
73 00:18:59.460 ⇒ 00:19:02.770 Uttam Kumaran: total sales all that information. Okay.
74 00:19:03.090 ⇒ 00:19:06.149 Uttam Kumaran: the second thing is, we wanna create
75 00:19:07.530 ⇒ 00:19:14.580 Uttam Kumaran: we want to create an adaptation of like that customer visit. So we can say, Shopify
76 00:19:15.460 ⇒ 00:19:17.720 Uttam Kumaran: Like visits, for now
77 00:19:20.290 ⇒ 00:19:25.650 Uttam Kumaran: builds on customer visits and 3, we want to create.
78 00:19:26.160 ⇒ 00:19:27.970 Uttam Kumaran: shopify
79 00:19:29.240 ⇒ 00:19:31.350 Customer
80 00:19:32.040 ⇒ 00:19:33.410 Uttam Kumaran: attribution.
81 00:19:35.390 ⇒ 00:19:36.920 Uttam Kumaran: This is going to be
82 00:19:38.190 ⇒ 00:19:41.000 Uttam Kumaran: on a
83 00:19:41.470 ⇒ 00:19:43.440 Uttam Kumaran: daily basis.
84 00:19:45.410 ⇒ 00:19:58.629 Uttam Kumaran: which? So it’s gonna look at customers. sales, orders. each of the major marketing channels.
85 00:19:59.420 ⇒ 00:20:00.840 Uttam Kumaran: Google
86 00:20:01.580 ⇒ 00:20:07.469 Uttam Kumaran: right now
87 00:20:10.520 ⇒ 00:20:12.920 Uttam Kumaran: and then this we’re gonna have to.
88 00:20:13.100 ⇒ 00:20:17.880 Uttam Kumaran: So the the main goal. I’m just gonna put up here.
89 00:20:21.310 ⇒ 00:20:30.310 Uttam Kumaran: We want to look at all of the money spent in
90 00:20:31.150 ⇒ 00:20:33.430 Uttam Kumaran: one day across
91 00:20:33.880 ⇒ 00:20:46.040 Uttam Kumaran: each marketing channel. all of the customers acquired, and all of the sales from those customers
92 00:20:46.870 ⇒ 00:20:50.489 Uttam Kumaran: giving us an even outlook
93 00:20:51.380 ⇒ 00:20:57.630 Uttam Kumaran: on marketing efficiency by chain. Does that make sense? Roughly?
94 00:20:58.090 ⇒ 00:21:05.030 Ryan Luke Daque: Yeah, I think so. I’m also looking at the shopify package that 5 grand has. Maybe we can.
95 00:21:05.810 ⇒ 00:21:10.940 Ryan Luke Daque: You can try utilizing that. Maybe. Yeah. So I actually do have that running.
96 00:21:11.700 ⇒ 00:21:18.730 Uttam Kumaran: I think. Yeah, if you look at shopify, underscore shopify
97 00:21:19.120 ⇒ 00:21:23.900 Ryan Luke Daque: in the 5 Tran gonna see all those.
98 00:21:25.480 ⇒ 00:21:28.709 Uttam Kumaran: So yeah, you’re right. Maybe we can take the shopify customers.
99 00:21:30.000 ⇒ 00:21:32.140 Ryan Luke Daque: Gotcha. They already made.
100 00:21:33.040 ⇒ 00:21:38.510 Ryan Luke Daque: Yeah, we’ll see what we can add to that if exactly, exactly, you’re spot on. So
101 00:21:38.680 ⇒ 00:21:41.389 Uttam Kumaran: I’m gonna just put a screenshot of this in there.
102 00:21:47.920 ⇒ 00:21:57.370 Ryan Luke Daque: This ideally, this should also have like sharpify daily shop, which is. I guess, a daily view of
103 00:21:58.430 ⇒ 00:22:01.930 Ryan Luke Daque: activity like
104 00:22:02.070 ⇒ 00:22:05.720 Uttam Kumaran: customers, matrix about customers, orders and stuff.
105 00:22:07.500 ⇒ 00:22:08.350 Ryan Luke Daque: Yeah.
106 00:22:09.580 ⇒ 00:22:12.850 Uttam Kumaran: take a look at that. Okay, great.
107 00:22:16.390 ⇒ 00:22:19.520 Uttam Kumaran: So that’s I would say.
108 00:22:19.800 ⇒ 00:22:23.960 Uttam Kumaran: that’s like the most important one that I want to take a look at.
109 00:22:23.990 ⇒ 00:22:27.100 Ryan Luke Daque: I think that’s gonna take.
110 00:22:27.770 ⇒ 00:22:33.940 Uttam Kumaran: you know, quite a bit of time this week. Wanna give you the ability to just focus on that.
111 00:22:34.350 ⇒ 00:22:44.530 Uttam Kumaran: The only other thing that’s smaller and we can discuss is, I want to create an estimated shipping cost field.
112 00:22:44.600 ⇒ 00:22:49.940 Uttam Kumaran: So if you noticed in that call, you know, we have a conversation. Yeah, so
113 00:22:50.730 ⇒ 00:22:57.349 Uttam Kumaran: pretty much. I think we can get a decent understanding of, like what the estimated shipping cost is
114 00:22:57.600 ⇒ 00:23:05.440 Uttam Kumaran: just through some basic averages based on the zone wait, product type. And
115 00:23:06.080 ⇒ 00:23:13.500 Uttam Kumaran: and so I just want to be able to provide them something within, like 10 of like what our shipping cost is going to be for the day.
116 00:23:13.970 ⇒ 00:23:16.539 Uttam Kumaran: And then we can get smarter over time.
117 00:23:17.040 ⇒ 00:23:18.440 Ryan Luke Daque: Yeah, sounds good.
118 00:23:19.090 ⇒ 00:23:28.890 Uttam Kumaran: So I actually don’t think this is like that heavy. But the the I would say, these are the if you’re if you’re comfortable, taking these 2 on, these are the primary 2. Okay.
119 00:23:29.040 ⇒ 00:23:30.199 Ryan Luke Daque: I can do that.
120 00:23:32.460 ⇒ 00:23:37.699 Ryan Luke Daque: Just a quick question about the the shopify underscore shopify that you
121 00:23:38.120 ⇒ 00:23:48.269 Ryan Luke Daque: created. This is coming from 500 itself. Right? You did the transformation. I’ll even just show you where to kind of see that. Yeah.
122 00:23:52.370 ⇒ 00:23:59.269 Uttam Kumaran: So on one hand, it’s I like it because, you know, it runs. It runs directly
123 00:24:00.070 ⇒ 00:24:09.649 Uttam Kumaran: when the shop of when the 5 chain models run on the other side. You can’t really modify or like get a really alerting or anything on these. So.
124 00:24:10.170 ⇒ 00:24:17.879 Uttam Kumaran: But they all. They’re all right here. So you go shopify transformations, and you go here and you can take a look at the schedule. And then.
125 00:24:19.210 ⇒ 00:24:23.620 Ryan Luke Daque: oh, I guess we could run tests and stuff, too. I don’t know. Yeah.
126 00:24:23.670 ⇒ 00:24:27.980 Ryan Luke Daque: we can. We can make it run in Bbt instead.
127 00:24:28.850 ⇒ 00:24:36.220 Uttam Kumaran: Up to you, I mean, like, I don’t know. I don’t know what’s better, because, yeah, I don’t know what’s better.
128 00:24:36.400 ⇒ 00:24:39.830 Ryan Luke Daque: Let’s see. Yeah, let’s see. Cause here
129 00:24:40.690 ⇒ 00:24:44.650 Ryan Luke Daque: I think that’s not running at tests right now. I guess cause it wasn’t.
130 00:24:44.790 ⇒ 00:24:46.829 Ryan Luke Daque: it was unbaked or something.
131 00:24:47.060 ⇒ 00:24:47.970 Uttam Kumaran: Yeah.
132 00:24:49.130 ⇒ 00:25:01.810 Ryan Luke Daque: okay, I’ll take a look. I’ll just do some research. This even has like customer cohorts, which is cool. If they have a ton of really good stuff. So let’s use as much as we can.
133 00:25:02.100 ⇒ 00:25:04.770 Uttam Kumaran: Some of it hasn’t been updated in a while.
134 00:25:04.790 ⇒ 00:25:09.109 Uttam Kumaran: But the logic is all here.
135 00:25:09.260 ⇒ 00:25:12.609 Uttam Kumaran: I’m gonna just send. I’m gonna put this in the ticket.
136 00:25:12.980 ⇒ 00:25:13.930 Ryan Luke Daque: Okay.
137 00:25:18.570 ⇒ 00:25:24.180 Uttam Kumaran: So let’s see how much of that we can use. I don’t know if there’s any other.
138 00:25:28.020 ⇒ 00:25:31.570 Uttam Kumaran: I think that’s the only like package.
139 00:25:34.650 ⇒ 00:25:39.580 Uttam Kumaran: yeah, I mean.
140 00:25:43.350 ⇒ 00:25:46.439 Uttam Kumaran: there’s some like, this is another one.
141 00:25:46.960 ⇒ 00:25:47.870 Ryan Luke Daque: Hmm.
142 00:25:48.970 ⇒ 00:25:50.400 Ryan Luke Daque: earbight.
143 00:25:51.480 ⇒ 00:25:53.690 Uttam Kumaran: Yeah. Arabite.
144 00:25:57.980 ⇒ 00:26:04.890 Uttam Kumaran: yeah, I mean, I don’t. I don’t know. I would take take a look. I think the 5 11 is maintained, and so we can just take that.
145 00:26:07.180 ⇒ 00:26:11.069 Uttam Kumaran: So these 2 are the biggest ones. Let’s take a
146 00:26:11.190 ⇒ 00:26:24.070 Ryan Luke Daque: are, are you still in progress? Oh, this is the one from last week. Yeah, I already updated it. I just didn’t create a Pr yet validation stuff, right?
147 00:26:24.450 ⇒ 00:26:27.160 Ryan Luke Daque: Yeah. And like, maybe.
148 00:26:27.870 ⇒ 00:26:36.790 Ryan Luke Daque: should we like start working on creating the Dev dev environment. So that yeah, you’re right. So let’s actually make tickets for that.
149 00:26:38.840 ⇒ 00:26:41.449 Uttam Kumaran: So I’m gonna say, modify
150 00:26:42.210 ⇒ 00:26:50.129 Uttam Kumaran: modify local Dbt runs to
151 00:26:50.450 ⇒ 00:26:53.790 Uttam Kumaran: the environment
152 00:26:57.460 ⇒ 00:26:58.150 Uttam Kumaran: there
153 00:27:00.100 ⇒ 00:27:07.460 Uttam Kumaran: and then. we’re all existing like dash
154 00:27:08.590 ⇒ 00:27:10.800 foundation issues.
155 00:27:11.260 ⇒ 00:27:13.380 Uttam Kumaran: add lightash
156 00:27:13.680 ⇒ 00:27:22.579 Uttam Kumaran: validation and preview to get up. Pr, okay, so these are all like a ton of infrast stuff.
157 00:27:22.950 ⇒ 00:27:26.829 Uttam Kumaran: Maybe. Do. Maybe we want to work on that today. These things.
158 00:27:27.210 ⇒ 00:27:31.570 Ryan Luke Daque: some of these today I don’t know. Cause I know it’s late.
159 00:27:32.990 ⇒ 00:27:38.170 Ryan Luke Daque: yeah, I mean, yeah, it would be great if you can like work on those. First, I guess.
160 00:27:38.580 ⇒ 00:27:41.260 Uttam Kumaran: Let’s do that. Let’s try to take a look at these today?
161 00:27:44.480 ⇒ 00:27:50.809 Uttam Kumaran: do you want to go through
162 00:27:51.210 ⇒ 00:27:56.199 Uttam Kumaran: which ones you? Which one do you want to try to take? Cause I can. I’ll have. I have time for the next few hours
163 00:27:56.910 ⇒ 00:27:58.630 Ryan Luke Daque: I can.
164 00:28:00.930 ⇒ 00:28:03.970 Uttam Kumaran: This one is going to take. We have to go into Snowflake.
165 00:28:04.070 ⇒ 00:28:08.210 Uttam Kumaran: Maybe I can do this one, and I’ll just document kind of how I did it.
166 00:28:08.640 ⇒ 00:28:14.259 Ryan Luke Daque: If you want to look at all the light dash validation issues that exist. Yeah, I can do that
167 00:28:15.650 ⇒ 00:28:22.680 Uttam Kumaran: and then let’s just talk in slack. If there’s some dashboards that are old that you can just ask me whether we need them or not.
168 00:28:22.760 ⇒ 00:28:23.770 Ryan Luke Daque: gotcha.
169 00:28:24.450 ⇒ 00:28:32.110 Ryan Luke Daque: So just to make sure I’m clear on this. Basically, this means I’m gonna have to look into all the live dash
170 00:28:32.260 ⇒ 00:28:35.359 Ryan Luke Daque: dashboards that we have right and see if there are any like.
171 00:28:36.110 ⇒ 00:28:42.750 Ryan Luke Daque: yeah, exactly. So here’s where that’s running all these validation issues.
172 00:28:43.290 ⇒ 00:28:51.140 Uttam Kumaran: I wanna just get rid of some of these. So some of these are just like like, there’s some Amazon dashboards that haven’t been touched in a while.
173 00:28:52.100 ⇒ 00:28:57.860 Uttam Kumaran: So some of these are probably just broken because we’ve we’ve moved a lot of stuff around.
174 00:28:58.670 ⇒ 00:29:00.670 Uttam Kumaran: there’s also some other like
175 00:29:00.830 ⇒ 00:29:09.110 Uttam Kumaran: individual charts that are broken, that again, you may just have to quickly change to another dimension.
176 00:29:09.740 ⇒ 00:29:11.870 So if you just want to go through this
177 00:29:12.430 ⇒ 00:29:14.499 Uttam Kumaran: that way, we start with a clean slate.
178 00:29:15.010 ⇒ 00:29:20.130 Uttam Kumaran: Sure, yes, and then I’ll I’ll also. I’m gonna do this.
179 00:29:21.200 ⇒ 00:29:23.049 Uttam Kumaran: and then
180 00:29:27.230 ⇒ 00:29:37.580 Uttam Kumaran: yeah, I will do my, this may take a little bit longer, because Github is kind of it’s a little bit tougher, so we’ll see. But I’ll also take this on, and I’ll see when we end up working on this.
181 00:29:39.000 ⇒ 00:29:52.060 Uttam Kumaran: cool. The other things that are on my side are. So I’m gonna move both of these to in progress. Since we’ll work on these, I need to do a couple send a couple of emails.
182 00:29:52.750 ⇒ 00:30:06.070 Uttam Kumaran: I need to follow up with the person who’s running marketing on just like how she’s been using the marketing dashboard. I need to send a couple of emails on the shipping information. So I’ll take that on.
183 00:30:06.110 ⇒ 00:30:09.659 Uttam Kumaran: I got an email from 5, 10 there
184 00:30:09.710 ⇒ 00:30:15.889 Uttam Kumaran: again, working on something for me. So we’ll see followed up on this. I haven’t heard back. So these 2
185 00:30:15.940 ⇒ 00:30:19.220 Uttam Kumaran: every few days I just ping him again. So we’re gonna see what happens.
186 00:30:21.910 ⇒ 00:30:27.279 Uttam Kumaran: I think that may be.
187 00:30:28.470 ⇒ 00:30:29.940 Ryan Luke Daque: yeah, I think that’s
188 00:30:30.380 ⇒ 00:30:46.510 Uttam Kumaran: I think that’s plenty for the week. I guess. Yeah, I I’m going to like, I’m gonna I’m I’m trying to keep my week pretty free. So I’m gonna try to work on some of these info tickets. And then I want to create a a little data in for a dashboard as soon as I can, so we can start toss across
189 00:30:46.620 ⇒ 00:30:48.420 Uttam Kumaran: 5 Tran and snowflake.
190 00:30:48.580 ⇒ 00:30:50.370 Ryan Luke Daque: Yeah.
191 00:30:50.890 ⇒ 00:31:01.020 Uttam Kumaran: Oh, and you know, there’s one other thing I wanted to try and do you can actually. So there’s 2 things. One I want to. I may have had it here.
192 00:31:02.500 ⇒ 00:31:06.150 Uttam Kumaran: Okay, for now I’m gonna I’m gonna add it here. I’m gonna say,
193 00:31:07.570 ⇒ 00:31:10.260 Uttam Kumaran: add caching to
194 00:31:10.550 ⇒ 00:31:12.720 dB, T. 2
195 00:31:14.420 ⇒ 00:31:18.470 Uttam Kumaran: github hello jobs.
196 00:31:19.210 ⇒ 00:31:36.059 Uttam Kumaran: So you can actually add caching, which what it does is, it’ll instead of installing Dbt every time it caches it. And that step takes like 2 min. So hopefully it should take that on. It’s a. It was actually kinda complicated. II have to read it again.
197 00:31:36.150 ⇒ 00:31:40.530 Uttam Kumaran: The second thing I want to do is run
198 00:31:41.400 ⇒ 00:31:45.609 Uttam Kumaran: only Dbt changes on each
199 00:31:46.410 ⇒ 00:31:48.460 Uttam Kumaran: Pr test
200 00:31:50.140 ⇒ 00:31:55.210 Uttam Kumaran: and also Hpr test.
201 00:31:55.410 ⇒ 00:32:11.490 Uttam Kumaran: and also run the Pr test. Oh, so actually, okay, so run only Dvt on each Pr test. And then this one actually so only modify local. But it’s actually, I want to modify local Dvt runs and the
202 00:32:12.260 ⇒ 00:32:15.739 Uttam Kumaran: and the on Pr
203 00:32:17.190 ⇒ 00:32:18.240 Uttam Kumaran: workflow
204 00:32:18.640 ⇒ 00:32:21.959 Uttam Kumaran: to use dev environment.
205 00:32:22.600 ⇒ 00:32:29.960 Ryan Luke Daque: I see? Yeah, that makes sense. Cause I don’t. If we run it locally, then we push a Pr and it ends up running like that’s also an issue. Right? So
206 00:32:31.440 ⇒ 00:32:32.980 Uttam Kumaran: let’s do that.
207 00:32:34.510 ⇒ 00:32:35.580 Ryan Luke Daque: Okay?
208 00:32:37.210 ⇒ 00:32:39.630 Uttam Kumaran: And then let’s say,
209 00:32:51.610 ⇒ 00:32:54.540 Uttam Kumaran: okay, yeah. I think plenty of stuff for this week.
210 00:32:56.800 ⇒ 00:33:07.819 Uttam Kumaran: And then the only other thing is as you’re looking at data. If there’s anything interesting, you see, like you could see a lot of you know the phone calls that I have with them are a mix of both explaining what’s new. But also
211 00:33:08.240 ⇒ 00:33:10.629 Uttam Kumaran: they wanna see what we’re what we’re finding.
212 00:33:10.670 ⇒ 00:33:23.279 Uttam Kumaran: And so anything as you go through. And you’re like, Oh, this is interesting, or somebody’s costs are high or anything interesting, you see. Just send it to me, or send in slack, and I’ll end up sending it to them. They’ll be happy to see stuff like that. So okay, yeah.
213 00:33:23.630 ⇒ 00:33:28.439 Uttam Kumaran: in case you explore their data or go down a rabbit hole or something. Yeah. Feel free to send it to me.
214 00:33:29.430 ⇒ 00:33:30.100 Ryan Luke Daque: Oh.
215 00:33:32.440 ⇒ 00:33:35.240 Uttam Kumaran: okay, anything else?
216 00:33:36.800 ⇒ 00:33:38.730 Ryan Luke Daque: Yeah. I think I’m I’m good.
217 00:33:39.760 ⇒ 00:33:40.600 Uttam Kumaran: Okay.
218 00:33:41.910 ⇒ 00:33:43.210 Uttam Kumaran: alright, it’s perfect.
219 00:33:43.300 ⇒ 00:33:45.049 Uttam Kumaran: Thanks. Have a nice day.
220 00:33:45.150 ⇒ 00:33:47.020 Uttam Kumaran: Talk to you soon. Bye.