2025-05-21_luke_daques_zoom_meeting_8fc1b9f4

Meeting Title: Luke Daque’s Zoom Meeting Date: 2025-05-21 Meeting participants: Luke Daque, Caio Velasco

---

WEBVTT

1 00:00:29.090 ⇒ 00:00:31.529 Luke Daque: Hello! Hello! Hello!

2 00:02:53.240 ⇒ 00:02:53.919 Caio Velasco: Hey! Luke!

3 00:02:56.030 ⇒ 00:02:57.719 Luke Daque: Hi, Kyle, how’s it going.

4 00:02:57.720 ⇒ 00:02:59.390 Caio Velasco: Alright, all good!

5 00:02:59.640 ⇒ 00:03:00.470 Caio Velasco: How are you.

6 00:03:01.260 ⇒ 00:03:04.640 Luke Daque: Yeah. Doing? Well, do you have another meeting coming up.

7 00:03:06.310 ⇒ 00:03:07.470 Caio Velasco: No, no, no, I’m done.

8 00:03:07.760 ⇒ 00:03:09.050 Luke Daque: Oh, cool! Nice!

9 00:03:10.240 ⇒ 00:03:11.050 Caio Velasco: What about you?

10 00:03:12.225 ⇒ 00:03:16.540 Luke Daque: Yeah, I don’t have any in in

11 00:03:17.040 ⇒ 00:03:19.329 Luke Daque: anytime soon. So yeah, it should be good.

12 00:03:20.130 ⇒ 00:03:21.250 Caio Velasco: Okay, cool.

13 00:03:25.326 ⇒ 00:03:31.330 Caio Velasco: Okay. So let me explain what I’m doing.

14 00:03:31.690 ⇒ 00:03:36.919 Caio Velasco: If you can share my my screen. One sec.

15 00:03:39.880 ⇒ 00:03:40.500 Luke Daque: Shit.

16 00:04:05.060 ⇒ 00:04:05.750 Caio Velasco: Okay.

17 00:04:07.390 ⇒ 00:04:09.210 Caio Velasco: Can you see here my screen.

18 00:04:09.600 ⇒ 00:04:10.040 Luke Daque: Yep.

19 00:04:10.570 ⇒ 00:04:11.300 Caio Velasco: Yep.

20 00:04:21.649 ⇒ 00:04:25.510 Caio Velasco: Always think you can. I minimize this bar.

21 00:04:26.620 ⇒ 00:04:27.540 Luke Daque: Which bar.

22 00:04:28.520 ⇒ 00:04:32.480 Caio Velasco: The zoom zoom. I don’t know if you see the Zoom Bar or just me.

23 00:04:32.480 ⇒ 00:04:35.230 Luke Daque: Oh, I I don’t see it, but.

24 00:04:36.370 ⇒ 00:04:42.110 Caio Velasco: Okay? So and okay, so

25 00:04:42.370 ⇒ 00:04:48.859 Caio Velasco: well, just so that you have, like a an over an overview so for the documentation part.

26 00:04:49.567 ⇒ 00:04:53.539 Caio Velasco: we are building like 2 sources for the AI agent

27 00:04:54.273 ⇒ 00:05:00.030 Caio Velasco: the 1st one is called Knowledge Base, which we have like one per per client.

28 00:05:00.460 ⇒ 00:05:03.969 Caio Velasco: and in this case we would be in the co-parts.

29 00:05:04.080 ⇒ 00:05:09.080 Caio Velasco: No, which is this one here.

30 00:05:12.410 ⇒ 00:05:16.459 Caio Velasco: and in the beginning we have, like a general

31 00:05:16.740 ⇒ 00:05:19.869 Caio Velasco: overview which amber already filled in

32 00:05:20.834 ⇒ 00:05:26.610 Caio Velasco: token states some some other items. Here. We can even start with this.

33 00:05:27.080 ⇒ 00:05:28.520 Caio Velasco: But in this.

34 00:05:29.080 ⇒ 00:05:37.490 Caio Velasco: on the where is it on the technical context part, then it’s basically a a mirror of

35 00:05:37.880 ⇒ 00:05:41.160 Caio Velasco: the spreadsheets that we are. Gonna talk about.

36 00:05:46.780 ⇒ 00:05:52.240 Caio Velasco: well, I think after we do the spreadsheet, I think everything here would be easy to do

37 00:05:52.480 ⇒ 00:05:59.149 Caio Velasco: so. The spreadsheets are located here, which goes to this page.

38 00:06:00.020 ⇒ 00:06:01.880 Caio Velasco: and then you have one per client.

39 00:06:03.155 ⇒ 00:06:07.499 Caio Velasco: We are in this one here, which is this one here?

40 00:06:08.420 ⇒ 00:06:10.070 Caio Velasco: Then there’s many tabs.

41 00:06:11.070 ⇒ 00:06:14.389 Caio Velasco: This one is more like what I got from the business context.

42 00:06:14.650 ⇒ 00:06:21.379 Caio Velasco: and then the others are related to well, more like the engineering work.

43 00:06:22.300 ⇒ 00:06:25.709 Caio Velasco: So since I haven’t really worked with

44 00:06:26.150 ⇒ 00:06:28.780 Caio Velasco: cool parts and well, I had

45 00:06:29.295 ⇒ 00:06:33.570 Caio Velasco: my VPN is monthly, so I haven’t paid the second one. So I didn’t

46 00:06:34.610 ⇒ 00:06:37.480 Caio Velasco: access now to Portable, for example.

47 00:06:37.930 ⇒ 00:06:42.270 Caio Velasco: So that’s also one of the reason why maybe you could help me expedite

48 00:06:44.060 ⇒ 00:06:45.649 Caio Velasco: But, for example, from.

49 00:06:45.920 ⇒ 00:06:54.280 Luke Daque: But I don’t think we’re using portable for full parts, though, unless I’m missing something. But I think we’re just using 5 grand for

50 00:06:54.970 ⇒ 00:06:59.230 Luke Daque: for everything from my end. Yeah, from what I can remember.

51 00:07:00.410 ⇒ 00:07:04.380 Caio Velasco: Okay, okay, so let me take this out.

52 00:07:05.960 ⇒ 00:07:06.620 Luke Daque: Yeah.

53 00:07:07.870 ⇒ 00:07:13.442 Caio Velasco: Maybe then we can even start here just to make sure it’s making sense.

54 00:07:13.840 ⇒ 00:07:20.220 Luke Daque: Wait. Let me check the sigma, or that we had before.

55 00:07:21.130 ⇒ 00:07:28.429 Luke Daque: I think. We had all the sources there. But let me see, where do I find that?

56 00:07:30.850 ⇒ 00:07:31.790 Luke Daque: There’s 2.

57 00:07:32.330 ⇒ 00:07:34.680 Caio Velasco: Let me see if it’s this one or another one.

58 00:07:36.420 ⇒ 00:07:40.949 Luke Daque: Oh, yeah, that the one below that, the one below Javi

59 00:07:41.690 ⇒ 00:07:47.749 Luke Daque: is pull apart. So we have all the data sources there. And we’re just using 5 grand for the data ingestion.

60 00:07:48.090 ⇒ 00:07:48.920 Luke Daque: So, yeah.

61 00:07:51.093 ⇒ 00:07:54.620 Caio Velasco: Okay, cool. So this is a everything here. It’s up to date.

62 00:07:55.470 ⇒ 00:07:58.189 Luke Daque: It should be because we did not change anything. Yep.

63 00:07:59.500 ⇒ 00:08:04.950 Caio Velasco: Okay, okay, okay, so we have the frequency of the sources. Pipes run.

64 00:08:05.090 ⇒ 00:08:08.450 Caio Velasco: Okay? Oh, that’s nice.

65 00:08:08.600 ⇒ 00:08:24.810 Luke Daque: That’s current setup. But I I don’t know if that’s the ideal setup, like the data ingestion, like different frequencies for the data ingestion doesn’t really make sense to me. Maybe we can like standardize everything to one day or whatever. But

66 00:08:25.110 ⇒ 00:08:26.949 Luke Daque: but that’s how it is, for now.

67 00:08:27.860 ⇒ 00:08:29.259 Caio Velasco: That’s how it is. For now. Okay.

68 00:08:29.260 ⇒ 00:08:29.820 Luke Daque: Yeah.

69 00:08:29.940 ⇒ 00:08:37.370 Caio Velasco: Perfect. Okay. So based on on this picture here, I believe

70 00:08:38.220 ⇒ 00:08:44.460 Caio Velasco: I can already answer. For example, this one here, like all the tech stack I assume.

71 00:08:44.640 ⇒ 00:08:45.480 Luke Daque: Yeah. Okay.

72 00:08:45.480 ⇒ 00:08:46.100 Luke Daque: Sweet.

73 00:08:46.920 ⇒ 00:08:53.030 Caio Velasco: And okay. And from this one I also can do all the tools

74 00:08:53.250 ⇒ 00:08:56.729 Caio Velasco: which I think we don’t really need this. But these are just sources. Right?

75 00:09:00.100 ⇒ 00:09:04.520 Caio Velasco: This is this I did today. So doesn’t don’t assume it’s correct.

76 00:09:05.220 ⇒ 00:09:07.550 Luke Daque: Yeah, that that. Yeah, that’s correct.

77 00:09:08.900 ⇒ 00:09:12.289 Luke Daque: I mean that. Yeah, that’s like, we have that. Yes.

78 00:09:16.480 ⇒ 00:09:17.420 Caio Velasco: There’s 2.

79 00:09:17.420 ⇒ 00:09:21.879 Luke Daque: Types of shopify, by the way, but I don’t know if we need to add it there in the.

80 00:09:22.960 ⇒ 00:09:25.869 Caio Velasco: In the source. Oh, maybe in the source one. Yes.

81 00:09:26.130 ⇒ 00:09:26.550 Luke Daque: Yeah.

82 00:09:26.550 ⇒ 00:09:32.979 Caio Velasco: Okay. So I think I don’t think we need these. These are just tools and sources are not really tools. I think.

83 00:09:35.340 ⇒ 00:09:36.080 Luke Daque: Yeah.

84 00:09:39.220 ⇒ 00:09:42.659 Caio Velasco: Okay. So from where from here, I can also do this part

85 00:09:43.490 ⇒ 00:09:46.350 Caio Velasco: you mentioned portable. So you can already delete this

86 00:09:47.130 ⇒ 00:09:53.380 Caio Velasco: and then data sources. I also yeah, from this I have all the data sources. So this is also okay.

87 00:09:54.147 ⇒ 00:10:00.160 Caio Velasco: Let me see if I have all the other description. Fine owner.

88 00:10:00.930 ⇒ 00:10:05.090 Caio Velasco: I don’t remember what they wanted by owner. Let me check exactly.

89 00:10:06.450 ⇒ 00:10:09.638 Caio Velasco: Owner was okay. Whoever owns that

90 00:10:10.170 ⇒ 00:10:11.080 Luke Daque: Hmm!

91 00:10:11.080 ⇒ 00:10:14.890 Luke Daque: I can just put you sure.

92 00:10:21.370 ⇒ 00:10:23.340 Luke Daque: I guess we can copy all the

93 00:10:23.970 ⇒ 00:10:27.320 Luke Daque: data sources that are in the big. No. One.

94 00:10:31.120 ⇒ 00:10:32.030 Caio Velasco: One.

95 00:10:33.350 ⇒ 00:10:36.989 Luke Daque: The ones in figma, like all the sources that are there.

96 00:10:38.360 ⇒ 00:10:42.330 Caio Velasco: Yeah, yeah.

97 00:10:46.830 ⇒ 00:10:49.390 Caio Velasco: let me check if it works, if it works.

98 00:10:53.540 ⇒ 00:10:55.669 Caio Velasco: and I assume they are all active.

99 00:10:57.020 ⇒ 00:10:59.460 Luke Daque: Yes, that’s right.

100 00:11:04.550 ⇒ 00:11:17.370 Caio Velasco: Description. It’s okay, or maybe like, let’s see, description depending. This would be like the description or simple.

101 00:11:18.250 ⇒ 00:11:21.379 Luke Daque: I think that’s too simple. I think we need. But

102 00:11:22.210 ⇒ 00:11:25.106 Luke Daque: maybe we can use that for now and then, just maybe

103 00:11:25.970 ⇒ 00:11:31.489 Luke Daque: expand on it so it would be better, I guess.

104 00:11:32.500 ⇒ 00:11:33.180 Caio Velasco: Here.

105 00:11:33.880 ⇒ 00:11:36.600 Luke Daque: But essentially th, those are yeah. The

106 00:11:38.080 ⇒ 00:11:42.829 Luke Daque: categories of the sources, like, if it’s for marketing or for

107 00:11:43.230 ⇒ 00:11:45.479 Luke Daque: orders and stuff like that. So yes.

108 00:11:47.380 ⇒ 00:11:49.700 Caio Velasco: And these are all right.

109 00:11:52.860 ⇒ 00:11:53.430 Luke Daque: These are.

110 00:11:54.020 ⇒ 00:11:56.700 Caio Velasco: Different types of Google sheets. Okay, I see.

111 00:12:20.230 ⇒ 00:12:30.239 Caio Velasco: Pipeline tool 2, 2, 2, where they’re just sources. So why, we have the 2 here. 5 Jesse.

112 00:12:30.240 ⇒ 00:12:30.665 Luke Daque: Hmm.

113 00:12:31.350 ⇒ 00:12:32.160 Luke Daque: Thanks. Steve.

114 00:12:32.160 ⇒ 00:12:33.080 Luke Daque: Suggestion.

115 00:12:35.690 ⇒ 00:12:36.350 Caio Velasco: Hmm!

116 00:12:39.320 ⇒ 00:12:42.770 Caio Velasco: Do we do? Do we really need this column?

117 00:12:43.860 ⇒ 00:12:48.380 Luke Daque: For like for a data source, maybe to tell where it’s coming from.

118 00:12:48.730 ⇒ 00:12:52.889 Luke Daque: Yeah, maybe just like in Javi’s case, where there’s multiple

119 00:12:53.440 ⇒ 00:12:59.530 Luke Daque: ingestion sources like, whether it’s from 5 can or portable. Then, yeah, maybe we need that field

120 00:13:00.690 ⇒ 00:13:05.599 Luke Daque: in pool parts, though it’s just 5 grand for everything. So.

121 00:13:06.050 ⇒ 00:13:06.500 Caio Velasco: True.

122 00:13:06.500 ⇒ 00:13:07.179 Luke Daque: But yeah.

123 00:13:07.673 ⇒ 00:13:13.650 Caio Velasco: Looking at this one here for Java, this this things make sense at all, because, dbt.

124 00:13:14.000 ⇒ 00:13:16.660 Caio Velasco: it’s just transformation, too. So.

