2025-11-11_brainforge_looker_cleanup_sync

Meeting Title: Brainforge Looker Cleanup Sync Date: 2025-11-11 Meeting participants: Awaish Kumar, Emily Giant, Henry Zhao, Demilade Agboola, Uttam Kumaran

WEBVTT

1 00:02:08.889 ⇒ 00:02:10.150 Emily Giant: Hello!

2 00:02:13.000 ⇒ 00:02:13.950 Awaish Kumar: Hello.

3 00:02:15.850 ⇒ 00:02:16.999 Emily Giant: How’s your day?

4 00:02:19.850 ⇒ 00:02:21.430 Awaish Kumar: Busy? How about you?

5 00:02:21.430 ⇒ 00:02:22.010 Emily Giant: Yeah.

6 00:02:22.330 ⇒ 00:02:24.250 Emily Giant: Same. Crazy.

7 00:02:50.890 ⇒ 00:02:59.170 Awaish Kumar: Okay, for the Looker, do you work directly in the… Browser, or an OPS code?

8 00:02:59.170 ⇒ 00:03:03.339 Emily Giant: I do, yeah. I usually work directly in the browser. Do you have a login?

9 00:03:04.500 ⇒ 00:03:06.150 Awaish Kumar: I use the same.

10 00:03:06.460 ⇒ 00:03:08.530 Emily Giant: Oh, as the others, yes, okay.

11 00:03:13.530 ⇒ 00:03:15.930 Emily Giant: Yeah, I use the browser.

12 00:03:16.880 ⇒ 00:03:19.240 Awaish Kumar: Which one is, like, production branch?

13 00:03:20.120 ⇒ 00:03:22.249 Emily Giant: It is… it’s called Master.

14 00:03:22.580 ⇒ 00:03:27.160 Emily Giant: So, if you just create a new branch, here I can show you.

15 00:03:28.350 ⇒ 00:03:36.450 Emily Giant: I’m sorry, I was up till 4am last night working, so I’m, like, dumb as a box of rocks right now, but I’m trying to rally.

16 00:03:47.960 ⇒ 00:03:48.800 Emily Giant: Okay.

17 00:03:49.720 ⇒ 00:03:51.400 Emily Giant: So, Looker…

18 00:03:56.200 ⇒ 00:04:05.460 Emily Giant: If you go to Develop, Urban Stems, or if you just, turn off Development Mode, you should be able to see what’s in production, and then,

19 00:04:06.050 ⇒ 00:04:12.639 Emily Giant: if you go to… oh, I’m out of development mode now, so it doesn’t show you all of the options, but…

20 00:04:27.530 ⇒ 00:04:29.839 Emily Giant: But you can create a new branch here.

21 00:04:30.210 ⇒ 00:04:36.710 Emily Giant: If you just do new branch, And then… Create from Production is master.

22 00:04:37.360 ⇒ 00:04:40.010 Awaish Kumar: Okay, I couldn’t see Master in the…

23 00:04:40.220 ⇒ 00:04:42.219 Awaish Kumar: Current branches, that’s what I was.

24 00:04:42.220 ⇒ 00:04:43.310 Emily Giant: Funnel!

25 00:04:46.770 ⇒ 00:04:49.639 Emily Giant: I… you should have… are you logged in with the…

26 00:04:50.190 ⇒ 00:04:54.540 Emily Giant: General Brainforge login. Let me make sure you have the right permissions.

27 00:05:03.340 ⇒ 00:05:04.550 Awaish Kumar: Sven on…

28 00:05:06.560 ⇒ 00:05:08.370 Awaish Kumar: 14…

29 00:05:16.610 ⇒ 00:05:17.260 Emily Giant: Yeah.

30 00:05:17.590 ⇒ 00:05:18.890 Emily Giant: You’re an admin.

31 00:05:26.810 ⇒ 00:05:29.270 Emily Giant: But the key is to make sure that

32 00:05:29.800 ⇒ 00:05:32.219 Emily Giant: Right here, the development mode is on.

33 00:05:33.330 ⇒ 00:05:37.810 Emily Giant: Hi, Henry. I don’t think we’ve either seen each other in months, or…

34 00:05:38.570 ⇒ 00:05:41.379 Emily Giant: Potentially have not met outside of the Brainforge channel.

35 00:05:41.790 ⇒ 00:05:44.139 Henry Zhao: Yeah, I think we haven’t met yet, so nice to meet you.

36 00:05:44.380 ⇒ 00:05:47.910 Emily Giant: You too! Thanks for coming to Hangout After Hours!

37 00:05:48.360 ⇒ 00:05:51.039 Henry Zhao: Yeah, thank you. Just here to see if there’s anything I can help with.

38 00:05:51.520 ⇒ 00:06:01.819 Emily Giant: Yeah, let’s just, like, burn it all down, if that sounds good. Just maybe erase Looker entirely, except for the nice new models that y’all have built.

39 00:06:03.180 ⇒ 00:06:03.920 Henry Zhao: Okay.

40 00:06:04.120 ⇒ 00:06:06.240 Emily Giant: Cool!

41 00:06:06.790 ⇒ 00:06:09.120 Emily Giant: Is Utam gonna join? Do you know?

42 00:06:09.710 ⇒ 00:06:11.750 Henry Zhao: I’m not sure, I thought he was going to join.

43 00:06:12.140 ⇒ 00:06:13.000 Emily Giant: Okay.

44 00:06:14.860 ⇒ 00:06:24.829 Emily Giant: I’m sure he will eventually, but I think what the plan is, is we’re going through, or together, doing some of the large amounts of deprecation.

45 00:06:25.050 ⇒ 00:06:33.959 Emily Giant: In archiving, which would be honestly really amazing. I have to present to leadership tomorrow, and I would love

46 00:06:34.200 ⇒ 00:06:41.740 Emily Giant: To say that we… Deleted 900 unused models. Or, excuse me, deleted 900 unused dashboards.

47 00:06:41.860 ⇒ 00:06:44.349 Emily Giant: I think that would make everyone really happy.

48 00:06:44.610 ⇒ 00:06:55.360 Henry Zhao: What I’ve done before is instead of deleting it, I just, one by one, like, add a prefix to it, like, archive or something like that, and then if nothing breaks, just continue doing that, and then eventually delete them.

49 00:06:56.390 ⇒ 00:06:58.450 Emily Giant: That’s brilliant.

50 00:06:58.660 ⇒ 00:07:00.170 Henry Zhao: I like the thought of that.

51 00:07:00.170 ⇒ 00:07:02.719 Emily Giant: It’s, it’s,

52 00:07:03.170 ⇒ 00:07:12.010 Emily Giant: complicated? Not that. That is not complicated. There’s just so many. Is there a way to do it with a script that either of you have done before?

53 00:07:15.070 ⇒ 00:07:18.009 Henry Zhao: When you say many, I heard there’s, like, hundreds, right?

54 00:07:18.450 ⇒ 00:07:25.520 Emily Giant: Oh, yeah. I think there’s… how many are there, Awish? Like… 900 that we have to… Archive?

55 00:07:26.250 ⇒ 00:07:29.409 Awaish Kumar: Yeah, we have more than, yeah, at least 700.

56 00:07:29.760 ⇒ 00:07:31.000 Awaish Kumar: Dashboards. Yep.

57 00:07:33.330 ⇒ 00:07:36.230 Henry Zhao: But I’m sure there’s some that you guys use a lot more than the other ones, right?

58 00:07:36.620 ⇒ 00:07:40.759 Emily Giant: It’s like we use 10 core ones, and the rest are, like, meh.

59 00:07:42.320 ⇒ 00:07:49.290 Emily Giant: Probably, like, every, like, every business. Everyone creates their own, it becomes junked up.

60 00:07:52.360 ⇒ 00:07:52.829 Henry Zhao: Yeah. Over time.

61 00:07:52.830 ⇒ 00:07:59.990 Emily Giant: I think there’s just… Yeah, there’s just been nobody matencing, so, running 10 minutes behind.

62 00:08:02.400 ⇒ 00:08:08.240 Emily Giant: just had to back, just need a quick water break, and I’ll cruise through Looker, okay. So,

63 00:08:08.520 ⇒ 00:08:13.439 Emily Giant: would you want to start with looking at, the sheet, Awash, that…

64 00:08:13.620 ⇒ 00:08:16.870 Emily Giant: Has all of the dashboards for deprecation.

65 00:08:19.100 ⇒ 00:08:23.719 Awaish Kumar: Sorry, I’ve seen the… One which I have marked, right?

66 00:08:24.110 ⇒ 00:08:24.940 Emily Giant: Yes.

67 00:08:25.990 ⇒ 00:08:30.930 Awaish Kumar: Yeah, like, we only have these 3… like this.

68 00:08:31.150 ⇒ 00:08:34.299 Awaish Kumar: Sail line, like this model?

69 00:08:35.340 ⇒ 00:08:36.140 Awaish Kumar: online.

70 00:08:38.789 ⇒ 00:08:39.299 Awaish Kumar: Sorry.

71 00:08:39.309 ⇒ 00:08:44.209 Emily Giant: I’ll… yeah, I’ll show you what’s going on. It’s so very disorganized.

72 00:08:44.210 ⇒ 00:08:49.160 Awaish Kumar: Yeah, top-line trade is the one which is really the…

73 00:08:49.380 ⇒ 00:08:50.920 Emily Giant: I think if we can…

74 00:08:52.320 ⇒ 00:08:57.840 Awaish Kumar: crash, like, tops… top-line sales, KPIs… Yeah.

75 00:08:58.380 ⇒ 00:09:04.570 Awaish Kumar: The third one, which was, like, Regarding…

76 00:09:08.000 ⇒ 00:09:08.690 Awaish Kumar: I think…

77 00:09:08.690 ⇒ 00:09:17.260 Emily Giant: There is, like, there’s some that, like, truly aren’t used, and, let me get a new window going here. I have so many…

78 00:09:17.630 ⇒ 00:09:18.899 Emily Giant: Things going on.

79 00:09:19.150 ⇒ 00:09:22.689 Emily Giant: So, if we go into Develop, Urban Stems.

80 00:09:24.310 ⇒ 00:09:25.240 Awaish Kumar: Get home.

81 00:09:26.980 ⇒ 00:09:31.599 Emily Giant: And then the models are down here. So,

82 00:09:32.540 ⇒ 00:09:34.920 Emily Giant: I don’t even know what the… oh, this is, like…

83 00:09:35.760 ⇒ 00:09:41.409 Emily Giant: We can’t touch that one, but it doesn’t matter. It’s just, like, Soligo API stuff.

84 00:09:41.700 ⇒ 00:09:49.470 Emily Giant: So, top-line sales is what everyone uses, and I know that the plan was to start anew. I would…

85 00:09:50.540 ⇒ 00:09:56.990 Emily Giant: I would advise against that for the sake of… a lot of…

86 00:09:57.160 ⇒ 00:10:06.549 Emily Giant: The inventory data that is new, lives in this model, and most of the core reports have some of those

87 00:10:06.900 ⇒ 00:10:08.549 Emily Giant: elements in them.

88 00:10:08.690 ⇒ 00:10:14.220 Emily Giant: This interim map forecast view

89 00:10:14.470 ⇒ 00:10:22.770 Emily Giant: I don’t even know what that is. But the mode migration, NetSuite cash sales, new core model.

90 00:10:23.060 ⇒ 00:10:24.360 Emily Giant: This can all go.

91 00:10:24.800 ⇒ 00:10:26.339 Emily Giant: Those all need to go.

92 00:10:26.620 ⇒ 00:10:30.419 Emily Giant: And, KPIs has not been upkept.

93 00:10:30.890 ⇒ 00:10:32.070 Emily Giant: So…

94 00:10:32.260 ⇒ 00:10:45.849 Emily Giant: I would consolidate this, unless the plan is to make, like, truly need and make different models, which I’ve never… with Looker, it’s somewhat hard for me to understand, like, why a business our size would need

95 00:10:45.950 ⇒ 00:10:52.129 Emily Giant: multiple models outside of, like, the KPIs, And the top-line sales.

96 00:10:52.280 ⇒ 00:10:56.490 Emily Giant: Because all of our data is relatively integratable.

97 00:10:56.690 ⇒ 00:11:03.040 Emily Giant: Or joinable, on a really stable level, now that we’ve, updated.

98 00:11:03.210 ⇒ 00:11:04.840 Emily Giant: Most of our core models.

99 00:11:07.500 ⇒ 00:11:11.849 Emily Giant: But, for example, we used to have, like, a full access account to Mode.

100 00:11:12.680 ⇒ 00:11:14.960 Emily Giant: And, some of the…

101 00:11:15.750 ⇒ 00:11:24.919 Emily Giant: stakeholders had reports in mode that would send. So these are just, like, derived tables that are very slow and,

102 00:11:25.330 ⇒ 00:11:29.599 Emily Giant: should really be, moved into DBT and deprecated.

103 00:11:29.900 ⇒ 00:11:38.969 Emily Giant: either that, or, like, they’re just simply not used. I… I’m guessing that none of these reports are still actually, like.

104 00:11:39.760 ⇒ 00:11:41.010 Emily Giant: upkept.

105 00:11:41.170 ⇒ 00:11:44.760 Emily Giant: By anyone, and it would not be noticed if we just deleted it.

106 00:11:44.970 ⇒ 00:11:51.159 Emily Giant: But… I’ve also been surprised before. This is where it gets really messy, is that,

107 00:11:51.380 ⇒ 00:11:59.999 Emily Giant: it’s similar to dbt, there’s the new model structure folder, and this currently houses all of the,

108 00:12:00.100 ⇒ 00:12:01.890 Emily Giant: updated views.

109 00:12:02.260 ⇒ 00:12:04.610 Emily Giant: that, Brainforges worked on.

110 00:12:05.240 ⇒ 00:12:13.719 Emily Giant: And all of the other ones, like, there are some folders that hold Views that stakeholders need.

111 00:12:13.950 ⇒ 00:12:19.620 Emily Giant: But then there’s also just so much clutter. Like, look at all these derived tables.

112 00:12:20.080 ⇒ 00:12:25.159 Emily Giant: This is just slowing down Looker, and that’s just one folder.

113 00:12:27.950 ⇒ 00:12:32.050 Emily Giant: And then finance views, like… Aye, aye.

114 00:12:32.050 ⇒ 00:12:47.159 Henry Zhao: Yeah, that’s why I like the idea of, like, just making all the things that we think are not used anymore with, like, an archive, prefix, then whenever somebody comes and says, this is broken, then we know that that’s actually being used, and if something over a long time says anything, we can then delete it.

115 00:12:47.780 ⇒ 00:12:48.690 Emily Giant: Okay.

116 00:12:49.960 ⇒ 00:12:54.769 Henry Zhao: It says, like, oh, my, Tableau items XF delivered raw is, like, not working.

117 00:12:55.110 ⇒ 00:12:55.550 Emily Giant: I just wouldn’.

118 00:12:55.550 ⇒ 00:13:02.379 Henry Zhao: the archived and take note that this is still needed, and I put it on my list of, like, to clean up or put into the main model.

119 00:13:02.550 ⇒ 00:13:03.709 Henry Zhao: At some point.

120 00:13:04.050 ⇒ 00:13:07.039 Emily Giant: Okay, so I know, like, maybe starting with

121 00:13:07.280 ⇒ 00:13:14.460 Emily Giant: like, Zendesk, for example, we no longer use them. So this is, like, a dead integration. I don’t…

122 00:13:15.140 ⇒ 00:13:28.730 Emily Giant: I don’t anticipate… I’m gonna rebuild our customer service data once we integrate our new customer service platform, but in the interim, there’s nothing that they could use from these. So, these would be, like, great candidates.

123 00:13:28.830 ⇒ 00:13:32.409 Emily Giant: to… Go immediately into an archive folder.

124 00:13:34.370 ⇒ 00:13:42.740 Emily Giant: My concern is the amount of errors that we incur once we change anything that’s connected to that top-line sales model.

125 00:13:42.960 ⇒ 00:13:45.260 Emily Giant: Because, like, for example.

126 00:13:45.440 ⇒ 00:13:51.790 Emily Giant: if I just change this name… well, I would have to change the view name, right? Because…

127 00:13:52.380 ⇒ 00:13:55.999 Emily Giant: This actually doesn’t matter for anything outside of…

128 00:13:56.750 ⇒ 00:14:00.089 Emily Giant: No, it doesn’t, it doesn’t matter. You have to change the,

129 00:14:05.070 ⇒ 00:14:13.750 Emily Giant: So, archive… And then, if I run… this.

130 00:14:21.000 ⇒ 00:14:23.130 Henry Zhao: Yeah, like, if there’s a lot of interdependencies, right, it’ll break the.

131 00:14:24.220 ⇒ 00:14:25.410 Emily Giant: Yeah.

132 00:14:25.770 ⇒ 00:14:26.480 Henry Zhao: Hmm.

133 00:14:28.220 ⇒ 00:14:36.459 Emily Giant: So, that’s only two, which is fabulous, but as soon as I, like, erase Zendesk from.

134 00:14:37.280 ⇒ 00:14:43.309 Henry Zhao: the top-line sales model, more… more will come. I commented out, usually.

