Meeting Title: ☕ Javvy Coffee Intro Date: 2024-10-25 Meeting participants: Luke Daque, Brian Pei, Nicolas Sucari


WEBVTT

1 00:01:09.640 00:01:10.500 Nicolas Sucari: Hey, guys.

2 00:01:10.860 00:01:13.389 Luke Daque: Hello, Nico! Hello, Brian!

3 00:01:14.070 00:01:14.880 Nicolas Sucari: Hi! Ryan.

4 00:01:15.390 00:01:16.230 Luke Daque: Happy. Friday.

5 00:01:17.060 00:01:18.910 Brian Pei: Going to Florida in like an hour.

6 00:01:19.210 00:01:20.450 Luke Daque: Oh, cool!

7 00:01:20.450 00:01:24.850 Nicolas Sucari: Nice. Okay, yeah. Sorry for the short notice on the meeting.

8 00:01:26.000 00:01:27.150 Nicolas Sucari: yeah. Yeah.

9 00:01:27.560 00:01:42.019 Nicolas Sucari: The idea was just to introduce Ryan to Javi, and maybe we can schedule something if you’re traveling now, Brian, for next week, I don’t know if you’re gonna have time, Floria, to, so that you can give him like update on what you’ve been doing for Javi.

10 00:01:42.060 00:01:43.719 Nicolas Sucari: I was gonna do that.

11 00:01:43.720 00:01:48.459 Brian Pei: Right now, but also I’m bringing my laptop, so we can do that whenever

12 00:01:50.180 00:01:51.080 Brian Pei: I’ll be around.

13 00:01:52.460 00:01:58.869 Nicolas Sucari: Excellent just for introductions, if you can. Share what you’ve been doing that now that’s great.

14 00:01:58.900 00:02:11.140 Nicolas Sucari: And Ryan, just for you to know we have like a 10 h gap with Javi. We are doing de and ae work for them. I’m handling most of the real stuff

15 00:02:11.160 00:02:13.567 Nicolas Sucari: for now and

16 00:02:14.430 00:02:29.830 Nicolas Sucari: they they have. We’re working with bungalow insights with Robert. I think you know Robert right and Payas, that’s from his team, too, and they are working also in Meta base. And they are gonna be creating some visualizations there.

17 00:02:29.860 00:02:33.659 Nicolas Sucari: Javi is a coffee

18 00:02:34.430 00:02:46.710 Nicolas Sucari: e-commerce, I think. Yeah, maybe looking. Yeah. They have like these coffee concentrates syrups and yeah other stuff. But they they are like these e-commerce. They sell

19 00:02:46.800 00:02:59.110 Nicolas Sucari: in shopify Amazon. And I think tick Tock is one of their biggest other platform. But yeah, they saw this, and we are just providing data insights for them.

20 00:03:00.310 00:03:02.000 Nicolas Sucari: Pretty? Brian will. Yeah.

21 00:03:02.000 00:03:03.970 Brian Pei: Easy product cause they just

22 00:03:04.550 00:03:05.760 Brian Pei: be in syrups.

23 00:03:05.760 00:03:06.500 Luke Daque: Yeah.

24 00:03:09.040 00:03:17.040 Luke Daque: yeah, I’m looking at the repo. Looks like, I have access to the repository. So yeah, I see there’s like, shopify and Amazon

25 00:03:18.750 00:03:22.810 Luke Daque: models. And then like orders, basically in order lines.

26 00:03:22.810 00:03:28.580 Brian Pei: Yeah, I was gonna go through all that right now, as soon as I get your email address.

27 00:03:28.580 00:03:31.060 Luke Daque: Oh, yeah, let me just ping it here

28 00:03:31.370 00:03:32.870 Brian Pei: Got it here so I can

29 00:03:35.620 00:03:38.229 Brian Pei: see. How do you spell your last name?

30 00:03:38.860 00:03:40.999 Luke Daque: DAQU, e, yeah.

31 00:03:41.000 00:03:43.879 Brian Pei: DAQU e boom.

32 00:03:45.650 00:03:47.439 Brian Pei: I’m gonna send this to you, but.

33 00:03:47.830 00:03:48.630 Luke Daque: Cool.

34 00:03:48.630 00:03:51.219 Brian Pei: It’s always password. 1, 2, 3, to start.

35 00:03:51.570 00:03:52.620 Luke Daque: Sure.

36 00:03:54.000 00:03:55.580 Luke Daque: Okay, so.

37 00:03:55.790 00:04:01.420 Brian Pei: Snowflake. I’m gonna write a slack message to us all with login stuff.

38 00:04:01.900 00:04:02.870 Luke Daque: Nice, cool.

39 00:04:03.370 00:04:08.650 Brian Pei: And ducky and password. 1, 2, 3 is Snowflake.

40 00:04:09.100 00:04:10.669 Brian Pei: Let’s do that first.st

41 00:04:12.900 00:04:19.089 Brian Pei: So the 3 tools that I’m always in are ones that you will be familiar with.

42 00:04:20.240 00:04:21.000 Luke Daque: Cram!

43 00:04:21.370 00:04:22.620 Brian Pei: 5 tran.

44 00:04:22.820 00:04:23.820 Brian Pei: which

45 00:04:24.930 00:04:25.990 Brian Pei: is

46 00:04:26.110 00:04:30.555 Brian Pei: more straightforward than all of the other clients to be honest.

47 00:04:30.960 00:04:31.560 Luke Daque: Right.

48 00:04:31.560 00:04:33.529 Brian Pei: 5, Tran, let me send you.

49 00:04:33.630 00:04:38.360 Brian Pei: And also all this stuff obviously, is not 2 factored. So we share Java.