125 00:13:16.820 ⇒ 00:13:22.070 Luke Daque: Yeah, that’s the 1011, 12 for job. It doesn’t

126 00:13:23.270 ⇒ 00:13:27.009 Luke Daque: bit, I guess, in that data source table.

127 00:13:27.730 ⇒ 00:13:31.060 Luke Daque: But I don’t know why it’s there.

128 00:13:31.060 ⇒ 00:13:34.289 Caio Velasco: I agree. I think it’s just coming from the template. So.

129 00:13:34.920 ⇒ 00:13:35.710 Luke Daque: Yeah.

130 00:13:36.570 ⇒ 00:13:39.945 Caio Velasco: I don’t remember using.

131 00:13:43.980 ⇒ 00:13:46.219 Caio Velasco: because now we don’t have access to anything.

132 00:13:46.340 ⇒ 00:13:50.409 Caio Velasco: Valjabi, right? So can’t really do this.

133 00:13:50.750 ⇒ 00:13:55.340 Luke Daque: Yeah, yeah, it sucks that. They.

134 00:13:55.670 ⇒ 00:13:57.690 Caio Velasco: Did not continue with us, but.

135 00:13:58.850 ⇒ 00:14:00.510 Luke Daque: Yeah, I guess that’s how it is.

136 00:14:02.550 ⇒ 00:14:04.160 Caio Velasco: Okay, I’ll I’ll check that.

137 00:14:05.710 ⇒ 00:14:08.189 Caio Velasco: Okay, back to pool parts.

138 00:14:08.530 ⇒ 00:14:13.640 Caio Velasco: So then here would be consuming from okay. 5 trend. That’s fine.

139 00:14:16.060 ⇒ 00:14:17.670 Caio Velasco: I believe everything is batch.

140 00:14:21.635 ⇒ 00:14:22.410 Luke Daque: Yes!

141 00:14:25.410 ⇒ 00:14:26.270 Caio Velasco: Okay.

142 00:14:26.600 ⇒ 00:14:32.560 Luke Daque: And then see, we have within the yeah. So

143 00:14:32.940 ⇒ 00:14:39.080 Luke Daque: almost everything is 6 h. The Google sheet is 8 h and.

144 00:14:39.460 ⇒ 00:14:40.220 Caio Velasco: There are.

145 00:14:40.220 ⇒ 00:14:45.050 Luke Daque: Dj, is 12. Yeah, there’s like, okay, yeah.

146 00:14:48.790 ⇒ 00:14:49.480 Caio Velasco: Oops.

147 00:14:56.940 ⇒ 00:14:57.940 Caio Velasco: Put this

148 00:15:02.570 ⇒ 00:15:06.830 Caio Velasco: the Cj cj, it’s another source. What Cj stands for.

149 00:15:08.190 ⇒ 00:15:15.149 Luke Daque: Cj. Is wait. I can’t remember what Cj. Was used for. But let me check.

150 00:15:17.320 ⇒ 00:15:21.100 Caio Velasco: I. I assume also that Google sheets affiliates. It’s marketing.

151 00:15:21.470 ⇒ 00:15:31.699 Luke Daque: Yeah, there’s a lot of like marketing sources. But like, see? Like

152 00:15:31.910 ⇒ 00:15:39.699 Luke Daque: the affiliates, for example, it’s not in Google ads. So I guess, like they are just sending it using Google sheets and stuff.

153 00:15:45.410 ⇒ 00:15:53.110 Luke Daque: Looks like Cj is also affiliate marketing. Related affiliate marketing.

154 00:16:15.370 ⇒ 00:16:20.339 Caio Velasco: Is one here, marketing, mapping ships, shipments.

155 00:16:35.790 ⇒ 00:16:39.680 Caio Velasco: basically 6 h for everything up to here.

156 00:16:42.760 ⇒ 00:16:43.290 Caio Velasco: And then.

157 00:16:43.290 ⇒ 00:16:43.930 Luke Daque: Yeah.

158 00:16:44.770 ⇒ 00:16:48.540 Caio Velasco: Negotiate affiliates in ours.

159 00:16:53.300 ⇒ 00:16:53.970 Caio Velasco: No.

160 00:17:02.830 ⇒ 00:17:03.730 Caio Velasco: you know.

161 00:17:06.620 ⇒ 00:17:07.080 Caio Velasco: Let’s see.

162 00:17:07.089 ⇒ 00:17:08.059 Luke Daque: Mj.

163 00:17:08.329 ⇒ 00:17:10.679 Caio Velasco: 12 h for cj, right?

164 00:17:11.599 ⇒ 00:17:14.370 Luke Daque: Yes, that’s correct.

165 00:17:14.839 ⇒ 00:17:19.670 Luke Daque: And then all the other Google sheets are one day.

166 00:17:20.770 ⇒ 00:17:22.839 Caio Velasco: Which I can put 24 h right?

167 00:17:22.849 ⇒ 00:17:23.799 Luke Daque: Yeah, yeah, that’s right.

168 00:17:23.800 ⇒ 00:17:25.339 Caio Velasco: Right? Okay, there’s no get.

169 00:17:27.660 ⇒ 00:17:28.319 Luke Daque: Cool.

170 00:17:29.150 ⇒ 00:17:30.650 Luke Daque: What’s duration?

171 00:17:31.430 ⇒ 00:17:32.000 Caio Velasco: So

172 00:17:32.490 ⇒ 00:17:44.059 Caio Velasco: I didn’t do this sheet, but when I did something in the in notion, I remember that when I put frequency and duration, duration was something related to.

173 00:17:44.650 ⇒ 00:17:51.240 Caio Velasco: How long does it take right, like every 6 h? But if it takes 4 h to just

174 00:17:51.530 ⇒ 00:18:03.110 Caio Velasco: complete the job, you know something like that. I don’t know like how important this is now. It’s something important, I think, but I don’t even know if we can find it.

175 00:18:04.703 ⇒ 00:18:08.840 Luke Daque: I well, I guess we can check 5 tran, but

176 00:18:11.030 ⇒ 00:18:19.290 Luke Daque: that it would depend right like sometimes it might be 2 h, and sometimes it might be 1 h depending on, like, how big the data is.

177 00:18:20.220 ⇒ 00:18:20.600 Caio Velasco: Except.

178 00:18:20.600 ⇒ 00:18:23.280 Luke Daque: Let me let me check if we can

179 00:18:24.140 ⇒ 00:18:32.600 Luke Daque: see it. Oh, yeah, it should have the average sync frequency.

180 00:18:33.350 ⇒ 00:18:42.310 Luke Daque: The biggest one is Amazon, which is an average of 38.9 min, followed by

181 00:18:43.140 ⇒ 00:18:46.779 Luke Daque: Facebook ads, which is 17 min.

182 00:18:48.330 ⇒ 00:18:53.790 Luke Daque: Do you have access to the 5 brand for brain? I mean for 2 parts.

183 00:18:56.340 ⇒ 00:18:57.260 Caio Velasco: Question.

184 00:19:18.780 ⇒ 00:19:19.640 Caio Velasco: huh?

185 00:19:19.750 ⇒ 00:19:22.070 Caio Velasco: Obviously have to do with one password.

186 00:19:24.700 ⇒ 00:19:25.460 Luke Daque: Yeah.

187 00:19:29.720 ⇒ 00:19:30.430 Caio Velasco: This one right.

188 00:19:30.570 ⇒ 00:19:32.049 Luke Daque: Yeah, you try that.

189 00:19:46.270 ⇒ 00:19:48.680 Caio Velasco: B, connection.

190 00:19:49.660 ⇒ 00:19:53.680 Luke Daque: Yeah. And if you look at, why can’t you see it?

191 00:19:54.590 ⇒ 00:19:56.879 Luke Daque: Mine shows in the last sync.

192 00:19:57.580 ⇒ 00:19:58.710 Luke Daque: It shows

193 00:20:03.040 ⇒ 00:20:11.170 Luke Daque: that’s weird. Mine is. Yeah, it’s showing there in the last thing in part.

194 00:20:16.570 ⇒ 00:20:18.459 Caio Velasco: Like a new column, or.

195 00:20:18.890 ⇒ 00:20:22.630 Luke Daque: It’s it’s no, it’s not a new call, but I can share my screen.

196 00:20:24.950 ⇒ 00:20:27.210 Luke Daque: I’ll show you how it looks like.

197 00:20:29.760 ⇒ 00:20:32.360 Luke Daque: I don’t know why, yours is different.

198 00:20:33.700 ⇒ 00:20:35.009 Luke Daque: Can you share my screen?

199 00:20:35.740 ⇒ 00:20:36.440 Caio Velasco: Year.

200 00:20:37.580 ⇒ 00:20:44.559 Luke Daque: Here it has like average duration. I don’t know. I don’t know why it was.

201 00:20:45.080 ⇒ 00:20:45.909 Caio Velasco: Have okay.

202 00:20:45.910 ⇒ 00:20:47.210 Luke Daque: To click this one. The.

203 00:20:47.646 ⇒ 00:20:49.830 Caio Velasco: Need to click, the dropdown.

204 00:20:49.830 ⇒ 00:20:51.069 Luke Daque: Yeah, yeah, okay, yeah.

205 00:20:51.560 ⇒ 00:20:52.549 Caio Velasco: Oh, nice!

206 00:20:55.660 ⇒ 00:21:03.739 Caio Velasco: Can I download the table? The older like this, this screen here the table.

207 00:21:04.150 ⇒ 00:21:08.270 Luke Daque: They could just copy, paste and chat and get all the free.

208 00:21:09.480 ⇒ 00:21:11.000 Luke Daque: Yeah, I don’t know.

209 00:21:18.450 ⇒ 00:21:19.569 Caio Velasco: Save the email.

210 00:21:19.570 ⇒ 00:21:22.289 Luke Daque: Copy it, and it will look like this.

211 00:21:23.790 ⇒ 00:21:25.310 Luke Daque: So maybe you can.

212 00:21:29.480 ⇒ 00:21:32.350 Caio Velasco: Nice. How did you copy? Did you copy just the whole page.

213 00:21:32.860 ⇒ 00:21:35.268 Luke Daque: Yeah, I just like, selected the

214 00:21:37.460 ⇒ 00:21:39.720 Luke Daque: yeah, I just selected something like this.

215 00:21:40.030 ⇒ 00:21:40.800 Caio Velasco: Okay.

216 00:21:41.660 ⇒ 00:21:44.930 Luke Daque: And then paste as as values, I guess.

217 00:21:46.240 ⇒ 00:21:49.260 Caio Velasco: This until I’ll delete.

218 00:21:50.210 ⇒ 00:21:53.140 Luke Daque: These special values on.

219 00:21:54.640 ⇒ 00:21:55.490 Caio Velasco: Alright cool.

220 00:21:58.860 ⇒ 00:22:08.879 Caio Velasco: Okay. So I can also do that for the duration. Okay, destination, apparently, is just raw.

221 00:22:09.180 ⇒ 00:22:13.079 Caio Velasco: Which do I have access to this? Or do I have to have

222 00:22:13.260 ⇒ 00:22:21.879 Caio Velasco: access in Snowflake or Github? It’s already sufficient, or or maybe even in the in the platform itself, right.

223 00:22:24.590 ⇒ 00:22:25.489 Luke Daque: I didn’t know.

224 00:22:26.290 ⇒ 00:22:27.109 Luke Daque: Can you?

225 00:22:27.600 ⇒ 00:22:28.170 Luke Daque: Information?

226 00:22:28.170 ⇒ 00:22:29.430 Luke Daque: Share your screen again?

227 00:22:30.215 ⇒ 00:22:30.670 Caio Velasco: Yes.

228 00:22:43.280 ⇒ 00:22:43.970 Caio Velasco: Okay.

229 00:22:45.340 ⇒ 00:22:47.770 Luke Daque: Yeah, I can see. See it now.

230 00:22:51.290 ⇒ 00:22:52.580 Caio Velasco: You can see? Right? Yeah.

231 00:22:52.850 ⇒ 00:22:53.530 Luke Daque: Yeah.

232 00:22:58.810 ⇒ 00:23:00.459 Luke Daque: what was your question? Again?

233 00:23:01.552 ⇒ 00:23:03.000 Caio Velasco: My question was

234 00:23:03.850 ⇒ 00:23:10.300 Caio Velasco: the destination in Snowflake. Everything, Snowflake. But I think that’s the only thing we have is data warehouse.

235 00:23:10.750 ⇒ 00:23:12.020 Luke Daque: Yes, that’s correct.

236 00:23:12.840 ⇒ 00:23:19.700 Caio Velasco: And the schema, let’s say, would be, where would I find.

237 00:23:20.425 ⇒ 00:23:21.150 Luke Daque: That.

238 00:23:23.540 ⇒ 00:23:25.010 Caio Velasco: Called Github.

239 00:23:30.240 ⇒ 00:23:35.729 Caio Velasco: because I mean this, even though I can find it in many places. I have to have a quick way

240 00:23:36.680 ⇒ 00:23:39.330 Caio Velasco: do it otherwise would be no.

241 00:23:39.330 ⇒ 00:23:39.960 Luke Daque: I don’t.

242 00:23:40.490 ⇒ 00:23:40.980 Caio Velasco: Client.

243 00:23:40.980 ⇒ 00:23:42.630 Luke Daque: I don’t think it’s in github

244 00:23:44.670 ⇒ 00:23:47.780 Luke Daque: but you can check the 5 trend, I guess. So if you

245 00:23:48.160 ⇒ 00:23:50.940 Luke Daque: click on edit connection in 5 grand.

246 00:23:52.550 ⇒ 00:23:53.850 Caio Velasco: Just one second.

247 00:23:56.670 ⇒ 00:24:01.990 Caio Velasco: If I go to model and sources, this is not sufficient, probably not right.

248 00:24:02.620 ⇒ 00:24:05.570 Luke Daque: And maybe that 1 5 trend database and then

249 00:24:05.670 ⇒ 00:24:12.400 Luke Daque: shopify. So 5 trend database dot shopify for the shopify.

250 00:24:13.600 ⇒ 00:24:21.590 Caio Velasco: This would be the the same name as in 5 7 like this.

251 00:24:23.060 ⇒ 00:24:24.350 Luke Daque: Yeah, it should be. Yeah.

252 00:24:25.360 ⇒ 00:24:25.890 Luke Daque: Okay.

253 00:24:25.890 ⇒ 00:24:31.980 Luke Daque: The schema you, if you check the schema in the sources. Yeah, no, that should be it.

254 00:24:37.460 ⇒ 00:24:38.859 Luke Daque: Oh, I can draw.

255 00:24:41.700 ⇒ 00:24:44.300 Caio Velasco: Because somewhere here you have to define destination.

256 00:24:44.300 ⇒ 00:24:47.109 Luke Daque: So you can go to setup.

