Meeting Title: Javy-Project-Internal-Review Date: 2024-09-26 Meeting participants: Brian Pei, Nicolas Sucari, Uttam Kumaran
WEBVTT
1 00:01:05.129 ⇒ 00:01:06.149 Brian Pei: Yo.
2 00:01:06.179 ⇒ 00:01:07.689 Brian Pei: Hello! Good morning.
3 00:01:08.279 ⇒ 00:01:09.709 Brian Pei: or at least for me.
4 00:01:10.290 ⇒ 00:01:12.960 Nicolas Sucari: Hey, Brian, good morning! How are you?
5 00:01:12.960 ⇒ 00:01:17.309 Brian Pei: What’s up? I just woke up, but everything’s cool. Everything’s good.
6 00:01:18.100 ⇒ 00:01:22.089 Nicolas Sucari: Excellent sorry. I think we’ve moved this meeting, or we moved it.
7 00:01:22.160 ⇒ 00:01:26.000 Nicolas Sucari: starting next. Yeah, sorry I moved it for next week on this one.
8 00:01:26.270 ⇒ 00:01:26.800 Brian Pei: It’s okay.
9 00:01:26.800 ⇒ 00:01:27.350 Nicolas Sucari: Okay.
10 00:01:27.350 ⇒ 00:01:28.780 Brian Pei: Starting next week. Yeah.
11 00:01:29.010 ⇒ 00:01:29.710 Brian Pei: Have you ever.
12 00:01:29.710 ⇒ 00:01:31.519 Nicolas Sucari: Already had your morning coffee.
13 00:01:32.060 ⇒ 00:01:37.070 Brian Pei: No, I’m gonna get it right after I I tell you what’s going on.
14 00:01:38.920 ⇒ 00:01:42.319 Brian Pei: I’m going to write out.
15 00:01:42.400 ⇒ 00:01:46.909 Brian Pei: Oh, my God! Did I just lose all my work. No, I didn’t. Okay, we’re totally good. So
16 00:01:49.190 ⇒ 00:01:53.770 Brian Pei: let me let me type out what I’ve been working on
17 00:01:53.890 ⇒ 00:01:58.489 Brian Pei: for you, so you don’t have to just like write it down. So I’m gonna type and talk at the same time.
18 00:01:58.620 ⇒ 00:02:02.250 Brian Pei: So what I’ve been what I’ve been doing is
19 00:02:03.680 ⇒ 00:02:04.810 Brian Pei: Snowflake
20 00:02:04.860 ⇒ 00:02:06.300 Brian Pei: sequel
21 00:02:06.480 ⇒ 00:02:07.560 Brian Pei: modeling
22 00:02:07.800 ⇒ 00:02:09.150 Brian Pei: work company.
23 00:02:09.696 ⇒ 00:02:14.820 Brian Pei: So before I write anything in Dbt, I have to know
24 00:02:15.370 ⇒ 00:02:21.650 Brian Pei: the the data that I’m looking at. So I’m mostly in Snowflake, querying all these tables and seeing
25 00:02:21.790 ⇒ 00:02:24.000 Brian Pei: what’s in it, and then writing
26 00:02:24.040 ⇒ 00:02:26.189 Brian Pei: some sequel in Snowflake
27 00:02:26.220 ⇒ 00:02:27.850 Brian Pei: to test.
28 00:02:27.850 ⇒ 00:02:28.440 Nicolas Sucari: Okay.
29 00:02:28.440 ⇒ 00:02:30.000 Brian Pei: Business logic. So I’m not.
30 00:02:31.820 ⇒ 00:02:41.139 Brian Pei: for yeah, for projects that like, just start. I can’t just go straight into Dbt. If I don’t really know what I’m looking at. So what I’ve been planning is
31 00:02:42.270 ⇒ 00:02:43.750 Brian Pei: for shopify.
32 00:02:44.030 ⇒ 00:02:46.779 Brian Pei: I have some queries written to create.
33 00:02:48.650 ⇒ 00:02:49.900 Brian Pei: customer
34 00:02:50.800 ⇒ 00:02:52.540 Brian Pei: order line.
35 00:02:52.830 ⇒ 00:02:55.689 Brian Pei: which is very similar to pool parts to go
36 00:02:56.550 ⇒ 00:02:57.270 Nicolas Sucari: Okay.
37 00:02:57.270 ⇒ 00:02:58.220 Brian Pei: Order
38 00:02:58.460 ⇒ 00:02:59.340 Brian Pei: with
39 00:03:01.220 ⇒ 00:03:05.019 Brian Pei: with tiktok tags, and like all the other tags
40 00:03:05.250 ⇒ 00:03:07.919 Brian Pei: product, which is like
41 00:03:08.100 ⇒ 00:03:11.149 Brian Pei: skew and type of coffee product.
42 00:03:12.320 ⇒ 00:03:15.079 Brian Pei: Subscriptions.
43 00:03:17.400 ⇒ 00:03:18.310 Brian Pei: sips.
44 00:03:18.790 ⇒ 00:03:19.780 Brian Pei: shins
45 00:03:19.890 ⇒ 00:03:21.760 Brian Pei: and transactions.
46 00:03:22.010 ⇒ 00:03:28.910 Brian Pei: So I just wrote all that down. So you don’t have to worry about it. So those are this, like, basically 6 shopify
47 00:03:29.220 ⇒ 00:03:32.230 Brian Pei: tables that I’m working on the logic for.
48 00:03:32.900 ⇒ 00:03:34.630 Brian Pei: and Amazon.
49 00:03:35.200 ⇒ 00:03:37.350 Brian Pei: I have orders
50 00:03:37.770 ⇒ 00:03:39.030 Brian Pei: and
51 00:03:39.060 ⇒ 00:03:41.240 Brian Pei: products and
52 00:03:44.710 ⇒ 00:03:48.979 Brian Pei: the note from Aman is Amazon. Customers
53 00:03:49.360 ⇒ 00:03:51.100 Brian Pei: don’t have
54 00:03:52.700 ⇒ 00:03:56.290 Brian Pei: identifiable information.
55 00:03:57.290 ⇒ 00:04:01.260 Brian Pei: so I can’t make Amazon customers table.
56 00:04:02.220 ⇒ 00:04:08.320 Brian Pei: We’ll see if I can join on at shipping address.
57 00:04:10.692 ⇒ 00:04:13.950 Brian Pei: So that’s shopify Amazon, and then
58 00:04:14.640 ⇒ 00:04:16.480 Brian Pei: the final table
59 00:04:17.149 ⇒ 00:04:18.390 Brian Pei: will be
60 00:04:19.079 ⇒ 00:04:21.430 Brian Pei: orders, all
61 00:04:21.470 ⇒ 00:04:23.540 Brian Pei: Amazon plus shopify
62 00:04:24.490 ⇒ 00:04:26.200 Brian Pei: product, all
63 00:04:27.680 ⇒ 00:04:30.230 Brian Pei: Amazon plus shopify
64 00:04:31.140 ⇒ 00:04:32.450 Brian Pei: and
65 00:04:32.580 ⇒ 00:04:34.600 Brian Pei: subscriptions
66 00:04:34.820 ⇒ 00:04:36.400 Brian Pei: shopify only
67 00:04:36.710 ⇒ 00:04:37.990 Brian Pei: customers
68 00:04:38.100 ⇒ 00:04:40.969 Brian Pei: shopify only, maybe Amazon.
69 00:04:43.600 ⇒ 00:04:44.980 Brian Pei: Okay. So
70 00:04:47.430 ⇒ 00:04:49.640 Brian Pei: for for any updates that
71 00:04:49.890 ⇒ 00:04:52.940 Brian Pei: you would like to give to either Utam or Aman.
72 00:04:53.500 ⇒ 00:04:55.119 Brian Pei: You can let them know that
73 00:04:55.440 ⇒ 00:04:59.030 Brian Pei: I’m writing sequel in Snowflake.
74 00:04:59.250 ⇒ 00:05:00.740 Brian Pei: so that I can.
75 00:05:03.040 ⇒ 00:05:03.720 Brian Pei: So that.
76 00:05:03.720 ⇒ 00:05:04.909 Nicolas Sucari: Yeah, for understanding.
77 00:05:04.910 ⇒ 00:05:11.430 Brian Pei: The data. Yeah. So I can see that the yeah, exactly. The data looks right before. I move things to to Dbt.
78 00:05:12.300 ⇒ 00:05:12.880 Nicolas Sucari: Okay.
79 00:05:13.470 ⇒ 00:05:18.169 Brian Pei: And yeah, there’s like 40 tables. So I’ll probably have to do this today and tomorrow
80 00:05:18.280 ⇒ 00:05:21.940 Brian Pei: before I’m confident enough to use Dbt to create.
81 00:05:22.040 ⇒ 00:05:25.478 Brian Pei: you know, a table that is final.
82 00:05:27.080 ⇒ 00:05:28.600 Brian Pei: and.
83 00:05:29.120 ⇒ 00:05:34.154 Nicolas Sucari: Okay. But we are looking to have those 4 final tables. I think that’s fine.
84 00:05:34.770 ⇒ 00:05:48.600 Nicolas Sucari: let’s aim to to work on that for next meeting with a man. And then I was looking at Snowflake. And once those tables are final, we are gonna move them into analytics, right like into the database.
85 00:05:48.920 ⇒ 00:05:58.177 Brian Pei: Yeah. All the sequel that I’m writing is not creating anything. I’m just. I’m writing sequel. And then I’m looking at the results.
86 00:05:58.580 ⇒ 00:05:58.990 Nicolas Sucari: Okay.
87 00:05:59.010 ⇒ 00:06:00.860 Brian Pei: Dbt will create
88 00:06:00.940 ⇒ 00:06:03.420 Brian Pei: new tables. Okay.
89 00:06:03.460 ⇒ 00:06:06.820 Brian Pei: And that point will be sometime next week
90 00:06:07.460 ⇒ 00:06:07.940 Nicolas Sucari: Excellent.
91 00:06:07.940 ⇒ 00:06:12.569 Brian Pei: I’ll I’ll I’ll get as much as I can done before we talk with them on for that.
92 00:06:13.560 ⇒ 00:06:13.970 Nicolas Sucari: Okay.
93 00:06:13.970 ⇒ 00:06:24.236 Brian Pei: And then it’ll move and move to like, you know. Aman will look at the tables and let me know like, Oh, we don’t need this column. We need this other column. It’ll it’ll go back and forth through
94 00:06:25.414 ⇒ 00:06:29.105 Brian Pei: iterations because he didn’t really give us a blueprint of what he wanted.
95 00:06:29.390 ⇒ 00:06:30.669 Nicolas Sucari: Yeah, yeah, of course.
96 00:06:30.670 ⇒ 00:06:33.949 Brian Pei: Something before he can make any suggestions.
97 00:06:35.453 ⇒ 00:06:37.279 Brian Pei: And then
98 00:06:37.730 ⇒ 00:06:39.430 Brian Pei: and yeah. And so
99 00:06:40.260 ⇒ 00:06:42.710 Brian Pei: without these
100 00:06:42.850 ⇒ 00:06:48.200 Brian Pei: analytics tables, I also obviously can’t do real stuff. So I.
101 00:06:48.200 ⇒ 00:06:48.979 Nicolas Sucari: Yeah, I know.
102 00:06:48.980 ⇒ 00:06:50.329 Brian Pei: I haven’t touched real yet.
103 00:06:50.960 ⇒ 00:06:52.320 Nicolas Sucari: Yeah, yeah, don’t worry. I think.
104 00:06:52.320 ⇒ 00:06:54.629 Brian Pei: The sequel, the sequel, Logic. First.st
105 00:06:54.630 ⇒ 00:06:59.199 Nicolas Sucari: Yeah, once we have those final tables, we can easily create the real stuff
106 00:06:59.955 ⇒ 00:07:08.140 Nicolas Sucari: for now, let’s just focus on having those tables. I think that’s fine. And are we gonna use that like intermediate structure?
107 00:07:08.780 ⇒ 00:07:10.510 Nicolas Sucari: I don’t know if
108 00:07:10.620 ⇒ 00:07:14.409 Nicolas Sucari: that’s gonna be needed for an hour now, but we have that in.
109 00:07:14.660 ⇒ 00:07:18.720 Nicolas Sucari: Well, I can see the snowflake. I don’t know how we’re gonna structure, all of the different.
110 00:07:19.020 ⇒ 00:07:19.560 Nicolas Sucari: So.
111 00:07:19.560 ⇒ 00:07:22.459 Brian Pei: Raw is 5 tran intermediate.
112 00:07:23.030 ⇒ 00:07:23.735 Brian Pei: the
113 00:07:26.030 ⇒ 00:07:27.370 Brian Pei: Dbt.
114 00:07:27.540 ⇒ 00:07:29.840 Brian Pei: but not final tables.
115 00:07:29.890 ⇒ 00:07:32.230 Brian Pei: It’s like in between
116 00:07:32.460 ⇒ 00:07:34.680 Brian Pei: business logic tables.
117 00:07:34.810 ⇒ 00:07:37.030 Brian Pei: and then analytics
118 00:07:38.370 ⇒ 00:07:40.610 Brian Pei: will be report ready
119 00:07:40.730 ⇒ 00:07:41.510 Brian Pei: and.
120 00:07:41.510 ⇒ 00:07:42.430 Nicolas Sucari: Excellent.
121 00:07:42.430 ⇒ 00:07:43.950 Brian Pei: 3 ready Tables.
122 00:07:44.660 ⇒ 00:07:54.989 Nicolas Sucari: Perfect. Yeah, that’s gonna yeah. I’m gonna try to create some like diagram on how it’s gonna be that process so that we can share also with the man. But yeah, I think that would be okay.
123 00:07:55.700 ⇒ 00:08:00.990 Brian Pei: Yeah, like, intermediate, like an example would be When I
124 00:08:01.280 ⇒ 00:08:02.700 Brian Pei: I’m getting like.
125 00:08:02.800 ⇒ 00:08:09.140 Brian Pei: I’m getting customer emails in one place and customer addresses somewhere else, and there’s duplicates and customer addresses.
126 00:08:09.270 ⇒ 00:08:10.390 Brian Pei: so like
127 00:08:10.720 ⇒ 00:08:14.169 Brian Pei: intermediate is like customer addresses cleaned up
128 00:08:14.370 ⇒ 00:08:22.140 Brian Pei: so like nobody nobody will query it. But for me. I need it to be clean before I use it in the final customers table. It’s like stuff like that.
129 00:08:22.890 ⇒ 00:08:23.690 Nicolas Sucari: Perfect.
130 00:08:23.840 ⇒ 00:08:24.580 Nicolas Sucari: Okay.
131 00:08:26.700 ⇒ 00:08:32.876 Nicolas Sucari: Great. Yeah, I don’t know. I don’t think we have anything else, for now we need to.
132 00:08:33.220 ⇒ 00:08:34.010 Uttam Kumaran: Thing.
133 00:08:34.280 ⇒ 00:08:35.689 Brian Pei: Oh, shit! Who’s on.
134 00:08:36.110 ⇒ 00:08:39.990 Uttam Kumaran: You could probably take some of the code from pool parts. Dude.
135 00:08:40.750 ⇒ 00:08:42.890 Brian Pei: I did. I I tried
136 00:08:43.049 ⇒ 00:08:51.533 Brian Pei: the column. Names are different. And there’s a lot of there’s a lot of Json fields like I have to extract like currency and like
137 00:08:52.100 ⇒ 00:08:55.120 Brian Pei: prices and stuff from a Json field.
138 00:08:55.710 ⇒ 00:08:59.219 Brian Pei: Which is fine, like. Obviously, every environment is different.
139 00:08:59.614 ⇒ 00:09:05.960 Brian Pei: So I I looked at a lot of the pool part stuff for guidance of, like the final columns that people like to see
140 00:09:06.364 ⇒ 00:09:10.909 Brian Pei: but it. But I tried the the copy and paste didn’t work. Yeah, because the
141 00:09:12.180 ⇒ 00:09:18.959 Brian Pei: ha, half the call, half the custom column names are different, but you know half of it is the same. It’s it’s just not one to one.
142 00:09:19.650 ⇒ 00:09:24.089 Uttam Kumaran: Okay? And then also, we took a bunch of stuff from the shopify
143 00:09:24.590 ⇒ 00:09:26.890 Uttam Kumaran: 5 Tran Dbt package as well.
144 00:09:27.490 ⇒ 00:09:36.150 Brian Pei: Oh, I did that, too. I I clicked the button. So it created like an initial version of customer and order and stuff like that for me already.
145 00:09:36.610 ⇒ 00:09:37.150 Uttam Kumaran: Okay, cool.
146 00:09:39.830 ⇒ 00:09:46.819 Uttam Kumaran: Okay, great. Yeah. I’m just trying to see, like as we do more of these shopify ones and Amazon ones like how much we can just like reuse
147 00:09:48.640 ⇒ 00:09:53.420 Brian Pei: It’s definitely helpful. I I can’t 1 to one copy paste, but I’m I’m using it as a template.
148 00:09:54.300 ⇒ 00:09:56.129 Uttam Kumaran: Even, but even like the
149 00:09:56.440 ⇒ 00:09:59.690 Uttam Kumaran: the orders, they just don’t have the same call names.
150 00:10:01.195 ⇒ 00:10:04.844 Brian Pei: At least, I’ve been working on order line, and
151 00:10:05.390 ⇒ 00:10:06.530 Brian Pei: it’s
152 00:10:07.460 ⇒ 00:10:09.869 Brian Pei: fairly different.
153 00:10:09.870 ⇒ 00:10:10.430 Uttam Kumaran: Okay.
154 00:10:14.060 ⇒ 00:10:16.519 Brian Pei: Oh, it’s called order items and pull parts to go.
155 00:10:17.930 ⇒ 00:10:22.624 Brian Pei: Yeah, I mean it. It’ll have, you know, like quantity and date and stuff.
156 00:10:23.370 ⇒ 00:10:24.190 Brian Pei: but
157 00:10:24.740 ⇒ 00:10:27.225 Brian Pei: what I was looking at is
158 00:10:30.600 ⇒ 00:10:38.019 Brian Pei: right? So, like all their discounts in shopify for coffee is called total discount, total discount set.
159 00:10:38.340 ⇒ 00:10:40.640 Brian Pei: It’s a Json field, with like.
160 00:10:40.640 ⇒ 00:10:41.360 Uttam Kumaran: Oh!
161 00:10:41.360 ⇒ 00:10:43.279 Brian Pei: In it, and then price set
162 00:10:44.030 ⇒ 00:10:46.189 Brian Pei: and they call it different. They call it.
163 00:10:46.190 ⇒ 00:10:46.830 Uttam Kumaran: Yeah.
164 00:10:46.830 ⇒ 00:10:48.170 Brian Pei: Resentment. Money
165 00:10:50.660 ⇒ 00:10:54.969 Brian Pei: stuff like shop money so it’s just a little bit different. But it’s like, not that big of a deal.
166 00:10:55.690 ⇒ 00:10:57.419 Uttam Kumaran: Okay, cool. Okay.
167 00:10:58.270 ⇒ 00:10:59.710 Uttam Kumaran: makes sense.
168 00:11:03.390 ⇒ 00:11:07.759 Uttam Kumaran: I mean, I honestly like, I even think that sort of stuff is helpful to show them on.
169 00:11:07.860 ⇒ 00:11:14.669 Uttam Kumaran: Because, again, like our one of the things that like. And I’m just kinda kinda keep beating a dead horse. But
170 00:11:14.790 ⇒ 00:11:20.289 Uttam Kumaran: our game is a bit of like buying time before we can give you enough time to do
171 00:11:20.400 ⇒ 00:11:21.840 Uttam Kumaran: like the modeling.
172 00:11:21.920 ⇒ 00:11:28.430 Uttam Kumaran: And so the one thing for customers is, it’s not like we’re internal where we can just like
173 00:11:28.660 ⇒ 00:11:31.209 Uttam Kumaran: come to stand up and be like still working.
174 00:11:31.632 ⇒ 00:11:40.700 Uttam Kumaran: It’s more of like, although that may be true. I also want to provide them with like a ton of context like, just hammer them with context and communication.
175 00:11:40.900 ⇒ 00:11:45.059 Uttam Kumaran: Right? Like, if we can share like, Hey, this is, this is like some of the stuff we’re seeing
176 00:11:45.130 ⇒ 00:11:51.530 Uttam Kumaran: like, here’s how to get into Snowflake. That’s all stuff for free that like it’s just sitting there. So that’s
177 00:11:52.120 ⇒ 00:11:56.330 Uttam Kumaran: I think more on on Nico side to just gather from Brian like, Hey, we’re seeing stuff.
178 00:11:56.330 ⇒ 00:11:56.670 Nicolas Sucari: Yes.
179 00:11:56.670 ⇒ 00:12:08.769 Uttam Kumaran: Discounts and price set and just share with him, like I would say, like, I wanted to come across that we’re like over communicating, because the one thing you don’t want with consultants is is silence.
180 00:12:09.462 ⇒ 00:12:15.600 Uttam Kumaran: Because I cause Nico we have consultants, and you know I don’t like when there’s silence. And so.
181 00:12:15.600 ⇒ 00:12:16.660 Nicolas Sucari: Oh, yeah. Totally.
182 00:12:16.660 ⇒ 00:12:18.459 Uttam Kumaran: It’s the same thing for us.
183 00:12:19.170 ⇒ 00:12:20.430 Uttam Kumaran: So yeah.
184 00:12:20.430 ⇒ 00:12:28.090 Brian Pei: No, I asked him on like 15 questions in our last meeting. To get back to me with some stuff.
185 00:12:29.160 ⇒ 00:12:38.059 Nicolas Sucari: Maybe we can. Yeah, if you if you find some more stuff that you have questions just let’s send some slack
186 00:12:38.414 ⇒ 00:12:44.520 Nicolas Sucari: to him so that we can ask those questions and see. And then he can see that we are still looking into that stuff.
187 00:12:47.050 ⇒ 00:12:49.090 Nicolas Sucari: Yeah, I think that would be useful.
188 00:12:50.100 ⇒ 00:12:51.829 Brian Pei: I will ask him when I have a.
189 00:12:52.730 ⇒ 00:12:53.390 Nicolas Sucari: Okay.
190 00:12:53.390 ⇒ 00:12:54.576 Brian Pei: Actual like
191 00:12:56.300 ⇒ 00:12:59.260 Brian Pei: actual data quality question.
192 00:12:59.670 ⇒ 00:13:05.400 Brian Pei: So like, for example, I’m I’m modeling subscriptions out for him. Utam. And I was like.
193 00:13:05.940 ⇒ 00:13:08.780 Brian Pei: it’s like, Yeah, I have. I have subscription
194 00:13:08.960 ⇒ 00:13:12.159 Brian Pei: as a tag. But what are your rules for?
195 00:13:13.430 ⇒ 00:13:19.509 Brian Pei: somebody who doesn’t have a subscription but orders every month versus someone who stops subscription. Then orders again.
196 00:13:19.510 ⇒ 00:13:19.930 Uttam Kumaran: Yeah.
197 00:13:19.930 ⇒ 00:13:23.290 Brian Pei: And reactivates. What’s your definition of reactivation?
198 00:13:23.300 ⇒ 00:13:33.179 Brian Pei: And do you care about like the subscription start and end time? Those are all questions I asked him last meeting, and he was like, I don’t know. Let me get back to you, so I’ll keep doing that.
199 00:13:34.650 ⇒ 00:13:35.829 Uttam Kumaran: Okay. Okay. Cool.
200 00:13:37.100 ⇒ 00:13:39.149 Brian Pei: They’re just selling coffee. It’s all good.
201 00:13:39.550 ⇒ 00:13:44.160 Uttam Kumaran: Yeah, no, I’m just gonna because it’s even a good reminder for me.
202 00:13:45.120 ⇒ 00:13:46.600 Uttam Kumaran: so just know
203 00:13:46.870 ⇒ 00:13:48.929 Uttam Kumaran: like where we are in the food chain and.
204 00:13:48.930 ⇒ 00:13:54.126 Brian Pei: And yeah, here’s here’s another data example that he shared with us.
205 00:13:54.940 ⇒ 00:14:00.829 Brian Pei: in Amazon they they wipe out Pii so we can’t get Amazon customers.
206 00:14:01.290 ⇒ 00:14:02.369 Brian Pei: So when I make.
207 00:14:02.370 ⇒ 00:14:03.260 Uttam Kumaran: Yeah.
208 00:14:03.260 ⇒ 00:14:05.120 Brian Pei: Consolidated Customer table.
209 00:14:05.300 ⇒ 00:14:11.969 Brian Pei: He was like, we either like Don’t include Amazon, or we try to do a Fuzzy join on shipping address so like.
210 00:14:11.970 ⇒ 00:14:18.439 Uttam Kumaran: Yeah, you’re not. They’re not gonna give you unless it’s fulfilled by them. They’re not gonna give you the shipping address.
211 00:14:18.730 ⇒ 00:14:19.599 Brian Pei: Yeah, exactly.
212 00:14:20.070 ⇒ 00:14:21.010 Uttam Kumaran: So what
213 00:14:21.500 ⇒ 00:14:26.500 Uttam Kumaran: this is where like, you can see what we did, for pool parts is pool parts only looks at their shopify customers
214 00:14:26.870 ⇒ 00:14:37.190 Uttam Kumaran: we tried to do. I mean, I had the same idea which is like some people may buy on Amazon and then buy on shopify. But the overlap was really low, mostly on pool parts by once.
215 00:14:37.360 ⇒ 00:14:42.469 Uttam Kumaran: but it may be cool to see that like it’s almost like shopify, plus the ones that we can resolve
216 00:14:43.632 ⇒ 00:14:47.870 Uttam Kumaran: but then the only thing to avoid there is doing things like comparing, like the
217 00:14:47.910 ⇒ 00:14:51.309 Uttam Kumaran: looking at total sales from that customers table versus another thing.
218 00:14:52.017 ⇒ 00:14:54.660 Uttam Kumaran: Just wanna be really clear of like.
219 00:14:54.810 ⇒ 00:14:57.559 Uttam Kumaran: these are the customers that we can resolve this for
220 00:14:59.060 ⇒ 00:15:07.929 Uttam Kumaran: But yeah, I mean, makes sense. Yes, Amazon gives you like weird email addresses, and then, if they fulfill it, they don’t give you any. The address comes in hash, so.
221 00:15:08.200 ⇒ 00:15:08.870 Brian Pei: Yeah.
222 00:15:09.800 ⇒ 00:15:18.139 Brian Pei: But yeah, and then that’s just on the customer side. And then like orders, though, I can union them and be fine and have a have a column for source, and
223 00:15:18.180 ⇒ 00:15:20.089 Brian Pei: the stuff that you guys did with pool parts.
224 00:15:20.611 ⇒ 00:15:30.379 Brian Pei: All of which to say is like, we we are asking questions, specific questions, and as I dig deeper into creating the initial tables.
225 00:15:31.640 ⇒ 00:15:34.870 Brian Pei: you know I I’ll always have stuff to present to him on
226 00:15:35.090 ⇒ 00:15:36.500 Brian Pei: cool.
227 00:15:36.680 ⇒ 00:15:39.560 Brian Pei: and I’ll let you know how it goes with
228 00:15:40.180 ⇒ 00:15:44.429 Brian Pei: I I before you joined I I pinged Nico a list.
229 00:15:44.430 ⇒ 00:15:45.200 Nicolas Sucari: Yeah.
230 00:15:45.200 ⇒ 00:15:49.200 Brian Pei: 9 tables that I’m working on the business logic for right now
231 00:15:49.330 ⇒ 00:15:50.850 Brian Pei: cool. And they didn’t give us.
232 00:15:50.850 ⇒ 00:15:52.529 Uttam Kumaran: I heard I heard that part. I was on.
233 00:15:52.530 ⇒ 00:15:52.850 Brian Pei: Oh, yeah.
234 00:15:52.850 ⇒ 00:15:53.430 Uttam Kumaran: I’m just.
235 00:15:53.430 ⇒ 00:15:59.369 Brian Pei: Okay, yeah. So it’s gonna be iterative. They they didn’t give us a blueprint. So I I need to give them something so that
236 00:15:59.470 ⇒ 00:16:00.899 Brian Pei: he can be like.
237 00:16:01.010 ⇒ 00:16:03.990 Brian Pei: Add this column, remove this column. Blah blah. So anyway.
238 00:16:03.990 ⇒ 00:16:04.660 Uttam Kumaran: Perfect.
239 00:16:05.530 ⇒ 00:16:19.550 Nicolas Sucari: Yeah, once we have any any table or that kind of stuff we’re gonna be sharing with the man, and he will give us some feedback, and we can keep that iterative process. As Brian said. I think that’s the only thing we have for now, because they don’t give us like any
240 00:16:19.830 ⇒ 00:16:23.269 Nicolas Sucari: table they were looking for directly or anything like that. So yep.
241 00:16:23.990 ⇒ 00:16:25.279 Uttam Kumaran: Okay. Okay. Cool.
242 00:16:26.920 ⇒ 00:16:28.250 Nicolas Sucari: Excellent. Okay.
243 00:16:28.330 ⇒ 00:16:29.560 Nicolas Sucari: thanks. Brian.
244 00:16:29.710 ⇒ 00:16:30.579 Brian Pei: Coffee, time.
245 00:16:30.580 ⇒ 00:16:31.010 Uttam Kumaran: Ss.
246 00:16:31.050 ⇒ 00:16:31.616 Brian Pei: Thanks guys.
247 00:16:32.240 ⇒ 00:16:33.260 Nicolas Sucari: Bye-bye.
248 00:16:33.260 ⇒ 00:16:34.140 Brian Pei: See you guys soon.
249 00:16:34.140 ⇒ 00:16:35.090 Uttam Kumaran: Bye.