50 00:04:38.360 00:04:39.040 Luke Daque: And then.

51 00:04:39.040 00:04:41.390 Brian Pei: So try not to turn that on.

52 00:04:42.073 00:04:44.739 Brian Pei: Gonna send you the password for that. Okay?

53 00:04:45.772 00:04:49.630 Brian Pei: So there’s 3 connectors going here.

54 00:04:50.530 00:04:54.289 Brian Pei: They have not had any issues. They sync once every 24 h.

55 00:04:54.310 00:04:56.389 Brian Pei: you gotta see. Actually, there’s 2 you got Amazon.

56 00:04:56.390 00:04:57.830 Luke Daque: Yeah. Shopify.

57 00:04:57.830 00:05:00.700 Brian Pei: Trend. Metadata is just their their metadata.

58 00:05:03.710 00:05:04.240 Brian Pei: this one.

59 00:05:04.240 00:05:15.439 Nicolas Sucari: Yeah. The only thing to be aware of Fivetran is the costs we need to look into which tables we are using and try to deselect the ones that we are not. Because, if not, the costs, like.

60 00:05:15.947 00:05:19.879 Nicolas Sucari: yeah, increase a lot. So yeah, that’s the only thing on 5.

61 00:05:19.880 00:05:25.639 Brian Pei: Which I did already do, but could maybe do more and more as as they go on.

62 00:05:26.080 00:05:28.929 Brian Pei: And then let me also write for you.

63 00:05:29.250 00:05:33.570 Brian Pei: So Bra is 5 tran landing. Oh, shoot.

64 00:05:33.570 00:05:34.349 Luke Daque: I did not.

65 00:05:34.350 00:05:35.300 Brian Pei: Give you.

66 00:05:39.180 00:05:39.809 Brian Pei: mind you do.

67 00:05:39.810 00:05:41.609 Luke Daque: Calendar. Yeah, it’s fine.

68 00:05:41.610 00:05:44.498 Brian Pei: You can go. That is, master, that’s everything.

69 00:05:45.140 00:05:45.710 Luke Daque: Okay.

70 00:05:45.894 00:05:48.109 Brian Pei: So I’m going to write this all out to you. But raw

71 00:05:48.582 00:05:49.729 Brian Pei: is 5 trend.

72 00:05:49.980 00:05:50.450 Luke Daque: Gotcha.

73 00:05:50.868 00:05:52.540 Brian Pei: You can ignore these

74 00:05:53.370 00:05:54.750 Brian Pei: shopify, shopify

75 00:05:54.980 00:05:57.029 Brian Pei: Amazon selling partner is Amazon.

76 00:05:57.330 00:05:58.990 Brian Pei: Pretty straightforward.

77 00:05:59.470 00:06:03.749 Brian Pei: Intermediate is where Dbt builds some

78 00:06:03.790 00:06:07.866 Brian Pei: Amazon tables and some shopify tables, which I’ll show you in a second.

79 00:06:08.440 00:06:10.550 Brian Pei: Analytics prod

80 00:06:10.780 00:06:12.750 Brian Pei: is where.

81 00:06:12.750 00:06:13.490 Luke Daque: It’s.

82 00:06:13.490 00:06:14.450 Brian Pei: There’s yeah.

83 00:06:15.940 00:06:21.560 Brian Pei: They just care about orders right now. I’m sure you’ll add a little bit more. But so far pretty

84 00:06:21.910 00:06:27.160 Brian Pei: concise things you’ve seen before. Customer, order, order, line product. That’s like

85 00:06:27.400 00:06:29.090 Brian Pei: all of it. Bar

86 00:06:30.760 00:06:32.410 Brian Pei: and.

87 00:06:32.410 00:06:37.329 Luke Daque: So it’s like a consolidation of both Amazon and shopify orders right?

88 00:06:38.440 00:06:38.860 Luke Daque: Cool.

89 00:06:39.280 00:06:43.129 Brian Pei: Intermediate. I’m just typing this out in the slack message

90 00:06:44.012 00:06:47.807 Brian Pei: int shopify and int Amazon tables.

91 00:06:48.760 00:06:49.730 Nicolas Sucari: I think

92 00:06:49.910 00:06:59.690 Nicolas Sucari: most right here. Most of the logic we, if we want to include like more tables, we need to look into like how we are doing that stuff for pull parts, and maybe just copy.

93 00:07:00.270 00:07:02.650 Brian Pei: Yeah. And I’ve been doing that. And it’s been.

94 00:07:02.650 00:07:03.370 Nicolas Sucari: Yeah, pretty.

95 00:07:04.040 00:07:04.930 Brian Pei: Pretty good

96 00:07:06.039 00:07:07.010 Brian Pei: So

97 00:07:07.310 00:07:13.730 Brian Pei: in the repo you got real, and you got dbt, it’s all hooked up to Dbt. Cloud for you already.

98 00:07:14.060 00:07:15.030 Luke Daque: Oh, okay.

99 00:07:15.670 00:07:18.810 Luke Daque: we’re not using core for this one.

100 00:07:19.120 00:07:21.680 Luke Daque: Dbd, core. So it’s Dbd cloud.

101 00:07:21.680 00:07:25.019 Brian Pei: It’s dbt cloud. But I’m gonna show you basically what I do.

102 00:07:25.430 00:07:26.810 Brian Pei: Dbt cloud,

103 00:07:28.390 00:07:29.650 Luke Daque: Yeah, so it looks like.

104 00:07:29.700 00:07:35.429 Luke Daque: probably in dB, you’re doing the prod runs, or like the job runs in dpt cloud as well. Right? This one.

105 00:07:35.430 00:07:39.430 Brian Pei: Actually, I only use Dbt cloud as the