257 00:24:51.920 ⇒ 00:24:54.469 Luke Daque: Yeah, that one. And then edit connection.

258 00:24:56.350 ⇒ 00:24:57.790 Luke Daque: Can you see my drawing.

259 00:24:58.500 ⇒ 00:25:01.372 Caio Velasco: Yes, they can. It’s actually nice. They do. The low.

260 00:25:01.980 ⇒ 00:25:02.880 Luke Daque: Yeah.

261 00:25:04.770 ⇒ 00:25:09.249 Luke Daque: Yeah. So yeah, it’s it’s the the schema is shopify. And then the

262 00:25:11.370 ⇒ 00:25:21.210 Luke Daque: The warehouse doesn’t look like it shows this warehouse, but but it should be the.

263 00:25:21.210 ⇒ 00:25:21.880 Caio Velasco: House.

264 00:25:22.040 ⇒ 00:25:28.540 Luke Daque: Maybe goes here. Yeah, maybe that one. Can you? Yeah, maybe click that

265 00:25:30.000 ⇒ 00:25:36.270 Luke Daque: 5 grand database. Yeah. If you scroll up a bit, this one, yeah.

266 00:25:37.759 ⇒ 00:25:40.830 Caio Velasco: Okay. But how do you know that this goes into wrong?

267 00:25:42.790 ⇒ 00:25:51.089 Luke Daque: That is the role. And that’s how it’s set up in full parts, because we we weren’t using the standard yet when this was set up.

268 00:25:51.700 ⇒ 00:25:59.580 Luke Daque: Because, if you remember, this is like the very 1st client that Utam had, and we didn’t use any standard like at all yet.

269 00:26:00.970 ⇒ 00:26:07.529 Luke Daque: So yeah, if we need to update this to our standard, we would we should be like renaming everything to raw

270 00:26:07.640 ⇒ 00:26:09.050 Luke Daque: for all the sources.

271 00:26:10.600 ⇒ 00:26:14.449 Luke Daque: But yeah, that’s how it was set up, back, then.

272 00:26:16.440 ⇒ 00:26:25.260 Caio Velasco: So this would be find trends, Dot.

273 00:26:26.080 ⇒ 00:26:32.730 Caio Velasco: It’s gonna do the 1st one. But that’s more. I mean, not this one, but the shopify one.

274 00:26:33.330 ⇒ 00:26:35.600 Luke Daque: Yeah, yeah, context.

275 00:26:35.600 ⇒ 00:26:38.000 Caio Velasco: And I would assume that all this.

276 00:26:40.040 ⇒ 00:26:42.290 Luke Daque: Would be 5 grand database. Yeah.

277 00:26:42.290 ⇒ 00:26:44.749 Caio Velasco: Pipeline database, and has to be in here.

278 00:26:45.950 ⇒ 00:26:46.959 Luke Daque: Yeah, that’s correct.

279 00:26:46.960 ⇒ 00:26:48.560 Caio Velasco: Okay, okay, great.

280 00:26:50.302 ⇒ 00:26:56.059 Caio Velasco: Okay. So I think for data source is fine. I can complete. After

281 00:26:56.460 ⇒ 00:27:00.649 Caio Velasco: then let’s jump this one and go to dashboards.

282 00:27:01.220 ⇒ 00:27:08.360 Caio Velasco: We’re not like currently, this is real, as I see from work.

283 00:27:09.120 ⇒ 00:27:11.379 Luke Daque: Yeah, it should be real.

284 00:27:11.710 ⇒ 00:27:16.219 Luke Daque: Yeah. All the dashboard, all the dashboards you have are in real.

285 00:27:17.510 ⇒ 00:27:21.369 Caio Velasco: Okay, do you? Or do I have access to to real.

286 00:27:21.530 ⇒ 00:27:28.090 Luke Daque: Let me check. I don’t think you have. But let me check.

287 00:27:28.780 ⇒ 00:27:30.690 Caio Velasco: I mean, if these names are

288 00:27:31.510 ⇒ 00:27:34.719 Caio Velasco: correct, are updated, this is all I need, but.

289 00:27:34.720 ⇒ 00:27:35.930 Luke Daque: Oh, yeah. Yeah.

290 00:27:40.500 ⇒ 00:27:45.480 Caio Velasco: Alright. Well, I think I’ll have to check with you anyways, just to confirm.

291 00:27:45.480 ⇒ 00:27:48.119 Luke Daque: Let me just open my real pen here.

292 00:27:48.660 ⇒ 00:27:52.609 Luke Daque: Pool points just to confirm. If that’s still up to date.

293 00:27:56.300 ⇒ 00:27:57.119 Luke Daque: it should be one.

294 00:27:57.120 ⇒ 00:28:02.010 Luke Daque: You receive 3, 4, 5, 6, 7. I can script. I can send you a screenshot.

295 00:28:11.840 ⇒ 00:28:14.489 Luke Daque: I sent the screenshot in chat.

296 00:28:15.210 ⇒ 00:28:17.040 Luke Daque: I think we should have it.

297 00:28:22.650 ⇒ 00:28:23.920 Caio Velasco: Just checked.

298 00:28:25.760 ⇒ 00:28:28.880 Caio Velasco: No, I wonder?

299 00:28:30.430 ⇒ 00:28:32.090 Caio Velasco: Or the item.

300 00:28:38.390 ⇒ 00:28:40.150 Caio Velasco: Okay, so they are different.

301 00:28:46.170 ⇒ 00:28:50.400 Caio Velasco: Oh, oh, launders native Api!

302 00:28:57.100 ⇒ 00:29:00.399 Caio Velasco: Let me save this picture to you then?

303 00:29:01.110 ⇒ 00:29:03.490 Caio Velasco: And I do related payments.

304 00:29:22.440 ⇒ 00:29:24.540 Caio Velasco: Yeah, ain’t good, neither.

305 00:29:26.550 ⇒ 00:29:36.519 Caio Velasco: And then priority. Do we have any like somewhere where we can find this priority? Or should I ask this to any or someone else.

306 00:29:41.470 ⇒ 00:29:43.300 Luke Daque: What was what was your question?

307 00:29:43.920 ⇒ 00:29:48.490 Caio Velasco: For this column here priority or the dashboards priority.

308 00:29:49.300 ⇒ 00:29:53.270 Luke Daque: That’s a good I also, and no.

309 00:29:53.940 ⇒ 00:29:56.400 Luke Daque: maybe we can set everything to.

310 00:29:57.740 ⇒ 00:30:03.150 Luke Daque: for sure. The I’m sure that the high one is the Daily Kpis

311 00:30:03.520 ⇒ 00:30:12.820 Luke Daque: and the rest. Maybe we can set to medium or low even, or yeah, medium for everything.

312 00:30:13.950 ⇒ 00:30:16.340 Luke Daque: because the daily Kpi is what

313 00:30:16.690 ⇒ 00:30:20.200 Luke Daque: they have been like looking at very recently. So yeah.

314 00:30:23.030 ⇒ 00:30:25.159 Caio Velasco: Do we have these categories?

315 00:30:29.450 ⇒ 00:30:30.830 Caio Velasco: Not really.

316 00:30:33.870 ⇒ 00:30:43.029 Luke Daque: So daily. Kpi would be like what I guess sales like revenue.

317 00:30:45.430 ⇒ 00:30:54.309 Caio Velasco: Oh, okay, so this is a good question. Because when I was here, what here, there’s a section

318 00:30:56.340 ⇒ 00:31:05.569 Caio Velasco: alright here that I took this from the repo from them for months.

319 00:31:05.830 ⇒ 00:31:09.660 Caio Velasco: So I’m assuming these are the categories should be.

320 00:31:13.100 ⇒ 00:31:13.950 Luke Daque: Yeah.

321 00:31:15.690 ⇒ 00:31:17.969 Caio Velasco: Because I think they are the ones.

322 00:31:22.290 ⇒ 00:31:24.670 Caio Velasco: Yeah, these ones, right?

323 00:31:27.200 ⇒ 00:31:27.930 Caio Velasco: Yep.

324 00:31:29.820 ⇒ 00:31:31.070 Caio Velasco: Makes sense

325 00:31:46.340 ⇒ 00:31:48.930 Caio Velasco: customer sales marketing.

326 00:31:49.690 ⇒ 00:31:53.320 Caio Velasco: So it would be Kpi then my guess?

327 00:31:54.370 ⇒ 00:31:57.750 Caio Velasco: Or do you think there’s another name that is better than this?

328 00:31:58.080 ⇒ 00:31:59.699 Caio Velasco: Or should we follow?

329 00:31:59.960 ⇒ 00:32:01.770 Caio Velasco: Maybe we should follow Marx.

330 00:32:04.290 ⇒ 00:32:05.710 Luke Daque: What was that? What was that?

331 00:32:06.240 ⇒ 00:32:11.790 Caio Velasco: Do you think we should follow for this part? Here we should follow the same as in March.

332 00:32:15.260 ⇒ 00:32:25.489 Luke Daque: Hmm, yeah, maybe. Yeah, we can follow marks, because that’s essentially what

333 00:32:26.770 ⇒ 00:32:30.100 Luke Daque: our reporting is going to be.

334 00:32:32.260 ⇒ 00:32:32.930 Caio Velasco: True.

335 00:32:34.290 ⇒ 00:32:34.810 Caio Velasco: Oh, we don’t.

336 00:32:34.810 ⇒ 00:32:36.180 Caio Velasco: Yeah, it makes sense brilliant.

337 00:32:36.900 ⇒ 00:32:43.020 Caio Velasco: So our okay. So there are the ones that you sent me and

338 00:32:45.510 ⇒ 00:32:50.760 Caio Velasco: the the screenshot you sent me? Do you have access to the text, or just to the screenshot?

339 00:32:51.640 ⇒ 00:32:54.699 Caio Velasco: Just so that makes it easier for me to copy paste.

340 00:32:54.700 ⇒ 00:33:01.910 Luke Daque: Didn’t wait. Maybe the one in the Github would make sense. Let me open up

341 00:33:03.150 ⇒ 00:33:07.240 Luke Daque: like how the folders are structured in the marks or in Github.

342 00:33:08.760 ⇒ 00:33:10.630 Luke Daque: Wait, let’s see.

343 00:33:15.020 ⇒ 00:33:19.309 Luke Daque: Yeah, those are actually the marts in Github.

344 00:33:19.420 ⇒ 00:33:26.360 Luke Daque: So of course, if you look at Kpi, for example, it’s it’s the Daily Kpi

345 00:33:26.920 ⇒ 00:33:31.559 Luke Daque: Ag, which is the Daily Kpi dashboard. That’s the source.

346 00:33:31.670 ⇒ 00:33:37.970 Luke Daque: So we can. Yeah, we can use the folder name for the categorization for that.

347 00:33:37.970 ⇒ 00:33:38.510 Caio Velasco: Okay.

348 00:33:38.510 ⇒ 00:33:44.810 Luke Daque: And also, like Kim’s Weekly report, as you can see, there would also be under Kpi, right? Yeah.

349 00:33:45.130 ⇒ 00:33:45.859 Luke Daque: yeah. That.

350 00:33:45.860 ⇒ 00:33:46.780 Caio Velasco: Yes.

351 00:33:47.860 ⇒ 00:33:49.599 Luke Daque: So maybe we can use that.

352 00:33:50.640 ⇒ 00:33:56.290 Luke Daque: So they, the the row number 3, which is daily Kpi is Kpi.

353 00:33:56.510 ⇒ 00:34:04.539 Luke Daque: And then didn’t we have teams we created for today, and the King’s Weekly report

354 00:34:05.090 ⇒ 00:34:08.449 Luke Daque: that’s in real would be Kpi, also

355 00:34:12.219 ⇒ 00:34:14.069 Luke Daque: the one in the screenshot.

356 00:34:15.290 ⇒ 00:34:22.629 Caio Velasco: Do you? Do you have a okay? Let me actually let me actually try something.

357 00:35:07.770 ⇒ 00:35:11.190 Caio Velasco: Oh, you can still see. My, yeah, my browser.

358 00:35:11.673 ⇒ 00:35:12.639 Luke Daque: Yep. Yep.

359 00:35:12.990 ⇒ 00:35:15.710 Caio Velasco: Let’s see if it’s if it helps.

360 00:35:17.890 ⇒ 00:35:25.350 Caio Velasco: Do you know why, sometimes it takes like so long? I even tried like to erasing memory and stuff, but nothing.

361 00:35:25.560 ⇒ 00:35:26.200 Caio Velasco: Oh, thanks.

362 00:35:26.200 ⇒ 00:35:29.870 Luke Daque: I think that’s like the servers for

363 00:35:30.390 ⇒ 00:35:37.050 Luke Daque: like if there’s so many people using chat gpt at the same time. So there’s service like balls.

364 00:35:37.050 ⇒ 00:35:39.479 Caio Velasco: So clearly. Everyone loves it.

365 00:35:40.657 ⇒ 00:35:42.389 Luke Daque: Yeah, looks like.

366 00:35:42.390 ⇒ 00:35:44.209 Caio Velasco: My God! This just saved my life! See!

367 00:35:47.200 ⇒ 00:35:50.220 Luke Daque: That’s how AI can make our work faster.

368 00:35:56.360 ⇒ 00:35:57.180 Caio Velasco: Okay?

369 00:36:20.770 ⇒ 00:36:22.350 Caio Velasco: Why, it doesn’t work

370 00:36:22.730 ⇒ 00:36:27.770 Caio Velasco: link for that. And then do you have the link for the for-, for the dashboards?

371 00:36:29.180 ⇒ 00:36:34.000 Luke Daque: Yeah, I can send it to you. Let me, but I know I don’t know if you have access yet, because

372 00:36:36.020 ⇒ 00:36:39.909 Caio Velasco: I don’t would give me like maybe amber.

373 00:36:40.540 ⇒ 00:36:43.589 Luke Daque: I can give it to you. I don’t have access to.

374 00:36:43.820 ⇒ 00:36:45.599 Caio Velasco: Okay, that’ll be good.

375 00:36:47.240 ⇒ 00:36:49.149 Luke Daque: One I just sent you in chat.

376 00:36:51.030 ⇒ 00:36:51.940 Caio Velasco: One. Sec.

377 00:37:37.660 ⇒ 00:37:39.389 Caio Velasco: This requested.

378 00:37:55.230 ⇒ 00:37:57.829 Caio Velasco: when you you have to approve right pro-pro.

379 00:38:02.300 ⇒ 00:38:04.059 Luke Daque: Let me see if I receive.

380 00:38:06.750 ⇒ 00:38:09.630 Luke Daque: Oh, yeah, I did approve. Let me see.

381 00:38:18.820 ⇒ 00:38:20.160 Luke Daque: I gave you edit.

382 00:38:20.360 ⇒ 00:38:24.090 Luke Daque: 3rd access. Can you try refreshing, maybe.

