Meeting Title: Uttam Kumaran Date: 2025-01-31 Meeting participants: Uttam Kumaran, Payas Parab
WEBVTT
1 00:01:38.740 ⇒ 00:01:39.790 Payas Parab: Hey? Can you hear me?
2 00:01:42.970 ⇒ 00:01:43.710 Payas Parab: Oh.
3 00:01:51.490 ⇒ 00:01:54.590 Payas Parab: okay, wait. I actually can’t move.
4 00:02:06.780 ⇒ 00:02:07.480 Uttam Kumaran: And.
5 00:02:08.530 ⇒ 00:02:09.660 Payas Parab: Oh, now again! Yep!
6 00:02:10.050 ⇒ 00:02:10.910 Uttam Kumaran: Anything.
7 00:02:11.450 ⇒ 00:02:12.050 Payas Parab: I hear you.
8 00:02:13.280 ⇒ 00:02:14.100 Payas Parab: What’s that?
9 00:02:14.580 ⇒ 00:02:15.999 Uttam Kumaran: Is it kind of quiet.
10 00:02:16.000 ⇒ 00:02:17.260 Payas Parab: Yeah, it is a little quiet.
11 00:02:17.590 ⇒ 00:02:19.760 Uttam Kumaran: What the fuck hold on.
12 00:02:19.760 ⇒ 00:02:20.330 Payas Parab: Okay.
13 00:02:32.190 ⇒ 00:02:33.609 Uttam Kumaran: Okay. Any better.
14 00:02:33.990 ⇒ 00:02:35.210 Payas Parab: Yeah, it’s better. Yep.
15 00:02:41.420 ⇒ 00:02:44.350 Uttam Kumaran: Is this working? Yeah, okay, let’s try a little better.
16 00:02:44.600 ⇒ 00:02:45.540 Payas Parab: Yep. Yeah.
17 00:02:45.540 ⇒ 00:02:54.709 Uttam Kumaran: Alright cool. So we are. I was just working on swimming this table. So we’re looking for
18 00:02:56.276 ⇒ 00:03:00.430 Uttam Kumaran: is subscription order.
19 00:03:01.050 ⇒ 00:03:06.325 Uttam Kumaran: So we don’t get that from from
20 00:03:07.130 ⇒ 00:03:12.849 Uttam Kumaran: What’s it called shopify at all, by the way, or Amazon at all. So.
21 00:03:13.610 ⇒ 00:03:16.830 Payas Parab: Yeah, we don’t. Yeah. The subscription order. We don’t right.
22 00:03:17.590 ⇒ 00:03:18.600 Uttam Kumaran: Yeah, we don’t.
23 00:03:18.880 ⇒ 00:03:22.639 Payas Parab: Or the new, and returning, I think, for the purposes of just like replicating what
24 00:03:22.820 ⇒ 00:03:28.589 Payas Parab: for shopify? Let’s just get it to them. I had a whole other bunch of stuff that came up for Amazon. And now I’m like.
25 00:03:28.890 ⇒ 00:03:38.559 Payas Parab: I’m overthinking all this extra stuff we can do. Let’s just get the shopify one was the one we aligned with Jared on. So I just want to get that to him, which is, and it’s in his format so he can’t just be like.
26 00:03:40.350 ⇒ 00:03:41.410 Uttam Kumaran: Yeah.
27 00:03:42.740 ⇒ 00:03:49.569 Payas Parab: I could have. I could just do it with like a case when function myself like that was, I was like the debate was like, do I just do that myself, or do we like
28 00:03:49.680 ⇒ 00:03:51.630 Payas Parab: put it in the order table like that?
29 00:03:52.450 ⇒ 00:03:53.470 Uttam Kumaran: This is fine.
30 00:03:53.760 ⇒ 00:03:57.249 Uttam Kumaran: Yeah, I mean, like cause to give you a sense of like, if I
31 00:03:57.360 ⇒ 00:04:01.739 Uttam Kumaran: if I were to go in and optimize this if I show you like.
32 00:04:02.710 ⇒ 00:04:06.089 Uttam Kumaran: I can go now, replace all these with the slag.
33 00:04:06.450 ⇒ 00:04:07.089 Payas Parab: Right, right.
34 00:04:07.090 ⇒ 00:04:12.599 Uttam Kumaran: And so I would just create you the flags. In fact, I wouldn’t even yeah, it’s just.
35 00:04:14.360 ⇒ 00:04:20.429 Uttam Kumaran: you know, you kind of make these decisions. You don’t really something beautiful. It’s hard to know whether it’s gonna matter. So this is fine.
36 00:04:20.430 ⇒ 00:04:20.950 Payas Parab: Sure.
37 00:04:21.380 ⇒ 00:04:22.720 Uttam Kumaran: Okay. So
38 00:04:22.830 ⇒ 00:04:28.679 Uttam Kumaran: I’m gonna just run this in staging, and then you can go take a look. I guess I’ll show you what’s I guess I’ll show you.
39 00:04:28.680 ⇒ 00:04:31.119 Payas Parab: So we need all we need.
40 00:04:31.310 ⇒ 00:04:32.810 Payas Parab: So what I’m saying is, instead of.
41 00:04:32.810 ⇒ 00:04:34.510 Uttam Kumaran: Want, every single variation.
42 00:04:34.990 ⇒ 00:04:39.269 Payas Parab: Yes, and it’s like, instead of Booleans. Why don’t we just do it as a
43 00:04:39.590 ⇒ 00:04:43.130 Payas Parab: like a text variable? That’s just like that’s what this field is
44 00:04:43.340 ⇒ 00:04:49.219 Payas Parab: so you can run a group by on the orders. So case when this subscription and this new
45 00:04:49.510 ⇒ 00:04:53.020 Payas Parab: new sub right case, when this you know.
46 00:04:53.020 ⇒ 00:04:58.340 Uttam Kumaran: Well, then, I guess you tell me. Tell me, like what what you want this field to be called like.
47 00:05:01.870 ⇒ 00:05:06.409 Payas Parab: Yeah, I guess customer type would get confusing. But it’s realistically as customer type. We call it.
48 00:05:08.580 ⇒ 00:05:13.319 Uttam Kumaran: Well, you could say customer, subscription type.
49 00:05:13.800 ⇒ 00:05:15.700 Payas Parab: Customer, subscription. Type, yeah.
50 00:05:18.540 ⇒ 00:05:21.960 Uttam Kumaran: Okay, so you basically want all the variations.
51 00:05:22.500 ⇒ 00:05:23.210 Payas Parab: Yeah.
52 00:05:24.150 ⇒ 00:05:25.360 Uttam Kumaran: Okay. Okay.
53 00:05:25.870 ⇒ 00:05:30.740 Payas Parab: And I didn’t know is like, is that better to just write the sequel in metabase? Or is it better to do it here?
54 00:05:30.740 ⇒ 00:05:32.010 Uttam Kumaran: No, I would do here.
55 00:05:32.010 ⇒ 00:05:34.010 Payas Parab: That’s what I thought, too. But I wanna make sure. Okay.
56 00:05:38.360 ⇒ 00:05:41.240 Uttam Kumaran: And then you wanted like, what would you name this.
57 00:05:41.791 ⇒ 00:05:44.599 Payas Parab: Just call it so like new subs
58 00:05:44.730 ⇒ 00:05:47.799 Payas Parab: would be the like description. There. Yeah. New subs.
59 00:05:53.260 ⇒ 00:05:54.049 Uttam Kumaran: Like this.
60 00:05:54.180 ⇒ 00:06:00.059 Payas Parab: Yeah, exactly. And then it already got the next one. Yep, so is subscription returning. So you have returning subs.
61 00:06:01.930 ⇒ 00:06:08.770 Payas Parab: and then I wouldn’t do that. I wouldn’t do that non subscriptions, because I
62 00:06:10.040 ⇒ 00:06:12.050 Payas Parab: like we should just make it a complete
63 00:06:12.760 ⇒ 00:06:19.309 Payas Parab: like all 4 variations, right? Of that 2 by 2. Let’s just get that in this field, because then for the other one you can just use. The is subscription is subscription.
64 00:06:19.310 ⇒ 00:06:22.160 Uttam Kumaran: Well, are there?
65 00:06:22.270 ⇒ 00:06:27.150 Uttam Kumaran: Yeah, like, what are the other? Is there one where this is false, and these are still new and returning.
66 00:06:27.150 ⇒ 00:06:28.100 Payas Parab: Yes. Yeah.
67 00:06:28.100 ⇒ 00:06:29.319 Uttam Kumaran: Okay. Okay. Okay.
68 00:06:29.580 ⇒ 00:06:36.810 Payas Parab: So there’d be there’d be new subscriptions, returning subscriptions, new non subscriptions returning non subscriptions exactly, and that should
69 00:06:37.050 ⇒ 00:06:40.709 Payas Parab: completed like else is unknown. Shouldn’t really occur.
70 00:06:41.460 ⇒ 00:06:43.799 Payas Parab: because it’s a 4 by it’s a 2 by 2 matrix, right?
71 00:06:43.800 ⇒ 00:06:55.390 Uttam Kumaran: Well, you’re gonna well. I like to keep the else, because if I don’t keep the else, it’s gonna come in as null. So at least, if it’s uncategorized, you’ll get something there, and then you can be like.
72 00:06:55.750 ⇒ 00:06:57.110 Uttam Kumaran: like something’s fucked up.
73 00:06:57.240 ⇒ 00:07:02.510 Payas Parab: Yeah. But I mean, those are both Booleans, right? So there’s only 4 combinations that are possible
74 00:07:02.680 ⇒ 00:07:05.619 Payas Parab: or not. Booleans. Sorry. No, no, they’re not one is a Boolean, the other.
75 00:07:05.620 ⇒ 00:07:07.820 Uttam Kumaran: Well, they’re both. They’re both just 2 values each.
76 00:07:07.820 ⇒ 00:07:08.320 Payas Parab: How you see.
77 00:07:08.320 ⇒ 00:07:10.280 Uttam Kumaran: 4, 4, total, yeah.
78 00:07:10.600 ⇒ 00:07:11.140 Payas Parab: Okay.
79 00:07:11.670 ⇒ 00:07:13.790 Uttam Kumaran: Okay, so I will.
80 00:07:14.130 ⇒ 00:07:17.880 Uttam Kumaran: So what I do here is like, I use github desktop. You can use github.
81 00:07:18.530 ⇒ 00:07:21.179 Uttam Kumaran: basically just create the Pr.
82 00:07:22.460 ⇒ 00:07:28.060 Uttam Kumaran: Adding, Oh, and then we don’t want to call this subscription type. We want to call this customer.
83 00:07:29.040 ⇒ 00:07:31.590 Payas Parab: Yeah, we call it customer subscription.
84 00:07:33.660 ⇒ 00:07:36.209 Uttam Kumaran: Yeah, I don’t like the name, but maybe that’s
85 00:07:38.140 ⇒ 00:07:40.439 Uttam Kumaran: you want to think of a better name. I don’t know.
86 00:07:40.800 ⇒ 00:07:41.400 Payas Parab: Sure.
87 00:07:41.909 ⇒ 00:07:42.929 Uttam Kumaran: Subscription type.
88 00:07:45.850 ⇒ 00:07:51.150 Uttam Kumaran: This is almost like a yeah, I don’t know.
89 00:07:51.650 ⇒ 00:07:56.429 Payas Parab: The other thing. I quickly. I mean, if we’re if we’re just making changes, and I again like I can.
90 00:07:56.430 ⇒ 00:07:58.410 Uttam Kumaran: Oh, no, we can make any change. Yeah.
91 00:07:58.784 ⇒ 00:08:06.739 Payas Parab: Is just get rid of some of these like old cogs things. So we don’t get confused because we want to keep it interactive so that they can like make stuff in Meta base.
92 00:08:07.040 ⇒ 00:08:08.449 Payas Parab: I think there’s.
93 00:08:09.610 ⇒ 00:08:12.049 Uttam Kumaran: Oh, you don’t want any. You don’t want many of these. Okay.
94 00:08:12.050 ⇒ 00:08:14.670 Payas Parab: The all the old cog stuff. And if I I think
95 00:08:15.280 ⇒ 00:08:20.160 Payas Parab: there’s the new stuff right there. Product cost product weight pack out units, shipping cost box costs.
96 00:08:20.160 ⇒ 00:08:21.968 Uttam Kumaran: Okay, what I’m gonna do is
97 00:08:43.669 ⇒ 00:08:44.490 Uttam Kumaran: Okay?
98 00:08:45.680 ⇒ 00:08:48.229 Uttam Kumaran: And then just tell me which ones you don’t want.
99 00:08:53.650 ⇒ 00:08:55.570 Uttam Kumaran: So you don’t want
100 00:08:57.410 ⇒ 00:08:58.470 Uttam Kumaran: These.
101 00:08:59.500 ⇒ 00:09:01.680 Payas Parab: Those are the old ones. Yeah, I think so.
102 00:09:02.665 ⇒ 00:09:03.170 Payas Parab: So.
103 00:09:03.170 ⇒ 00:09:05.850 Uttam Kumaran: Insert costs to skew weights rounded.
104 00:09:07.860 ⇒ 00:09:11.640 Uttam Kumaran: Yeah, cause this is now coming from the Soc shopify cogs.
105 00:09:12.230 ⇒ 00:09:14.519 Payas Parab: Yeah, so we don’t need ol anymore.
106 00:09:14.520 ⇒ 00:09:19.370 Uttam Kumaran: Do we? Do we not need it, or are we like? Is it just? Should I just delete it
107 00:09:21.020 ⇒ 00:09:22.000 Uttam Kumaran: like, will you need.
108 00:09:22.000 ⇒ 00:09:24.930 Payas Parab: I think that there’s no like we don’t have.
109 00:09:25.570 ⇒ 00:09:27.479 Payas Parab: Oh, this is coming from.
110 00:09:28.200 ⇒ 00:09:29.190 Uttam Kumaran: Little ones.
111 00:09:30.140 ⇒ 00:09:34.150 Payas Parab: This is coming from orderlines. This is coming from that like cloudflare thing that’s firing.
112 00:09:34.850 ⇒ 00:09:41.570 Payas Parab: Maybe we just leave it like that was the one. That was the whole thing that kicked off this thing which is like that’s just not right, like those aren’t right.
113 00:09:44.650 ⇒ 00:09:47.929 Payas Parab: So we have these updated ones that are coming from that spreadsheet.
114 00:09:48.190 ⇒ 00:09:57.289 Uttam Kumaran: I’m going to. I’m gonna just remove it out of the Union and then let long term I can. I’ll just put a comment to delete it, because in case you need it, it’ll be
115 00:09:57.520 ⇒ 00:09:59.339 Uttam Kumaran: quick to like revert this, so.
116 00:09:59.340 ⇒ 00:10:00.630 Payas Parab: Sure. Okay, that makes sense.
117 00:10:00.630 ⇒ 00:10:04.020 Uttam Kumaran: Insert cost and skew weights around it.
118 00:10:19.325 ⇒ 00:10:21.820 Uttam Kumaran: And I was gonna ask this
119 00:10:36.290 ⇒ 00:10:39.700 Uttam Kumaran: subscription customer category, how do we think? Feel about that?
120 00:10:40.080 ⇒ 00:10:40.650 Payas Parab: Sure.
121 00:10:40.710 ⇒ 00:10:42.400 Uttam Kumaran: I like category better.
122 00:10:42.810 ⇒ 00:10:51.839 Payas Parab: Sure. Yeah, okay, that should be clear, because every analysis Jared wants you can. Basically, he wants those categories.
123 00:10:51.840 ⇒ 00:10:52.650 Uttam Kumaran: Okay. Great.
124 00:10:52.650 ⇒ 00:10:55.210 Payas Parab: And also totals, which, like
125 00:10:55.670 ⇒ 00:11:01.909 Payas Parab: annoyingly in metabase, adds a little bit of complexity. But Metabase has a pivot table thing that I think will get the job done.
126 00:11:03.000 ⇒ 00:11:03.640 Uttam Kumaran: Okay.
127 00:11:18.470 ⇒ 00:11:22.360 Uttam Kumaran: Oh, shit. Okay, let’s do it, anyways.
128 00:11:51.330 ⇒ 00:11:53.950 Uttam Kumaran: And then I’m just gonna put here.
129 00:12:19.890 ⇒ 00:12:22.900 Uttam Kumaran: Okay, this should run. And then let’s see.
130 00:12:24.970 ⇒ 00:12:28.109 Payas Parab: And is this updated like relatively real time? Or is it.
131 00:12:28.976 ⇒ 00:12:33.509 Uttam Kumaran: Yeah. Well, it’s gonna run in staging, and then I’ll just show you what it looks like.
132 00:12:33.890 ⇒ 00:12:34.510 Payas Parab: Okay.
133 00:12:34.680 ⇒ 00:12:37.839 Uttam Kumaran: And then, if it’s good, I’ll push it.
134 00:12:39.780 ⇒ 00:12:42.459 Payas Parab: So how are you checking? That’s the one thing out there. Yeah. So you’re.
135 00:12:42.460 ⇒ 00:12:44.101 Uttam Kumaran: Yeah, so I’ll show you.
136 00:12:45.900 ⇒ 00:12:52.770 Uttam Kumaran: I’ll show you where to go. See this run. And we created, I created like dev and staging environments.
137 00:12:52.770 ⇒ 00:12:53.260 Payas Parab: Okay.
138 00:12:53.260 ⇒ 00:12:58.030 Uttam Kumaran: Previously we would run the Pr. And it would test it, but it would just overwrite what’s live which is
139 00:12:58.850 ⇒ 00:12:59.795 Uttam Kumaran: dumb?
140 00:13:01.060 ⇒ 00:13:08.329 Uttam Kumaran: So instead, what you’ll see here soon as this is, or whatever this is done.
141 00:13:16.170 ⇒ 00:13:18.500 Uttam Kumaran: So it’s currently running this.
142 00:13:18.750 ⇒ 00:13:24.629 Uttam Kumaran: It’s running a bunch of Dbt stuff here. It’s it’s running the entire build. Basically, it will check that, did we?
143 00:13:25.050 ⇒ 00:13:26.450 Uttam Kumaran: The refux coming up?
144 00:13:27.134 ⇒ 00:13:31.330 Uttam Kumaran: And so if you go to staging intermediate
145 00:13:34.330 ⇒ 00:13:39.899 Uttam Kumaran: you should see this get updated soon. So 17 min ago.
146 00:13:40.130 ⇒ 00:13:41.790 Uttam Kumaran: So we’ll wait until this.
147 00:13:42.090 ⇒ 00:13:47.130 Payas Parab: So this runs, and then you you do push it to the prod branch, but it’s.
148 00:13:47.760 ⇒ 00:13:50.200 Uttam Kumaran: So when I push it to prodbench, it’ll run again.
149 00:13:51.210 ⇒ 00:13:55.770 Payas Parab: Oh, so you’re on. You’re in just the the Pr.
150 00:13:55.770 ⇒ 00:14:06.410 Uttam Kumaran: So I’m in the Pr, so in the P. So what happens is this job will check out the Github code from my branch and execute it against the staging environment.
151 00:14:07.011 ⇒ 00:14:09.069 Payas Parab: Do you guys found that.
152 00:14:09.190 ⇒ 00:14:12.560 Uttam Kumaran: Yeah. Or is that like a def? I was like, that’s not like a default thing. Right?
153 00:14:13.630 ⇒ 00:14:15.140 Uttam Kumaran: No. We built this. Yeah.
154 00:14:16.090 ⇒ 00:14:16.810 Payas Parab: And sick.
155 00:14:17.180 ⇒ 00:14:17.940 Payas Parab: Okay.
156 00:14:18.390 ⇒ 00:14:20.384 Uttam Kumaran: Well, this is how like cause, otherwise.
157 00:14:22.440 ⇒ 00:14:24.020 Payas Parab: Does this give up actions.
158 00:14:24.240 ⇒ 00:14:30.719 Uttam Kumaran: Yeah, this. So we built our own. We built our own Github actions to run. Dbt, basically, this is like what we would have to pay
159 00:14:30.890 ⇒ 00:14:32.770 Uttam Kumaran: Dbt. Cloud for
160 00:14:33.155 ⇒ 00:14:38.780 Uttam Kumaran: clouds like a. It’s just a kind of a waste of money, doesn’t. The only thing we would use it for is to schedule jobs.
161 00:14:39.096 ⇒ 00:14:46.880 Uttam Kumaran: Otherwise, it’s it’s kind of like, not a lot of in there. But they charge a hundred bucks a month per user. And I was like, that’s kind of a waste. We’ll just run everything here.
162 00:14:47.110 ⇒ 00:14:50.349 Uttam Kumaran: So basically, the ideal development flow is like.
163 00:14:50.750 ⇒ 00:14:58.349 Uttam Kumaran: we didn’t do this today. But I would have ran this in dev locally it would go. I would go look at it in the dev
164 00:14:58.500 ⇒ 00:15:02.270 Uttam Kumaran: in the dev Marts and dev intermediate schema here
165 00:15:02.460 ⇒ 00:15:10.849 Uttam Kumaran: verify that it looks good. You would push a Pr. The Pr. Would also run. Someone else would approve it, and then it gets merged, and then it gets picked up by production.
166 00:15:11.381 ⇒ 00:15:18.670 Uttam Kumaran: That’s like the lightest version of like a developer environment. People do things like Pre dev, like.
167 00:15:18.930 ⇒ 00:15:23.169 Uttam Kumaran: there’s a we could get like much more advanced, but across most clients we’ll have that.
168 00:15:23.560 ⇒ 00:15:32.869 Payas Parab: I wanted to like. Let’s say I was like, Hey, I want to just take a rip. It like like that. Code you wrote isn’t like rocket science, right? I just like want to make sure nothing. So the best flow would be.
169 00:15:33.090 ⇒ 00:15:34.699 Uttam Kumaran: So the best flow would be
170 00:15:35.339 ⇒ 00:15:47.470 Uttam Kumaran: one to to make sure you’re set up on Dbt locally, which we can. We can help you do. It’s pretty simple, and then you would just then run dbt, run, dash, dash models, and like fact orders.
171 00:15:47.470 ⇒ 00:15:47.870 Payas Parab: Okay.
172 00:15:47.870 ⇒ 00:15:53.869 Uttam Kumaran: You. You could do that otherwise. You can also just do. You can run everything, in fact, orders, including everything, before it.
173 00:15:54.020 ⇒ 00:16:02.879 Uttam Kumaran: That way. You run the entire pipeline, or you can just basically run. Dbt, run. It’ll run the whole thing that will go ahead and appear in Dev.
174 00:16:03.110 ⇒ 00:16:03.970 Payas Parab: In depth.
175 00:16:04.220 ⇒ 00:16:04.870 Uttam Kumaran: Yeah.
176 00:16:05.640 ⇒ 00:16:08.679 Uttam Kumaran: And and what we’re gonna do is basically we will prevent
177 00:16:08.790 ⇒ 00:16:17.139 Uttam Kumaran: all of our developers from having any ability to write over anything and staging and prod. So you won’t have to worry about like fucking anything up. Basically.
178 00:16:17.140 ⇒ 00:16:27.409 Payas Parab: That’s that’s that was like, that’s always my main concern of like, why, Pr, this, when it’s like the fix, is relatively easy, right? Like, I know the case when logic that needs to be built, it’s more so I’m gonna pull it locally.
179 00:16:27.410 ⇒ 00:16:35.139 Uttam Kumaran: So, yeah, so you. So the nice thing is, you could have rent even you could have done what I did, which is just create it. And like I
180 00:16:35.450 ⇒ 00:16:43.920 Uttam Kumaran: like, I’m not gonna get the sequel wrong. It’s there’s nothing really get wrong. So I’ll just push it. But anyways, dB, Github will tell you like. Did you fuck something up?
181 00:16:44.436 ⇒ 00:16:53.899 Uttam Kumaran: And that way that way? I don’t have to. When I go review the Pr. I don’t have to also bring it locally and run it. I’m like Dbt. Does that for us.
182 00:16:54.110 ⇒ 00:16:54.590 Payas Parab: That’s okay.
183 00:16:54.590 ⇒ 00:16:55.100 Uttam Kumaran: Awesome.
184 00:16:55.450 ⇒ 00:16:55.999 Payas Parab: Like this is.
185 00:16:56.000 ⇒ 00:17:02.350 Uttam Kumaran: Yeah, and then nobody, and then nobody can. No developer should be able to touch anything in
186 00:17:02.510 ⇒ 00:17:10.489 Uttam Kumaran: in staging or production, and production can only be touched by basically the our production job.
187 00:17:10.907 ⇒ 00:17:22.699 Uttam Kumaran: Just creates layers of separation. Ideally, what we would do is like we would, for example, we would almost staging. We would just push stuff to staging, and then we would do what’s called a like a release or a
188 00:17:22.829 ⇒ 00:17:29.780 Uttam Kumaran: like a branch release, which was we? We do a cut over, we’d say, cool. We push 10 changes. And now all these changes we want to merge up.
189 00:17:30.030 ⇒ 00:17:36.970 Uttam Kumaran: we sort of continuously deploy. So we don’t have like 4 environments. Otherwise we would have 4. We would have like
190 00:17:37.370 ⇒ 00:17:42.899 Uttam Kumaran: we would have dev stage. We would have dev staging, pre prod and prod probably, or something like that.
191 00:17:42.900 ⇒ 00:17:46.199 Payas Parab: Yeah, yeah, which we don’t. Wanna. I think that also adds, there’s like.
192 00:17:46.200 ⇒ 00:17:47.200 Uttam Kumaran: I mean, we just like.
193 00:17:47.200 ⇒ 00:17:48.490 Payas Parab: Try. Off. Yeah.
194 00:17:48.720 ⇒ 00:17:55.439 Uttam Kumaran: I, just, it’s just like we will. I mean this. This is the way we, we avoid issues as we start to do more complicated stuff. We’ll
195 00:17:55.820 ⇒ 00:18:02.270 Uttam Kumaran: we’ll get there. It’s just for me. It’s like, how do I prevent people from making issues, but also allow them to test their code
196 00:18:02.440 ⇒ 00:18:03.380 Uttam Kumaran: early
197 00:18:05.310 ⇒ 00:18:14.409 Uttam Kumaran: and like again, like if you if you don’t want to miss a comma blah blah. And also the other thing we’re gonna start to do is we’ll we’ll start auto formatting your code as soon as it’s pushed in.
198 00:18:14.988 ⇒ 00:18:19.919 Uttam Kumaran: And then the next stage is, I’ll actually have AI sort of give you comments also.
199 00:18:22.210 ⇒ 00:18:33.919 Uttam Kumaran: what we’ll what we’ll what we’ll end up doing is like. If the ticket has enough requirements, then the AI will have understanding of what the ticket was about, what your commit was, and then it will basically do the review like
200 00:18:34.050 ⇒ 00:18:40.389 Uttam Kumaran: you should go change Xyz, or like, it’s good that way. I can go in and be like, Okay, AI already said, it’s good. I’ll just.
201 00:18:40.850 ⇒ 00:18:44.136 Uttam Kumaran: It’s just like we could just get reviews on faster. Right? That’s
202 00:18:44.410 ⇒ 00:18:46.260 Payas Parab: Yeah, yeah, yeah.
203 00:18:46.940 ⇒ 00:18:51.249 Uttam Kumaran: But we’re a yeah, that’s the general flow. So let’s see, this is still running.
204 00:18:52.880 ⇒ 00:18:54.360 Uttam Kumaran: but it looks like we’ll be good.
205 00:18:55.520 ⇒ 00:18:59.219 Payas Parab: My phone break. It would, if it would have broken. It would have told you that right.
206 00:18:59.220 ⇒ 00:19:08.020 Uttam Kumaran: Yeah, so what? So actually, what we’re what we’re not doing right now is currently, we’re running everything we can actually just run the stuff affected.
207 00:19:08.518 ⇒ 00:19:10.679 Uttam Kumaran: We’re just not doing that in this.
208 00:19:10.980 ⇒ 00:19:11.650 Payas Parab: Sure.
209 00:19:11.860 ⇒ 00:19:14.909 Uttam Kumaran: Flow. But let me just show you where this could be.
210 00:19:18.280 ⇒ 00:19:20.250 Uttam Kumaran: or it’s in staging.
211 00:19:23.520 ⇒ 00:19:25.190 Uttam Kumaran: Where is this guy?
212 00:19:37.710 ⇒ 00:19:40.589 Uttam Kumaran: Oh, it didn’t! It’s not running yet. Hold on.
213 00:20:01.410 ⇒ 00:20:05.089 Uttam Kumaran: yeah. See? Like, for example, indoor cogs ran 4 min ago.
214 00:20:05.670 ⇒ 00:20:06.250 Payas Parab: Hmm.
215 00:20:07.600 ⇒ 00:20:09.689 Uttam Kumaran: And so we should see this pop up soon.
216 00:20:10.760 ⇒ 00:20:17.810 Uttam Kumaran: Okay, see? Look! There was an error. Invalid, identifier order number, and.
217 00:20:23.990 ⇒ 00:20:25.160 Payas Parab: Blocked orders.
218 00:20:32.930 ⇒ 00:20:34.289 Uttam Kumaran: Oh, I know what happened
219 00:21:02.470 ⇒ 00:21:03.330 Uttam Kumaran: one.
220 00:21:24.280 ⇒ 00:21:25.310 Uttam Kumaran: And
221 00:21:33.990 ⇒ 00:21:38.620 Uttam Kumaran: something’s wrong with my like local environment. But this should do it.
222 00:21:39.490 ⇒ 00:21:41.830 Uttam Kumaran: But the problem is, it’s gonna run it again.
223 00:21:43.720 ⇒ 00:21:44.910 Uttam Kumaran: Wait a sec.
224 00:23:06.720 ⇒ 00:23:08.719 Payas Parab: Sure on it and get on there.
225 00:23:09.990 ⇒ 00:23:16.030 Uttam Kumaran: Yes, it is. But I just wanna that’s fine.
226 00:23:25.320 ⇒ 00:23:26.320 Uttam Kumaran: Okay, I don’t know.
227 00:23:59.270 ⇒ 00:24:00.420 Uttam Kumaran: Jeez.
228 00:24:09.190 ⇒ 00:24:10.179 Uttam Kumaran: let’s see.
229 00:24:56.170 ⇒ 00:24:56.880 Uttam Kumaran: Yeah.
230 00:25:04.940 ⇒ 00:25:13.210 Uttam Kumaran: okay, so yeah, like, for example, I can just now compile this and like.
231 00:25:13.590 ⇒ 00:25:19.960 Uttam Kumaran: let’s say I’m like cool. I’m working on something in Dbt, and I want to go test it. You can run it here, or you can actually just go like
232 00:25:20.560 ⇒ 00:25:24.760 Uttam Kumaran: I would just go here and basically just try to just try to run it in a
233 00:25:24.870 ⇒ 00:25:27.719 Uttam Kumaran: here. So I can go here and say, cool, let me just go test.
234 00:25:28.010 ⇒ 00:25:28.645 Payas Parab: And
235 00:25:30.770 ⇒ 00:25:32.200 Uttam Kumaran: This should run.
236 00:25:32.870 ⇒ 00:25:35.040 Uttam Kumaran: This is almost done anyways, but
237 00:25:36.270 ⇒ 00:25:41.710 Uttam Kumaran: and so we can look here and see that it’s not working.
238 00:25:41.960 ⇒ 00:25:43.620 Uttam Kumaran: Oh, but these are all Amazon.
239 00:25:45.823 ⇒ 00:25:47.350 Uttam Kumaran: So let’s
240 00:25:54.430 ⇒ 00:25:56.030 Uttam Kumaran: these are all Amazon.
241 00:25:56.220 ⇒ 00:25:58.190 Uttam Kumaran: Okay, here, shopify.
242 00:25:58.520 ⇒ 00:25:59.740 Uttam Kumaran: Yeah, it’s working.
243 00:26:00.430 ⇒ 00:26:01.380 Payas Parab: Perfect. Okay.
244 00:26:01.690 ⇒ 00:26:04.329 Uttam Kumaran: But what do you want to do for these?
245 00:26:05.800 ⇒ 00:26:08.079 Uttam Kumaran: For the non shopify ones?
246 00:26:09.160 ⇒ 00:26:12.999 Payas Parab: Think there is like there is a way to figure out like
247 00:26:14.640 ⇒ 00:26:24.459 Payas Parab: there’s something to do there. It’s just that it unlocks a whole can of worms that I don’t want to unlock yet, and I just want to get the shopify margins done is where my head’s at.
248 00:26:24.690 ⇒ 00:26:26.719 Payas Parab: because there is a way
249 00:26:26.880 ⇒ 00:26:32.620 Payas Parab: like with Amazon, you can get the customer. Id, so we can do that same logic that we built out for shopping.
250 00:26:32.620 ⇒ 00:26:35.140 Uttam Kumaran: Oh, yeah. Yeah. Find it before? Yeah.
251 00:26:35.760 ⇒ 00:26:37.499 Payas Parab: You can find, yeah, basically like.
252 00:26:37.500 ⇒ 00:26:39.080 Uttam Kumaran: So subscriptions, right.
253 00:26:41.580 ⇒ 00:26:48.970 Payas Parab: I believe I believe there are subscriptions on Amazon. We are unable to get the data of whether it’s a subscription order or not. I believe.
254 00:26:48.970 ⇒ 00:26:51.050 Uttam Kumaran: You can do new custom, new returning customers.
255 00:26:51.050 ⇒ 00:26:53.219 Payas Parab: We can do new and returning. Yes.
256 00:26:53.650 ⇒ 00:26:56.718 Payas Parab: you’re gonna you’re just gonna get null in your
257 00:26:59.010 ⇒ 00:27:01.950 Uttam Kumaran: In your dropdown, though? Is that okay?
258 00:27:03.200 ⇒ 00:27:08.229 Payas Parab: I think it should be okay. If if as long as we’re we’re filtering specifically for shopify.
259 00:27:09.360 ⇒ 00:27:10.060 Uttam Kumaran: Yeah, exactly.
260 00:27:10.060 ⇒ 00:27:20.019 Payas Parab: What I’d like is like, just let’s start with like getting. Just make sure that those numbers on shopify and the margin tables that Jared’s asking for those look somewhat right.
261 00:27:20.290 ⇒ 00:27:25.360 Payas Parab: and then I think we’ll get to the Amazon, and how we union all that together later.
262 00:27:26.140 ⇒ 00:27:27.540 Uttam Kumaran: Okay, so.
263 00:27:29.580 ⇒ 00:27:30.940 Payas Parab: See emerging, prod, now.
264 00:27:31.120 ⇒ 00:27:33.973 Uttam Kumaran: Yeah. So once you merge this, you’ll see that
265 00:27:35.170 ⇒ 00:27:41.510 Uttam Kumaran: a new one of these should get kicked off at some point.
266 00:27:45.290 ⇒ 00:27:47.400 Uttam Kumaran: Or actually, maybe
267 00:28:06.600 ⇒ 00:28:09.200 Uttam Kumaran: Internet. Yeah, let me just run this.
268 00:28:20.890 ⇒ 00:28:29.699 Uttam Kumaran: So yeah, we we can’t have the staging environment here hooked up to Ci, CD, so we run the staging, but we were previously just like
269 00:28:29.870 ⇒ 00:28:39.869 Uttam Kumaran: I didn’t know how big Javi was. Gonna be. So we were like, just run. We just have one job now that there’s like a bunch of us running, I’ll probably end up moving everything to Dbt.
270 00:28:40.070 ⇒ 00:28:47.220 Uttam Kumaran: Core, which is there, which is open source. Cbt, and I’ll probably take these runs and put them there. But
271 00:28:47.540 ⇒ 00:28:50.209 Uttam Kumaran: this was working just fine. So yeah, this is.
272 00:28:51.080 ⇒ 00:28:54.600 Uttam Kumaran: this will run. And it looks like it’ll take like 5 min. Yeah.
273 00:28:54.600 ⇒ 00:28:57.830 Payas Parab: No problem. Okay? And I also have to refresh the schemas in
274 00:28:58.830 ⇒ 00:29:00.899 Payas Parab: in database, and it should be on them.
275 00:29:01.270 ⇒ 00:29:04.750 Uttam Kumaran: What else do you need anything else? I’m in here doing stuff today.
276 00:29:06.500 ⇒ 00:29:07.560 Payas Parab: I think.
277 00:29:08.770 ⇒ 00:29:13.080 Uttam Kumaran: I push the the or the order lines. The order, id stuff is also done.
278 00:29:13.260 ⇒ 00:29:14.319 Payas Parab: Okay, that’s good.
279 00:29:14.700 ⇒ 00:29:15.530 Payas Parab: Yeah.
280 00:29:15.730 ⇒ 00:29:18.810 Payas Parab: I I think, for now, then, like, we’re good there.
281 00:29:19.100 ⇒ 00:29:19.740 Uttam Kumaran: Okay.
282 00:29:20.060 ⇒ 00:29:22.119 Payas Parab: Yeah, thanks for thanks for that. Don’t worry.
283 00:29:22.400 ⇒ 00:29:27.920 Payas Parab: Yeah. That order. Id order number thing was just causing some weird duplication stuff. So I just wanted to make sure we cleared that up.
284 00:29:28.140 ⇒ 00:29:29.230 Uttam Kumaran: Yeah, okay.
285 00:29:29.230 ⇒ 00:29:43.380 Payas Parab: Excellent. Okay, yeah, we’re good there. I’m just gonna like this is basically what I’m gonna crank on. Also like to my message earlier, it’s like I’m not saying like, Oh, I’m like totally fucked. And everything I just like. I’m noticing things are like a day or 2 behind, and those things quickly cascade. So I wanted to.
286 00:29:43.380 ⇒ 00:29:43.840 Uttam Kumaran: Yeah.
287 00:29:43.840 ⇒ 00:29:58.940 Payas Parab: It’s not a red flag. I’m throwing up a yellow flag that’s like, just like giving you some heads up like I’m adjusting to my new master’s program and like work stuff. And it’s just I see things getting delayed by like a day or 2, like one day being out kind of things fall apart for me and.
288 00:29:58.940 ⇒ 00:29:59.260 Uttam Kumaran: Yeah.
289 00:30:00.070 ⇒ 00:30:02.870 Payas Parab: You know, I just wanna make sure that like, maybe we
290 00:30:02.970 ⇒ 00:30:10.739 Payas Parab: implement in just some near term stuff, too, like I’m more engaged. So I think I’m like getting better at it, but I project management has never been a skill of mine.
291 00:30:10.920 ⇒ 00:30:34.839 Uttam Kumaran: Yeah, no, I think we’re gonna get better. We also have one other person that joined yesterday on the Ae. Side. So he’s gonna be handling. Probably he’s gonna probably take over some stuff for Javi. Ae, Ryan is gonna be working with me on pool parts and stack lits, and then we have another client starting to, so I think we’ll have more coverage there and then.
292 00:30:35.477 ⇒ 00:30:37.880 Payas Parab: Think it just might be to have some like.
293 00:30:38.220 ⇒ 00:30:43.129 Uttam Kumaran: We’re gonna have one more person trying to. We’re gonna have one more person who’s redundant on everything. Basically.
294 00:30:43.130 ⇒ 00:30:53.759 Payas Parab: That’s that’s that’s why my head was like. It would be nice to have some redundancy just about. There’s some accountability of like well, fuck dude like I’m stay on this like then it’s like.
295 00:30:54.320 ⇒ 00:30:57.660 Uttam Kumaran: Yeah, can someone, could someone just come in and take this real quick? Yeah, yeah.
296 00:30:57.660 ⇒ 00:31:03.370 Payas Parab: Yeah. Yeah. And and like, it’s, it’s because it’s not hard. What needs to get done. Like, nothing is rocket science. It’s just
297 00:31:03.520 ⇒ 00:31:07.550 Payas Parab: fuck. I just need 3, 4 h, and I’m not sure. Last 2 days, if I have.
298 00:31:07.550 ⇒ 00:31:12.745 Uttam Kumaran: No, that’s fine. We’re just gonna make sure that there’s 1 other analyst, basically. And then
299 00:31:13.230 ⇒ 00:31:19.650 Uttam Kumaran: we’ll sort of as as things come up. We’ll sort of make sure that we can. We can toss things. We’ll just have more redundancy. So that’d be fine.
300 00:31:19.650 ⇒ 00:31:22.650 Payas Parab: Yeah. And I think long term like my my strength is like
301 00:31:22.820 ⇒ 00:31:25.719 Payas Parab: in knowing what to do and like, not as much as like doing.
302 00:31:25.720 ⇒ 00:31:32.070 Uttam Kumaran: No, but I actually think, like out of everyone I think you’re. I would much rather have you focus on the pool parts
303 00:31:32.300 ⇒ 00:31:34.540 Uttam Kumaran: because they’re like a unique situation.
304 00:31:34.710 ⇒ 00:31:37.949 Uttam Kumaran: like there’s they, we. It’s just like a
305 00:31:39.860 ⇒ 00:31:43.109 Uttam Kumaran: it’s I don’t know. I I’m not comfortable throwing anyone who hasn’t
306 00:31:43.590 ⇒ 00:31:47.680 Uttam Kumaran: been able to just like work, sort of with execs and like work with like kind of like
307 00:31:47.920 ⇒ 00:31:49.409 Uttam Kumaran: weird shit into that.
308 00:31:50.090 ⇒ 00:31:56.479 Uttam Kumaran: So I would the stuff that’s like gross margin like this sort of easy stuff. I feel I’m more like and throw that to anybody.
309 00:31:56.810 ⇒ 00:31:59.190 Payas Parab: That’s that’s what like I like. That’s the other.
310 00:31:59.190 ⇒ 00:32:03.030 Uttam Kumaran: I wanna put you in like the harder situation because the other people can’t handle.
311 00:32:03.030 ⇒ 00:32:09.690 Payas Parab: Also, it was like those like harder data, science projects like, I jumped on that. And it took like from my estimated 6 h. It actually took
312 00:32:09.840 ⇒ 00:32:13.400 Payas Parab: 11. But, like we match 35,000 customers.
313 00:32:13.400 ⇒ 00:32:13.730 Uttam Kumaran: Yeah.
314 00:32:13.730 ⇒ 00:32:22.070 Payas Parab: Them like, and he still hasn’t responded, because maybe it’s just like there’s a lot to digest there. But, like I know, for a fact, we’ve solved a very serious problem for them.
315 00:32:22.070 ⇒ 00:32:22.520 Uttam Kumaran: Yeah.
316 00:32:23.070 ⇒ 00:32:26.250 Payas Parab: And even though we haven’t gotten a response or feedback yet like
317 00:32:26.540 ⇒ 00:32:29.509 Payas Parab: that’s not a like. It wasn’t a trivial thing at all. I know.
318 00:32:29.510 ⇒ 00:32:34.340 Uttam Kumaran: No, maybe I’m gonna send something to to them. I’m gonna send something to. I’m on right now. Maybe.
319 00:32:35.210 ⇒ 00:32:40.900 Payas Parab: Just be like, Hey, is there any feedback on that or anything? Because, like, we did work hard on that? And we think that’s high value.
320 00:32:45.280 ⇒ 00:32:50.090 Payas Parab: Yeah, my, my thing is like those those projects make more sense. And some of these, like small
321 00:32:50.340 ⇒ 00:32:54.930 Payas Parab: execution on my dashboard, things that just kind of like get pushed aside. Does that make sense like, you know, like.
322 00:32:54.930 ⇒ 00:32:57.840 Uttam Kumaran: Yeah. Oh, but Justin responded, today, right?
323 00:32:57.840 ⇒ 00:33:05.330 Payas Parab: Just responded to the other one, and he’s just like, Oh, there’s a couple of 100 matches since a certain date, and I was like, I don’t fully get it. But it looks like, Yeah, that’s right.
324 00:33:05.550 ⇒ 00:33:07.370 Payas Parab: if that’s what you’re going for. But
325 00:33:07.500 ⇒ 00:33:12.589 Payas Parab: the new data set should have like a truly stupid, more amount of matches, so you can have.
326 00:33:12.590 ⇒ 00:33:13.700 Uttam Kumaran: Okay. Okay. Okay.
327 00:33:13.700 ⇒ 00:33:24.899 Payas Parab: Like. There’s 35,000 unique names of customers that were matched, which is like far beyond. Like. I remember, Brian took a stab at this like months ago, and we got like a couple of 100. Maybe
328 00:33:26.660 ⇒ 00:33:29.489 Payas Parab: they also have, like scaled up their Amazon business recently.
329 00:33:30.140 ⇒ 00:33:35.910 Payas Parab: So there’s a lot of people who are probably ordering it on Amazon. Now that it’s available on Amazon. So they’re trying to figure this out.
330 00:33:41.500 ⇒ 00:33:43.260 Payas Parab: You send them on just like a bump.
331 00:33:44.180 ⇒ 00:33:45.020 Uttam Kumaran: Yeah.
332 00:33:53.280 ⇒ 00:33:54.470 Payas Parab: I would just DM him.
333 00:33:55.650 ⇒ 00:33:58.560 Uttam Kumaran: I just put them in, put it in the the channel.
334 00:33:58.900 ⇒ 00:33:59.510 Payas Parab: Okay.
335 00:34:04.530 ⇒ 00:34:05.250 Payas Parab: Okay.
336 00:34:06.530 ⇒ 00:34:10.670 Uttam Kumaran: Okay, it looks like this. It looks like you’re good on this. So let’s I’ll just.
337 00:34:11.204 ⇒ 00:34:11.729 Payas Parab: Yeah.
338 00:34:12.049 ⇒ 00:34:18.499 Payas Parab: as long as it’s in problem, let me just make sure that field is just key, because that’s exactly what he wants. For whatever reason
339 00:34:20.219 ⇒ 00:34:21.759 Uttam Kumaran: Yeah, it looks like it’s there.
340 00:34:22.500 ⇒ 00:34:25.530 Payas Parab: Excellent. Let me just double check the database, too, because yeah.
341 00:34:29.123 ⇒ 00:34:30.739 Payas Parab: back to what it is.
342 00:34:31.810 ⇒ 00:34:36.390 Payas Parab: Okay, customer subscribe.
343 00:34:37.190 ⇒ 00:34:38.679 Payas Parab: I’ll just have to reset
344 00:35:08.770 ⇒ 00:35:11.079 Payas Parab: you ever also, like, ever get this where you like.
345 00:35:11.430 ⇒ 00:35:16.999 Payas Parab: you procrastinate on the easy things. And that’s like the hard shit you’re like. I’m gonna figure this out right now. I feel like I’ve been.
346 00:35:17.000 ⇒ 00:35:21.009 Uttam Kumaran: Oh, yeah, I mean it. I it’s just for me. This is like
347 00:35:21.730 ⇒ 00:35:30.699 Uttam Kumaran: the the last 4 days I’ve been working like 15 h days like this. This mode is like, I just do as much as I can. I mean, sometimes it’s basically me versus like.
348 00:35:31.590 ⇒ 00:35:37.910 Uttam Kumaran: I mean, you know, like you work 10 h, they start like the brain isn’t like. It’s hard for me to do the hard thing.
349 00:35:37.910 ⇒ 00:35:38.510 Payas Parab: Yeah.
350 00:35:38.510 ⇒ 00:35:46.529 Uttam Kumaran: Also, it’s hard to develop like I can’t develop in like 15 min increments between meetings like it takes me 20 fucking minutes to sit here and be like
351 00:35:46.760 ⇒ 00:35:51.680 Uttam Kumaran: what? What the fuck am I like looking at? And then I can start to work. So
352 00:35:51.970 ⇒ 00:35:56.489 Uttam Kumaran: it’s tough, like I I’m I’m really efficient at the data work.
353 00:35:56.760 ⇒ 00:36:00.699 Uttam Kumaran: but I don’t have, like the large blocks.
354 00:36:01.106 ⇒ 00:36:06.440 Uttam Kumaran: which is which is a tough part, but kind of moving out of some other stuff. So let’s see.
355 00:36:11.030 ⇒ 00:36:17.110 Payas Parab: And what do we call it? Customer type, customer, subscription, text.
356 00:36:17.110 ⇒ 00:36:22.150 Uttam Kumaran: Subscription. Yeah, subscription customer category.
357 00:36:39.410 ⇒ 00:36:45.210 Payas Parab: Oh, looks like it hasn’t loaded in. But I just reset one of these.
358 00:36:46.420 ⇒ 00:36:49.000 Payas Parab: Oh, back orders.
359 00:37:17.480 ⇒ 00:37:19.749 Payas Parab: I don’t think it’s updated yet.
360 00:37:21.810 ⇒ 00:37:24.229 Uttam Kumaran: And prod Mart’s fact orders.
361 00:37:25.420 ⇒ 00:37:27.590 Payas Parab: Fraud marks, fact orders.
362 00:37:28.180 ⇒ 00:37:30.470 Uttam Kumaran: Prod marts, marts, fact orders.
363 00:37:32.850 ⇒ 00:37:35.069 Payas Parab: Not yet not in metabase.
364 00:37:36.570 ⇒ 00:37:37.839 Uttam Kumaran: What the fuck does that mean?
365 00:37:38.390 ⇒ 00:37:40.769 Payas Parab: There’s there’s sort of like there’s a little bit of a lag.
366 00:37:41.120 ⇒ 00:37:41.820 Uttam Kumaran: Oh!
367 00:37:42.317 ⇒ 00:37:45.929 Payas Parab: I can try. There’s basically like this thing you can do you like reset.
368 00:37:47.000 ⇒ 00:37:49.519 Uttam Kumaran: Do you know, can you confirm which table is looking at.
369 00:37:52.190 ⇒ 00:37:53.150 Payas Parab: Yeah.
370 00:37:55.520 ⇒ 00:38:03.500 Payas Parab: So this pulls in everything from I can share my screen. It’s pulling everything in from analytics.
371 00:38:10.590 ⇒ 00:38:17.660 Payas Parab: can be snowflake analytics. And then I’m pulling in
372 00:38:18.710 ⇒ 00:38:21.390 Payas Parab: everything so like it kind of shows you.
373 00:38:26.930 ⇒ 00:38:27.760 Payas Parab: we’ll see.
374 00:38:28.180 ⇒ 00:38:37.420 Payas Parab: Yeah, like, you’ll see here, it’s like pulling in specifically everything in analytics.
375 00:38:38.700 ⇒ 00:38:40.450 Uttam Kumaran: In analytics. Wait! What?
376 00:38:41.400 ⇒ 00:38:42.280 Payas Parab: Yeah. Wait a minute.
377 00:38:42.860 ⇒ 00:38:43.460 Uttam Kumaran: Wait.
378 00:38:45.620 ⇒ 00:38:51.800 Uttam Kumaran: yeah, switch out of analytics. Can you have it switch to a different database? Or is that easy to do.
379 00:38:52.555 ⇒ 00:38:52.960 Payas Parab: Shit.
380 00:38:57.140 ⇒ 00:38:59.362 Uttam Kumaran: Like? Can you have it? Look at
381 00:39:00.510 ⇒ 00:39:02.719 Payas Parab: Can you have a look at Prod Marts?
382 00:39:03.080 ⇒ 00:39:05.290 Uttam Kumaran: All caps prod underscore Martz.
383 00:39:05.850 ⇒ 00:39:08.159 Payas Parab: Row underscore loads. Okay?
384 00:39:10.150 ⇒ 00:39:13.269 Uttam Kumaran: Will you? Will. Will you need to like, do anything on your end?
385 00:39:14.560 ⇒ 00:39:17.379 Payas Parab: Let me just set this up as a new one, just to be safe.
386 00:39:19.030 ⇒ 00:39:22.259 Payas Parab: That one was like syncing correctly. So I don’t know
387 00:39:30.540 ⇒ 00:39:36.820 Payas Parab: it should just be. I just always forget these settings. We just need to grab sure.
388 00:39:36.820 ⇒ 00:39:42.280 Uttam Kumaran: You can also just like clone it into there. If you just wanted to handle that now. And we can just like not worry about this right now.
389 00:39:46.850 ⇒ 00:39:51.899 Payas Parab: I think this should be doable as long as it’s the database name is prod underscore marks.
390 00:39:51.900 ⇒ 00:39:55.320 Payas Parab: Underscore Martz. Everything else the same.
391 00:39:56.250 ⇒ 00:39:57.470 Payas Parab: Just give that a rip.
392 00:40:16.330 ⇒ 00:40:18.730 Payas Parab: It could be service user and database
393 00:40:26.830 ⇒ 00:40:28.220 Payas Parab: warehouses.
394 00:40:40.900 ⇒ 00:40:42.839 Payas Parab: What is the warehouse name? Again? It’s.
395 00:40:43.600 ⇒ 00:40:49.879 Uttam Kumaran: It’s just warehouse reports warehouse underscore report.
396 00:40:51.420 ⇒ 00:40:54.970 Payas Parab: Warehouse underscore report.
397 00:40:56.010 ⇒ 00:40:59.140 Payas Parab: Database name is prods prod underscore months.
398 00:41:26.330 ⇒ 00:41:27.719 Payas Parab: Hold on everything else.
399 00:41:42.120 ⇒ 00:41:42.920 Payas Parab: Oh.
400 00:41:43.410 ⇒ 00:41:48.510 Payas Parab: if the password is the service user, but soon we’re gonna have to change that. But we can fix that when it comes here.
401 00:41:50.940 ⇒ 00:41:52.679 Uttam Kumaran: Yeah, let me know if if you need that.
402 00:41:52.680 ⇒ 00:41:56.030 Payas Parab: Prod underscore marts. Database is incorrect.
403 00:41:59.847 ⇒ 00:42:02.269 Uttam Kumaran: It says incorrect.
404 00:42:03.190 ⇒ 00:42:05.219 Payas Parab: Yeah, it looks like database name is incorrect.
405 00:42:11.070 ⇒ 00:42:15.493 Uttam Kumaran: Oh, one sec. Okay, I’m just gonna give you. I’m just gonna clone it.
406 00:42:17.470 ⇒ 00:42:18.740 Payas Parab: Into the other one.
407 00:42:19.100 ⇒ 00:42:19.900 Uttam Kumaran: Yeah.
408 00:42:20.380 ⇒ 00:42:21.540 Payas Parab: That’s that’s fine.
409 00:42:25.740 ⇒ 00:42:29.760 Payas Parab: There was something weird that had to be. Nico figured it out so we can.
410 00:42:29.980 ⇒ 00:42:31.669 Payas Parab: Then she rely on him. But in the.
411 00:42:32.710 ⇒ 00:42:35.449 Payas Parab: I guess analytics. Can you just clone that in there? Then.
412 00:42:35.930 ⇒ 00:42:36.630 Uttam Kumaran: Yeah.
413 00:42:37.300 ⇒ 00:42:38.450 Payas Parab: And then hopefully, not.
414 00:42:58.360 ⇒ 00:42:59.260 Uttam Kumaran: Okay.
415 00:42:59.260 ⇒ 00:42:59.680 Payas Parab: 5, 10.
416 00:42:59.680 ⇒ 00:43:00.370 Uttam Kumaran: You’re good.
417 00:43:31.950 ⇒ 00:43:35.649 Payas Parab: okay, some of them are working. I think they’re just one fact orders is
418 00:43:36.320 ⇒ 00:43:38.420 Payas Parab: it’s getting an error with order number.
419 00:43:40.230 ⇒ 00:43:44.429 Uttam Kumaran: Was, oh, yeah, you you have to. There’s no order number.
420 00:43:44.430 ⇒ 00:43:49.460 Payas Parab: Oh, so yeah, let me yeah.
421 00:43:49.840 ⇒ 00:43:52.270 Payas Parab: Sync banners, it’s free.
422 00:44:01.850 ⇒ 00:44:03.280 Payas Parab: We’re cooking with gas.
423 00:44:04.450 ⇒ 00:44:11.420 Payas Parab: Alright, this is nice. This is like nice and clean to follow. Too excellent. Okay, awesome.
424 00:44:11.630 ⇒ 00:44:12.740 Payas Parab: Thank you, Tom.
425 00:44:13.230 ⇒ 00:44:16.259 Uttam Kumaran: Alright dude. Yeah, let me know you’d be what you need. I’ll be up.
426 00:44:16.670 ⇒ 00:44:28.839 Payas Parab: Awesome. Yeah, I’m gonna try and get this all done tonight. Give it something we can review in the morning, and then just something we can fire out just as like a we’re moving along here. And I’m I’m just gonna like I’m just gonna go like, I’m curious on.
427 00:44:29.030 ⇒ 00:44:32.719 Payas Parab: just like humble like, just blow them up with charts. Now, at this point.
428 00:44:32.720 ⇒ 00:44:33.200 Uttam Kumaran: Yeah.
429 00:44:33.320 ⇒ 00:44:41.979 Payas Parab: I have something. It’s like, there’s like 8 tabs. And like 9 different fucking charts. And I’m like, I was just like, so like we gotta get the accuracy right? We gotta get this right. And now I’m like, you know.
430 00:44:41.980 ⇒ 00:44:46.509 Uttam Kumaran: No, no, get something else first.st There’s there’s gonna be a million questions, no matter what we do. So.
431 00:44:46.510 ⇒ 00:44:51.349 Payas Parab: Agreed. That was, that was a bit of a misstep on my part. But here we are, sweet.
432 00:44:51.810 ⇒ 00:44:55.400 Payas Parab: alright dude. Thank you, man, appreciate it. Have a good night. Try and get some sleep time.
433 00:44:55.660 ⇒ 00:44:57.330 Uttam Kumaran: Yeah. Well, thanks.