Meeting Title: Javy-Project-Internal-Review Date: 2024-10-10 Meeting participants: Brian Pei, Nicolas Sucari, Payas Parab
WEBVTT
1 00:04:25.630 ⇒ 00:04:26.540 Brian Pei: Hello!
2 00:04:28.750 ⇒ 00:04:30.590 Nicolas Sucari: Hey, Brian, how are you?
3 00:04:31.540 ⇒ 00:04:32.590 Brian Pei: Good.
4 00:04:32.860 ⇒ 00:04:36.039 Brian Pei: See if I can get camera off today.
5 00:04:37.080 ⇒ 00:04:38.570 Brian Pei: Alrighty.
6 00:04:39.180 ⇒ 00:04:39.730 Brian Pei: I’m back.
7 00:04:39.730 ⇒ 00:04:42.749 Nicolas Sucari: How does it feel to do? Yeah, to be back home.
8 00:04:43.210 ⇒ 00:04:45.680 Brian Pei: Pretty good. I’m all jet lags. But
9 00:04:45.880 ⇒ 00:04:47.439 Brian Pei: that’s okay. Yeah.
10 00:04:47.800 ⇒ 00:04:48.615 Brian Pei: right?
11 00:04:49.770 ⇒ 00:04:57.080 Brian Pei: I do have something quick to go over with you before, because it doesn’t really involve bias for.
12 00:04:57.080 ⇒ 00:04:57.680 Nicolas Sucari: Okay.
13 00:04:57.680 ⇒ 00:04:58.760 Brian Pei: T. Cloud.
14 00:04:59.306 ⇒ 00:05:08.420 Brian Pei: It should be a small thing. Basically. What Utam sent us was the oh, he’s joining. But that’s okay. What Utam sent us
15 00:05:08.540 ⇒ 00:05:13.750 Brian Pei: was the password for the Javi coffee. Gmail.
16 00:05:13.920 ⇒ 00:05:14.900 Nicolas Sucari: Gmail, yeah.
17 00:05:14.900 ⇒ 00:05:19.809 Brian Pei: So I can’t log into it for some reason.
18 00:05:20.150 ⇒ 00:05:28.959 Brian Pei: if you can log into it. I went to the dB. I went to the Dbt. Cloud, and I requested a password. Reset
19 00:05:29.556 ⇒ 00:05:33.929 Brian Pei: and all I need is for someone who can get into the gmail
20 00:05:34.030 ⇒ 00:05:41.429 Brian Pei: to reset the Dbt. Cloud password to whatever you want, and then just send me what that is going to be.
21 00:05:41.730 ⇒ 00:05:42.480 Brian Pei: and then.
22 00:05:42.793 ⇒ 00:05:43.420 Nicolas Sucari: Give me
23 00:05:43.540 ⇒ 00:05:45.579 Nicolas Sucari: 1 min. I’m trying to access.
24 00:05:45.860 ⇒ 00:05:47.202 Brian Pei: Yeah, no problem.
25 00:05:48.010 ⇒ 00:05:49.554 Brian Pei: while you’re doing that.
26 00:05:50.100 ⇒ 00:05:51.630 Brian Pei: since Pius is here.
27 00:05:52.680 ⇒ 00:05:53.959 Payas Parab: Hey, guys, how are you.
28 00:05:54.410 ⇒ 00:05:55.245 Brian Pei: Good
29 00:05:57.160 ⇒ 00:06:00.463 Brian Pei: I lost the password for Dbt. Cloud. No big deal. Don’t worry about that.
30 00:06:01.500 ⇒ 00:06:06.090 Brian Pei: Don’t even think about that. It’s all good. But
31 00:06:06.160 ⇒ 00:06:09.889 Brian Pei: yeah, for today, I’m gonna I’ll quickly go over
32 00:06:10.030 ⇒ 00:06:13.739 Brian Pei: on the data side things that have been going on
33 00:06:14.250 ⇒ 00:06:17.969 Brian Pei: pass it over to Nico to talk about real which.
34 00:06:17.970 ⇒ 00:06:18.490 Payas Parab: You didn’t.
35 00:06:18.490 ⇒ 00:06:21.370 Brian Pei: Working so for me.
36 00:06:22.960 ⇒ 00:06:39.569 Brian Pei: This week we are. I just poked around enough, and I found cost. I didn’t validate cost, but I know that what I added has a Usd. Cost added to every product variant, which is the product, child?
37 00:06:40.550 ⇒ 00:06:42.130 Brian Pei: I then
38 00:06:42.850 ⇒ 00:06:54.370 Brian Pei: I could not join that to orders, because one order has multiple line items which is fine. So I joined it to shopify.
39 00:06:54.450 ⇒ 00:06:58.250 Brian Pei: What’s the what’s the name of the table?
40 00:07:00.770 ⇒ 00:07:04.489 Payas Parab: Is there a place where, like the items in every order, are captured as well
41 00:07:04.670 ⇒ 00:07:05.240 Payas Parab: like it’s.
42 00:07:05.240 ⇒ 00:07:10.593 Brian Pei: Yeah, exactly. So I I was just looking for the name. So shopify order line.
43 00:07:11.140 ⇒ 00:07:20.450 Brian Pei: fact, shopify order line is the breakout of line items for every order. So I I was able to join it to that.
44 00:07:20.660 ⇒ 00:07:21.740 Brian Pei: So
45 00:07:22.070 ⇒ 00:07:23.590 Brian Pei: you have orders
46 00:07:24.100 ⇒ 00:07:27.120 Brian Pei: and order line. Item, the call
47 00:07:28.190 ⇒ 00:07:31.490 Brian Pei: the cost I named to product cost.
48 00:07:31.760 ⇒ 00:07:32.770 Brian Pei: in
49 00:07:33.290 ⇒ 00:07:35.379 Brian Pei: fact, shopify order line.
50 00:07:35.590 ⇒ 00:07:39.419 Brian Pei: and then what I haven’t done yet but will do
51 00:07:39.780 ⇒ 00:07:41.240 Brian Pei: is
52 00:07:41.880 ⇒ 00:07:47.279 Brian Pei: using order line. I think I should be able to some product cost
53 00:07:47.410 ⇒ 00:07:48.910 Brian Pei: by order id
54 00:07:49.180 ⇒ 00:07:54.350 Brian Pei: and join that to orders to get a total aggregate order, cost, or product cost.
55 00:07:55.090 ⇒ 00:07:56.470 Brian Pei: As long
56 00:07:56.590 ⇒ 00:08:01.859 Brian Pei: as I have the arithmetic to not include
57 00:08:02.010 ⇒ 00:08:04.859 Brian Pei: refunded orders in that cost.
58 00:08:05.810 ⇒ 00:08:07.939 Brian Pei: Because you can
59 00:08:08.060 ⇒ 00:08:09.470 Brian Pei: refund
60 00:08:09.540 ⇒ 00:08:13.949 Brian Pei: one part of an order and still have it fulfilled.
61 00:08:14.100 ⇒ 00:08:18.989 Brian Pei: And so, if I want the aggregated cost or cogs to show up
62 00:08:19.110 ⇒ 00:08:28.000 Brian Pei: in the orders table, I need to make sure that it’s all cost of fulfilled and delivered orders, and not anything that was
63 00:08:28.080 ⇒ 00:08:33.500 Brian Pei: removed or refunded. Which is why I didn’t add it yet, because I need to make sure that that.
64 00:08:34.299 ⇒ 00:08:35.429 Payas Parab: And that’s cost of.
65 00:08:35.429 ⇒ 00:08:36.409 Brian Pei: Makes sense.
66 00:08:36.409 ⇒ 00:08:39.869 Payas Parab: This is product cost. I see what you’re saying. So like, if the order is
67 00:08:42.009 ⇒ 00:08:45.739 Payas Parab: well, if it’s refunded, I think they eat. The cost was my assumption.
68 00:08:46.429 ⇒ 00:08:48.759 Payas Parab: So refunds kind of becomes its own thing where it’s.
69 00:08:48.760 ⇒ 00:08:49.950 Brian Pei: Oh!
70 00:08:50.290 ⇒ 00:08:54.489 Payas Parab: I think so. We can confirm that with the Cfo. And or Aman. But
71 00:08:54.690 ⇒ 00:09:00.549 Payas Parab: the way I looked at it when we did this in amplitude was that I assumed the refund. You just eat the entire cost.
72 00:09:01.200 ⇒ 00:09:03.730 Brian Pei: I guess so. So they just throw it out. That sucks.
73 00:09:03.730 ⇒ 00:09:09.780 Payas Parab: Yeah, cause I don’t think it’s like you’re legally allowed to like ship food that already has been shipped to someone and reship it to someone.
74 00:09:09.780 ⇒ 00:09:11.370 Brian Pei: Oh, I didn’t even think about that!
75 00:09:11.370 ⇒ 00:09:14.179 Payas Parab: So, I believe, and then, I believe, with shopify
76 00:09:14.730 ⇒ 00:09:26.691 Payas Parab: they kind of are like, well, you ship like their their suppliers still have to get paid, and then the pack and pick the pick and pack costs and the logistics fees, I think. Don’t get refunded. So I think they’re just like it’s just complete.
77 00:09:27.480 ⇒ 00:09:28.380 Payas Parab: Oh.
78 00:09:28.760 ⇒ 00:09:29.089 Brian Pei: I mean.
79 00:09:29.090 ⇒ 00:09:29.740 Payas Parab: That makes things.
80 00:09:29.740 ⇒ 00:09:30.420 Brian Pei: Easier.
81 00:09:30.640 ⇒ 00:09:42.260 Payas Parab: It does. Yeah, cause it’s kind of like its own thing, right where it’s like, okay, here’s the sales. Here’s the cost of that. One thing I wanted to confirm on. I can check this product cost field because I haven’t checked that. The other cost I’d found in inventory
82 00:09:42.340 ⇒ 00:09:49.710 Payas Parab: seemed really low like, it seemed like, really, really low. It should be around 20 to 30% should be cogs.
83 00:09:52.300 ⇒ 00:09:53.080 Brian Pei: Hmm
84 00:09:53.670 ⇒ 00:09:55.509 Brian Pei: in shop of in the shopify tables.
85 00:09:55.510 ⇒ 00:09:56.510 Payas Parab: Yeah.
86 00:09:57.230 ⇒ 00:09:59.839 Payas Parab: I’m wondering what that ratio looks like on
87 00:10:01.350 ⇒ 00:10:08.949 Payas Parab: in order line items. But we want to check on that just because that cost seemed really low, at least the one in the inventory table.
88 00:10:09.310 ⇒ 00:10:12.849 Brian Pei: Let me take a look right now.
89 00:10:13.690 ⇒ 00:10:19.426 Payas Parab: The other costs that we kind of need to find. So when I, when we originally did this, the main components
90 00:10:20.180 ⇒ 00:10:22.069 Payas Parab: the main components.
91 00:10:22.780 ⇒ 00:10:23.559 Payas Parab: We can keep going.
92 00:10:23.560 ⇒ 00:10:24.429 Brian Pei: I’m just.
93 00:10:24.430 ⇒ 00:10:27.059 Payas Parab: Yeah, no worries. You do. The
94 00:10:27.300 ⇒ 00:10:33.919 Payas Parab: I’m just. I’m actually find the presentation. I think I may have sent it a while ago, but it was like on a Friday or some shit later date. But
95 00:10:34.810 ⇒ 00:10:36.230 Payas Parab: the
96 00:10:36.440 ⇒ 00:10:40.059 Payas Parab: there’s like a couple other costs that are kind of factored into
97 00:10:40.642 ⇒ 00:10:44.870 Payas Parab: and I can share my screen here and show you what I’m talking about.
98 00:10:47.150 ⇒ 00:10:48.250 Brian Pei: I’ll stop sharing.
99 00:10:50.570 ⇒ 00:10:55.550 Payas Parab: So these are the costs we looked at, and this is what was pulled through in the amplitude events from shopify.
100 00:10:56.920 ⇒ 00:10:59.220 Payas Parab: Let me know if you can see my screen.
101 00:11:02.460 ⇒ 00:11:07.189 Payas Parab: Yeah. So this was. So there’s like, there’s the cogs right, which is the cost of goods which
102 00:11:07.270 ⇒ 00:11:12.020 Payas Parab: on the 1st subscription, it should be around 20. It’s between 20 to 30%.
103 00:11:12.110 ⇒ 00:11:16.110 Payas Parab: The cogs is higher on the subscription initiation, because.
104 00:11:16.439 ⇒ 00:11:22.029 Payas Parab: they include like freebies like they include like your 1st ever like. If it’s your 1st order, they include like
105 00:11:22.160 ⇒ 00:11:32.977 Payas Parab: a Javi coffee stir, or some shit like like a bunch of little gifts right like a a recipe book or something. So that’s what drives the cost up here, you see in that green circle. Right?
106 00:11:33.620 ⇒ 00:11:34.730 Payas Parab: But
107 00:11:36.790 ⇒ 00:11:39.518 Payas Parab: yeah, in this green circle. You’ll see that
108 00:11:40.620 ⇒ 00:11:41.540 Payas Parab: but
109 00:11:41.670 ⇒ 00:12:00.890 Payas Parab: like there’s other components here, they called it like 3 pl fees, packaging fees, shipping. And then here in this, like this gray circle, you’ll see the impact of like refunds, which, like it’s kind of just an overall L on the entire margin. So I looked at that completely, separately, was like, Okay, all the refunded orders.
110 00:12:00.910 ⇒ 00:12:03.180 Payas Parab: all the costs that went into
111 00:12:03.530 ⇒ 00:12:09.560 Payas Parab: that, including shipping and stuff. We’re like an L, so I think what we’re looking at with this product cost is probably this like
112 00:12:09.960 ⇒ 00:12:13.290 Payas Parab: this, cogs bar right. This like this left hand.
113 00:12:13.290 ⇒ 00:12:14.139 Brian Pei: Good word.
114 00:12:14.600 ⇒ 00:12:20.389 Payas Parab: I believe it should be higher, or there’s a chance that, like gifts, or like extra freebies from the order.
115 00:12:20.730 ⇒ 00:12:26.649 Payas Parab: are somehow not being captured right? When we look at an order line, item, the free items should be added to it.
116 00:12:27.230 ⇒ 00:12:35.439 Payas Parab: and then they also sell those items. So that’s what makes it tricky. There’ll be days. There’s times where it’ll be 0, and there’s time. This is something we gotta validate here.
117 00:12:35.791 ⇒ 00:12:41.929 Payas Parab: Just to make sure that that cogs fully captures that cost of that 1st order, including the freebies,
118 00:12:42.540 ⇒ 00:12:43.820 Payas Parab: and stuff like that.
119 00:12:44.760 ⇒ 00:12:46.190 Brian Pei: Let me.
120 00:12:46.490 ⇒ 00:12:49.300 Brian Pei: I’ve been writing sequel this whole time.
121 00:12:49.300 ⇒ 00:12:51.869 Payas Parab: Yep, I can stop sharing if you want to pull up yours.
122 00:12:51.870 ⇒ 00:12:54.690 Brian Pei: Okay. One second, let me make sure. Okay. So.
123 00:12:54.690 ⇒ 00:12:58.560 Payas Parab: And I would have had more time to explore it. But like this guy, I got food poisoning.
124 00:12:58.730 ⇒ 00:13:06.549 Payas Parab: and then this guy kept pounding me all week where he’s like, where is this? Where is this to be fair? I was like in bed, and I should have just been like, Hey, I food poisoning. But then
125 00:13:07.110 ⇒ 00:13:14.060 Payas Parab: he’s just been like on my ass. So I’m like, we, yeah, we can talk about the real stuff, Nico, which I sent you. Do you see the message you sent me.
126 00:13:15.690 ⇒ 00:13:16.420 Nicolas Sucari: Yeah, yeah.
127 00:13:16.420 ⇒ 00:13:26.759 Payas Parab: I took everything that we did and put it into a spreadsheet to make it user friendly. And he’s like this isn’t useful. And I’m just like alright dude like you made me the spreadsheet bro like you made me the spreadsheet.
128 00:13:27.970 ⇒ 00:13:31.750 Nicolas Sucari: But what like his expectations, is to have like live data or something.
129 00:13:31.750 ⇒ 00:13:55.119 Payas Parab: Yeah, he wants a lot. I think I think his feedback is reasonable. It’s just I don’t like the way he says it. Like, you know, like he’s correct. Is that like, if at the end of the day he has like a finance, he’s a finance. The Cfo. Right like he’s supposed to do analysis like that. So there’s no need for us to do it. We need to like make it so. It’s all auto refreshed, right? Like I’m hoping that the Excel exercise made it super easy for us, though, right? Because now I’ve made a snowflake
130 00:13:55.290 ⇒ 00:14:01.660 Payas Parab: table that has those things, and I know exactly what we need to do to pull from it. And that shouldn’t be that hard.
131 00:14:03.420 ⇒ 00:14:21.150 Nicolas Sucari: Yeah. And I think once, once we have that sequel query and tables that that you worked on, I think we can create that in real, we can create a dashboard and real will app automatically update, like every day the data so that everything should be like, like.
132 00:14:21.530 ⇒ 00:14:25.990 Nicolas Sucari: I think we were setting. Yeah, 24 h. Update right? Brian, on
133 00:14:26.300 ⇒ 00:14:27.290 Nicolas Sucari: everything.
134 00:14:28.940 ⇒ 00:14:31.190 Brian Pei: Yes, sorry. I’m still pregnant.
135 00:14:31.190 ⇒ 00:14:31.880 Nicolas Sucari: Yeah.
136 00:14:31.880 ⇒ 00:14:32.689 Payas Parab: It’s all good.
137 00:14:33.209 ⇒ 00:14:38.320 Nicolas Sucari: While while he’s finishing that. Yeah, were you able to to follow the steps on.
138 00:14:38.320 ⇒ 00:14:40.930 Payas Parab: Not not yet. That’s that’s on me. I should have done.
139 00:14:41.200 ⇒ 00:14:43.009 Nicolas Sucari: Don’t, don’t worry, don’t worry. I mean.
140 00:14:43.420 ⇒ 00:14:47.669 Nicolas Sucari: when we are done with this I can stay a little bit longer with you, and I can help you.
141 00:14:47.890 ⇒ 00:14:59.269 Payas Parab: Yeah, like, is it done in like a do you mind quickly showing me like how you edit a real dashboard like I? Is it like streamlit where it’s like a scripting language, or is it? It is right. Okay.
142 00:14:59.540 ⇒ 00:15:00.210 Nicolas Sucari: Yeah.
143 00:15:00.810 ⇒ 00:15:01.290 Payas Parab: Okay.
144 00:15:01.770 ⇒ 00:15:03.743 Brian Pei: Yeah, I can do that in one second.
145 00:15:03.990 ⇒ 00:15:05.929 Payas Parab: No worries. Take your time, Brian. No, no, no.
146 00:15:07.050 ⇒ 00:15:12.529 Brian Pei: If I did this right. And I’m just looking at all borderlines, and I do
147 00:15:12.710 ⇒ 00:15:19.069 Brian Pei: cogs divided by the total sales by title.
148 00:15:19.770 ⇒ 00:15:24.810 Brian Pei: See, I mean the the free stuff is going to be more than one.
149 00:15:24.910 ⇒ 00:15:28.760 Brian Pei: And then here’s the purse. Here’s the mark.
150 00:15:29.870 ⇒ 00:15:32.379 Brian Pei: I mean approximate margin. I guess.
151 00:15:32.380 ⇒ 00:15:36.640 Payas Parab: What did you join? This? Is this a joint with product variance like is the title coming from product.
152 00:15:36.932 ⇒ 00:15:43.960 Brian Pei: I’ll send it to you. This was, you didn’t have this yet. This is when I added product cost to to order line like.
153 00:15:44.360 ⇒ 00:15:44.760 Payas Parab: Okay.
154 00:15:44.760 ⇒ 00:15:46.009 Brian Pei: An hour ago.
155 00:15:46.130 ⇒ 00:15:50.439 Brian Pei: and by title it looks
156 00:15:50.470 ⇒ 00:15:52.070 Brian Pei: better.
157 00:15:52.070 ⇒ 00:15:54.110 Payas Parab: That does look that looks about right.
158 00:15:54.110 ⇒ 00:15:55.269 Brian Pei: 20% 18%.
159 00:15:55.270 ⇒ 00:15:55.950 Payas Parab: Yeah.
160 00:15:55.950 ⇒ 00:15:57.560 Brian Pei: Go down, but and then.
161 00:15:57.560 ⇒ 00:16:00.180 Payas Parab: What are? What are the 0 coming? What is the 0?
162 00:16:00.500 ⇒ 00:16:03.220 Brian Pei: It’s probably it just doesn’t have. Let’s see.
163 00:16:03.330 ⇒ 00:16:04.990 Brian Pei: Caught shipping.
164 00:16:05.900 ⇒ 00:16:08.200 Payas Parab: Oh, I see there’s no cogs tied to that. Yeah.
165 00:16:08.200 ⇒ 00:16:11.700 Brian Pei: I guess straws technically cost something, but they might have
166 00:16:11.950 ⇒ 00:16:13.149 Brian Pei: just not.
167 00:16:13.720 ⇒ 00:16:16.260 Brian Pei: Oh, this is because
168 00:16:16.430 ⇒ 00:16:18.049 Brian Pei: when I’m doing
169 00:16:19.980 ⇒ 00:16:24.490 Brian Pei: cost divided by the sales price. If it’s free, the denominator is going to be 0.
170 00:16:25.490 ⇒ 00:16:26.790 Payas Parab: Or the numerator. Yeah.
171 00:16:27.273 ⇒ 00:16:28.240 Brian Pei: Yeah? Or.
172 00:16:28.460 ⇒ 00:16:29.340 Brian Pei: yeah.
173 00:16:29.700 ⇒ 00:16:33.310 Brian Pei: Well, the sales price of a free straw would be 0.
174 00:16:33.570 ⇒ 00:16:34.689 Brian Pei: And I’m doing cogs.
175 00:16:34.690 ⇒ 00:16:39.150 Payas Parab: Oh, cogs divided by. And it’s not erroring. Then it’s just does 0. Then.
176 00:16:39.150 ⇒ 00:16:40.089 Brian Pei: Well, I did a case.
177 00:16:41.060 ⇒ 00:16:44.079 Brian Pei: It did by 0 error. I just would. I just very.
178 00:16:44.080 ⇒ 00:16:44.480 Payas Parab: It’s not.
179 00:16:44.480 ⇒ 00:16:46.040 Brian Pei: Quickly chicken scratched.
180 00:16:46.040 ⇒ 00:16:48.189 Payas Parab: No worries. No, it makes sense. Okay.
181 00:16:48.240 ⇒ 00:16:56.989 Payas Parab: alright, cool. Let me let me go play around with this, and just kind of see, and I just hope it somewhat aligns to that like that slide deck I showed you right on like the overall cost.
182 00:16:57.553 ⇒ 00:17:01.450 Payas Parab: That’ll make it easier also, if this is on Github. You can also just add me
183 00:17:01.570 ⇒ 00:17:02.940 Payas Parab: if that’s easier.
184 00:17:03.050 ⇒ 00:17:04.480 Payas Parab: as a collaborator.
185 00:17:05.140 ⇒ 00:17:08.160 Brian Pei: I was going to
186 00:17:09.880 ⇒ 00:17:15.291 Brian Pei: ask Nico to do that, because I don’t think I have the power to do that. But
187 00:17:15.800 ⇒ 00:17:21.360 Brian Pei: basically. And I, Nico does better job at showing this, because I was just pushing the code in
188 00:17:22.323 ⇒ 00:17:26.016 Brian Pei: what? It’s very straightforward.
189 00:17:29.100 ⇒ 00:17:32.269 Brian Pei: There’s sources which they’re they’re all yamls.
190 00:17:32.620 ⇒ 00:17:33.029 Payas Parab: And there’s.
191 00:17:33.030 ⇒ 00:17:35.890 Brian Pei: No business logic unless you want to add it.
192 00:17:36.000 ⇒ 00:17:45.629 Brian Pei: Sources are just what’s the name of the table? Right? So it’s usually like select star from whatever. This is all dev stuff. We know that, but it’s just to make sure that it’s working
193 00:17:47.300 ⇒ 00:17:48.750 Brian Pei: and.
194 00:17:49.370 ⇒ 00:17:56.430 Payas Parab: In theory, I could like make a data set right there using the cut that I made. Essentially like the the raw data I made is a snowflake table I made.
195 00:17:56.720 ⇒ 00:18:00.859 Payas Parab: Would I update it as a yaml? Or would that like cause any issues.
196 00:18:00.860 ⇒ 00:18:06.259 Brian Pei: You can do it as a model. The the there’s it goes, sources, models, and dashboards.
197 00:18:06.260 ⇒ 00:18:07.269 Payas Parab: I see. Okay.
198 00:18:07.270 ⇒ 00:18:12.320 Brian Pei: Courses are our yamls, where we try to just not have business logic.
199 00:18:12.610 ⇒ 00:18:13.950 Payas Parab: That makes sense. Okay, model.
200 00:18:13.950 ⇒ 00:18:15.929 Brian Pei: Model you can. So then, in the sequel.
201 00:18:15.930 ⇒ 00:18:16.490 Payas Parab: Okay.
202 00:18:16.490 ⇒ 00:18:23.230 Brian Pei: This is the name of a source. So you can do left join blah blah! I’ll do arithmetic. It’ll make a sequel.
203 00:18:23.270 ⇒ 00:18:24.530 Brian Pei: Query.
204 00:18:24.530 ⇒ 00:18:25.480 Payas Parab: In real.
205 00:18:25.730 ⇒ 00:18:37.510 Brian Pei: And then in dashboards it goes back to Yaml, where you tell it. The table which is the model here. It’s kind of confusing. But this is this.
206 00:18:37.690 ⇒ 00:18:43.260 Brian Pei: and then it’s like, what dimensions and measures do you want? And then you just like copy paste. This.
207 00:18:43.500 ⇒ 00:18:52.059 Nicolas Sucari: Yeah. But when when you run it locally also, and you already created the model and the model is correct, you can then create like automatically with AI, create the
208 00:18:52.090 ⇒ 00:18:54.819 Nicolas Sucari: the dashboard, and then you can just customize it.
209 00:18:54.970 ⇒ 00:19:00.490 Nicolas Sucari: So you don’t need to write like all of these. You see there on the top. It says this file was generated using AI
210 00:19:01.038 ⇒ 00:19:05.200 Nicolas Sucari: you can actually do that when you run it locally. Yeah.
211 00:19:06.810 ⇒ 00:19:08.509 Payas Parab: When you run it locally. Okay?
212 00:19:09.950 ⇒ 00:19:11.664 Nicolas Sucari: Do you? Do you have a
213 00:19:12.470 ⇒ 00:19:16.380 Nicolas Sucari: You have real already started real Brian, so we can maybe show you show.
214 00:19:16.700 ⇒ 00:19:22.890 Payas Parab: Yeah, I just love to know what it looks like. Cause I I basically just want to get this dashboard in its current form to
215 00:19:23.120 ⇒ 00:19:25.700 Payas Parab: the Cfo to be like, Okay, cool. We like at least.
216 00:19:25.700 ⇒ 00:19:33.732 Nicolas Sucari: Yeah, the the only thing in order to share that is we need to deploy these to real cloud. And maybe we’ll need an account.
217 00:19:34.080 ⇒ 00:19:44.779 Nicolas Sucari: So I’m gonna ask Patrick on, how can we create that account if we have like a trial version or something? So they don’t need to like subscribe now to any of their.
218 00:19:44.780 ⇒ 00:19:51.210 Payas Parab: Real cloud cost. I want to make sure we don’t come with a surprise of like. Oh, here’s another cost.
219 00:19:52.880 ⇒ 00:19:57.050 Nicolas Sucari: I think the pricing is. Let me check.
220 00:19:57.670 ⇒ 00:20:02.059 Nicolas Sucari: But it was like 200 bucks a month, something like that.
221 00:20:04.060 ⇒ 00:20:12.229 Nicolas Sucari: But maybe we can get discounts or something they kind, are they? They are like partner from us. So maybe we can talk with them and see
222 00:20:13.158 ⇒ 00:20:17.809 Nicolas Sucari: how we can do it. But yeah, in order to to deploy, we’ll need to create that account.
223 00:20:19.390 ⇒ 00:20:20.660 Payas Parab: Got it. Okay.
224 00:20:21.000 ⇒ 00:20:27.160 Payas Parab: yeah, we definitely like to get that deployed because the other thing, too, is like, if we’re already paying for snowflake. This also like makes me wonder
225 00:20:27.270 ⇒ 00:20:30.679 Payas Parab: like I built some stuff in streamlit before.
226 00:20:30.940 ⇒ 00:20:38.400 Payas Parab: like is streamlit part of our snowflake instance, because I was able to like make an app, I think, or like, get started on like a streamlit project.
227 00:20:39.210 ⇒ 00:20:43.169 Payas Parab: And I’m like wondering if that’s included, too, if we could. Just
228 00:20:43.250 ⇒ 00:20:48.830 Payas Parab: I I don’t wanna basically what I want to avoid now, especially after I spent like 2 h on this fucking spreadsheet is like
229 00:20:48.910 ⇒ 00:20:55.480 Payas Parab: doing a bunch of intermediate stuff that’s not going to be the final product. But if you guys can figure out how we can get to
230 00:20:56.230 ⇒ 00:21:04.430 Payas Parab: like streamline or not, streamline sorry, real cloud, like kind of faster. Just so we can like get something up and running and being like, Hey, here it is.
231 00:21:04.941 ⇒ 00:21:10.850 Payas Parab: That would be great cause I know how to do streamlet and like streamlet, you could deploy pretty easily on cloud.
232 00:21:14.680 ⇒ 00:21:17.989 Payas Parab: we’ll just need to give people the snowflake access.
233 00:21:20.870 ⇒ 00:21:27.810 Payas Parab: so we could do that as well. If if we want, I just don’t want to like make an intermediate version that’s ultimately gonna go in real because everything else is in real.
234 00:21:28.800 ⇒ 00:21:33.530 Payas Parab: So yeah, if you can figure out like how we can get like a cloud version or something that’s like shareable
235 00:21:34.118 ⇒ 00:21:38.850 Payas Parab: even if it’s like a dev version, not with like live data or something. Just to show
236 00:21:38.890 ⇒ 00:21:44.589 Payas Parab: this is what it will look like and it, once we connect it, it will be auto refreshing that that would just be helpful.
237 00:21:46.960 ⇒ 00:21:48.460 Brian Pei: Has the client
238 00:21:48.530 ⇒ 00:21:53.460 Brian Pei: said, whether they prefer real or streamline, or they just like whatever works.
239 00:21:53.460 ⇒ 00:21:56.650 Payas Parab: They’re just like whatever they’re they’re just like. Their their whole thing is like.
240 00:21:56.650 ⇒ 00:21:57.170 Brian Pei: Okay.
241 00:21:57.170 ⇒ 00:22:02.330 Payas Parab: Which is fair, which is, hey? If it’s a spreadsheet, I can just do this myself. And I’m like, Yeah, that’s fair. You can. So
242 00:22:02.360 ⇒ 00:22:07.968 Payas Parab: let’s real and streamline, I think, will make the data more interactive.
243 00:22:08.790 ⇒ 00:22:15.890 Payas Parab: and like, also auto refresh right streamlit, refreshing data kind of a pain in the ass like not trivial.
244 00:22:16.030 ⇒ 00:22:23.170 Payas Parab: So if real, is faster and better right, which it seems like, it is because I can just put those SQL. Queries as like a dot SQL. File in that folder
245 00:22:23.420 ⇒ 00:22:26.989 Payas Parab: and push it like that. That’s pretty easy, right like to me.
246 00:22:28.500 ⇒ 00:22:37.219 Brian Pei: Should be. I am stressed out because my notion would not load and give me the directions of something that I should have memorized by now, but I don’t.
247 00:22:37.580 ⇒ 00:22:38.860 Brian Pei: so I am
248 00:22:38.920 ⇒ 00:22:41.059 Brian Pei: freaking out trying to show you.
249 00:22:43.400 ⇒ 00:22:44.070 Brian Pei: Oh, my God!
250 00:22:44.070 ⇒ 00:22:48.660 Payas Parab: That’s why we we have these internal calls. These are more chill. It’s not like the client hounding us.
251 00:22:48.660 ⇒ 00:22:51.169 Brian Pei: But, please, dear God, just let me
252 00:22:53.470 ⇒ 00:22:54.530 Brian Pei: create
253 00:22:54.590 ⇒ 00:22:56.170 Brian Pei: what is what is happening.
254 00:22:59.610 ⇒ 00:23:02.619 Payas Parab: Yeah, Nico, if we can just get like I and I can like move those tables.
255 00:23:02.620 ⇒ 00:23:02.890 Nicolas Sucari: Yeah.
256 00:23:02.890 ⇒ 00:23:06.140 Payas Parab: Like I have the SQL. Query. And then, if there’s just a way
257 00:23:06.270 ⇒ 00:23:11.809 Payas Parab: I can like quickly turn that into something that like can be visually viewed like it can.
258 00:23:11.810 ⇒ 00:23:12.130 Nicolas Sucari: Yes.
259 00:23:12.130 ⇒ 00:23:13.380 Payas Parab: Went then.
260 00:23:13.750 ⇒ 00:23:20.009 Payas Parab: like I’m good to just get that by the end of the week to Jared, and be like, Hey, cool like. Here’s the next step, and this would be
261 00:23:20.050 ⇒ 00:23:22.610 Payas Parab: and auto refresh data. You know.
262 00:23:24.620 ⇒ 00:23:27.140 Nicolas Sucari: Yeah, give me. Let me share.
263 00:23:27.840 ⇒ 00:23:29.869 Nicolas Sucari: This is working right now.
264 00:23:29.870 ⇒ 00:23:30.350 Brian Pei: By the time
265 00:23:31.140 ⇒ 00:23:33.630 Brian Pei: I get notion to load
266 00:23:33.660 ⇒ 00:23:34.930 Brian Pei: I’m going to
267 00:23:35.160 ⇒ 00:23:37.450 Brian Pei: end it all. I swear.
268 00:23:37.450 ⇒ 00:23:39.679 Nicolas Sucari: Let me see if you if you can see it.
269 00:23:43.430 ⇒ 00:23:44.680 Nicolas Sucari: you can see the screen.
270 00:23:46.206 ⇒ 00:23:48.420 Payas Parab: Give me one second. Yes, I can.
271 00:23:48.420 ⇒ 00:23:49.180 Brian Pei: I can.
272 00:23:49.180 ⇒ 00:23:51.020 Nicolas Sucari: Cool. So
273 00:23:51.280 ⇒ 00:24:05.039 Nicolas Sucari: I follow these steps that we have here in the notion I mean, I just installed real first, st then navigated to the folder. The folder is just going to the place. We have this Javi coffee real folder, and then starting real.
274 00:24:05.080 ⇒ 00:24:17.420 Nicolas Sucari: I I you you will need to create the same file as I said because this we need to add, like your credentials. This is kind of my credentials. But yeah, if you load your credentials. Here you it will connect to Snowflake
275 00:24:17.480 ⇒ 00:24:22.720 Nicolas Sucari: directly with your account, and then it will bring in local host this
276 00:24:22.790 ⇒ 00:24:27.019 Nicolas Sucari: view of how to like manage all of the sources and models.
277 00:24:27.020 ⇒ 00:24:27.839 Payas Parab: Got it.
278 00:24:27.840 ⇒ 00:24:41.259 Nicolas Sucari: For for real right? So right now, it’s giving me. Maybe it’s trying yeah, trying to load all of these ones. It’s working yet but once the the source is already loaded, you will see here, all of the
279 00:24:41.310 ⇒ 00:24:45.039 Nicolas Sucari: same tables that we have in Snowflake, because we are just doing a select star.
280 00:24:45.780 ⇒ 00:24:46.260 Payas Parab: Everything.
281 00:24:46.260 ⇒ 00:24:54.940 Nicolas Sucari: Okay? And then you can create the models from it. So here we have the model that Brian created is just like the same select star
282 00:24:55.090 ⇒ 00:25:03.149 Nicolas Sucari: for this one, but you can add, like your query here, you can do it right here, or you can do it also in Vs code. Create a branch and then
283 00:25:03.250 ⇒ 00:25:17.719 Nicolas Sucari: may make a pull request right? Because any change you’re doing here, as it’s local host will create that that change to your local repo, right? And then you need to commit and just push the changes to have it live or to for everyone to have it.
284 00:25:17.800 ⇒ 00:25:24.130 Nicolas Sucari: And then from this model you can. You can go to the dashboard. I don’t know why the dashboard is failing here.
285 00:25:24.570 ⇒ 00:25:33.740 Nicolas Sucari: so this doesn’t not exist. Let me recreate it. I just delete the the dashboard. So if I go here in dashboards, I don’t have nothing. That’s okay.
286 00:25:33.920 ⇒ 00:25:39.420 Nicolas Sucari: And now, if I go to models as this model is working. I can click here, generate dashboard with AI.
287 00:25:41.840 ⇒ 00:25:43.210 Nicolas Sucari: So let’s do it again.
288 00:25:45.340 ⇒ 00:25:57.690 Nicolas Sucari: It will automatically create that file dashboard with those metrics, labels, metrics, and measures. Yeah, here everything. And then you can preview. And you can see the actual dashboard with the data.
289 00:25:57.690 ⇒ 00:25:59.549 Payas Parab: Amazing. Okay, fuck.
290 00:25:59.840 ⇒ 00:26:02.490 Payas Parab: And then if I wanted to like, keep this, I could.
291 00:26:02.890 ⇒ 00:26:10.400 Nicolas Sucari: Yeah, you can go to edit metrics here. You can like, actually change this any of the labels, any. You can add them.
292 00:26:10.400 ⇒ 00:26:16.749 Payas Parab: How do I actually make like? Let’s say, it’s like, Okay, I want a line graph of some of something like, you know, like, how would I
293 00:26:17.840 ⇒ 00:26:19.090 Payas Parab: kind of go deep.
294 00:26:19.600 ⇒ 00:26:34.959 Nicolas Sucari: So so right now, real like only like like the visual stuff or the components. You will have like these like time series. With the measures and all of the dimensions here. Right? So right you you can’t like create like a bar chart or a pie chart.
295 00:26:34.960 ⇒ 00:26:37.779 Payas Parab: Oh, I see. I see that makes sense. Okay.
296 00:26:38.290 ⇒ 00:26:58.660 Nicolas Sucari: So it’s only this, yeah, you don’t customize like the type of graph, you just add measures and dimensions. And then, yeah, you can do kind of some tweaks. I should go through the documentation to see what else we can do. But then, for example, if you can like, if you want to dig in total orders, you can click. You can change here for a bar chart, but these are the only.
297 00:26:58.660 ⇒ 00:26:59.820 Payas Parab: Oh, nice!
298 00:26:59.820 ⇒ 00:27:00.700 Nicolas Sucari: It’s real.
299 00:27:00.700 ⇒ 00:27:04.389 Payas Parab: Okay, this is super clutch. This is better than streamline, for sure.
300 00:27:05.700 ⇒ 00:27:22.130 Brian Pei: When you generate with AI the dashboard, it looks at that snowflake table, and it’s like, if it’s our car, it’s a dimension. If it’s numeric, it’s gonna be a measure. And we know that measures can be plotted on a chart. So that’s why it was like a 1 click. And you get all of it. And then with that.
301 00:27:22.130 ⇒ 00:27:22.819 Payas Parab: Generated dashboard.
302 00:27:22.820 ⇒ 00:27:24.470 Brian Pei: Yaml, if you want to make.
303 00:27:24.470 ⇒ 00:27:24.870 Nicolas Sucari: Yeah.
304 00:27:24.870 ⇒ 00:27:30.830 Brian Pei: Want to reorder it or make a just refunds, or whatever all you have to do is take out like you can make.
305 00:27:30.830 ⇒ 00:27:31.629 Payas Parab: Yeah, this makes.
306 00:27:31.630 ⇒ 00:27:32.190 Brian Pei: 1 million.
307 00:27:32.905 ⇒ 00:27:33.620 Payas Parab: Dashboard!
308 00:27:33.620 ⇒ 00:27:34.279 Brian Pei: Yeah, mostly
309 00:27:34.940 ⇒ 00:27:37.369 Brian Pei: dashboard, yaml and order subscription.
310 00:27:37.370 ⇒ 00:27:41.329 Payas Parab: Damn realist cracked. I’ve never I didn’t realize it was this crack. This is sick.
311 00:27:41.330 ⇒ 00:27:42.260 Brian Pei: It’s just
312 00:27:42.790 ⇒ 00:27:43.699 Brian Pei: pretty simple.
313 00:27:43.700 ⇒ 00:27:44.420 Nicolas Sucari: I mean he’s.
314 00:27:44.420 ⇒ 00:27:53.839 Brian Pei: Even though the presentation is like just like the rebuilt line charts. But that just means you don’t have to edit all the graphs and people like line charts like who.
315 00:27:55.870 ⇒ 00:27:56.920 Payas Parab: Yes.
316 00:27:56.970 ⇒ 00:28:00.050 Payas Parab: yeah, this is cool. Wow, okay, alright sweet.
317 00:28:00.390 ⇒ 00:28:14.560 Payas Parab: I’m good to go. Then if you guys want to add me to the repo, then I can start kind of making some stuff. I’ll make a branch of my own, and then if we can. Yeah, if you want to, just give me. My github is at pies, prob like it’s just I can put in the group. Chat.
318 00:28:15.175 ⇒ 00:28:15.790 Nicolas Sucari: Yeah.
319 00:28:15.960 ⇒ 00:28:17.830 Nicolas Sucari: So let me see.
320 00:28:18.050 ⇒ 00:28:19.940 Nicolas Sucari: Voice teams, general.
321 00:28:26.200 ⇒ 00:28:28.480 Nicolas Sucari: how can I put you here?
322 00:28:29.245 ⇒ 00:28:29.569 Payas Parab: Cool.
323 00:28:29.570 ⇒ 00:28:31.510 Nicolas Sucari: Okay, collaborators and teams.
324 00:28:33.190 ⇒ 00:28:34.610 Nicolas Sucari: 2 factor
325 00:28:34.880 ⇒ 00:28:36.040 Nicolas Sucari: meet.
326 00:28:44.090 ⇒ 00:28:47.649 Nicolas Sucari: Cool. Yeah, so have people.
327 00:28:49.090 ⇒ 00:28:52.990 Payas Parab: Why wouldn’t you just denote that? It’s like the the time series is, yeah, that’s me.
328 00:28:53.946 ⇒ 00:29:04.860 Payas Parab: The time series is like, you know, whatever the time, whatever that field was, where it’s like time series created at then I don’t even have to like truncate by date or week. It can kind of cut the data itself.
329 00:29:07.740 ⇒ 00:29:09.660 Payas Parab: Right? Can I send you back in the room.
330 00:29:09.660 ⇒ 00:29:10.660 Nicolas Sucari: Can you repeat that.
331 00:29:10.660 ⇒ 00:29:16.856 Payas Parab: Yeah, can we go back to the real real quick? So if I wanted to like you saw, I don’t know if you saw got a chance to yet in the the
332 00:29:17.465 ⇒ 00:29:23.089 Payas Parab: excel where I have like a week over week trend. And I want to like, observe that week over week trend like.
333 00:29:23.310 ⇒ 00:29:27.439 Payas Parab: Is there an easy way to like? Kind of? Oh, I guess. Compare against right.
334 00:29:27.750 ⇒ 00:29:42.739 Nicolas Sucari: Yeah, exactly. I mean, you can filter down custom dates or week, yeah, or weeks you want. For example, I don’t know. Last 14 days, and then you can compare for previous period like, say, this is like the same 14 days. But before
335 00:29:42.790 ⇒ 00:29:50.579 Nicolas Sucari: these ones, or you can change that to previous months. So it’s same same dates, but previous months or previous quarter, year or custom.
336 00:29:50.620 ⇒ 00:29:56.090 Nicolas Sucari: So you can do these comparisons, and you can change by day, by hour by week, we can add more
337 00:29:56.130 ⇒ 00:30:09.380 Nicolas Sucari: kind of these options. There are a little bit of yeah, we can add years or quarters here and how to compare. But yeah, you you can like easily compare. Now here, for example, orders between
338 00:30:09.460 ⇒ 00:30:12.380 Nicolas Sucari: 14 days on September and 14 days in August.
339 00:30:14.220 ⇒ 00:30:14.850 Payas Parab: And then.
340 00:30:14.850 ⇒ 00:30:15.770 Nicolas Sucari: For everything.
341 00:30:16.300 ⇒ 00:30:34.550 Nicolas Sucari: and all of the dimensions will show what it’s saying here. So you can change. What is the dimension like the values that we’re showing for each dimension. For example, if you wanna see total revenue or the cancel reason for detailed with the total revenue amount, you can see it here.
342 00:30:34.850 ⇒ 00:30:36.990 Nicolas Sucari: Comparison and the variance. Yeah.
343 00:30:37.240 ⇒ 00:30:43.990 Payas Parab: Yeah, I think I think he’ll be once we get this data and like that usable format, I think it’ll be. This will be exactly what he’s looking for.
344 00:30:44.596 ⇒ 00:30:45.189 Payas Parab: Can you.
345 00:30:45.190 ⇒ 00:30:52.689 Nicolas Sucari: Yeah. And and it’s pretty. It’s pretty quick if you want. I don’t know if you are seeing here, let me go to total orders.
346 00:30:52.810 ⇒ 00:30:57.459 Nicolas Sucari: Let’s go. Let’s see if if you wanna see like easily. Wh, which are the
347 00:30:58.102 ⇒ 00:31:05.630 Nicolas Sucari: let me see the yeah. The orders in Texas. You just click here on the dimension and filters everything on the view.
348 00:31:05.770 ⇒ 00:31:10.669 Nicolas Sucari: just for the Texas one. And it’s like Super quick to do like these kind of queries.
349 00:31:11.630 ⇒ 00:31:14.019 Brian Pei: Yeah. It caches everything first, st and then it.
350 00:31:14.970 ⇒ 00:31:21.519 Payas Parab: So for sure. Shopify orders, metrics right now that we have this this kind of table. Here, right?
351 00:31:21.780 ⇒ 00:31:24.529 Payas Parab: The shopify orders. Metrics like.
352 00:31:24.710 ⇒ 00:31:31.609 Payas Parab: is this thing like? Is there a way to like validate? Check this, or is this like once you’ve got it? And you’re pretty confident on the underlying tables
353 00:31:31.720 ⇒ 00:31:41.060 Payas Parab: you can like. Just this is like good to go like, I’m just curious in your experience, like what validation we do at this layer cause this looks like good to me, but I like don’t know right.
354 00:31:42.350 ⇒ 00:31:43.590 Nicolas Sucari: For I mean.
355 00:31:43.960 ⇒ 00:31:51.250 Brian Pei: Yeah, validation means. So Nico is looking at the Dev table. Obviously, right now.
356 00:31:53.200 ⇒ 00:31:55.430 Brian Pei: when when I’m
357 00:31:55.770 ⇒ 00:32:00.600 Brian Pei: migrate, the Dev code, to quote, unquote prod.
358 00:32:01.210 ⇒ 00:32:02.770 Brian Pei: The data won’t
359 00:32:04.207 ⇒ 00:32:11.589 Brian Pei: change much. Besides, Dbt has an orchestrator. So it updates daily orders.
360 00:32:13.350 ⇒ 00:32:14.390 Brian Pei: the
361 00:32:14.670 ⇒ 00:32:17.990 Brian Pei: the meetings we have with Aman are
362 00:32:18.340 ⇒ 00:32:21.699 Brian Pei: basically the the data validation. I
363 00:32:21.960 ⇒ 00:32:25.070 Brian Pei: have all of their shopify data.
364 00:32:25.100 ⇒ 00:32:29.150 Brian Pei: And I tried to clean it and transform it and put it in here
365 00:32:29.260 ⇒ 00:32:33.499 Brian Pei: and then, usually. And so if there’s a spike somewhere
366 00:32:33.640 ⇒ 00:32:39.379 Brian Pei: that requires custom business sequel that I maybe didn’t know about
367 00:32:40.570 ⇒ 00:32:41.700 Brian Pei: it’s
368 00:32:41.780 ⇒ 00:32:49.750 Brian Pei: it’s a transactionatory process, because I wouldn’t know the business in, in and out from a financial standpoint.
369 00:32:51.060 ⇒ 00:32:52.270 Brian Pei: it’s just
370 00:32:52.530 ⇒ 00:32:55.370 Brian Pei: here’s your shopify data, all or nothing.
371 00:32:55.430 ⇒ 00:33:04.200 Brian Pei: If you want me to put filters on things, for example, like, Oh, we had test accounts in 2011. Can you exclude those.
372 00:33:04.490 ⇒ 00:33:04.830 Payas Parab: Right.
373 00:33:04.830 ⇒ 00:33:10.210 Brian Pei: Changes, and it updates in Snowflake, and then real will catch up. There’s no like
374 00:33:10.828 ⇒ 00:33:14.220 Brian Pei: I mean, unless you give me like an excel sheet of
375 00:33:14.320 ⇒ 00:33:20.099 Brian Pei: from them. Here are our monthly order counts, and like roughly
376 00:33:20.650 ⇒ 00:33:26.930 Brian Pei: estimated revenue. Then, of course, like I’ll write a SQL. Query, and I’ll check that those numbers match.
377 00:33:28.253 ⇒ 00:33:36.026 Payas Parab: That’s 1 thing he he did provide he did provide like a screenshot from shopify. I’m on. Never got us the access. But
378 00:33:36.861 ⇒ 00:33:46.760 Payas Parab: I’m I he did get us like a screenshot of from shopify that we want to try and reconcile that. I wanna make sure we get done as well. I can show you.
379 00:33:47.935 ⇒ 00:33:48.719 Payas Parab: Yeah.
380 00:33:49.450 ⇒ 00:34:05.999 Nicolas Sucari: Yeah, but that validation is part of the process. I mean, we can get the data from Snowflake, as Brian is saying. But then we will need like to check if that information that we’re getting is accurate matching it with shopify. But it’s not like a constant validation every time we do, we do this.
381 00:34:06.000 ⇒ 00:34:07.960 Payas Parab: Yeah, yeah, that makes sense.
382 00:34:09.320 ⇒ 00:34:09.690 Nicolas Sucari: Okay.
383 00:34:09.699 ⇒ 00:34:10.389 Payas Parab: Okay.
384 00:34:11.239 ⇒ 00:34:12.034 Payas Parab: Great.
385 00:34:14.739 ⇒ 00:34:15.599 Payas Parab: All right.
386 00:34:15.600 ⇒ 00:34:16.420 Nicolas Sucari: Cool.
387 00:34:16.780 ⇒ 00:34:17.630 Payas Parab: Awesome.
388 00:34:17.969 ⇒ 00:34:24.749 Nicolas Sucari: Let me know. I think I already invited you here. So yeah, you should be able to access the repo
389 00:34:25.083 ⇒ 00:34:39.160 Nicolas Sucari: ideally every time. Now that we are making any change to the real stuff, we can create a branch and follow kind of an approval process. Right? So maybe you can add a reviewer for the Pr. And we can go through that just to add
390 00:34:39.429 ⇒ 00:34:46.979 Nicolas Sucari: things there and try not to mess up anything here. But yeah, I think it’s pretty simple. I mean, once you have the sources.
391 00:34:47.659 ⇒ 00:34:52.369 Nicolas Sucari: create the model files and then create any, the amount of dashboards that you want.
392 00:34:52.389 ⇒ 00:35:06.019 Nicolas Sucari: I’m gonna go investigate a little bit more what we need to deploy because when we click here to deploy or share, yeah, yeah, we need to create like the account and kind of see pricing. And that kind of stuff. Okay.
393 00:35:06.260 ⇒ 00:35:08.219 Payas Parab: Got it. Okay, sounds good.
394 00:35:09.720 ⇒ 00:35:10.490 Payas Parab: cool.
395 00:35:12.540 ⇒ 00:35:16.920 Nicolas Sucari: Yeah, I don’t know if we need anything else, for now.
396 00:35:17.320 ⇒ 00:35:19.770 Payas Parab: I think we’re good for now then, yep.
397 00:35:20.490 ⇒ 00:35:21.410 Nicolas Sucari: Excellent
398 00:35:22.290 ⇒ 00:35:23.296 Nicolas Sucari: great guys.
399 00:35:23.800 ⇒ 00:35:29.669 Brian Pei: Yeah, if you can reset or try to reset the Dbt cloud password. That’s the only thing that I need.
400 00:35:29.670 ⇒ 00:35:30.799 Nicolas Sucari: Oh, sorry. Yeah.
401 00:35:31.080 ⇒ 00:35:33.960 Nicolas Sucari: let me show you, because I already got access to
402 00:35:39.050 ⇒ 00:35:40.960 Nicolas Sucari: to the Gmail account.
403 00:35:41.440 ⇒ 00:35:43.233 Payas Parab: You guys mind if I drop off
404 00:35:43.490 ⇒ 00:35:44.930 Nicolas Sucari: Yeah, yeah, that’s fine.
405 00:35:45.290 ⇒ 00:35:46.659 Payas Parab: Alright! Bye, guys!
406 00:35:48.460 ⇒ 00:35:49.179 Nicolas Sucari: Bye, bye!
407 00:35:50.042 ⇒ 00:35:52.779 Nicolas Sucari: Where I have it. Give me a minute
408 00:35:58.020 ⇒ 00:36:02.480 Nicolas Sucari: here. This is the Javi one, so I I don’t know if.
409 00:36:03.240 ⇒ 00:36:03.710 Brian Pei: Yes.
410 00:36:03.710 ⇒ 00:36:05.390 Nicolas Sucari: And anything from Dvt.
411 00:36:06.158 ⇒ 00:36:08.250 Brian Pei: Can you check spam? Maybe.
412 00:36:10.890 ⇒ 00:36:11.560 Brian Pei: Nope.
413 00:36:11.670 ⇒ 00:36:12.340 Brian Pei: darn it.
414 00:36:12.340 ⇒ 00:36:13.149 Nicolas Sucari: Trash, Nope.
415 00:36:14.300 ⇒ 00:36:17.539 Nicolas Sucari: Or try to do it right now, and I can give you a code or anything. I don’t.
416 00:36:17.540 ⇒ 00:36:19.400 Brian Pei: Yeah, okay, let me do it right now.
417 00:36:21.280 ⇒ 00:36:22.829 Brian Pei: Deep to cloud
418 00:36:23.130 ⇒ 00:36:29.019 Brian Pei: email address is Bobby coffee@rimingforge.ai
419 00:36:29.410 ⇒ 00:36:31.800 Brian Pei: going to click forgot password.
420 00:36:32.100 ⇒ 00:36:33.950 Brian Pei: Please, resubmit.
421 00:36:37.190 ⇒ 00:36:38.440 Brian Pei: continue.
422 00:36:41.980 ⇒ 00:36:44.490 Brian Pei: Okay. It says, reset
423 00:36:44.620 ⇒ 00:36:46.279 Brian Pei: password link sent.
424 00:36:48.050 ⇒ 00:36:52.230 Nicolas Sucari: So in order to access the Gmail account, you need to
425 00:36:52.842 ⇒ 00:36:59.720 Nicolas Sucari: open it with one password, because the 2 factor, I mean there is no 2 factor but the
426 00:37:00.080 ⇒ 00:37:02.150 Nicolas Sucari: like. Pass keys in one password.
427 00:37:04.130 ⇒ 00:37:05.760 Brian Pei: I see I’m
428 00:37:06.190 ⇒ 00:37:07.920 Brian Pei: really bad with one password
429 00:37:09.660 ⇒ 00:37:10.199 Nicolas Sucari: Yeah. Don’t worry.
430 00:37:10.200 ⇒ 00:37:12.110 Brian Pei: You try refreshing.
431 00:37:13.540 ⇒ 00:37:15.050 Brian Pei: Maybe.
432 00:37:17.220 ⇒ 00:37:20.790 Brian Pei: I swear Dbt, cloud is so slow.
433 00:37:22.036 ⇒ 00:37:23.329 Brian Pei: Okay. Well.
434 00:37:24.520 ⇒ 00:37:27.200 Brian Pei: we don’t have to wait here all day. I will.
435 00:37:30.100 ⇒ 00:37:31.800 Nicolas Sucari: Do we do we have.
436 00:37:34.410 ⇒ 00:37:38.860 Brian Pei: So I, basically, I just have to log in using one password.
437 00:37:39.610 ⇒ 00:37:42.540 Nicolas Sucari: Like, yeah. Here, if you go to the Bringford Javi
438 00:37:43.370 ⇒ 00:37:59.280 Nicolas Sucari: space vault here in one password you can then access, and when when it says like, if you’re logged in to one password, then it will appear the top right, I think. And it says, like sign into Google Jabby, I don’t know something like that.
439 00:37:59.410 ⇒ 00:38:00.850 Nicolas Sucari: and it will go in.
440 00:38:00.970 ⇒ 00:38:06.039 Nicolas Sucari: It will ask you to set up a 2 factor, but you can just postpone it.
441 00:38:07.660 ⇒ 00:38:10.890 Brian Pei: Okay, I I can do it. Then we don’t have to wait to see if the
442 00:38:12.075 ⇒ 00:38:12.880 Brian Pei: email.
443 00:38:13.290 ⇒ 00:38:17.790 Nicolas Sucari: Oh, yeah, let let me know if that doesn’t work. And yeah.
444 00:38:18.030 ⇒ 00:38:19.582 Brian Pei: Okay. Will do
445 00:38:20.650 ⇒ 00:38:22.570 Brian Pei: sweet cool. It’s a good meeting.
446 00:38:23.240 ⇒ 00:38:24.160 Nicolas Sucari: Yeah. Great meeting.
447 00:38:24.160 ⇒ 00:38:24.920 Brian Pei: Thanks for all the help.
448 00:38:24.920 ⇒ 00:38:25.780 Nicolas Sucari: Thank you, Brian.
449 00:38:25.950 ⇒ 00:38:27.459 Brian Pei: Alright! I’ll talk to you soon.