Meeting Title: BF <> Brian Date: 2024-06-10 Meeting participants: Brian Pei, Uttam Kumaran
WEBVTT
1 00:00:27.590 ⇒ 00:00:29.639 Brian Pei: Does the opponent have a chill? I don’t know what.
2 00:00:29.850 ⇒ 00:00:30.520 Brian Pei: Keep this.
3 00:03:44.550 ⇒ 00:03:45.125 Uttam Kumaran: Hello!
4 00:03:47.790 ⇒ 00:03:49.279 Brian Pei: You just weren’t going to let me
5 00:03:49.300 ⇒ 00:03:51.680 Brian Pei: do an intro had to ask for it.
6 00:03:52.672 ⇒ 00:03:55.560 Uttam Kumaran: Well, I thought I’d do it. I thought you know all these people.
7 00:03:56.010 ⇒ 00:03:58.110 Brian Pei: I don’t know any of these people.
8 00:03:58.110 ⇒ 00:04:00.960 Uttam Kumaran: Oh, okay, sorry. I thought you already worked with some of these guns.
9 00:04:01.180 ⇒ 00:04:06.360 Brian Pei: I worked with one guy who subsequently left your company.
10 00:04:06.880 ⇒ 00:04:09.706 Uttam Kumaran: Oh, yeah, yeah, he’s he was not great.
11 00:04:10.060 ⇒ 00:04:11.629 Brian Pei: He talked a lot.
12 00:04:11.950 ⇒ 00:04:18.099 Brian Pei: He was very, sir. He reminded me of Austin Slaky. He was like a surfer Bro, who started to do tech stuff.
13 00:04:18.550 ⇒ 00:04:22.549 Uttam Kumaran: Yeah, he just got frustrated really easily and and honestly wouldn’t listen to me.
14 00:04:23.520 ⇒ 00:04:28.483 Brian Pei: And then one of the guys on the meeting looks like the guy from Ted Lasso who says football is life
15 00:04:29.020 ⇒ 00:04:30.100 Brian Pei: that’s cool.
16 00:04:31.810 ⇒ 00:04:34.826 Brian Pei: Never met Patrick. He seems
17 00:04:36.012 ⇒ 00:04:39.809 Brian Pei: like Weinberg, but mostly because he said he worked on the Biden campaign.
18 00:04:40.600 ⇒ 00:04:41.740 Uttam Kumaran: Yeah, yeah, yeah.
19 00:04:42.410 ⇒ 00:04:43.360 Uttam Kumaran: yeah, that’s like.
20 00:04:43.360 ⇒ 00:04:44.769 Brian Pei: That. But yeah, I haven’t heard that.
21 00:04:44.770 ⇒ 00:04:46.690 Uttam Kumaran: Yeah. Back through Wallenberg.
22 00:04:48.830 ⇒ 00:04:51.209 Brian Pei: Probably a Weinberg who’s less jaded about
23 00:04:51.240 ⇒ 00:04:52.620 Brian Pei: living life
24 00:04:55.800 ⇒ 00:04:59.170 Brian Pei: because Weinberg is jaded about everything and doesn’t want to do it.
25 00:05:00.930 ⇒ 00:05:05.330 Uttam Kumaran: Yeah, Patrick is actually good. I think it’s like, I think, Patrick.
26 00:05:05.470 ⇒ 00:05:09.009 Uttam Kumaran: he’s got a de stuff, and I kind of just wanted to fucking own that.
27 00:05:10.050 ⇒ 00:05:10.950 Brian Pei: That’s great. No.
28 00:05:10.950 ⇒ 00:05:12.560 Uttam Kumaran: Nastiest stuff.
29 00:05:13.190 ⇒ 00:05:14.889 Brian Pei: No one likes to do the setup shit.
30 00:05:18.730 ⇒ 00:05:19.490 Brian Pei: Oh, so
31 00:05:19.980 ⇒ 00:05:20.710 Brian Pei: rogue.
32 00:05:21.180 ⇒ 00:05:27.170 Brian Pei: hey? Good job! On actually making notion seem viable. Never seen that before.
33 00:05:27.730 ⇒ 00:05:29.979 Uttam Kumaran: Thanks! I, fucking hate this.
34 00:05:30.530 ⇒ 00:05:31.140 Brian Pei: Yeah.
35 00:05:31.340 ⇒ 00:05:36.560 Uttam Kumaran: I don’t know what it well, like dude I’m I’m like, I’m trying my best to like, have as little
36 00:05:36.640 ⇒ 00:05:40.899 Uttam Kumaran: process as possible. But also, this stuff is actually more for the clients than us.
37 00:05:41.306 ⇒ 00:05:46.469 Uttam Kumaran: Cause I don’t. I don’t give a fuck about like if you know what the objectives are like.
38 00:05:46.800 ⇒ 00:05:49.529 Uttam Kumaran: you know, you’ll kind of get the you’ll kind of get it. But like
39 00:05:49.540 ⇒ 00:05:52.850 Uttam Kumaran: I main mainly the clients are so disorganized sometimes
40 00:05:53.230 ⇒ 00:05:53.885 Uttam Kumaran: that
41 00:05:54.760 ⇒ 00:05:57.870 Uttam Kumaran: I kinda wanna come across like we’re super organized.
42 00:05:58.650 ⇒ 00:05:59.459 Uttam Kumaran: That’s g-.
43 00:05:59.460 ⇒ 00:06:00.300 Brian Pei: Me and Eddie.
44 00:06:00.540 ⇒ 00:06:03.430 Uttam Kumaran: Continue to build 3 or 6 months of backlog.
45 00:06:04.780 ⇒ 00:06:07.839 Brian Pei: Your your company is propped up by pool parts
46 00:06:08.150 ⇒ 00:06:09.189 Brian Pei: right now.
47 00:06:09.190 ⇒ 00:06:13.410 Uttam Kumaran: The company is propped up by pool parts, but we have 2. We have 2 good clients
48 00:06:13.560 ⇒ 00:06:14.440 Uttam Kumaran: saw.
49 00:06:14.730 ⇒ 00:06:15.680 Uttam Kumaran: I’m happy.
50 00:06:18.400 ⇒ 00:06:20.200 Uttam Kumaran: We’re doing a lot for pool parts.
51 00:06:22.320 ⇒ 00:06:23.250 Brian Pei: And then
52 00:06:23.920 ⇒ 00:06:31.190 Brian Pei: I think I have all my stuff set up. Yeah, I’m getting a new macbook, because not having a screen or a camera on my personal is,
53 00:06:31.460 ⇒ 00:06:32.470 Uttam Kumaran: Drop it.
54 00:06:33.510 ⇒ 00:06:35.240 Brian Pei: Well, remember, I told you like
55 00:06:35.300 ⇒ 00:06:38.640 Brian Pei: my camera. I kept having to turn it off because this
56 00:06:38.910 ⇒ 00:06:40.780 Brian Pei: screens. But this was like months ago
57 00:06:40.940 ⇒ 00:06:44.970 Brian Pei: I bought like an external monitor, but now I’m home, and so I don’t have an external monitor.
58 00:06:44.970 ⇒ 00:06:46.819 Uttam Kumaran: Oh, you’re in Vegas!
59 00:06:48.030 ⇒ 00:06:49.250 Brian Pei: Oh, yeah, I’m in Vegas.
60 00:06:49.250 ⇒ 00:06:50.829 Uttam Kumaran: Yeah, yeah, yeah, okay, okay.
61 00:06:55.660 ⇒ 00:06:58.400 Brian Pei: So I’m gonna get an I I’m gonna get the air.
62 00:06:58.560 ⇒ 00:06:59.130 Brian Pei: fuck it.
63 00:06:59.388 ⇒ 00:07:01.459 Uttam Kumaran: Nice. Yeah. The New Year is good. Dude.
64 00:07:01.810 ⇒ 00:07:06.699 Brian Pei: Yeah, I don’t need the Macbook pro. And then I’m buying my dad an iphone 15 for his birthday.
65 00:07:06.920 ⇒ 00:07:08.190 Uttam Kumaran: Oh, nice!
66 00:07:10.360 ⇒ 00:07:16.044 Brian Pei: Alright. Let’s see. Let me. I’m gonna share something. What am I gonna share? I’m gonna share this.
67 00:07:16.360 ⇒ 00:07:19.009 Uttam Kumaran: Just make sure you’re all set up on everything.
68 00:07:21.836 ⇒ 00:07:25.310 Brian Pei: I got the get, and then I’m going to
69 00:07:25.920 ⇒ 00:07:29.980 Brian Pei: run a dbt. Compile to make sure that I’m hooked up.
70 00:07:30.770 ⇒ 00:07:37.060 Brian Pei: and that should be all I need. I mean I can. If I have get I mean I can. I can make prs and merge things already.
71 00:07:37.348 ⇒ 00:07:40.029 Brian Pei: And but good to be able to test the code.
72 00:07:40.720 ⇒ 00:07:43.729 Brian Pei: and I was looking at.
73 00:07:45.490 ⇒ 00:07:46.660 Brian Pei: See?
74 00:07:49.420 ⇒ 00:07:50.540 Brian Pei: Oh, God, damn
75 00:07:55.460 ⇒ 00:07:57.840 Brian Pei: fuck is evidence! Dbt, project
76 00:07:58.570 ⇒ 00:07:59.320 Brian Pei: owls
77 00:08:00.750 ⇒ 00:08:02.640 Brian Pei: got a bunch of test tests.
78 00:08:05.426 ⇒ 00:08:07.773 Brian Pei: Look at these directories.
79 00:08:08.520 ⇒ 00:08:09.340 Uttam Kumaran: S.
80 00:08:09.910 ⇒ 00:08:12.259 Brian Pei: Ship station. I remember. Ship station
81 00:08:14.200 ⇒ 00:08:15.220 Brian Pei: cool.
82 00:08:18.810 ⇒ 00:08:22.410 Brian Pei: Yeah, this is great. Your your Ocd is really coming in. Clutch. Here.
83 00:08:25.290 ⇒ 00:08:28.270 Brian Pei: What’s the most important table? Again? Something orders.
84 00:08:28.850 ⇒ 00:08:29.780 Uttam Kumaran: All orders.
85 00:08:30.500 ⇒ 00:08:31.690 Brian Pei: Is that in reporting.
86 00:08:32.150 ⇒ 00:08:32.740 Uttam Kumaran: Yep.
87 00:08:34.720 ⇒ 00:08:35.520 Brian Pei: Sweet
88 00:08:36.150 ⇒ 00:08:38.000 Brian Pei: this is this is great!
89 00:08:39.000 ⇒ 00:08:42.360 Uttam Kumaran: Yeah, the big thing is, if you can, you go to projects. And Github.
90 00:08:44.520 ⇒ 00:08:45.889 Brian Pei: Like the like, the
91 00:08:46.040 ⇒ 00:08:47.396 Brian Pei: oh in github
92 00:08:52.100 ⇒ 00:08:54.859 Brian Pei: in pull parts, or do you? All this stuff.
93 00:08:55.760 ⇒ 00:08:56.430 Uttam Kumaran: And
94 00:08:57.510 ⇒ 00:09:01.380 Uttam Kumaran: and and it’s just to be at the top. There should be a thing called projects.
95 00:09:02.630 ⇒ 00:09:03.310 Brian Pei: Oh!
96 00:09:03.310 ⇒ 00:09:03.860 Uttam Kumaran: Yeah.
97 00:09:04.010 ⇒ 00:09:05.060 Uttam Kumaran: The top one
98 00:09:05.660 ⇒ 00:09:06.770 Uttam Kumaran: project tracker.
99 00:09:07.770 ⇒ 00:09:11.120 Brian Pei: What the I’ve never looked at projects before, what the.
100 00:09:11.415 ⇒ 00:09:13.780 Uttam Kumaran: On the left. Just click pool parts ago.
101 00:09:15.390 ⇒ 00:09:17.830 Uttam Kumaran: So these are all of our pool parts tickets.
102 00:09:21.880 ⇒ 00:09:22.530 Brian Pei: This.
103 00:09:25.230 ⇒ 00:09:28.759 Uttam Kumaran: And basically you, you should be assigned stuff.
104 00:09:29.190 ⇒ 00:09:29.980 Brian Pei: Sweet.
105 00:09:33.430 ⇒ 00:09:36.629 Brian Pei: This is bad. Okay, backlog. Let me see.
106 00:09:37.990 ⇒ 00:09:40.879 Brian Pei: I’ve never seen this before my entire life. This is cool.
107 00:09:42.860 ⇒ 00:09:45.370 Uttam Kumaran: They see, like we have everything as an issue.
108 00:09:45.710 ⇒ 00:09:48.139 Uttam Kumaran: And so you can create a branch directly from here.
109 00:09:49.360 ⇒ 00:09:50.100 Uttam Kumaran: and.
110 00:09:51.910 ⇒ 00:09:54.700 Brian Pei: So if I wanted to create a branch directly from here, what button do I press.
111 00:09:54.700 ⇒ 00:09:56.499 Uttam Kumaran: There already is a branch open.
112 00:09:56.750 ⇒ 00:09:58.800 Uttam Kumaran: So if you see development on the right.
113 00:10:00.620 ⇒ 00:10:02.290 Brian Pei: Development! Oh.
114 00:10:02.290 ⇒ 00:10:06.004 Uttam Kumaran: So that branch is already open, and I already have a pull request open.
115 00:10:07.128 ⇒ 00:10:11.070 Uttam Kumaran: But like this is what I need help with this one.
116 00:10:11.530 ⇒ 00:10:15.940 Uttam Kumaran: So, to give you a sense, I created this new shipments table.
117 00:10:17.970 ⇒ 00:10:18.869 Uttam Kumaran: Bring this shipment.
118 00:10:18.870 ⇒ 00:10:19.719 Brian Pei: And so I speak.
119 00:10:20.550 ⇒ 00:10:27.449 Uttam Kumaran: Yeah, I created this new table called shipments shipments. Basically, every order item is associated with a shipment.
120 00:10:27.790 ⇒ 00:10:30.849 Uttam Kumaran: But one order may have multiple shipments.
121 00:10:31.330 ⇒ 00:10:33.489 Uttam Kumaran: So you know, order. Item versus order, right.
122 00:10:34.020 ⇒ 00:10:35.070 Brian Pei: Yeah, yeah.
123 00:10:35.510 ⇒ 00:10:36.250 Uttam Kumaran: Yeah, it’s
124 00:10:36.540 ⇒ 00:10:37.159 Uttam Kumaran: it’s been.
125 00:10:37.160 ⇒ 00:10:40.569 Brian Pei: Line line items. And yeah, parent parent order.
126 00:10:40.570 ⇒ 00:10:41.220 Uttam Kumaran: So border.
127 00:10:41.220 ⇒ 00:10:41.600 Brian Pei: Yeah.
128 00:10:41.600 ⇒ 00:10:50.830 Uttam Kumaran: Each line item has to get shipped, but not every order may may. Every order can have multiple line items, which means an order can have one or more shipments
129 00:10:50.940 ⇒ 00:10:51.860 Uttam Kumaran: yo.
130 00:10:52.020 ⇒ 00:10:57.306 Uttam Kumaran: Previously I had all the shipment data in all orders, but of course that led to some dupes.
131 00:10:57.730 ⇒ 00:10:59.870 Uttam Kumaran: so I had to rip it out.
132 00:10:59.900 ⇒ 00:11:03.059 Uttam Kumaran: But this table is kind of fucking, complicated
133 00:11:03.260 ⇒ 00:11:06.170 Uttam Kumaran: in terms of like the logic. Sometimes
134 00:11:06.230 ⇒ 00:11:12.050 Uttam Kumaran: because I’m having to bring in specific logic from like every single shipment source.
135 00:11:15.490 ⇒ 00:11:17.589 Uttam Kumaran: and it’s honestly not a shade.
136 00:11:17.810 ⇒ 00:11:19.000 Brian Pei: Lt. L
137 00:11:19.110 ⇒ 00:11:20.570 Brian Pei: should ship station again.
138 00:11:20.570 ⇒ 00:11:23.330 Uttam Kumaran: So there’s 2 shop. There’s 2 there’s
139 00:11:23.520 ⇒ 00:11:27.809 Uttam Kumaran: there’s I mean it’s hold on, I mean, I mean, I should might as well just write this down right now.
140 00:11:30.350 ⇒ 00:11:31.710 Uttam Kumaran: hold on one sec.
141 00:11:34.870 ⇒ 00:11:35.600 Uttam Kumaran: Couple.
142 00:11:46.120 ⇒ 00:11:46.900 Brian Pei: Okay.
143 00:11:48.560 ⇒ 00:11:50.113 Uttam Kumaran: So there’s
144 00:11:50.980 ⇒ 00:11:52.020 Uttam Kumaran: There’s
145 00:11:52.100 ⇒ 00:12:02.340 Uttam Kumaran: multiple ways to ship from both Amazon and shopify. So if we talk about Amazon, Amazon goes straight through ship, station
146 00:12:02.720 ⇒ 00:12:05.580 Uttam Kumaran: and ship station goes
147 00:12:07.090 ⇒ 00:12:17.580 Uttam Kumaran: through like a number of different sources. Whether ups, Usps. Things like that shopify goes through either. Ltl.
148 00:12:17.700 ⇒ 00:12:20.759 Uttam Kumaran: which we’re switching to. This company called Primus.
149 00:12:21.020 ⇒ 00:12:23.329 Uttam Kumaran: It can go Unis.
150 00:12:23.550 ⇒ 00:12:24.430 Uttam Kumaran: which
151 00:12:24.560 ⇒ 00:12:26.980 Uttam Kumaran: is another company that basically
152 00:12:27.010 ⇒ 00:12:34.250 Uttam Kumaran: ships from 2 different warehouses, both California and Florida. And then it can go through ship station as well.
153 00:12:36.210 ⇒ 00:12:45.779 Uttam Kumaran: So you have Amazon. Ltl, you have ship state, you have shopify? Ltl, you then should have. I don’t think. Is there Amazon units. Can you control F for that.
154 00:12:49.645 ⇒ 00:12:49.960 Brian Pei: Up.
155 00:12:49.960 ⇒ 00:12:52.949 Uttam Kumaran: Pro Amazon premise is like Amazon v. Ltl.
156 00:12:53.320 ⇒ 00:12:57.390 Brian Pei: Yeah, you got Amazon prime is. That’s the new one that you added. I assume.
157 00:12:57.820 ⇒ 00:12:58.680 Brian Pei: sweet.
158 00:13:01.460 ⇒ 00:13:05.130 Uttam Kumaran: and then and then you also have just ship station for both.
159 00:13:05.200 ⇒ 00:13:12.349 Uttam Kumaran: So the thing is is like, if something gets shipped by, if something gets shipped by by Primus or Unus, it doesn’t show up
160 00:13:12.400 ⇒ 00:13:13.230 Uttam Kumaran: in
161 00:13:14.130 ⇒ 00:13:18.929 Uttam Kumaran: it shouldn’t show up in ship station, but the the way we have to get each
162 00:13:19.050 ⇒ 00:13:23.280 Uttam Kumaran: actual shipment is like, kind of weird between each 3. So there’s just a bunch of logic here.
163 00:13:23.908 ⇒ 00:13:29.610 Uttam Kumaran: Like, I don’t know whether it’s best to like we walk through this, or I kinda wanna let you just poke around and see it.
164 00:13:29.950 ⇒ 00:13:30.790 Uttam Kumaran: Girp.
165 00:13:30.790 ⇒ 00:13:31.490 Brian Pei: You know that.
166 00:13:32.000 ⇒ 00:13:32.620 Uttam Kumaran: Yeah.
167 00:13:34.222 ⇒ 00:13:39.549 Brian Pei: Okay. So one of them is reviewing your Pr
168 00:13:39.810 ⇒ 00:13:41.940 Brian Pei: and seeing if there is
169 00:13:43.390 ⇒ 00:13:48.740 Brian Pei: an easier way to get all the data, or just, I guess, making sure that this is everything is
170 00:13:49.440 ⇒ 00:13:50.270 Brian Pei: okay.
171 00:13:50.610 ⇒ 00:13:53.560 Brian Pei: Got it. So that’s shipments. Okay, shipment.
172 00:13:55.615 ⇒ 00:13:56.680 Brian Pei: Ship
173 00:13:57.130 ⇒ 00:13:57.960 Brian Pei: meant
174 00:13:58.390 ⇒ 00:14:04.549 Brian Pei: data model, okay? And then ice. And then, and then you made a shipping table that
175 00:14:05.310 ⇒ 00:14:09.330 Brian Pei: you’ll be able to join to the order item table. I assume in some capacity.
176 00:14:13.880 ⇒ 00:14:19.129 Uttam Kumaran: Yeah. So basically, I moved it. Yeah, I I want to shipments to be able to be leveraged
177 00:14:19.340 ⇒ 00:14:22.149 Uttam Kumaran: by Jacob for
178 00:14:22.190 ⇒ 00:14:23.960 Uttam Kumaran: analysis. Primarily.
179 00:14:24.480 ⇒ 00:14:25.570 Brian Pei: Okay, yeah.
180 00:14:28.660 ⇒ 00:14:29.710 Brian Pei: That’s a good.
181 00:14:29.710 ⇒ 00:14:30.543 Uttam Kumaran: Like. So if you could.
182 00:14:30.710 ⇒ 00:14:31.179 Brian Pei: That’s good.
183 00:14:31.180 ⇒ 00:14:32.490 Uttam Kumaran: Just get like
184 00:14:32.640 ⇒ 00:14:36.439 Uttam Kumaran: your head around how shipments works. That’ll save us a bunch of time.
185 00:14:37.007 ⇒ 00:14:43.910 Uttam Kumaran: That’s probably the that’s probably honestly, the 1st thing that you could look at. The second thing is some stuff in the backlog like.
186 00:14:44.000 ⇒ 00:14:45.372 Uttam Kumaran: why is there?
187 00:14:46.770 ⇒ 00:14:52.110 Uttam Kumaran: Why is there like wise? Has refund has nulls like there’s like shit like that that I’m like fuck. I don’t know.
188 00:14:53.400 ⇒ 00:14:55.960 Brian Pei: Why does has refunds have north of it?
189 00:14:56.020 ⇒ 00:14:58.259 Brian Pei: Wait? Where’s this backlog backlog?
190 00:14:58.710 ⇒ 00:14:59.770 Brian Pei: Or look at that.
191 00:14:59.770 ⇒ 00:15:00.520 Uttam Kumaran: This week.
192 00:15:02.530 ⇒ 00:15:03.870 Brian Pei: Sorry what you broke up.
193 00:15:03.870 ⇒ 00:15:05.420 Uttam Kumaran: Looking ready this week.
194 00:15:06.148 ⇒ 00:15:08.619 Uttam Kumaran: And click on pool parts on the left.
195 00:15:17.150 ⇒ 00:15:18.560 Brian Pei: I see. Okay.
196 00:15:20.540 ⇒ 00:15:24.310 Brian Pei: Una is. Patrick, my boy.
197 00:15:27.590 ⇒ 00:15:28.400 Brian Pei: okay.
198 00:15:31.930 ⇒ 00:15:33.410 Brian Pei: Refunds
199 00:15:34.620 ⇒ 00:15:38.980 Brian Pei: putting it on my personal checklist. Okay? And then let me see
200 00:15:39.620 ⇒ 00:15:43.199 Brian Pei: if I can still use this for compilation.
201 00:15:43.200 ⇒ 00:15:43.900 Uttam Kumaran: Yeah.
202 00:15:45.100 ⇒ 00:15:47.509 Brian Pei: That would be super sick.
203 00:15:48.740 ⇒ 00:15:49.550 Brian Pei: But
204 00:15:49.970 ⇒ 00:15:50.870 Brian Pei: what do you mean?
205 00:15:53.530 ⇒ 00:15:55.420 Brian Pei: Oh, the gipa! Oh, I see.
206 00:15:57.389 ⇒ 00:16:01.990 Brian Pei: Okay, you don’t have a i i have to set my! I have to set my own shit up. That’s fine.
207 00:16:02.520 ⇒ 00:16:04.455 Uttam Kumaran: Are you still in one password? Maybe it’s there.
208 00:16:08.427 ⇒ 00:16:10.462 Brian Pei: look away. Okay, stop share.
209 00:16:11.570 ⇒ 00:16:15.580 Brian Pei: because my password is literally on my desktop, and I just copy paste. It.
210 00:16:16.180 ⇒ 00:16:18.469 Uttam Kumaran: There is actually one here and see it.
211 00:16:21.280 ⇒ 00:16:22.840 Brian Pei: Oh, shit. Yeah. You’re right.
212 00:16:22.980 ⇒ 00:16:23.820 Uttam Kumaran: Oh, work!
213 00:16:24.730 ⇒ 00:16:27.539 Brian Pei: No, I just I mean, I have your email address.
214 00:16:27.750 ⇒ 00:16:28.450 Uttam Kumaran: Oh, nice!
215 00:16:28.970 ⇒ 00:16:29.910 Brian Pei: For
216 00:16:30.030 ⇒ 00:16:33.609 Brian Pei: Dbt. Cloud which you made public in your one pass. I believe.
217 00:16:33.610 ⇒ 00:16:34.530 Uttam Kumaran: Oh, nice!
218 00:16:38.680 ⇒ 00:16:40.940 Brian Pei: Okay. -Oh.
219 00:16:41.610 ⇒ 00:16:42.940 Brian Pei: me, reshare
220 00:16:52.760 ⇒ 00:16:54.170 Brian Pei: is this, wait.
221 00:16:54.710 ⇒ 00:16:59.230 Brian Pei: Th, this is okay to have X’s right. None of this is on. You’re you run everything through, get actions.
222 00:16:59.230 ⇒ 00:17:00.890 Uttam Kumaran: Yeah, everything should get actions.
223 00:17:01.300 ⇒ 00:17:04.850 Brian Pei: Okay? Oh, right, this is from February. Got it? Okay.
224 00:17:07.750 ⇒ 00:17:09.640 Brian Pei: let’s see if this is updated.
225 00:17:10.770 ⇒ 00:17:13.109 Brian Pei: Let’s see if they updated their ide at all.
226 00:17:19.630 ⇒ 00:17:22.170 Brian Pei: Let’s see sick. Okay.
227 00:17:22.900 ⇒ 00:17:25.409 Brian Pei: you have to
228 00:17:26.440 ⇒ 00:17:32.040 Brian Pei: re add whatever profile this is probably to get.
229 00:17:32.450 ⇒ 00:17:34.560 Brian Pei: Or I log in with my.
230 00:17:34.680 ⇒ 00:17:36.900 Brian Pei: okay, I’m not gonna do this on
231 00:17:40.220 ⇒ 00:17:41.879 Brian Pei: zoom with you, but
232 00:17:42.100 ⇒ 00:17:43.999 Brian Pei: might be able to do something with this.
233 00:17:44.690 ⇒ 00:17:49.830 Brian Pei: Okay, regardless I got snowflakes, so at least I can take
234 00:17:52.127 ⇒ 00:17:53.799 Brian Pei: pieces of your
235 00:17:54.440 ⇒ 00:17:56.279 Brian Pei: model, and just
236 00:17:56.960 ⇒ 00:17:59.189 Brian Pei: look at Snowflake shit!
237 00:18:04.220 ⇒ 00:18:05.380 Brian Pei: Oh.
238 00:18:07.470 ⇒ 00:18:10.949 Brian Pei: hey! Look! It’s me, Brian! Exclamation. Point cool.
239 00:18:11.340 ⇒ 00:18:12.260 Brian Pei: awesome.
240 00:18:12.530 ⇒ 00:18:14.340 Brian Pei: Oh, Patrick’s been in here.
241 00:18:15.500 ⇒ 00:18:16.990 Uttam Kumaran: I’ve maybe been in there.
242 00:18:17.270 ⇒ 00:18:18.190 Brian Pei: Okay.
243 00:18:18.640 ⇒ 00:18:20.939 Brian Pei: I wonder if there’s a limit to. Okay, whatever
244 00:18:21.250 ⇒ 00:18:23.239 Brian Pei: B. Pay.
245 00:18:23.900 ⇒ 00:18:24.980 Brian Pei: June
246 00:18:25.950 ⇒ 00:18:27.300 Brian Pei: 2024.
247 00:18:29.700 ⇒ 00:18:31.150 Brian Pei: Brian pay
248 00:18:31.430 ⇒ 00:18:32.580 Brian Pei: work sheet.
249 00:18:35.780 ⇒ 00:18:36.650 Brian Pei: Hi, man.
250 00:18:36.760 ⇒ 00:18:37.759 Brian Pei: I got you.
251 00:18:38.080 ⇒ 00:18:41.289 Brian Pei: Okay, this is the shit that I’ve done. It’s all good.
252 00:18:41.953 ⇒ 00:18:49.080 Uttam Kumaran: Yeah, shipments. So the one thing is, I wanna schedule a time between me, you and Jacob. To review shipments in rail
253 00:18:49.390 ⇒ 00:18:52.879 Uttam Kumaran: real is like the shiny new bi tool that I’m using for everybody.
254 00:18:54.770 ⇒ 00:18:57.260 Uttam Kumaran: so you said Wednesday is probably good.
255 00:18:59.971 ⇒ 00:19:03.339 Brian Pei: Yes, I’ll marking Wednesday, and then
256 00:19:03.900 ⇒ 00:19:09.220 Brian Pei: I mean, if you want to do it Friday, I can. I can pop on. My dad’s thing isn’t until night. I just
257 00:19:09.380 ⇒ 00:19:11.150 Brian Pei: have it off to
258 00:19:12.030 ⇒ 00:19:14.480 Brian Pei: chill with with the pops.
259 00:19:14.620 ⇒ 00:19:16.890 Uttam Kumaran: Are you gonna be looking at some shipment shit today?
260 00:19:17.860 ⇒ 00:19:21.790 Brian Pei: Yeah, yeah. My parents aren’t even home right now. I was just gonna
261 00:19:22.220 ⇒ 00:19:25.829 Brian Pei: check this, I mean, and your your shit’s not merged yet. Right? So there’s
262 00:19:26.070 ⇒ 00:19:26.800 Brian Pei: we can’t really.
263 00:19:26.800 ⇒ 00:19:30.120 Uttam Kumaran: There. The shipments model should be there.
264 00:19:31.044 ⇒ 00:19:33.890 Uttam Kumaran: But it probably doesn’t include Primus.
265 00:19:34.110 ⇒ 00:19:36.409 Uttam Kumaran: Actually, I don’t know. Chances. There actually.
266 00:19:37.350 ⇒ 00:19:40.909 Brian Pei: What would it be called? Mark
267 00:19:41.290 ⇒ 00:19:43.720 Brian Pei: artit? Nope, not not there.
268 00:19:45.300 ⇒ 00:19:47.519 Brian Pei: There is Dbt. Dvg. Dove.
269 00:19:48.270 ⇒ 00:19:53.070 Uttam Kumaran: If you go under dbt dot dB, like go to dB, go to Dbt.
270 00:19:54.590 ⇒ 00:19:57.120 Uttam Kumaran: DVD. Mark the underscore mark.
271 00:19:58.330 ⇒ 00:20:00.980 Brian Pei: Oh, man, this shit sucks! Oh, here you go!
272 00:20:00.980 ⇒ 00:20:03.440 Uttam Kumaran: I don’t know why the fuck, the other thing exists.
273 00:20:15.380 ⇒ 00:20:17.469 Brian Pei: Okay, you got ship station
274 00:20:23.570 ⇒ 00:20:24.520 Brian Pei: 8 here.
275 00:20:48.620 ⇒ 00:20:50.510 Brian Pei: Oh, sweet, this updated
276 00:20:50.700 ⇒ 00:20:52.100 Brian Pei: today. Okay.
277 00:20:53.380 ⇒ 00:20:54.580 Brian Pei: you got
278 00:20:55.120 ⇒ 00:20:59.590 Brian Pei: Amazon and shopify ship station, and then your Pr will add
279 00:21:00.610 ⇒ 00:21:02.890 Brian Pei: rim job, what is it called
280 00:21:03.450 ⇒ 00:21:05.390 Brian Pei: Primus and Unis. Okay.
281 00:21:06.860 ⇒ 00:21:08.080 Brian Pei: okay, yeah.
282 00:21:09.090 ⇒ 00:21:14.309 Brian Pei: sweet. I’ll take a look. Let me take a look at real real business intelligence.
283 00:21:18.555 ⇒ 00:21:21.390 Uttam Kumaran: I’m gonna add you, we already have real setup.
284 00:21:23.750 ⇒ 00:21:26.870 Uttam Kumaran: I’m using arc. By the way, for my browser, it’s kind of sick.
285 00:21:28.985 ⇒ 00:21:29.870 Brian Pei: Fuck is arc
286 00:21:30.530 ⇒ 00:21:33.469 Brian Pei: in memory. dB, holy shit!
287 00:21:35.090 ⇒ 00:21:38.910 Brian Pei: What did did real give you money or something? Why are you using real.
288 00:21:39.030 ⇒ 00:21:40.110 Uttam Kumaran: It’s sick.
289 00:21:40.450 ⇒ 00:21:41.649 Uttam Kumaran: It’s really good. Okay.
290 00:21:42.440 ⇒ 00:21:43.010 Brian Pei: Alright!
291 00:21:45.230 ⇒ 00:21:46.429 Uttam Kumaran: I will.
292 00:21:47.800 ⇒ 00:21:50.379 Uttam Kumaran: I’ll add you. But here’s the link.
293 00:21:52.160 ⇒ 00:21:55.689 Uttam Kumaran: Wait, let’s just do live, cause I’ll just make sure that you can get into here.
294 00:21:57.060 ⇒ 00:21:59.429 Brian Pei: Oh, sure! Are you sending it in slack.
295 00:22:00.080 ⇒ 00:22:01.679 Uttam Kumaran: I’m setting in slack. Yeah.
296 00:22:02.000 ⇒ 00:22:02.750 Brian Pei: Okay.
297 00:22:06.790 ⇒ 00:22:09.320 Uttam Kumaran: Actually go to notion. It’s in notion
298 00:22:13.140 ⇒ 00:22:14.870 Uttam Kumaran: it’s in the cool part’s homepage.
299 00:22:24.380 ⇒ 00:22:25.930 Uttam Kumaran: go to clients.
300 00:22:26.452 ⇒ 00:22:27.599 Brian Pei: Fuck my life.
301 00:22:27.620 ⇒ 00:22:28.560 Uttam Kumaran: Clients.
302 00:22:28.770 ⇒ 00:22:29.859 Uttam Kumaran: We’ll go ahead.
303 00:22:30.810 ⇒ 00:22:31.843 Uttam Kumaran: And then, do you see?
304 00:22:32.760 ⇒ 00:22:35.400 Uttam Kumaran: Oh, fuck! You don’t say no?
305 00:22:36.140 ⇒ 00:22:39.243 Uttam Kumaran: Oh, yeah, cause we haven’t done it yet. Okay, I’m not clear. I’m just not.
306 00:22:39.850 ⇒ 00:22:41.499 Brian Pei: Be like dash right now.
307 00:22:44.260 ⇒ 00:22:45.569 Uttam Kumaran: I slacked it to you.
308 00:22:46.770 ⇒ 00:22:47.710 Uttam Kumaran: No, I’m just coming on.
309 00:22:47.710 ⇒ 00:22:48.710 Brian Pei: Elementary.
310 00:22:48.830 ⇒ 00:22:51.519 Brian Pei: Oh, you use elementary isn’t elementary, like
311 00:22:52.260 ⇒ 00:22:53.600 Brian Pei: dog shit. Oh, hang on.
312 00:22:53.600 ⇒ 00:22:56.200 Uttam Kumaran: It’s for observability. No, it’s actually pretty good.
313 00:22:57.770 ⇒ 00:23:00.399 Brian Pei: Bulk observability. Okay, continue with Google.
314 00:23:02.110 ⇒ 00:23:03.080 Brian Pei: Boom.
315 00:23:04.030 ⇒ 00:23:05.629 Uttam Kumaran: It’s probably not gonna work.
316 00:23:06.790 ⇒ 00:23:07.610 Brian Pei: Continue.
317 00:23:10.310 ⇒ 00:23:11.280 Brian Pei: continue.
318 00:23:14.880 ⇒ 00:23:16.460 Uttam Kumaran: Let me make sure you get, added.
319 00:23:20.890 ⇒ 00:23:21.500 Brian Pei: Go.
320 00:23:31.440 ⇒ 00:23:32.180 Uttam Kumaran: Yep.
321 00:23:33.110 ⇒ 00:23:34.250 Brian Pei: I’ve public.
322 00:23:35.790 ⇒ 00:23:38.050 Brian Pei: So yeah, Sm, I just have to get added.
323 00:23:44.970 ⇒ 00:23:46.860 Uttam Kumaran: Oh, yeah, I don’t know what the fuck this is.
324 00:23:47.530 ⇒ 00:23:50.270 Brian Pei: This is the their public
325 00:23:50.900 ⇒ 00:23:52.960 Brian Pei: space. I was just looking at it.
326 00:23:54.780 ⇒ 00:23:57.159 Brian Pei: City bike. Wikipedia.
327 00:27:44.440 ⇒ 00:27:45.270 Brian Pei: the heck!
328 00:28:08.300 ⇒ 00:28:10.416 Brian Pei: What’s up, man? I’m hungry.
329 00:28:11.377 ⇒ 00:28:15.012 Uttam Kumaran: Okay, maybe I have to get back to you because this is not working right now.
330 00:28:17.030 ⇒ 00:28:20.680 Uttam Kumaran: But either way, it’s like a, it’s a cool bi tool. I’ll send it to you.
331 00:28:21.120 ⇒ 00:28:22.560 Brian Pei: There’s just no.
332 00:28:22.700 ⇒ 00:28:25.020 Uttam Kumaran: It doesn’t look like this at all. This is some old shit.
333 00:28:27.150 ⇒ 00:28:30.799 Uttam Kumaran: Here, let me see if I can. Are you in one password?
334 00:28:32.310 ⇒ 00:28:34.060 Brian Pei: Yeah, but I feel like you
335 00:28:34.210 ⇒ 00:28:39.399 Brian Pei: do. You should just have an account admin for real and just you could just add my email, now, am I crazy.
336 00:28:39.400 ⇒ 00:28:42.773 Uttam Kumaran: Yeah, I’m doing that. But I’m it’s just like there’s something.
337 00:28:56.690 ⇒ 00:28:58.080 Brian Pei: Have you seen this new.
338 00:28:59.590 ⇒ 00:29:01.680 Brian Pei: this, this good, this good shit.
339 00:29:01.840 ⇒ 00:29:04.289 Uttam Kumaran: Yeah, I’ve seen that. I I built that one
340 00:29:06.070 ⇒ 00:29:07.380 Uttam Kumaran: about all that.
341 00:29:08.830 ⇒ 00:29:09.725 Brian Pei: And
342 00:29:16.350 ⇒ 00:29:19.529 Brian Pei: well, they’re hiring a ded senior sales and Enterprise engine.
343 00:29:19.730 ⇒ 00:29:20.860 Brian Pei: Bdr.
344 00:29:21.060 ⇒ 00:29:22.150 Brian Pei: I’m gonna apply.
345 00:29:25.750 ⇒ 00:29:27.050 Brian Pei: Look as a Bdr.
346 00:30:14.460 ⇒ 00:30:15.489 Uttam Kumaran: Added it.
347 00:30:16.580 ⇒ 00:30:17.680 Uttam Kumaran: check your email.
348 00:30:19.190 ⇒ 00:30:21.049 Brian Pei: Wait one second. I want to see what the top
349 00:30:21.130 ⇒ 00:30:25.450 Brian Pei: be. It tools in 2023 are Ibm cognos, looker.
350 00:30:25.550 ⇒ 00:30:29.859 Brian Pei: oracle, gross power, bi, disgusting click view trash.
351 00:30:30.890 ⇒ 00:30:33.099 Brian Pei: Sas via never heard of it. Tableau
352 00:30:33.350 ⇒ 00:30:35.890 Brian Pei: spot fire. Yeah, often. Okay.
353 00:30:36.650 ⇒ 00:30:40.510 Brian Pei: Didn’t see real in there. That’s fine. It’s kidding alright. Here we go.
354 00:30:44.430 ⇒ 00:30:46.260 Uttam Kumaran: No, no, go to the go to the URL sign.
355 00:30:51.740 ⇒ 00:30:55.870 Uttam Kumaran: Actually, like, yeah, try playing around with this while you fuck around, learn shipments.
356 00:30:59.200 ⇒ 00:31:03.270 Brian Pei: Oh, bookmark bookmark this Tab.
357 00:31:03.460 ⇒ 00:31:05.080 Uttam Kumaran: Go to dashboards on the left.
358 00:31:07.550 ⇒ 00:31:11.800 Uttam Kumaran: click on anything, shipments, metrics for shipment, model.
359 00:31:13.660 ⇒ 00:31:15.250 Brian Pei: Let’s refresh 2 weeks ago.
360 00:31:15.500 ⇒ 00:31:16.699 Brian Pei: That’s supposed to be.
361 00:31:23.660 ⇒ 00:31:24.789 Brian Pei: This is neat.
362 00:31:25.360 ⇒ 00:31:26.180 Uttam Kumaran: Clean.
363 00:31:27.380 ⇒ 00:31:28.519 Brian Pei: Clean and fresh.
364 00:31:33.160 ⇒ 00:31:34.590 Brian Pei: This order, Id
365 00:31:35.350 ⇒ 00:31:39.219 Brian Pei: was $856. Is that what this means.
366 00:31:41.050 ⇒ 00:31:41.720 Uttam Kumaran: Which one?
367 00:31:42.670 ⇒ 00:31:46.220 Uttam Kumaran: No. So that so it says, total shipping amount on the top.
368 00:31:46.530 ⇒ 00:31:47.810 Uttam Kumaran: just showing.
369 00:31:48.630 ⇒ 00:31:49.520 Uttam Kumaran: yeah.
370 00:31:50.410 ⇒ 00:31:52.159 Brian Pei: Right? So this one shipment.
371 00:31:52.490 ⇒ 00:31:52.830 Uttam Kumaran: Yeah.
372 00:31:52.830 ⇒ 00:31:55.200 Brian Pei: They charge them $850 to ship this.
373 00:31:56.313 ⇒ 00:31:59.840 Uttam Kumaran: That could be. Yeah, like, yeah, probably.
374 00:32:00.420 ⇒ 00:32:01.350 Brian Pei: That’s crazy.
375 00:32:01.760 ⇒ 00:32:02.540 Brian Pei: Okay.
376 00:32:02.730 ⇒ 00:32:09.060 Uttam Kumaran: But this is where, like I again, I wanna have some very like, I just need you to look at like everything, basically, and like double check. Some of work.
377 00:32:10.373 ⇒ 00:32:10.939 Brian Pei: Got you
378 00:32:13.200 ⇒ 00:32:13.970 Brian Pei: booing
379 00:32:15.480 ⇒ 00:32:16.660 Brian Pei: this chart?
380 00:32:16.680 ⇒ 00:32:19.229 Brian Pei: I don’t know if it’s working alright.
381 00:32:20.240 ⇒ 00:32:21.630 Brian Pei: I will
382 00:32:21.810 ⇒ 00:32:23.150 Brian Pei: dive in.
383 00:32:23.710 ⇒ 00:32:28.159 Brian Pei: and then tomorrow is my dad’s birthday, and then I’ll hit you up on Wednesday.
384 00:32:28.500 ⇒ 00:32:29.150 Uttam Kumaran: Okay.
385 00:32:33.207 ⇒ 00:32:35.992 Brian Pei: Sweet alright! I will go.
386 00:32:36.550 ⇒ 00:32:41.029 Uttam Kumaran: Message me with anything you need on shipments like I. It’s it’s kind of like a really
387 00:32:41.290 ⇒ 00:32:43.729 Uttam Kumaran: esoteric thing, but
388 00:32:43.800 ⇒ 00:32:45.080 Uttam Kumaran: generally
389 00:32:45.400 ⇒ 00:32:50.859 Uttam Kumaran: like I think you just got them check double check. Each joins and stuff like that. But just text me, if you need anything on the end.
390 00:32:51.910 ⇒ 00:32:58.579 Brian Pei: Okay is every every shipment id should be one to one with an order line. Item, id right.
391 00:33:00.715 ⇒ 00:33:01.690 Uttam Kumaran: Yes.
392 00:33:02.130 ⇒ 00:33:02.840 Brian Pei: Okay. So the.
393 00:33:02.840 ⇒ 00:33:08.579 Uttam Kumaran: Big, big thing you’ll see I tried to do is basically, I want to make sure that every Amazon order and every
394 00:33:08.860 ⇒ 00:33:13.920 Uttam Kumaran: every Amazon and shopify order needs to have at least one shipment associated with it.
395 00:33:14.680 ⇒ 00:33:15.989 Uttam Kumaran: So that’s our check.
396 00:33:17.730 ⇒ 00:33:18.410 Brian Pei: Okay.
397 00:33:18.770 ⇒ 00:33:22.080 Uttam Kumaran: And you can see I kind of have some creative ways of trying to do that. But
398 00:33:22.700 ⇒ 00:33:26.420 Uttam Kumaran: I was getting some duplicates, and I just wasn’t confident, so I didn’t push it yet.
399 00:33:27.140 ⇒ 00:33:30.790 Brian Pei: Because if there’s 2, that just means that the shipment went through 2 systems.
400 00:33:31.890 ⇒ 00:33:37.270 Uttam Kumaran: That’s the thing. So it’s like sometimes it may ship one through ship station and one through Unis.
401 00:33:37.450 ⇒ 00:33:41.019 Uttam Kumaran: and that’s where it kind of gets a little confusing.
402 00:33:42.920 ⇒ 00:33:47.649 Brian Pei: And then the if there’s a tie breaker, it should be Eunice right? Cause they’re gonna move off ship station at some point.
403 00:33:47.920 ⇒ 00:33:52.420 Uttam Kumaran: Well, there’s no there’s the yeah there. Well, there’s no tie breaker.
404 00:33:52.990 ⇒ 00:33:54.949 Uttam Kumaran: It’s it’s just one or the other.
405 00:33:57.070 ⇒ 00:34:00.620 Brian Pei: Oh, I thought you said. Sometimes the same shipment shows up in both the systems.
406 00:34:03.220 ⇒ 00:34:04.820 Uttam Kumaran: No, it that shouldn’t.
407 00:34:04.820 ⇒ 00:34:05.809 Brian Pei: I mean something got.
408 00:34:05.980 ⇒ 00:34:07.239 Brian Pei: I think, in check, too.
409 00:34:07.240 ⇒ 00:34:09.319 Uttam Kumaran: Yeah, that shouldn’t be happening. But check.
410 00:34:10.100 ⇒ 00:34:10.820 Brian Pei: Okay.
411 00:34:11.870 ⇒ 00:34:12.976 Brian Pei: Alright. I’ll
412 00:34:15.500 ⇒ 00:34:16.800 Brian Pei: yeah, sweet.
413 00:34:17.000 ⇒ 00:34:17.960 Uttam Kumaran: Okay. Call me.
414 00:34:18.159 ⇒ 00:34:20.559 Brian Pei: I’ll make it so good, I’ll make it so good for you.
415 00:34:20.760 ⇒ 00:34:22.180 Uttam Kumaran: You please please.
416 00:34:23.699 ⇒ 00:34:25.069 Brian Pei: Alright. I’ll hook you up later.
417 00:34:25.320 ⇒ 00:34:26.270 Uttam Kumaran: Thank you.