135 00:14:43.310 ⇒ 00:14:44.350 Emily Giant: Yeah, yeah, yeah.

136 00:14:49.630 ⇒ 00:14:56.300 Emily Giant: Someday, I’ll get, like, the finger touch to not also zoom in when I comment out with a hotkey, but it always zooms in.

137 00:14:57.680 ⇒ 00:14:58.860 Emily Giant: Validate.

138 00:15:05.590 ⇒ 00:15:09.340 Emily Giant: This is another one that we need to, like, get out of here.

139 00:15:10.880 ⇒ 00:15:14.589 Emily Giant: That actually didn’t prove my point at all. But,

140 00:15:14.730 ⇒ 00:15:16.859 Emily Giant: Let’s do this one. Let’s do.

141 00:15:16.860 ⇒ 00:15:18.250 Henry Zhao: But I understand what you’re trying to say, yeah.

142 00:15:18.250 ⇒ 00:15:19.369 Emily Giant: Yeah, yeah.

143 00:15:19.540 ⇒ 00:15:21.800 Emily Giant: And then I would just rename this.

144 00:15:25.080 ⇒ 00:15:26.140 Emily Giant: Archive.

145 00:15:27.040 ⇒ 00:15:27.700 Henry Zhao: Yeah.

146 00:15:28.170 ⇒ 00:15:28.830 Emily Giant: Okay.

147 00:15:30.350 ⇒ 00:15:35.500 Emily Giant: Let’s do… Inventory XF.

148 00:15:36.720 ⇒ 00:15:39.980 Emily Giant: There’s absolutely no reason to still have that.

149 00:15:44.450 ⇒ 00:15:54.060 Emily Giant: But it was one of our most… used views, prior to… the engagement.

150 00:16:00.210 ⇒ 00:16:03.429 Emily Giant: And I’m guessing this will also crash half of the drive tables.

151 00:16:06.500 ⇒ 00:16:11.540 Henry Zhao: Yeah, so when I was doing this, if anything was, like, breaking too many things, I just kind of left it a little bit for later.

152 00:16:12.300 ⇒ 00:16:12.890 Emily Giant: Okay.

153 00:16:13.890 ⇒ 00:16:17.490 Emily Giant: I’m just gonna have, like, a huge cup of coffee and, like, gut it out.

154 00:16:17.980 ⇒ 00:16:19.090 Henry Zhao: Yeah, exactly.

155 00:16:22.400 ⇒ 00:16:25.939 Emily Giant: Hey, Demolade. Welcome to the middle of the night.

156 00:16:26.740 ⇒ 00:16:31.400 Demilade Agboola: Yeah, it’s, like, 11… Level 15 here, so it’s fine.

157 00:16:31.400 ⇒ 00:16:32.330 Emily Giant: Oh, man.

158 00:16:32.970 ⇒ 00:16:39.840 Emily Giant: I… I was telling them a lot earlier, we had… we had one of those days where, like, we woke up to just, like, a shitstorm, and

159 00:16:41.010 ⇒ 00:16:44.150 Emily Giant: I was up till 4am last night working.

160 00:16:44.310 ⇒ 00:16:57.390 Emily Giant: So I’m just like… You know, your brain just is not as good after doing that, so… I’m on the struggle bus a little bit today. Okay, so if I were to… I just need to comment this out.

161 00:16:58.870 ⇒ 00:17:00.519 Demilade Agboola: What are we ripping out now?

162 00:17:01.280 ⇒ 00:17:03.219 Emily Giant: The old inventory.

163 00:17:03.330 ⇒ 00:17:05.870 Emily Giant: models. Or, excuse me, views.

164 00:17:07.069 ⇒ 00:17:09.119 Demilade Agboola: Okay, so we’re taking them out completely.

165 00:17:10.359 ⇒ 00:17:11.609 Emily Giant: Yeah.

166 00:17:12.200 ⇒ 00:17:13.279 Demilade Agboola: Okay, all good.

167 00:17:13.579 ⇒ 00:17:18.129 Demilade Agboola: Dallas, we… have they been using any other, like, dashboards right now?

168 00:17:19.030 ⇒ 00:17:19.660 Emily Giant: Nope.

169 00:17:20.420 ⇒ 00:17:21.559 Demilade Agboola: Okay, that’s great then.

170 00:17:22.170 ⇒ 00:17:26.569 Emily Giant: Yeah, so what model is this? This is… Oh my gosh.

171 00:17:27.030 ⇒ 00:17:28.540 Henry Zhao: Yeah, they’re so many…

172 00:17:28.540 ⇒ 00:17:35.040 Emily Giant: Empire Explorer needs to go away. Like, I need to come out the Empire Explorer.

173 00:17:35.920 ⇒ 00:17:36.400 Henry Zhao: Oh, okay.

174 00:17:36.400 ⇒ 00:17:40.210 Emily Giant: None of it is… used anymore.

175 00:17:41.510 ⇒ 00:17:45.829 Demilade Agboola: What are we commenting on, rather than just removing it, like… Picking it out completely.

176 00:17:46.550 ⇒ 00:17:49.730 Emily Giant: I think… Commenting it out for now.

177 00:17:49.860 ⇒ 00:17:52.919 Emily Giant: Seeing if anyone throws a fit, and then…

178 00:17:53.760 ⇒ 00:17:55.760 Henry Zhao: Yeah, it’s as much as a group correlator.

179 00:17:55.990 ⇒ 00:17:58.469 Henry Zhao: Because then, after a while, if nobody throws a fit, you can just come.

180 00:17:58.840 ⇒ 00:18:00.690 Henry Zhao: deleted, commented back in.

181 00:18:05.850 ⇒ 00:18:10.769 Emily Giant: Did you include inventory XF and top line sales model? These are funny new errors, these are, like.

182 00:18:15.320 ⇒ 00:18:20.350 Emily Giant: Okay, so, Inventory XF… Commenting this out…

183 00:18:21.700 ⇒ 00:18:29.560 Emily Giant: If anyone even is using this view at all, they’re… generating… out of date.

184 00:18:30.060 ⇒ 00:18:32.250 Emily Giant: inaccurate data, so…

185 00:18:43.990 ⇒ 00:18:45.380 Emily Giant: Okay, we’re down to 4.

186 00:18:51.690 ⇒ 00:18:53.749 Emily Giant: Okay, vase pairings view.

187 00:18:53.890 ⇒ 00:18:56.040 Emily Giant: Is this a… what is this?

188 00:19:12.840 ⇒ 00:19:13.970 Emily Giant: Oh, I see.

189 00:19:18.260 ⇒ 00:19:19.060 Emily Giant: Okay.

190 00:19:22.790 ⇒ 00:19:27.130 Emily Giant: I don’t actually understand what’s happening here, or why this is saying that there’s an error.

191 00:19:27.870 ⇒ 00:19:31.760 Emily Giant: But I’m… Pretty sure no one’s used this.

192 00:19:33.890 ⇒ 00:19:34.850 Emily Giant: Ever.

193 00:19:35.440 ⇒ 00:19:40.170 Emily Giant: It’s probably based on, like, a, PDT.

194 00:19:45.110 ⇒ 00:19:46.890 Henry Zhao: See, top-line sales…

195 00:19:59.540 ⇒ 00:20:06.170 Awaish Kumar: It is a killing error on this… This INV info doesn’t exist.

196 00:20:07.260 ⇒ 00:20:07.990 Emily Giant: Yeah.

197 00:20:09.660 ⇒ 00:20:12.999 Awaish Kumar: What is it referring to? Is it a schema?

198 00:20:13.460 ⇒ 00:20:14.580 Awaish Kumar: And.

199 00:20:14.580 ⇒ 00:20:19.310 Emily Giant: Yeah, but I don’t know what it… is.

200 00:20:26.620 ⇒ 00:20:30.500 Emily Giant: Okay, it’s in a Carrie G-Sheet. He has not worked with the company for several years.

201 00:20:31.390 ⇒ 00:20:32.060 Henry Zhao: Okay.

202 00:20:32.820 ⇒ 00:20:38.770 Emily Giant: So… Really good candidate to, delete this.

203 00:20:40.950 ⇒ 00:20:42.390 Uttam Kumaran: Hi, guys. Sorry about that.

204 00:20:42.390 ⇒ 00:20:43.330 Emily Giant: Hi!

205 00:20:45.970 ⇒ 00:20:50.760 Emily Giant: We were just doing, like, an experiment of

206 00:20:51.250 ⇒ 00:20:55.559 Emily Giant: Deprecating the main inventory model, and just, like.

207 00:20:55.960 ⇒ 00:21:02.109 Emily Giant: witnessing the downstream impacts, because it is going to clean up the majority of the Looker errors.

208 00:21:02.350 ⇒ 00:21:07.500 Emily Giant: once we deprecate Inventory XF and Inventory Transactions XF.

209 00:21:08.310 ⇒ 00:21:15.439 Emily Giant: But… And it shouldn’t impact any active dashboards, because we turned off that sync At Mother’s Day.

210 00:21:18.370 ⇒ 00:21:22.400 Emily Giant: Okay. But we’re getting some strange errors.

211 00:21:25.510 ⇒ 00:21:30.839 Uttam Kumaran: So I guess, like, a couple things that I’m probably gonna maybe have to start also working on in parallel…

212 00:21:31.390 ⇒ 00:21:36.770 Uttam Kumaran: I guess you’re working on cleaning up views, or are you working more on explorers?

213 00:21:38.140 ⇒ 00:21:41.850 Emily Giant: Both. Mostly explores.

214 00:21:42.690 ⇒ 00:21:44.780 Emily Giant: I guess if I just went and, like.

215 00:21:46.470 ⇒ 00:21:54.980 Emily Giant: commented out the explorers, the errors would be a lot fewer, and then I could, like, retroactively archive the views.

216 00:21:56.120 ⇒ 00:21:56.790 Emily Giant: Yeah, that works.

217 00:21:56.790 ⇒ 00:21:58.679 Henry Zhao: That might make more sense.

218 00:22:00.040 ⇒ 00:22:08.590 Uttam Kumaran: Yeah, so I can… what I can do now is I’ll go through… I can start to attack the views if you want to just take on explorers, that way we’re gonna, like… Yeah.

219 00:22:09.270 ⇒ 00:22:13.300 Uttam Kumaran: the PRs don’t… Trip on each other, and then…

220 00:22:13.700 ⇒ 00:22:17.209 Uttam Kumaran: Maybe for other folks, I guess.

221 00:22:17.460 ⇒ 00:22:21.319 Uttam Kumaran: For Demolade, I think there’s kind of two other pieces we want to tackle here.

222 00:22:21.840 ⇒ 00:22:27.560 Uttam Kumaran: Is one is, like, moving PDTs to DBT, and then…

223 00:22:28.390 ⇒ 00:22:32.069 Uttam Kumaran: I think we also want to tackle, like, the rep… like, actually migrating.

224 00:22:32.870 ⇒ 00:22:35.489 Uttam Kumaran: So, kind of, those are the kind of a couple of objectives.

225 00:22:38.240 ⇒ 00:22:44.150 Emily Giant: Yeah, so as far as migrating, I was saying to the team, before you got here.

226 00:22:44.920 ⇒ 00:22:48.449 Emily Giant: People are so accustomed to going to the top-line sales model.

227 00:22:48.730 ⇒ 00:22:53.910 Emily Giant: and almost every core dashboard is built on it. I’m not, like.

228 00:22:54.720 ⇒ 00:23:03.699 Emily Giant: vehemently opposed to creating a new model, but I think it would be… For this juncture.

229 00:23:04.470 ⇒ 00:23:08.850 Emily Giant: I would leave it… leave the active views in Top Line Sales.

230 00:23:09.130 ⇒ 00:23:17.949 Emily Giant: And then once we have a handle on if we’ve archived anything that actually is needed, at that point, move it to a new model.

231 00:23:18.770 ⇒ 00:23:22.450 Uttam Kumaran: I guess my point would be, why not just replace the views with…

232 00:23:24.090 ⇒ 00:23:27.220 Uttam Kumaran: Like, the views you… like, the new ones.

233 00:23:28.990 ⇒ 00:23:32.980 Emily Giant: I mean, we can, but, like, for example, the other day, when I…

234 00:23:33.200 ⇒ 00:23:50.970 Emily Giant: all I did was merge those two inventory models, or inventory views into one explore, and it took me 45 minutes just to replace the broken reports through the content validator, and that was only, like, a couple reports.

235 00:23:53.730 ⇒ 00:23:54.610 Uttam Kumaran: Okay.

236 00:23:55.280 ⇒ 00:23:58.340 Emily Giant: But, I mean, you know better than I. I just think, like, if…

237 00:23:58.490 ⇒ 00:24:03.290 Emily Giant: If, for example, we archive something and have to turn it back on.

238 00:24:03.510 ⇒ 00:24:10.160 Emily Giant: It would be easier to go and uncomment it out in top-line sales, temporarily, than to add it to a new model

239 00:24:11.180 ⇒ 00:24:14.800 Emily Giant: etc. And it will have a higher impact of, like.

240 00:24:16.110 ⇒ 00:24:22.300 Emily Giant: I mean, we… I don’t think we can… we don’t want to, like, Delete top-line sales.

241 00:24:22.510 ⇒ 00:24:27.579 Uttam Kumaran: Yeah, I guess, like, this is where I, like, I think maybe, like, I don’t know, Henry, if you have thoughts, but…

242 00:24:27.850 ⇒ 00:24:38.919 Uttam Kumaran: basically, I would just gut the… I would just gut the inside of it, like, you just have to make sure that you’re mapping the new metrics and dimensions to the old ones, and just don’t change them.

243 00:24:39.390 ⇒ 00:24:41.569 Uttam Kumaran: Don’t change the names of anything.

244 00:24:42.070 ⇒ 00:24:44.000 Uttam Kumaran: You know?

245 00:24:45.540 ⇒ 00:24:46.220 Emily Giant: Yeah.

246 00:24:47.430 ⇒ 00:24:55.439 Uttam Kumaran: But, like, that’s… that’s honestly what I would rather focus on while we’re all on the call, because cleaning up the views and stuff is all things I think we can…

247 00:24:55.940 ⇒ 00:24:58.940 Uttam Kumaran: We can do, but that’s gonna be the kind of gnarliest piece.

248 00:25:00.300 ⇒ 00:25:01.979 Emily Giant: the… the Explorers.

249 00:25:02.250 ⇒ 00:25:07.249 Uttam Kumaran: Yeah, like, replacing the Explorers Or in the underlying views.

250 00:25:10.660 ⇒ 00:25:18.450 Emily Giant: I don’t think we’ll do much for placing of underlying views. Well, do you want to share a screen and show an example of what you mean? Just because I think I’m…

251 00:25:18.620 ⇒ 00:25:21.310 Emily Giant: I’m in my own head about the process, and…

252 00:25:21.590 ⇒ 00:25:23.770 Uttam Kumaran: Would like to hear more about your thoughts.

253 00:25:24.190 ⇒ 00:25:25.100 Uttam Kumaran: Yeah, sure.

254 00:25:26.460 ⇒ 00:25:28.080 Uttam Kumaran: Let me just…

255 00:25:29.280 ⇒ 00:25:37.670 Henry Zhao: Yeah, and while you do that, like, I don’t have much context yet, but I just heard from… from Emily that basically there’s a lot of stuff that is not being used anymore, right, and you guys want to clean that up.

256 00:25:38.620 ⇒ 00:25:44.460 Uttam Kumaran: Yeah, so we already have kind of an action plan. I guess I just want to make sure that we’re all on the call and we’re tackling the biggest

257 00:25:44.610 ⇒ 00:25:49.599 Uttam Kumaran: Fish, which is just… Getting in our new models, and then kind of, like, divvying up

258 00:25:49.860 ⇒ 00:25:56.449 Uttam Kumaran: who’s gonna do what. So, if I was to… let me just log in here, and I’ll kind of share what I mean.

259 00:25:56.970 ⇒ 00:26:03.149 Uttam Kumaran: So… Hold on one second…

260 00:26:09.010 ⇒ 00:26:09.770 Uttam Kumaran: Okay.

261 00:26:10.910 ⇒ 00:26:16.200 Uttam Kumaran: So, if we go to, like, The top-line sales model.

262 00:26:17.250 ⇒ 00:26:27.560 Uttam Kumaran: Go to… the… Explore, that is… Calls… Sales data.

263 00:26:28.360 ⇒ 00:26:36.380 Uttam Kumaran: basically, what I would say is your job… our job here is to replace like… this?

264 00:26:37.540 ⇒ 00:26:39.719 Uttam Kumaran: One or several of ours.

265 00:26:40.380 ⇒ 00:26:47.500 Uttam Kumaran: and basically supported through many joins. So what you’re gonna find is if you go to Tableau ItemsXF,

266 00:26:47.780 ⇒ 00:26:57.979 Uttam Kumaran: you’re gonna see that all of these columns here are named a certain way, so what we’re gonna have to do is… there’s two options. Either you…

267 00:26:58.210 ⇒ 00:27:00.600 Uttam Kumaran: Create new views that sort of map

