Meeting Title: Daily-Brainforge-Standup-DBT-Power-User-Demo Date: 2024-05-14 Meeting participants: Uttam Kumaran, Agustin, Jakob Kagel, Patrick Trainer, Ryan Luke Daque
WEBVTT
1 00:00:11.710 ⇒ 00:00:12.640 Ryan Luke Daque: Hello! Lou!
2 00:00:17.790 ⇒ 00:00:18.710 Patrick Trainer: Yo yo.
3 00:00:19.590 ⇒ 00:00:21.189 Ryan Luke Daque: Nice! How’s it going.
4 00:00:22.350 ⇒ 00:00:23.410 Jakob Kagel: Hey! How are you?
5 00:00:24.380 ⇒ 00:00:25.759 Ryan Luke Daque: Doing well, doing well.
6 00:00:26.720 ⇒ 00:00:27.789 Patrick Trainer: You had phones with them.
7 00:00:30.450 ⇒ 00:00:32.709 Ryan Luke Daque: We? We can’t hear you, Tom. I think.
8 00:00:32.710 ⇒ 00:00:33.960 Uttam Kumaran: Haven’t now.
9 00:00:33.960 ⇒ 00:00:34.979 Ryan Luke Daque: Yeah, there, you go.
10 00:00:35.430 ⇒ 00:00:36.060 Uttam Kumaran: Alright.
11 00:00:36.640 ⇒ 00:00:38.470 Uttam Kumaran: I just said, How’s it going today?
12 00:00:39.030 ⇒ 00:00:39.680 Patrick Trainer: Well.
13 00:00:40.850 ⇒ 00:00:44.370 Ryan Luke Daque: Yeah. I’ve been battling with real the whole day since yesterday.
14 00:00:46.470 ⇒ 00:00:47.070 Uttam Kumaran: Hit
15 00:00:48.470 ⇒ 00:00:49.019 Uttam Kumaran: yet.
16 00:00:49.020 ⇒ 00:00:51.030 Patrick Trainer: Some new new headphones with them.
17 00:00:52.402 ⇒ 00:00:54.148 Uttam Kumaran: I’ve had these.
18 00:00:54.800 ⇒ 00:00:56.679 Uttam Kumaran: They’re like the sony’s. They’re really nice.
19 00:00:56.680 ⇒ 00:00:57.979 Patrick Trainer: Yeah. It’s sunny.
20 00:00:59.290 ⇒ 00:01:01.130 Uttam Kumaran: It’s just sometimes I like, I’m like.
21 00:01:01.210 ⇒ 00:01:06.660 Uttam Kumaran: Yeah, I’m like, out and about so wearing headphones is a little bit annoying. But I’m just out of we work today. So.
22 00:01:07.040 ⇒ 00:01:07.620 Patrick Trainer: Oh, yeah.
23 00:01:07.620 ⇒ 00:01:08.579 Uttam Kumaran: Spread it sound
24 00:01:11.064 ⇒ 00:01:18.360 Uttam Kumaran: cool. So let’s get started. And then I don’t know. Ryan, do you have time to kind of go through
25 00:01:18.390 ⇒ 00:01:20.940 Uttam Kumaran: Dbt, power user stuff. Today.
26 00:01:20.940 ⇒ 00:01:22.539 Ryan Luke Daque: Yeah, sure, I can do a quick
27 00:01:22.590 ⇒ 00:01:24.650 Ryan Luke Daque: demo. It’s probably gonna be
28 00:01:24.660 ⇒ 00:01:28.279 Ryan Luke Daque: pretty short, anyway, because I don’t even use all the functionality.
29 00:01:29.110 ⇒ 00:01:32.050 Uttam Kumaran: Okay, yeah, just whatever you use that way, we can just see it.
30 00:01:32.050 ⇒ 00:01:32.710 Ryan Luke Daque: Nation.
31 00:01:34.572 ⇒ 00:01:37.060 Uttam Kumaran: Oh, okay. So for
32 00:01:38.640 ⇒ 00:01:42.770 Uttam Kumaran: for asset link. So you’re finalizing this real implementation, this should be done
33 00:01:42.780 ⇒ 00:01:43.930 Uttam Kumaran: today. Right?
34 00:01:43.930 ⇒ 00:01:50.610 Ryan Luke Daque: Yeah, I already have the Pr up. So I just do a bit of like, remove the sec data and stuff. So.
35 00:01:51.680 ⇒ 00:01:52.329 Uttam Kumaran: But that.
36 00:01:53.520 ⇒ 00:01:59.920 Uttam Kumaran: Okay. So for this asset, link AI. So I had a conversation with surf Augustine last yesterday evening.
37 00:02:00.020 ⇒ 00:02:05.789 Uttam Kumaran: So I have enough context. So I’m just gonna begin putting a bunch of stuff in there, basically,
38 00:02:06.360 ⇒ 00:02:08.630 Uttam Kumaran: basically, we want to
39 00:02:09.151 ⇒ 00:02:19.510 Uttam Kumaran: just develop like a quick link chain implementation on top of the asset link data. But we want to do it outside of Snowflake.
40 00:02:19.670 ⇒ 00:02:24.999 Uttam Kumaran: So we we want to probably connect to Snowflake using like the Jdbc connector.
41 00:02:25.060 ⇒ 00:02:28.170 Uttam Kumaran: Bring in that data and then ask some questions over it.
42 00:02:28.507 ⇒ 00:02:30.240 Uttam Kumaran: I’ll put in all the details there.
43 00:02:30.635 ⇒ 00:02:34.540 Uttam Kumaran: And then they’re gonna basically he’s gonna try and host that
44 00:02:34.600 ⇒ 00:02:36.520 Uttam Kumaran: so they can bring them into the product.
45 00:02:37.620 ⇒ 00:02:38.590 Agustin: Short, right.
46 00:02:39.040 ⇒ 00:02:46.659 Agustin: great sorry should. Is this the priority? Or should I work on primus data first?
47 00:02:47.071 ⇒ 00:02:49.539 Uttam Kumaran: The premise would be great cause.
48 00:02:50.147 ⇒ 00:02:51.820 Uttam Kumaran: We’re actually missing
49 00:02:52.000 ⇒ 00:02:53.849 Uttam Kumaran: a lot of that data right now.
50 00:02:53.910 ⇒ 00:02:57.470 Uttam Kumaran: I know the email back. So that would be amazing to work on.
51 00:02:57.790 ⇒ 00:02:58.750 Uttam Kumaran: I will mark that.
52 00:02:58.750 ⇒ 00:02:59.399 Agustin: I wouldn’t.
53 00:02:59.670 ⇒ 00:03:04.479 Agustin: Today I have a lot of free time, so I will take a look. Look up at both. That is.
54 00:03:04.480 ⇒ 00:03:05.210 Uttam Kumaran: Okay, yeah.
55 00:03:06.170 ⇒ 00:03:07.729 Uttam Kumaran: thank you so much.
56 00:03:10.910 ⇒ 00:03:13.620 Uttam Kumaran: cool anything on like the action side.
57 00:03:15.670 ⇒ 00:03:18.720 Patrick Trainer: What? For me? It’s
58 00:03:19.270 ⇒ 00:03:27.510 Patrick Trainer: well there, there’s the like. I’ve gotten the first action like the the called actions. Those are set up and ready to be called
59 00:03:27.916 ⇒ 00:03:31.679 Patrick Trainer: just needs to be implemented in the like. The caller.
60 00:03:31.680 ⇒ 00:03:32.160 Uttam Kumaran: Here! Aye.
61 00:03:32.160 ⇒ 00:03:35.550 Patrick Trainer: So wherever we’re wanting to use that centralized
62 00:03:35.660 ⇒ 00:03:41.940 Patrick Trainer: action app so we just need to drop that in there and that should be good to go.
63 00:03:42.405 ⇒ 00:03:44.659 Patrick Trainer: So yeah, everything’s like teed up
64 00:03:45.628 ⇒ 00:03:55.360 Patrick Trainer: but then there’s the the like. The stellar issue of. They actually use the wrong account and the integration all that, and I’ll need that.
65 00:03:55.360 ⇒ 00:03:55.780 Uttam Kumaran: Yeah.
66 00:03:55.780 ⇒ 00:03:56.490 Patrick Trainer: Redone
67 00:03:57.140 ⇒ 00:03:58.060 Uttam Kumaran: Yeah, it’s.
68 00:03:58.390 ⇒ 00:04:01.720 Patrick Trainer: So I guess I’m figuring that
69 00:04:02.120 ⇒ 00:04:05.500 Patrick Trainer: is going to take priority. I imagine.
70 00:04:05.870 ⇒ 00:04:09.159 Uttam Kumaran: Yeah, that’d be great to to tackle first.
71 00:04:11.180 ⇒ 00:04:11.840 Patrick Trainer: Cool.
72 00:04:12.582 ⇒ 00:04:16.589 Uttam Kumaran: Is there anything you asked? Is there anything you need from his side? I guess we’ll be talking
73 00:04:16.880 ⇒ 00:04:18.399 Uttam Kumaran: after this. But.
74 00:04:22.350 ⇒ 00:04:26.090 Patrick Trainer: no, I’m just I I don’t think so. I’m just gonna have to pass
75 00:04:27.930 ⇒ 00:04:33.830 Patrick Trainer: some values back to him for them to complete on their side, and then
76 00:04:34.452 ⇒ 00:04:38.820 Patrick Trainer: then we’ll have to go through the whole like testing thing of seeing if
77 00:04:39.080 ⇒ 00:04:43.830 Patrick Trainer: we can actually connect to their bucket. And assuming that they have a bucket created, and
78 00:04:44.030 ⇒ 00:04:44.920 Patrick Trainer: all of that.
79 00:04:44.920 ⇒ 00:04:45.570 Uttam Kumaran: Okay.
80 00:04:45.760 ⇒ 00:04:46.620 Uttam Kumaran: Oh, guys.
81 00:04:47.630 ⇒ 00:04:49.627 Uttam Kumaran: okay, cool. Then I’m gonna move.
82 00:04:51.620 ⇒ 00:04:55.246 Uttam Kumaran: the azure thing back the same one.
83 00:04:56.460 ⇒ 00:04:59.932 Uttam Kumaran: But okay, I’m glad we’re going through it, I guess.
84 00:05:01.150 ⇒ 00:05:07.119 Uttam Kumaran: Maybe the maybe the other thing is, I can also add a note to create like a little azure.
85 00:05:07.470 ⇒ 00:05:11.310 Uttam Kumaran: Wait, you’re gonna so you’re gonna commit all that storage integration code to the repo. Right?
86 00:05:11.700 ⇒ 00:05:13.790 Patrick Trainer: So that’s already that’s already committed.
87 00:05:13.790 ⇒ 00:05:15.549 Uttam Kumaran: It’s already there. Yeah, okay.
88 00:05:15.550 ⇒ 00:05:16.889 Patrick Trainer: Yeah. So I think.
89 00:05:17.130 ⇒ 00:05:18.570 Patrick Trainer: what like.
90 00:05:18.990 ⇒ 00:05:29.309 Patrick Trainer: we should actually create like a new ticket, and then just link it to this one. Because this is like, it’s for a separate organization or a after organization. So I guess
91 00:05:30.200 ⇒ 00:05:31.140 Patrick Trainer: I mean.
92 00:05:31.140 ⇒ 00:05:31.610 Uttam Kumaran: I said.
93 00:05:31.610 ⇒ 00:05:32.540 Patrick Trainer: We’ll have 2.
94 00:05:32.540 ⇒ 00:05:33.749 Uttam Kumaran: We just won’t have 2. Yeah.
95 00:05:33.750 ⇒ 00:05:35.020 Patrick Trainer: Large integrations.
96 00:05:37.910 ⇒ 00:05:40.200 Patrick Trainer: and then like, if we want the
97 00:05:41.100 ⇒ 00:05:45.429 Patrick Trainer: cancel one or the other like, then we’ll then we’ll just do that. But
98 00:05:45.470 ⇒ 00:05:46.489 Patrick Trainer: yeah, I think
99 00:05:47.150 ⇒ 00:05:51.480 Patrick Trainer: the new ticket is probably the best way to go there.
100 00:05:51.480 ⇒ 00:05:53.590 Uttam Kumaran: Is there an easy way to duplicate these.
101 00:05:56.230 ⇒ 00:05:57.530 Uttam Kumaran: Maybe maybe not.
102 00:05:57.530 ⇒ 00:05:58.620 Patrick Trainer: Not that I know of.
103 00:05:59.000 ⇒ 00:05:59.900 Patrick Trainer: I don’t know.
104 00:06:01.190 ⇒ 00:06:04.449 Patrick Trainer: Can you highlight the like entire row? And then.
105 00:06:07.130 ⇒ 00:06:07.870 Uttam Kumaran: Think so?
106 00:06:08.050 ⇒ 00:06:09.920 Patrick Trainer: Maybe. Yeah, I don’t know
107 00:06:20.120 ⇒ 00:06:20.800 Patrick Trainer: proved.
108 00:06:27.970 ⇒ 00:06:31.180 Patrick Trainer: And then if you yeah, if you just wanna assign me, I can fill out the
109 00:06:31.320 ⇒ 00:06:32.250 Patrick Trainer: fill up the rest.
110 00:06:32.250 ⇒ 00:06:32.920 Uttam Kumaran: Yeah, okay.
111 00:06:36.910 ⇒ 00:06:38.040 Uttam Kumaran: thank you.
112 00:06:39.290 ⇒ 00:06:42.029 Uttam Kumaran: I like the milestone. We will say.
113 00:06:42.030 ⇒ 00:06:43.559 Patrick Trainer: Oh, yeah, yeah, yeah.
114 00:06:44.300 ⇒ 00:06:46.299 Patrick Trainer: yeah. It was dead. It was.
115 00:06:46.300 ⇒ 00:06:48.519 Uttam Kumaran: I’m gonna I’m gonna try and create something.
116 00:06:48.970 ⇒ 00:06:52.530 Uttam Kumaran: create some new views, too. Cause. Now that we have, like.
117 00:06:52.600 ⇒ 00:06:55.382 Uttam Kumaran: I wanna start looking at like creation versus
118 00:06:56.160 ⇒ 00:06:58.520 Uttam Kumaran: like, when it was like the drawdown, so.
119 00:07:00.292 ⇒ 00:07:02.267 Patrick Trainer: Like like burn ups and stuff or.
120 00:07:02.550 ⇒ 00:07:03.250 Uttam Kumaran: Yeah.
121 00:07:03.900 ⇒ 00:07:06.830 Patrick Trainer: If you go into the little chart thing on the top right?
122 00:07:08.630 ⇒ 00:07:09.400 Patrick Trainer: Yeah.
123 00:07:10.120 ⇒ 00:07:11.459 Patrick Trainer: Like, got those thing.
124 00:07:12.030 ⇒ 00:07:12.625 Uttam Kumaran: Yeah.
125 00:07:13.580 ⇒ 00:07:15.300 Patrick Trainer: If that’s if that’s what you meant.
126 00:07:15.640 ⇒ 00:07:18.002 Uttam Kumaran: Yeah, basically, I also, wanna look at
127 00:07:18.440 ⇒ 00:07:23.879 Uttam Kumaran: I mean, basically, I wanna look at it based what we’ll once we start organizing like by weeks.
128 00:07:24.060 ⇒ 00:07:25.269 Uttam Kumaran: Think we’ll get a little bit.
129 00:07:25.270 ⇒ 00:07:26.140 Patrick Trainer: Yeah, right.
130 00:07:26.900 ⇒ 00:07:28.599 Uttam Kumaran: Seeing all of them get drawn down.
131 00:07:31.390 ⇒ 00:07:35.049 Uttam Kumaran: cool. Okay, great. So yeah. The Stella stuff would be great.
132 00:07:36.625 ⇒ 00:07:37.820 Uttam Kumaran: On
133 00:07:38.250 ⇒ 00:07:40.589 Uttam Kumaran: cool parts. So
134 00:07:40.870 ⇒ 00:07:45.370 Uttam Kumaran: this shipping dashboard work is done.
135 00:07:45.798 ⇒ 00:07:52.070 Uttam Kumaran: I’ll maybe demo a little bit of it on Friday. But, Jacob, I’ll respond to your note today.
136 00:07:52.502 ⇒ 00:07:57.597 Uttam Kumaran: There’s just a lot of logic that I actually need to really document
137 00:07:58.120 ⇒ 00:08:03.810 Uttam Kumaran: because we have multiple different storefronts using multiple different shipping providers.
138 00:08:04.000 ⇒ 00:08:05.140 Uttam Kumaran: awesome.
139 00:08:05.270 ⇒ 00:08:07.160 Jakob Kagel: I was thinking, Yeah.
140 00:08:07.160 ⇒ 00:08:10.650 Uttam Kumaran: And the join keys are all over the place.
141 00:08:10.820 ⇒ 00:08:11.585 Uttam Kumaran: And
142 00:08:14.050 ⇒ 00:08:16.879 Uttam Kumaran: yeah, it’s just fucking. It’s kind of ridiculous.
143 00:08:17.405 ⇒ 00:08:21.324 Uttam Kumaran: So we’ll we. I’ll add a lot of that.
144 00:08:22.100 ⇒ 00:08:26.490 Uttam Kumaran: I guess, just to close this one out. So, Ryan, I wanna make sure that this
145 00:08:26.930 ⇒ 00:08:31.750 Uttam Kumaran: is has everything you need for the shipments dashboard.
146 00:08:33.860 ⇒ 00:08:42.630 Uttam Kumaran: because I know I made bunch of changes on this one. So it’s kind of like I wanna make sure that it has all the columns you need. And then, in case you need more columns.
147 00:08:43.360 ⇒ 00:08:49.070 Uttam Kumaran: we can basically bring it in or modify like the light dash
148 00:08:50.000 ⇒ 00:08:52.329 Uttam Kumaran: to bring it in as a join, so.
149 00:08:52.960 ⇒ 00:09:02.163 Ryan Luke Daque: Yeah, I’ll have to take a look again, because I I haven’t checked the light dash version that I created after you updated the model. So yeah, I’ll check.
150 00:09:02.470 ⇒ 00:09:07.770 Uttam Kumaran: Yeah, we can do this. Yeah, we can do this after, as after real stuff is done.
151 00:09:08.211 ⇒ 00:09:11.526 Uttam Kumaran: And then that should be the honest 2 big hurdles.
152 00:09:13.190 ⇒ 00:09:19.909 Uttam Kumaran: So I’m excited for that. I know. That’s this one is directly blocking this.
153 00:09:20.354 ⇒ 00:09:25.830 Uttam Kumaran: Jacob, I know you. You just sent a note back to Wild, and then also the intelligent stuff.
154 00:09:26.290 ⇒ 00:09:43.699 Jakob Kagel: Yeah, exactly. Intelligence and spend some more time on that today. Just try to make sure that I’m as familiar through the platform as I can be before I meet with them. Just so that we can make sure we get all squared away this week. Yeah, exactly like.
155 00:09:43.820 ⇒ 00:09:50.719 Jakob Kagel: Clint replied. From Wild. Said they would give put together a report, I think, by the end of this week.
156 00:09:51.200 ⇒ 00:10:00.299 Jakob Kagel: And then yeah, on the shipping stuff. Yeah, just let me know if I can help there in any way. I mean, I kinda agree, I agree with what you’re saying, and that’s kind of like
157 00:10:00.570 ⇒ 00:10:04.819 Jakob Kagel: the part that I wanted to parse out to is like, Yeah.
158 00:10:04.900 ⇒ 00:10:13.750 Jakob Kagel: obviously, whatever shipping the Jacksonville versus New York, or like, you know, these scenarios up where it’s like, actually cheaper. But there’s like a lot of
159 00:10:14.050 ⇒ 00:10:17.685 Jakob Kagel: different variables that we have to consider there.
160 00:10:18.500 ⇒ 00:10:34.529 Jakob Kagel: and yeah, that’s just sort of. I just wanted to discuss that a little bit before putting starting to put it together. So yeah, just let me know. I mean happy to go ahead and discuss some of it, or try to help with any of the stuff that you’re working on there as well.
161 00:10:34.530 ⇒ 00:10:37.090 Uttam Kumaran: Yeah, let me let me notes out all the
162 00:10:37.160 ⇒ 00:10:41.039 Uttam Kumaran: I’m gonna go through and do a pass of like some documentation on shipping
163 00:10:41.070 ⇒ 00:10:46.650 Uttam Kumaran: cause. Honestly, I think, and then that’ll be good for our conversations. Then. Yeah, it’d be amazing if you can.
164 00:10:46.907 ⇒ 00:11:02.090 Uttam Kumaran: Then begin to take a look at some of the next analysis, because a lot of the shipping stuff is in my head, so I would love to kind of get it out into a document, and then kind of share with you as well. So you kind of have a really good understanding. We do get a lot of questions about shipping, so.
165 00:11:02.420 ⇒ 00:11:07.339 Jakob Kagel: Yeah, real quick. Just on just quick question. So do they?
166 00:11:08.100 ⇒ 00:11:25.217 Jakob Kagel: I know you mentioned like, do they sign like a contract with like a new, like third party logistics like company to do all their shipping like? Is all their shipping done through the same sort of provider? Or did they use different providers based on different regions and stuff like? How fragmented.
167 00:11:25.540 ⇒ 00:11:35.049 Uttam Kumaran: It’s pretty. It’s different. It’s different, based on different regions. So it’s also different, based on different products. So all of their large pumps have to go on freight.
168 00:11:35.130 ⇒ 00:11:38.610 Uttam Kumaran: So they were previously using Ltl. Which is a Fedex
169 00:11:38.670 ⇒ 00:11:44.919 Uttam Kumaran: like freight company. They just move from Ltl. To Primus, though. So that’s what Augustine is working on.
170 00:11:45.120 ⇒ 00:11:48.050 Uttam Kumaran: So they’re moving to another provider for that.
171 00:11:48.110 ⇒ 00:11:51.230 Uttam Kumaran: completely outright. So from Ltl. To Primus
172 00:11:52.360 ⇒ 00:11:54.940 Uttam Kumaran: they also are using ship station
173 00:11:55.020 ⇒ 00:12:02.200 Uttam Kumaran: for anything, for a certain amount of regions and a certain amount of products. Ship station then pipes the ups
174 00:12:02.430 ⇒ 00:12:04.440 Uttam Kumaran: to Fedex to usps.
175 00:12:04.820 ⇒ 00:12:05.270 Jakob Kagel: Okay.
176 00:12:05.270 ⇒ 00:12:09.130 Uttam Kumaran: And then they use. And then they’re using. Unis was A, which is a Threepl.
177 00:12:09.310 ⇒ 00:12:11.730 Uttam Kumaran: And Eunice has Jacksonville.
178 00:12:12.050 ⇒ 00:12:14.369 Uttam Kumaran: and then they’re also opening up California
179 00:12:14.460 ⇒ 00:12:17.059 Uttam Kumaran: for for their third party logistics.
180 00:12:18.530 ⇒ 00:12:23.530 Uttam Kumaran: so there’s so I will put all the criteria based on basically like, what’s the decision tree? There.
181 00:12:24.130 ⇒ 00:12:24.720 Jakob Kagel: Right.
182 00:12:24.720 ⇒ 00:12:27.159 Uttam Kumaran: This next question is like, Where should there.
183 00:12:27.180 ⇒ 00:12:31.509 Uttam Kumaran: W. Should we open another? Should we push units to open another?
184 00:12:31.760 ⇒ 00:12:40.919 Uttam Kumaran: 3 pl. In. In like in the middle of the country where California, New York, and Florida do not really like hit.
185 00:12:41.140 ⇒ 00:12:49.680 Uttam Kumaran: That’s like kind of like what this is, and just generally getting. Your also would love to get your just like looking at all this data and kind of like finding out just some things. So.
186 00:12:49.840 ⇒ 00:13:00.134 Jakob Kagel: Yeah, definitely. I mean, I think shipping is probably an area where we can add, like the most value. Or like, you know, one of the areas we can add the most value for sure. So
187 00:13:00.420 ⇒ 00:13:01.220 Uttam Kumaran: Yeah, it.
188 00:13:01.220 ⇒ 00:13:07.420 Jakob Kagel: Sounds like it’s a bit of a mess. But that’s you know, that’s kinda good, because that means that there’s problems for us to solve.
189 00:13:07.420 ⇒ 00:13:14.400 Uttam Kumaran: Yeah, yeah, no. The data is really, really rich. I like the data a lot. It’s like, really cool logistics data. So.
190 00:13:14.610 ⇒ 00:13:20.870 Jakob Kagel: Yeah, okay, well, cool. I mean, yeah, exactly. Just let me know. I mean, I’m happy to to to chat whenever
191 00:13:21.630 ⇒ 00:13:22.310 Jakob Kagel: cool.
192 00:13:22.750 ⇒ 00:13:29.580 Jakob Kagel: Oh, and then, yeah, I have the meeting with you this afternoon on refunds. But that’s that’s basically it for me.
193 00:13:30.090 ⇒ 00:13:34.394 Uttam Kumaran: Nice, and you you’re and I I know I message you on slack. But you’re able to get actually get into the
194 00:13:34.910 ⇒ 00:13:37.670 Uttam Kumaran: to the evidence. Thing right?
195 00:13:37.670 ⇒ 00:13:38.360 Jakob Kagel: Yeah.
196 00:13:38.890 ⇒ 00:13:39.620 Jakob Kagel: call.
197 00:13:40.000 ⇒ 00:13:40.660 Uttam Kumaran: Nice.
198 00:13:41.220 ⇒ 00:13:43.292 Uttam Kumaran: This looks really good.
199 00:13:44.680 ⇒ 00:13:45.615 Uttam Kumaran: cool.
200 00:13:48.370 ⇒ 00:13:52.889 Uttam Kumaran: so August. And I think probably the Zendesk AI thing. Let’s just keep that on the back burner.
201 00:13:53.456 ⇒ 00:13:56.160 Uttam Kumaran: The primeest thing is the number one.
202 00:13:57.960 ⇒ 00:13:58.869 Agustin: Short priority.
203 00:13:58.870 ⇒ 00:13:59.860 Uttam Kumaran: Right now.
204 00:14:00.100 ⇒ 00:14:03.759 Uttam Kumaran: I don’t know where it is that is. Oh, it’s right here, I think right here.
205 00:14:07.400 ⇒ 00:14:09.800 Uttam Kumaran: okay. I honestly think that
206 00:14:10.920 ⇒ 00:14:16.299 Uttam Kumaran: that. May be it so. I think everybody the biggest stuff is like
207 00:14:16.350 ⇒ 00:14:22.327 Uttam Kumaran: getting the asset link roll out and working on the AI for them for pull parts. It’s the
208 00:14:22.860 ⇒ 00:14:29.160 Uttam Kumaran: primus integration. It’s and Jacob, you’re basically leading a lot of the analysis. And then it’s finishing shipping.
209 00:14:29.170 ⇒ 00:14:37.319 Uttam Kumaran: And then for Stella Pat, you’re just owning the storage integration. And then we’re gonna talk to them in 15 about just like the overall status.
210 00:14:38.000 ⇒ 00:14:38.740 Uttam Kumaran: Yep.
211 00:14:40.570 ⇒ 00:14:48.588 Uttam Kumaran: okay, sick, I guess, for the time remaining. Ryan, if you want to do a brief demo, Ryan is using this
212 00:14:48.980 ⇒ 00:14:58.289 Uttam Kumaran: dB, this dbt, Vs code extension. That’s kind of like supposed to be helpful for Dbt development. So I was just asking if you wanted to share
213 00:15:00.770 ⇒ 00:15:01.889 Uttam Kumaran: how works.
214 00:15:02.040 ⇒ 00:15:02.766 Ryan Luke Daque: Yeah, sure.
215 00:15:03.923 ⇒ 00:15:09.259 Ryan Luke Daque: so yeah, and this might be helpful. For like people who want to like develop in Dvt.
216 00:15:09.300 ⇒ 00:15:11.410 Ryan Luke Daque: like, maybe Jacob or something.
217 00:15:11.920 ⇒ 00:15:20.140 Ryan Luke Daque: So yeah, basically, it’s the this extension. There’s it’s called Bt power user. I installed this one.
218 00:15:20.480 ⇒ 00:15:23.684 Ryan Luke Daque: this one dB, a power user for Dbd core.
219 00:15:24.230 ⇒ 00:15:32.990 Ryan Luke Daque: And basically what there’s a lot of things that you can do here like it has, like auto complete for DVD code, like the the ginger and stuff
220 00:15:33.658 ⇒ 00:15:42.619 Ryan Luke Daque: it has like preview query results. So this is basically what I mostly use this for. So I don’t have to like, compile the code and query it, and snowflake
221 00:15:42.990 ⇒ 00:15:45.830 Ryan Luke Daque: and stuff like that. I just directly
222 00:15:46.040 ⇒ 00:15:49.830 Ryan Luke Daque: preview the results of the model query that I’m doing.
223 00:15:50.060 ⇒ 00:15:53.199 Ryan Luke Daque: Also as Columbine. She’s also great.
224 00:15:53.770 ⇒ 00:15:58.709 Ryan Luke Daque: It has like this generate dB models coming from sources basically to me.
225 00:15:58.750 ⇒ 00:15:59.880 Ryan Luke Daque: So it
226 00:16:00.360 ⇒ 00:16:01.370 Ryan Luke Daque: basically
227 00:16:01.460 ⇒ 00:16:08.499 Ryan Luke Daque: automatically creates the staging model for you. You just have to update a couple of things like maybe renaming
228 00:16:08.510 ⇒ 00:16:10.720 Ryan Luke Daque: fields, or like adding basic
229 00:16:10.740 ⇒ 00:16:13.500 Ryan Luke Daque: calculation, logic or something stuff like that.
230 00:16:13.640 ⇒ 00:16:16.429 Ryan Luke Daque: I can show you that in a bit later.
231 00:16:16.670 ⇒ 00:16:25.669 Ryan Luke Daque: And yeah, there’s there’s a couple of other things like generate documentation. If we are, currently, we’re not like documenting all our models. But this is also like, good to do
232 00:16:26.460 ⇒ 00:16:27.100 Ryan Luke Daque: yeah.
233 00:16:28.632 ⇒ 00:16:36.120 Ryan Luke Daque: I can. I can like show you a couple of things. So currently, I’m in the Asset Link project at the moment. But.
234 00:16:37.100 ⇒ 00:16:40.870 Ryan Luke Daque: for example, let’s go to like one of the models here.
235 00:16:41.270 ⇒ 00:16:42.650 Ryan Luke Daque: So basically.
236 00:16:44.012 ⇒ 00:16:50.009 Ryan Luke Daque: you’ll be able to know that you have dB installed because, like, this is. The dB core at the bottom is like.
237 00:16:50.390 ⇒ 00:16:51.970 Ryan Luke Daque: has a checkmark in it.
238 00:16:52.260 ⇒ 00:16:54.460 Ryan Luke Daque: and you can click on it, and you can do like
239 00:16:56.220 ⇒ 00:16:57.060 Ryan Luke Daque: You can
240 00:16:57.810 ⇒ 00:17:01.289 Ryan Luke Daque: set up documentation and run, project, health check even.
241 00:17:02.890 ⇒ 00:17:05.380 Ryan Luke Daque: yeah. But like
242 00:17:05.680 ⇒ 00:17:10.620 Ryan Luke Daque: one useful thing that I I am doing, for this is like the query.
243 00:17:11.690 ⇒ 00:17:12.310 Ryan Luke Daque: Preview.
244 00:17:12.730 ⇒ 00:17:21.039 Ryan Luke Daque: So like, if this model, for example, this SQL career, all I have to do is just press control enter. And it basically
245 00:17:21.540 ⇒ 00:17:23.909 Ryan Luke Daque: displays the result here. Like
246 00:17:24.119 ⇒ 00:17:26.699 Ryan Luke Daque: I’m querying it in SQL. Or something
247 00:17:26.990 ⇒ 00:17:28.660 Ryan Luke Daque: with a limit or something.
248 00:17:28.890 ⇒ 00:17:33.750 Jakob Kagel: So what is this? This is our all users like, okay. First.
249 00:17:33.750 ⇒ 00:17:34.100 Ryan Luke Daque: Yeah.
250 00:17:34.100 ⇒ 00:17:35.600 Jakob Kagel: Nice. Now, okay.
251 00:17:35.600 ⇒ 00:17:37.520 Uttam Kumaran: Also, you don’t have to like compile it.
252 00:17:37.520 ⇒ 00:17:37.950 Ryan Luke Daque: Yeah.
253 00:17:37.950 ⇒ 00:17:42.229 Uttam Kumaran: Put it into Snowflake. Run it! I’ll do that, that’s all I was doing for like 9 h. That’s right.
254 00:17:42.230 ⇒ 00:17:47.689 Ryan Luke Daque: It saves a lot of time. Yeah, cause I don’t have to do a dB compile and copy all the code and do go through.
255 00:17:47.690 ⇒ 00:17:49.520 Uttam Kumaran: I’m sorry. That’s all I was doing.
256 00:17:50.000 ⇒ 00:17:50.480 Ryan Luke Daque: Yes.
257 00:17:50.480 ⇒ 00:17:53.949 Patrick Trainer: That’s like a that’s a cloud killer to me. No.
258 00:17:53.950 ⇒ 00:18:01.401 Ryan Luke Daque: Yeah, yeah, this is like, what Dbt cloud is doing, and you can do it here. So yeah. So like, I, I.
259 00:18:02.160 ⇒ 00:18:02.830 Jakob Kagel: Sorry go ahead.
260 00:18:02.830 ⇒ 00:18:03.870 Ryan Luke Daque: Yeah. Good. Go ahead.
261 00:18:04.440 ⇒ 00:18:08.489 Jakob Kagel: I was. Gonna say, all this data is coming from shopify, or this is like.
262 00:18:09.445 ⇒ 00:18:12.100 Ryan Luke Daque: On on the query, you’re running here in dB.
263 00:18:12.100 ⇒ 00:18:12.690 Jakob Kagel: Private.
264 00:18:13.130 ⇒ 00:18:13.530 Ryan Luke Daque: Yeah.
265 00:18:13.530 ⇒ 00:18:15.300 Jakob Kagel: But this one specifically.
266 00:18:15.300 ⇒ 00:18:20.439 Ryan Luke Daque: This one. Specifically, since this is asset link. This is like users, data from asset link.
267 00:18:20.440 ⇒ 00:18:21.030 Jakob Kagel: But
268 00:18:21.660 ⇒ 00:18:22.759 Jakob Kagel: oh, okay, okay.
269 00:18:22.760 ⇒ 00:18:26.979 Ryan Luke Daque: Yeah, like, coming from web events and like their postgres tables. Yeah, this isn’t.
270 00:18:26.980 ⇒ 00:18:27.370 Uttam Kumaran: Yeah.
271 00:18:29.000 ⇒ 00:18:34.930 Ryan Luke Daque: But yeah, like, you can easily check and any errors here, or like, sometimes when I do like
272 00:18:36.380 ⇒ 00:18:38.500 Ryan Luke Daque: like investigation, I just like
273 00:18:38.720 ⇒ 00:18:40.330 Ryan Luke Daque: of this thing
274 00:18:40.490 ⇒ 00:18:43.030 Ryan Luke Daque: full name, for example, or something. I mean.
275 00:18:43.680 ⇒ 00:18:49.019 Ryan Luke Daque: I’ll be able to see it directly here. I don’t have to do it in Snowflake. I just yeah.
276 00:18:50.890 ⇒ 00:18:57.489 Jakob Kagel: So for this one like you have the All users sequel, and then you have, like the all users. Yaml, there.
277 00:18:57.490 ⇒ 00:18:57.850 Ryan Luke Daque: Like.
278 00:18:58.110 ⇒ 00:19:04.890 Jakob Kagel: Is the Yaml, is that basically where you put in like the Api, so that you can access the data from asset link, or whatever source.
279 00:19:06.760 ⇒ 00:19:14.059 Ryan Luke Daque: Not really. But this is the model cmo, file. This is like in Dbt, basically, this is where you like.
280 00:19:14.130 ⇒ 00:19:22.590 Ryan Luke Daque: put descriptions to whatever other the the fields, and like what dimension they are. This is also like tied up to light dash, basically
281 00:19:22.890 ⇒ 00:19:24.130 Ryan Luke Daque: because, like.
282 00:19:24.340 ⇒ 00:19:30.244 Ryan Luke Daque: you would be able to determine whether the field is a dimension or or metric, and like, if it’s a metric, it has, like
283 00:19:30.720 ⇒ 00:19:36.910 Ryan Luke Daque: logic into it like it’s count distinct users to be able to know like, it’s the counting users and stuff.
284 00:19:37.120 ⇒ 00:19:48.089 Ryan Luke Daque: And this is also where you can put tests where we are doing currently doing tests to make sure. Like, we’re not duplicating roles. Or like, we have unique ids and and stuff like that. Basically.
285 00:19:48.545 ⇒ 00:19:52.120 Ryan Luke Daque: What you were referring to, I guess, was the sources Yaml.
286 00:19:52.300 ⇒ 00:20:00.169 Ryan Luke Daque: where this is also yamo format. But it’s for the sources. This is where we get connection from Snowflake into
287 00:20:00.550 ⇒ 00:20:04.450 Ryan Luke Daque: Dbt, basically getting the table out of snowflake and like
288 00:20:05.280 ⇒ 00:20:06.130 Ryan Luke Daque: make it
289 00:20:06.460 ⇒ 00:20:10.050 Ryan Luke Daque: such that DVD. Can like, do queries on it.
290 00:20:11.090 ⇒ 00:20:11.910 Jakob Kagel: Okay.
291 00:20:12.720 ⇒ 00:20:13.310 Ryan Luke Daque: Yeah.
292 00:20:14.760 ⇒ 00:20:22.650 Ryan Luke Daque: so yeah, going back to dbt, power user. This is like one of the best things that I’m like
293 00:20:22.940 ⇒ 00:20:25.990 Ryan Luke Daque: doing, like doing just a query. It helps a lot
294 00:20:26.428 ⇒ 00:20:32.549 Ryan Luke Daque: lineage. You can also see the needs here. So like for all users, for example, you can see all the down screen
295 00:20:32.650 ⇒ 00:20:33.800 Ryan Luke Daque: models.
296 00:20:35.110 ⇒ 00:20:36.259 Ryan Luke Daque: and you can like click on.
297 00:20:36.260 ⇒ 00:20:42.279 Agustin: Sorry I I have a quick question. Can you see the column lineage, too, or only
298 00:20:42.350 ⇒ 00:20:43.490 Agustin: tables?
299 00:20:43.490 ⇒ 00:20:48.120 Ryan Luke Daque: Yeah, like, if you go to like that. That was like the old
300 00:20:48.440 ⇒ 00:20:54.389 Ryan Luke Daque: other old ui like, if this is I click the new Ui here you should be able to see
301 00:20:54.970 ⇒ 00:20:58.219 Ryan Luke Daque: the details here and like, see the columns right
302 00:20:59.260 ⇒ 00:21:03.250 Ryan Luke Daque: over here, and you’ll be able to see like for this one, for example.
303 00:21:03.998 ⇒ 00:21:09.980 Ryan Luke Daque: stage post guest production going to 2 down screen models, you’ll be able to see
304 00:21:11.045 ⇒ 00:21:11.560 Ryan Luke Daque: but
305 00:21:13.060 ⇒ 00:21:14.859 Ryan Luke Daque: yeah, you you’ll be able to.
306 00:21:14.860 ⇒ 00:21:15.520 Patrick Trainer: Eyes.
307 00:21:15.520 ⇒ 00:21:18.859 Ryan Luke Daque: Yeah, see all the stuff here. So these are the columns.
308 00:21:19.170 ⇒ 00:21:19.819 Ryan Luke Daque: and you can also.
309 00:21:20.455 ⇒ 00:21:21.090 Uttam Kumaran: Nice.
310 00:21:21.090 ⇒ 00:21:21.800 Ryan Luke Daque: Swell.
311 00:21:25.020 ⇒ 00:21:27.450 Ryan Luke Daque: or was that? Did that answer your question?
312 00:21:27.670 ⇒ 00:21:28.659 Ryan Luke Daque: I just think.
313 00:21:31.217 ⇒ 00:21:32.290 Agustin: Yes, thank you.
314 00:21:32.290 ⇒ 00:21:33.890 Ryan Luke Daque: Yeah, oops.
315 00:21:37.100 ⇒ 00:21:37.830 Ryan Luke Daque: I
316 00:21:39.060 ⇒ 00:21:40.970 Ryan Luke Daque: so let me click my PIN now.
317 00:21:41.290 ⇒ 00:21:42.100 Ryan Luke Daque: But yeah, what.
318 00:21:42.100 ⇒ 00:21:44.100 Uttam Kumaran: What did you? What did you use to run it again?
319 00:21:44.910 ⇒ 00:21:45.879 Ryan Luke Daque: What was that?
320 00:21:46.230 ⇒ 00:21:49.469 Uttam Kumaran: What did what did you press to run it like to run the.
321 00:21:49.640 ⇒ 00:21:55.295 Ryan Luke Daque: It was Con. The short cut was control. Enter. But I don’t know if you have any other.
322 00:21:55.610 ⇒ 00:21:56.470 Uttam Kumaran: Share or something. Okay.
323 00:21:56.470 ⇒ 00:21:59.180 Ryan Luke Daque: And making a conflict. So you’ll have to check to see
324 00:21:59.360 ⇒ 00:22:01.179 Ryan Luke Daque: you have several other
325 00:22:01.370 ⇒ 00:22:04.189 Ryan Luke Daque: extensions. They might have a conflict or something.
326 00:22:04.740 ⇒ 00:22:11.870 Ryan Luke Daque: Yeah, those are basically the 2 main things that I’m doing with it. But you can do other stuff
327 00:22:12.080 ⇒ 00:22:12.949 Ryan Luke Daque: like,
328 00:22:13.990 ⇒ 00:22:16.040 Ryan Luke Daque: yeah, I can show you like how
329 00:22:16.270 ⇒ 00:22:22.700 Ryan Luke Daque: you can instantly create a staging model out of a source like if you go to sources, Yaml, for example.
330 00:22:22.810 ⇒ 00:22:28.600 Ryan Luke Daque: And once you have Dbt power user installed, you can see this generate model thing
331 00:22:28.960 ⇒ 00:22:35.449 Ryan Luke Daque: like from post hog, for example, events table, you click the generate model. It basically creates a staging model.
332 00:22:36.470 ⇒ 00:22:42.230 Ryan Luke Daque: It’s selecting from a source, gets a rename cte where you can like rename this
333 00:22:42.730 ⇒ 00:22:45.399 Ryan Luke Daque: new view. Id, for example, whatever
334 00:22:47.611 ⇒ 00:22:51.700 Ryan Luke Daque: or like do like basic calculations. For example.
335 00:22:53.460 ⇒ 00:22:57.690 Ryan Luke Daque: like, if this is a number, and then you have to divide it by 100 or whatever.
336 00:22:57.760 ⇒ 00:23:02.699 Ryan Luke Daque: So you can do it here, you can do. You can basically already have a staging model.
337 00:23:02.910 ⇒ 00:23:03.970 Ryan Luke Daque: And
338 00:23:04.160 ⇒ 00:23:05.209 Ryan Luke Daque: yeah, which is
339 00:23:05.480 ⇒ 00:23:07.969 Ryan Luke Daque: pretty insane. If you ask me, like, you can.
340 00:23:08.050 ⇒ 00:23:09.860 Ryan Luke Daque: you don’t have to write this down?
341 00:23:10.740 ⇒ 00:23:16.209 Ryan Luke Daque: Yeah, and just put it wherever rename it, rename the model, or, like.
342 00:23:16.220 ⇒ 00:23:18.210 Ryan Luke Daque: put it in a different folder, whatever.
343 00:23:19.850 ⇒ 00:23:22.370 Patrick Trainer: The way the way I’ve done it in the past. I’ve
344 00:23:22.750 ⇒ 00:23:25.059 Patrick Trainer: I read a SQL. Query that like
345 00:23:25.280 ⇒ 00:23:27.310 Patrick Trainer: generates it. Basically.
346 00:23:28.040 ⇒ 00:23:30.680 Ryan Luke Daque: Right now, it’s just here, basically.
347 00:23:30.680 ⇒ 00:23:31.629 Patrick Trainer: Yeah, yeah, yeah.
348 00:23:33.360 ⇒ 00:23:36.640 Ryan Luke Daque: Yeah, that one that’s also helpful, especially when
349 00:23:36.880 ⇒ 00:23:41.210 Ryan Luke Daque: for new projects, like new sources, you have to create staging models.
350 00:23:42.130 ⇒ 00:23:45.210 Ryan Luke Daque: Another thing you can do is also
351 00:23:45.770 ⇒ 00:23:49.688 Ryan Luke Daque: like you can click on the extension and like whatever
352 00:23:50.590 ⇒ 00:23:57.920 Ryan Luke Daque: model you’re looking at, you can see, like what the parent models are, what the child children. Models are the downstream models.
353 00:23:58.714 ⇒ 00:24:01.380 Ryan Luke Daque: The tests for that specific model.
354 00:24:02.030 ⇒ 00:24:03.960 Ryan Luke Daque: even documentation.
355 00:24:04.250 ⇒ 00:24:05.889 Ryan Luke Daque: like, if you ever have.
356 00:24:06.140 ⇒ 00:24:13.769 Ryan Luke Daque: if we have documentation for description for the field. For example, you can click. And it’s like Ui based. That’s why, like, I don’t
357 00:24:13.810 ⇒ 00:24:17.329 Ryan Luke Daque: either. You just use it because you can. You can just
358 00:24:17.860 ⇒ 00:24:18.710 Ryan Luke Daque: critic.
359 00:24:18.710 ⇒ 00:24:19.150 Patrick Trainer: Could you.
360 00:24:19.160 ⇒ 00:24:19.660 Ryan Luke Daque: Of them.
361 00:24:19.660 ⇒ 00:24:22.179 Patrick Trainer: If you, if you write in the
362 00:24:22.510 ⇒ 00:24:26.560 Patrick Trainer: in like, the describe your model, does that write to the Yaml file.
363 00:24:27.110 ⇒ 00:24:29.360 Ryan Luke Daque: I haven’t tested it. We can. We can test it out.
364 00:24:30.450 ⇒ 00:24:32.090 Ryan Luke Daque: That’s this portion.
365 00:24:34.890 ⇒ 00:24:37.572 Ryan Luke Daque: Let’s see. Like, how do I go to the
366 00:24:39.680 ⇒ 00:24:40.960 Ryan Luke Daque: The events.
367 00:24:43.010 ⇒ 00:24:44.559 Ryan Luke Daque: Yeah, it looks like it did.
368 00:24:48.160 ⇒ 00:24:48.860 Ryan Luke Daque: Weapon.
369 00:24:53.190 ⇒ 00:24:55.060 Ryan Luke Daque: Where’s this?
370 00:25:09.620 ⇒ 00:25:10.579 Ryan Luke Daque: Try it again.
371 00:25:12.520 ⇒ 00:25:13.110 Patrick Trainer: Maybe.
372 00:25:17.530 ⇒ 00:25:18.300 Ryan Luke Daque: Sydney
373 00:25:18.950 ⇒ 00:25:22.429 Ryan Luke Daque: doesn’t look like it’s seeing maybe I have to click something.
374 00:25:24.830 ⇒ 00:25:27.250 Ryan Luke Daque: Yeah, cause I I haven’t tried this.
375 00:25:27.624 ⇒ 00:25:29.120 Patrick Trainer: It’s like all AI!
376 00:25:29.860 ⇒ 00:25:30.560 Ryan Luke Daque: Problem.
377 00:25:32.520 ⇒ 00:25:33.770 Ryan Luke Daque: generate off
378 00:25:41.340 ⇒ 00:25:42.720 Ryan Luke Daque: same emotion.
379 00:25:48.600 ⇒ 00:25:49.390 Patrick Trainer: Oh, it looks like it!
380 00:25:49.390 ⇒ 00:25:50.820 Ryan Luke Daque: Yeah, it. Looks like it.
381 00:25:50.820 ⇒ 00:25:53.329 Patrick Trainer: Oh, yeah, it’s got test down at the bottom.
382 00:25:53.750 ⇒ 00:25:55.779 Ryan Luke Daque: Yeah. And it also created all the
383 00:25:56.710 ⇒ 00:25:58.880 Ryan Luke Daque: yaml for each field.
384 00:26:01.650 ⇒ 00:26:04.220 Ryan Luke Daque: Except for this, the description and even
385 00:26:05.060 ⇒ 00:26:06.989 Ryan Luke Daque: decided what data type it
386 00:26:07.060 ⇒ 00:26:09.400 Ryan Luke Daque: is, which is interesting.
387 00:26:11.020 ⇒ 00:26:15.729 Ryan Luke Daque: Yeah, we’ll. I’ll have to dig into that because I haven’t been using that.
388 00:26:17.500 ⇒ 00:26:23.150 Ryan Luke Daque: And lastly, it’s the this one, the project health check. You can like, start scan.
389 00:26:23.990 ⇒ 00:26:25.500 Ryan Luke Daque: And once
390 00:26:25.680 ⇒ 00:26:37.110 Ryan Luke Daque: this takes a while, but once it’s done you can see it here in the problems like, if you have any like Dbd project like the yaml is misformatted, or whatever
391 00:26:37.210 ⇒ 00:26:39.220 Ryan Luke Daque: you’ll be able to see it there.
392 00:26:40.755 ⇒ 00:26:41.710 Ryan Luke Daque: Like.
393 00:26:41.860 ⇒ 00:26:50.609 Ryan Luke Daque: It also shows like which models don’t have documentation like this one, for example, column is imported, is undocumented and stuff so
394 00:26:51.266 ⇒ 00:26:55.419 Ryan Luke Daque: this shows you like, which models don’t have documentation in in them.
395 00:26:55.820 ⇒ 00:27:03.660 Ryan Luke Daque: and then other like errors, potential errors that you have like this one model storage, and it does not exist in the database.
396 00:27:04.470 ⇒ 00:27:05.910 Ryan Luke Daque: Yeah.
397 00:27:06.190 ⇒ 00:27:11.090 Ryan Luke Daque: which is pretty cool. But yeah, the 2 major things that I’m using is basically the
398 00:27:11.280 ⇒ 00:27:15.079 Ryan Luke Daque: query preview and lineage, which is very helpful
399 00:27:16.140 ⇒ 00:27:16.910 Ryan Luke Daque: for me.
400 00:27:18.440 ⇒ 00:27:19.270 Ryan Luke Daque: So yeah, if you.
401 00:27:19.270 ⇒ 00:27:20.199 Uttam Kumaran: Oh, yeah, I’m going to use that.
402 00:27:20.200 ⇒ 00:27:22.680 Ryan Luke Daque: Right? Yeah, it’s pretty cool.
403 00:27:26.050 ⇒ 00:27:26.760 Uttam Kumaran: Okay.
404 00:27:26.890 ⇒ 00:27:28.390 Uttam Kumaran: Well, appreciate a demo.
405 00:27:30.090 ⇒ 00:27:31.220 Ryan Luke Daque: Basically thanks.
406 00:27:31.220 ⇒ 00:27:33.319 Agustin: Yeah, I I like it. It’s great.
407 00:27:33.320 ⇒ 00:27:34.839 Uttam Kumaran: Yeah, I’m gonna I just installed it.
408 00:27:35.260 ⇒ 00:27:35.950 Ryan Luke Daque: Yeah.
409 00:27:36.100 ⇒ 00:27:36.990 Ryan Luke Daque: nice
410 00:27:39.230 ⇒ 00:27:41.290 Ryan Luke Daque: okay, thanks, guys.
411 00:27:41.640 ⇒ 00:27:42.709 Ryan Luke Daque: thanks, guys, thanks.
412 00:27:42.710 ⇒ 00:27:43.610 Uttam Kumaran: See us, in.
413 00:27:44.040 ⇒ 00:27:44.860 Agustin: Atlanta.
414 00:27:44.860 ⇒ 00:27:45.340 Ryan Luke Daque: Hmm cool.
415 00:27:45.635 ⇒ 00:27:45.930 Jakob Kagel: Go.
416 00:27:45.930 ⇒ 00:27:46.700 Ryan Luke Daque: Yeah, sure.
417 00:27:46.910 ⇒ 00:27:48.049 Ryan Luke Daque: See you? Aye.
418 00:27:48.190 ⇒ 00:27:49.000 Ryan Luke Daque: bye, bye.