383 00:38:27.610 ⇒ 00:38:29.930 Luke Daque: or click on the link again, or something.

384 00:38:33.140 ⇒ 00:38:36.319 Caio Velasco: Do I need to say this, or it’s already. Oh, let’s see.

385 00:38:38.320 ⇒ 00:38:38.900 Caio Velasco: Richard!

386 00:38:39.470 ⇒ 00:38:40.070 Caio Velasco: Again.

387 00:38:40.500 ⇒ 00:38:43.979 Luke Daque: I maybe click on the link from the zoom again.

388 00:38:48.750 ⇒ 00:38:51.840 Luke Daque: because I already approve it. You should have access here.

389 00:38:52.130 ⇒ 00:38:55.269 Caio Velasco: Yeah, probably it’s like some cash sheet or something.

390 00:38:56.190 ⇒ 00:38:57.110 Caio Velasco: Yeah, there you go.

391 00:38:58.280 ⇒ 00:38:59.480 Caio Velasco: Mice.

392 00:39:29.380 ⇒ 00:39:30.230 Caio Velasco: Nice.

393 00:39:30.930 ⇒ 00:39:38.250 Caio Velasco: Okay? So I think I then I can get each one of them, or actually

394 00:39:39.590 ⇒ 00:39:41.979 Caio Velasco: okay, here would be all the dashboards.

395 00:39:42.730 ⇒ 00:39:43.520 Caio Velasco: Okay?

396 00:39:44.330 ⇒ 00:39:53.439 Caio Velasco: And do you know, given the marks, what is what here is there like a way to.

397 00:39:59.150 ⇒ 00:40:04.499 Caio Velasco: I’m not sure if it’s like marketing. Okay, this is kind of obvious.

398 00:40:05.520 ⇒ 00:40:11.110 Luke Daque: Yeah, we can check the like I mentioned via the the Github folder structure

399 00:40:11.610 ⇒ 00:40:19.270 Luke Daque: for the sources like, yeah, like, if you click, maybe marketing. We should be like customers. Yeah, we should be able to see.

400 00:40:22.310 ⇒ 00:40:24.060 Caio Velasco: Right by performance.

401 00:40:25.500 ⇒ 00:40:32.389 Caio Velasco: Because I mean, this is something that that’s the reason why we are building this, because, for example, now, we would like to know

402 00:40:32.980 ⇒ 00:40:36.290 Caio Velasco: the marts and the connection to

403 00:40:36.420 ⇒ 00:40:41.980 Caio Velasco: to the dashboards, and we kind of lose a lot of time right trying to find out.

404 00:40:43.090 ⇒ 00:40:43.960 Luke Daque: Yeah.

405 00:40:46.740 ⇒ 00:40:55.209 Caio Velasco: For example, we want to know. Okay, these are the names of the dashboards, but a dashboard can

406 00:40:56.830 ⇒ 00:40:59.139 Caio Velasco: can come from many marks as well.

407 00:41:03.260 ⇒ 00:41:06.329 Caio Velasco: so theoretically we need to be here

408 00:41:06.570 ⇒ 00:41:09.659 Caio Velasco: and then go. Let’s say all orders.

409 00:41:10.560 ⇒ 00:41:11.220 Luke Daque: Yeah.

410 00:41:11.460 ⇒ 00:41:13.579 Caio Velasco: And somehow find.

411 00:41:17.770 ⇒ 00:41:24.210 Caio Velasco: find like this table, or this one, or like, and then infer.

412 00:41:25.360 ⇒ 00:41:28.229 Luke Daque: Well, I guess we can make our own. We can

413 00:41:28.770 ⇒ 00:41:32.139 Luke Daque: probably categorize it can maybe let’s try like

414 00:41:32.360 ⇒ 00:41:35.739 Luke Daque: having chat. Gpt, categorize this for us.

415 00:41:36.580 ⇒ 00:41:39.009 Luke Daque: Let me see if I can do that. Here.

416 00:41:40.070 ⇒ 00:41:40.760 Caio Velasco: Okay.

417 00:41:45.550 ⇒ 00:41:53.840 Luke Daque: To help me that federalize these report documents.

418 00:41:56.650 ⇒ 00:41:59.480 Caio Velasco: But even though Chatty can try something

419 00:42:00.220 ⇒ 00:42:05.179 Caio Velasco: if we have this marketing table being used

420 00:42:05.390 ⇒ 00:42:12.519 Caio Velasco: in the All Orders dashboard! This should be in the spreadsheet. But Chatebt won’t know it.

421 00:42:13.430 ⇒ 00:42:20.029 Luke Daque: Yeah, but like but maybe that’s not the best way, right like

422 00:42:23.260 ⇒ 00:42:33.290 Caio Velasco: Okay, I see, because this is like a dashboard tab. So it doesn’t need to be connected to barge.

423 00:42:34.000 ⇒ 00:42:36.899 Caio Velasco: because these are already connected to mark.

424 00:42:37.550 ⇒ 00:42:38.400 Luke Daque: Yeah.

425 00:42:38.590 ⇒ 00:42:41.570 Caio Velasco: The metrics and the dashboard names

426 00:42:42.390 ⇒ 00:42:47.039 Caio Velasco: so kind of we already had this. So this should be exactly what you’re saying, just like that.

427 00:42:47.820 ⇒ 00:42:48.260 Luke Daque: Can you.

428 00:42:48.260 ⇒ 00:42:49.370 Caio Velasco: Yeah, but wouldn’t be nice to me.

429 00:42:49.370 ⇒ 00:42:52.139 Caio Velasco: like the categories matching the marks.

430 00:42:53.610 ⇒ 00:42:58.750 Luke Daque: Yeah, this is like what chat Gpt suggested the one at the bottom.

431 00:43:02.190 ⇒ 00:43:03.800 Luke Daque: Does this make sense?

432 00:43:04.200 ⇒ 00:43:05.179 Luke Daque: Okay? Again.

433 00:43:10.260 ⇒ 00:43:11.750 Caio Velasco: Yeah, I think so.

434 00:43:20.710 ⇒ 00:43:25.640 Luke Daque: Make sure you can change keeping my.

435 00:43:28.230 ⇒ 00:43:30.689 Caio Velasco: Teams. What is Kim to person.

436 00:43:31.180 ⇒ 00:43:33.449 Luke Daque: Yeah team suppression. She’s using that.

437 00:43:35.870 ⇒ 00:43:40.779 Luke Daque: She’s in the data. Oh, yeah, we should add the data stakeholder. I think

438 00:43:40.930 ⇒ 00:43:46.460 Luke Daque: that’s already in the notion document. But that.

439 00:43:47.200 ⇒ 00:43:47.880 Caio Velasco: In motion.

440 00:43:53.990 ⇒ 00:44:01.129 Caio Velasco: Yes, these would be the stakeholders with this person I.

441 00:44:13.200 ⇒ 00:44:13.640 Luke Daque: Okay.

442 00:44:13.640 ⇒ 00:44:14.820 Caio Velasco: Yes. Okay.

443 00:44:15.170 ⇒ 00:44:15.769 Luke Daque: Yeah, give me.

444 00:44:15.770 ⇒ 00:44:18.489 Caio Velasco: Do we need to be here as stakeholder or.

445 00:44:18.890 ⇒ 00:44:23.130 Luke Daque: I don’t know. Maybe I can add myself.

446 00:44:23.940 ⇒ 00:44:28.639 Caio Velasco: It may be only you, and I wish I wish, as I wish, worked on with pool parked.

447 00:44:29.330 ⇒ 00:44:30.879 Luke Daque: I don’t think so.

448 00:44:44.041 ⇒ 00:44:45.790 Caio Velasco: Yeah. Okay, of course. Yeah, please.

449 00:44:49.620 ⇒ 00:44:50.760 Luke Daque: I guess you need to

450 00:44:54.930 ⇒ 00:44:55.870 Luke Daque: come on.

451 00:45:02.420 ⇒ 00:45:03.370 Caio Velasco: 8 seconds.

452 00:45:08.000 ⇒ 00:45:11.590 Luke Daque: And you just need to add their emails here somehow.

453 00:45:14.690 ⇒ 00:45:15.810 Caio Velasco: Yeah, but.

454 00:45:16.230 ⇒ 00:45:20.120 Luke Daque: Yeah, I think think this should be fine

455 00:45:20.727 ⇒ 00:45:24.880 Luke Daque: in terms of like the data category for dashboards, for now

456 00:45:31.320 ⇒ 00:45:35.070 Luke Daque: warranties would be creations.

457 00:45:35.840 ⇒ 00:45:36.979 Luke Daque: I guess.

458 00:45:40.140 ⇒ 00:45:41.240 Caio Velasco: His partners.

459 00:45:41.480 ⇒ 00:45:42.320 Caio Velasco: Yes.

460 00:45:43.580 ⇒ 00:45:46.020 Luke Daque: Shopify cost.

461 00:45:47.900 ⇒ 00:45:49.809 Luke Daque: Yeah, I think that should be fine.

462 00:45:50.340 ⇒ 00:45:51.600 Caio Velasco: Yeah, I think so.

463 00:45:52.540 ⇒ 00:45:57.911 Caio Velasco: Yeah, I think for those things. I think we have everything we need. I can do the rest.

464 00:45:58.980 ⇒ 00:46:07.020 Caio Velasco: for this one here, the core metrics and lineage that’s the one that, like we would lose them the majority of time.

465 00:46:07.480 ⇒ 00:46:15.160 Caio Velasco: No, I’m not sure how any did, Eden, because I’m still waiting for her. Okay.

466 00:46:16.547 ⇒ 00:46:18.370 Caio Velasco: believe in it.

467 00:46:26.510 ⇒ 00:46:29.340 Caio Velasco: I don’t know if you replied my question

468 00:46:31.576 ⇒ 00:46:37.660 Caio Velasco: yeah, because I she did for Eden, but I’m not sure mean she followed any.

469 00:46:38.870 ⇒ 00:46:43.350 Caio Velasco: I don’t know like any efficient way to do this.

470 00:46:45.340 ⇒ 00:46:48.400 Caio Velasco: Because when I talk to a wish, this is what.

471 00:46:48.400 ⇒ 00:46:48.720 Luke Daque: Don’t use it.

472 00:46:48.720 ⇒ 00:46:49.670 Caio Velasco: Said,

473 00:46:54.250 ⇒ 00:46:56.520 Caio Velasco: let me see. I don’t remember where.

474 00:47:00.180 ⇒ 00:47:05.190 Caio Velasco: Yes, this is what he said for that column, the data pipeline column.

475 00:47:05.968 ⇒ 00:47:13.630 Caio Velasco: I asked. Like if we want just the name of the Dbt. Models or the sources and reference tables in the model.

476 00:47:13.760 ⇒ 00:47:17.440 Caio Velasco: And he’s, he said, he said, broad tables we can get

477 00:47:17.670 ⇒ 00:47:20.829 Caio Velasco: for me. I think he wants to complete the lineage.

478 00:47:23.870 ⇒ 00:47:27.680 Caio Velasco: So cool parts.

479 00:47:27.980 ⇒ 00:47:34.140 Caio Velasco: I think I have the repo mix for pool parts or not. Kind of cool.

480 00:47:42.580 ⇒ 00:47:44.910 Caio Velasco: Yeah, no, I don’t have for cool parts.

481 00:47:45.610 ⇒ 00:47:48.340 Caio Velasco: Do we have this in here?

482 00:47:51.700 ⇒ 00:47:56.400 Caio Velasco: So, for example, in Oahu, we I can do manually, but.

483 00:47:57.020 ⇒ 00:47:57.990 Luke Daque: Without.

484 00:47:59.170 ⇒ 00:48:11.072 Caio Velasco: The repo mix. I cannot even use chat. Guess let’s say that I you know when

485 00:48:12.030 ⇒ 00:48:25.819 Caio Velasco: but there’s a lot of different this one I wanna have complete lineage of. Actually, it’s not even starting by the table. Actually, if you go to the spreadsheet, we are starting by the core metric. So I would have to go to real

486 00:48:26.550 ⇒ 00:48:32.450 Caio Velasco: to this specific dashboard, for example, and get all the metrics

487 00:48:33.220 ⇒ 00:48:39.119 Caio Velasco: which I don’t need. Well, since I didn’t do this. I don’t even know what would be a metric here. Maybe this is a metric.

488 00:48:39.700 ⇒ 00:48:44.650 Caio Velasco: This is another metric this year.

489 00:48:45.060 ⇒ 00:48:50.909 Caio Velasco: just the average over time. Maybe so. I don’t even know what would be the metrics here.

490 00:48:53.340 ⇒ 00:48:54.550 Caio Velasco: Setting. But

491 00:48:57.770 ⇒ 00:48:58.500 Caio Velasco: hmm!

492 00:48:59.960 ⇒ 00:49:03.399 Caio Velasco: We wouldn’t know where to start. This would take like a lot of time.

493 00:49:03.400 ⇒ 00:49:05.500 Luke Daque: Yeah, there’s there’s so much

494 00:49:08.820 ⇒ 00:49:14.840 Luke Daque: there’s so much custom calculation for pool parts, which is

495 00:49:15.580 ⇒ 00:49:19.409 Luke Daque: yeah. It’s gonna take a while for us to like complete all the metrics

496 00:49:23.770 ⇒ 00:49:29.319 Luke Daque: like, even for shipping. There’s like lots of shipping partners and like

497 00:49:29.690 ⇒ 00:49:35.400 Luke Daque: shipping cost is calculated differently across shipping partners.

498 00:49:35.810 ⇒ 00:49:39.500 Luke Daque: So yeah, it’s gonna take a while to do that.

499 00:49:41.440 ⇒ 00:49:44.289 Caio Velasco: Okay, so what should we do?

500 00:49:45.130 ⇒ 00:49:47.370 Caio Velasco: No. 3, 5 weeks knows this.

501 00:49:48.360 ⇒ 00:49:57.329 Caio Velasco: Because I think we yeah, if the granularity here is on the metric level.

502 00:49:57.880 ⇒ 00:50:05.300 Caio Velasco: Then 1st we will need a list of metrics. Do we have this like? For whoever built did you bid real, or was it any.

503 00:50:06.890 ⇒ 00:50:08.790 Luke Daque: I I did do real.

504 00:50:08.790 ⇒ 00:50:09.370 Caio Velasco: Okay?

505 00:50:09.600 ⇒ 00:50:18.840 Caio Velasco: Then I assume you did like more like on the fly that you didn’t have like a complete list of metrics and then it went like one by one, creating them.

506 00:50:19.160 ⇒ 00:50:21.639 Luke Daque: The. It was like

507 00:50:22.170 ⇒ 00:50:31.839 Luke Daque: the history, basically, for pool parts was this was like Utam’s 1st client. And he he started working on the models created the