106 00:07:39.740 00:07:45.280 Brian Pei: to check the job runs. I don’t really do development in in Dbt cloud per se.

107 00:07:45.280 00:07:45.980 Luke Daque: Gotcha.

108 00:07:46.711 00:07:53.790 Brian Pei: But I test in Dbt cloud I’ll show you right now. So

109 00:07:53.990 00:07:55.829 Brian Pei: the you got models

110 00:07:56.160 00:08:00.600 Brian Pei: intermediate is Amazon and shopify business logic.

111 00:08:00.960 00:08:01.630 Brian Pei: which.

112 00:08:01.630 00:08:02.050 Luke Daque: Right.

113 00:08:02.050 00:08:04.179 Brian Pei: Gets pushed to the intermediate

114 00:08:05.300 00:08:07.000 Brian Pei: snowflake database

115 00:08:08.990 00:08:13.059 Brian Pei: at the top of all of these. We have set up

116 00:08:13.550 00:08:15.990 Brian Pei: what database and what schema they go to.

117 00:08:16.260 00:08:16.789 Luke Daque: No care.

118 00:08:16.790 00:08:20.310 Brian Pei: This is the name of the table. It should be very easy to track down.

119 00:08:22.040 00:08:23.840 Brian Pei: let me think. Let me think.

120 00:08:23.950 00:08:27.200 Brian Pei: Okay, so that’s intermediate. And then Mart’s

121 00:08:27.450 00:08:32.890 Brian Pei: are just like what we saw. Fact, order line. In fact, orders. It’s just a union of Amazon and shopify

122 00:08:33.545 00:08:38.400 Brian Pei: the only other important file is sources, which is

123 00:08:39.138 00:08:41.929 Brian Pei: nothing crazy. Just the names of the tables.

124 00:08:42.949 00:08:46.589 Brian Pei: As they appear out of Fivetran raw.

125 00:08:47.160 00:08:56.419 Brian Pei: So if there’s a table that’s not in here that you’re using added in sources, and then, ref it in in in dbt,

126 00:08:57.320 00:09:03.590 Brian Pei: So I just this morning what I what I do is I just in

127 00:09:04.100 00:09:05.839 Brian Pei: get desktop in my

128 00:09:05.880 00:09:07.380 Brian Pei: own personal

129 00:09:09.210 00:09:22.119 Brian Pei: code. Editor, I added some logic for refunds that wasn’t wasn’t there before I merged this 18 min ago. Basically, like I made a Pr I merged it. And then I go to Dbt. Cloud.

130 00:09:22.460 00:09:24.100 Brian Pei: and

131 00:09:25.180 00:09:30.770 Brian Pei: I ran it 18 min ago, and there was a failure. This runs once a day

132 00:09:30.930 00:09:31.580 Brian Pei: so.

133 00:09:31.580 00:09:31.950 Luke Daque: Okay.

134 00:09:31.950 00:09:39.209 Brian Pei: Fails. It’s not a big deal. I use this as my log tracker, so, like I merged it, I went to DC. Cloud.

135 00:09:39.260 00:09:42.419 Brian Pei: I went to the job, and I hit rerun to see if it worked

136 00:09:43.136 00:09:57.363 Brian Pei: it didn’t work this one time, because I forgot that in a union I had 3 extra columns, and I just didn’t union. And then I went back and I made another Pr, and then I ran it again. And it was successful. Basically.

137 00:09:57.910 00:09:59.720 Brian Pei: in Dbt cloud.

138 00:10:00.040 00:10:04.340 Brian Pei: there’s 1 job because it’s so small. It’s just dB,

139 00:10:06.470 00:10:07.360 Luke Daque: And.

140 00:10:07.360 00:10:16.839 Brian Pei: I I really I mean I I went to jobs just to show you. Whenever I log into Dp. Cloud, I just go to deploy and run history. You’ll you’ll see. Check marks. The X’s are when I’m merging. Shit.

141 00:10:17.070 00:10:20.870 Brian Pei: The check marks are the daily runs, and they, whenever I

142 00:10:21.150 00:10:29.059 Brian Pei: break it. I’ll fix it, obviously. And then, like the because there’s not so much crazy sequel and they don’t.

143 00:10:29.740 00:10:38.829 Brian Pei: But they haven’t asked for it. It’s it’s very simple, and it’s usually all all green like when I didn’t work over the weekend. It’s it’s it’s all green all the time.

144 00:10:39.888 00:10:44.050 Brian Pei: So let me send you the Dbt cloud login, dbt. Cloud.

145 00:10:44.560 00:10:47.750 Luke Daque: Runs once a day. Right? You you mentioned.

146 00:10:48.003 00:10:49.779 Brian Pei: Wait. Let me just double check that

147 00:10:52.020 00:10:55.849 Brian Pei: settings. So all it does is dbt, run.

148 00:10:55.850 00:10:56.610 Luke Daque: Right.

149 00:10:56.610 00:10:57.860 Brian Pei: It is. Oh, every time.

150 00:10:58.320 00:11:00.000 Luke Daque: It’s up twice a day.

151 00:11:00.520 00:11:01.490 Luke Daque: Okay.

152 00:11:01.930 00:11:03.750 Brian Pei: And the data.

153 00:11:04.040 00:11:05.401 Brian Pei: It’s pretty small.

154 00:11:06.990 00:11:10.319 Luke Daque: And the login for Dbt. Cloud is the Javi coffee login.

155 00:11:10.320 00:11:13.499 Brian Pei: Also Javi coffee in the same message. I’m writing to you.

156 00:11:13.500 00:11:13.950 Luke Daque: Email.

157 00:11:13.950 00:11:15.379 Brian Pei: Putting I’m putting in.