268 00:27:00.940 ⇒ 00:27:03.789 Uttam Kumaran: They have the same measure names and dimension names.

269 00:27:04.040 ⇒ 00:27:13.340 Uttam Kumaran: So basically, as long as you make it available, you can go through Content Validator and move things from Tableau XF to the right

270 00:27:13.610 ⇒ 00:27:14.480 Uttam Kumaran: view.

271 00:27:14.970 ⇒ 00:27:26.500 Uttam Kumaran: That way, as long as the measure names are the same, all you’re going to do content validation on, or the… whatever, the bulk edit, basically, is on changing the view from Tableau Items XF to the new view.

272 00:27:27.170 ⇒ 00:27:29.580 Uttam Kumaran: And ideally, if you have your joint set up well.

273 00:27:29.930 ⇒ 00:27:33.560 Uttam Kumaran: We’ll just have to run that command once we make the swap.

274 00:27:34.390 ⇒ 00:27:36.550 Uttam Kumaran: Alternatively is, like.

275 00:27:37.410 ⇒ 00:27:43.260 Uttam Kumaran: we create a new Explorer, but again, you’re gonna lose all that content that’s created on the existing Explorer.

276 00:27:43.490 ⇒ 00:27:50.100 Uttam Kumaran: So… my suggestion here is, like, okay, if our job is to take Tableau items like SAF,

277 00:27:50.860 ⇒ 00:27:54.970 Uttam Kumaran: And we just have to map dimensions from here to…

278 00:27:55.580 ⇒ 00:27:59.279 Uttam Kumaran: The dimensions from the new model, similarly from the measures.

279 00:27:59.390 ⇒ 00:28:04.419 Uttam Kumaran: And then all… what we’ll have to do is just make sure that all of those

280 00:28:04.560 ⇒ 00:28:06.839 Uttam Kumaran: That’s basically the same names.

281 00:28:06.990 ⇒ 00:28:08.160 Uttam Kumaran: exist?

282 00:28:08.610 ⇒ 00:28:11.829 Uttam Kumaran: In the new… in the new views, and then…

283 00:28:12.450 ⇒ 00:28:16.650 Uttam Kumaran: You sort of just do the swap, and then once you swap it out, all of those

284 00:28:17.130 ⇒ 00:28:29.779 Uttam Kumaran: I would say all of those, like, all the dashboards built on this are gonna fail, and at that point, what you’re going to do is basically say, great, anything that fails with all car PM orders, we’re gonna swap to

285 00:28:30.570 ⇒ 00:28:41.820 Uttam Kumaran: this other view. Okay, maybe days remaining until this is coming from another view. We’re going to swap the view definition for this metric from tableau items, except to the new view.

286 00:28:43.420 ⇒ 00:28:45.190 Uttam Kumaran: That’s how I’ve done this in the past.

287 00:28:45.930 ⇒ 00:28:46.590 Emily Giant: Okay.

288 00:28:48.450 ⇒ 00:28:57.540 Emily Giant: That makes sense. Demolade, what are your thoughts on… on that process?

289 00:28:58.060 ⇒ 00:29:08.100 Emily Giant: Like, given how… the updates in the Revenue Mart, for example, relate to, like, what exists.

290 00:29:09.150 ⇒ 00:29:10.300 Emily Giant: Currently.

291 00:29:11.520 ⇒ 00:29:19.519 Emily Giant: I don’t know if I’m asking that question right. Like, I’m… I guess I’m asking, do you think that… that is a good idea to map things to how they were?

292 00:29:19.760 ⇒ 00:29:23.599 Emily Giant: Since how they were… Was kind of a disaster.

293 00:29:25.100 ⇒ 00:29:32.279 Demilade Agboola: Oh, gee… The… yes, I think we collapsed some of the things, how things were.

294 00:29:32.600 ⇒ 00:29:36.700 Demilade Agboola: But, I’m trying to think…

295 00:29:37.480 ⇒ 00:29:44.670 Demilade Agboola: I think, ultimately, we do have things like our fulfilled revenue, which can replace, like, revenue recognized.

296 00:29:44.860 ⇒ 00:29:48.990 Demilade Agboola: Unacrued revenue, which would just be, like, the revenue as it was before.

297 00:29:49.360 ⇒ 00:29:56.700 Demilade Agboola: I think… beyond that, I don’t think we have too many other issues.

298 00:29:57.190 ⇒ 00:30:04.169 Demilade Agboola: I think we’ll just have… we’ll have to add things like the delivery date, and map it properly, and things like the fiscal date as well.

299 00:30:04.410 ⇒ 00:30:09.839 Demilade Agboola: But I don’t think there are any serious, like, large disparities, at least I haven’t seen any.

300 00:30:12.750 ⇒ 00:30:13.560 Emily Giant: Okay.

301 00:30:20.910 ⇒ 00:30:22.440 Uttam Kumaran: So what do you think?

302 00:30:24.700 ⇒ 00:30:33.429 Uttam Kumaran: like, I guess my question for you guys is, like, can we… can we basically do a mapping of everything in Tableau ItemsXF to a new model?

303 00:30:34.000 ⇒ 00:30:36.970 Uttam Kumaran: I’m like, that’s probably where I would… Yeah.

304 00:30:36.970 ⇒ 00:30:37.750 Awaish Kumar: with that again.

305 00:30:37.750 ⇒ 00:30:39.210 Uttam Kumaran: our time today.

306 00:30:39.380 ⇒ 00:30:57.099 Demilade Agboola: Yeah, also, I will say that, like, Tableau’s Icelandic XF is this really, really, really, really large table that, like, we don’t have everything to map to it. Like, for instance, in Tableau’s Icelandic XF, they already have, like, customized segmentation, which… it was terribly done, by the way, but, like, they do have it there.

307 00:30:57.100 ⇒ 00:30:57.750 Emily Giant: Yeah.

308 00:30:57.750 ⇒ 00:31:01.219 Demilade Agboola: But, like, and we haven’t done any of that.

309 00:31:01.590 ⇒ 00:31:03.980 Uttam Kumaran: We’ve just done, like, the pure core.

310 00:31:03.980 ⇒ 00:31:05.190 Demilade Agboola: Or every new models.

311 00:31:05.450 ⇒ 00:31:11.880 Uttam Kumaran: You can still leave some items in Tableau Items Accept, but I want to move as many as possible over, right?

312 00:31:12.110 ⇒ 00:31:16.320 Uttam Kumaran: So… Basically, ideally, that should give us the…

313 00:31:16.460 ⇒ 00:31:20.339 Uttam Kumaran: Ideally, that column mapping exercise should give us the roadmap.

314 00:31:20.920 ⇒ 00:31:22.280 Uttam Kumaran: on what’s remaining.

315 00:31:26.950 ⇒ 00:31:28.160 Emily Giant: Okay, so…

316 00:31:28.160 ⇒ 00:31:28.930 Demilade Agboola: Sounds good.

317 00:31:29.380 ⇒ 00:31:30.060 Emily Giant: Oh, yeah.

318 00:31:30.630 ⇒ 00:31:32.709 Uttam Kumaran: So, I don’t know, maybe if…

319 00:31:33.050 ⇒ 00:31:42.409 Uttam Kumaran: Demolati, do you want to start? I would say, like, if we can start that in our data platform, like, documentation, that would be great.

320 00:31:42.860 ⇒ 00:31:47.290 Uttam Kumaran: And then while… if you guys want to start on that, I’m gonna kind of…

321 00:31:47.720 ⇒ 00:31:52.010 Uttam Kumaran: I’m gonna kind of go through and just do a… a little bit of an… of a…

322 00:31:52.400 ⇒ 00:31:55.850 Uttam Kumaran: ticketing of, like, the cleanup steps, and then I can…

323 00:31:56.560 ⇒ 00:32:02.340 Uttam Kumaran: I can kind of pass that to me and Henry to try to take a stab at right now, in the easy cleanups.

324 00:32:03.920 ⇒ 00:32:06.859 Uttam Kumaran: So I think that the steps we probably need…

325 00:32:07.000 ⇒ 00:32:13.440 Uttam Kumaran: Now, is kind of just, like, every column… from Tableau Items, XF, And then…

326 00:32:15.600 ⇒ 00:32:18.640 Uttam Kumaran: Basically, we want to map this to…

327 00:32:19.230 ⇒ 00:32:25.680 Uttam Kumaran: like, another table, and then a column in that table, right? So this would be like a numerics table.

328 00:32:28.850 ⇒ 00:32:29.510 Emily Giant: Yeah.

329 00:32:30.820 ⇒ 00:32:31.750 Emily Giant: That works.

330 00:32:34.470 ⇒ 00:32:36.260 Uttam Kumaran: Oh, it’s not B.

331 00:32:38.830 ⇒ 00:32:40.779 Uttam Kumaran: That would be amazing.

332 00:32:41.230 ⇒ 00:32:45.949 Uttam Kumaran: And then I guess, like, this is where Tableau Items Accept is just one, but I think…

333 00:32:46.180 ⇒ 00:32:49.020 Uttam Kumaran: Let’s just consider this, like, our sales…

334 00:32:49.650 ⇒ 00:32:52.749 Uttam Kumaran: Basically, this is, like, Sales Explorer migration.

335 00:32:53.300 ⇒ 00:32:56.149 Uttam Kumaran: So, ideally, we’re able to map all

336 00:32:57.540 ⇒ 00:33:06.149 Uttam Kumaran: We’re basically able to say, like, okay, as long as we put the… have the right views with all these columns, we could do this migration, you know?

337 00:33:09.020 ⇒ 00:33:09.690 Emily Giant: Yeah.

338 00:33:18.790 ⇒ 00:33:24.830 Emily Giant: Okay, so… So how do we… chart.

339 00:33:26.800 ⇒ 00:33:32.439 Uttam Kumaran: Yeah, I mean, I… can someone bring in the Tableau items except columns, and then…

340 00:33:33.110 ⇒ 00:33:38.300 Uttam Kumaran: Demolade or OH, you guys want to work on armarts, basically mapping that?

341 00:33:39.130 ⇒ 00:33:40.570 Uttam Kumaran: Or, yeah, I…

342 00:33:41.240 ⇒ 00:33:43.269 Demilade Agboola: I’m tr- I’m trying to get the…

343 00:33:43.460 ⇒ 00:33:47.920 Demilade Agboola: a query to, like, put everything, all the columns from top of those items, etc.

344 00:33:48.260 ⇒ 00:33:52.250 Demilade Agboola: They have, like, it has, like, 100 columns, so it’s not something to, like, copy and paste, you have to just.

345 00:33:52.250 ⇒ 00:33:52.750 Emily Giant: Yeah.

346 00:33:53.030 ⇒ 00:33:53.570 Uttam Kumaran: Yeah, yeah.

347 00:33:53.570 ⇒ 00:33:54.810 Demilade Agboola: grammatically guessing you.

348 00:33:55.440 ⇒ 00:33:56.000 Uttam Kumaran: Yeah.

349 00:33:58.610 ⇒ 00:33:59.310 Uttam Kumaran: Okay.

350 00:34:02.870 ⇒ 00:34:10.429 Awaish Kumar: And are we looking to, like, manage all of that in Looker, or…

351 00:34:11.050 ⇒ 00:34:15.380 Awaish Kumar: Like, aren’t we thinking of creating summary tables in dbt?

352 00:34:19.110 ⇒ 00:34:24.599 Uttam Kumaran: Yeah, I’m happy if you want to create those, but again, like, this is where I’m, like, kind of pushing on…

353 00:34:25.620 ⇒ 00:34:31.109 Uttam Kumaran: you and Demolade, like, to make the distinction on, like, where we want the models to live.

354 00:34:31.360 ⇒ 00:34:32.080 Uttam Kumaran: Bye.

355 00:34:32.909 ⇒ 00:34:36.729 Uttam Kumaran: But, of course, like, at minimum right now, we…

356 00:34:37.219 ⇒ 00:34:43.189 Uttam Kumaran: we’re not… we’re… these… we’re still pulling from old tables, so I kind of need a solution, like.

357 00:34:43.590 ⇒ 00:34:46.049 Uttam Kumaran: Pretty quickly, to kind of make this switch.

358 00:34:46.380 ⇒ 00:34:53.490 Uttam Kumaran: So, I don’t… I’ll leave… I’m kind of open if you have a suggestion on what to move, but…

359 00:34:54.100 ⇒ 00:34:55.809 Uttam Kumaran: It’s… I don’t think there’s gonna…

360 00:34:55.920 ⇒ 00:35:01.049 Uttam Kumaran: one size fits all on this. Like, we can’t have… we can’t have summary tables for… for everything.

361 00:35:02.540 ⇒ 00:35:03.270 Demilade Agboola: I do actually want us.

362 00:35:03.270 ⇒ 00:35:04.589 Uttam Kumaran: That’s more of the data, you know?

363 00:35:05.760 ⇒ 00:35:14.389 Demilade Agboola: Yeah, I do… I have said this to Emily as well as to Sam. I would… like, they have really wide tables, and I’m not a big fan of that.

364 00:35:16.060 ⇒ 00:35:22.380 Demilade Agboola: But the flip side is, the way they set up those tables is so that anybody on their team can kind of go to that one table.

365 00:35:23.120 ⇒ 00:35:25.709 Demilade Agboola: And kind of just do all the analysis they need to do.

366 00:35:26.720 ⇒ 00:35:29.190 Demilade Agboola: But obviously, I don’t think it’s maintainable.

367 00:35:29.940 ⇒ 00:35:33.169 Demilade Agboola: It’s always the problem with, like, me having 100 columns.

368 00:35:33.720 ⇒ 00:35:38.339 Demilade Agboola: it’s very, very hard to maintain. So, yeah, at DB, we should… we should actually…

369 00:35:42.160 ⇒ 00:35:58.910 Demilade Agboola: Like, even the models I’m making now are, like, smaller, they’re not as wide as that, and they’re focused on one thing. But eventually, when it gets to Looker, it does become wider, because, you know, people join it, and it becomes, like, two tables or three tables into one, and it becomes this wide table for everybody to use.

370 00:35:59.320 ⇒ 00:36:04.669 Demilade Agboola: So, that is the… Complication in using these things.

371 00:36:19.720 ⇒ 00:36:28.039 Emily Giant: Yeah, I think it’s a worthwhile, to do the columns in the new mark table, and just decide which, fields… I can even run a quick

372 00:36:28.230 ⇒ 00:36:35.719 Emily Giant: look or query, to see if those fields are even used, and decide whether They’re worth migrating.

373 00:36:36.510 ⇒ 00:36:37.060 Uttam Kumaran: Okay.

374 00:36:37.240 ⇒ 00:36:52.650 Emily Giant: Yeah, so I think, like, also, Demolati knows this, but, there are two different models that calculate revenue, and they’re different. Like, one of the tests we had to turn off during Mother’s Day was the, like, the test in dbt for, like.

375 00:36:52.930 ⇒ 00:37:08.199 Emily Giant: if the difference between revenue in the one revenue model versus the other is greater than $5, then defer to, like, failing. And we only have one revenue model now, so I think that that is going to eliminate

376 00:37:08.760 ⇒ 00:37:15.959 Emily Giant: ton of these columns, because what we’ve built is something that can, like, roll up and roll out,

377 00:37:16.120 ⇒ 00:37:26.740 Emily Giant: cleanly, and, like, a lot of the duplication issues that happen with revenue, like today, for example, are because of all the columns that are in it that don’t need to be.

378 00:37:27.050 ⇒ 00:37:32.420 Emily Giant: So yeah, I think starting with just listing out those columns and then deciding what we’re gonna carry over and what we’re not.

379 00:37:32.820 ⇒ 00:37:36.409 Emily Giant: is a good idea.

380 00:37:36.580 ⇒ 00:37:49.949 Emily Giant: And then, in terms of, like, at the same time, building a new model, there is a chunk of all the new stuff right at the top of the top-line sales model that you can just, like, copy and paste over to the new one.

381 00:37:50.220 ⇒ 00:37:55.399 Emily Giant: And then we can, like, build… From there, because anything…

382 00:37:55.710 ⇒ 00:37:59.250 Emily Giant: Pretty sure anything that’s in, like, a fact…

383 00:37:59.660 ⇒ 00:38:06.290 Emily Giant: table in dbt is in Looker. So…

384 00:38:08.310 ⇒ 00:38:14.980 Emily Giant: As far as, like, building the new tables, Initially, like, they’re there.

385 00:38:15.660 ⇒ 00:38:23.820 Emily Giant: The one big thing that we haven’t deployed is one that I’m sitting on, which is all of the delivery

386 00:38:25.450 ⇒ 00:38:36.510 Emily Giant: the delivery data, like, tracking number, blah blah blah blah blah, I can legit deploy that, like, probably right now, if I just run into my staging, and that way it’s available.

387 00:38:36.690 ⇒ 00:38:39.689 Emily Giant: But… I leave that to y’all.

388 00:38:41.100 ⇒ 00:38:41.660 Uttam Kumaran: Okay.

389 00:38:44.690 ⇒ 00:38:51.159 Demilade Agboola: I just found the unlocked. It appears that there are 402 columns.

