Meeting Title: Zoom Meeting Date: 2024-11-22 Meeting participants: Luke Daque, Nicolas Sucari
WEBVTT
1 00:00:31.590 ⇒ 00:00:32.570 Nicolas Sucari: Hey! Ran!
2 00:00:33.360 ⇒ 00:00:34.500 Luke Daque: Nicholas.
3 00:00:36.200 ⇒ 00:00:37.110 Nicolas Sucari: So.
4 00:00:37.300 ⇒ 00:00:39.449 Luke Daque: Is this regarding the amplitude?
5 00:00:39.880 ⇒ 00:00:41.910 Nicolas Sucari: Yeah, look where I got.
6 00:00:42.030 ⇒ 00:00:45.270 Nicolas Sucari: Think I already have. I’m almost there.
7 00:00:45.800 ⇒ 00:00:47.100 Nicolas Sucari: That
8 00:00:48.677 ⇒ 00:00:56.120 Nicolas Sucari: I’m not sure if I’m selecting the correct options, that’s why I wanted Robert to tell me. I don’t know. I’m not sure about amplitude.
9 00:00:57.100 ⇒ 00:00:59.600 Nicolas Sucari: Yeah. So oh, wait, let me go back.
10 00:00:59.960 ⇒ 00:01:06.020 Nicolas Sucari: So for the connection. I think this is okay, like, it got connected with this role.
11 00:01:06.736 ⇒ 00:01:12.959 Nicolas Sucari: I created this user with the password on Snowflake. And that is here. So this is working.
12 00:01:13.050 ⇒ 00:01:19.910 Nicolas Sucari: I’m using the warehouse ingest and the database role I can’t like. Select exactly the
13 00:01:19.960 ⇒ 00:01:28.630 Nicolas Sucari: the gorgeous schema inside row. But I already added, like a privilege to this role rolling chest to see gorgeous tables.
14 00:01:28.710 ⇒ 00:01:32.030 Nicolas Sucari: And I think that’s working. Because when I continue
15 00:01:32.880 ⇒ 00:01:40.529 Nicolas Sucari: so, it verifies the instrument instrumentation, it’s okay. And then when you go to select data. I need to select like event type
16 00:01:40.900 ⇒ 00:01:44.650 Nicolas Sucari: theme for strategy. I’m not sure what to capture.
17 00:01:45.660 ⇒ 00:01:47.210 Nicolas Sucari: What would you say?
18 00:01:48.760 ⇒ 00:01:51.999 Nicolas Sucari: I would say this one, right? The change data, capture.
19 00:01:57.280 ⇒ 00:02:01.380 Luke Daque: Yeah, let’s we Sync, the most recent rows in the data.
20 00:02:01.530 ⇒ 00:02:06.460 Luke Daque: Yeah, I think we can use that. But then we’ll have to. Maybe we’ll have to select
21 00:02:06.990 ⇒ 00:02:10.660 Luke Daque: a field. That would that it would determine as.
22 00:02:10.660 ⇒ 00:02:11.090 Nicolas Sucari: Yeah.
23 00:02:11.090 ⇒ 00:02:13.520 Luke Daque: Yeah. So so let’s let’s try that.
24 00:02:13.760 ⇒ 00:02:18.689 Nicolas Sucari: I I tried this one, and then, when I select this one like these 2 fields appear
25 00:02:18.940 ⇒ 00:02:26.279 Nicolas Sucari: so here is like continuous sync. I’m not sure if, like, we all need, or just a pen.
26 00:02:27.070 ⇒ 00:02:34.790 Luke Daque: Maybe just append, because change data capture might also be more expensive. I’m not sure. But that’s like usual.
27 00:02:35.240 ⇒ 00:02:37.169 Nicolas Sucari: Case. But why? I don’t want.
28 00:02:37.170 ⇒ 00:02:37.520 Luke Daque: Linkedin.
29 00:02:37.520 ⇒ 00:02:42.709 Nicolas Sucari: Finish this setup without Robert telling me like, these are the correct options, because I don’t want to like
30 00:02:42.840 ⇒ 00:02:47.700 Nicolas Sucari: like how like it costs. But that’s okay. But when I do this, because this is where I got
31 00:02:47.740 ⇒ 00:02:52.389 Nicolas Sucari: like, I can see here the gorgeous table, as I already gave access.
32 00:02:52.480 ⇒ 00:02:53.670 Nicolas Sucari: So that’s fine.
33 00:02:55.046 ⇒ 00:03:03.900 Nicolas Sucari: But then I can. I need to select like one of these tables. I think I don’t know where we are getting like all of the information here. If it is on
34 00:03:04.000 ⇒ 00:03:08.429 Nicolas Sucari: customer or tickets, I don’t know
35 00:03:09.490 ⇒ 00:03:12.339 Nicolas Sucari: or ticket. Yeah, I’m I’m hearing.
36 00:03:12.340 ⇒ 00:03:13.150 Luke Daque: Sure.
37 00:03:13.860 ⇒ 00:03:16.960 Nicolas Sucari: I’m not. Yeah, I’m not sure. I mean, I can see
38 00:03:17.960 ⇒ 00:03:22.280 Nicolas Sucari: that’s a preview. I I have like another window with some of like here with all of the
39 00:03:24.050 ⇒ 00:03:25.570 Nicolas Sucari: and tables.
40 00:03:25.790 ⇒ 00:03:31.150 Nicolas Sucari: But I don’t know like what we want to see here with with this data, right?
41 00:03:31.220 ⇒ 00:03:37.569 Nicolas Sucari: So that’s why I need. I think we need them to let tell us, because E, even if I like the ticket
42 00:03:37.800 ⇒ 00:03:39.670 Nicolas Sucari: like, I need to map column.
43 00:03:40.240 ⇒ 00:03:41.549 Luke Daque: Yeah, it. Looks like.
44 00:03:41.550 ⇒ 00:03:45.390 Nicolas Sucari: This is gonna be like a pain in the ass if they don’t tell us what to do right.
45 00:03:45.600 ⇒ 00:03:48.976 Luke Daque: Yeah, that’s weird, though. I mean
46 00:03:49.550 ⇒ 00:03:51.870 Luke Daque: that it does that like it would.
47 00:03:51.880 ⇒ 00:03:55.149 Luke Daque: It doesn’t have any auto like default value.
48 00:03:55.610 ⇒ 00:04:00.360 Nicolas Sucari: Yeah, exactly. Exactly like we need to add, like each column name to map.
49 00:04:00.360 ⇒ 00:04:00.840 Luke Daque: Right.
50 00:04:00.840 ⇒ 00:04:06.520 Nicolas Sucari: Like user Id. I don’t know, you know, like we need to do this so.
51 00:04:08.510 ⇒ 00:04:11.549 Nicolas Sucari: or I can give the credentials to them. And.
52 00:04:12.450 ⇒ 00:04:14.480 Luke Daque: And they can manage it. Maybe.
53 00:04:14.510 ⇒ 00:04:16.401 Nicolas Sucari: But the thing is that
54 00:04:17.839 ⇒ 00:04:19.560 Nicolas Sucari: Aman is asking, and
55 00:04:19.610 ⇒ 00:04:26.770 Nicolas Sucari: good questions are regarding amplitude and the costs, and those are all things that Robert and pay us were managing right.
56 00:04:28.380 ⇒ 00:04:29.210 Luke Daque: Yeah.
57 00:04:29.770 ⇒ 00:04:37.390 Nicolas Sucari: Like. We can’t say anything like we can give the estimated for Snowflake real.
58 00:04:37.390 ⇒ 00:04:38.140 Luke Daque: And.
59 00:04:38.570 ⇒ 00:04:39.360 Nicolas Sucari: Yeah.
60 00:04:39.920 ⇒ 00:04:40.660 Luke Daque: Yeah, but.
61 00:04:40.660 ⇒ 00:04:41.460 Nicolas Sucari: Run, and that’s it.
62 00:04:41.970 ⇒ 00:04:43.380 Luke Daque: Yeah, exactly.
63 00:04:45.150 ⇒ 00:04:49.010 Nicolas Sucari: They don’t like when they kind of disappear.
64 00:04:49.520 ⇒ 00:04:50.410 Nicolas Sucari: Okay.
65 00:04:53.290 ⇒ 00:05:06.122 Nicolas Sucari: But yeah, maybe I’m gonna send a message that we need your input to finish this setup, or I’ll send the credentials and you can do it, I can say, and that’s it. And I’m gonna ask, man, I’m gonna tag Robert there so that he can, answers
66 00:05:06.480 ⇒ 00:05:09.280 Nicolas Sucari: and we can give the estimations for 5 tran.
67 00:05:09.510 ⇒ 00:05:12.899 Nicolas Sucari: and I don’t know how much Snowflake is.
68 00:05:12.920 ⇒ 00:05:14.990 Nicolas Sucari: Maybe I need to ask utam that one.
69 00:05:16.630 ⇒ 00:05:19.590 Nicolas Sucari: But really it’s gonna be 2 50 a month.
70 00:05:19.950 ⇒ 00:05:22.729 Nicolas Sucari: We are not paying that. But yeah
71 00:05:23.790 ⇒ 00:05:27.110 Nicolas Sucari: yet. But we should start to pay. I don’t know when.
72 00:05:27.760 ⇒ 00:05:28.739 Luke Daque: Yeah, because we’re.
73 00:05:28.740 ⇒ 00:05:32.049 Nicolas Sucari: Really, really, it’s not clear about that, right?
74 00:05:32.980 ⇒ 00:05:39.099 Luke Daque: I’m not. Yeah, I think because we’re partners. I think that’s why it’s like free for us at the moment.
75 00:05:39.100 ⇒ 00:05:43.260 Nicolas Sucari: And they are not like kind of blocking us doing anything right.
76 00:05:43.260 ⇒ 00:05:47.279 Luke Daque: Yeah, they’re not asking us to pay anything at the moment, but.
77 00:05:47.280 ⇒ 00:05:47.660 Nicolas Sucari: Right.
78 00:05:47.660 ⇒ 00:05:48.340 Luke Daque: Yeah.
79 00:05:48.970 ⇒ 00:05:54.967 Nicolas Sucari: Okay, cool. Okay. And do you have the recharge real?
80 00:05:55.940 ⇒ 00:06:00.810 Luke Daque: It should be. It should be in the Javi Coffee Rail, so you can see it there.
81 00:06:02.970 ⇒ 00:06:04.160 Nicolas Sucari: I have it here.
82 00:06:04.920 ⇒ 00:06:07.279 Nicolas Sucari: Jabbie. Coffee! Excellent!
83 00:06:07.940 ⇒ 00:06:08.500 Luke Daque: Yep.
84 00:06:08.500 ⇒ 00:06:12.109 Nicolas Sucari: Land recharge orders. Okay, yeah. Just check it out.
85 00:06:12.430 ⇒ 00:06:17.660 Nicolas Sucari: Yeah. Okay, where it is all time. It’s.
86 00:06:17.810 ⇒ 00:06:25.160 Luke Daque: Yeah, it’s weird because it we only have. It looks like at the moment November stuff orders.
87 00:06:26.517 ⇒ 00:06:30.740 Luke Daque: Yeah. But that’s what we’re getting from the I’m snow.
88 00:06:30.740 ⇒ 00:06:31.389 Nicolas Sucari: From the daddy.
89 00:06:31.390 ⇒ 00:06:33.190 Luke Daque: It’s a lot better than
90 00:06:35.050 ⇒ 00:06:39.359 Luke Daque: What you what did you call this? The the the 1st Api that we had right.
91 00:06:39.360 ⇒ 00:06:39.959 Nicolas Sucari: Yeah, yeah.
92 00:06:39.960 ⇒ 00:06:40.680 Luke Daque: Let’s keep.
93 00:06:40.680 ⇒ 00:06:41.380 Nicolas Sucari: Okay.
94 00:06:41.830 ⇒ 00:06:42.340 Luke Daque: Yeah.
95 00:06:43.040 ⇒ 00:06:48.549 Nicolas Sucari: So we have like 24 K orders. Okay, that’s fine. 23 K orders.
96 00:06:49.010 ⇒ 00:06:54.300 Nicolas Sucari: Yep, alrighty, that’s fine. Maybe they started using it in November. But
97 00:06:54.360 ⇒ 00:06:57.380 Nicolas Sucari: yeah, I’m not sure. No, because they have some stuff
98 00:06:59.110 ⇒ 00:07:01.870 Nicolas Sucari: I don’t know. Maybe we should check one is the like.
99 00:07:02.620 ⇒ 00:07:07.519 Nicolas Sucari: see? Total orders like, yeah, they started here right on November 4.
100 00:07:09.520 ⇒ 00:07:11.389 Nicolas Sucari: Was nothing before? Right?
101 00:07:11.580 ⇒ 00:07:12.350 Nicolas Sucari: Yeah.
102 00:07:12.560 ⇒ 00:07:14.710 Luke Daque: It looks like nothing before.
103 00:07:15.660 ⇒ 00:07:16.320 Nicolas Sucari: Okay.
104 00:07:17.750 ⇒ 00:07:29.490 Nicolas Sucari: don’t worry. Okay, this is great and what I, what I was checking is, if you go to the old orders dashboard like we don’t have. Okay. Now we do. Okay, maybe it’s syncing.
105 00:07:29.560 ⇒ 00:07:30.729 Nicolas Sucari: Go my day.
106 00:07:30.730 ⇒ 00:07:31.290 Luke Daque: Thing.
107 00:07:31.460 ⇒ 00:07:32.579 Luke Daque: Oh, yeah, that was because.
108 00:07:32.580 ⇒ 00:07:33.260 Nicolas Sucari: Yeah, okay.
109 00:07:33.260 ⇒ 00:07:34.429 Luke Daque: Earlier, but now.
110 00:07:34.430 ⇒ 00:07:34.920 Nicolas Sucari: Okay. Sure.
111 00:07:34.920 ⇒ 00:07:36.849 Luke Daque: Be good. Yeah, because I figured
112 00:07:37.180 ⇒ 00:07:39.530 Luke Daque: I fixed that by like changing the.
113 00:07:39.900 ⇒ 00:07:40.480 Nicolas Sucari: Okay.
114 00:07:40.810 ⇒ 00:07:41.780 Luke Daque: Connection can.
115 00:07:41.780 ⇒ 00:07:43.779 Nicolas Sucari: And the M. Variables right.
116 00:07:43.990 ⇒ 00:07:44.603 Luke Daque: Yep. Yep.
117 00:07:45.200 ⇒ 00:07:46.080 Nicolas Sucari: Excellent.
118 00:07:46.190 ⇒ 00:07:57.130 Nicolas Sucari: amazing. What I’m thinking is we should should should we like have, like the previous complete previous day to in this report as we did for bullpart.
119 00:07:58.248 ⇒ 00:08:01.739 Luke Daque: Remove- remove the 1st day, or, like the the.
120 00:08:02.130 ⇒ 00:08:07.890 Nicolas Sucari: The actual date. Yeah, like, we should just only have completed dates right?
121 00:08:08.270 ⇒ 00:08:09.880 Luke Daque: Yeah, that makes sense.
122 00:08:10.490 ⇒ 00:08:13.920 Nicolas Sucari: Because we’re gonna see like this, drop right.
123 00:08:14.270 ⇒ 00:08:14.910 Luke Daque: Yeah.
124 00:08:15.290 ⇒ 00:08:15.949 Nicolas Sucari: There’s some stuff.
125 00:08:15.950 ⇒ 00:08:17.229 Luke Daque: And the current date.
126 00:08:17.740 ⇒ 00:08:28.400 Nicolas Sucari: Yeah, yeah, I think that’s an easy one that we can do. Okay, cool. I’m gonna I’m gonna send a message and update to a man. Also with that new dashboard cool.
127 00:08:28.620 ⇒ 00:08:29.810 Nicolas Sucari: I think it’s good.
128 00:08:29.900 ⇒ 00:08:37.720 Nicolas Sucari: Yeah, I think we’re doing great. I need to talk to pay us about the documentation. It would be good to have like something. Or maybe I can ask you
129 00:08:38.362 ⇒ 00:08:40.139 Nicolas Sucari: next week about
130 00:08:40.190 ⇒ 00:08:44.999 Nicolas Sucari: how is like how we can manage all of the documentation. Like to explain all of the
131 00:08:45.180 ⇒ 00:08:49.999 Nicolas Sucari: the things that we are doing on Dbt, right? So that they can have like a place
132 00:08:50.000 ⇒ 00:08:50.869 Nicolas Sucari: for pay us?
133 00:08:50.870 ⇒ 00:08:51.890 Nicolas Sucari: Yeah, for sure.
134 00:08:51.890 ⇒ 00:08:53.099 Luke Daque: Yeah, yeah, okay.
135 00:08:53.100 ⇒ 00:08:56.260 Nicolas Sucari: If I ask them to share with with them too.
136 00:08:56.720 ⇒ 00:08:58.190 Luke Daque: Yeah, okay, no. Problem.
137 00:08:58.190 ⇒ 00:09:02.630 Nicolas Sucari: Okay, yeah, it’s something that maybe we can work with next week on that one.
138 00:09:02.930 ⇒ 00:09:04.819 Luke Daque: Okay. Sounds good.
139 00:09:05.160 ⇒ 00:09:06.510 Nicolas Sucari: Cool. Excellent
140 00:09:06.700 ⇒ 00:09:14.019 Nicolas Sucari: thanks, Ryan. Okay, I’m gonna send those messages in slack so that Robert can help us there with the configuration.
141 00:09:14.440 ⇒ 00:09:28.339 Nicolas Sucari: And yeah, also. One more thing that I talked with Utah this week is, I know you’re working on that synthetic data. But all we we also have, like a lot of information in one of these tools that Ryan
142 00:09:28.813 ⇒ 00:09:37.179 Nicolas Sucari: Is working on the content stuff from our website. So it will be great to have like a website performance dashboard.
143 00:09:37.240 ⇒ 00:09:46.429 Nicolas Sucari: like from like, from from actual data from our website. You know that we can then share with with people as, hey, we’re using this to monitor our performance.
144 00:09:46.942 ⇒ 00:09:48.829 Nicolas Sucari: Like, I don’t know.
145 00:09:49.493 ⇒ 00:10:03.850 Nicolas Sucari: Views on the on on the website, different clicks. I don’t know. We can track different stuff. We have like a lot of events. And we are tracking a lot of information there. But we don’t have that data in real. So maybe it’s gonna be good to like.
146 00:10:04.050 ⇒ 00:10:07.519 Nicolas Sucari: have that in Snowflake and then create like a real dashboard with it.
147 00:10:07.970 ⇒ 00:10:09.430 Luke Daque: Yeah, that makes sense.
148 00:10:11.340 ⇒ 00:10:15.829 Nicolas Sucari: Because what we are trying to do is like we’re trying to sell all of our work. So
149 00:10:15.850 ⇒ 00:10:22.669 Nicolas Sucari: it’s easier to sell. And we can show like, Hey, we’re also using this internally for us to do some stuff.
150 00:10:23.690 ⇒ 00:10:24.540 Luke Daque: Yeah.
151 00:10:25.150 ⇒ 00:10:32.050 Nicolas Sucari: So I think that’s gonna be great. Yeah, maybe we can work on that next week, too. But it was just an idea. And I think it’s it’s it’s cool.
152 00:10:32.050 ⇒ 00:10:35.729 Luke Daque: Yeah, that’s that’s a good idea as well. Like, I agree, like, since
153 00:10:35.880 ⇒ 00:10:47.010 Luke Daque: we have, I have time like, because I’m only doing like 2 h for Javi, right for the week, I mean per day. So I have like spare time to to work on stuff like that.
154 00:10:47.510 ⇒ 00:10:49.100 Nicolas Sucari: Okay, excellent.
155 00:10:50.360 ⇒ 00:10:51.090 Nicolas Sucari: Yeah.
156 00:10:51.950 ⇒ 00:10:52.730 Luke Daque: Cool.
157 00:10:53.170 ⇒ 00:10:53.790 Nicolas Sucari: Cool.
158 00:10:54.290 ⇒ 00:10:55.080 Nicolas Sucari: Okay.
159 00:10:56.040 ⇒ 00:11:04.739 Nicolas Sucari: I need to get the access to those tools I’m thinking about, maybe a message to Ryan. I don’t know which exactly was the tool that he was showing.
160 00:11:05.080 ⇒ 00:11:07.539 Nicolas Sucari: Yeah. But yeah, I’m gonna ask, okay.
161 00:11:08.350 ⇒ 00:11:08.976 Luke Daque: Sounds good.
162 00:11:10.100 ⇒ 00:11:11.026 Luke Daque: Thanks, Nick.
163 00:11:11.900 ⇒ 00:11:12.820 Nicolas Sucari: Thanks, Ryan.
164 00:11:13.900 ⇒ 00:11:16.430 Luke Daque: Thank you as well. Have a nice rest of your day.
165 00:11:16.430 ⇒ 00:11:23.180 Nicolas Sucari: Oh, yeah, we just are closing up. Okay, that’s fine. Yeah. Have a great weekend. And.
166 00:11:23.180 ⇒ 00:11:23.570 Luke Daque: Next week.
167 00:11:23.570 ⇒ 00:11:24.140 Nicolas Sucari: Okay.
168 00:11:24.410 ⇒ 00:11:26.140 Luke Daque: Sounds. Good. Bye-bye.