158 00:11:15.830 00:11:16.310 Luke Daque: Okay.

159 00:11:16.310 00:11:18.330 Brian Pei: Everything you need.

160 00:11:18.740 00:11:21.049 Brian Pei: which which I believe, believe I just sent

161 00:11:22.030 00:11:22.770 Brian Pei: cool.

162 00:11:22.950 00:11:24.220 Brian Pei: And

163 00:11:25.000 00:11:33.290 Brian Pei: yeah, the data is pretty small. It may be bigger than pool parts, maybe because they sell coffee instead of generators. But it’s like.

164 00:11:33.290 00:11:34.329 Luke Daque: Like not big data.

165 00:11:34.592 00:11:37.219 Brian Pei: It doesn’t use a lot of credits. It’s very cheap.

166 00:11:38.750 00:11:39.900 Brian Pei: so

167 00:11:39.970 00:11:42.260 Brian Pei: yeah, my my

168 00:11:43.310 00:11:47.290 Brian Pei: days, when the client asks for more

169 00:11:47.570 00:11:49.270 Brian Pei: logic or

170 00:11:49.320 00:11:53.540 Brian Pei: check. Some sequel is either in snowflake

171 00:11:53.670 00:11:54.780 Brian Pei: running.

172 00:11:55.060 00:11:57.109 Brian Pei: you know, checks for myself.

173 00:11:59.110 00:12:00.210 Brian Pei: github.

174 00:12:00.930 00:12:02.210 Brian Pei: throw it in

175 00:12:02.790 00:12:03.936 Brian Pei: intermediate usually.

176 00:12:06.470 00:12:07.580 Brian Pei: merge it.

177 00:12:07.880 00:12:09.549 Brian Pei: run it in Dbg cloud.

178 00:12:09.660 00:12:20.714 Brian Pei: or do a manual run deep cloud by, just you can click any of these and then hit rerun right? Because actually, I’ll rerun it now, because I actually just merged one more thing.

179 00:12:21.430 00:12:28.340 Brian Pei: Whenever whenever it reruns, it doesn’t matter what job number it is. It pulls latest from. Get before.

180 00:12:28.340 00:12:29.270 Luke Daque: Right.

181 00:12:29.270 00:12:29.650 Brian Pei: So.

182 00:12:29.650 00:12:30.660 Luke Daque: From main.

183 00:12:30.980 00:12:38.380 Brian Pei: From Maine. Yeah. And I think this will run in like a minute to show you how how fast it is, because

184 00:12:38.850 00:12:40.000 Brian Pei: there’s no answers.

185 00:12:40.000 00:12:40.909 Luke Daque: Just small.

186 00:12:41.130 00:12:44.519 Brian Pei: It’s small. There’s no analysts or data scientists working in it.

187 00:12:44.760 00:12:50.019 Brian Pei: Nobody’s really using it except for Nico and Pius, like when they’re running like real stuff.

188 00:12:50.300 00:12:51.200 Brian Pei: But

189 00:12:51.710 00:12:52.210 Brian Pei: so, yeah.

190 00:12:52.210 00:12:55.569 Nicolas Sucari: I was creating some Prs yesterday, I think.

191 00:12:56.190 00:12:56.530 Brian Pei: Yeah.

192 00:12:56.530 00:12:58.840 Nicolas Sucari: I think he has, like some branches open.

193 00:12:59.940 00:13:00.329 Luke Daque: With you.

194 00:13:00.330 00:13:01.290 Nicolas Sucari: And all the team.

195 00:13:01.460 00:13:03.260 Nicolas Sucari: No.

196 00:13:03.260 00:13:03.840 Brian Pei: Do.

197 00:13:03.840 00:13:05.000 Luke Daque: Oh, okay.

198 00:13:05.250 00:13:08.069 Brian Pei: Whatever he wants, whatever, but when he

199 00:13:08.800 00:13:12.679 Brian Pei: merges some or he can’t merge stuff, he’ll send it to us, and we’ll merge

200 00:13:13.747 00:13:24.020 Brian Pei: you can do the you can treat it as if it’s 1 of your prs where you merge it. You go in here, you click, rerun. You, look at the logs. If his stuff is effed up

201 00:13:24.310 00:13:30.190 Brian Pei: like our stuff will still run, it’ll just it’ll f up somewhere somewhere else.

202 00:13:30.839 00:13:31.419 Brian Pei: And.

203 00:13:31.420 00:13:36.730 Luke Daque: And there’s no currently there’s no dev environment for this. Right? So like in local.

204 00:13:37.150 00:13:41.780 Brian Pei: They’re actually what when? When we did dev, because they don’t.

205 00:13:41.780 00:13:42.200 Luke Daque: Oh!

206 00:13:42.200 00:13:43.193 Brian Pei: Know anything

207 00:13:43.880 00:13:52.980 Brian Pei: I created. There’s I just like I have like, oh, here I can show you when we’re testing things for the 1st time

208 00:13:53.170 00:13:56.090 Brian Pei: I would straight up in Snowflake, create a replace table.

209 00:13:56.880 00:13:57.470 Luke Daque: All right.

210 00:13:57.470 00:14:05.069 Brian Pei: Shopify Dev, and I’ll send them this, and I’ll be like, Hey, does this look like what you want to see? If they say yes. Then I just take the sequel, and I move it to Dbt.

211 00:14:05.380 00:14:06.170 Luke Daque: Okay.

212 00:14:06.170 00:14:08.969 Brian Pei: But there’s no like dev environment in Dbg cloud to like.

213 00:14:09.540 00:14:10.679 Luke Daque: Stuff with.

214 00:14:12.750 00:14:16.169 Brian Pei: So yeah, this was like my, my process for quote, unquote dev.