390 00:38:51.850 ⇒ 00:38:52.329 Emily Giant: Oh, my God.

391 00:38:52.330 ⇒ 00:38:52.880 Demilade Agboola: project, so…

392 00:38:52.880 ⇒ 00:38:54.150 Emily Giant: God!

393 00:38:54.480 ⇒ 00:38:55.790 Emily Giant: That’s funny.

394 00:38:56.660 ⇒ 00:39:03.150 Demilade Agboola: So, that’s what I mean by they do really, really large tables, and obviously that’s… that’s… it’s not useful at this point.

395 00:39:04.040 ⇒ 00:39:04.479 Henry Zhao: There you go.

396 00:39:04.480 ⇒ 00:39:09.410 Demilade Agboola: Like, we definitely… we definitely need smaller tables, like, that’s a summary table.

397 00:39:10.750 ⇒ 00:39:14.509 Henry Zhao: I literally don’t even know how you guys are maintaining the right level of aggregation with that many columns.

398 00:39:14.790 ⇒ 00:39:15.360 Emily Giant: Oh, we’re not.

399 00:39:15.360 ⇒ 00:39:33.290 Demilade Agboola: We are not… that’s why… that’s why revenue keeps going. Like, literally, the issue today, why revenue was much higher, is because we were having duplicates, like, actually, in some cases, triplicates, like, three… three values for the same amount. But the revenue was, like, times three, and so we had to go in there and deduplicate.

400 00:39:33.590 ⇒ 00:39:37.990 Demilade Agboola: then it fell back to normal. But, yeah, it’s… it’s really hard to maintain.

401 00:39:39.160 ⇒ 00:39:41.809 Henry Zhao: Yeah, and in my experience, I know Looker sells themselves as, like.

402 00:39:41.960 ⇒ 00:39:52.179 Henry Zhao: it will never happen, because you know that you do the many-to-one and one-to-many relationships, but in my experience, it’s never properly used. Just because there’s so much things you have to, like, keep in mind.

403 00:39:52.640 ⇒ 00:39:54.740 Henry Zhao: To properly split up, you know?

404 00:39:55.950 ⇒ 00:39:56.480 Henry Zhao: So I…

405 00:39:56.480 ⇒ 00:40:01.049 Emily Giant: Yeah, you’re preaching to the choir, for sure. It is not maintained.

406 00:40:09.270 ⇒ 00:40:13.309 Uttam Kumaran: Yeah, so Emily, I think it would be helpful maybe if you want to own this column.

407 00:40:14.320 ⇒ 00:40:16.199 Emily Giant: Yeah… I will do that.

408 00:40:16.200 ⇒ 00:40:16.930 Uttam Kumaran: Okay.

409 00:40:17.090 ⇒ 00:40:20.890 Uttam Kumaran: And then… Yeah, I would say…

410 00:40:21.160 ⇒ 00:40:25.050 Uttam Kumaran: for Demi and OH, if you guys want to start to map?

411 00:40:25.610 ⇒ 00:40:30.160 Uttam Kumaran: And then I’m gonna kind of poke around and… In Looker a bit.

412 00:40:31.170 ⇒ 00:40:35.320 Uttam Kumaran: A few other things. I’m just gonna set up local my environment and stuff.

413 00:40:36.410 ⇒ 00:40:38.100 Uttam Kumaran: Start cutting things.

414 00:40:41.270 ⇒ 00:40:43.220 Emily Giant: What tab is… what tab is that in?

415 00:40:43.850 ⇒ 00:40:48.299 Uttam Kumaran: This is in Sales Explorer Migration.

416 00:40:48.950 ⇒ 00:40:49.730 Emily Giant: Thank you.

417 00:40:50.030 ⇒ 00:40:51.709 Uttam Kumaran: Yeah, I’ll just move biscuit.

418 00:42:01.210 ⇒ 00:42:06.099 Emily Giant: Sorry, my cat I had a bowl of soup, and she just put her paw in it entirely.

419 00:43:16.730 ⇒ 00:43:31.340 Demilade Agboola: Also, I think beyond being used in Looker, should we not just have the concept of what we need for, like, the revenue dashboard specifically? Because some things might be used in Looker, but they don’t really matter to, like, the core revenue.

420 00:43:32.850 ⇒ 00:43:41.599 Uttam Kumaran: Yeah, this is also kind of like… this is just so tough, because it’s a little bit of a cart before the horse, so I almost, like, want to ask that.

421 00:43:41.920 ⇒ 00:43:49.359 Uttam Kumaran: But… I’m also, like, let’s just, like, make sure… I don’t know, I’m also kind of on team…

422 00:43:49.590 ⇒ 00:43:52.979 Uttam Kumaran: Just make sure we support what’s existing, and then…

423 00:43:53.730 ⇒ 00:43:56.569 Uttam Kumaran: We… that’s our next question, you know?

424 00:43:57.900 ⇒ 00:43:58.610 Demilade Agboola: Okay.

425 00:44:05.680 ⇒ 00:44:06.729 Uttam Kumaran: I hear you.

426 00:47:23.450 ⇒ 00:47:26.450 Awaish Kumar: And what are these? Comp 1, 2, 3, 4?

427 00:47:36.560 ⇒ 00:47:37.609 Uttam Kumaran: No. I’m sorry, wasn’.

428 00:47:39.110 ⇒ 00:47:40.240 Demilade Agboola: It’s the components.

429 00:47:40.240 ⇒ 00:47:40.820 Emily Giant: Sure.

430 00:47:41.890 ⇒ 00:47:42.680 Emily Giant: Oh, jeez.

431 00:47:42.680 ⇒ 00:47:43.570 Demilade Agboola: Tom Slug.

432 00:47:43.740 ⇒ 00:47:45.050 Emily Giant: The console.

433 00:47:45.630 ⇒ 00:47:49.859 Demilade Agboola: Components log components, like, it’s the components in the order.

434 00:47:50.900 ⇒ 00:47:51.639 Emily Giant: Yeah, I know.

435 00:47:51.640 ⇒ 00:47:55.559 Demilade Agboola: So, like… Like, the item that makes up the order.

436 00:47:58.850 ⇒ 00:47:59.900 Awaish Kumar: We’re looking…

437 00:47:59.900 ⇒ 00:48:02.769 Emily Giant: Yeah, it’s very flawed.

438 00:48:03.300 ⇒ 00:48:10.930 Emily Giant: Cause it only has, like… it’s not even… I don’t even think it’s a for loop. Like, it just stops doing iterations at a certain point, it’s…

439 00:48:11.240 ⇒ 00:48:15.309 Emily Giant: it’ll work with Demolade’s new model, because he’s, like.

440 00:48:15.720 ⇒ 00:48:22.000 Emily Giant: reallocated the revenue appropriately. But, like, that model is done.

441 00:48:22.140 ⇒ 00:48:27.230 Emily Giant: Until it’s… updated with the new data mart, or with the new revenue mart.

442 00:48:29.550 ⇒ 00:48:33.110 Emily Giant: So, I’m… marking these.

443 00:48:33.360 ⇒ 00:48:39.160 Emily Giant: And, like, there’s a bunch of stuff in this model that should only come from inventory.

444 00:48:39.700 ⇒ 00:48:45.349 Emily Giant: So I’m just noting that, like, in column E, I’m just leaving some notes, so that…

445 00:48:46.020 ⇒ 00:48:49.949 Emily Giant: We know that… we can join these one-to-one,

446 00:48:50.400 ⇒ 00:48:54.250 Emily Giant: Which we were never able to do, which is why there’s so many duplicate things.

447 00:48:54.540 ⇒ 00:49:00.110 Emily Giant: But… some of these, I’m just, like, making the executive decision knowing that…

448 00:49:00.240 ⇒ 00:49:07.530 Emily Giant: the accurate data will come from NetSuite as opposed to Shopify, because Shopify doesn’t… do units.

449 00:49:07.640 ⇒ 00:49:14.650 Emily Giant: the way that… These are meant to. Some of these… Fields.

450 00:50:45.890 ⇒ 00:50:49.730 Uttam Kumaran: It’s getting so dark here so fast. It’s, like, only 4.50.

451 00:50:54.290 ⇒ 00:51:00.649 Emily Giant: Yeah, it’s completely dark here. It’s so… It’s ridiculous.

452 00:51:01.390 ⇒ 00:51:02.140 Emily Giant: Click…

453 00:51:02.250 ⇒ 00:51:13.430 Emily Giant: 6 o’clock, and there’s also people on my roof right now replacing the gutter, and I’m like, I am not liable for this when you fall. Like, I did not choose…

454 00:51:14.000 ⇒ 00:51:16.160 Emily Giant: For you to do this in the night.

455 00:51:18.810 ⇒ 00:51:19.750 Uttam Kumaran: Yikes.

456 00:51:20.470 ⇒ 00:51:20.940 Uttam Kumaran: Yeah.

457 00:51:39.530 ⇒ 00:51:42.719 Uttam Kumaran: Henry, maybe while you’re here, if you’re…

458 00:51:42.900 ⇒ 00:51:46.980 Uttam Kumaran: just hanging out. I was wondering, maybe you can help on…

459 00:51:47.370 ⇒ 00:51:54.249 Uttam Kumaran: this ticket, which is just, like, migrating PDTs, I’m wondering if you can help me just, like, identify

460 00:51:54.520 ⇒ 00:51:59.170 Uttam Kumaran: all of the actively used PDTs, And so we can create…

461 00:51:59.930 ⇒ 00:52:06.030 Uttam Kumaran: a list of those. Not sure if those are also tracked anywhere in our data platform sheet, but…

462 00:52:07.670 ⇒ 00:52:09.270 Uttam Kumaran: That would be very helpful.

463 00:52:17.510 ⇒ 00:52:19.350 Uttam Kumaran: You’re on mute if you’re talking.

464 00:52:20.050 ⇒ 00:52:20.789 Henry Zhao: No, I’m not.

465 00:52:21.260 ⇒ 00:52:22.900 Uttam Kumaran: Oh, okay, alright.

466 00:52:22.900 ⇒ 00:52:24.230 Henry Zhao: Just watching your… yeah.

467 00:52:24.530 ⇒ 00:52:29.900 Uttam Kumaran: Oh, okay. I was just gonna see if there’s… Any…

468 00:52:31.270 ⇒ 00:52:34.250 Uttam Kumaran: Like, anyone that says PDT somewhere?

469 00:52:38.040 ⇒ 00:52:41.060 Uttam Kumaran: Okay, there’s some… oh, these are all dashboards.

470 00:52:44.030 ⇒ 00:52:51.060 Uttam Kumaran: Yeah, I feel like we don’t have anything here that… And the list of PDTs?

471 00:52:51.540 ⇒ 00:52:55.630 Uttam Kumaran: Would you… Mind putting together a little bit of a list here?

472 00:52:58.570 ⇒ 00:52:59.360 Henry Zhao: Yeah, sure.

473 00:53:02.570 ⇒ 00:53:03.250 Uttam Kumaran: That’s amazing.

474 00:53:03.250 ⇒ 00:53:04.470 Henry Zhao: Give me access to this donkey.

475 00:53:05.350 ⇒ 00:53:06.070 Uttam Kumaran: Yes.

476 00:53:14.570 ⇒ 00:53:17.390 Uttam Kumaran: And then, let me get you access to…

477 00:54:39.950 ⇒ 00:54:43.980 Uttam Kumaran: Yeah, basically, we can just have… you can just list the PDT, or, like.

478 00:54:44.220 ⇒ 00:54:47.080 Uttam Kumaran: The view, maybe the link, and then…

479 00:54:48.120 ⇒ 00:54:54.320 Uttam Kumaran: Ideally, it’s like, for each of them, we can have a ticket, and then, a PR.

480 00:54:54.750 ⇒ 00:54:56.880 Uttam Kumaran: And all of these kind of get moved to…

481 00:54:58.480 ⇒ 00:55:06.539 Uttam Kumaran: Well, this is sort of like… this is where we’re gonna have, like, our dbt PR, and then we’re gonna have our, like, Looker PR once dbt is merged.

482 00:55:07.030 ⇒ 00:55:26.579 Uttam Kumaran: we then can move the view to select from that. The other piece is not every, view needs to get moved, so I think another thing that could be helpful is just to also look at how many times the view has been queried. I don’t know if you used a… I assume you’ve used, like, the system activity, like, you know, you go and see

483 00:55:27.150 ⇒ 00:55:28.200 Uttam Kumaran: Queries.

484 00:55:28.670 ⇒ 00:55:29.750 Uttam Kumaran: purview.

485 00:55:30.410 ⇒ 00:55:32.210 Emily Giant: Yeah, I’ll figure it out. Yeah.

486 00:55:32.210 ⇒ 00:55:33.120 Uttam Kumaran: Okay, today.

487 00:55:33.720 ⇒ 00:55:34.909 Emily Giant: Select your confidence.

488 00:55:35.770 ⇒ 00:55:39.530 Uttam Kumaran: You go under System Activity, you’ll just basically…

489 00:55:40.420 ⇒ 00:55:42.650 Uttam Kumaran: You could just type in the view and then query, like.

490 00:55:42.780 ⇒ 00:55:44.919 Uttam Kumaran: The number of times it’s been used.

491 00:55:45.630 ⇒ 00:55:48.409 Uttam Kumaran: Ideally, we could just nix them if we need to.

492 01:07:46.930 ⇒ 01:07:48.780 Uttam Kumaran: God, why is this not working?

493 01:08:23.359 ⇒ 01:08:24.890 Uttam Kumaran: Oh, look at it there.

494 01:08:36.200 ⇒ 01:08:36.920 Uttam Kumaran: Professor.

495 01:08:41.859 ⇒ 01:08:44.079 Uttam Kumaran: No,

496 01:08:57.170 ⇒ 01:08:58.820 Uttam Kumaran: But the main building.

497 01:09:11.930 ⇒ 01:09:13.200 Uttam Kumaran: About that…

498 01:09:31.729 ⇒ 01:09:33.369 Uttam Kumaran: Yeah. Bye.

499 01:09:38.000 ⇒ 01:09:40.369 Uttam Kumaran: Oh, Martian, okay, alright.

500 01:09:42.180 ⇒ 01:09:42.990 Uttam Kumaran: Amazing.

501 01:10:25.040 ⇒ 01:10:28.159 Henry Zhao: There’s some PDTs that fail, should we ignore those, or…

502 01:10:29.710 ⇒ 01:10:31.590 Uttam Kumaran: Which ones?

503 01:10:33.070 ⇒ 01:10:36.880 Henry Zhao: Just, there’s just 4 PDTs that fail with build errors.

504 01:10:38.320 ⇒ 01:10:40.040 Henry Zhao: Just curious if there’s a deputy or something.

505 01:10:40.630 ⇒ 01:10:45.179 Uttam Kumaran: I feel like they probably haven’t been deprecated, but, which ones are they?

506 01:10:45.930 ⇒ 01:10:50.300 Henry Zhao: Attached products arrive table, component economics, KPI components, and KPI orders.

507 01:10:55.940 ⇒ 01:10:56.840 Uttam Kumaran: Emily?

508 01:10:56.840 ⇒ 01:10:58.070 Emily Giant: I’m thinking.

509 01:10:58.500 ⇒ 01:10:59.890 Uttam Kumaran: Okay.

510 01:11:02.590 ⇒ 01:11:04.450 Henry Zhao: I mean, if they’re…

511 01:11:04.450 ⇒ 01:11:07.760 Uttam Kumaran: Yeah, put them in, and if they haven’t been running.

512 01:11:07.760 ⇒ 01:11:13.769 Emily Giant: Yeah, my thought is that… If I haven’t heard from someone about that.

513 01:11:14.170 ⇒ 01:11:15.790 Emily Giant: Then no one is using it.

514 01:11:15.790 ⇒ 01:11:16.930 Henry Zhao: Remember? Yeah.

515 01:11:17.650 ⇒ 01:11:19.350 Henry Zhao: I don’t know if that’s a long time or not.

516 01:11:21.060 ⇒ 01:11:22.759 Uttam Kumaran: When was the last to open?

517 01:11:23.950 ⇒ 01:11:27.499 Henry Zhao: The last time it was successful was September 13th-ish.

518 01:11:28.790 ⇒ 01:11:30.459 Emily Giant: Yeah, I’m not too worried about it.

519 01:11:31.020 ⇒ 01:11:31.710 Henry Zhao: Okay.

520 01:11:54.170 ⇒ 01:11:56.249 Henry Zhao: I mean, KPI orders sounds like an important one, but…

521 01:11:57.790 ⇒ 01:12:01.680 Emily Giant: It does, but you’d be surprised.

522 01:12:03.300 ⇒ 01:12:10.939 Uttam Kumaran: Yeah, they all sound… when I saw Pandera Paradigm, I was like, this sounds like some type of X-Men movie.

523 01:12:10.940 ⇒ 01:12:14.930 Emily Giant: It does, which it probably is. If Steven had, like.

524 01:12:15.040 ⇒ 01:12:18.510 Emily Giant: Free reign of all of it, so…

525 01:12:19.570 ⇒ 01:12:20.250 Uttam Kumaran: Yeah.