508 00:50:32.620 ⇒ 00:50:35.280 Luke Daque: The among the majority of the models.

509 00:50:35.830 ⇒ 00:50:39.189 Caio Velasco: And and he was initially using.

510 00:50:39.600 ⇒ 00:50:44.510 Luke Daque: A different reporting tool. It wasn’t real yet it was light dash.

511 00:50:45.562 ⇒ 00:50:50.850 Luke Daque: and then, when I joined Brainforge, I was like helping him

512 00:50:51.240 ⇒ 00:50:59.930 Luke Daque: with what he already made for pool part. So I added more models. And that’s also when we decided to transfer to real.

513 00:51:00.430 ⇒ 00:51:06.699 Luke Daque: So we had to switch all the current dashboards that were in light dash to rail.

514 00:51:06.910 ⇒ 00:51:14.600 Luke Daque: But yeah, there were there. There was like a lot of back and forth communication between the client and us for like

515 00:51:15.000 ⇒ 00:51:24.620 Luke Daque: how to calculate stuff like returns, for example, from shopify versus returns from Amazon, and like shipping from

516 00:51:25.500 ⇒ 00:51:30.609 Luke Daque: from Ltl. Versus shipping, from ship station and

517 00:51:30.860 ⇒ 00:51:44.529 Luke Daque: stuff like that. So yeah, there’s there’s there’s a lot of metrics we’ll we can. We’ll have to. I can’t even remember all of them, because there’s a lot we’ll have to like check how the logic is being done in like the the models. So we can.

518 00:51:45.200 ⇒ 00:51:47.760 Luke Daque: I guess we’ll do here.

519 00:51:48.980 ⇒ 00:51:49.560 Luke Daque: Yeah.

520 00:51:49.560 ⇒ 00:51:57.660 Caio Velasco: Okay, just so that we see a bit of the pain here. And why? Don’t know? See if we have an idea. But if you if we were to pick one

521 00:51:57.860 ⇒ 00:52:00.320 Caio Velasco: for us to do now like a simple one.

522 00:52:00.560 ⇒ 00:52:04.749 Caio Velasco: what which one would it be? From which dashboard, which metric.

523 00:52:05.350 ⇒ 00:52:10.680 Luke Daque: Maybe we can use the Daily Tpi dashboard, since that’s the high priority dashboard.

524 00:52:11.060 ⇒ 00:52:17.230 Luke Daque: and that those were those would be like revenue related

525 00:52:17.970 ⇒ 00:52:23.020 Luke Daque: like, say, total sales ordered sales product margin total calls.

526 00:52:23.360 ⇒ 00:52:28.800 Luke Daque: Yeah, that those should be pretty straightforward, I believe, just like they are like generic.

527 00:52:30.440 ⇒ 00:52:35.160 Caio Velasco: Okay, so total sales would be one. Let me, what do you?

528 00:52:35.360 ⇒ 00:52:43.159 Caio Velasco: 1,007, then let’s see, that would be where would be daily Kpis.

529 00:52:43.490 ⇒ 00:52:46.180 Luke Daque: Can we check? Yeah, can we check the Kpi?

530 00:52:47.279 ⇒ 00:52:47.679 Luke Daque: Yeah.

531 00:52:48.260 ⇒ 00:52:53.330 Luke Daque: Or if the model in the repo, I hope we added some

532 00:52:57.615 ⇒ 00:52:59.219 Caio Velasco: Dashboards.

533 00:53:03.650 ⇒ 00:53:04.280 Caio Velasco: Here we go!

534 00:53:04.810 ⇒ 00:53:06.140 Caio Velasco: Oh, differently!

535 00:53:06.150 ⇒ 00:53:08.123 Luke Daque: Open, daily.

536 00:53:13.490 ⇒ 00:53:19.409 Caio Velasco: The GPS, and then here I click here.

537 00:53:20.050 ⇒ 00:53:25.230 Luke Daque: Do you have access to cursory.

538 00:53:26.940 ⇒ 00:53:28.700 Caio Velasco: Not sure.

539 00:53:38.320 ⇒ 00:53:41.930 Caio Velasco: or for like in Vs code, or something.

540 00:53:42.790 ⇒ 00:53:45.080 Luke Daque: Yeah, I in, yeah, cursor.

541 00:53:45.800 ⇒ 00:53:46.630 Caio Velasco: Hmm.

542 00:53:47.890 ⇒ 00:53:48.560 Luke Daque: Wait!

543 00:53:52.810 ⇒ 00:53:59.570 Caio Velasco: You mean you mean opening the repo on Vs code and doing something with courser. Is that what you mean?

544 00:54:00.470 ⇒ 00:54:02.619 Luke Daque: Yeah. Have you tried that?

545 00:54:02.620 ⇒ 00:54:05.949 Caio Velasco: No, I haven’t used Jasper in a while, to be honest.

546 00:54:06.578 ⇒ 00:54:11.950 Caio Velasco: In like a month or so. I don’t have this rep. I can do it

547 00:54:14.600 ⇒ 00:54:16.679 Caio Velasco: even know what it is connected to.

548 00:54:20.360 ⇒ 00:54:20.930 Caio Velasco: Okay.

549 00:54:23.120 ⇒ 00:54:25.870 Caio Velasco: So I’ll have to open a new window.

550 00:54:32.380 ⇒ 00:54:33.580 Caio Velasco: No, don’t.

551 00:54:34.660 ⇒ 00:54:35.569 Caio Velasco: There we go.

552 00:54:41.458 ⇒ 00:54:45.400 Caio Velasco: Report to clone the right. Let me see, Clone, the right.

553 00:55:47.920 ⇒ 00:55:51.289 Caio Velasco: This show that I haven’t been doing technical things for a while.

554 00:55:52.406 ⇒ 00:55:52.880 Luke Daque: Thank you.

555 00:55:53.350 ⇒ 00:55:57.010 Caio Velasco: I the red pop. Okay, I’ll do that.

556 00:56:09.090 ⇒ 00:56:12.350 Luke Daque: Yeah, it’s not working. Really.

557 00:56:16.460 ⇒ 00:56:17.560 Caio Velasco: People can find

558 00:56:18.510 ⇒ 00:56:24.430 Caio Velasco: repository. Okay? So I have to debug this because it might, it might even be connect to another profile.

559 00:56:25.250 ⇒ 00:56:26.399 Luke Daque: No worries.

560 00:56:28.850 ⇒ 00:56:30.689 Caio Velasco: Repository not found.

561 00:56:31.350 ⇒ 00:56:37.070 Luke Daque: So this is just data source, like

562 00:56:38.510 ⇒ 00:56:42.199 Luke Daque: in this, like core metrics and deanage tab

563 00:56:43.210 ⇒ 00:56:46.050 Luke Daque: like, if you, if we go back to the Google Sheet.

564 00:56:48.085 ⇒ 00:56:50.559 Luke Daque: for total sales. For example.

565 00:56:52.060 ⇒ 00:56:53.320 Caio Velasco: Just one second.

566 00:56:53.930 ⇒ 00:56:54.660 Luke Daque: For sure.

567 00:56:55.100 ⇒ 00:56:55.710 Caio Velasco: One sec.

568 00:56:55.960 ⇒ 00:56:57.629 Caio Velasco: Let’s see if this works.

569 00:57:18.980 ⇒ 00:57:21.399 Caio Velasco: Yeah, well, I’ll have to do both for them.

570 00:57:21.570 ⇒ 00:57:23.470 Caio Velasco: Okay, what? What did you say? Sorry.

571 00:57:25.715 ⇒ 00:57:28.190 Luke Daque: Yeah, if you go back to the Google Sheet.

572 00:57:29.730 ⇒ 00:57:30.819 Caio Velasco: Oh, well, she.

573 00:57:32.770 ⇒ 00:57:37.660 Luke Daque: Yeah. So for total, the total sales, the data source. Are we?

574 00:57:40.460 ⇒ 00:57:44.539 Luke Daque: Are we getting? What do we add there? Is it going to be

575 00:57:44.990 ⇒ 00:57:47.719 Luke Daque: like. For in this case, for example, we have

576 00:57:47.880 ⇒ 00:57:52.069 Luke Daque: orders coming from shopify. We have orders coming from Amazon.

577 00:57:54.030 ⇒ 00:57:59.990 Luke Daque: do we add those as the data source? Or do we just put all orders, which is like the

578 00:58:00.970 ⇒ 00:58:05.380 Luke Daque: the model that we are using to show.

579 00:58:10.010 ⇒ 00:58:11.879 Caio Velasco: One. Then they already did

580 00:58:15.480 ⇒ 00:58:16.650 Caio Velasco: corporate banks.

581 00:58:20.890 ⇒ 00:58:23.209 Caio Velasco: but I think they’re basically adding, like the

582 00:58:24.610 ⇒ 00:58:30.900 Caio Velasco: like, all the source I mean, I would assume the source. Dot Eml file would be

583 00:58:31.260 ⇒ 00:58:33.879 Caio Velasco: the source like the source ginger

584 00:58:36.920 ⇒ 00:58:38.870 Caio Velasco: pointing to each metric.

585 00:58:39.170 ⇒ 00:58:40.659 Caio Velasco: So if you let’s say.

586 00:58:40.660 ⇒ 00:58:41.219 Luke Daque: One year.

587 00:58:41.490 ⇒ 00:58:43.149 Caio Velasco: Total sales.

588 00:58:43.860 ⇒ 00:58:49.569 Caio Velasco: And then how do I see where this come from? Is that like a sequel code for this.

589 00:58:50.520 ⇒ 00:58:53.600 Luke Daque: Yeah should be in the should be in the

590 00:58:55.230 ⇒ 00:58:59.899 Luke Daque: in the Daily Kpi model, in the repository.

591 00:59:02.306 ⇒ 00:59:09.159 Caio Velasco: But but wait! But how would I know that this basic Api is exactly that model.

592 00:59:09.460 ⇒ 00:59:16.130 Luke Daque: So yeah, if you go to the repository and go to the

593 00:59:16.410 ⇒ 00:59:18.629 Luke Daque: pool parts to go real folder.

594 00:59:19.650 ⇒ 00:59:23.289 Luke Daque: not not the Dbt project, but the pool parts to go real.

595 00:59:24.798 ⇒ 00:59:26.911 Caio Velasco: Yes, through. It’s here

596 00:59:27.440 ⇒ 00:59:29.679 Luke Daque: And then dashboards.

597 00:59:30.060 ⇒ 00:59:31.040 Caio Velasco: Folder.

598 00:59:32.150 ⇒ 00:59:36.768 Luke Daque: And then daily Kpi model, dashboard. Yaml, if you click

599 00:59:37.960 ⇒ 00:59:40.499 Luke Daque: the Daily Kpi, yeah, that one.

600 00:59:41.220 ⇒ 00:59:42.049 Caio Velasco: They don’t hear.

601 00:59:42.240 ⇒ 00:59:44.579 Luke Daque: Yeah, that one daily Kpi dashboard

602 00:59:45.530 ⇒ 00:59:55.850 Luke Daque: and then total sales. You can see it’s the sum of total price, right? But to be able to know. So it’s coming from the Daily Kpi model.

603 00:59:56.560 ⇒ 01:00:01.160 Luke Daque: So you have to check the models folder in the

604 01:00:01.330 ⇒ 01:00:08.210 Luke Daque: pull parts to go real to know which source it’s coming from.

605 01:00:09.470 ⇒ 01:00:10.160 Caio Velasco: Okay, if you.

606 01:00:10.160 ⇒ 01:00:10.580 Luke Daque: Go back.

607 01:00:10.580 ⇒ 01:00:11.460 Caio Velasco: Right corner.

608 01:00:11.970 ⇒ 01:00:13.400 Luke Daque: Yeah. If you go back.

609 01:00:17.430 ⇒ 01:00:18.579 Caio Velasco: Big one right?

610 01:00:19.670 ⇒ 01:00:20.859 Luke Daque: Yeah, that one.

611 01:00:23.420 ⇒ 01:00:26.469 Luke Daque: It’s coming from Daily Kpi source.

612 01:00:27.560 ⇒ 01:00:29.600 Luke Daque: So if you go back again.

613 01:00:30.070 ⇒ 01:00:33.769 Caio Velasco: Source here, yeah, sources.

614 01:00:34.250 ⇒ 01:00:38.260 Luke Daque: And there’s a daily Kpi, that one.

615 01:00:38.260 ⇒ 01:00:38.920 Caio Velasco: You know.

616 01:00:40.200 ⇒ 01:00:40.810 Caio Velasco: Oh, wow!

617 01:00:40.810 ⇒ 01:00:45.850 Luke Daque: It should show. Yeah, it’s the marts dot daily. Kpi, ag.

618 01:00:46.210 ⇒ 01:00:52.440 Luke Daque: so it’s going to be the Daily Kpi, Ag, Dbt model. Basically.

619 01:01:01.480 ⇒ 01:01:06.296 Caio Velasco: How if someone would look at this, how would this person know that it’s

620 01:01:07.070 ⇒ 01:01:08.480 Caio Velasco: But wait! What is that?

621 01:01:08.720 ⇒ 01:01:15.069 Caio Velasco: What is this? Again? It’s a so that boom.

622 01:01:16.998 ⇒ 01:01:19.509 Caio Velasco: This is a table in the snowflake.

623 01:01:20.130 ⇒ 01:01:20.880 Luke Daque: Yes.

624 01:01:22.040 ⇒ 01:01:28.969 Caio Velasco: Okay? And what is ingesting what source is ingesting this table?

625 01:01:29.350 ⇒ 01:01:32.839 Caio Velasco: Maybe this is not even the source right? There is a source behind it.

626 01:01:33.170 ⇒ 01:01:36.540 Luke Daque: Yeah, if we that should be coming from the

627 01:01:37.030 ⇒ 01:01:40.439 Luke Daque: Dbt March model, the Daily Kpi ad

628 01:01:40.810 ⇒ 01:01:49.800 Luke Daque: March model. So if we go to the Dbt. March, and then Kpi, my models.

629 01:01:51.540 ⇒ 01:01:54.319 Luke Daque: and then marts, and then Kpi.

630 01:01:55.030 ⇒ 01:02:04.069 Luke Daque: and then their daily Kpi ag, which is the same name as the Snowflake table. Yeah, you should be able to see it there.

631 01:02:04.360 ⇒ 01:02:06.999 Luke Daque: So it’s referencing all orders.

632 01:02:11.130 ⇒ 01:02:12.700 Caio Velasco: As well as sheets.

633 01:02:13.200 ⇒ 01:02:22.650 Luke Daque: Yeah, that’s yeah for the shipments, so that all it has a lot. So it has all orders. It has shipments, and for marketing it’s marketing.

634 01:02:26.440 ⇒ 01:02:27.860 Caio Velasco: Okay. So