215 00:14:17.680 00:14:23.354 Brian Pei: and yeah, this ran in, ignore this warning. It’s not real.

216 00:14:24.340 00:14:25.370 Brian Pei: yeah. Everything else.

217 00:14:25.370 00:14:26.170 Luke Daque: Move that.

218 00:14:26.170 00:14:30.950 Brian Pei: Finish. Yeah, you can remove that as well. Finish running 11 tables in 44 seconds.

219 00:14:30.990 00:14:31.760 Luke Daque: Gotcha.

220 00:14:31.760 00:14:32.450 Nicolas Sucari: Cool.

221 00:14:32.450 00:14:40.280 Luke Daque: So I guess I can also like, since I already have log into the Dbt cloud. I guess I can also develop here in Dbt. Cloud.

222 00:14:40.280 00:14:43.300 Brian Pei: You can. Yeah, if you’re comfortable with it. I

223 00:14:43.310 00:14:46.783 Brian Pei: haven’t. But yeah, I mean, go. This is

224 00:14:47.810 00:14:50.920 Brian Pei: Dbt. Cloud enterprise. It should have all the features, and if you.

225 00:14:50.920 00:14:51.790 Luke Daque: Right.

226 00:14:51.790 00:14:54.320 Brian Pei: Login. I’m gonna sign out now because I don’t know how it works.

227 00:14:54.320 00:14:55.830 Luke Daque: Oh, right? Yeah, I think.

228 00:14:55.830 00:14:59.119 Brian Pei: 2 Ips, or whatever. I don’t know if they care honestly.

229 00:14:59.120 00:15:06.320 Luke Daque: I think I think they do. I I’ve had. I’ve experienced that before. Like, if, like, there’s 2 people logging in it locks out the other one. So.

230 00:15:06.320 00:15:06.980 Brian Pei: Yeah.

231 00:15:06.980 00:15:07.515 Luke Daque: Messy.

232 00:15:09.880 00:15:11.720 Brian Pei: But yeah, it’s been

233 00:15:12.520 00:15:13.870 Brian Pei: pretty.

234 00:15:14.930 00:15:15.510 Luke Daque: Straightforward.

235 00:15:15.510 00:15:16.640 Brian Pei: Chills

236 00:15:16.980 00:15:19.004 Brian Pei: been pretty chill.

237 00:15:19.990 00:15:23.010 Brian Pei: nothing crazy. And

238 00:15:25.240 00:15:27.430 Brian Pei: oh, and then yeah, so

239 00:15:27.560 00:15:30.739 Brian Pei: Nico will bring up whenever

240 00:15:31.300 00:15:35.509 Brian Pei: they start caring about costs. I don’t know if you’ve done it

241 00:15:35.800 00:15:38.330 Brian Pei: in Snowflake before.

242 00:15:39.420 00:15:40.530 Brian Pei: It’s this.

243 00:15:41.270 00:15:42.190 Luke Daque: Yeah, like.

244 00:15:42.190 00:15:44.649 Brian Pei: 28 days you can approximate.

245 00:15:45.980 00:15:46.560 Nicolas Sucari: Yeah.

246 00:15:46.560 00:15:47.179 Brian Pei: And we’ve been running.

247 00:15:47.180 00:15:48.040 Nicolas Sucari: They are.

248 00:15:48.040 00:15:49.330 Brian Pei: Every day, for 2 weeks.

249 00:15:49.590 00:16:02.700 Nicolas Sucari: Yeah, they are. They are kind of trying to see an an estimation of all the tools we are using and how how much it will cost. And so we are trying to estimate that I think the the most important one is 5 Tron, because that’s the one we have.

250 00:16:03.312 00:16:06.150 Nicolas Sucari: Like the the biggest cost right.

251 00:16:06.150 00:16:09.280 Luke Daque: It was like 2,800 or something that I saw earlier.

252 00:16:09.280 00:16:10.779 Nicolas Sucari: Yeah. Well, that was before we did.

253 00:16:10.780 00:16:12.009 Brian Pei: Some stuff that was necessary.

254 00:16:12.010 00:16:12.510 Luke Daque: Right.

255 00:16:12.510 00:16:17.240 Brian Pei: We did some stuff, but oh, I’ll send you the name also. I’ll be around.

256 00:16:19.340 00:16:26.760 Brian Pei: and but I’ll send you the name of our 5 trend Guy, who promised he would make this cheaper for us, or else we fire him.

257 00:16:27.612 00:16:30.260 Brian Pei: His name was Will.

258 00:16:30.260 00:16:32.919 Nicolas Sucari: We’ll. Yeah. We’ll something.

259 00:16:33.130 00:16:33.680 Brian Pei: This.

260 00:16:34.810 00:16:38.480 Brian Pei: 5 Tran. Rep for Jay. Coffee.

261 00:16:39.040 00:17:00.019 Nicolas Sucari: So he showed us how to do some estimations on, like going to the price estimator there and deselecting some tables and trying to estimate the cost. Obviously, yeah, that will depend on how much data we are bringing in. We. As for now that we have shopify and Amazon, I think we are around

262 00:17:00.210 00:17:04.349 Nicolas Sucari: 1,200 amount something around that, and.

263 00:17:04.359 00:17:04.759 Luke Daque: Fine.

264 00:17:04.760 00:17:08.839 Nicolas Sucari: But we, we will need to start working with some more data sources.

265 00:17:08.849 00:17:09.609 Luke Daque: Hmm.

266 00:17:09.609 00:17:13.339 Nicolas Sucari: From Javi. They asked us to start working for

267 00:17:13.519 00:17:16.169 Nicolas Sucari: gorgeous. I think it was. Yeah, gorgeous.