526 01:12:21.110 ⇒ 01:12:21.970 Uttam Kumaran: That’s funny.

527 01:13:40.970 ⇒ 01:13:44.180 Uttam Kumaran: I guess, Emily, thoughts on how I can do a min…

528 01:13:45.870 ⇒ 01:13:49.380 Uttam Kumaran: Completed date as, like, a column.

529 01:13:50.800 ⇒ 01:13:52.079 Emily Giant: Let me think…

530 01:13:53.910 ⇒ 01:13:58.820 Uttam Kumaran: Basically, I wanna… I wanna find the last time anyone… some of these people queried.

531 01:14:00.950 ⇒ 01:14:03.639 Emily Giant: You’re gonna wanna do a custom expression.

532 01:14:03.770 ⇒ 01:14:08.329 Emily Giant: So if you click that, and then you can do… you can write men in there, and it should…

533 01:14:08.330 ⇒ 01:14:08.980 Uttam Kumaran: Okay.

534 01:14:10.950 ⇒ 01:14:13.230 Emily Giant: So, like, Min, yeah, you got it.

535 01:14:16.490 ⇒ 01:14:17.640 Uttam Kumaran: Hmm…

536 01:14:20.270 ⇒ 01:14:21.930 Henry Zhao: I’ll figure this out for you, Tim.

537 01:14:23.450 ⇒ 01:14:29.500 Uttam Kumaran: Yeah, min of, like, history… I basically want to find the earliest time For…

538 01:14:29.990 ⇒ 01:14:36.940 Uttam Kumaran: I want to actually… it’s probably max, but, like, basically the latest time anyone’s queried, because then I’m gonna…

539 01:14:37.050 ⇒ 01:14:40.370 Uttam Kumaran: I’m gonna see who we need to… if we need to get rid of any people.

540 01:14:40.700 ⇒ 01:14:44.489 Emily Giant: You have to write the entire schema and field.

541 01:14:44.770 ⇒ 01:14:57.140 Emily Giant: And that’s probably why it’s failing. It should be, like, whatever the schema is called. If you go into, in use, if you already have that in… or not in use, go to the,

542 01:14:57.770 ⇒ 01:15:02.149 Emily Giant: History Completed, or whatever the field is called, and click on the little eye.

543 01:15:03.930 ⇒ 01:15:08.189 Uttam Kumaran: And then you can just copy, yeah, then you can just copy the name, yeah.

544 01:15:08.540 ⇒ 01:15:10.539 Emily Giant: Oh, that’s what it says, okay.

545 01:15:12.040 ⇒ 01:15:12.400 Henry Zhao: Right now.

546 01:15:12.400 ⇒ 01:15:17.620 Uttam Kumaran: Min must be a number or number list, but… oh, maybe there’s, like, max date or something.

547 01:15:18.400 ⇒ 01:15:19.469 Emily Giant: I bet you’re in.

548 01:15:21.180 ⇒ 01:15:24.150 Emily Giant: Looker has its own ridiculous rules.

549 01:15:26.050 ⇒ 01:15:28.550 Uttam Kumaran: Date, date, date, oh, ugh.

550 01:15:32.820 ⇒ 01:15:37.649 Uttam Kumaran: I guess I can ex… Doesn’t make sense. I can’t do, like, min.

551 01:15:37.910 ⇒ 01:15:38.960 Uttam Kumaran: Of a date?

552 01:15:41.190 ⇒ 01:15:42.630 Henry Zhao: Thought you could.

553 01:15:43.980 ⇒ 01:15:45.529 Emily Giant: I think you can.

554 01:15:46.630 ⇒ 01:15:48.910 Emily Giant: I’m almost sure you can.

555 01:15:49.420 ⇒ 01:15:50.960 Uttam Kumaran: Chatgpt.

556 01:15:51.200 ⇒ 01:15:56.790 Emily Giant: Create a… you can also create a custom field in the table of that.

557 01:15:56.790 ⇒ 01:15:57.469 Uttam Kumaran: And I shouldn’t.

558 01:15:57.470 ⇒ 01:15:58.120 Emily Giant: Beautiful.

559 01:15:58.570 ⇒ 01:15:59.700 Henry Zhao: Oh yeah, that’s true.

560 01:16:01.070 ⇒ 01:16:03.560 Emily Giant: I can’t believe I even still remember how to use Looker.

561 01:16:07.640 ⇒ 01:16:08.589 Henry Zhao: I thought Google was getting.

562 01:16:08.590 ⇒ 01:16:12.109 Emily Giant: That was not a very encouraging thing to say, sorry.

563 01:16:12.110 ⇒ 01:16:15.419 Uttam Kumaran: Oh, I think they… well, they basically have, like, slowed down development on everything.

564 01:16:15.600 ⇒ 01:16:16.440 Emily Giant: Yeah.

565 01:16:45.630 ⇒ 01:16:50.810 Uttam Kumaran: Oh, here it is. Okay, they already have one here. Okay, I’m stupid. This is the most recent quarter date.

566 01:16:50.810 ⇒ 01:16:52.890 Emily Giant: Looker, it’s stupid. Sorry.

567 01:16:58.040 ⇒ 01:17:02.950 Emily Giant: It’s… it’s after hours, so this is when I just, like, become a clown.

568 01:17:28.120 ⇒ 01:17:29.220 Emily Giant: This table is…

569 01:17:29.220 ⇒ 01:17:30.020 Uttam Kumaran: Okay.

570 01:17:30.020 ⇒ 01:17:31.740 Emily Giant: A mess.

571 01:17:37.030 ⇒ 01:17:39.239 Henry Zhao: They have a great team, they’re all using Looker.

572 01:17:39.820 ⇒ 01:17:41.200 Emily Giant: Yeah.

573 01:17:41.200 ⇒ 01:17:41.930 Henry Zhao: It’s never the.

574 01:17:41.930 ⇒ 01:17:48.760 Uttam Kumaran: Yeah, I just… I just want to double check. I feel like if this is everybody, then we’re actually… not much so due here on the…

575 01:17:49.810 ⇒ 01:17:51.460 Uttam Kumaran: User side…

576 01:17:52.440 ⇒ 01:17:55.159 Emily Giant: Makes sense. Jesse’s power user…

577 01:17:55.980 ⇒ 01:18:00.109 Emily Giant: Manakshi, Jess Campbell’s the one that I’m like, I would love to get that FedEx.

578 01:18:00.210 ⇒ 01:18:01.020 Emily Giant: Or the shipping.

579 01:18:01.020 ⇒ 01:18:01.900 Uttam Kumaran: Yeah, yeah. Right.

580 01:18:01.900 ⇒ 01:18:04.000 Emily Giant: For her, she’s such a champ.

581 01:18:39.000 ⇒ 01:18:45.980 Uttam Kumaran: Maybe a better thing is just to get your eyes on this, which is… Hmm…

582 01:18:53.920 ⇒ 01:19:02.239 Uttam Kumaran: I mean, all these folks are using it every day. I guess the thing I’m… I’m worried about is…

583 01:19:02.520 ⇒ 01:19:05.600 Uttam Kumaran: There’s 140 users here.

584 01:19:06.140 ⇒ 01:19:08.709 Uttam Kumaran: But are these… oh, these are all disabled books.

585 01:19:08.970 ⇒ 01:19:11.589 Emily Giant: Oh, I was like, what?

586 01:19:13.640 ⇒ 01:19:17.729 Uttam Kumaran: So, I guess my question is, can I go ahead and delete some of these people?

587 01:19:18.210 ⇒ 01:19:19.010 Emily Giant: Yeah.

588 01:19:20.380 ⇒ 01:19:21.590 Uttam Kumaran: Is there anyone…

589 01:19:21.980 ⇒ 01:19:29.839 Uttam Kumaran: If I scroll down slowly, is there anyone here that is disabled that you would not like me to just delete their account?

590 01:19:30.630 ⇒ 01:19:32.819 Emily Giant: No, I’ve gone through this recently, so…

591 01:19:32.820 ⇒ 01:19:34.389 Uttam Kumaran: Okay, okay, so then I’m just gonna…

592 01:19:34.390 ⇒ 01:19:41.189 Emily Giant: Maybe Steven. Don’t delete Steven, just because some of the schedules are built in his name, and I would need to switch those all over.

593 01:19:43.290 ⇒ 01:19:46.749 Uttam Kumaran: Yeah, so schedules created by the user, that user content will be deleted.

594 01:19:48.150 ⇒ 01:19:53.049 Uttam Kumaran: Their looks and dashboards will be moved to the trash. Oh, but you can reassign schedules.

595 01:19:53.050 ⇒ 01:19:54.390 Emily Giant: Yeah, exactly.

596 01:19:55.020 ⇒ 01:19:57.990 Uttam Kumaran: Oh, so what I’m gonna… oh, let’s actually…

597 01:20:03.630 ⇒ 01:20:06.849 Uttam Kumaran: Oh, okay, so let me go… let’s actually… let’s do this first, then.

598 01:20:07.030 ⇒ 01:20:09.150 Uttam Kumaran: Are there any schedules here?

599 01:20:09.710 ⇒ 01:20:21.060 Uttam Kumaran: not owned by you, that should just be moved to you, or… are any of these folks no longer… are any of these folks RIP that I can start to just migrate it to you?

600 01:20:21.060 ⇒ 01:20:24.420 Emily Giant: Nope. I actually think that I did this really recently.

601 01:20:24.420 ⇒ 01:20:25.140 Uttam Kumaran: Okay.

602 01:20:25.430 ⇒ 01:20:27.490 Emily Giant: Cause this all looks up-to-date.

603 01:20:28.010 ⇒ 01:20:28.680 Uttam Kumaran: Okay.

604 01:20:29.150 ⇒ 01:20:33.230 Emily Giant: Except Perry. If any are owned by Perry, they need to be moved.

605 01:20:34.160 ⇒ 01:20:35.829 Emily Giant: And they should be moved to me.

606 01:20:36.410 ⇒ 01:20:37.220 Uttam Kumaran: Okay.

607 01:21:12.430 ⇒ 01:21:13.880 Uttam Kumaran: Shoids, that’s fun.

608 01:21:20.390 ⇒ 01:21:21.300 Uttam Kumaran: Oops.

609 01:21:34.880 ⇒ 01:21:37.390 Uttam Kumaran: This looks like it’s an email to Perry.

610 01:21:37.520 ⇒ 01:21:39.700 Uttam Kumaran: Weekly non-some demand overview?

611 01:21:40.290 ⇒ 01:21:48.910 Emily Giant: Yeah, you can… you can X that. Actually, she’s consulting for now. Okay. Yeah, just change the schedule over to me. It can still send to her.

612 01:21:48.910 ⇒ 01:21:51.369 Uttam Kumaran: Yeah, this is, this is… this is owned by you, I guess I was just…

613 01:21:51.370 ⇒ 01:21:52.249 Emily Giant: Yeah, that’s fine.

614 01:21:53.380 ⇒ 01:21:58.950 Uttam Kumaran: you know, when you get into these, you sort of like, oh, let me just go, like, let me clean that up and clean that up, so I’m just sort of like…

615 01:22:00.160 ⇒ 01:22:02.980 Emily Giant: days of my life. Those are actually my happy days.

616 01:22:03.850 ⇒ 01:22:08.749 Emily Giant: No, this is… I was talking to the team today, I was like, this is sort of like ASMR work for me, I just, like.

617 01:22:08.750 ⇒ 01:22:10.610 Uttam Kumaran: Yeah. I kinda like doing this, but you…

618 01:22:10.770 ⇒ 01:22:12.390 Uttam Kumaran: You do kinda need to, like.

619 01:22:12.750 ⇒ 01:22:16.919 Uttam Kumaran: Just, like, kind of block off time, because you end up just, like, going down the rabbit hole.

620 01:22:17.430 ⇒ 01:22:23.010 Emily Giant: And doing it for 2 weeks, and doing nothing else, and breaking things, because people aren’t watching you. Yeah.

621 01:22:23.010 ⇒ 01:22:23.820 Uttam Kumaran: Yeah.

622 01:22:34.280 ⇒ 01:22:37.400 Emily Giant: My favorite, I think, in this is the…

623 01:22:37.700 ⇒ 01:22:45.960 Emily Giant: duplicate columns of, like, order contains purchased vase. Order contains vase. Like, why isn’t the vase purchased? I don’t understand.

624 01:22:46.620 ⇒ 01:22:47.480 Emily Giant: Odor contains.

625 01:22:47.480 ⇒ 01:22:48.210 Uttam Kumaran: approved.

626 01:22:48.210 ⇒ 01:22:52.400 Emily Giant: Purchased non-vace add-on. Those are going away. Forever.

627 01:22:52.400 ⇒ 01:22:54.779 Uttam Kumaran: Hey, that’s just the opposite of the first one.

628 01:22:54.780 ⇒ 01:22:56.970 Emily Giant: I know. Or is it?

629 01:22:57.640 ⇒ 01:22:59.419 Uttam Kumaran: Yeah, actually, I don’t know.

630 01:23:28.780 ⇒ 01:23:30.569 Uttam Kumaran: Alright, space will clean that up.

631 01:23:31.220 ⇒ 01:23:32.229 Uttam Kumaran: Now, let’s go.

632 01:23:42.930 ⇒ 01:23:47.440 Uttam Kumaran: Well, I guess my trouble is… how many of these people are still…

633 01:24:09.650 ⇒ 01:24:14.030 Uttam Kumaran: I guess, Emily, are there any other people on this list that, like…

634 01:24:14.890 ⇒ 01:24:18.900 Uttam Kumaran: Alright, you just said… you said you went through… was there anyone else here that is not…

635 01:24:21.180 ⇒ 01:24:22.930 Emily Giant: No, those are all…

636 01:24:23.830 ⇒ 01:24:24.600 Uttam Kumaran: on the team.

637 01:24:24.600 ⇒ 01:24:26.530 Emily Giant: Who is Jason Garcia?

638 01:24:28.400 ⇒ 01:24:29.210 Uttam Kumaran: Where’s Jason?

639 01:24:29.210 ⇒ 01:24:33.940 Emily Giant: Theo… Theo Buchheimer hasn’t been here for years. I saw a Jason, like, J-E-I.

640 01:24:33.940 ⇒ 01:24:34.780 Uttam Kumaran: Jason.

641 01:24:34.980 ⇒ 01:24:35.610 Uttam Kumaran: Yeah,

642 01:24:35.610 ⇒ 01:24:36.860 Emily Giant: Yeah, yeah.

643 01:24:38.370 ⇒ 01:24:46.940 Emily Giant: Bouquet inventory received past week. I bet you anything he’s from one of the 3Ps. He’s probably a 3P manager, I wouldn’t change that.

644 01:24:47.230 ⇒ 01:24:51.520 Emily Giant: It looks like her mom may have set that up, but Theo can go.

645 01:24:52.370 ⇒ 01:24:53.180 Uttam Kumaran: Okay.

646 01:24:59.080 ⇒ 01:25:06.860 Emily Giant: Can I see what… what it is that, Catalina Nieto, rollover order summary.

647 01:25:08.250 ⇒ 01:25:10.770 Emily Giant: I… something tells me these are just, like.

648 01:25:11.340 ⇒ 01:25:19.059 Emily Giant: not at all updated with inventory data, because I know… I know that team.

649 01:25:19.400 ⇒ 01:25:20.960 Emily Giant: Whatever.

650 01:25:20.960 ⇒ 01:25:24.589 Uttam Kumaran: I can just send you the screenshot, and you can be like, hey, are you using this?

651 01:25:24.590 ⇒ 01:25:26.210 Emily Giant: I… yeah. Okay.

652 01:25:26.900 ⇒ 01:25:27.980 Uttam Kumaran: I’m gonna send it to you.

653 01:25:28.870 ⇒ 01:25:29.710 Emily Giant: Thank you.

654 01:25:33.300 ⇒ 01:25:35.799 Demilade Agboola: So some people are using old inventory data?

655 01:25:37.580 ⇒ 01:25:42.310 Emily Giant: I mean, if they are, they’re probably really worried about the state of the business, because we turned it off in May.

656 01:25:43.060 ⇒ 01:25:43.575 Demilade Agboola: Bye.

657 01:25:44.300 ⇒ 01:25:45.160 Emily Giant: Yeah.

658 01:25:47.460 ⇒ 01:25:48.750 Demilade Agboola: Yeah.

659 01:25:59.120 ⇒ 01:26:04.789 Uttam Kumaran: Okay, I just want to kind of keep a Rolodex of, like, who is… who these folks are. Andy Zalan?

660 01:26:07.540 ⇒ 01:26:17.599 Emily Giant: Oh yeah, he is our, head of careers, so that’s probably… You know what, though? I think you can kill that template, because we don’t use dispatch anymore.

661 01:26:18.370 ⇒ 01:26:20.000 Emily Giant: We switched 2 weeks ago.

662 01:26:23.530 ⇒ 01:26:26.360 Uttam Kumaran: Okay, so I can just delete this one…

663 01:26:26.360 ⇒ 01:26:27.200 Emily Giant: Yeah.

664 01:26:33.010 ⇒ 01:26:33.750 Uttam Kumaran: Okay.

