Meeting Title: Looker and dbt Integration Sync Date: 2025-09-09 Meeting participants: Emily Giant, Demilade Agboola
WEBVTT
1 00:01:27.500 ⇒ 00:01:28.480 Demilade Agboola: I mean…
2 00:01:29.480 ⇒ 00:01:30.920 Emily Giant: Hi, how’s it going?
3 00:01:31.930 ⇒ 00:01:35.409 Demilade Agboola: Oh, it’s a bit hectic today, but otherwise, fine. How are you?
4 00:01:35.850 ⇒ 00:01:38.869 Emily Giant: Same. I didn’t know, should we…
5 00:01:39.240 ⇒ 00:01:42.750 Emily Giant: Do anything to, like, support what’s not…
6 00:01:42.910 ⇒ 00:01:47.400 Emily Giant: running on these refreshes, like, I know that Tom said it was…
7 00:01:47.700 ⇒ 00:01:54.020 Emily Giant: Related to the seed file running, but I don’t think that’s the only thing, because we deployed that at, like, 8 o’clock last night.
8 00:01:54.980 ⇒ 00:02:01.920 Demilade Agboola: Yes, but your plastic seat fell to not refresh, and that refresh meant that, certain columns that were expected and the models didn’t run.
9 00:02:02.020 ⇒ 00:02:05.119 Emily Giant: And that caused some of the test failures that we saw.
10 00:02:05.480 ⇒ 00:02:16.129 Emily Giant: Gotcha, okay, that is… oh, God, that happens, like, every time there’s a seed file. I need to, like, tattoo it on my head, like, full refresh, or…
11 00:02:16.270 ⇒ 00:02:22.449 Emily Giant: refresh seed when that happens. But what I wanted to go over with you today was kind of some of the, like.
12 00:02:22.620 ⇒ 00:02:25.970 Emily Giant: downstream Looker stuff, like, what I can…
13 00:02:26.190 ⇒ 00:02:34.099 Emily Giant: do in Looker to make sure that, like, what you’re building in dbt is getting to stakeholders.
14 00:02:34.420 ⇒ 00:02:45.650 Emily Giant: So, I wanted to kind of go over where you were at with the fulfillment lines, and, like, connecting that to the HEVO suborders, and then, just chatting through
15 00:02:45.960 ⇒ 00:02:54.899 Emily Giant: what I’ve built so far in Looker, and, like, what the plan is for how we’re gonna use these individual tables from Shopify for stakeholders.
16 00:02:56.250 ⇒ 00:03:02.050 Demilade Agboola: Yeah, so right now, the fulfillment orders
17 00:03:02.360 ⇒ 00:03:10.229 Demilade Agboola: there hasn’t necessarily been a lot of progress, because I’m trying to, like, push out the facts of borders and facts, orders.
18 00:03:10.230 ⇒ 00:03:10.960 Emily Giant: Huh.
19 00:03:10.960 ⇒ 00:03:13.429 Demilade Agboola: But I’m trying to ensure that…
20 00:03:14.270 ⇒ 00:03:21.500 Demilade Agboola: Like, losing the Shopify things, but I’m getting an open number as well, and that has been a bit of a hassle.
21 00:03:24.190 ⇒ 00:03:34.039 Emily Giant: Can I help with any of that? Like, can I see where you’re at with the orders and suborders? And also, are you using Hivo, or are those coming from…
22 00:03:34.040 ⇒ 00:03:34.470 Demilade Agboola: so fast.
23 00:03:34.470 ⇒ 00:03:35.590 Emily Giant: Shopify now.
24 00:03:37.120 ⇒ 00:03:40.820 Demilade Agboola: So, yeah, I’m trying to… like, things are coming from Shopify now.
25 00:03:41.000 ⇒ 00:03:41.730 Emily Giant: Okay.
26 00:03:47.310 ⇒ 00:03:50.410 Demilade Agboola: chucking on some food. So things are coming from.
27 00:03:50.410 ⇒ 00:03:52.389 Emily Giant: Okay. Did you say you’re choking?
28 00:03:53.140 ⇒ 00:03:55.859 Demilade Agboola: Yeah, I was shipping out some food, but I’m fine now.
29 00:03:55.860 ⇒ 00:03:56.710 Emily Giant: Okay.
30 00:03:57.960 ⇒ 00:04:00.110 Demilade Agboola: But things are coming slowly.
31 00:04:00.390 ⇒ 00:04:08.520 Demilade Agboola: Shopify. I want that to be the basis, and that’s kind of why, like I said, the fulfillment line thing is… is,
32 00:04:09.470 ⇒ 00:04:16.390 Demilade Agboola: a bit behind, because I’m trying to ensure that the Shopify part is good before I fully integrate it with the YMS support.
33 00:04:17.560 ⇒ 00:04:18.849 Demilade Agboola: Be able to care.
34 00:04:20.300 ⇒ 00:04:20.950 Emily Giant: I feel like I think…
35 00:04:20.959 ⇒ 00:04:21.489 Demilade Agboola: punch you.
36 00:04:21.490 ⇒ 00:04:28.060 Emily Giant: It’s a lot for one person to do, and as long as I know what you want, I can jump in.
37 00:04:29.280 ⇒ 00:04:34.310 Demilade Agboola: I mean, to be fair, some things, like, sidetracked the progress, because, like, for instance, today, the whole, like.
38 00:04:35.110 ⇒ 00:04:37.899 Demilade Agboola: Inventory Refresh isn’t… hasn’t been the best.
39 00:04:40.330 ⇒ 00:04:46.689 Demilade Agboola: But I have some time blocked after this call, where I just plan to, like, go through everything, like, kind of push it out.
40 00:04:47.550 ⇒ 00:04:49.780 Demilade Agboola: Okay. Cool, yeah.
41 00:04:50.390 ⇒ 00:05:00.760 Emily Giant: In that case, I definitely have some, like, Looker inventory questions. I know that you’re not, like, a Looker pro, but neither am I. I figure still two heads are better than one.
42 00:05:00.760 ⇒ 00:05:01.490 Demilade Agboola: contract?
43 00:05:01.490 ⇒ 00:05:04.979 Emily Giant: So, let me share my screen real quick, and I can show you what I’m working with here.
44 00:05:05.980 ⇒ 00:05:07.919 Emily Giant: Hmm, excuse me.
45 00:05:10.090 ⇒ 00:05:15.680 Emily Giant: Okay. So, in Looker, I’m…
46 00:05:16.080 ⇒ 00:05:22.220 Emily Giant: Still dealing with a lot of, like, the garbage that… Was never, like.
47 00:05:22.630 ⇒ 00:05:29.669 Emily Giant: Deprecated, so it’s still super messy in our, in our, like, file browser.
48 00:05:30.160 ⇒ 00:05:38.019 Emily Giant: But… essentially what I’ve got with inventory is in the new model structure, and
49 00:05:38.240 ⇒ 00:05:49.369 Emily Giant: what I have is what is in the top line sales already, which is this Mart inventory lot table, and then Martin inventory transactions. And because I didn’t want to disrupt the reports that are…
50 00:05:50.240 ⇒ 00:05:56.130 Emily Giant: built off of those, I just kind of let them be, but in the new model.
51 00:05:56.270 ⇒ 00:06:03.010 Emily Giant: I’m using… these are, like, replicas of those, with inventory adjustments, inventory balance,
52 00:06:03.130 ⇒ 00:06:07.150 Emily Giant: But they’re in this new core model.
53 00:06:08.470 ⇒ 00:06:11.749 Emily Giant: And, essentially what I’ve done is
54 00:06:13.320 ⇒ 00:06:28.589 Emily Giant: with the inventory lot balance, because we had talked about only having one explorer for both of these inventory tables, I’ve made it, like, an required extension in inventory adjustment data, which means that,
55 00:06:29.120 ⇒ 00:06:35.710 Emily Giant: it’s going to appear only as one explore. So, now it rolls up correctly after,
56 00:06:36.100 ⇒ 00:06:40.249 Emily Giant: all of the, adjustments. Well, it will once I’m able to…
57 00:06:40.400 ⇒ 00:06:43.800 Emily Giant: Or been given the green light to deploy the rest of that one.
58 00:06:43.910 ⇒ 00:06:46.939 Emily Giant: PR that I’m splitting into pieces.
59 00:06:47.050 ⇒ 00:07:00.139 Emily Giant: But, I did a ton of testing, and it now appears as just one explorer, which is much cleaner. The snapshot data is still gonna be its own thing, because I don’t want people, like, confusing snapshot data for…
60 00:07:00.560 ⇒ 00:07:05.420 Emily Giant: anything but what it is. But yeah, so…
61 00:07:06.630 ⇒ 00:07:11.730 Emily Giant: Oh, excuse me, I do need to work on rebuilding some of these dashboards.
62 00:07:12.250 ⇒ 00:07:21.500 Emily Giant: that exist with the, previous inventory, but, like, I’m… I still am, like, unsure of, like, how to roll this out.
63 00:07:21.660 ⇒ 00:07:23.789 Emily Giant: To stakeholders, like…
64 00:07:24.060 ⇒ 00:07:31.609 Emily Giant: all of this newness. It’s just, like, a… there’s a lot of junk in here, and I keep making, like.
65 00:07:31.860 ⇒ 00:07:37.129 Emily Giant: duplicate things instead of, like, overriding things, because I don’t want to disrupt
66 00:07:37.580 ⇒ 00:07:41.570 Emily Giant: existing reports, but it’s just getting really messy, and I…
67 00:07:42.420 ⇒ 00:07:50.530 Emily Giant: feel like I need help with this, like, deprecation cleanup process that Kayo kind of stalled out on, or wasn’t able to complete.
68 00:07:52.140 ⇒ 00:07:56.459 Demilade Agboola: Well, yeah, I think what we need to do is,
69 00:07:56.870 ⇒ 00:08:10.459 Demilade Agboola: number one, get, like, the list of all the data, like, explores that we’re going to be using, and number two, let’s have a list of the ones that will be deprecated. And in certain cases, if we can map
70 00:08:10.860 ⇒ 00:08:15.530 Demilade Agboola: fields. Like, if there’s a one-to-one mapping we can do of the field, that would be very helpful.
71 00:08:16.610 ⇒ 00:08:29.319 Demilade Agboola: perhaps that it’s easy to say, hey, like, I know you’re currently using this, but here is where the new data is… the new and improved data is available, so people who are, number one, using things can know where to find the new ones.
72 00:08:29.580 ⇒ 00:08:32.250 Demilade Agboola: Number two,
73 00:08:33.200 ⇒ 00:08:40.580 Demilade Agboola: we can tell them or give a heads up that we do want to complete application by, say, end of September or end of October or something, where.
74 00:08:40.580 ⇒ 00:08:41.250 Emily Giant: Hmm.
75 00:08:41.470 ⇒ 00:08:54.629 Demilade Agboola: That way, people need to kind of move off of the old data sources to the new ones. And finally, I would say, like, as much as possible, we need to make it as not complex as possible.
76 00:08:54.830 ⇒ 00:09:02.410 Demilade Agboola: So, let’s not have so many more… any… so many explorers that it might be, you need to join this to this, or you need to do… it can literally just be…
77 00:09:02.810 ⇒ 00:09:07.129 Demilade Agboola: This is it when it’s flat. This is the rolled-up version.
78 00:09:07.320 ⇒ 00:09:18.370 Demilade Agboola: Because the sum of all that has happened over whatever time period. But ideally, yeah, we don’t want to have too many models that can become, like, it can become too complicated to manage.
79 00:09:19.370 ⇒ 00:09:36.080 Emily Giant: Okay, yeah, I’ll do that. So I can just work on, like, as these things roll out, like, pulling the reports I know they need and rebuilding them so that they don’t have to do it necessarily, because there isn’t, like, any major changes in how the data’s used. It’s just more accurate. And,
80 00:09:36.850 ⇒ 00:09:56.599 Emily Giant: I want to get rid of top-line sales. It is the, like, junkiest model of all times, and it’s got, like, just years of… like, this is just crap. There’s ways to write it in Looker that are cleaner, and are, like, one line of code, and instead, like, this entire model is just junk like this, and…
81 00:09:56.790 ⇒ 00:10:02.749 Emily Giant: Yeah, I’d rather just, like, be able to delete this at the end of the day, so…
82 00:10:03.280 ⇒ 00:10:10.489 Emily Giant: that will, in turn, make anything built on this, which is almost everything in Looker, deprecated.
83 00:10:11.280 ⇒ 00:10:13.629 Emily Giant: But it’s just such a model.
84 00:10:14.280 ⇒ 00:10:21.360 Demilade Agboola: Yeah, I don’t think we should do some… such a hash, like, process, because if we just delete every king.
85 00:10:23.170 ⇒ 00:10:30.910 Demilade Agboola: If we just delete everything, what’s gonna end up happening is that… .
86 00:10:32.510 ⇒ 00:10:35.599 Emily Giant: There’s a fill-in model, but it’s still…
87 00:10:35.790 ⇒ 00:10:51.690 Demilade Agboola: inventory lots, hourly changes, I’ll push a fix for that. But if we change everything, what’s gonna happen is, I think it will be very hard to contain everything, given how, like, widespread the impact of this is. What I suggest is…
88 00:10:51.940 ⇒ 00:10:57.290 Demilade Agboola: Give a heads up and say, hey, this is what we’re… what we’re going to do with this.
89 00:10:57.390 ⇒ 00:11:06.290 Demilade Agboola: Maybe… For inventory, you might need to create tips?
90 00:11:09.770 ⇒ 00:11:10.750 Demilade Agboola: on…
91 00:11:16.980 ⇒ 00:11:20.230 Demilade Agboola: Sorry, I need to send… it’s on the message. Give me one second.
92 00:11:20.230 ⇒ 00:11:21.209 Emily Giant: Oh, no worries, take your time.
93 00:11:21.210 ⇒ 00:11:22.390 Demilade Agboola: Oops, you know.
94 00:12:02.000 ⇒ 00:12:04.910 Demilade Agboola: Alright, so, I feel like…
95 00:12:05.180 ⇒ 00:12:14.560 Demilade Agboola: we should, is there a way to, like, easily just see the blast radius of deleting this table, deleting this, X block?
96 00:12:16.040 ⇒ 00:12:17.750 Emily Giant: Say it again? Sorry.
97 00:12:17.980 ⇒ 00:12:27.199 Demilade Agboola: Is there a way to determine blast radius of deleting this explore? Like, if we delete it, how many dashboards are… and that’s going to be a little bit. Who should we be…
98 00:12:27.700 ⇒ 00:12:35.350 Demilade Agboola: And also, I know Tableau Items Accept doesn’t only answer inventory questions, so I know there’s more to it than that.
99 00:12:35.380 ⇒ 00:12:36.969 Emily Giant: Which is also another instrument.
100 00:12:36.970 ⇒ 00:12:38.109 Demilade Agboola: To look out for.
101 00:12:38.480 ⇒ 00:12:40.560 Emily Giant: Yeah.
102 00:12:41.270 ⇒ 00:12:48.400 Emily Giant: You know, as you’re saying all of this, I’m wondering if, like, maybe my focus should, instead of, like, blasting this, be to, like.
103 00:12:48.610 ⇒ 00:12:53.890 Emily Giant: clean it up and organize it so that, like, anything that I know we want to deprecate’s at the bottom.
104 00:12:54.080 ⇒ 00:12:56.030 Emily Giant: Everything we want to keep is at the top.
105 00:12:56.690 ⇒ 00:13:00.629 Emily Giant: Instead of, like, annihilating all of this.
106 00:13:01.950 ⇒ 00:13:15.019 Emily Giant: But I can definitely, like, this shit, I can go into holiday delivery forecasts, which I guarantee you nobody’s used in 10 years, and you can make a list of fields that you…
107 00:13:15.340 ⇒ 00:13:31.659 Emily Giant: it’s like a tag, and I can just put, like, fields, like, minus that tag, instead of all of these Tableau things that are listed over and over and over again in every Explorer. So, like, maybe even making it more readable could be step one,
108 00:13:32.470 ⇒ 00:13:34.580 Emily Giant: But, like, I just… ugh.
109 00:13:35.060 ⇒ 00:13:40.639 Emily Giant: It’s like this is the nexus of all of the bad junk that’s been done over the years, so…
110 00:13:41.590 ⇒ 00:13:45.410 Emily Giant: I, I do agree. Too nuclear of an option.
111 00:13:45.740 ⇒ 00:13:49.569 Emily Giant: to just blast it, but I want to.
112 00:13:50.870 ⇒ 00:13:52.160 Demilade Agboola: I understand, I understand.
113 00:13:52.160 ⇒ 00:13:57.670 Emily Giant: new stuff. Like, this is all getting replaced with Shopify, for the most part, outside of historical.
114 00:13:58.310 ⇒ 00:14:04.610 Emily Giant: Yeah, it’s just so much junk.
115 00:14:09.490 ⇒ 00:14:21.909 Emily Giant: Alright, well, I don’t mind building a different model for our testing purposes. Like, nobody gets into new core model right now, so it’s super easy for me to, like, rebuild, test, and then I can just drop that in to top-line sales.
116 00:14:22.320 ⇒ 00:14:24.260 Emily Giant: Like, any…
117 00:14:24.260 ⇒ 00:14:34.949 Demilade Agboola: So here’s what we need to do, or what I think might be the best things to do. So if you build out this explod, is it possible for us to list out, like, the top inventory dashboards that are being used by stakeholders?
118 00:14:35.260 ⇒ 00:14:36.770 Demilade Agboola: Like, maybe top 5.
119 00:14:36.870 ⇒ 00:14:40.679 Demilade Agboola: I migrate those ones and tell them, okay, these need to be migrated.
120 00:14:40.990 ⇒ 00:14:45.969 Demilade Agboola: And so we can slowly start that way. So instead of going nuclear by, like, deleting…
121 00:14:46.130 ⇒ 00:14:59.380 Demilade Agboola: the Explores, why don’t we slowly push the most important dashboards onto it? And so over time, when people use the data, it might be easier for them to see, hey, Tableau Adventure Excel is terrible. Let’s, like…
122 00:14:59.590 ⇒ 00:15:04.620 Demilade Agboola: Because if you use… if you’re using both, and you’re moving them slowly, so, like, if every month
123 00:15:04.740 ⇒ 00:15:10.190 Demilade Agboola: we have, like, a list of, say, 5 to 10 dashboards that we need to move off, table items, etc.
124 00:15:10.350 ⇒ 00:15:16.450 Demilade Agboola: I feel that is a more helpful, slow, but productive way to go about making this migration.
125 00:15:16.970 ⇒ 00:15:34.459 Emily Giant: Okay, I dig it, yeah. So, like, for example, GA4 audience behavior, I know that we still use it. So, I would move this over to new core model, and as stakeholders are like, I need to use that, I would take the Explore and move it onto the new one, so that eventually top-line sales is irrelevant.
126 00:15:36.490 ⇒ 00:15:39.110 Emily Giant: Is that what you’re saying, or were you saying the opposite?
127 00:15:39.810 ⇒ 00:15:46.570 Demilade Agboola: You know, I’m saying? I’m saying we need to enrich and just ensure that our… our current data.
128 00:15:46.770 ⇒ 00:15:50.310 Demilade Agboola: And answer the questions they need for the top inventory dashboards.
129 00:15:50.410 ⇒ 00:15:54.189 Demilade Agboola: And then, if… Once we’re done with that process.
130 00:15:54.190 ⇒ 00:15:54.630 Emily Giant: Hmm.
131 00:15:54.630 ⇒ 00:16:00.240 Demilade Agboola: We can, like, we can move the, say, is there the dashboard for inventory use by
132 00:16:00.400 ⇒ 00:16:15.359 Demilade Agboola: you know, maybe Philippe, another dashboard being used by some business stakeholders, maybe the aggregated version, and there’s another… there’s another dashboard being used elsewhere. We can end up just saying, hey, these 5 or these 10 need to move before the sheet.
133 00:16:15.650 ⇒ 00:16:18.260 Demilade Agboola: So that, that we… If…
134 00:16:18.410 ⇒ 00:16:34.179 Demilade Agboola: the… explore that, like, the connection to the new data will be done, and if there are any loopholes, or any, like, hey, we need this enrich… we need… we need from other data, it makes it easier for us to know what that data is.
135 00:16:36.690 ⇒ 00:16:37.600 Emily Giant: Okay.
136 00:16:38.080 ⇒ 00:16:41.320 Emily Giant: Yeah, that, that makes sense. So…
137 00:16:41.490 ⇒ 00:16:42.189 Demilade Agboola: I said, okay, okay.
138 00:16:42.190 ⇒ 00:16:48.849 Emily Giant: Yeah, I’m kind of in a rock and a hard place with, like, those deployments, because the new data…
139 00:16:49.470 ⇒ 00:16:55.820 Emily Giant: that I’d be updating those dashboards that I know are used, those, like, top 5 ones. I don’t…
140 00:16:56.150 ⇒ 00:17:02.450 Emily Giant: I can’t really rebuild them until… That deployment’s completely… Pushed through.
141 00:17:02.850 ⇒ 00:17:05.589 Emily Giant: So I think…
142 00:17:05.599 ⇒ 00:17:06.449 Demilade Agboola: deployments.
143 00:17:06.579 ⇒ 00:17:07.199 Emily Giant: What’d you say?
144 00:17:07.200 ⇒ 00:17:13.829 Demilade Agboola: deployment… I was gonna say, like, what’s the deployment holding us back from, like, what data should be in their base and in there?
145 00:17:14.210 ⇒ 00:17:18.290 Emily Giant: So right now, well, something failed here.
146 00:17:18.670 ⇒ 00:17:26.640 Emily Giant: It’s the, lauded… it’s, like, the refinement of unlotted goods throughout history.
147 00:17:26.859 ⇒ 00:17:36.790 Emily Giant: And then also, the… reconfiguring for edge cases of uncommitted orders versus committed, and then it’s…
148 00:17:36.790 ⇒ 00:17:37.290 Demilade Agboola: stop.
149 00:17:37.290 ⇒ 00:17:45.060 Emily Giant: really bringing in, like, everything historical, very streamlined. So… Yeah, go ahead.
150 00:17:45.060 ⇒ 00:17:50.370 Demilade Agboola: Good question. Does Snow Items like Seth have… does he handle the unlotted better than this?
151 00:17:51.820 ⇒ 00:17:52.680 Emily Giant: No.
152 00:17:53.240 ⇒ 00:17:54.420 Emily Giant: It doesn’t handle it at all.
153 00:17:55.360 ⇒ 00:18:15.350 Demilade Agboola: Alright, so I think we’re… we’re using perfection to be our enemy of progress. If we have better data than what exists, than what currently stakeholders have to make decisions now, it’s better we put it out there and iterating public than wait for the perfect numbers before we put it out there.
154 00:18:15.780 ⇒ 00:18:16.480 Emily Giant: Okay.
155 00:18:16.750 ⇒ 00:18:20.770 Demilade Agboola: Like, it’s better for them to have visibility to make better decisions.
156 00:18:21.140 ⇒ 00:18:29.390 Demilade Agboola: Than us saying, hey, we’re not making anything happen, because this needs to work completely.
157 00:18:31.490 ⇒ 00:18:33.120 Emily Giant: Yeah, okay.
158 00:18:33.540 ⇒ 00:18:38.380 Emily Giant: So hopefully then, once UTAM fixes,
159 00:18:38.710 ⇒ 00:18:44.590 Emily Giant: the seed file issue, then that will be the case with this, because it’s done.
160 00:18:45.540 ⇒ 00:18:46.360 Demilade Agboola: Okay.
161 00:18:46.360 ⇒ 00:18:48.550 Emily Giant: It’s like, yeah, yeah, so this… Yeah.
162 00:18:48.550 ⇒ 00:18:56.189 Demilade Agboola: Yeah, this… this… it should have run now, so I think the metric should be up to date. I think they might just make a check now, but, like, Eventually, if I should be up to date.
163 00:18:56.750 ⇒ 00:18:57.729 Emily Giant: Let me check.
164 00:18:58.380 ⇒ 00:19:00.910 Demilade Agboola: At least, from the dbt end.
165 00:19:02.000 ⇒ 00:19:05.400 Emily Giant: Oh yeah, you check the DBT, I’m gonna check what I know Menakshi looks at.
166 00:19:10.280 ⇒ 00:19:14.439 Emily Giant: Yeah, it’s… it’s not changed. It was 31%.
167 00:19:14.650 ⇒ 00:19:16.350 Emily Giant: when I logged on this morning.
168 00:19:18.640 ⇒ 00:19:24.720 Demilade Agboola: Okay. Do you need to do a refresh? Because, like, from the DPTN, it does appear that there has been
169 00:19:27.930 ⇒ 00:19:30.600 Demilade Agboola: The tables, the mock tables have run.
170 00:19:31.520 ⇒ 00:19:32.140 Emily Giant: Okay.
171 00:19:36.530 ⇒ 00:19:37.610 Emily Giant: Oh, dear.
172 00:19:40.780 ⇒ 00:19:41.560 Demilade Agboola: Yeah.
173 00:19:42.870 ⇒ 00:19:45.869 Demilade Agboola: It appears again, there’s a two main connections error.
174 00:19:51.510 ⇒ 00:19:53.209 Emily Giant: So is that why it’s failing?
175 00:19:53.840 ⇒ 00:19:55.389 Emily Giant: to update Looker?
176 00:19:56.460 ⇒ 00:20:01.060 Demilade Agboola: I mean, right, potentially, I need to look into that. But the…
177 00:20:01.940 ⇒ 00:20:07.539 Demilade Agboola: But from our end, the dbt end, it’s done, so it might just be a look at it right now.
178 00:20:09.420 ⇒ 00:20:11.359 Emily Giant: I’ve never seen that error before.
179 00:20:12.380 ⇒ 00:20:13.609 Demilade Agboola: We spoke yesterday.
180 00:20:14.270 ⇒ 00:20:19.889 Emily Giant: Yeah, with Perry, but this is, like, the first… okay, 37’s higher. It was 34.
181 00:20:20.020 ⇒ 00:20:20.930 Emily Giant: Before.
182 00:20:21.060 ⇒ 00:20:22.690 Emily Giant: A 31.2.
183 00:20:23.040 ⇒ 00:20:26.549 Emily Giant: So… Farm Direct, that makes sense.
184 00:20:26.920 ⇒ 00:20:29.299 Emily Giant: That’s the same, that’s the subs.
185 00:20:29.590 ⇒ 00:20:31.530 Emily Giant: 34 is the same.
186 00:20:32.710 ⇒ 00:20:34.850 Emily Giant: 37 is higher.
187 00:20:35.220 ⇒ 00:20:40.030 Emily Giant: That was 34 and 31.2 is the same. Okay, yeah, these have barely moved.
188 00:20:40.700 ⇒ 00:20:44.950 Emily Giant: Let me see if I do it for, like, an individual report instead of the dashboard.
189 00:20:53.770 ⇒ 00:20:56.069 Emily Giant: Did that change? Am I crazy?
190 00:20:56.930 ⇒ 00:21:00.090 Emily Giant: I… Where’s the 31.2 one?
191 00:21:37.000 ⇒ 00:21:38.630 Emily Giant: Oh yeah, okay, it’s working.
192 00:21:40.440 ⇒ 00:21:42.980 Demilade Agboola: Yeah. Like I said, the numbers look…
193 00:21:44.460 ⇒ 00:21:54.789 Demilade Agboola: fine from a dbt perspective, it’s just, like, Looker has access… like, it’s been propagated to Looker, so it appears, like, the numbers are beginning to populate.
194 00:21:57.200 ⇒ 00:21:58.100 Emily Giant: Okay.
195 00:21:58.840 ⇒ 00:22:03.149 Emily Giant: So I’ve gotta figure that out, like, what that even means. I’m gonna let Em know real quick.
196 00:22:05.470 ⇒ 00:22:05.990 Demilade Agboola: Okay.
197 00:22:06.570 ⇒ 00:22:08.560 Emily Giant: Watch it. Duh.
198 00:22:08.740 ⇒ 00:22:10.370 Emily Giant: Visually…
199 00:23:05.030 ⇒ 00:23:06.140 Emily Giant: Okay.
200 00:23:06.530 ⇒ 00:23:12.249 Emily Giant: Alright, well, at least we know that dbt is updating, that’s something.
201 00:23:14.210 ⇒ 00:23:18.499 Emily Giant: I wish I could use cursor for these collision errors, that’d be nice.
202 00:23:20.660 ⇒ 00:23:26.969 Demilade Agboola: Yeah, it would definitely be helpful. I mean, you could always ask, you might not be able to implement it, but you’ll always ask.
203 00:23:28.460 ⇒ 00:23:29.699 Emily Giant: Okay, let me see.
204 00:23:30.820 ⇒ 00:23:32.740 Emily Giant: I’ll copy the whole thing.
205 00:23:33.240 ⇒ 00:23:35.470 Demilade Agboola: Yeah, so it’s a wretched thing, because…
206 00:23:36.180 ⇒ 00:23:36.710 Emily Giant: Yeah.
207 00:23:36.710 ⇒ 00:23:37.770 Demilade Agboola: Okay, great.
208 00:23:37.770 ⇒ 00:23:40.470 Emily Giant: Her user is a… is…
209 00:23:40.470 ⇒ 00:23:41.260 Demilade Agboola: the redshift.
210 00:23:41.260 ⇒ 00:23:41.990 Emily Giant: Yeah.
211 00:23:52.650 ⇒ 00:23:56.079 Demilade Agboola: So that’s what I think… that’s what’s the important thing about maybe scheduling.
212 00:23:56.510 ⇒ 00:24:00.250 Demilade Agboola: Or… maybe… B, I guess.
213 00:24:01.970 ⇒ 00:24:03.060 Emily Giant: I diagnose.
214 00:24:06.470 ⇒ 00:24:07.180 Emily Giant: Here.
215 00:24:39.630 ⇒ 00:24:43.699 Emily Giant: Okay, review Looker Connection… whoop, it’s moving so fast!
216 00:24:43.820 ⇒ 00:24:44.650 Emily Giant: Okay.
217 00:24:46.530 ⇒ 00:24:55.510 Emily Giant: The diagnostics show the Looker user currently has only two connections, which suggests this might be an intermittent issue, or an error caused when there are more connections.
218 00:24:55.690 ⇒ 00:24:57.179 Emily Giant: Let me check Redshift.
219 00:24:57.830 ⇒ 00:25:01.180 Emily Giant: Connection limits and provide you with comprehensive solutions.
220 00:25:54.540 ⇒ 00:26:03.370 Emily Giant: In Looker Admin Panel, adjust the settings. Max Connections, reduce default, To 3 to 5?
221 00:26:04.900 ⇒ 00:26:09.880 Demilade Agboola: So, the term says that apparently maybe refresh their Redshift.
222 00:26:10.130 ⇒ 00:26:12.639 Demilade Agboola: So that’s potentially something to look into.
223 00:26:12.790 ⇒ 00:26:13.540 Emily Giant: Okay.
224 00:26:13.540 ⇒ 00:26:14.540 Demilade Agboola: I assume.
225 00:26:14.670 ⇒ 00:26:15.520 Demilade Agboola: Yeah.
226 00:26:16.170 ⇒ 00:26:20.769 Emily Giant: Okay, I’ll keep digging on this one, because I think that’s actually what’s happening. It’s like…
227 00:26:20.990 ⇒ 00:26:21.600 Demilade Agboola: Yeah.
228 00:26:21.600 ⇒ 00:26:27.330 Emily Giant: No one refreshes the individual reports, they refresh the entire dashboard, and it’s just… it’s…
229 00:26:27.820 ⇒ 00:26:30.480 Emily Giant: Timing out, or colliding, or something.
230 00:26:31.940 ⇒ 00:26:32.600 Emily Giant: Let me…
231 00:26:32.600 ⇒ 00:26:33.270 Demilade Agboola: panel.
232 00:26:33.270 ⇒ 00:26:35.880 Emily Giant: I used to… Correct redshift.
233 00:26:38.630 ⇒ 00:26:43.100 Emily Giant: I don’t know what it’s doing right now. Sometimes it, like, takes things and runs with it.
234 00:26:46.300 ⇒ 00:26:47.350 Emily Giant: Okay.
235 00:26:52.070 ⇒ 00:26:58.489 Emily Giant: Action 17 out of 500, well within limits, yeah. Looker Connections 1, no connection leaks detected.
236 00:26:58.630 ⇒ 00:27:03.140 Emily Giant: admin configuration, it looks like in your Looker Admin panel, update these settings.
237 00:27:05.350 ⇒ 00:27:07.780 Emily Giant: Maximum connections per user, 3.
238 00:27:18.180 ⇒ 00:27:24.639 Emily Giant: Alright, I’m gonna go through these tables, too, and see if there’s anything, like… Wonky going on here.
239 00:27:25.110 ⇒ 00:27:26.160 Emily Giant: But, okay, I…
240 00:27:26.160 ⇒ 00:27:26.850 Demilade Agboola: Awesome.
241 00:27:26.850 ⇒ 00:27:35.179 Emily Giant: Yeah, we don’t have to, I know you need time back badly, but I just wanted to kind of chat through the Looker stuff with you, and I think that we’ve got a good plan.
242 00:27:36.570 ⇒ 00:27:42.949 Demilade Agboola: I mean, I think, yeah, once we’re able to stop migrating the native dashboards off, I think the rest starts to follow.
243 00:27:43.090 ⇒ 00:27:49.029 Demilade Agboola: Because if we… if, like, people are using Baby, for instance, two different dashboards, and they can see the…
244 00:27:49.340 ⇒ 00:27:52.540 Demilade Agboola: better quality they’re getting with one. They would…
245 00:27:52.790 ⇒ 00:28:02.279 Demilade Agboola: ideally want to move the other ones off, so I think we need to just start, and just keep pushing. Like, once we start with one, or, like, we start with, like, a couple, like, 5, 10,
246 00:28:02.360 ⇒ 00:28:13.229 Demilade Agboola: we can start pushing, and then it becomes easier for people to migrate. Although people are trying to build, views or whatever, they would just initially, or looks, they would instead just use the new data.
247 00:28:13.830 ⇒ 00:28:14.610 Emily Giant: Yeah.
248 00:28:15.290 ⇒ 00:28:19.490 Demilade Agboola: But it needs to be in people… it needs to be in people’s faces. That’s the problem.
249 00:28:19.950 ⇒ 00:28:26.320 Emily Giant: In that case, once UTAM gives me the thumbs up, I’ll rebuild the two dashboards I know they use every day. Today.
250 00:28:26.320 ⇒ 00:28:26.880 Demilade Agboola: Hang on.
251 00:28:26.880 ⇒ 00:28:27.730 Emily Giant: Never.
252 00:28:27.750 ⇒ 00:28:28.430 Demilade Agboola: Sounds great.
253 00:28:28.490 ⇒ 00:28:32.099 Emily Giant: And then, that way, we can start pushing them towards those.
254 00:28:33.100 ⇒ 00:28:33.720 Demilade Agboola: Okay.
255 00:28:33.910 ⇒ 00:28:34.230 Emily Giant: Right.
256 00:28:34.230 ⇒ 00:28:35.219 Demilade Agboola: Sounds good.
257 00:28:35.220 ⇒ 00:28:41.920 Emily Giant: Alright, thank you so much. Just ping me if you need help with, like… sometimes just two sets of hands doing the work is…
258 00:28:42.750 ⇒ 00:28:46.979 Emily Giant: Faster, so just let me know if I can help you with those, suborders tables.
259 00:28:47.920 ⇒ 00:28:49.510 Demilade Agboola: Okay, sounds good, I will… we’ll do it.
260 00:28:49.510 ⇒ 00:28:51.710 Emily Giant: Alright, cool. Thanks, bud. I’ll talk to you later.
261 00:28:52.370 ⇒ 00:28:53.740 Demilade Agboola: Talk to you later. Bye.