635 01:02:28.520 ⇒ 01:02:35.839 Caio Velasco: so that that’s how difficult this is. I’m not sure if I wish understood this, then because this is takes a lot like.

636 01:02:36.030 ⇒ 01:02:41.049 Caio Velasco: So let’s say again, we go to the real. And then we saw

637 01:02:41.620 ⇒ 01:02:48.509 Caio Velasco: a lot of metrics. We started with this one. We click here. Then it’s like, Okay, where does this come from?

638 01:02:48.870 ⇒ 01:02:51.730 Caio Velasco: Me? I have to find total sales somewhere.

639 01:02:52.050 ⇒ 01:02:53.729 Caio Velasco: Then we go to the repo.

640 01:02:55.010 ⇒ 01:02:59.129 Caio Velasco: and maybe that I will do this total sales.

641 01:03:04.560 ⇒ 01:03:06.770 Caio Velasco: even like this is not easy.

642 01:03:09.870 ⇒ 01:03:13.389 Caio Velasco: I would have to go to the real dashboard. Okay.

643 01:03:15.210 ⇒ 01:03:16.270 Luke Daque: Yeah.

644 01:03:16.480 ⇒ 01:03:20.170 Caio Velasco: The new dashboards.

645 01:03:21.150 ⇒ 01:03:25.709 Caio Velasco: But even though I don’t know where would they come from, I wouldn’t know what to choose from here.

646 01:03:31.770 ⇒ 01:03:34.540 Caio Velasco: Total. Okay, I would assume, but still

647 01:03:34.770 ⇒ 01:03:37.650 Caio Velasco: it has to be a doable work.

648 01:03:38.560 ⇒ 01:03:41.510 Luke Daque: Yeah, it’s it’s gonna take a while like.

649 01:03:41.700 ⇒ 01:03:45.019 Luke Daque: even just for the Daily Kpi dashboard.

650 01:03:45.780 ⇒ 01:03:49.090 Luke Daque: If you look at the all order like

651 01:03:49.450 ⇒ 01:03:57.939 Luke Daque: we were looking at. It was referencing the all orders. So if we look at that, all orders model if you scroll up. No, not that one.

652 01:03:58.370 ⇒ 01:04:02.540 Luke Daque: The Dbt model, it’s done.

653 01:04:02.540 ⇒ 01:04:03.110 Caio Velasco: Okay.

654 01:04:03.670 ⇒ 01:04:10.279 Luke Daque: The Dbt model. So if you scroll up, go to Dbt. Project and then models, and then march.

655 01:04:10.830 ⇒ 01:04:22.070 Luke Daque: and then where is order, I guess, reporting all orders. Yeah.

656 01:04:23.050 ⇒ 01:04:30.850 Luke Daque: cause that’s where it’s coming from. So it’s the all orders is even coming from shopify. And if you scroll down.

657 01:04:31.490 ⇒ 01:04:37.780 Luke Daque: there’s also Amazon that this is, that’s the shopify. And then there’s also Amazon.

658 01:04:38.250 ⇒ 01:04:40.110 Luke Daque: And there’s also Walmart.

659 01:04:40.610 ⇒ 01:04:45.639 Luke Daque: So there’s actually 3 sources for all orders.

660 01:04:46.860 ⇒ 01:04:47.750 Luke Daque: Right?

661 01:04:48.080 ⇒ 01:04:49.540 Caio Velasco: Okay. Yes.

662 01:04:49.910 ⇒ 01:04:54.630 Luke Daque: And then and then there’s also, like zip codes as well, mapping.

663 01:04:56.890 ⇒ 01:04:57.820 Caio Velasco: Whoa!

664 01:04:57.820 ⇒ 01:05:04.479 Luke Daque: So yeah, it’s gonna it’s gonna take a while. If we need to add the exact sources

665 01:05:05.150 ⇒ 01:05:07.769 Luke Daque: for that specific measure.

666 01:05:10.410 ⇒ 01:05:12.123 Caio Velasco: Oh, okay.

667 01:05:16.320 ⇒ 01:05:20.750 Caio Velasco: so let me think.

668 01:05:25.030 ⇒ 01:05:32.269 Caio Velasco: I’m thinking, if the rep the repo mix here would have access to literally everything in this repo.

669 01:05:34.770 ⇒ 01:05:35.610 Luke Daque: Yeah.

670 01:05:36.780 ⇒ 01:05:38.100 Caio Velasco: But still

671 01:05:38.700 ⇒ 01:05:44.380 Caio Velasco: I don’t even know how to ask that to check, but I don’t know if it would fit. In the in the

672 01:05:44.860 ⇒ 01:05:46.129 Caio Velasco: the the screen.

673 01:05:48.060 ⇒ 01:05:52.739 Luke Daque: Yeah, it’s it’s going to be very manual. I I don’t think.

674 01:05:54.080 ⇒ 01:06:04.619 Caio Velasco: Okay, okay? And also so but one thing that is also important, like.

675 01:06:04.910 ⇒ 01:06:08.350 Caio Velasco: we tried that we, we were trying to do this one here.

676 01:06:08.610 ⇒ 01:06:17.460 Caio Velasco: And then we well, just to go just to find the data source we saw already. Like, it’s a lot of things. If if we really want like total lineage.

677 01:06:18.030 ⇒ 01:06:23.850 Caio Velasco: You’d like, even though we just saw, like Walmart, shopify Amazon, etc, and maybe others.

678 01:06:25.320 ⇒ 01:06:27.350 Caio Velasco: Okay, this is doable. But

679 01:06:28.060 ⇒ 01:06:30.679 Caio Velasco: if let’s say that we complete this

680 01:06:30.860 ⇒ 01:06:35.319 Caio Velasco: after we complete this, we really don’t need anything else

681 01:06:35.440 ⇒ 01:06:40.029 Caio Velasco: to to answer this question, of which metrics are pointing to

682 01:06:42.800 ⇒ 01:06:45.020 Caio Velasco: let me see if I can rephrase this.

683 01:06:49.340 ⇒ 01:06:55.229 Caio Velasco: But then let’s say that you change. Well, that’s the problem as well. If you change something, then it’s

684 01:06:55.860 ⇒ 01:06:57.860 Caio Velasco: so. We had like a right.

685 01:06:58.000 ⇒ 01:06:59.910 Caio Velasco: It’s also complicated. But

686 01:07:04.340 ⇒ 01:07:05.020 Caio Velasco: hmm!

687 01:07:09.630 ⇒ 01:07:14.770 Caio Velasco: That’s why, somehow, even though I know that the work starts from anywhere.

688 01:07:14.930 ⇒ 01:07:20.299 Caio Velasco: If we had this frame before working with the client.

689 01:07:20.590 ⇒ 01:07:26.630 Caio Velasco: Then, when someone like you were was like, Okay, I’m building total sales. You would already

690 01:07:27.530 ⇒ 01:07:29.860 Caio Velasco: do this when you’re when you’re doing that.

691 01:07:30.290 ⇒ 01:07:34.980 Luke Daque: Yeah, it would like guide you to like, know exactly what are the sources and.

692 01:07:35.770 ⇒ 01:07:39.390 Caio Velasco: And then, yeah, they would be even easy to.

693 01:07:39.640 ⇒ 01:07:45.709 Caio Velasco: And then maybe the Dbt project would be mimicking the same structure. You would see here.

694 01:07:47.220 ⇒ 01:07:47.630 Caio Velasco: Alright.

695 01:07:47.630 ⇒ 01:07:49.700 Luke Daque: It would actually be

696 01:07:49.870 ⇒ 01:07:57.200 Luke Daque: to be honest. It would be great if we are. We were using like Dbt cloud, because Dbt cloud has a semantic layer.

697 01:07:59.100 ⇒ 01:08:06.350 Luke Daque: Where we can add all those descriptions for the what do you call this?

698 01:08:07.130 ⇒ 01:08:11.550 Luke Daque: Where the Me measures the dimensions and stuff like that?

699 01:08:12.630 ⇒ 01:08:13.400 Luke Daque: But.

700 01:08:13.740 ⇒ 01:08:14.569 Caio Velasco: Yeah. No. Please.

701 01:08:14.570 ⇒ 01:08:15.200 Luke Daque: So.

702 01:08:16.430 ⇒ 01:08:19.990 Caio Velasco: Sorry. So this come from March in Dvt. Right.

703 01:08:20.220 ⇒ 01:08:20.970 Luke Daque: Right.

704 01:08:21.540 ⇒ 01:08:25.530 Caio Velasco: So we have the we can do like a doc generate, and

705 01:08:26.609 ⇒ 01:08:29.969 Caio Velasco: and the lineage will be there for this table.

706 01:08:30.990 ⇒ 01:08:32.369 Luke Daque: Yeah, it should be, yeah.

707 01:08:33.090 ⇒ 01:08:36.409 Caio Velasco: So then we would have all the sources for total sales.

708 01:08:37.080 ⇒ 01:08:40.959 Luke Daque: Yeah, I can probably even show it to you. Now.

709 01:08:41.460 ⇒ 01:08:44.459 Caio Velasco: Okay, at least that would have been super helpful.

710 01:08:45.609 ⇒ 01:08:50.490 Caio Velasco: They wouldn’t just have to along the rep.

711 01:08:50.490 ⇒ 01:08:52.300 Caio Velasco: Let me share my screen.

712 01:08:52.990 ⇒ 01:08:54.219 Luke Daque: So you can

713 01:08:58.300 ⇒ 01:09:00.130 Luke Daque: see it. Can you see my screen.

714 01:09:00.870 ⇒ 01:09:01.460 Caio Velasco: Yes.

715 01:09:02.200 ⇒ 01:09:04.590 Luke Daque: So this is what it looks like.

716 01:09:05.140 ⇒ 01:09:07.989 Luke Daque: So this is the daily kpi aggregate.

717 01:09:09.939 ⇒ 01:09:11.019 Luke Daque: Like it.

718 01:09:11.659 ⇒ 01:09:17.859 Luke Daque: There’s like 3 major other March models that we are using. So all orders.

719 01:09:17.979 ⇒ 01:09:23.659 Luke Daque: all orders has Amazon orders, shopify orders and Walmart orders.

720 01:09:23.929 ⇒ 01:09:28.939 Luke Daque: and this even has like for Amazon orders. This is coming from

721 01:09:29.149 ⇒ 01:09:34.179 Luke Daque: Amazon order lines, financial service events, stuff like that.

722 01:09:35.039 ⇒ 01:09:38.249 Caio Velasco: And then like shopify. Has this so.

723 01:09:38.619 ⇒ 01:09:41.859 Luke Daque: Yeah, there’s there’s a lot you can see here.

724 01:09:41.859 ⇒ 01:09:42.529 Caio Velasco: Okay.

725 01:09:43.679 ⇒ 01:09:54.629 Caio Velasco: okay. But then we don’t have. We have until March. But if real is built on top of March we don’t have the mapping from March to Real.

726 01:09:54.979 ⇒ 01:09:57.749 Caio Velasco: That’s exactly what we are trying to do with the spreadsheet.

727 01:09:58.480 ⇒ 01:09:59.789 Luke Daque: I see. Okay.

728 01:09:59.790 ⇒ 01:10:06.520 Caio Velasco: Right. So it does make sense that we are doing their work because there’s just no nothing mapping.

729 01:10:06.980 ⇒ 01:10:18.590 Luke Daque: I mean, we can always add exposure. I’m not sure if DVD. Core has exposures, let me that way

730 01:10:20.250 ⇒ 01:10:22.266 Luke Daque: that way. We can.

731 01:10:23.560 ⇒ 01:10:31.240 Luke Daque: It should show in the docs generate something like this. So this would be the March models in Dbt. And then

732 01:10:31.340 ⇒ 01:10:34.910 Luke Daque: it has a lineage to the exposure.

733 01:10:35.390 ⇒ 01:10:39.980 Luke Daque: Exposures would are definitely are basically

734 01:10:40.270 ⇒ 01:10:47.440 Luke Daque: like the reports or the dashboards that it’s being used. So maybe we can utilize that we can. We can check.

735 01:10:49.040 ⇒ 01:10:52.470 Luke Daque: Yes, maybe it is.

736 01:10:52.470 ⇒ 01:10:55.790 Caio Velasco: Nice. Yes, that that’s exactly what we’re doing.

737 01:10:56.850 ⇒ 01:11:02.199 Luke Daque: I can send you this. So maybe you can read this out and see this is something that we can

738 01:11:03.500 ⇒ 01:11:04.540 Luke Daque: dry.

739 01:11:04.950 ⇒ 01:11:11.920 Luke Daque: The only I’m the only thing that I’m not sure of is if this works for Dbt core.

740 01:11:16.000 ⇒ 01:11:23.199 Luke Daque: maybe it’s it’s not that video. But I can. Maybe. Yeah, we can try.

741 01:11:26.940 ⇒ 01:11:31.700 Luke Daque: See it? Yeah, you can see it depends. Like exposure, for example, would be the

742 01:11:31.980 ⇒ 01:11:38.279 Luke Daque: Daily Kpi dashboard for this case, which is the real dashboard.

743 01:11:38.800 ⇒ 01:11:43.700 Luke Daque: And then, yeah, it’s the type would be dashboard, and the URL would be there.

744 01:11:43.960 ⇒ 01:11:46.259 Luke Daque: or the actual dashboard. And then

745 01:11:46.380 ⇒ 01:11:57.590 Luke Daque: it would depend on. In this case these 3. It will depend on all orders. I mean, it will depend on this daily Kpi. It’s only one.

746 01:11:58.310 ⇒ 01:12:02.770 Caio Velasco: So. But we have to build this declared or.

747 01:12:02.770 ⇒ 01:12:09.709 Luke Daque: Yeah, let can we? Maybe let me try and see if this works? If I add an exposure here.

748 01:12:14.460 ⇒ 01:12:15.059 Luke Daque: Just so you.

749 01:12:15.060 ⇒ 01:12:18.889 Caio Velasco: Yeah. It says here that it it works with the ut core.

750 01:12:20.110 ⇒ 01:12:22.330 Luke Daque: Got this like Hudd rings.

751 01:12:28.080 ⇒ 01:12:31.950 Caio Velasco: Yeah. When you do. Dbt, Doc, serve you will.

752 01:12:32.050 ⇒ 01:12:36.399 Caio Velasco: You will get the yaml file. This is a yaml file that you.

753 01:12:36.860 ⇒ 01:12:38.540 Luke Daque: It should generate right.

754 01:12:38.850 ⇒ 01:12:39.440 Caio Velasco: Yeah.

755 01:12:53.460 ⇒ 01:12:55.629 Luke Daque: Let me see if it works really quick.

756 01:12:56.420 ⇒ 01:12:58.949 Caio Velasco: Yeah, let’s just test this. And then.