665 01:26:34.560 ⇒ 01:26:37.439 Uttam Kumaran: I’m roughly not seeing most of these folks anyways, so…

666 01:26:57.360 ⇒ 01:26:58.160 Uttam Kumaran: Okay.

667 01:28:54.020 ⇒ 01:28:56.480 Uttam Kumaran: How’d it turn out on the PDTs, Henry?

668 01:28:59.710 ⇒ 01:29:00.330 Henry Zhao: That’s done.

669 01:29:01.390 ⇒ 01:29:01.940 Henry Zhao: What?

670 01:29:02.710 ⇒ 01:29:04.539 Henry Zhao: What do we do now to create the tickets?

671 01:29:05.600 ⇒ 01:29:07.600 Uttam Kumaran: Yes.

672 01:29:08.270 ⇒ 01:29:09.669 Uttam Kumaran: I guess…

673 01:29:12.780 ⇒ 01:29:18.499 Uttam Kumaran: And all… you confirmed… can you… did you confirm that all of these have been queried recently?

674 01:29:20.180 ⇒ 01:29:23.319 Uttam Kumaran: The one thing you can do is if you go into,

675 01:29:24.660 ⇒ 01:29:26.609 Uttam Kumaran: If you go into History here.

676 01:29:26.820 ⇒ 01:29:30.219 Uttam Kumaran: You can actually just go type in, like, the…

677 01:29:31.100 ⇒ 01:29:39.099 Uttam Kumaran: Where is it? I think there’s, like, a history table for… Hmm… I think it’s con…

678 01:29:41.980 ⇒ 01:29:43.689 Uttam Kumaran: Is it content usage?

679 01:29:44.200 ⇒ 01:29:44.970 Uttam Kumaran: Art.

680 01:29:45.840 ⇒ 01:29:51.400 Uttam Kumaran: Actually, here, if you go and you type in… query…

681 01:29:52.260 ⇒ 01:29:59.580 Uttam Kumaran: I think you can filter the query… And just put in the…

682 01:30:04.800 ⇒ 01:30:07.650 Uttam Kumaran: Like, put in the view name, and you can actually see, like.

683 01:30:07.880 ⇒ 01:30:11.049 Uttam Kumaran: If that view has ever been queried before.

684 01:30:12.000 ⇒ 01:30:13.379 Henry Zhao: Yeah, I’ll look at it.

685 01:30:13.780 ⇒ 01:30:17.709 Uttam Kumaran: Okay, I would say just, like, if you can put that in, and then we can…

686 01:30:19.190 ⇒ 01:30:24.869 Uttam Kumaran: basically get signed off from Emily and create tickets for each of those, and then that’ll knock that out. Should be great.

687 01:30:29.760 ⇒ 01:30:38.170 Emily Giant: Okay, question. If something’s used, but it absolutely shouldn’t be in this table, like, for example, all this, like, move to marketing or customer view stuff.

688 01:30:38.560 ⇒ 01:30:41.930 Emily Giant: I put no, but it is used, it just shouldn’t be in this table.

689 01:30:42.810 ⇒ 01:30:49.049 Uttam Kumaran: Then what we’re gonna… then there’s a third category, which is basically…

690 01:30:49.440 ⇒ 01:30:58.159 Uttam Kumaran: we will have to figure out how to support it elsewhere, but, like, not… basically, we’ll have to keep pulling it from Tableau items from now… for now.

691 01:30:58.160 ⇒ 01:30:58.930 Emily Giant: Yeah.

692 01:30:59.520 ⇒ 01:31:02.430 Uttam Kumaran: Like, so that’s what I would flag it on, is, like.

693 01:31:02.590 ⇒ 01:31:10.390 Uttam Kumaran: We have to… for everything else that isn’t sort of covered, that’s what prioritizes, like, the next couple models to build.

694 01:31:11.070 ⇒ 01:31:11.720 Emily Giant: Okay.

695 01:31:12.750 ⇒ 01:31:19.040 Demilade Agboola: Yeah, because, like, the focus now is revenue, and obviously long-term, there are other things to handle beyond revenue.

696 01:31:21.230 ⇒ 01:31:21.869 Uttam Kumaran: I don’t know.

697 01:31:23.090 ⇒ 01:31:27.279 Emily Giant: All this lifetime stuff should not be in the revenue table.

698 01:31:59.810 ⇒ 01:32:02.269 Uttam Kumaran: Where do you go to… where do you… where can you see trash?

699 01:32:04.250 ⇒ 01:32:04.870 Uttam Kumaran: Forgot.

700 01:32:04.870 ⇒ 01:32:05.970 Emily Giant: Trash?

701 01:32:06.310 ⇒ 01:32:08.549 Emily Giant: I actually don’t know.

702 01:32:08.860 ⇒ 01:32:11.809 Emily Giant: It liquor’s kind of like a dark hole in that way.

703 01:32:19.400 ⇒ 01:32:22.040 Uttam Kumaran: They’re located under the folders item.

704 01:32:22.590 ⇒ 01:32:23.860 Uttam Kumaran: Oh, here.

705 01:32:24.560 ⇒ 01:32:25.830 Uttam Kumaran: Trashed.

706 01:32:27.220 ⇒ 01:32:28.420 Uttam Kumaran: Lovely!

707 01:34:45.750 ⇒ 01:34:47.440 Uttam Kumaran: Okay, empty trash.

708 01:34:50.440 ⇒ 01:34:51.680 Uttam Kumaran: Very nice.

709 01:34:52.090 ⇒ 01:34:53.090 Emily Giant: Yay!

710 01:35:02.520 ⇒ 01:35:03.290 Emily Giant: Okay.

711 01:35:09.930 ⇒ 01:35:16.739 Uttam Kumaran: And look, there’s 1421 pieces of content, haven’t been used since 12 months from now… 12 months ago.

712 01:35:18.180 ⇒ 01:35:19.310 Emily Giant: Delete.

713 01:35:19.840 ⇒ 01:35:21.790 Uttam Kumaran: Delete.

714 01:35:21.790 ⇒ 01:35:22.630 Emily Giant: Yay!

715 01:35:23.330 ⇒ 01:35:23.950 Emily Giant: Just do it.

716 01:35:23.950 ⇒ 01:35:28.350 Uttam Kumaran: literally… You’re like the…

717 01:35:28.550 ⇒ 01:35:34.120 Uttam Kumaran: You’re like, how do I describe it? I guess it is Veterans Day, I was gonna say, though, you’re like an old war vet, you’re like…

718 01:35:34.930 ⇒ 01:35:36.630 Uttam Kumaran: Just give now.

719 01:35:36.920 ⇒ 01:35:39.399 Emily Giant: Yeah, that’s how I am with most things.

720 01:35:39.400 ⇒ 01:35:40.039 Uttam Kumaran: Like, it’s good.

721 01:35:40.040 ⇒ 01:35:41.209 Emily Giant: I’ll go with it.

722 01:35:42.500 ⇒ 01:35:43.809 Uttam Kumaran: That’s so funny.

723 01:35:45.810 ⇒ 01:35:54.280 Emily Giant: Oh, just… you should ask Matthew, my partner, if he leaves something out that even slightly resembles trash, he’ll never see it again.

724 01:35:55.580 ⇒ 01:35:58.000 Uttam Kumaran: Delete.

725 01:35:58.140 ⇒ 01:35:58.740 Emily Giant: late.

726 01:35:59.340 ⇒ 01:36:01.420 Uttam Kumaran: Delayed.

727 01:36:01.570 ⇒ 01:36:02.600 Uttam Kumaran: That’s funny.

728 01:36:02.960 ⇒ 01:36:04.060 Emily Giant: Do it!

729 01:36:07.340 ⇒ 01:36:14.740 Uttam Kumaran: Okay, so I’m just gonna note down some stats as we keep going here. So that’s almost, like, I would say 3,000…

730 01:36:14.970 ⇒ 01:36:18.610 Uttam Kumaran: pieces of content, so those dashboards and looks.

731 01:36:19.270 ⇒ 01:36:20.370 Emily Giant: Oh my gosh.

732 01:36:23.620 ⇒ 01:36:25.169 Emily Giant: That’s a beautiful thing.

733 01:36:26.570 ⇒ 01:36:31.329 Uttam Kumaran: Yeah… Okay, that’s something done.

734 01:36:33.050 ⇒ 01:36:34.930 Uttam Kumaran: Let’s take a look at…

735 01:36:41.100 ⇒ 01:36:42.380 Uttam Kumaran: boulders.

736 01:36:47.350 ⇒ 01:36:48.810 Emily Giant: I was just doing that.

737 01:36:54.720 ⇒ 01:36:56.590 Uttam Kumaran: Just getting the lay of the land.

738 01:36:58.700 ⇒ 01:37:06.149 Uttam Kumaran: Couple of these can go… Love that you have to type in the name of the…

739 01:37:06.740 ⇒ 01:37:08.490 Emily Giant: Yeah, isn’t that terrifying?

740 01:37:10.320 ⇒ 01:37:13.690 Uttam Kumaran: That that’s what, that, like… wait, what’s terrifying?

741 01:37:13.770 ⇒ 01:37:22.829 Emily Giant: Some of the stuff that you can, that you must type in manually, like, if you’re doing a content validation, you could replace

742 01:37:23.020 ⇒ 01:37:28.839 Emily Giant: Every… field with something that does not exist, no problem. And it will do it.

743 01:37:29.510 ⇒ 01:37:32.910 Uttam Kumaran: And they changed the contrast of this. It used to not be this red.

744 01:37:34.920 ⇒ 01:37:38.379 Uttam Kumaran: Oh, that’s very good. Someone’s still cooking behind the scenes.

745 01:37:40.010 ⇒ 01:37:42.150 Emily Giant: There’s, there’s that one guy.

746 01:37:42.570 ⇒ 01:37:48.760 Uttam Kumaran: There’s one, dude. Wait, Henry, where did you, where’d you use Looker before? At Uber?

747 01:37:48.990 ⇒ 01:37:51.149 Henry Zhao: At a dental company.

748 01:37:52.410 ⇒ 01:37:53.150 Uttam Kumaran: Nice.

749 01:37:53.610 ⇒ 01:37:56.220 Henry Zhao: There were, like, 20 dentists just using Looker to pull data.

750 01:37:56.790 ⇒ 01:37:57.800 Emily Giant: Oh my god.

751 01:37:58.270 ⇒ 01:37:59.890 Henry Zhao: They, like, knew nothing about data.

752 01:38:00.260 ⇒ 01:38:06.520 Emily Giant: I was gonna say, that sounds like the last group of humans that I could imagine using Dana.

753 01:38:08.290 ⇒ 01:38:15.090 Emily Giant: No offense if you have dentists in the family, they just are not the ones in my life of…

754 01:38:19.280 ⇒ 01:38:20.440 Henry Zhao: Absolutely.

755 01:38:31.260 ⇒ 01:38:33.080 Uttam Kumaran: Emily, can I ditch these two?

756 01:38:34.700 ⇒ 01:38:35.310 Emily Giant: Yeah.

757 01:38:36.620 ⇒ 01:38:37.810 Emily Giant: Big time.

758 01:38:57.490 ⇒ 01:38:59.240 Uttam Kumaran: And MDay23.

759 01:38:59.860 ⇒ 01:39:00.680 Emily Giant: Yep.

760 01:39:15.550 ⇒ 01:39:16.380 Uttam Kumaran: Yeah.

761 01:39:18.870 ⇒ 01:39:20.090 Uttam Kumaran: Oh, okay.

762 01:39:36.460 ⇒ 01:39:38.999 Emily Giant: Okay, I can also deploy a bunch of the, like.

763 01:39:39.870 ⇒ 01:39:43.840 Emily Giant: Never mind. Just got 64 errors. Hold, please.

764 01:39:45.160 ⇒ 01:39:46.200 Uttam Kumaran: Hold, please.

765 01:40:19.910 ⇒ 01:40:24.129 Uttam Kumaran: Product cost and slippage, past spoilage, weekly use breakdown.

766 01:40:29.360 ⇒ 01:40:30.540 Emily Giant: Yeah, we good.

767 01:40:30.770 ⇒ 01:40:32.750 Emily Giant: No, it’s… no.

768 01:40:33.470 ⇒ 01:40:38.650 Emily Giant: Any inventory thing that’s older than May is not working anymore.

769 01:40:39.510 ⇒ 01:40:40.120 Uttam Kumaran: Okay.

770 01:40:40.280 ⇒ 01:40:45.000 Emily Giant: That one you can delete. That was just what I gave to people when they were doing the testing.

771 01:40:45.890 ⇒ 01:40:46.420 Uttam Kumaran: Okay.

772 01:40:48.630 ⇒ 01:40:50.680 Uttam Kumaran: Recipient to sender.

773 01:40:53.030 ⇒ 01:40:55.200 Emily Giant: Oh, no, I don’t think so.

774 01:40:55.930 ⇒ 01:40:57.130 Uttam Kumaran: 40 months.

775 01:41:00.990 ⇒ 01:41:05.129 Uttam Kumaran: Promotions and gift cards, these are also 35 months ago.

776 01:41:14.810 ⇒ 01:41:16.919 Uttam Kumaran: Sentiment of Send.

777 01:41:19.160 ⇒ 01:41:21.590 Emily Giant: Oh, God, I don’t… yeah, I don’t think so.

778 01:41:23.770 ⇒ 01:41:29.339 Uttam Kumaran: I’m gonna move these all to trash, so they’re not, like… you know, next week we’ll hit the empty.

779 01:41:30.100 ⇒ 01:41:32.819 Uttam Kumaran: Next week, we’ll hit the delete.

780 01:41:33.790 ⇒ 01:41:34.800 Uttam Kumaran: Delete.

781 01:41:36.260 ⇒ 01:41:37.980 Emily Giant: That sounds really good.

782 01:41:48.440 ⇒ 01:41:54.519 Uttam Kumaran: So, maybe if you can give me a look on these. So, these are all in the top-level retention and segmentation dash.

783 01:41:55.920 ⇒ 01:41:57.690 Uttam Kumaran: These all look pretty old.

784 01:41:58.960 ⇒ 01:42:01.559 Uttam Kumaran: And… low view count.

785 01:42:02.340 ⇒ 01:42:08.230 Emily Giant: Yeah, anything by Jeremy can go away. Anything PK has made recently, I would not.

786 01:42:09.280 ⇒ 01:42:13.089 Uttam Kumaran: Yeah, I’m not touching anything from anybody that I… that I kind of know, like, even…

787 01:42:13.090 ⇒ 01:42:13.750 Emily Giant: Yeah.

788 01:42:13.750 ⇒ 01:42:15.889 Uttam Kumaran: It’s not from Chris, I’m just gonna leave, but…

789 01:42:16.360 ⇒ 01:42:17.040 Emily Giant: Yeah, the other one.

790 01:42:17.040 ⇒ 01:42:17.870 Uttam Kumaran: This is, like, an older one.

791 01:42:17.870 ⇒ 01:42:20.140 Emily Giant: If they have a low view count, it’s fine.

792 01:42:44.440 ⇒ 01:42:46.830 Uttam Kumaran: Henry, did you end up finding the PDT thing?

793 01:42:47.950 ⇒ 01:42:51.959 Henry Zhao: Not yet, it’s not that simple. You guys use BigQuery, right?

794 01:42:53.010 ⇒ 01:42:53.400 Uttam Kumaran: Congratulations.

795 01:42:53.400 ⇒ 01:42:54.210 Emily Giant: That’s right.

796 01:42:54.590 ⇒ 01:42:55.399 Henry Zhao: She’s like, okay.

797 01:42:58.070 ⇒ 01:43:01.150 Uttam Kumaran: It’s also fine, we can move them over.

798 01:43:01.430 ⇒ 01:43:02.450 Henry Zhao: There’s not that many.

799 01:43:04.530 ⇒ 01:43:05.420 Uttam Kumaran: Okay.

800 01:43:05.670 ⇒ 01:43:10.300 Uttam Kumaran: Yeah, would you mind… Creating…

801 01:43:11.180 ⇒ 01:43:13.659 Uttam Kumaran: A ticket for each of them?

802 01:43:14.130 ⇒ 01:43:18.529 Uttam Kumaran: And then if you could just put the link to the view and the ticket, and then…

803 01:43:19.980 ⇒ 01:43:21.930 Uttam Kumaran: B, at least we have it tracked.

804 01:43:28.020 ⇒ 01:43:28.959 Henry Zhao: Sorry, say that again?

805 01:43:32.250 ⇒ 01:43:33.559 Henry Zhao: I miss what you just said.

806 01:43:33.980 ⇒ 01:43:35.629 Uttam Kumaran: Wait, say that again? Sorry.

807 01:43:35.630 ⇒ 01:43:37.019 Henry Zhao: I miss what you just said.

808 01:43:37.780 ⇒ 01:43:39.370 Uttam Kumaran: Oh, I just said,

809 01:43:40.470 ⇒ 01:43:47.739 Uttam Kumaran: If you just create a ticket and you put the link into the view, then we can probably… I can work on it later this week, moving some of those to dbt.

810 01:43:48.340 ⇒ 01:43:49.000 Henry Zhao: Okay.

