Meeting Title: US x BF | Standup Date: 2025-06-27 Meeting participants: Caio Velasco, Demilade Agboola, Amber Lin
WEBVTT
1 00:01:34.310 ⇒ 00:01:35.410 Caio Velasco: I didn’t you? Added.
2 00:01:46.890 ⇒ 00:01:48.080 Amber Lin: Hi! There!
3 00:01:49.130 ⇒ 00:01:49.539 Caio Velasco: Who.
4 00:01:52.652 ⇒ 00:01:56.990 Amber Lin: Emily is not joining today. She’s she’s off.
5 00:01:57.470 ⇒ 00:01:59.549 Amber Lin: Let me see.
6 00:02:00.840 ⇒ 00:02:07.319 Amber Lin: Oh, I saw that, Kyle. I saw that you put a comment on one of the
7 00:02:07.840 ⇒ 00:02:10.359 Amber Lin: on one of the tickets.
8 00:02:11.210 ⇒ 00:02:14.950 Amber Lin: I’ll share my screen, and he can quickly talk about them.
9 00:02:15.560 ⇒ 00:02:16.290 Caio Velasco: Okay.
10 00:02:26.270 ⇒ 00:02:27.230 Amber Lin: And
11 00:02:52.760 ⇒ 00:02:57.729 Amber Lin: alright which one was the is it? Was it this one that you had a comment on.
12 00:02:58.290 ⇒ 00:02:59.080 Caio Velasco: Yes.
13 00:03:01.270 ⇒ 00:03:03.390 Caio Velasco: So well.
14 00:03:04.020 ⇒ 00:03:11.150 Caio Velasco: I did both looker deprecation and redshift things, or at least we could call prep
15 00:03:11.310 ⇒ 00:03:15.449 Caio Velasco: prepping redshift tables also for future deprecation.
16 00:03:16.301 ⇒ 00:03:28.250 Caio Velasco: Because that was part of how we would connect the Dbt accuracy to the dashboard. We had to go through redshift tables to make the connection. So we have the redshift tables, all the
17 00:03:28.470 ⇒ 00:03:29.600 Caio Velasco: sheet.
18 00:03:30.510 ⇒ 00:03:40.770 Caio Velasco: and I noticed a few things today with David, for example, one of the columns that he did previously is not matching
19 00:03:40.980 ⇒ 00:03:51.600 Caio Velasco: this manifest Dot Json, which should contain everything regarding Dbt. And connection to the redshift tables. So then, this is something that I found out.
20 00:03:51.790 ⇒ 00:03:54.999 Caio Velasco: and so I have to take a look into that. And
21 00:03:56.020 ⇒ 00:04:02.350 Caio Velasco: also I remember that I asked you, Tom, a few things
22 00:04:02.950 ⇒ 00:04:05.140 Caio Velasco: of okay. Now that we have
23 00:04:05.640 ⇒ 00:04:16.310 Caio Velasco: a few columns, columns, flagging redshift tables. Each column could be interpreted, interpreted as a layer of deprecation.
24 00:04:16.510 ⇒ 00:04:27.119 Caio Velasco: We just have to be to make sure that we follow layer by layer. And we start to do this turning off the tables according to those decisions.
25 00:04:27.540 ⇒ 00:04:33.289 Caio Velasco: So I mean, this would still need a bit of like a day or 2 to really arrive at the final
26 00:04:33.580 ⇒ 00:04:40.019 Caio Velasco: point until it start deprecating layer by layer to avoid problems.
27 00:04:40.020 ⇒ 00:04:47.515 Amber Lin: Oh, I see, I see I made this ticket because I thought we’ve already turned off registered tables. So
28 00:04:47.890 ⇒ 00:04:48.429 Caio Velasco: So yes.
29 00:04:48.430 ⇒ 00:04:51.430 Amber Lin: Said, I think still need to turn them off right.
30 00:04:51.430 ⇒ 00:04:53.849 Caio Velasco: Yeah, yeah, just to clarify.
31 00:04:53.850 ⇒ 00:04:55.680 Amber Lin: Yeah.
32 00:04:55.880 ⇒ 00:05:00.110 Caio Velasco: Yeah, just to clarify. In the beginning, we we turned off ingestion
33 00:05:00.530 ⇒ 00:05:05.280 Caio Velasco: pipelines, ingestion sources from the ingestion tools.
34 00:05:05.640 ⇒ 00:05:09.170 Caio Velasco: Theoretically, they have nothing to do with redshift tables.
35 00:05:09.630 ⇒ 00:05:17.019 Caio Velasco: of course, the ingestion tools at the end of the day. They are also inside redshift tables, but they are 2 separate works.
36 00:05:19.500 ⇒ 00:05:20.652 Demilade Agboola: Yeah. So I see.
37 00:05:22.510 ⇒ 00:05:33.729 Demilade Agboola: yeah. So there are 2 different flows. Turning off just means that the tables in redshift are not being refreshed with new data. But redshift is just like a place where all
38 00:05:34.110 ⇒ 00:05:45.770 Demilade Agboola: the like, every single table lives. And so if we realize that things are not being utilized, we can just kind of delete them from storage, which is what what, which is, what this flow is about.
39 00:05:46.510 ⇒ 00:05:47.090 Caio Velasco: Yeah.
40 00:05:48.710 ⇒ 00:06:01.190 Amber Lin: Okay, let me. I can make another ticket, which is to turn off red shift tables.
41 00:06:01.190 ⇒ 00:06:15.960 Demilade Agboola: I think, something that we can also just do. At least, let’s take advantage of what we already have, things that are not being utilized both that we can see through my script as well as the manifest. Can we mark them, and just like highlight them? So that that way we don’t. We’re not like.
42 00:06:17.150 ⇒ 00:06:31.479 Demilade Agboola: let’s just have a clear idea of the things that we’re deprecating. And we can keep adding based off like the things we’re getting more clarity about, but like those ones we know that are not being utilized through the manifesto through dbt, those ones are definitely going to go. So let’s not like.
43 00:06:31.930 ⇒ 00:06:36.820 Demilade Agboola: Let’s just kind of have that sheets that we’re just building
44 00:06:37.483 ⇒ 00:06:42.300 Demilade Agboola: or like our dep our deprecation sheet that we’re building so that we keep adding to it.
45 00:06:42.710 ⇒ 00:07:04.309 Demilade Agboola: I want us to have like progress. I guess I want us to be able to have like things that we’re saying like, Okay, so this is done or not necessarily done. But these are the things we’re gonna get rid of. We’re still going through this part of it because we want to be sure that, like we’re communicating, that it’s a subset or a small part of the task that we’re handling. Not necessarily the entire task.
46 00:07:04.560 ⇒ 00:07:07.759 Demilade Agboola: We want to be able to show the progress on the small bits of the task.
47 00:07:15.980 ⇒ 00:07:20.320 Amber Lin: Okay, is there anything specific? I should put in this ticket.
48 00:07:22.920 ⇒ 00:07:24.800 Caio Velasco: So they’re not registered in
49 00:07:27.700 ⇒ 00:07:36.950 Caio Velasco: the comment I had before in the other one. From that’s, I think, the most important thing, and that should be related.
50 00:07:37.830 ⇒ 00:07:41.939 Caio Velasco: or even overlapping with the Mila. They just said they are. They are the same things.
51 00:07:43.140 ⇒ 00:07:45.350 Caio Velasco: The yes, that comment from slack.
52 00:07:45.610 ⇒ 00:07:46.370 Caio Velasco: Yeah.
53 00:07:51.190 ⇒ 00:07:51.910 Amber Lin: All right.
54 00:07:54.300 ⇒ 00:07:58.050 Amber Lin: Okay, so is this.
55 00:07:58.480 ⇒ 00:08:01.639 Amber Lin: So this would be done before the other one.
56 00:08:03.090 ⇒ 00:08:13.130 Caio Velasco: Yes, they are kind of the same now, I mean the other one is just a very big one, which I thought there was other things inside, but I’m not sure if it’s from the past or something.
57 00:08:13.600 ⇒ 00:08:14.900 Caio Velasco: The 1 21.
58 00:08:16.840 ⇒ 00:08:23.340 Amber Lin: Well, that one, I think, is just after we turn it off for the ones that we’re pretty sure we’re not gonna use. We can drop it.
59 00:08:25.650 ⇒ 00:08:29.279 Caio Velasco: Yeah, so that’s the point. Like, when when I asked you, Tom, and
60 00:08:30.120 ⇒ 00:08:34.029 Caio Velasco: try to like, see this work, as you know, going layer by layer
61 00:08:35.159 ⇒ 00:08:39.099 Caio Velasco: archive while flagging them. This is what we are doing in the sheet.
62 00:08:39.439 ⇒ 00:08:40.779 Caio Velasco: Then
63 00:08:40.899 ⇒ 00:08:47.979 Caio Velasco: we would have to archive them, and then dropping, or, you know, like, step by step, that that was the idea of what he meant, what he meant.
64 00:08:49.981 ⇒ 00:08:56.450 Caio Velasco: Tickets are kind of the same, you know, we what we have to do is deprecate and turn off things. But we have to do that in a.
65 00:08:57.189 ⇒ 00:09:15.459 Demilade Agboola: Yeah, what we could just do is we could create a schema and move the archive and move those table into that schema. We can call it like archive schema, and then, if we have that for a while, say 30 days, we can then drop the schema. Once we have for sure that nothing has broken since we move that.
66 00:09:16.160 ⇒ 00:09:25.479 Demilade Agboola: So you don’t have to know how these scripts drop in multiple tables where, if you forget to put certain things. You can have an error. We could just have that schema and drop the entire schema.
67 00:09:27.150 ⇒ 00:09:38.020 Amber Lin: Yeah, I’m gonna move the drop off to the other one, I think. move flags, metric tables
68 00:09:38.230 ⇒ 00:09:40.500 Amber Lin: to archive.
69 00:09:44.990 ⇒ 00:09:46.370 Amber Lin: How is this?
70 00:09:47.850 ⇒ 00:09:49.609 Amber Lin: How much would that take?
71 00:09:51.120 ⇒ 00:09:55.060 Amber Lin: If a point is 2 h, then how long would that take.
72 00:09:58.300 ⇒ 00:09:59.020 Caio Velasco: Well.
73 00:09:59.200 ⇒ 00:10:13.289 Caio Velasco: let me think, if we have flag them already, that they are just a list. I would have to just build a script to get that list and move it one by one, because it’s probably gonna be like 1,000. So a few hours, I believe I can do it.
74 00:10:13.660 ⇒ 00:10:16.389 Caio Velasco: 2 points are, how much? Again, 2 h.
75 00:10:17.380 ⇒ 00:10:22.959 Amber Lin: 1 point is 2 h, so 2 points would be like half a day.
76 00:10:23.373 ⇒ 00:10:29.989 Caio Velasco: Okay, 2 points. Then I can update this. Let me even using AI sometimes, it’s complicated.
77 00:10:36.690 ⇒ 00:10:40.490 Amber Lin: Okay, so
78 00:10:46.280 ⇒ 00:10:50.100 Amber Lin: isn’t that this is kind of also what was upset.
79 00:10:50.100 ⇒ 00:10:52.250 Caio Velasco: Yeah, yeah, yeah.
80 00:10:52.250 ⇒ 00:10:52.600 Amber Lin: Nice.
81 00:10:52.600 ⇒ 00:10:58.269 Caio Velasco: And then then he said something else, and then we don’t have to go and check everything and see if we.
82 00:10:58.730 ⇒ 00:11:01.090 Amber Lin: Oh, reach like a final idea!
83 00:11:01.925 ⇒ 00:11:10.449 Caio Velasco: So basically need 2 things finalize the the flags in the spreadsheet, which includes what I talked to them later today.
84 00:11:11.248 ⇒ 00:11:14.129 Caio Velasco: And then the other one that he just did archive.
85 00:11:16.270 ⇒ 00:11:20.550 Amber Lin: So that’s for the restaurant tables, too? Right? Do we I don’t think, we have a.
86 00:11:22.650 ⇒ 00:11:28.720 Caio Velasco: Yeah, yeah, this is just to be make sure that I’m gonna go there and and check what the library told me today.
87 00:11:28.820 ⇒ 00:11:32.539 Caio Velasco: And then everything is. If everything is flagged, then we can move to the other one.
88 00:11:32.740 ⇒ 00:11:40.999 Caio Velasco: and anything else related to redshift table deprecation doesn’t need to be there, because these 2 tickets is only what we need. Right? Emula.
89 00:11:44.580 ⇒ 00:11:46.870 Demilade Agboola: Oh, sorry I was muted. I said yes.
90 00:11:47.120 ⇒ 00:11:48.033 Caio Velasco: Okay. Cool.
91 00:11:49.180 ⇒ 00:11:55.589 Amber Lin: Okay. So from my understanding, this is to move everything to archive. This is finish.
92 00:11:56.152 ⇒ 00:12:06.569 Amber Lin: Once. This is, these 2 are different, because 1, 4, 9 is related to looker and 1 80 are just in general flagging
93 00:12:07.280 ⇒ 00:12:08.200 Amber Lin: right.
94 00:12:09.800 ⇒ 00:12:14.670 Caio Velasco: Yes, this 5, 1, 49,
95 00:12:15.020 ⇒ 00:12:18.860 Caio Velasco: it should be after I flag and use it. Views and exports.
96 00:12:19.200 ⇒ 00:12:21.920 Amber Lin: Yeah. I marked it as blocked, for now.
97 00:12:22.314 ⇒ 00:12:26.259 Caio Velasco: Yeah. And it should be in look or in redshift.
98 00:12:27.079 ⇒ 00:12:27.729 Caio Velasco: Sorry.
99 00:12:35.170 ⇒ 00:12:37.980 Amber Lin: I can put it here for now.
100 00:12:38.230 ⇒ 00:12:56.720 Amber Lin: Okay, so I know this one was a bit confusing. I feel like this should be adjusted. I don’t know if you saw the the table yesterday where I I think both of you were staying the meeting where the stakeholders told us about what we need. I think.
101 00:12:58.570 ⇒ 00:13:05.769 Amber Lin: I can’t move this to me. I do know. We already have marked
102 00:13:05.900 ⇒ 00:13:26.400 Amber Lin: things as used and inaccurate, and we’ve already had the deprecation layer of what needs to be deprecated, what needs to be rebuilt? I think we just need more stakeholder opinions on on their dashboards, and then we can have a full spreadsheet of their different opinions.
103 00:13:27.010 ⇒ 00:13:31.059 Caio Velasco: Yeah, no, perfect. I saw the meeting, and I also made some comments on slack.
104 00:13:31.702 ⇒ 00:13:35.230 Caio Velasco: That table, that new table from yesterday looks good
105 00:13:35.730 ⇒ 00:13:39.910 Caio Velasco: I also saw that you guys were trying to find a
106 00:13:40.120 ⇒ 00:13:53.480 Caio Velasco: sentiment dashboard or something, and it was not there. But it’s because that spreadsheet was already filtered by the 2 deprecate columns, because that was the idea of all the work we did to reach a final
107 00:13:54.410 ⇒ 00:13:54.650 Caio Velasco: Deputy.
108 00:13:54.650 ⇒ 00:13:55.610 Amber Lin: Yeah.
109 00:13:55.960 ⇒ 00:14:10.809 Amber Lin: yeah, I agree. I think some. We it was good that we asked the stakeholders, because there was a few things that they were like, Okay, we can check, but maybe it can’t go. So it was good that we asked the stakeholders.
110 00:14:11.890 ⇒ 00:14:13.739 Amber Lin: Oh, we do have.
111 00:14:13.950 ⇒ 00:14:17.200 Demilade Agboola: You have one. But the stakeholders wasn’t there.
112 00:14:17.400 ⇒ 00:14:23.560 Amber Lin: Last yesterday. So this is, we have sentiments, but it’s under a different stakeholder.
113 00:14:23.810 ⇒ 00:14:27.610 Demilade Agboola: Yeah, something we can do is just
114 00:14:31.250 ⇒ 00:14:34.479 Demilade Agboola: I don’t know if you can do subfolders in looker.
115 00:14:35.280 ⇒ 00:14:44.560 Demilade Agboola: so you can create a folder on a subfolder, but ideally it will be helpful if we can create a folder called archived and then a subfolder. For.
116 00:14:45.060 ⇒ 00:14:45.900 Demilade Agboola: like
117 00:14:45.900 ⇒ 00:14:52.559 Demilade Agboola: about the domain that they’re currently in or by the username that they’re associated with. And if we can do that.
118 00:14:52.720 ⇒ 00:15:03.260 Demilade Agboola: that means that we can say, Hey, for the next 30 days these are going to be the archive folders, and at the end of the 30 days this is when we like get rid of those dashboards.
119 00:15:04.310 ⇒ 00:15:10.789 Demilade Agboola: I realized over 30 days that, Hey, this is missing, or this I’ve not. I need to use this. I haven’t used this.
120 00:15:10.970 ⇒ 00:15:17.509 Demilade Agboola: and then they can go through to the username or through the normal place, that they would find it like the the
121 00:15:18.640 ⇒ 00:15:21.210 Demilade Agboola: and then access it, and then.
122 00:15:21.210 ⇒ 00:15:22.370 Amber Lin: That sounds good.
123 00:15:22.370 ⇒ 00:15:31.219 Demilade Agboola: Yeah. So that way, we don’t just do a drop when people might be using stuff. And potentially, it might be a bit faster or easier than like
124 00:15:32.237 ⇒ 00:15:35.560 Demilade Agboola: having everyone speak to the.
125 00:15:35.560 ⇒ 00:15:36.280 Amber Lin: Oh!
126 00:15:36.686 ⇒ 00:15:39.530 Demilade Agboola: Like speak to the dashboards, I guess.
127 00:15:40.190 ⇒ 00:15:44.109 Amber Lin: I agree. Some of them, I remember, in the meeting they just said like
128 00:15:44.340 ⇒ 00:15:52.810 Amber Lin: it’s been creative since when they had, when they switched over to shopify, so they might still need it. But they haven’t used it.
129 00:15:52.810 ⇒ 00:15:53.390 Demilade Agboola: Yeah.
130 00:15:53.390 ⇒ 00:15:58.739 Amber Lin: But I think the Archive Code Archive Folder is a good idea.
131 00:16:01.240 ⇒ 00:16:06.771 Caio Velasco: And then last thing in that, in the in that new table or sheet
132 00:16:08.120 ⇒ 00:16:11.020 Caio Velasco: I created the the other column.
133 00:16:11.420 ⇒ 00:16:24.009 Caio Velasco: Yeah, the the deprecate stakeholder column column. K, because, you know, since I noticed that we have the comments, guiding what needs to be done or not, then we should add that one. So now we will.
134 00:16:24.510 ⇒ 00:16:27.289 Caio Velasco: Things that happened right like Emily did work.
135 00:16:27.400 ⇒ 00:16:41.450 Caio Velasco: I did work with them with a dpt accuracy, and then the last one was the stakeholders, like last opinion, and then, you know, the final deprecate. Colin would give us the final final decision.
136 00:16:42.017 ⇒ 00:16:46.560 Amber Lin: Okay, I see that’s great. For these
137 00:16:46.680 ⇒ 00:16:49.260 Amber Lin: things that don’t have an owner.
138 00:16:49.440 ⇒ 00:16:55.659 Amber Lin: Shouldn’t we be deprecating them if they don’t have a owner and viewed, is viewed once.
139 00:16:56.410 ⇒ 00:16:58.018 Caio Velasco: So that’s the thing.
140 00:16:58.650 ⇒ 00:17:01.609 Caio Velasco: We we can go back on this again. But
141 00:17:02.070 ⇒ 00:17:08.369 Caio Velasco: the 1st touch for old Dashboard was done by Emily, so she kind of know why she put why.
142 00:17:08.530 ⇒ 00:17:14.849 Caio Velasco: in the in the deprecate column, the the icon? No, everything is market white. If you if you see
143 00:17:18.619 ⇒ 00:17:23.729 Amber Lin: Oh, so this she’s like, yes, we can deprecate. How come we’re saying? No, here.
144 00:17:23.910 ⇒ 00:17:28.010 Caio Velasco: Because the Dbt. Says that it’s accurate.
145 00:17:28.790 ⇒ 00:17:31.809 Caio Velasco: and then and then they call them J. You’d say no.
146 00:17:34.510 ⇒ 00:17:44.619 Amber Lin: Why would we, if it’s not used? If Emily says, deprecate, does it matter if Dvt is accurate or inaccurate?
147 00:17:45.540 ⇒ 00:17:59.059 Caio Velasco: So then, it’s like a good question. And this is something that because we did the work in accuracy, we can. We can now question this, then it’s a question for them, like, why, if the the model it’s accurate by your eyes.
148 00:17:59.060 ⇒ 00:18:03.940 Demilade Agboola: No, but it’s also about it’s about utility. So if if the model is not.
149 00:18:04.200 ⇒ 00:18:08.102 Demilade Agboola: if they’re like Yo, let’s deprecate this model.
150 00:18:09.210 ⇒ 00:18:30.410 Demilade Agboola: that is, when we like that that would always supersede like Dbt, I think we need dbt when, for instance, they say it’s we don’t want to deprecate this. But we’re looking at it. And the accuracy is like questionable. So we can be like, Okay, sure, you don’t want to deprecate this for whatever reasons. But
151 00:18:30.650 ⇒ 00:18:36.739 Demilade Agboola: like, there’s questionable data that is feeding this dashboard. So that leads us to other conversations that we can have.
152 00:18:38.120 ⇒ 00:18:42.399 Demilade Agboola: But I feel like, yeah, whatever should supersede like.
153 00:18:44.040 ⇒ 00:18:50.629 Caio Velasco: Okay, okay, no, that’s no problem. Right? We just have to change the form in.
154 00:18:51.414 ⇒ 00:18:57.760 Caio Velasco: That. That’s okay. Because the we still have the the beauty accuracy column, which is good to be there.
155 00:18:57.950 ⇒ 00:19:02.459 Caio Velasco: But yeah, you’re right. Like, if they said, yes, this should be the most important thing.
156 00:19:02.730 ⇒ 00:19:12.879 Amber Lin: Oh, okay, great. So I I think for these, as long as it’s yes, here and then we
157 00:19:16.150 ⇒ 00:19:21.320 Amber Lin: huh! I guess we can start from the bottom, whatever they say. Yes.
158 00:19:21.480 ⇒ 00:19:29.870 Amber Lin: here, that’s very little that has very little usage. We can move all of them to an archive folder, and then we have less to deal with.
159 00:19:31.030 ⇒ 00:19:38.849 Demilade Agboola: Yeah. And then, if they say like, No, we don’t deprecate. But Dbt, saying, yes, we should deprecate. Then we can have conversations about.
160 00:19:39.190 ⇒ 00:19:47.170 Amber Lin: Oh, like, we know, you don’t want to deprecate this. But, like BBC, the the data coming in seems to have a lot of questions around it.
161 00:19:52.070 ⇒ 00:19:52.850 Amber Lin: Yeah, okay.
162 00:19:52.850 ⇒ 00:19:57.400 Caio Velasco: Yeah, yeah, just make sure that we have this.
163 00:19:57.980 ⇒ 00:20:04.799 Amber Lin: Yeah, I guess for these we need a conversation, for these probably is like.
164 00:20:05.460 ⇒ 00:20:12.330 Amber Lin: sure we can get rid of. We can put them in archive, and that’s like 100 the ae.
165 00:20:12.680 ⇒ 00:20:17.360 Caio Velasco: Yeah. But don’t forget the the the comments which should be
166 00:20:17.938 ⇒ 00:20:23.509 Caio Velasco: should be in the K column. If that’s if those comments are correct.
167 00:20:23.875 ⇒ 00:20:39.589 Amber Lin: Yeah, these ones don’t have a username, so they won’t get any comments. The ones down here. I group by the username. These we have almost 300 here. There’s no username, so we can directly base it off of what Emily says.
168 00:20:39.710 ⇒ 00:20:41.230 Amber Lin: And then.
169 00:20:42.010 ⇒ 00:20:43.210 Caio Velasco: Like.
170 00:20:43.210 ⇒ 00:20:44.900 Amber Lin: Yes, we no.
171 00:20:46.090 ⇒ 00:21:10.470 Caio Velasco: I don’t know if it helps or not. But yesterday, right before the meeting, or right after our stand up, or something, I added a query by column in the other spreadsheet, like, let’s say the original one, because I thought that you would need that. But I don’t think you saw my, my, my comment in slack. So we have another column that has more people that people have who are query it.
172 00:21:10.630 ⇒ 00:21:14.360 Caio Velasco: Maybe it’s helpful. But yeah, I don’t.
173 00:21:18.530 ⇒ 00:21:22.570 Amber Lin: Sorry. Would that be like?
174 00:21:24.240 ⇒ 00:21:27.180 Amber Lin: Where would I see? They queried. It.
175 00:21:28.000 ⇒ 00:21:33.119 Caio Velasco: So if you go to the old, the old tab, the old dashboards tab, which is now more to the right.
176 00:21:33.120 ⇒ 00:21:33.810 Amber Lin: Cool.
177 00:21:35.092 ⇒ 00:21:41.469 Caio Velasco: Then there is a updated by, sorry. Yeah.
178 00:21:45.130 ⇒ 00:21:46.540 Amber Lin: Oh, I see.
179 00:21:47.715 ⇒ 00:21:52.010 Amber Lin: Okay, yeah. I think that could be helpful.
180 00:21:52.670 ⇒ 00:21:57.562 Caio Velasco: So then I would have to bring that into the new one, which is also another work.
181 00:21:59.028 ⇒ 00:22:02.159 Amber Lin: I can. I can get that over. It’s okay.
182 00:22:03.460 ⇒ 00:22:08.819 Caio Velasco: Because it’s gonna be. I usually do the script that to match because it’s like 800.
183 00:22:08.990 ⇒ 00:22:11.408 Caio Velasco: So let me know, because I’m I’m used to it.
184 00:22:12.500 ⇒ 00:22:13.230 Amber Lin: Okay.
185 00:22:13.910 ⇒ 00:22:19.750 Caio Velasco: Format. It depends on what you prefer. I mean, last work for me is good as well, but I can help if you need.
186 00:22:27.840 ⇒ 00:22:29.122 Amber Lin: okay, let me.
187 00:22:34.780 ⇒ 00:22:38.600 Amber Lin: Yeah, I think that’s good.
188 00:22:39.630 ⇒ 00:22:41.210 Amber Lin: So
189 00:22:47.430 ⇒ 00:22:51.730 Amber Lin: I mean, that’s all. I guess everything else is on track. Right?
190 00:22:53.391 ⇒ 00:22:58.699 Caio Velasco: Yes, I’m working on the exporting views. I was already able to build the exports one.
191 00:22:58.700 ⇒ 00:22:59.150 Amber Lin: Hmm.
192 00:22:59.150 ⇒ 00:23:09.119 Caio Velasco: And just check. If it’s correct, and then I’ll move to the views. But as I see, this is another layer of deprecation as well, so everything that we just talked
193 00:23:09.220 ⇒ 00:23:13.980 Caio Velasco: it’s fine. But then, if we are also doing explorers and views.
194 00:23:14.290 ⇒ 00:23:21.289 Caio Velasco: we have done another layer of deprecation, of dashboards that would say something different from whatever decision we are having.
195 00:23:22.560 ⇒ 00:23:24.400 Amber Lin: Are we deprecating?
196 00:23:25.470 ⇒ 00:23:26.400 Amber Lin: Huh?
197 00:23:26.940 ⇒ 00:23:45.739 Caio Velasco: Because the what I was doing that you can told me is like sometimes explores are not being used at all, and maybe some dashboards have only those exports. So we deprecate those dashboards. That would be the idea. So that can change what the things we are doing right now, because everything overlaps.
198 00:23:48.000 ⇒ 00:23:49.080 Amber Lin: Let’s see.
199 00:23:54.260 ⇒ 00:24:03.339 Amber Lin: Aren’t the sorry? Aren’t the explorers and views built on top of dashboards? So if we deprecate some dashboards.
200 00:24:03.460 ⇒ 00:24:11.160 Amber Lin: then what’s left is the ones that they actually use, and the views and explores that actually matter right?
201 00:24:12.490 ⇒ 00:24:16.579 Caio Velasco: So I think the foundations will always be the views and
202 00:24:16.850 ⇒ 00:24:19.860 Caio Velasco: the in the dashboards, and somehow the looks
203 00:24:20.480 ⇒ 00:24:34.600 Caio Velasco: sorry, the views, the explores, and and somehow the looks as well, and dashboards are built on top of those. So if you deprecate dashboards, those this explores, and the view they’re still existing.
204 00:24:36.040 ⇒ 00:24:37.109 Caio Velasco: So he’s like.
205 00:24:37.110 ⇒ 00:24:38.160 Amber Lin: Oh, I see!
206 00:24:38.570 ⇒ 00:24:39.260 Caio Velasco: Yeah.
207 00:24:41.360 ⇒ 00:24:42.320 Amber Lin: Huh!
208 00:24:43.650 ⇒ 00:24:47.700 Demilade Agboola: Yeah. So we we, I think we, we need to be able to
209 00:24:49.350 ⇒ 00:24:58.789 Demilade Agboola: handle this like bit by bit. And then if we need to deprecate. So I think, yeah, we need to map the looks and the explores to whatever dashboard. And
210 00:24:59.530 ⇒ 00:25:04.660 Demilade Agboola: once we then create dashboards, and we figured out that dashboards were duplicating
211 00:25:04.790 ⇒ 00:25:23.110 Demilade Agboola: that can allow us to also get rid of the looks and views and everything associated with those dashboards as well, so like that would also reduce the workload or should reduce the workload when we’re not trying to go through the books and explores and views, just so that we don’t wanna necessarily doing everything from scratch.
212 00:25:25.670 ⇒ 00:25:27.599 Caio Velasco: Yeah, yeah, no. I agree. I agree.
213 00:25:29.690 ⇒ 00:25:51.319 Caio Velasco: yeah, on my end. If we are deprecating dashboards or not doesn’t change much. Because what I do is I I’m scripting everything. So if there is a dashboard that’s not there, maybe the look would be flagged as no, I mean something like that. So for me, it doesn’t doesn’t matter much. What matters for me is like the the decisions of each layer of deprecation.
214 00:25:51.500 ⇒ 00:26:03.879 Caio Velasco: So we did the and the one with Emily. Then we did the one with Dbt. Accuracy. Then we did the one with stakeholder. Now we have the one with explores and views. If those things are well defined, then yes, we just need to finish work.
215 00:26:04.110 ⇒ 00:26:05.070 Caio Velasco: Basically.
216 00:26:09.250 ⇒ 00:26:10.050 Amber Lin: Okay?
217 00:26:12.726 ⇒ 00:26:22.080 Amber Lin: Oh, my, linear is not loading. Okay, do we need so would, you need any other tickets based on what we just discussed.
218 00:26:24.177 ⇒ 00:26:27.929 Caio Velasco: No, no, I can continue the explorers and views.
219 00:26:28.650 ⇒ 00:26:33.749 Caio Velasco: And yeah, and that would add another column to to that sheet
220 00:26:34.320 ⇒ 00:26:40.120 Caio Velasco: another deprecate column, and then we have to play with the decisions we want to reach the final one
221 00:26:41.990 ⇒ 00:26:45.690 Caio Velasco: like the why, the why? No, why, no! Why, no. Those things.
222 00:26:47.020 ⇒ 00:26:49.990 Amber Lin: Hmm, okay.
223 00:26:51.640 ⇒ 00:27:02.860 Amber Lin: could we do them in phases of like, okay, we see the star mark that. Yes, let’s move all of them. Okay, what’s left. Let’s look at these, and then move whatever or better, to do it in one batch.
224 00:27:03.800 ⇒ 00:27:09.240 Caio Velasco: No, I think we can do in phases. We have the columns that are flagging now. It’s
225 00:27:09.720 ⇒ 00:27:13.130 Caio Velasco: a matter of us choosing what to deprecate first, st
226 00:27:14.110 ⇒ 00:27:24.799 Caio Velasco: and then we can do like bit by bit, archive this subset, then archive another subset, then we are going to increase in complexity, until, if we reach a point that we are
227 00:27:25.010 ⇒ 00:27:29.220 Caio Velasco: kind of affecting people that are using, then then okay, then we stop.
228 00:27:31.280 ⇒ 00:27:31.940 Amber Lin: Okay.
229 00:27:32.877 ⇒ 00:27:44.340 Amber Lin: okay, sure, I can make a ticket. I can address some subsets. And then, you guys can comment on if that’s okay? And then this way, we can get started on deprecation earlier.
230 00:27:45.300 ⇒ 00:27:47.980 Amber Lin: Because I know we’ve been stuck on this for a while.
231 00:27:48.710 ⇒ 00:28:01.750 Caio Velasco: Yeah. Yeah. And it was a lot of work with AI. So without the I don’t think this could happen in less than 3 or 4 months. No, I mean, really, really honest. This this is because the scripts are being done by AI. But all the guide.
232 00:28:01.750 ⇒ 00:28:02.550 Amber Lin: Wow!
233 00:28:03.210 ⇒ 00:28:09.070 Caio Velasco: Yeah. Otherwise it’s way longer. So I mean, if they’re expecting less, I think they’re wrong.
234 00:28:10.330 ⇒ 00:28:14.550 Amber Lin: Hmm, hmm, yeah, you did a lot of work.
235 00:28:15.104 ⇒ 00:28:19.789 Amber Lin: Okay, we have to jump to the company meeting. I’ll see you guys there.
236 00:28:20.280 ⇒ 00:28:21.689 Caio Velasco: Cool. Thank you. Bye-bye.
237 00:28:21.990 ⇒ 00:28:23.950 Amber Lin: Alright, thanks, bye.