757 01:12:59.220 ⇒ 01:13:05.650 Luke Daque: It would be referencing the daily meeting.

758 01:13:15.150 ⇒ 01:13:17.219 Luke Daque: Let’s see, and then.

759 01:13:18.580 ⇒ 01:13:20.920 Caio Velasco: And if this works we’re done.

760 01:13:22.050 ⇒ 01:13:23.080 Luke Daque: Michael Smith.

761 01:13:25.440 ⇒ 01:13:26.279 Luke Daque: There it is.

762 01:13:27.570 ⇒ 01:13:30.480 Luke Daque: And what did? What was that? DVD, Doc. Sir.

763 01:13:31.170 ⇒ 01:13:31.860 Caio Velasco: Yes.

764 01:13:33.390 ⇒ 01:13:34.079 Luke Daque: It’s my group.

765 01:13:50.565 ⇒ 01:13:52.694 Caio Velasco: You wanna do. Only for okay,

766 01:13:53.820 ⇒ 01:13:59.819 Caio Velasco: I mean, I mean, I can ask you like we are trying to. Reference was.

767 01:14:03.610 ⇒ 01:14:07.240 Luke Daque: Or it needs to be RAM.

768 01:14:07.880 ⇒ 01:14:08.680 Luke Daque: Yes.

769 01:14:12.220 ⇒ 01:14:13.120 Luke Daque: okay.

770 01:14:15.130 ⇒ 01:14:24.870 Luke Daque: And then, is it going to be the real dashboards this week?

771 01:14:43.660 ⇒ 01:14:44.430 Caio Velasco: But what?

772 01:14:45.110 ⇒ 01:14:46.110 Caio Velasco: Okay.

773 01:14:46.450 ⇒ 01:14:49.670 Luke Daque: It doesn’t seem to be working.

774 01:14:49.990 ⇒ 01:15:00.320 Caio Velasco: Yeah, you. What it says is that you do a Dbt docs generate with a select or a model you want, and then you do the Dbt. Doc, sir, by itself.

775 01:15:08.220 ⇒ 01:15:09.010 Luke Daque: Like that.

776 01:15:14.570 ⇒ 01:15:17.259 Caio Velasco: Then, yeah, I think when you serve, we’ll just.

777 01:15:19.050 ⇒ 01:15:21.440 Luke Daque: And then docs generate after it’s done.

778 01:15:22.220 ⇒ 01:15:24.419 Caio Velasco: And then digital Doc, search.

779 01:15:30.420 ⇒ 01:15:32.610 Luke Daque: Still loading it. Let’s see

780 01:15:44.350 ⇒ 01:15:49.309 Luke Daque: where is wait! What

781 01:16:02.830 ⇒ 01:16:04.359 Luke Daque: onward midway.

782 01:16:05.740 ⇒ 01:16:07.659 Caio Velasco: What are we trying to find.

783 01:16:17.780 ⇒ 01:16:19.320 Luke Daque: Where’s the leaves?

784 01:16:20.790 ⇒ 01:16:21.890 Caio Velasco: Oh, yeah, let me check.

785 01:16:33.130 ⇒ 01:16:34.760 Luke Daque: Doesn’t show the language.

786 01:16:36.200 ⇒ 01:16:40.319 Caio Velasco: Yeah, I just asked you to see how to get the leverage.

787 01:16:42.200 ⇒ 01:16:43.140 Luke Daque: I need this.

788 01:16:43.140 ⇒ 01:16:46.620 Caio Velasco: Where did you see? How did you see that that lineage again?

789 01:16:46.910 ⇒ 01:16:47.680 Caio Velasco: Forget.

790 01:16:47.680 ⇒ 01:16:49.859 Luke Daque: Here, here it is. Looks like

791 01:16:53.190 ⇒ 01:16:55.389 Luke Daque: this is the rename shape. Looks like.

792 01:16:59.120 ⇒ 01:17:02.649 Luke Daque: but it’s not showing the exposure right? So maybe

793 01:17:06.280 ⇒ 01:17:07.520 Luke Daque: this is here.

794 01:17:09.650 ⇒ 01:17:11.129 Luke Daque: Daily data

795 01:17:30.250 ⇒ 01:17:31.200 Luke Daque: annoying.

796 01:17:31.300 ⇒ 01:17:35.470 Luke Daque: It says, control C to exit. But it’s not basically.

797 01:17:36.530 ⇒ 01:17:38.960 Luke Daque: maybe let’s just keep the new camera.

798 01:18:06.950 ⇒ 01:18:08.179 Luke Daque: No, it doesn’t it?

799 01:18:18.880 ⇒ 01:18:22.060 Luke Daque: It said. Here it should work. If we do this.

800 01:18:31.040 ⇒ 01:18:34.859 Luke Daque: maybe we need to tag this that’s enabled.

801 01:18:42.160 ⇒ 01:18:44.459 Caio Velasco: Yeah, what is telling me here in

802 01:18:45.410 ⇒ 01:18:49.650 Caio Velasco: on Chat Gpt, that 1st you define this the exposure?

803 01:18:50.573 ⇒ 01:18:55.390 Caio Velasco: I just don’t know where you should put the file, but and.

804 01:18:56.960 ⇒ 01:19:02.740 Luke Daque: We, I added a folder here called Exposures, under DVD. Project.

805 01:19:04.580 ⇒ 01:19:05.479 Caio Velasco: Let me see if it comes.

806 01:19:15.470 ⇒ 01:19:20.610 Luke Daque: Let’s finish right daily daily.

807 01:19:20.780 ⇒ 01:19:24.399 Caio Velasco: Didn’t any says any place within the models file.

808 01:19:30.020 ⇒ 01:19:34.800 Luke Daque: Let’s try moving this to you.

809 01:19:37.540 ⇒ 01:19:38.815 Caio Velasco: Yes, could be.

810 01:19:48.170 ⇒ 01:19:49.120 Luke Daque: Oh, there you go!

811 01:19:49.660 ⇒ 01:19:50.890 Caio Velasco: Okay.

812 01:19:52.230 ⇒ 01:19:53.820 Luke Daque: Where is joining everything?

813 01:20:01.100 ⇒ 01:20:08.110 Luke Daque: Maybe it needs to run all the upstream modules for the Daily Kpi

814 01:20:11.310 ⇒ 01:20:12.520 Luke Daque: before it works.

815 01:20:14.600 ⇒ 01:20:16.010 Luke Daque: So now that it’s

816 01:20:19.460 ⇒ 01:20:20.530 Luke Daque: good morning.

817 01:20:24.350 ⇒ 01:20:25.540 Luke Daque: How do we show it?

818 01:20:43.690 ⇒ 01:20:50.890 Caio Velasco: The U. Okay, the URL for the real dashboard depends on right orders.

819 01:20:51.800 ⇒ 01:20:56.060 Luke Daque: Yeah, this should be, I guess, the correct email.

820 01:20:59.460 ⇒ 01:21:04.190 Caio Velasco: Yeah, the Dbt docs generate. Dbt, Doc, sir? Yeah, it should be that easy.

821 01:21:15.840 ⇒ 01:21:20.580 Caio Velasco: Yeah. Because I think the DVD docs generate is, what’s gonna use the exposure.

822 01:21:21.800 ⇒ 01:21:25.389 Luke Daque: So we do. DVD. Docs generate first.st

823 01:21:26.680 ⇒ 01:21:32.980 Caio Velasco: Yes, is it? It will update the manifest, Jason, and then you lose it.

824 01:21:34.270 ⇒ 01:21:37.719 Caio Velasco: Yeah, if you look so, that’s what it’s saying here. But let’s see.

825 01:21:51.930 ⇒ 01:21:54.140 Luke Daque: Okay, this is what it’s shown.

826 01:21:54.690 ⇒ 01:22:00.580 Luke Daque: So if you go back and go to Kpi, who is that?

827 01:22:01.330 ⇒ 01:22:06.780 Luke Daque: Who would like to go? Modes Kpi daily. Kpi ag

828 01:22:07.420 ⇒ 01:22:09.439 Luke Daque: the lineage. Oh, there you go!

829 01:22:09.950 ⇒ 01:22:14.659 Luke Daque: It’s showing that it we need to. Now go into the dashboard.

830 01:22:15.820 ⇒ 01:22:16.930 Caio Velasco: That’s awesome.

831 01:22:17.600 ⇒ 01:22:18.700 Caio Velasco: Nice.

832 01:22:20.280 ⇒ 01:22:23.080 Luke Daque: Yes, I guess we can do it like that.

833 01:22:25.980 ⇒ 01:22:30.750 Caio Velasco: And is it okay? Go to the dashboard. Let me check if

834 01:22:33.130 ⇒ 01:22:39.930 Caio Velasco: and the metrics were defined in a yaml file within the real dashboard folder.

835 01:22:42.300 ⇒ 01:22:43.130 Luke Daque: What does that.

836 01:22:44.120 ⇒ 01:22:50.310 Caio Velasco: Because within the where were the, for example, the total sales metric? Where was it? Defined?

837 01:22:50.660 ⇒ 01:22:53.130 Caio Velasco: The Nyaml file as well. Right.

838 01:22:54.350 ⇒ 01:22:55.320 Luke Daque: Yeah.

839 01:22:55.540 ⇒ 01:23:00.000 Luke Daque: So I guess we should be able to see then here.

840 01:23:02.110 ⇒ 01:23:06.060 Luke Daque: But we should have. We should have some descriptions for you

841 01:23:06.370 ⇒ 01:23:10.649 Luke Daque: if we defined it correctly, but I guess maybe we did not.

842 01:23:12.690 ⇒ 01:23:19.860 Luke Daque: Yeah, we need not put any description. So if we put some description here, then

843 01:23:20.650 ⇒ 01:23:24.859 Luke Daque: it should show up here like this one or date, because we

844 01:23:25.300 ⇒ 01:23:30.139 Luke Daque: for sure, I think we added that description, for there, yeah.

845 01:23:33.090 ⇒ 01:23:36.170 Luke Daque: So if you add a description, for example, the

846 01:23:38.160 ⇒ 01:23:41.320 Luke Daque: like, the measure of total cogs. For example.

847 01:23:41.780 ⇒ 01:23:49.370 Luke Daque: if you add a total orders right here, the number are very, very supportive, or you’re good.

848 01:23:49.680 ⇒ 01:23:52.449 Luke Daque: Something like that. This should also show up.

849 01:23:52.800 ⇒ 01:23:58.900 Luke Daque: Yeah, in the description which could be our semantic layer right.

850 01:24:03.050 ⇒ 01:24:04.750 Caio Velasco: Yeah, I think so.

851 01:24:09.580 ⇒ 01:24:13.549 Caio Velasco: Okay, but they have. We okay? So so far have we solved the

852 01:24:15.620 ⇒ 01:24:18.549 Caio Velasco: finding the sources for the total sales.

853 01:24:18.720 ⇒ 01:24:19.700 Caio Velasco: For example.

854 01:24:24.490 ⇒ 01:24:25.230 Luke Daque: No.

855 01:24:25.850 ⇒ 01:24:29.500 Caio Velasco: By adding this exposure helped us

856 01:24:29.600 ⇒ 01:24:35.730 Caio Velasco: know which dashboards, pointing to that specific model.

857 01:24:36.280 ⇒ 01:24:36.800 Luke Daque: Yeah.

858 01:24:36.800 ⇒ 01:24:38.026 Caio Velasco: Smart model

859 01:24:40.330 ⇒ 01:24:43.399 Caio Velasco: And from that dashboard we would

860 01:24:44.140 ⇒ 01:24:49.759 Caio Velasco: need another exposure. Let’s say that would point to metrics more or less.

861 01:24:50.070 ⇒ 01:24:51.710 Caio Velasco: That will be like the dream.

862 01:24:53.970 ⇒ 01:24:54.860 Luke Daque: Yeah.

863 01:25:04.770 ⇒ 01:25:05.730 Luke Daque: Where is he?

864 01:25:22.320 ⇒ 01:25:27.439 Caio Velasco: Dash in the measures. Okay.

865 01:26:08.890 ⇒ 01:26:12.800 Caio Velasco: one question. We only could do this exposure because we are using real.

866 01:26:13.490 ⇒ 01:26:17.229 Caio Velasco: since really it’s a folder in the repo.

867 01:26:19.710 ⇒ 01:26:26.389 Luke Daque: We can use it, even if we’re not using real like, it’s just like exposing whatever the marks model is.

868 01:26:26.570 ⇒ 01:26:31.810 Luke Daque: So we we will be able to know what reports are or dashboards are using.

869 01:26:32.620 ⇒ 01:26:35.850 Caio Velasco: I guess, because we brilliant to the exposure. Yeah.

870 01:26:35.850 ⇒ 01:26:36.699 Luke Daque: Yeah, even.

871 01:26:36.700 ⇒ 01:26:39.410 Caio Velasco: We could name this like Brainfort, whatever.

872 01:26:39.910 ⇒ 01:26:43.569 Luke Daque: Yeah, okay, do whatever you want.

873 01:26:44.110 ⇒ 01:26:45.580 Caio Velasco: Okay, it can be.

874 01:26:46.040 ⇒ 01:26:51.540 Luke Daque: It doesn’t have to be a dashboard or like it doesn’t have to be real. It can be any dashboard, for example.

875 01:26:51.640 ⇒ 01:26:54.419 Luke Daque: like tableau or looker, or whatever

876 01:26:55.820 ⇒ 01:27:03.670 Luke Daque: or it can also be something else, like where the data is being exposed to, maybe to a ui or something

877 01:27:04.570 ⇒ 01:27:05.510 Luke Daque: we are.

878 01:27:07.080 ⇒ 01:27:12.709 Luke Daque: But yeah, I think I think for the columns.

879 01:27:19.370 ⇒ 01:27:20.939 Luke Daque: I think we’ll have to do it.

880 01:27:22.070 ⇒ 01:27:24.099 Caio Velasco: So it’s saying here that you can.

881 01:27:25.095 ⇒ 01:27:29.850 Caio Velasco: For example, let let’s try this. I will share this in the chat.

882 01:27:30.580 ⇒ 01:27:31.530 Caio Velasco: Okay.

883 01:27:35.050 ⇒ 01:27:38.400 Caio Velasco: so in the depend on.

884 01:27:38.560 ⇒ 01:27:39.680 Luke Daque: Depends on.

885 01:27:40.510 ⇒ 01:27:41.880 Caio Velasco: Think you would have to.

886 01:27:42.280 ⇒ 01:27:43.880 Caio Velasco: But let me think that this is

887 01:27:44.790 ⇒ 01:27:48.470 Caio Velasco: names you’re now, because now we are exposing

888 01:27:49.670 ⇒ 01:27:55.980 Caio Velasco: and dashboard a dashboard. I think we’re just adding an the