268 00:17:16.170 00:17:16.649 Brian Pei: Never heard of it.

269 00:17:16.650 00:17:16.990 Nicolas Sucari: And.

270 00:17:16.990 00:17:19.219 Brian Pei: So don’t worry about not ever hearing about that before.

271 00:17:19.859 00:17:21.439 Luke Daque: Oh, yeah, I haven’t. Yeah.

272 00:17:22.009 00:17:23.879 Luke Daque: Is that like, a, yeah.

273 00:17:24.400 00:17:26.830 Nicolas Sucari: I I yeah, let me. I can share

274 00:17:26.920 00:17:29.290 Nicolas Sucari: the web page.

275 00:17:29.930 00:17:30.320 Luke Daque: Yeah.

276 00:17:30.320 00:17:30.730 Nicolas Sucari: And.

277 00:17:30.730 00:17:35.540 Luke Daque: Is there anything like we need to be doing at the moment for Javi.

278 00:17:35.540 00:17:36.930 Nicolas Sucari: And the only thing

279 00:17:37.350 00:17:42.251 Nicolas Sucari: I I think if you finish the one on refunds Brian.

280 00:17:42.770 00:17:46.599 Nicolas Sucari: I don’t know. We we maybe we need to like, do some more.

281 00:17:48.090 00:17:53.189 Nicolas Sucari: some more tables for the product staff, or create something for shipping. We have all.

282 00:17:53.190 00:17:55.180 Brian Pei: Oh, yeah, I didn’t do shipping.

283 00:17:55.510 00:17:56.050 Luke Daque: And that would.

284 00:17:56.050 00:17:59.209 Brian Pei: Be a good one to test the waters of using all of this.

285 00:17:59.710 00:18:00.530 Brian Pei: Okay?

286 00:18:01.210 00:18:04.600 Brian Pei: And you can use the pool parts shipping basically as a template.

287 00:18:04.600 00:18:05.430 Luke Daque: Right.

288 00:18:07.490 00:18:22.710 Nicolas Sucari: Yeah, I think that’s like the next step for now. And also I’m gonna introduce you, Ryan, on Monday to the team to pay us. And Robert obviously, or I think you know most of them. But pay us is the one who is leading from Pongo insights like this project.

289 00:18:23.051 00:18:29.280 Nicolas Sucari: I’m going to introduce you to him. And on Tuesday we have the meeting with Aman. Aman is from Javi.

290 00:18:29.935 00:18:30.489 Nicolas Sucari: Yeah.

291 00:18:30.650 00:18:38.990 Nicolas Sucari: And the idea is to. Yeah, he has some questions about that gorgeous data source, how to house like the best way in order to bring

292 00:18:39.508 00:18:45.190 Nicolas Sucari: that data into snowflake. So yeah, might, we might, we may need to look into

293 00:18:45.340 00:18:58.250 Nicolas Sucari: how we can connect to to that data source. I have an email that Utam copied me from some guys from Gorgeous that he knows. So maybe I’ll I’ll ask them and see what’s the best option.

294 00:18:58.777 00:19:03.239 Nicolas Sucari: But yeah, maybe we we need to start working on that next week. Okay.

295 00:19:06.080 00:19:13.699 Nicolas Sucari: for now, it will be just yeah. Working on the tables we have and creating something for shipping, I think.

296 00:19:14.412 00:19:18.427 Nicolas Sucari: Yeah, I’m validating the refund stuff and discounts

297 00:19:18.930 00:19:19.390 Brian Pei: There is

298 00:19:19.880 00:19:32.260 Brian Pei: requirement yesterday. That when you, when you’re invited to the slack channel, I sent an update where I added what they need to validate, but they do. They still need to look at the number when I say that it’s usually pious. He.

299 00:19:32.480 00:19:32.870 Nicolas Sucari: Yes.

300 00:19:32.870 00:19:40.468 Brian Pei: To the Cfo. Directly, which is good. We don’t have to speak with him, and then he comes back with whatever

301 00:19:40.980 00:19:42.390 Brian Pei: and

302 00:19:42.440 00:19:47.080 Brian Pei: so he just he needs to validate the Ref. The new refund numbers.

303 00:19:49.090 00:19:50.394 Brian Pei: That’s about it.

304 00:19:50.830 00:19:51.590 Luke Daque: Okay.

305 00:19:53.840 00:19:56.025 Brian Pei: If the numbers also look weird.

306 00:19:57.100 00:19:59.799 Brian Pei: I will hop back in on on refund stuff.

307 00:20:00.060 00:20:00.940 Brian Pei: Sure.

308 00:20:01.600 00:20:02.080 Brian Pei: you know.

309 00:20:02.080 00:20:03.523 Luke Daque: Yeah, we can. We can also, like

310 00:20:04.943 00:20:10.230 Luke Daque: You mentioned earlier, like, they didn’t require tests. But we can always add them if needed, or something

311 00:20:11.400 00:20:14.080 Luke Daque: to make sure, like we’re not duplicating stuff

312 00:20:14.250 00:20:15.170 Luke Daque: and stuff.

313 00:20:16.980 00:20:18.689 Brian Pei: You can go crazy. You can do whatever you want

314 00:20:19.170 00:20:20.362 Brian Pei: as long. But

315 00:20:21.040 00:20:37.369 Brian Pei: we meet with, so Aman is the on the client side our point of technical point of contact on Javi coffee. We meet with him once a week. Any new stuff you want to do? Well, first, st like check with Nico that there’s no other work to actually be done. But you can bring anything up to him.

316 00:20:37.370 00:20:37.850 Nicolas Sucari: Yeah.

317 00:20:37.850 00:20:39.639 Brian Pei: Or Utam 1st the