811 01:44:33.030 ⇒ 01:44:35.150 Uttam Kumaran: Oh, there’s a FedEx one, okay.

812 01:45:56.590 ⇒ 01:45:59.109 Uttam Kumaran: Jeremy was on the data team at some point?

813 01:46:00.730 ⇒ 01:46:10.130 Emily Giant: Yeah, he was the original me. He was really good, but he was, clinically insane. So, a lot of the stuff in here is, like…

814 01:46:10.910 ⇒ 01:46:11.760 Uttam Kumaran: He worked on a lot of them.

815 01:46:11.760 ⇒ 01:46:13.129 Emily Giant: It’s wild.

816 01:46:13.950 ⇒ 01:46:15.210 Uttam Kumaran: Oh, really? Okay.

817 01:46:15.350 ⇒ 01:46:18.149 Emily Giant: Yeah, he’s worth… I see his name on everything, but…

818 01:46:18.150 ⇒ 01:46:23.319 Uttam Kumaran: He was a baller. He just quit one day without another job, because he wanted to hang out with his cats.

819 01:46:23.480 ⇒ 01:46:28.640 Emily Giant: And he was like, it’s alright. I’ll get another job when I want to, and he did.

820 01:46:29.920 ⇒ 01:46:31.309 Uttam Kumaran: I should give him a call.

821 01:46:31.690 ⇒ 01:46:32.380 Emily Giant: Right?

822 01:46:34.050 ⇒ 01:46:36.749 Emily Giant: I forget where he went to, somewhere awesome.

823 01:46:37.630 ⇒ 01:46:39.830 Emily Giant: But, like, I would put,

824 01:46:40.530 ⇒ 01:46:42.289 Emily Giant: Cal- like, things on his calendar.

825 01:46:43.110 ⇒ 01:46:52.399 Emily Giant: And… because I wanted to get Looker access, and nobody would give it to me when I started 3 years ago, and I was like, no, I swear I know how to use this. And finally, he was like.

826 01:46:52.580 ⇒ 01:47:00.219 Emily Giant: Okay, I’ll take the meeting. And he just literally talked to me about what to do about his sick dog the whole time. And I was like, oh, this is actually better than…

827 01:47:00.600 ⇒ 01:47:04.920 Emily Giant: learning look. I could probably manage that myself if you give me permissions, but…

828 01:47:05.190 ⇒ 01:47:06.160 Uttam Kumaran: That’s funny.

829 01:47:06.350 ⇒ 01:47:06.970 Emily Giant: Yeah.

830 01:47:11.020 ⇒ 01:47:19.320 Emily Giant: you would have all really liked both of the, BI engineers that worked here before me. They were really, really cool dudes.

831 01:47:20.980 ⇒ 01:47:23.660 Emily Giant: I guess that just comes with the territory.

832 01:47:23.910 ⇒ 01:47:27.880 Uttam Kumaran: It does! Hey, all the people on this call are all cool data people, so…

833 01:47:28.050 ⇒ 01:47:28.990 Emily Giant: No.

834 01:47:29.650 ⇒ 01:47:31.180 Emily Giant: What am I even looking at?

835 01:48:16.710 ⇒ 01:48:22.540 Emily Giant: I can deploy mine in a second here, so you can see all the ones, all of the views that are archived.

836 01:48:23.450 ⇒ 01:48:25.820 Emily Giant: And that way we can trash those, too.

837 01:48:41.250 ⇒ 01:48:43.680 Uttam Kumaran: So there is an inventory folder here.

838 01:48:44.020 ⇒ 01:48:46.409 Uttam Kumaran: I assume some of this stuff is still in use.

839 01:48:46.950 ⇒ 01:48:50.490 Uttam Kumaran: And then some of it is not, so I’m just gonna confirm.

840 01:48:50.900 ⇒ 01:49:05.040 Emily Giant: Yeah, anything that’s using, so I remade all of Felipe’s reports on Friday in that new polyatomic inventory report folder. Anything that’s based on Inventory XF or Inventory Transactions XF can just be deleted.

841 01:49:06.460 ⇒ 01:49:08.799 Uttam Kumaran: So, if you were to look at these.

842 01:49:09.510 ⇒ 01:49:13.450 Uttam Kumaran: This one I’m gonna leave, but… Piece 3.

843 01:49:15.620 ⇒ 01:49:16.880 Emily Giant: Yeah, delete them.

844 01:49:19.620 ⇒ 01:49:22.879 Emily Giant: You have my permission. I don’t even care if you delete important stuff at this point.

845 01:49:22.880 ⇒ 01:49:24.260 Uttam Kumaran: No, no, no.

846 01:49:24.260 ⇒ 01:49:26.349 Emily Giant: I’m mad that we let it get to this state.

847 01:49:26.350 ⇒ 01:49:32.550 Uttam Kumaran: I’m taking liberty, I just, like, in case something looks a little… Suspect, though.

848 01:49:32.550 ⇒ 01:49:34.819 Emily Giant: I mean, if you see Alex crawl on it, or…

849 01:49:34.820 ⇒ 01:49:36.140 Uttam Kumaran: Yeah, yeah, yeah, of course, of course.

850 01:49:36.140 ⇒ 01:49:38.839 Emily Giant: Maybe not, but, like, other than that…

851 01:50:01.000 ⇒ 01:50:06.739 Uttam Kumaran: I’m just worried that if people use something earlier this year, and there comes next year, and they’re like, where was that one thing?

852 01:50:06.860 ⇒ 01:50:09.200 Uttam Kumaran: But I guess, at that point, they can just ask.

853 01:50:09.910 ⇒ 01:50:21.420 Emily Giant: Well, that thing is so broken now, so… especially if it’s any of those inventory views, they… they don’t ingest data, and they never ingested it correctly, so who knows what they were even looking at.

854 01:50:23.720 ⇒ 01:50:24.980 Uttam Kumaran: For real…

855 01:50:57.160 ⇒ 01:50:59.570 Henry Zhao: Also, I’ve never seen so many schemas in Looker.

856 01:51:00.830 ⇒ 01:51:03.480 Emily Giant: Isn’t it just the dumbest thing you’ve ever seen?

857 01:51:04.400 ⇒ 01:51:05.750 Henry Zhao: No, it’s just a lot, man.

858 01:51:06.950 ⇒ 01:51:09.479 Emily Giant: You’re a kind person, I can tell.

859 01:51:14.090 ⇒ 01:51:18.230 Emily Giant: Okay, I am going to commit S.

860 01:51:20.750 ⇒ 01:51:26.889 Uttam Kumaran: And there’s this deprecated dashboards folder, should I move all these to archived, or can I just rep and delete on this?

861 01:51:27.550 ⇒ 01:51:30.090 Emily Giant: Yeah, just… rip it.

862 01:51:31.100 ⇒ 01:51:33.559 Emily Giant: That was from Kayo, I think.

863 01:51:33.560 ⇒ 01:51:35.070 Uttam Kumaran: Okay, cool. Then, yeah, then it’s…

864 01:51:35.070 ⇒ 01:51:37.379 Emily Giant: Those have already been, like, signed off on.

865 01:51:53.320 ⇒ 01:52:04.650 Emily Giant: And just a word of warning, Looker has a lag with, the error detection, so you might think you have no errors, and then 20 seconds later, it will populate with them, so…

866 01:52:05.630 ⇒ 01:52:11.179 Emily Giant: Make sure to wait, like, a full 1 minute before deploying any, like, major updates.

867 01:52:12.820 ⇒ 01:52:16.159 Uttam Kumaran: I can just delete the Okpo and custom…

868 01:52:16.260 ⇒ 01:52:19.549 Uttam Kumaran: Customer experience, this is nothing new.

869 01:52:20.130 ⇒ 01:52:20.770 Emily Giant: Yeah.

870 01:52:24.100 ⇒ 01:52:27.470 Uttam Kumaran: Great, I’m cruising. Let’s go.

871 01:52:28.030 ⇒ 01:52:29.610 Emily Giant: You… no, never mind.

872 01:53:01.620 ⇒ 01:53:07.400 Emily Giant: We can delete the entire, netSuite Cash Sales Model.

873 01:53:08.280 ⇒ 01:53:11.190 Emily Giant: Oh, okay.

874 01:53:12.450 ⇒ 01:53:13.620 Emily Giant: I don’t know.

875 01:53:15.150 ⇒ 01:53:18.100 Uttam Kumaran: There’s nothing in… there’s nothing in these subfolders, there’s just this one.

876 01:53:20.520 ⇒ 01:53:23.160 Uttam Kumaran: I mean, it has one view, I guess, if there’s someone really…

877 01:53:23.160 ⇒ 01:53:28.229 Emily Giant: Just delete it. It’s fine. I know how to rebuild it, if for any reason, someone decides to look at that.

878 01:53:28.540 ⇒ 01:53:33.000 Emily Giant: How do we feel about deleting the entire NetSuite cash sales model that was never used?

879 01:53:33.970 ⇒ 01:53:38.250 Uttam Kumaran: I feel good about that, but I would, merge whatever…

880 01:53:39.100 ⇒ 01:53:40.999 Uttam Kumaran: The thing is that you just did.

881 01:53:41.740 ⇒ 01:53:42.730 Uttam Kumaran: First. Okay.

882 01:53:44.020 ⇒ 01:53:46.789 Uttam Kumaran: Like, just keep merging incrementally, basically.

883 01:53:47.880 ⇒ 01:53:50.740 Emily Giant: Once I clear all of these errors, then I will.

884 01:55:23.320 ⇒ 01:55:30.830 Emily Giant: the one folder that would be… I think I even moved the current one into the new model structure folder is some of the,

885 01:55:31.440 ⇒ 01:55:39.429 Emily Giant: the forecast documents or views. Those would be the only things that, I wouldn’t archive.

886 01:55:39.870 ⇒ 01:55:42.410 Emily Giant: Sunday… And they’re in which one?

887 01:55:42.920 ⇒ 01:55:47.120 Emily Giant: Probably in, dear.

888 01:55:47.120 ⇒ 01:55:48.720 Uttam Kumaran: e-commerce forecast planning.

889 01:55:48.960 ⇒ 01:55:49.720 Emily Giant: Yeah.

890 01:55:49.870 ⇒ 01:55:57.689 Emily Giant: Oh, not even those, you can delete tons of those, just in the actual backend. More of, like, what we’re doing in the LookML.

891 01:55:58.320 ⇒ 01:55:59.420 Uttam Kumaran: Oh, okay.

892 01:56:00.060 ⇒ 01:56:02.899 Uttam Kumaran: Oh god, there’s a ton of, like, nested stuff here.

893 01:56:03.030 ⇒ 01:56:03.850 Uttam Kumaran: No.

894 01:56:03.850 ⇒ 01:56:04.820 Emily Giant: Doesn’t mean…

895 01:56:06.200 ⇒ 01:56:07.420 Uttam Kumaran: It’s fine.

896 01:56:07.870 ⇒ 01:56:08.660 Uttam Kumaran: Huh.

897 01:56:09.210 ⇒ 01:56:14.090 Uttam Kumaran: I’m just gonna avoid that one for now, I’m just gonna… Keep going.

898 01:56:56.580 ⇒ 01:56:58.519 Uttam Kumaran: Sticky V2 reporting.

899 01:56:58.890 ⇒ 01:57:00.920 Emily Giant: Oh my god, get rid of it.

900 01:57:01.100 ⇒ 01:57:04.459 Emily Giant: Wait, whoa, whoa, whoa, if there’s any…

901 01:57:05.230 ⇒ 01:57:09.379 Emily Giant: forecasting dashboards. Leave them, because I’m…

902 01:57:09.500 ⇒ 01:57:11.660 Emily Giant: Just gonna use them as a template.

903 01:57:12.240 ⇒ 01:57:12.950 Emily Giant: But you can…

904 01:57:12.950 ⇒ 01:57:13.490 Uttam Kumaran: Yeah, none of that.

905 01:57:13.490 ⇒ 01:57:14.080 Emily Giant: Good luck.

906 01:57:14.750 ⇒ 01:57:15.869 Emily Giant: Oh, those are all looks? Yeah.

907 01:57:15.870 ⇒ 01:57:18.009 Uttam Kumaran: Oh, yeah, these are all looks, yeah.

908 01:57:18.010 ⇒ 01:57:18.949 Emily Giant: Yeah, they can go.

909 01:57:28.520 ⇒ 01:57:31.950 Uttam Kumaran: Yeah, and I’m just gonna move everything to the, like, top level, basically.

910 01:57:32.610 ⇒ 01:57:33.250 Emily Giant: Okay.

911 01:57:34.790 ⇒ 01:57:35.870 Emily Giant: Perfect.

912 01:58:22.450 ⇒ 01:58:26.759 Uttam Kumaran: There’s this in month-end close, but it’s all looks.

913 01:58:27.720 ⇒ 01:58:29.919 Uttam Kumaran: From the mode migration model.

914 01:58:32.750 ⇒ 01:58:33.670 Emily Giant: Kill it.

915 01:58:44.900 ⇒ 01:58:50.229 Uttam Kumaran: Avoided Braintree. I’m just gonna… this whole finance thing, I think, is not… there’s nothing in here, anyways.

916 01:58:50.230 ⇒ 01:58:50.940 Emily Giant: Yeah.

917 01:59:41.190 ⇒ 01:59:43.120 Uttam Kumaran: How about these three?

918 01:59:43.310 ⇒ 01:59:46.050 Uttam Kumaran: Care buffer, EOM lots and amounts.

919 01:59:46.900 ⇒ 01:59:48.590 Emily Giant: No, gone.

920 01:59:50.050 ⇒ 01:59:57.249 Uttam Kumaran: And then there’s this Ops KPI Weekly scheduled data pull with a lot of views. Can I move that to somewhere more…

921 01:59:58.180 ⇒ 02:00:00.500 Emily Giant: We just need to move it into DBT.

922 02:00:00.820 ⇒ 02:00:06.150 Emily Giant: like, it’s… what is… mode is just SQL. So…

923 02:00:06.150 ⇒ 02:00:07.880 Uttam Kumaran: No, no, no, I think… oh.

924 02:00:08.130 ⇒ 02:00:10.550 Uttam Kumaran: Yeah, I guess I don’t even know what this is.

925 02:00:10.550 ⇒ 02:00:18.270 Emily Giant: The whole mode migration is for reports that used to be stored in mode, and then when we stopped paying for it, and got rid of the platform.

926 02:00:19.190 ⇒ 02:00:21.920 Emily Giant: we just moved the SQL into Looker.

927 02:00:22.240 ⇒ 02:00:28.239 Emily Giant: So, there’s a good chance that someone needs this, it just shouldn’t be in Looker, because it just slows it down like crazy.

928 02:00:28.790 ⇒ 02:00:32.959 Uttam Kumaran: So this one will get a… Oh, I don’t even… okay.

929 02:00:36.950 ⇒ 02:00:40.690 Uttam Kumaran: Okay, I’m gonna put that back in the closet for now.

930 02:00:44.180 ⇒ 02:00:46.000 Uttam Kumaran: That’s another variety.

931 02:00:46.330 ⇒ 02:00:52.070 Emily Giant: So many of these views don’t even… they’re not even added to the model. They’re just, like, sitting in here.

932 02:01:06.030 ⇒ 02:01:07.980 Uttam Kumaran: Yeah, that’s actually crazy, too.

933 02:01:09.100 ⇒ 02:01:10.950 Emily Giant: Like, so you just added this.

934 02:01:11.650 ⇒ 02:01:14.130 Emily Giant: And then didn’t do anything.

935 02:01:21.080 ⇒ 02:01:21.750 Uttam Kumaran: Okay.

936 02:03:19.750 ⇒ 02:03:23.899 Emily Giant: Someone left a note in this view that says.

937 02:03:24.670 ⇒ 02:03:29.030 Emily Giant: Fiscal columns are pulled directly from another model, and then it says, shruggy.

938 02:03:32.030 ⇒ 02:03:33.050 Emily Giant: I’m shruggy.

939 02:03:38.090 ⇒ 02:03:39.209 Uttam Kumaran: That’s funny.

940 02:03:42.970 ⇒ 02:03:48.209 Emily Giant: the assuredness that people had that nobody looked at Looker, except for them.

941 02:03:48.210 ⇒ 02:03:48.980 Uttam Kumaran: No.

942 02:03:49.340 ⇒ 02:03:50.470 Emily Giant: astounding.

943 02:03:54.550 ⇒ 02:03:56.079 Uttam Kumaran: Just writing some notes.

944 02:03:56.190 ⇒ 02:03:58.650 Uttam Kumaran: Like, for yourself on the wall, like, it’s like…

945 02:03:59.420 ⇒ 02:04:00.579 Uttam Kumaran: At a prison.

946 02:04:48.140 ⇒ 02:04:48.800 Emily Giant: Thank you.

947 02:05:05.220 ⇒ 02:05:06.340 Uttam Kumaran: Okay…

948 02:07:34.940 ⇒ 02:07:41.399 Uttam Kumaran: Yeah, and Emily, I think these, you’re safe to deprecate, or if you want me to do it, I can do those.