889 01:27:57.230 ⇒ 01:28:07.100 Caio Velasco: the metric over there. It’s because they are using an old style to define a metric. But we defined in the email. You showed me that the total where the total sales is defined.

890 01:28:07.670 ⇒ 01:28:08.330 Luke Daque: Yeah.

891 01:28:18.170 ⇒ 01:28:20.540 Luke Daque: So I guess we can also define

892 01:28:26.120 ⇒ 01:28:27.789 Luke Daque: a metric there.

893 01:28:29.070 ⇒ 01:28:30.030 Caio Velasco: Yes.

894 01:28:33.050 ⇒ 01:28:34.400 Luke Daque: So, instead of

895 01:28:38.620 ⇒ 01:28:39.820 Luke Daque: a reference.

896 01:28:39.820 ⇒ 01:28:45.740 Caio Velasco: Maybe we can. I don’t know if we can have both, or we would have create another one, or just.

897 01:28:46.560 ⇒ 01:28:48.610 Luke Daque: Yeah, that’s a good question.

898 01:28:48.610 ⇒ 01:28:54.459 Caio Velasco: Because it would be nice to also have the name of the dashboard as an exposure. And then, after the metric.

899 01:28:55.690 ⇒ 01:28:58.899 Caio Velasco: Yes, exactly. That would be, for example.

900 01:28:59.220 ⇒ 01:29:02.499 Caio Velasco: So maybe yes, maybe you can add the metric as well.

901 01:29:02.680 ⇒ 01:29:10.440 Caio Velasco: but not with the metric name would be measure. I think you defined as a measure, and

902 01:29:11.100 ⇒ 01:29:15.739 Caio Velasco: in the repo we’ll give you the record.

903 01:29:16.430 ⇒ 01:29:18.969 Luke Daque: What is metric, though I haven’t

904 01:29:23.140 ⇒ 01:29:23.940 Luke Daque: would be.

905 01:29:31.480 ⇒ 01:29:33.939 Luke Daque: Yeah. It’s part of the semantic model.

906 01:29:34.160 ⇒ 01:29:42.790 Luke Daque: So I think we need to set up semantic model semantic layer to define our metrics

907 01:29:43.560 ⇒ 01:29:49.769 Luke Daque: like this is what the semantic layer is for, because it should.

908 01:29:49.920 ⇒ 01:29:57.660 Luke Daque: Yeah, it let’s see defining business metrics like revenue, or in our case, total sales, for example.

909 01:29:58.170 ⇒ 01:30:02.619 Luke Daque: in the DVD project. So maybe this is also something we need to

910 01:30:03.330 ⇒ 01:30:08.129 Luke Daque: look into. We haven’t been using which we can use.

911 01:30:09.080 ⇒ 01:30:14.510 Luke Daque: See? If we can, we can define metrics here.

912 01:30:15.660 ⇒ 01:30:21.300 Luke Daque: and then we can expose it in the and the exposures.

913 01:30:23.530 ⇒ 01:30:27.339 Luke Daque: And it, yeah, something like that.

914 01:30:28.490 ⇒ 01:30:35.060 Luke Daque: But yeah, we’ll have to. I’ll have to read through this and see how we can.

915 01:30:38.730 ⇒ 01:30:40.640 Luke Daque: how you can use it. Basically.

916 01:30:44.950 ⇒ 01:30:47.280 Caio Velasco: Just one second to try something.

917 01:30:51.250 ⇒ 01:30:52.340 Luke Daque: One step.

918 01:31:01.310 ⇒ 01:31:02.170 Luke Daque: Hmm.

919 01:31:25.050 ⇒ 01:31:31.130 Luke Daque: yeah, we need to do it something like this. We need another Yaml file for all the metrics.

920 01:31:32.160 ⇒ 01:31:32.950 Luke Daque: Right?

921 01:31:34.010 ⇒ 01:31:39.710 Luke Daque: So we would have something like this, metrics, and then total sales

922 01:31:39.840 ⇒ 01:31:45.010 Luke Daque: what the description of Delta sales is, and then

923 01:31:48.480 ⇒ 01:31:50.619 Luke Daque: I guess this will be the logic

924 01:32:06.250 ⇒ 01:32:07.390 Luke Daque: interesting.

925 01:32:18.110 ⇒ 01:32:21.340 Caio Velasco: Yeah, it’s it’s saying here that we would need to

926 01:32:22.120 ⇒ 01:32:27.460 Caio Velasco: exposures in the same file. You would just add the metric

927 01:32:30.620 ⇒ 01:32:31.510 Caio Velasco: weird.

928 01:32:36.110 ⇒ 01:32:38.670 Caio Velasco: I’m not sure this, if this would work now, but.

929 01:32:39.800 ⇒ 01:32:45.090 Luke Daque: Yeah, but it’s something that we can probably. Oh, that you sent you said something.

930 01:32:46.410 ⇒ 01:32:55.180 Caio Velasco: Yeah, could I ask strategy, like, I have this dashboard where there is the total sale. But I want to expose both the dashboard and the

931 01:32:55.840 ⇒ 01:32:56.489 Caio Velasco: and it may.

932 01:32:56.490 ⇒ 01:32:57.449 Luke Daque: And the next 2.

933 01:32:58.940 ⇒ 01:33:03.060 Caio Velasco: Okay, but I’m not sure if they will be connected.

934 01:33:06.810 ⇒ 01:33:09.500 Luke Daque: Let’s try. Let me try adding this second.

935 01:33:09.500 ⇒ 01:33:15.179 Caio Velasco: Because you were referenced. Yeah, the metric is referencing. The reference that you referenced above.

936 01:33:16.150 ⇒ 01:33:19.949 Luke Daque: So it’s probably something like this. Can you still see my screen? By the way.

937 01:33:20.410 ⇒ 01:33:21.130 Caio Velasco: Yes.

938 01:33:22.330 ⇒ 01:33:24.260 Luke Daque: So I’ll do something like this.

939 01:33:27.960 ⇒ 01:33:31.310 Caio Velasco: And then you would put the Daily Kpi down there.

940 01:33:37.590 ⇒ 01:33:40.689 Luke Daque: And it will be some of item sales price.

941 01:33:44.840 ⇒ 01:33:46.980 Luke Daque: Let’s try to do it again.

942 01:33:51.390 ⇒ 01:33:57.020 Luke Daque: So 1st we need to do, we need to expose it together.

943 01:33:57.610 ⇒ 01:34:00.400 Caio Velasco: I don’t think we need to run those dbt run.

944 01:34:01.680 ⇒ 01:34:02.279 Caio Velasco: I mean, I don’t.

945 01:34:02.280 ⇒ 01:34:05.489 Luke Daque: So this is just Docs. Generate. Let me see.

946 01:34:06.800 ⇒ 01:34:09.910 Luke Daque: this docs generate, and then they need to serve.

947 01:34:10.350 ⇒ 01:34:11.200 Caio Velasco: Yes.

948 01:34:24.190 ⇒ 01:34:31.739 Caio Velasco: I mean, the only reason why this would be nice now is because we could finish the the spreadsheet quick way quickly.

949 01:34:32.180 ⇒ 01:34:39.309 Caio Velasco: and then we can think if the semantic layer it’s more interesting or doing like this is, it’s already okay.

950 01:34:39.830 ⇒ 01:34:43.050 Luke Daque: Yeah. Or and maybe this would even

951 01:34:44.210 ⇒ 01:34:47.889 Luke Daque: like, if we can do this and like, serve this every time

952 01:34:49.120 ⇒ 01:34:53.800 Luke Daque: the P. The the Github action runs, and then we have.

953 01:34:53.800 ⇒ 01:34:54.960 Caio Velasco: Yeah, we don’t need even to.

954 01:34:54.960 ⇒ 01:34:55.380 Luke Daque: They don’t.

955 01:34:55.380 ⇒ 01:34:56.190 Caio Velasco: Spreadsheet.

956 01:34:56.190 ⇒ 01:34:57.530 Luke Daque: Yeah, exactly.

957 01:34:57.710 ⇒ 01:34:59.179 Caio Velasco: Exactly, no perfect.

958 01:35:05.960 ⇒ 01:35:07.890 Luke Daque: Oh, yeah, there you go. It’s showing.

959 01:35:08.870 ⇒ 01:35:10.960 Luke Daque: So let me just put one here.

960 01:35:12.040 ⇒ 01:35:13.010 Luke Daque: There you go.

961 01:35:13.190 ⇒ 01:35:14.320 Luke Daque: There’s my trick.

962 01:35:15.110 ⇒ 01:35:20.238 Caio Velasco: The metric comes with. But that’s the interesting thing. This metric came from the dashboard. Right? So

963 01:35:21.550 ⇒ 01:35:29.050 Caio Velasco: because we are referencing dedicated pi aggregate. Okay, but we don’t know that the total sales it’s within that dashboard.

964 01:35:29.960 ⇒ 01:35:33.640 Luke Daque: Would we be able to see it here?

965 01:35:35.600 ⇒ 01:35:39.250 Luke Daque: Tell me more than or mute it?

966 01:35:50.790 ⇒ 01:35:56.189 Luke Daque: Yeah, we we can see, I guess. See it here, like, if we go to

967 01:35:57.651 ⇒ 01:36:06.359 Luke Daque: exposure referenced by exposures, and then the metric and be able to see the definition of the vector.

968 01:36:12.460 ⇒ 01:36:12.760 Caio Velasco: Hmm.

969 01:36:16.220 ⇒ 01:36:16.800 Luke Daque: Prompted.

970 01:36:19.600 ⇒ 01:36:22.790 Luke Daque: Oh, yeah, and if you click that, it goes directly to

971 01:36:23.000 ⇒ 01:36:25.180 Luke Daque: the real dashboard, which is cool.

972 01:36:29.030 ⇒ 01:36:39.150 Caio Velasco: So Dp, so chatty, said, that you cannot expose something depending on another exposure.

973 01:36:40.692 ⇒ 01:36:44.190 Caio Velasco: But that’s it. Gives an workaround.

974 01:36:44.550 ⇒ 01:36:52.460 Luke Daque: I guess that’s because we are referencing it to a model, which is we? I mean, we’re depending it on reference.

975 01:36:52.900 ⇒ 01:36:56.020 Luke Daque: It should be like something like metric

976 01:36:56.280 ⇒ 01:37:04.239 Luke Daque: like that right, which is something we need also need to define in the semantic layer. Then, like total sales, will have to

977 01:37:04.410 ⇒ 01:37:09.559 Luke Daque: define in the semantic layer that way.

978 01:37:10.550 ⇒ 01:37:15.490 Luke Daque: It shows as an actual metric. Now I mean it get links.

979 01:37:17.740 ⇒ 01:37:20.760 Caio Velasco: Yes, to our metrics, not to our model.

980 01:37:22.600 ⇒ 01:37:25.790 Luke Daque: But yeah, I’m not very familiar with the semantic data yet.

981 01:37:25.990 ⇒ 01:37:32.439 Luke Daque: No. Dvds, but yeah, we can definitely make it something like this. So.

982 01:37:34.230 ⇒ 01:37:39.600 Caio Velasco: Okay and well given this new this what? This that I we found out

983 01:37:41.530 ⇒ 01:37:45.339 Caio Velasco: I would have to talk to a wish. But do do you have any opinion on

984 01:37:46.370 ⇒ 01:37:49.429 Caio Velasco: on losing so much time on the spreadsheet?

985 01:37:51.860 ⇒ 01:37:57.770 Luke Daque: I. Yeah, I think it’s not the best approach that currently that we have like

986 01:37:57.910 ⇒ 01:38:03.489 Luke Daque: using the spreadsheet as the I guess, as the semantic layer right?

987 01:38:03.630 ⇒ 01:38:07.040 Luke Daque: Just like that’s where we are defining

988 01:38:08.940 ⇒ 01:38:13.420 Luke Daque: the sources of the models and dashboards. And

989 01:38:14.480 ⇒ 01:38:20.540 Luke Daque: like, if there are any changes, we’ll have to change your page. So like, we’re already modifying

990 01:38:21.250 ⇒ 01:38:28.119 Luke Daque: sequel code, for example. And then we’ll we’ll have to modify this as well. If there’s any update that needs to be done.

991 01:38:28.530 ⇒ 01:38:36.979 Luke Daque: It’s like I think it’s it’s very time consuming, I would say, and prone to error.

992 01:38:38.450 ⇒ 01:38:39.009 Luke Daque: I don’t know.

993 01:38:39.010 ⇒ 01:38:44.449 Caio Velasco: Exactly. And yeah, I would have to talk to a wish about it.

994 01:38:47.210 ⇒ 01:38:51.329 Caio Velasco: Okay, okay, okay, cool. I think we had like a lot of good information already.

995 01:38:52.960 ⇒ 01:38:58.220 Caio Velasco: And I’ll talk to a wish and and see what he thinks.

996 01:38:58.850 ⇒ 01:38:59.380 Luke Daque: Yeah.

997 01:38:59.560 ⇒ 01:39:07.500 Caio Velasco: Maybe we could do, maybe doing this semantic layer. It’s already proficient.

998 01:39:10.100 ⇒ 01:39:17.320 Caio Velasco: and we could like just copy paste whatever we want there. I mean, I think there’s a there is a easier way.

999 01:39:17.789 ⇒ 01:39:25.139 Caio Velasco: cause I wouldn’t mind doing it. But now that I, just for total safe, took like no, I don’t even know how like

1000 01:39:25.300 ⇒ 01:39:29.049 Caio Velasco: half an hour, just just for one metric. And then we have like 50.

1001 01:39:29.280 ⇒ 01:39:30.560 Caio Velasco: Then, yeah, thank you.

1002 01:39:30.600 ⇒ 01:39:31.390 Caio Velasco: Yeah.

1003 01:39:31.510 ⇒ 01:39:37.119 Caio Velasco: Then you’re paying someone like $10,000 just to fill a spreadsheet. I don’t think you want that.

1004 01:39:38.480 ⇒ 01:39:39.220 Luke Daque: Yeah.

1005 01:39:42.120 ⇒ 01:39:48.140 Caio Velasco: Okay, okay, okay, cool look. I’ll talk to a wish, and then I’ll update you as well.

1006 01:39:50.580 ⇒ 01:39:52.000 Luke Daque: Cool sounds, good.

1007 01:39:52.280 ⇒ 01:39:52.900 Caio Velasco: Cool. Thanks.

1008 01:39:52.900 ⇒ 01:39:54.350 Caio Velasco: Thank you very much. I appreciate.

1009 01:39:54.750 ⇒ 01:39:56.100 Luke Daque: Have a nice day. Bye, bye.

1010 01:39:56.100 ⇒ 01:39:57.600 Caio Velasco: Nice David. Bye-bye.

1011 01:40:08.920 ⇒ 01:40:09.460 Luke Daque: Okay.