318 00:20:39.991 00:20:44.830 Brian Pei: before you like. Go and set up tests, and then they’re just like, what what are we doing this.

319 00:20:45.090 00:20:51.459 Luke Daque: Because it might also like add to the cost to write running tests right like in snowflake and stuff like that.

320 00:20:51.460 00:21:00.420 Brian Pei: Could. It’ll be small, but it would still, you know, add a little bit, but I think at the same time, if they don’t ask for it right now. We don’t have to do it for them.

321 00:21:00.610 00:21:01.160 Luke Daque: Right.

322 00:21:01.160 00:21:02.559 Brian Pei: At a time when

323 00:21:02.974 00:21:10.049 Brian Pei: they they look at the contract and there, and they ask, like, what other things can we do that we haven’t thought of. Then you can be like yo.

324 00:21:10.910 00:21:11.690 Nicolas Sucari: Yeah.

325 00:21:13.110 00:21:13.740 Luke Daque: Yeah.

326 00:21:14.640 00:21:31.229 Nicolas Sucari: Also because they don’t really or or we don’t really know what they are expecting on all of the tables yet. I mean, they they don’t have like a blueprint of Hey, we want all of these done. It’s not that, straightforward as the real project that we did.

327 00:21:31.640 00:21:38.810 Nicolas Sucari: A couple of weeks ago. But we are still like trying to identify some stuff that we can work with them. Pay us is our main

328 00:21:38.890 00:21:54.079 Nicolas Sucari: point of contact there that we want to try to give him all of the tools and all of the tables ready, so that he can show the CEO, CEO and Cfo of Javi. But yeah, I mean, we can. We can do whatever we want there and try to give him

329 00:21:54.220 00:22:04.240 Nicolas Sucari: more stuff. We only have that cap of 10 HA week. But we can go over obviously, if if we are doing stuff that they are gonna

330 00:22:04.800 00:22:09.790 Nicolas Sucari: value from us. And then we can talk with Robert and tell us about that. That’s fine.

331 00:22:09.790 00:22:10.179 Luke Daque: Okay.

332 00:22:11.280 00:22:12.210 Luke Daque: Sounds good.

333 00:22:12.210 00:22:18.290 Brian Pei: Yeah, they don’t have a data team. And Aman isn’t like the most data savvy person. So what Nico is saying is like.

334 00:22:18.420 00:22:20.999 Brian Pei: we’re doing stuff and showing him like check out.

335 00:22:21.000 00:22:21.480 Luke Daque: Right.

336 00:22:21.480 00:22:26.919 Brian Pei: Cool stuff, and he’s like, Oh, wow! That’s so cool as opposed to him, giving us like very specific requirements.

337 00:22:26.920 00:22:28.480 Luke Daque: Right, makes sense.

338 00:22:28.970 00:22:30.700 Brian Pei: Which is a good thing sometimes.

339 00:22:31.020 00:22:31.900 Luke Daque: Yeah.

340 00:22:33.417 00:22:35.572 Luke Daque: make us makes us look good. Right?

341 00:22:36.470 00:22:38.480 Luke Daque: Yeah, he’s really nice.

342 00:22:38.480 00:22:40.050 Brian Pei: Like so far, so good.

343 00:22:40.470 00:22:41.540 Luke Daque: Nice.

344 00:22:43.540 00:22:43.900 Nicolas Sucari: Cool.

345 00:22:43.900 00:22:44.350 Brian Pei: Something.

346 00:22:44.350 00:22:45.280 Nicolas Sucari: Yeah.

347 00:22:46.110 00:22:55.240 Nicolas Sucari: what else do we have? I just invited you to the slack channel, the internal one. We have another one with the man. I’ll I’ll invite you there.

348 00:22:55.280 00:22:57.530 Nicolas Sucari: probably when I introduced to him.

349 00:22:58.260 00:22:58.990 Luke Daque: Can.

350 00:22:59.990 00:23:02.080 Nicolas Sucari: So yeah, I think

351 00:23:02.980 00:23:06.459 Nicolas Sucari: that’s all right. I don’t know if you have anything else, Brian.

352 00:23:07.390 00:23:08.396 Brian Pei: Yeah, I

353 00:23:09.490 00:23:11.620 Brian Pei: I don’t know if this meeting was recorded, but

354 00:23:11.900 00:23:12.510 Brian Pei: essentially.

355 00:23:13.410 00:23:15.545 Brian Pei: and that’s like everything that I do.

356 00:23:16.780 00:23:17.500 Brian Pei: yeah.

357 00:23:17.500 00:23:18.340 Nicolas Sucari: Cool. Yeah, I think.

358 00:23:18.340 00:23:19.189 Brian Pei: Like go back.

359 00:23:19.650 00:23:24.710 Luke Daque: Any like questions or anything I can always like. Slack you.

360 00:23:24.710 00:23:26.079 Brian Pei: Yeah, of course, of course.

361 00:23:26.080 00:23:26.740 Luke Daque: Yeah.

362 00:23:28.460 00:23:29.840 Brian Pei: and then Nico’s

363 00:23:29.960 00:23:33.230 Brian Pei: doing real stuff. But you’ll probably jump into real stuff. And then

364 00:23:33.620 00:23:36.120 Brian Pei: that’s for exploratory data analysis cheap.

365 00:23:36.170 00:23:43.840 Brian Pei: And then for Enterprise reporting. They decided last week to go with Meta Base. But Robert Side is doing all the Meta based stuff.

366 00:23:43.840 00:23:44.450 Nicolas Sucari: Yeah.

367 00:23:44.970 00:23:46.060 Luke Daque: Gotcha.

368 00:23:47.110 00:23:49.950 Nicolas Sucari: I I got the invitation for Metabody, did you?