949 02:07:42.960 ⇒ 02:07:43.470 Emily Giant: We… which…

950 02:07:43.470 ⇒ 02:07:48.749 Uttam Kumaran: I just sent it in the Zoom chat. Oh, sorry, sorry, I sent it here.

951 02:08:29.970 ⇒ 02:08:31.860 Emily Giant: So, wait, what was your question about these?

952 02:08:32.280 ⇒ 02:08:36.069 Uttam Kumaran: I guess those have been previously marked as…

953 02:08:36.850 ⇒ 02:08:40.670 Uttam Kumaran: good to remove, so I just want to confirm that we’ve…

954 02:08:40.960 ⇒ 02:08:44.319 Uttam Kumaran: I think we may have already deprecated these, but just confirming.

955 02:08:44.680 ⇒ 02:08:45.839 Emily Giant: Yeah, it’s fine.

956 02:08:46.090 ⇒ 02:08:48.210 Emily Giant: I didn’t even look. I’m kidding, I did.

957 02:08:48.770 ⇒ 02:08:50.540 Uttam Kumaran: But they can be deprecated.

958 02:08:51.320 ⇒ 02:08:56.199 Uttam Kumaran: Okay, let me just see whether this might have already… we might have already done these.

959 02:08:57.710 ⇒ 02:08:58.570 Uttam Kumaran: Nope.

960 02:08:58.690 ⇒ 02:09:02.339 Uttam Kumaran: Oh, so we marked it as hidden, so I’m just gonna actually just delete these now.

961 02:09:02.760 ⇒ 02:09:06.749 Emily Giant: Yeah, awesome. Anything I’ve marked as archived can also be deleted.

962 02:09:07.400 ⇒ 02:09:08.060 Uttam Kumaran: Okay.

963 02:09:12.200 ⇒ 02:09:13.709 Emily Giant: This is… this is great.

964 02:09:18.290 ⇒ 02:09:21.120 Uttam Kumaran: I don’t know what this is. Attached products to roundtable.

965 02:09:25.300 ⇒ 02:09:31.010 Uttam Kumaran: Oh, I guess maybe it’s… I’m just not gonna touch those for now. Well, it doesn’t have a view. Alright, whatever.

966 02:09:31.120 ⇒ 02:09:32.609 Uttam Kumaran: Welcome back to that.

967 02:09:34.110 ⇒ 02:09:36.490 Uttam Kumaran: These guys can go…

968 02:09:42.760 ⇒ 02:09:44.479 Henry Zhao: Alright, I’m gonna drop, have fun, guys.

969 02:09:44.860 ⇒ 02:09:45.360 Uttam Kumaran: Thank you.

970 02:09:45.560 ⇒ 02:09:46.650 Emily Giant: Thank you.

971 02:09:47.070 ⇒ 02:09:48.239 Henry Zhao: Nice meeting you, Emily.

972 02:09:48.530 ⇒ 02:09:50.239 Emily Giant: You too, have a good night.

973 02:09:50.540 ⇒ 02:09:51.480 Henry Zhao: Thanks, too, bye.

974 02:12:05.150 ⇒ 02:12:07.789 Uttam Kumaran: Emily, do you know why this was done?

975 02:12:10.740 ⇒ 02:12:11.810 Emily Giant: Mom.

976 02:12:11.940 ⇒ 02:12:13.810 Emily Giant: Mmm… what?

977 02:12:15.200 ⇒ 02:12:19.140 Uttam Kumaran: Setting the new LookML runtime to no?

978 02:12:19.610 ⇒ 02:12:21.670 Emily Giant: I do not know what that is.

979 02:12:22.350 ⇒ 02:12:24.689 Uttam Kumaran: Okay, let’s see if I can find it.

980 02:12:24.790 ⇒ 02:12:26.849 Uttam Kumaran: Cause this should not be there.

981 02:12:28.820 ⇒ 02:12:38.170 Uttam Kumaran: And… Yeah, they’re… Basically, this not… this does not need to be there. Okay, cool.

982 02:12:38.750 ⇒ 02:12:45.780 Uttam Kumaran: Yeah, this, this could be really impactful by not doing… by…

983 02:12:45.890 ⇒ 02:12:52.740 Uttam Kumaran: Putting this as no, because basically they released, like, a bunch of new Basically, there’s a…

984 02:12:52.940 ⇒ 02:12:58.329 Uttam Kumaran: they upgraded the way they do LookML validation and content validation.

985 02:12:58.600 ⇒ 02:13:00.880 Emily Giant: And if you set this to no.

986 02:13:01.220 ⇒ 02:13:03.470 Uttam Kumaran: You don’t get to use any of those.

987 02:13:03.640 ⇒ 02:13:04.590 Emily Giant: Oh, no.

988 02:13:04.590 ⇒ 02:13:08.850 Uttam Kumaran: I’m wondering why this was set up that way, but… enough.

989 02:13:10.020 ⇒ 02:13:15.140 Uttam Kumaran: Okay, well, you let me know if you find out things are any faster.

990 02:13:15.570 ⇒ 02:13:17.349 Emily Giant: Okay, cool, I mean, that’s…

991 02:13:17.350 ⇒ 02:13:18.630 Uttam Kumaran: That could be helpful, yeah.

992 02:13:49.640 ⇒ 02:13:51.010 Uttam Kumaran: just happened here.

993 02:14:45.630 ⇒ 02:14:52.799 Uttam Kumaran: Can I get a… thought here, like, I’m getting all these LookML issues with Tableau items like Seth.

994 02:14:53.540 ⇒ 02:14:54.680 Uttam Kumaran: Stuff…

995 02:14:55.450 ⇒ 02:15:07.799 Emily Giant: Okay, so… Tableau ItemsXF… what is… the error is that Tableau 364 day repeat customer referenced in filters parameter. So I’m guessing that that got…

996 02:15:11.430 ⇒ 02:15:21.650 Emily Giant: click on it, I think you probably just need to delete that. If it was in one of the views that got deleted, it’ll have a red line… oh, filter parameter there. So, something that got deleted…

997 02:15:22.500 ⇒ 02:15:24.120 Uttam Kumaran: And wait, where are you seeing the filler?

998 02:15:24.120 ⇒ 02:15:24.510 Emily Giant: So…

999 02:15:24.520 ⇒ 02:15:25.889 Uttam Kumaran: Oh, dear.

1000 02:15:25.890 ⇒ 02:15:27.729 Emily Giant: I mean, yeah, yeah, yeah, you got it.

1001 02:15:29.400 ⇒ 02:15:30.710 Uttam Kumaran: Interesting.

1002 02:15:33.410 ⇒ 02:15:35.450 Uttam Kumaran: But I didn’t delete any…

1003 02:15:36.420 ⇒ 02:15:37.370 Emily Giant: That’s really odd.

1004 02:15:37.370 ⇒ 02:15:39.880 Uttam Kumaran: Deleted explores, really.

1005 02:15:47.680 ⇒ 02:15:50.250 Emily Giant: It may have been joined in an Explorer.

1006 02:15:50.410 ⇒ 02:15:52.969 Emily Giant: And then, if that got deleted…

1007 02:15:55.080 ⇒ 02:15:58.399 Uttam Kumaran: Interesting. Okay, let me look to see where that’s happening, then.

1008 02:16:00.980 ⇒ 02:16:01.969 Emily Giant: It’s only 12.

1009 02:16:02.510 ⇒ 02:16:08.260 Emily Giant: I love how it was, like, 76, and then it was 12, and then it’ll be, like, 4 when you validate it again.

1010 02:16:08.480 ⇒ 02:16:10.690 Uttam Kumaran: And all these are hidden measures.

1011 02:16:13.290 ⇒ 02:16:15.480 Emily Giant: Yeah… .

1012 02:16:15.480 ⇒ 02:16:18.019 Uttam Kumaran: So, look, let’s take this example, right? This is…

1013 02:16:19.570 ⇒ 02:16:21.220 Uttam Kumaran: Like, I didn’t touch any of these.

1014 02:16:21.220 ⇒ 02:16:25.419 Emily Giant: hired fields. Oh, I… you can delete Zendesk 6XF.

1015 02:16:25.640 ⇒ 02:16:26.520 Emily Giant: Completely.

1016 02:16:26.960 ⇒ 02:16:28.690 Uttam Kumaran: Oh, okay, great. Yeah.

1017 02:16:35.700 ⇒ 02:16:38.780 Uttam Kumaran: Where the heck is that guy, though? Sundays?

1018 02:16:43.160 ⇒ 02:16:46.899 Emily Giant: Alright, I’m gonna do another push here so that y’all are updated.

1019 02:16:47.410 ⇒ 02:16:48.180 Uttam Kumaran: Okay.

1020 02:17:33.360 ⇒ 02:17:36.549 Uttam Kumaran: And we don’t need any… do we need a Zendesk Explorer?

1021 02:17:36.700 ⇒ 02:17:41.399 Emily Giant: Those are all… can you update your branch? These are all gonna go away.

1022 02:17:42.740 ⇒ 02:17:45.009 Emily Giant: So if you do,

1023 02:17:50.510 ⇒ 02:17:56.920 Emily Giant: it should trigger that pull from remote, because I’ve already commented out Like, a lot of those.

1024 02:17:57.490 ⇒ 02:17:58.270 Uttam Kumaran: Okay.

1025 02:17:58.430 ⇒ 02:17:59.489 Uttam Kumaran: But, like…

1026 02:17:59.490 ⇒ 02:18:07.080 Emily Giant: Mine is still updating to… Okay, it should be up-to-date now, and give you the option to…

1027 02:18:08.260 ⇒ 02:18:09.730 Emily Giant: To pull from remote.

1028 02:18:11.059 ⇒ 02:18:12.289 Uttam Kumaran: Okay, let’s see…

1029 02:18:17.389 ⇒ 02:18:23.369 Emily Giant: Do you push… well, no, it won’t let you. Can you do ValidateLookML and see if it triggers it?

1030 02:18:28.659 ⇒ 02:18:30.329 Emily Giant: No.

1031 02:18:32.790 ⇒ 02:18:36.000 Uttam Kumaran: Well, I can just… I can keep note of what I did, and then…

1032 02:18:38.379 ⇒ 02:18:41.430 Emily Giant: Like, maybe start a new… push to remote and start a new branch.

1033 02:19:06.690 ⇒ 02:19:13.500 Uttam Kumaran: Yeah… Okay, well… Yeah, because those will all be fine.

1034 02:19:13.500 ⇒ 02:19:18.529 Emily Giant: Once you’re in a fresh branch. Maybe you could do it in GitHub, and, like, circumvent this.

1035 02:19:18.920 ⇒ 02:19:20.930 Uttam Kumaran: Yeah, let me go do that, actually.

1036 02:19:23.559 ⇒ 02:19:27.159 Demilade Agboola: Hey guys, I think I’ll drop. Is there anything I’m here for?

1037 02:19:28.209 ⇒ 02:19:30.380 Emily Giant: Yeah, it’s pretty late there. No, I think that’s it.

1038 02:19:31.389 ⇒ 02:19:38.949 Demilade Agboola: Okay, all good. Then, so I’ll log on tomorrow and just kind of see what the state of things are, and, like, where I can pick up from.

1039 02:19:40.240 ⇒ 02:19:40.969 Uttam Kumaran: Perfect.

1040 02:19:41.879 ⇒ 02:19:43.569 Uttam Kumaran: Sounds good, thank you.

1041 02:19:47.690 ⇒ 02:19:49.200 Uttam Kumaran: Okay, so…

1042 02:20:12.470 ⇒ 02:20:14.589 Emily Giant: I’m just gonna do a couple more big ones.

1043 02:20:14.760 ⇒ 02:20:22.619 Emily Giant: And then I do have to hop, because I have to do my presentation, and I’m gonna try to deploy the fixes I made to revenue today, so that I can.

1044 02:20:22.620 ⇒ 02:20:23.570 Uttam Kumaran: Oh, great.

1045 02:20:23.870 ⇒ 02:20:24.430 Emily Giant: Yeah.

1046 02:20:25.170 ⇒ 02:20:38.139 Emily Giant: it, so, like, Demolade’s models were perfect, and then, HIVO decided to stop supporting certain columns, and you have to extract them from the JSON through, like, a parse or whatever, so I just wanted… it was…

1047 02:20:39.070 ⇒ 02:20:44.099 Emily Giant: not a lot, but I felt bad that he had done such a good job, and then it was like, oh…

1048 02:20:44.750 ⇒ 02:20:48.359 Emily Giant: Last week, we just stopped ingesting this column, sorry.

1049 02:21:04.020 ⇒ 02:21:07.099 Uttam Kumaran: Okay, this is being weird, so I don’t know.

1050 02:21:08.850 ⇒ 02:21:10.539 Emily Giant: Is it still not letting you?

1051 02:21:12.140 ⇒ 02:21:12.930 Emily Giant: Just reverse.

1052 02:21:13.410 ⇒ 02:21:15.850 Emily Giant: open production. Did you do a ton, though?

1053 02:21:16.270 ⇒ 02:21:17.400 Uttam Kumaran: No, no, no.

1054 02:21:18.000 ⇒ 02:21:18.710 Emily Giant: Okay.

1055 02:21:20.390 ⇒ 02:21:21.600 Uttam Kumaran: I didn’t do that much.

1056 02:21:36.430 ⇒ 02:21:42.130 Emily Giant: Senders who are recipients? That’s a whole explore? What the fuck? Sorry.

1057 02:21:42.130 ⇒ 02:21:45.139 Uttam Kumaran: I just don’t know what was going on.

1058 02:21:45.140 ⇒ 02:21:47.040 Emily Giant: For years.

1059 02:21:50.690 ⇒ 02:21:53.559 Emily Giant: We looked 5 different fiscal calendars in here.

1060 02:21:55.530 ⇒ 02:21:56.480 Uttam Kumaran: That’s funny.

1061 02:21:57.000 ⇒ 02:21:57.580 Emily Giant: Huh.

1062 02:22:56.890 ⇒ 02:23:05.680 Uttam Kumaran: Okay, then I’m gonna kind of spend a couple… probably a little bit more time later today on a few more Explorers, and then tomorrow we should be able to get all of the

1063 02:23:06.310 ⇒ 02:23:09.530 Uttam Kumaran: all the PDTs in, so.

1064 02:23:09.530 ⇒ 02:23:11.180 Emily Giant: Amazing.

1065 02:23:11.780 ⇒ 02:23:25.760 Emily Giant: That’s awesome. I’ll… if I finish up my, deck early enough, I’ll double back to it. I do want to try and edit that stuff tonight, so I just wanted to, like, do the refreshes while nobody was…

1066 02:23:26.130 ⇒ 02:23:28.980 Emily Giant: Staring at our inventory dashboard, so…

1067 02:23:28.980 ⇒ 02:23:29.700 Uttam Kumaran: Yes.

1068 02:23:30.140 ⇒ 02:23:31.470 Emily Giant: Yeah.

1069 02:23:31.530 ⇒ 02:23:36.399 Uttam Kumaran: Okay, and yeah, send me a ping if I can be… if I can help with anything. Otherwise, like, I feel like…

1070 02:23:36.630 ⇒ 02:23:38.130 Uttam Kumaran: This week, we can…

1071 02:23:38.390 ⇒ 02:23:50.029 Uttam Kumaran: now that we have sort of a little bit of a plan, it’ll be a little bit easier to start to move that over. It’ll probably be something, again, we want to try to do off hours, so… but at least we can prep a branch with all that.

1072 02:23:50.670 ⇒ 02:23:53.360 Emily Giant: Yeah, agreed.

1073 02:23:53.710 ⇒ 02:24:05.990 Emily Giant: Yeah, that sounds good. The one thing I was hoping you could look at was my subscription forecast model. I’ll send it to you if I can get to it tonight, because it’s, like, all but done, but it’s taking…

1074 02:24:06.160 ⇒ 02:24:08.130 Emily Giant: Way too long to run.

1075 02:24:08.230 ⇒ 02:24:09.509 Emily Giant: And… Okay.

1076 02:24:09.630 ⇒ 02:24:14.709 Emily Giant: So I think it’s just a matter of, like, sort keys and, like, improving the join.

1077 02:24:15.350 ⇒ 02:24:21.729 Emily Giant: But, yeah. But I’ll send that over tonight if I get it to a place where it feels like it’s not a waste of your time.

1078 02:24:22.420 ⇒ 02:24:23.860 Uttam Kumaran: Okay, okay, no problem.

1079 02:24:24.270 ⇒ 02:24:34.819 Emily Giant: Alright, cool, I’m gonna deploy this last one, and then make sure that it doesn’t break everything. And then, yeah, I’ll be around for the next, like, 3 or 4 hours, so if you need anything, let me know.

1080 02:24:36.150 ⇒ 02:24:38.629 Uttam Kumaran: Okay, perfect. Alright. Thank you.

1081 02:24:38.970 ⇒ 02:24:40.400 Emily Giant: Thank you, bye.

1082 02:24:40.740 ⇒ 02:24:41.530 Uttam Kumaran: Bye.

Brainforge Knowledge

Explorer

2025-11-11_brainforge_looker_cleanup_sync_b7354fa6

Graph View