Meeting Title: Eden OS and Gosh Query Sync Date: 2026-04-13 Meeting participants: Ashwini Sharma, Jasmin Multani
WEBVTT
1 00:07:27.130 ⇒ 00:07:29.089 Ashwini Sharma: Hey, Jasmine. Hello.
2 00:07:29.380 ⇒ 00:07:31.329 Jasmin Multani: Hi, sorry for the late ping.
3 00:07:31.330 ⇒ 00:07:32.730 Ashwini Sharma: No problem.
4 00:07:32.860 ⇒ 00:07:33.410 Jasmin Multani: Okay.
5 00:07:33.590 ⇒ 00:07:43.930 Jasmin Multani: I’m just trying to understand the ask Amber had sent to you. So, it looks like you pushed something out that’s gonna unify
6 00:07:44.410 ⇒ 00:07:47.930 Jasmin Multani: both Eden OS and Gosh.
7 00:07:48.500 ⇒ 00:07:50.140 Ashwini Sharma: Yes, that’s right.
8 00:07:50.220 ⇒ 00:07:54.220 Jasmin Multani: Okay, and so, let me pull up the Eden.
9 00:07:55.230 ⇒ 00:07:56.700 Jasmin Multani: Chat real quick.
10 00:08:12.110 ⇒ 00:08:13.680 Jasmin Multani: Let me pull up the…
11 00:08:18.500 ⇒ 00:08:20.130 Jasmin Multani: Dashboard right now.
12 00:08:44.940 ⇒ 00:08:47.670 Jasmin Multani: So, let me also share my screen.
13 00:09:06.870 ⇒ 00:09:12.369 Jasmin Multani: Okay, so this is the dashboard that we want to be impacted by.
14 00:09:12.470 ⇒ 00:09:22.570 Jasmin Multani: So, with the… with what you created, I think, Abhi said that I just have to change the source, is that correct?
15 00:09:23.090 ⇒ 00:09:28.929 Ashwini Sharma: Yes, that’s correct. Yeah, use that. It should be in DevMarts for now.
16 00:09:29.180 ⇒ 00:09:29.510 Jasmin Multani: Huh.
17 00:09:29.510 ⇒ 00:09:34.910 Ashwini Sharma: eventually, it’ll be in Broadmarts once the PR is merged.
18 00:09:36.850 ⇒ 00:09:38.710 Jasmin Multani: Prod… Prodmarts, okay.
19 00:09:38.710 ⇒ 00:09:39.330 Ashwini Sharma: Yeah.
20 00:09:40.070 ⇒ 00:09:42.710 Jasmin Multani: Let’s see…
21 00:09:43.670 ⇒ 00:09:49.430 Jasmin Multani: So would I go… I just am learning, about Omni, so would I go into Workbook, or…
22 00:10:00.480 ⇒ 00:10:05.159 Ashwini Sharma: So, probably your query might not work as it is.
23 00:10:05.750 ⇒ 00:10:09.400 Ashwini Sharma: let’s see what you’re trying to do over here.
24 00:10:15.150 ⇒ 00:10:20.649 Ashwini Sharma: So you’re taking fat transactions and then joining it with DIM products, okay?
25 00:10:29.580 ⇒ 00:10:34.780 Ashwini Sharma: So instead of that fact transactions, right, line number 47.
26 00:10:35.040 ⇒ 00:10:35.660 Jasmin Multani: Yeah.
27 00:10:36.330 ⇒ 00:10:38.530 Ashwini Sharma: Can you replace it with,
28 00:10:38.690 ⇒ 00:10:42.830 Ashwini Sharma: So, change that broad to dev, first of all.
29 00:10:44.730 ⇒ 00:10:50.819 Ashwini Sharma: No, no, no, no, no, just keep it as it is. Only the broad needs to be changed to dev.
30 00:10:51.160 ⇒ 00:10:52.070 Jasmin Multani: Okay, my bad.
31 00:10:54.130 ⇒ 00:11:01.379 Ashwini Sharma: Alright, and then back transactions, that needs to be replaced with the new table name that was shared by Avish.
32 00:11:02.560 ⇒ 00:11:04.090 Jasmin Multani: Okay, so this one.
33 00:11:05.290 ⇒ 00:11:06.240 Ashwini Sharma: Yes.
34 00:11:08.490 ⇒ 00:11:09.220 Jasmin Multani: Okay.
35 00:11:10.940 ⇒ 00:11:11.730 Ashwini Sharma: No.
36 00:11:12.640 ⇒ 00:11:14.159 Ashwini Sharma: Now try to run it.
37 00:11:14.660 ⇒ 00:11:17.160 Jasmin Multani: I’ve been having issues with the sequel prairie.
38 00:11:17.710 ⇒ 00:11:20.699 Jasmin Multani: So let’s see… okay, yeah, it says it’s not running.
39 00:11:21.310 ⇒ 00:11:25.780 Jasmin Multani: Even when I, like, initially, this was just one.
40 00:11:26.720 ⇒ 00:11:33.619 Jasmin Multani: And I changed it to 3 so that, so that the sorting could happen by revenue, but it didn’t go through.
41 00:11:35.950 ⇒ 00:11:41.210 Ashwini Sharma: Can you look at that pink color banner right above your query? What does it say?
42 00:11:42.830 ⇒ 00:11:45.719 Ashwini Sharma: And bad function not found.
43 00:11:45.720 ⇒ 00:11:46.760 Jasmin Multani: Big end.
44 00:11:49.220 ⇒ 00:11:50.970 Jasmin Multani: But if it’s been counted…
45 00:11:59.650 ⇒ 00:12:01.540 Ashwini Sharma: Can you share that entire query to me?
46 00:12:01.790 ⇒ 00:12:02.820 Ashwini Sharma: Take a looko.
47 00:12:03.470 ⇒ 00:12:04.819 Jasmin Multani: Should I just copy-paste this?
48 00:12:05.020 ⇒ 00:12:08.290 Ashwini Sharma: No, no, just share the query, yeah, from there.
49 00:12:11.010 ⇒ 00:12:16.559 Jasmin Multani: Also, if you have to run, that’s totally fine. I can also get… work with this with, Advait.
50 00:12:18.630 ⇒ 00:12:24.030 Jasmin Multani: The good thing I needed to know was just, like, where in the query I needed to change things, and…
51 00:12:24.300 ⇒ 00:12:30.320 Jasmin Multani: Okay. Yeah, you basically provided that. Oh, actually… oh, no, not here, not here!
52 00:12:30.320 ⇒ 00:12:31.060 Ashwini Sharma: Oh, okay.
53 00:12:31.200 ⇒ 00:12:33.240 Jasmin Multani: No, no, no, no, no, no!
54 00:12:33.970 ⇒ 00:12:37.260 Jasmin Multani: That’s embarrassing. Okay.
55 00:12:38.220 ⇒ 00:12:39.730 Jasmin Multani: That was scary.
56 00:12:39.970 ⇒ 00:12:44.990 Jasmin Multani: Okay, let me do code block.
57 00:12:45.720 ⇒ 00:12:46.620 Jasmin Multani: Here.
58 00:12:46.980 ⇒ 00:12:50.700 Jasmin Multani: Yeah, so even before…
59 00:12:55.570 ⇒ 00:12:56.270 Ashwini Sharma: Ming.
60 00:12:56.990 ⇒ 00:12:58.269 Jasmin Multani: Did this copy of Pricker.
61 00:13:13.550 ⇒ 00:13:16.370 Ashwini Sharma: Artificial product ID.
62 00:13:21.760 ⇒ 00:13:29.340 Ashwini Sharma: Okay, this is not yet added. Let’s join on DIM products. Do you need to join on the products for now?
63 00:13:31.720 ⇒ 00:13:36.400 Jasmin Multani: According to what Amber has written.
64 00:13:37.130 ⇒ 00:13:37.750 Ashwini Sharma: Hmm?
65 00:13:38.020 ⇒ 00:13:42.629 Jasmin Multani: Why, what’s the limitation? Like, why do you think it shouldn’t be added?
66 00:13:42.950 ⇒ 00:13:43.890 Jasmin Multani: Or joined.
67 00:13:44.810 ⇒ 00:13:49.250 Ashwini Sharma: Did you change anything in the query? I got the query again, notification again.
68 00:13:49.770 ⇒ 00:13:51.659 Ashwini Sharma: From the previous beast?
69 00:13:51.850 ⇒ 00:13:56.410 Jasmin Multani: The previous pace, I think it was just half, but if you see here…
70 00:13:57.160 ⇒ 00:13:59.500 Jasmin Multani: Yeah, why didn’t it save? Okay, that’s weird.
71 00:13:59.800 ⇒ 00:14:00.710 Jasmin Multani: Sorry.
72 00:14:03.360 ⇒ 00:14:04.590 Ashwini Sharma: No problem.
73 00:14:04.590 ⇒ 00:14:08.940 Jasmin Multani: 47… we changed line 47. Yeah, I don’t know why it didn’t say… okay.
74 00:14:11.780 ⇒ 00:14:13.839 Jasmin Multani: So, this just has to be dev.
75 00:14:17.200 ⇒ 00:14:18.440 Jasmin Multani: Right? 47.
76 00:14:18.440 ⇒ 00:14:22.409 Ashwini Sharma: Yeah, yeah, and then fact transactions has to change, too.
77 00:14:22.600 ⇒ 00:14:23.260 Jasmin Multani: Okay.
78 00:14:23.260 ⇒ 00:14:24.980 Ashwini Sharma: Fact unified or something.
79 00:14:42.990 ⇒ 00:14:47.920 Jasmin Multani: Dev, DBT Marts… And then this changes…
80 00:14:49.750 ⇒ 00:14:52.549 Jasmin Multani: Should I try Ctrl-F to replace all?
81 00:14:53.530 ⇒ 00:14:55.759 Ashwini Sharma: No, that’s fine, I don’t think you have…
82 00:14:56.170 ⇒ 00:14:59.169 Ashwini Sharma: Let me, let me check it on my side.
83 00:15:22.030 ⇒ 00:15:25.799 Ashwini Sharma: Yeah, artificial product ID is not there in this one.
84 00:15:26.180 ⇒ 00:15:31.229 Jasmin Multani: And so the left joint, the joint itself, this entire query has to be rewritten, basically.
85 00:15:31.230 ⇒ 00:15:33.870 Ashwini Sharma: Yeah, the join is not working.
86 00:15:33.870 ⇒ 00:15:34.200 Jasmin Multani: Lucas.
87 00:15:34.200 ⇒ 00:15:35.089 Ashwini Sharma: They can…
88 00:15:35.680 ⇒ 00:15:36.360 Jasmin Multani: Okay.
89 00:15:36.650 ⇒ 00:15:44.649 Jasmin Multani: That’s okay, I’ll let Robert know this piece… this joining piece is gonna have to be a separate ticket.
90 00:15:44.830 ⇒ 00:15:52.429 Jasmin Multani: Okay. But I just wanted to ask, like, when I did this order by 3, it didn’t go through.
91 00:15:53.750 ⇒ 00:15:54.370 Jasmin Multani: And I wonder…
92 00:15:54.850 ⇒ 00:15:55.670 Jasmin Multani: Oh, okay.
93 00:15:55.670 ⇒ 00:15:57.300 Ashwini Sharma: go through men’s water.
94 00:16:11.700 ⇒ 00:16:13.099 Jasmin Multani: Okay, now it’s going through.
95 00:16:13.480 ⇒ 00:16:14.340 Ashwini Sharma: Nowadays, okay.
96 00:16:14.340 ⇒ 00:16:18.759 Jasmin Multani: Okay, whatever. I… I think I wrote Big End.
97 00:16:19.060 ⇒ 00:16:23.369 Jasmin Multani: In one of the… yeah, whatever, it’s fine. It’s been a long day.
98 00:16:23.370 ⇒ 00:16:24.830 Ashwini Sharma: constant tax error, yeah, that’s okay.
99 00:16:25.410 ⇒ 00:16:27.850 Jasmin Multani: All good. Alright, thank you so much, I’ll let you go.
100 00:16:27.850 ⇒ 00:16:29.160 Ashwini Sharma: Yeah, thank you, yeah.
101 00:16:29.160 ⇒ 00:16:30.020 Jasmin Multani: Sorry for that, bye.
102 00:16:30.020 ⇒ 00:16:30.800 Ashwini Sharma: Bye, bye.