Meeting Title: Javy-Project-Internal-Review Date: 2024-10-17 Meeting participants: Brian Pei, Nicolas Sucari, Payas Parab
WEBVTT
1 00:04:23.350 ⇒ 00:04:24.500 Payas Parab: Hey? What’s up? Nico?
2 00:04:25.430 ⇒ 00:04:27.060 Nicolas Sucari: Hey, Bayas! How are you?
3 00:04:27.670 ⇒ 00:04:29.249 Payas Parab: I’m doing all right. How are you.
4 00:04:30.130 ⇒ 00:04:31.230 Nicolas Sucari: Pretty good.
5 00:04:32.780 ⇒ 00:04:38.390 Nicolas Sucari: Oh, yeah, I’m with my camera off. I just. I’m finished. I’m finishing meeting. I’ll turn it.
6 00:04:38.390 ⇒ 00:04:39.570 Payas Parab: Boys, yeah.
7 00:04:39.570 ⇒ 00:04:41.420 Nicolas Sucari: Like 5 min.
8 00:04:41.580 ⇒ 00:04:42.660 Payas Parab: No worries.
9 00:04:47.180 ⇒ 00:04:50.380 Nicolas Sucari: Let me try pinging Brian. See if he’s joining.
10 00:05:16.500 ⇒ 00:05:18.049 Nicolas Sucari: How’s everything going.
11 00:05:18.982 ⇒ 00:05:21.790 Payas Parab: Things are okay. I’ve just been trying to
12 00:05:21.930 ⇒ 00:05:24.021 Payas Parab: kind of stay afloat here.
13 00:05:24.990 ⇒ 00:05:30.170 Payas Parab: yeah, man, things have been just just hanging in there, that’s that’s all I could say. How about you?
14 00:05:30.670 ⇒ 00:05:31.500 Payas Parab: Yeah.
15 00:05:31.500 ⇒ 00:05:34.919 Nicolas Sucari: That’s okay. Here things are going fine. I think
16 00:05:35.930 ⇒ 00:05:39.749 Nicolas Sucari: we’ve been working with uten and some internal guys
17 00:05:40.030 ⇒ 00:05:42.699 Nicolas Sucari: on getting more clients. And I think
18 00:05:42.960 ⇒ 00:05:46.170 Nicolas Sucari: we’re actually seeing some progress on that end.
19 00:05:46.460 ⇒ 00:05:47.160 Payas Parab: That’s awesome.
20 00:05:48.560 ⇒ 00:05:53.330 Nicolas Sucari: Yeah, we’ve been doing like a lot of effort on marketing and trying to
21 00:05:53.600 ⇒ 00:05:57.139 Nicolas Sucari: reach out to different people. And I think it’s paying off
22 00:05:57.160 ⇒ 00:06:01.119 Nicolas Sucari: right now, or should be off in a couple couple of weeks
23 00:06:01.580 ⇒ 00:06:03.810 Nicolas Sucari: coming in. So yeah.
24 00:06:04.060 ⇒ 00:06:05.110 Nicolas Sucari: I’m excited.
25 00:06:15.950 ⇒ 00:06:17.040 Nicolas Sucari: Hey, Brian.
26 00:06:17.640 ⇒ 00:06:18.340 Brian Pei: Hey!
27 00:06:24.490 ⇒ 00:06:26.609 Nicolas Sucari: Do you know by us if Robert is joining.
28 00:06:27.168 ⇒ 00:06:32.180 Payas Parab: That I don’t know. Let me check his calendar. Maybe he’s double booked, or maybe it says it on here.
29 00:06:36.962 ⇒ 00:06:40.170 Payas Parab: I don’t see it on his calendar, maybe
30 00:06:40.230 ⇒ 00:06:42.180 Payas Parab: maybe declined it, or
31 00:06:42.290 ⇒ 00:06:44.372 Payas Parab: oh, he’s actually not on the invite.
32 00:06:47.840 ⇒ 00:06:50.489 Nicolas Sucari: Hmm, okay, I can forward this to him and.
33 00:06:50.490 ⇒ 00:06:51.410 Payas Parab: Yeah.
34 00:06:52.550 ⇒ 00:06:57.719 Payas Parab: I can send him the notes. If this is too last minute for him now, I just realized he’s not on it. Maybe.
35 00:07:15.010 ⇒ 00:07:21.949 Nicolas Sucari: I thought he was on this one don’t know why he’s not in the invite, maybe because it was the internal one. He was not gonna join it.
36 00:07:23.300 ⇒ 00:07:23.930 Nicolas Sucari: Yeah.
37 00:07:24.730 ⇒ 00:07:28.359 Nicolas Sucari: but that’s okay. I just sent in the invite.
38 00:07:31.470 ⇒ 00:07:32.080 Payas Parab: Excellent.
39 00:07:35.340 ⇒ 00:07:35.940 Nicolas Sucari: Okay.
40 00:07:36.360 ⇒ 00:07:37.450 Nicolas Sucari: So
41 00:07:38.090 ⇒ 00:07:41.435 Nicolas Sucari: I think the meeting this week went well with the man.
42 00:07:41.860 ⇒ 00:07:49.950 Nicolas Sucari: I think we need to start working with trying to ingest north stream. Right north beam is how is it called that tool? Sorry
43 00:07:53.190 ⇒ 00:07:53.670 Nicolas Sucari: and.
44 00:07:53.670 ⇒ 00:07:55.599 Payas Parab: Yeah. Can you say that? Say again, sorry.
45 00:07:55.810 ⇒ 00:07:56.770 Payas Parab: Kind of cut off.
46 00:07:56.770 ⇒ 00:08:00.419 Nicolas Sucari: Yeah, north of them. I think we need to start working.
47 00:08:00.560 ⇒ 00:08:05.879 Nicolas Sucari: 1st of all, Brian. I don’t know if we, if you already have that full request ready to
48 00:08:06.040 ⇒ 00:08:08.560 Nicolas Sucari: to to change the tables, Kina.
49 00:08:09.310 ⇒ 00:08:13.630 Nicolas Sucari: But when that is done, I think we need to start working on bringing in the data from
50 00:08:13.720 ⇒ 00:08:15.049 Nicolas Sucari: north beam.
51 00:08:18.700 ⇒ 00:08:19.670 Nicolas Sucari: That should be our.
52 00:08:19.670 ⇒ 00:08:20.310 Brian Pei: Let’s.
53 00:08:21.930 ⇒ 00:08:24.049 Nicolas Sucari: That should be our next step right.
54 00:08:27.290 ⇒ 00:08:28.120 Brian Pei: But now.
55 00:08:30.630 ⇒ 00:08:36.560 Nicolas Sucari: No, if my! My question was, if we already merged the pull request that you were working on
56 00:08:36.580 ⇒ 00:08:37.940 Nicolas Sucari: with the Oh, yeah.
57 00:08:37.940 ⇒ 00:08:38.610 Brian Pei: Yeah, yeah.
58 00:08:38.610 ⇒ 00:08:39.299 Nicolas Sucari: Okay.
59 00:08:40.482 ⇒ 00:08:44.000 Brian Pei: It merged I’ve been testing it
60 00:08:44.310 ⇒ 00:08:45.990 Brian Pei: all day.
61 00:08:47.270 ⇒ 00:08:51.159 Brian Pei: I just got everything except one thing to run
62 00:08:51.650 ⇒ 00:08:53.510 Brian Pei: here. Let me show you what it looks like.
63 00:08:54.300 ⇒ 00:08:54.890 Nicolas Sucari: Okay.
64 00:08:55.140 ⇒ 00:08:56.040 Brian Pei: Oh.
65 00:09:00.330 ⇒ 00:09:03.813 Brian Pei: so this is dbt, cloud.
66 00:09:07.060 ⇒ 00:09:09.290 Brian Pei: these are. This is me testing.
67 00:09:10.320 ⇒ 00:09:12.580 Brian Pei: So right now I am on
68 00:09:12.730 ⇒ 00:09:14.040 Brian Pei: this run.
69 00:09:14.480 ⇒ 00:09:18.450 Brian Pei: So I’m very close of the 8 models, it’ll run
70 00:09:18.830 ⇒ 00:09:20.850 Brian Pei: and put on a schedule.
71 00:09:21.160 ⇒ 00:09:24.050 Brian Pei: Everything except this is airing out
72 00:09:24.650 ⇒ 00:09:26.770 Brian Pei: because of a
73 00:09:27.510 ⇒ 00:09:29.609 Brian Pei: because the word order
74 00:09:29.730 ⇒ 00:09:31.850 Brian Pei: is a snowflake
75 00:09:35.980 ⇒ 00:09:46.650 Brian Pei: function or something like that. I can’t put just shopify dot order. I have to wrap it in quotes or something. Anyway, I’m like, it’s like 99% there. Once I get this error fixed.
76 00:09:47.049 ⇒ 00:09:49.110 Brian Pei: Then this is gonna get put on a schedule.
77 00:09:49.520 ⇒ 00:09:52.770 Brian Pei: and and these prod tables will all exist.
78 00:09:53.670 ⇒ 00:09:55.270 Nicolas Sucari: Excellent. Okay?
79 00:09:58.170 ⇒ 00:10:03.440 Nicolas Sucari: Then, I think we need to change the real dashboards, the sources to.
80 00:10:04.367 ⇒ 00:10:08.310 Nicolas Sucari: Yeah. Just use those tables right?
81 00:10:09.330 ⇒ 00:10:11.340 Nicolas Sucari: Just to have that coming from.
82 00:10:11.340 ⇒ 00:10:15.059 Brian Pei: Yeah, and the columns will all be the same. It’s just the table name.
83 00:10:15.350 ⇒ 00:10:17.560 Brian Pei: When this runs I’ll send
84 00:10:17.760 ⇒ 00:10:23.109 Brian Pei: basically a message of the the old table name and the new table name. So it’s easy to map.
85 00:10:24.400 ⇒ 00:10:35.879 Nicolas Sucari: Oh, yeah, and I can. I can do the change. I can create a pull request and change that sources, maybe by us. If you already are using real locally, you will need to refresh the sources.
86 00:10:36.820 ⇒ 00:10:39.060 Nicolas Sucari: Or, you know, just kill
87 00:10:39.070 ⇒ 00:10:42.509 Nicolas Sucari: real, and started again with the new sources
88 00:10:42.964 ⇒ 00:10:47.060 Nicolas Sucari: once that’s ready, and that will automatically try to load the new source.
89 00:10:47.060 ⇒ 00:10:50.129 Payas Parab: You’re not gonna put that in the cloud, though that’ll just be on like the
90 00:10:50.940 ⇒ 00:10:55.529 Payas Parab: like. It won’t be deployed to cloud or cause I I figured I could just use Cloud just to like check on stuff.
91 00:10:55.530 ⇒ 00:10:58.820 Nicolas Sucari: Yeah, yeah, of course. Yes, I can.
92 00:10:59.480 ⇒ 00:11:09.669 Nicolas Sucari: I mean, I I’ll I always try to work it locally first, st so that I can test everything. Once that is ready, I deploy to cloud. But yeah, it shouldn’t be a problem. It should be the same for you.
93 00:11:09.670 ⇒ 00:11:10.220 Payas Parab: Yeah.
94 00:11:10.760 ⇒ 00:11:15.728 Payas Parab: sorry I have my boomer computer. That’s why I just wanna.
95 00:11:16.880 ⇒ 00:11:19.170 Nicolas Sucari: That’s fine. Yeah.
96 00:11:19.180 ⇒ 00:11:29.669 Nicolas Sucari: I use real locally. Just when I try to create a new dashboard or anything else, just to change some stuff that I can test it out. But yeah, obviously, I can deploy to real clone. And you will see there.
97 00:11:30.050 ⇒ 00:11:30.650 Payas Parab: Great.
98 00:11:31.910 ⇒ 00:11:45.399 Nicolas Sucari: Excellent. Okay, yeah. And when once that is ready, Brian, maybe we need to start we need to ask a man for the access for north beam, I think, so that we can try to start ingesting the data source right? Pay us.
99 00:11:45.780 ⇒ 00:11:48.510 Payas Parab: Yeah, yeah, I think that would be good to get that going as well.
100 00:11:49.520 ⇒ 00:12:02.299 Nicolas Sucari: Excellent. Yeah. And then regarding the tool. I know Robert just sent a message about that. But I think you guys need to come to a decision. And yeah, let us know.
101 00:12:02.300 ⇒ 00:12:17.310 Payas Parab: I mean, I think I think we’ll just do Meta base. Then I think that maybe that’s just the easiest one, and it’s the cheapest. And you guys have, Robert said with Stella. You guys collaborated on that, and that worked well, so like rather than shake things up. Then maybe we’ll just stick to
102 00:12:17.740 ⇒ 00:12:23.259 Payas Parab: I brought up hex hex is a lot more expensive. Right is my. I think hex is more expensive.
103 00:12:24.830 ⇒ 00:12:27.450 Nicolas Sucari: I don’t know. But yeah, maybe let me check.
104 00:12:27.761 ⇒ 00:12:33.369 Payas Parab: I cause I like Hex better. I think they’ll be more pleased with something as aesthetic as hex.
105 00:12:33.802 ⇒ 00:12:36.969 Payas Parab: So like my inclination is there. But if Robert’s.
106 00:12:37.640 ⇒ 00:12:44.689 Payas Parab: I think we’ll just double check the costs, and if it’s like really significant, then I say, we just pull the trigger for them on on like on our
107 00:12:45.030 ⇒ 00:12:47.431 Payas Parab: like. We’ll just pull the trigger for them. Let me just
108 00:12:47.820 ⇒ 00:12:54.899 Payas Parab: I just don’t know how much Meta base cost. Would you guys be like, do you guys know how much you guys have implemented Meta base for before.
109 00:12:56.257 ⇒ 00:13:05.129 Nicolas Sucari: Here in the pricing page for metabase. It says, like the starter plan is $85 a month
110 00:13:05.770 ⇒ 00:13:11.380 Nicolas Sucari: for 5 users only, and then it’s $5 per month per user additional.
111 00:13:11.720 ⇒ 00:13:16.880 Nicolas Sucari: But if we need to get to the but if we need to get the pro plan, it’s 500 a month.
112 00:13:17.680 ⇒ 00:13:19.259 Nicolas Sucari: I don’t know if we need that.
113 00:13:19.260 ⇒ 00:13:20.460 Payas Parab: Right? Yeah.
114 00:13:20.480 ⇒ 00:13:25.059 Payas Parab: So I think I think meta base because I think hex utam had sent. I think it’s
115 00:13:25.180 ⇒ 00:13:30.079 Payas Parab: per editor like $85 a month per person. Is that was that right? Am I?
116 00:13:30.550 ⇒ 00:13:31.530 Payas Parab: Let me.
117 00:13:35.020 ⇒ 00:13:38.160 Nicolas Sucari: Professional is 36 per acre per month.
118 00:13:38.970 ⇒ 00:13:40.120 Nicolas Sucari: 36.
119 00:13:40.180 ⇒ 00:13:43.299 Nicolas Sucari: Yeah, it depends on how. Yeah. Per, editor.
120 00:13:46.320 ⇒ 00:13:49.999 Payas Parab: So then they’d only have one editor right, and then they’d be sharing with people.
121 00:13:52.281 ⇒ 00:13:58.148 Nicolas Sucari: I think so. Yeah, I don’t know. I mean, the idea was that there
122 00:13:58.600 ⇒ 00:14:03.239 Nicolas Sucari: data engineer will be their data. Analyst will be managing all of the
123 00:14:04.046 ⇒ 00:14:06.430 Nicolas Sucari: creation of those dashboards right.
124 00:14:07.670 ⇒ 00:14:08.200 Payas Parab: Yeah.
125 00:14:08.200 ⇒ 00:14:17.549 Nicolas Sucari: So if they have only one person, it would be one editor. And yeah, it will be 36 month. I don’t know if that’s shareable with more people, and if that has a cost.
126 00:14:19.530 ⇒ 00:14:20.370 Payas Parab: Yeah.
127 00:14:20.370 ⇒ 00:14:21.780 Nicolas Sucari: I’m not sure.
128 00:14:21.990 ⇒ 00:14:28.949 Payas Parab: I say, let me just let me just ping Robert and just see what he thinks about Hex. I I just think Hex looks a lot better like. That’s just my.
129 00:14:29.630 ⇒ 00:14:30.559 Nicolas Sucari: I really like that.
130 00:14:31.170 ⇒ 00:14:38.940 Payas Parab: Like, don’t you like? It’s just more aesthetic, more pleasing. And they can like, write basically like docs and dashboards and notes super easily.
131 00:14:40.410 ⇒ 00:14:42.710 Payas Parab: that I really like. But
132 00:14:43.350 ⇒ 00:14:43.890 Payas Parab: oh.
133 00:14:43.890 ⇒ 00:14:47.169 Nicolas Sucari: Or or maybe you can. You can just send the information of both.
134 00:14:47.959 ⇒ 00:14:56.039 Nicolas Sucari: If if Robert is okay with Meta based on Hextech. We can send the information both to a man and he can make the choice or.
135 00:14:56.040 ⇒ 00:14:56.579 Payas Parab: Sure. Yeah.
136 00:14:56.580 ⇒ 00:14:56.940 Nicolas Sucari: Can you.
137 00:14:56.940 ⇒ 00:14:57.560 Payas Parab: We’ll just.
138 00:14:58.190 ⇒ 00:15:10.720 Nicolas Sucari: Because I I don’t know why, what they are needing the reports to look like, and then that will make like the decision of which tool is better for what they are needing. Right? But yeah.
139 00:15:10.740 ⇒ 00:15:12.280 Nicolas Sucari: maybe we can send both
140 00:15:12.350 ⇒ 00:15:14.249 Nicolas Sucari: to them, and they can decide.
141 00:15:14.940 ⇒ 00:15:22.409 Payas Parab: Yeah, I think I think Robert’s just leaning. Cause like I’m on sometimes just goes like, whatever you guys think like, he doesn’t really give that much of a fuck. So like, I think he’s like.
142 00:15:23.311 ⇒ 00:15:29.439 Payas Parab: I think they just I I like, I think we just do. You guys, you guys are familiar with most with Meta base. Right? Is that what you guys.
143 00:15:30.560 ⇒ 00:15:36.759 Nicolas Sucari: I haven’t used it before. I don’t know you, Brian. If you already worked with metase.
144 00:15:37.230 ⇒ 00:15:47.900 Payas Parab: Because connecting it to the warehouse is like not. It’s not difficult, but it’s also not trivial either. So I want to make sure if whatever is faster for you guys, we can also just choose that. And I think.
145 00:15:48.090 ⇒ 00:15:55.520 Payas Parab: given they’re being cheap in general. We’ll just go with the cheaper option I’m like in hindsight. Let’s just make the decision for them, and just get them something up and running.
146 00:15:55.970 ⇒ 00:15:56.919 Nicolas Sucari: Yeah, I’m
147 00:15:57.210 ⇒ 00:16:00.980 Nicolas Sucari: I think Robert has already worked with metabase a lot. So maybe
148 00:16:01.410 ⇒ 00:16:02.960 Nicolas Sucari: yeah, that’s the easiest.
149 00:16:03.130 ⇒ 00:16:07.940 Payas Parab: Yeah, okay, let’s just do that. I I say, we just pull the trigger for that. And okay.
150 00:16:08.670 ⇒ 00:16:24.210 Payas Parab: we’ll just let them all know that’s what we’re leaning. This is the cost. The other one there’s like, if you want more people to be able to edit and like make their own dashboards, and it it like racks up really quickly. But it’s more aesthetically pleasing. Let us know if you disagree, and you’d rather have the more aesthetically pleasing
151 00:16:24.350 ⇒ 00:16:25.420 Payas Parab: one. Yep.
152 00:16:25.420 ⇒ 00:16:27.939 Nicolas Sucari: Okay, my only concern. There is
153 00:16:28.570 ⇒ 00:16:38.369 Nicolas Sucari: that maybe you need to discuss with Robert is, what what are we gonna do with real? If we want to have real, or we’re just gonna be using it locally to self service
154 00:16:38.967 ⇒ 00:16:44.200 Nicolas Sucari: some dashboards and reports for anyone who wants to do that, or use it internally, as
155 00:16:44.220 ⇒ 00:16:48.700 Nicolas Sucari: if they don’t want to have it in the cloud, because that will be like another tool and another cost.
156 00:16:48.750 ⇒ 00:16:49.910 Nicolas Sucari: But I think they are able.
157 00:16:49.910 ⇒ 00:17:04.060 Payas Parab: Cost. I I think real, is worth it, though, to have like a self serve environment like I think they need some type of like a like, these guys know how to do some basic stuff. So I think we should provide them a self. Serve environment. Meta base is not a great self serve environment. So there’s just this like.
158 00:17:04.079 ⇒ 00:17:06.699 Payas Parab: and neither is hex. Right? So like.
159 00:17:06.720 ⇒ 00:17:27.169 Payas Parab: I think it is important, we provide them a self. Serve environment. Let’s just get the costs in front of them. But I I don’t think we drop rail. I think I think they need something where you know that, like they can just play around with the data easily themselves. I think I think that’s critical. And again, at the end of the day, they’re paying us to implement it. Let’s just implement it. Let’s give it to them. And one day, if they decide to cancel it like
160 00:17:27.180 ⇒ 00:17:29.830 Payas Parab: that’s on them right like, let them cancel it.
161 00:17:29.930 ⇒ 00:17:33.480 Payas Parab: but I think we give it to them now, so that they have self serve.
162 00:17:33.790 ⇒ 00:17:48.799 Payas Parab: and they can like go do their own stuff. So I think we’ll do real cloud. Let’s just get the cost like clear in front of him on for that. Just so he knows it. I think we will keep real cloud, and then we’ll just do Meta base, which is the cheaper option. So then we’re not like racking up too many costs on the software. They’ll have.
163 00:17:50.050 ⇒ 00:17:50.730 Nicolas Sucari: Okay.
164 00:17:52.300 ⇒ 00:17:54.028 Nicolas Sucari: yeah. Cool. I am.
165 00:17:54.720 ⇒ 00:18:01.420 Nicolas Sucari: talk with autumn about the pricing of real and see. Try to estimate a monthly price for that one, and let you know.
166 00:18:01.850 ⇒ 00:18:06.570 Payas Parab: Yeah, you guys have like a partnership with them, too. Right? So you should be able to get some type of like discounted price.
167 00:18:06.904 ⇒ 00:18:15.145 Payas Parab: If we can show that, then it’s like that’s great. I I mean, even if we can just tell them like we got you a discount. They’ll be like, yeah.
168 00:18:16.205 ⇒ 00:18:16.850 Payas Parab: yeah.
169 00:18:16.850 ⇒ 00:18:19.150 Nicolas Sucari: Of course, of course. Cool.
170 00:18:19.630 ⇒ 00:18:20.199 Payas Parab: Great guys.
171 00:18:20.200 ⇒ 00:18:20.640 Nicolas Sucari: Bye.
172 00:18:20.640 ⇒ 00:18:31.349 Payas Parab: In terms of like, just a bunch of querying that I need to do. And like, I’m actually having some issues or something I’m gonna need to verify like something is not quite tying out to the shopify actual dashboard.
173 00:18:31.640 ⇒ 00:18:59.650 Payas Parab: That Jared screenshotted. I’m wondering if it’s like I’m not transforming these things correctly, but like some stuff isn’t tying out like the number of discounts and stuff. So I think we may need to investigate that wanted to know from you guys, I I have to go do that leg work right now, right to like, actually figure out what’s not tying out. But if there is an issue. How do you guys typically diagnose right? Is there like a da like, if there’s a data issue or like something like that, how how do you guys typically.
174 00:18:59.650 ⇒ 00:19:00.680 Brian Pei: Items.
175 00:19:00.680 ⇒ 00:19:01.669 Payas Parab: Stuff, not tying out.
176 00:19:01.670 ⇒ 00:19:04.219 Brian Pei: Is? Is it higher or lower?
177 00:19:05.960 ⇒ 00:19:09.591 Payas Parab: The discounts appears lower.
178 00:19:10.500 ⇒ 00:19:11.010 Brian Pei: Appear.
179 00:19:11.010 ⇒ 00:19:17.109 Payas Parab: Yeah, the total sales. I think I may have just chosen the wrong columns. I was looking at it last night. I think I just
180 00:19:17.640 ⇒ 00:19:22.780 Payas Parab: like there, there’s something like for their gross sales versus their discounts. The discounts
181 00:19:23.470 ⇒ 00:19:38.960 Payas Parab: seem higher. Sorry? Yeah, that sorry. Actually, the discount seem higher. There’s like some of them like we’re net sales is negative, which is like, not possible, right? So that that I think. But then, like I could have also fucked up the query. I’m trying to like. Figure that out 1st before I say, it’s a data issue.
182 00:19:39.810 ⇒ 00:19:40.260 Payas Parab: Yeah.
183 00:19:40.260 ⇒ 00:19:43.908 Brian Pei: It could be. Yeah. So basically.
184 00:19:44.480 ⇒ 00:19:45.719 Brian Pei: DM, me.
185 00:19:46.584 ⇒ 00:19:58.249 Brian Pei: we you we could get discounts from 2 different places. There’s total discounts that come straight up on the order object. And then there’s an order discount table that has an amount
186 00:19:58.450 ⇒ 00:20:02.070 Brian Pei: that I summed up. But I didn’t bring in, because I actually
187 00:20:02.220 ⇒ 00:20:05.049 Brian Pei: didn’t know if it was the discount
188 00:20:05.240 ⇒ 00:20:09.629 Brian Pei: amount from the discount table or the discount amount from the order table. So
189 00:20:09.690 ⇒ 00:20:10.909 Brian Pei: now my gut’s telling me.
190 00:20:10.910 ⇒ 00:20:13.000 Payas Parab: Do you know if those those look different.
191 00:20:14.550 ⇒ 00:20:16.690 Payas Parab: In theory, should they be the same, or like.
192 00:20:16.690 ⇒ 00:20:19.949 Brian Pei: In theory they should be the same, but it’s wouldn’t.
193 00:20:20.320 ⇒ 00:20:21.810 Brian Pei: When shopify
194 00:20:22.250 ⇒ 00:20:27.470 Brian Pei: tries to do it on one object and also splits it out on another one. It’s
195 00:20:27.810 ⇒ 00:20:29.920 Brian Pei: high likelihood that they are different.
196 00:20:30.170 ⇒ 00:20:30.850 Payas Parab: Yep.
197 00:20:32.430 ⇒ 00:20:35.139 Brian Pei: And I don’t know if I need to add
198 00:20:35.220 ⇒ 00:20:38.410 Brian Pei: arithmetic, where, if the discount amount is
199 00:20:38.840 ⇒ 00:20:42.290 Brian Pei: greater than or equal to, the total order, amount just
200 00:20:42.620 ⇒ 00:20:43.850 Brian Pei: round it, or.
201 00:20:43.850 ⇒ 00:21:04.660 Payas Parab: Yeah, I I think we’re partially fucking it up like, remember, I told you they have like freebies for their 1st subscription. I think there’s something like going wrong with that where they’re like, cause I we we looked at a bunch of shopify orders in shopify with them on before it adds the freebies to the cart. It’s not like a default thing that gets added on later. It’s like it adds it to the cart, and then removes the cost
202 00:21:04.750 ⇒ 00:21:06.100 Payas Parab: from the price.
203 00:21:06.350 ⇒ 00:21:07.790 Payas Parab: Okay? Which is what my.
204 00:21:07.790 ⇒ 00:21:08.199 Brian Pei: So that.
205 00:21:08.200 ⇒ 00:21:13.910 Payas Parab: On here is like the freebies are not part of the subtotal. Maybe because I’m using subtotal. Maybe I need to use
206 00:21:14.120 ⇒ 00:21:16.479 Payas Parab: price list total price set.
207 00:21:17.390 ⇒ 00:21:20.790 Brian Pei: Yeah, the the easiest thing. DM, me.
208 00:21:20.900 ⇒ 00:21:23.740 Brian Pei: we we basically we. We carve out a month.
209 00:21:24.010 ⇒ 00:21:26.839 Brian Pei: And then I make a dev table
210 00:21:26.890 ⇒ 00:21:31.880 Brian Pei: with scratch. SQL, that’s not part of dbt. To validate
211 00:21:32.050 ⇒ 00:21:33.680 Brian Pei: our validation
212 00:21:33.690 ⇒ 00:21:36.450 Brian Pei: in the dev table. I’ll include
213 00:21:36.560 ⇒ 00:21:43.189 Brian Pei: discount amounts from as many different places as I can possibly can find, and we see which one of the columns ties out
214 00:21:43.230 ⇒ 00:21:50.019 Brian Pei: closest to this shopify report, and then that tells us which field to actually bring into the table.
215 00:21:50.740 ⇒ 00:22:02.269 Payas Parab: Got it that would be perfect. Alright, let me let me go play around with that, and then I’ll show you the month that I’m looking at and trying to tie out, and then I’ll present that cleanly for you, and then we can kind of debug from there. I would just love some help, because I’m probably.
216 00:22:02.270 ⇒ 00:22:02.760 Brian Pei: Yeah, of course.
217 00:22:02.760 ⇒ 00:22:04.490 Payas Parab: Second set of eyes. Yeah.
218 00:22:04.490 ⇒ 00:22:05.130 Brian Pei: For sure.
219 00:22:05.320 ⇒ 00:22:06.030 Payas Parab: Awesome.
220 00:22:07.070 ⇒ 00:22:11.879 Payas Parab: Alright. Yeah, I’ll ping you with that, probably in like the next few hours. Here, I’m just trying to wrap up some other stuff. But yeah.
221 00:22:11.880 ⇒ 00:22:12.630 Brian Pei: No problem.
222 00:22:13.200 ⇒ 00:22:14.380 Brian Pei: I’ll be around.
223 00:22:14.840 ⇒ 00:22:15.920 Brian Pei: Yeah, cool.
224 00:22:16.460 ⇒ 00:22:17.240 Brian Pei: Okay.
225 00:22:17.240 ⇒ 00:22:18.070 Nicolas Sucari: Thanks guys.
226 00:22:18.270 ⇒ 00:22:19.460 Brian Pei: Thanks. Everyone.
227 00:22:19.460 ⇒ 00:22:20.239 Payas Parab: All right.
228 00:22:20.530 ⇒ 00:22:21.879 Brian Pei: Like tomorrow we’ll talk later.