369 00:23:50.460 00:23:53.049 Nicolas Sucari: You went in there, Brian? No.

370 00:23:53.350 00:24:01.150 Brian Pei: I didn’t go to Meta Base. I created a Meta base snowflake account for them to use so that they can have their metabase. Talk to Snowflake.

371 00:24:02.310 00:24:12.360 Nicolas Sucari: Cool. Yeah, because I I saw the tables there. But they are not the final ones, I think. But yeah, maybe we can discuss that with Payoff on Monday.

372 00:24:13.930 00:24:14.540 Brian Pei: Yeah.

373 00:24:14.700 00:24:19.140 Nicolas Sucari: I haven’t seen any dashboard yet or anything in metabase. So yeah, maybe they are working on that.

374 00:24:20.810 00:24:22.839 Brian Pei: They’re chilling. Pius is chilling.

375 00:24:23.930 00:24:28.220 Brian Pei: We’re all chilling. This is a chill. This is a chill one. Knock on wood.

376 00:24:28.430 00:24:30.620 Brian Pei: but regardless I will be here.

377 00:24:30.620 00:24:31.120 Nicolas Sucari: Yeah.

378 00:24:32.300 00:24:34.009 Luke Daque: There seems to be a lot of other

379 00:24:34.250 00:24:36.059 Luke Daque: changes in the main

380 00:24:36.350 00:24:37.390 Luke Daque: branch.

381 00:24:38.070 00:24:39.160 Luke Daque: Not sure if, like.

382 00:24:39.160 00:24:39.659 Brian Pei: What do you mean by.

383 00:24:39.660 00:24:40.100 Luke Daque: And she.

384 00:24:40.100 00:24:41.179 Brian Pei: Changes! Oh.

385 00:24:41.180 00:24:42.110 Luke Daque: Or like it was.

386 00:24:42.110 00:24:45.579 Brian Pei: Making 5 prs a day, because I suck, yeah, that’s me.

387 00:24:45.580 00:24:46.266 Luke Daque: I know.

388 00:24:47.250 00:24:49.551 Luke Daque: I know I’m just looking at the

389 00:24:50.280 00:24:52.689 Luke Daque: the Dbt cloud at the moment. But

390 00:24:53.190 00:24:56.110 Luke Daque: I mean the yeah, the Id

391 00:24:56.720 00:24:59.800 Luke Daque: developing in DVD cloud. But then it looks like there’s

392 00:25:00.320 00:25:01.400 Luke Daque: lots of

393 00:25:01.880 00:25:02.640 Luke Daque: updates.

394 00:25:02.640 00:25:07.509 Brian Pei: Oh, oh, make sure! So when you spin that up for the 1st time, it’s going to

395 00:25:08.780 00:25:12.400 Brian Pei: create model example models for you.

396 00:25:13.340 00:25:14.110 Brian Pei: So.

397 00:25:14.330 00:25:15.300 Luke Daque: I, yeah.

398 00:25:15.300 00:25:17.580 Brian Pei: Sure that it’s not doing the

399 00:25:17.680 00:25:19.670 Brian Pei: cause. I haven’t used it right so.

400 00:25:19.670 00:25:20.609 Luke Daque: Right, sure.

401 00:25:20.610 00:25:28.785 Brian Pei: So that it’s like not giving you random example stuff like, oh, here’s here’s your 1st time setting it up, because it it will do that.

402 00:25:29.640 00:25:33.739 Luke Daque: Yeah, I think I need to create a branch here or something. But never mind, I I guess I’ll just.

403 00:25:34.500 00:25:41.710 Brian Pei: Yeah, ignore ignore changes you see, in in cloud Ide. Those are. Those are not me.

404 00:25:42.120 00:25:44.170 Luke Daque: Right? Okay. Sounds good.

405 00:25:47.080 00:25:47.970 Nicolas Sucari: Excellent.

406 00:25:48.590 00:25:52.520 Nicolas Sucari: Well, it’s great. 25 min. Yeah, that was quick.

407 00:25:53.050 00:25:53.860 Brian Pei: Meeting.

408 00:25:54.490 00:26:02.529 Nicolas Sucari: Yeah. Okay, if you want Ryan, start taking a look. And if you have any questions, just shoot on slack. We can

409 00:26:02.750 00:26:12.030 Nicolas Sucari: try helping there. And yeah, I’m going to invite you to the meetings next week. We have Mondays and Thursdays with Payas and Tuesdays with a man.

410 00:26:12.607 00:26:15.349 Nicolas Sucari: And yeah, that’s it. We just

411 00:26:15.700 00:26:21.710 Nicolas Sucari: try. We are trying to get things done and share with them. Try to show him some real stuff.

412 00:26:21.800 00:26:33.999 Nicolas Sucari: And yeah, Pyas is working on metabase also to share with them. And that’s it, for now I think we need to start looking into gorgeous, and maybe then, after gorgeous, there’s a north beam as data source, too.

413 00:26:34.060 00:26:39.210 Nicolas Sucari: But for now we just try to focus on orders and maybe shipping stuff.

414 00:26:40.350 00:26:41.056 Luke Daque: Sounds good.

415 00:26:42.440 00:26:43.210 Luke Daque: Okay.

416 00:26:44.260 00:26:45.400 Nicolas Sucari: Well, thanks. Guys.

417 00:26:45.650 00:26:46.679 Nicolas Sucari: stuck, later.

418 00:26:46.840 00:26:47.829 Brian Pei: Cool thanks guys.

419 00:26:47.830 00:26:49.480 Luke Daque: Good thanks, thanks. See you. Bye-bye.

420 00:26:49.480 00:26:50.089 Nicolas Sucari: Bye, bye.