Meeting Title: Brainforce BI Data Loading Guidance Date: 2026-03-26 Meeting participants: Mustafa Raja, Uttam Kumaran
WEBVTT
1 00:00:24.590 ⇒ 00:00:25.200 Mustafa Raja: Hey.
2 00:00:25.200 ⇒ 00:00:29.469 Uttam Kumaran: Hey, so I have the data, I just need some guidance on how to load it.
3 00:00:30.310 ⇒ 00:00:37.640 Mustafa Raja: Oh, yeah, I just asked, sir, to load it. I have, given it the, MotherRock CLI, right?
4 00:00:39.100 ⇒ 00:00:44.909 Mustafa Raja: So, it tries… Script, and then runs it, and then, you know, it takes care of that.
5 00:00:45.100 ⇒ 00:00:50.960 Mustafa Raja: What other thing we can do is, we can create tables using files inside the Motherlock UI.
6 00:00:53.770 ⇒ 00:00:55.309 Mustafa Raja: So, tables from CSS.
7 00:00:55.310 ⇒ 00:00:59.010 Uttam Kumaran: What do you think is best? Should I just try to hook it up right now?
8 00:00:59.820 ⇒ 00:01:01.790 Uttam Kumaran: to MCP, or using Motherdeck CLI?
9 00:01:02.070 ⇒ 00:01:07.089 Mustafa Raja: Motherx CLI, MCP doesn’t have that functionality, so, it has to be CLI.
10 00:01:07.940 ⇒ 00:01:10.270 Uttam Kumaran: Okay, one second then, let’s see if we can do it.
11 00:01:11.970 ⇒ 00:01:13.379 Mustafa Raja: Yeah, how’s your day going?
12 00:01:14.630 ⇒ 00:01:16.380 Uttam Kumaran: Crazy, dude.
13 00:01:16.890 ⇒ 00:01:17.860 Uttam Kumaran: Crazy.
14 00:01:18.600 ⇒ 00:01:21.640 Uttam Kumaran: I’ll probably… I’ll call you later to add some stuff to share, but…
15 00:01:21.640 ⇒ 00:01:22.129 Mustafa Raja: Oh, that’s good.
16 00:01:23.020 ⇒ 00:01:24.250 Uttam Kumaran: Yeah.
17 00:01:24.250 ⇒ 00:01:27.930 Mustafa Raja: Element renewed for a big amount. That’s pretty good.
18 00:01:28.830 ⇒ 00:01:31.590 Uttam Kumaran: Yeah, it’s almost… it’s not signed yet, it’s almost…
19 00:01:31.590 ⇒ 00:01:32.130 Mustafa Raja: Oh, snap.
20 00:01:32.130 ⇒ 00:01:33.280 Uttam Kumaran: But… Yeah, it’s…
21 00:01:33.280 ⇒ 00:01:34.229 Mustafa Raja: Yeah, it has to go to…
22 00:01:35.300 ⇒ 00:01:36.150 Uttam Kumaran: Yeah…
23 00:01:37.410 ⇒ 00:01:40.349 Mustafa Raja: Do we have any other new AI clients coming in?
24 00:01:41.540 ⇒ 00:01:45.830 Uttam Kumaran: Yes, that’s what I’ll call you and tell you. Let me, let me finish this.
25 00:01:45.830 ⇒ 00:01:49.009 Mustafa Raja: Okay, let’s my focus. Yeah, let’s get this done, yeah.
26 00:01:49.010 ⇒ 00:01:53.700 Uttam Kumaran: So… I’m gonna…
27 00:01:54.550 ⇒ 00:01:59.829 Mustafa Raja: I just want to flag that I’ll be out from, next week, Wednesday, right?
28 00:02:00.180 ⇒ 00:02:03.180 Uttam Kumaran: Okay, okay, one… but wait, one second, let me… let’s just finish this up, hold on.
29 00:02:03.180 ⇒ 00:02:04.640 Mustafa Raja: Sorry.
30 00:02:05.140 ⇒ 00:02:11.890 Uttam Kumaran: What is… do I even have the repo? Like, what repo is this?
31 00:02:12.360 ⇒ 00:02:20.410 Mustafa Raja: It doesn’t have to be in a repo, to be honest. Just get it in the folder that you downloaded the data in, you know?
32 00:02:22.460 ⇒ 00:02:25.199 Uttam Kumaran: But I don’t even know what… how to connect a mother duck.
33 00:02:25.820 ⇒ 00:02:29.450 Mustafa Raja: Do you have the… oh, you’ll need, hmm, tokens.
34 00:02:29.450 ⇒ 00:02:34.380 Uttam Kumaran: Well, like, I’ll figure that all out, but, like, hold on one second. Let me just try to find the repo.
35 00:02:36.100 ⇒ 00:02:39.680 Mustafa Raja: It’s Brainforce BI. The default one is Brainforce BI.
36 00:02:40.930 ⇒ 00:02:41.870 Uttam Kumaran: This one.
37 00:02:41.870 ⇒ 00:02:42.570 Mustafa Raja: Yeah.
38 00:02:43.810 ⇒ 00:02:45.179 Uttam Kumaran: But this one doesn’t have anything in it.
39 00:02:46.450 ⇒ 00:02:48.190 Mustafa Raja: Regarding mother, yes.
40 00:02:49.150 ⇒ 00:02:54.730 Mustafa Raja: Oh, you might need to… what’s it called? You might need to, you know, pull stuff from me.
41 00:03:03.540 ⇒ 00:03:07.569 Mustafa Raja: Oh, 4.4 mini… does this work good?
42 00:03:08.520 ⇒ 00:03:09.210 Uttam Kumaran: Yes.
43 00:03:11.010 ⇒ 00:03:11.930 Uttam Kumaran: It’s really good.
44 00:03:31.300 ⇒ 00:03:32.010 Uttam Kumaran: Okay.
45 00:03:33.030 ⇒ 00:03:35.210 Uttam Kumaran: Cool.
46 00:03:35.600 ⇒ 00:03:37.930 Uttam Kumaran: So, I’m gonna say…
47 00:03:45.880 ⇒ 00:03:47.810 Uttam Kumaran: And I just provide it with, like.
48 00:03:49.050 ⇒ 00:03:52.390 Uttam Kumaran: What do I even provide it for? Provide… provide it?
49 00:03:56.930 ⇒ 00:04:00.930 Mustafa Raja: I just installed CLI, MotherX CLI myself for this, you know.
50 00:04:01.090 ⇒ 00:04:02.759 Mustafa Raja: I manually did that.
51 00:04:04.870 ⇒ 00:04:08.699 Mustafa Raja: And then if you need the token, I can give you that.
52 00:04:21.860 ⇒ 00:04:23.850 Mustafa Raja: Hmm, that’s okay.
53 00:04:43.620 ⇒ 00:04:44.839 Uttam Kumaran: Okay, so what do I do now?
54 00:04:46.950 ⇒ 00:04:51.060 Mustafa Raja: Wait, let me come back to one thing… Okay, so we have…
55 00:04:52.780 ⇒ 00:04:54.739 Mustafa Raja: Yeah, I think she installed that.
56 00:05:34.500 ⇒ 00:05:36.340 Mustafa Raja: Okay, has it installed it?
57 00:05:37.240 ⇒ 00:05:37.990 Uttam Kumaran: Yeah.
58 00:05:39.520 ⇒ 00:05:42.439 Uttam Kumaran: So, I have this, so I should… what should I say?
59 00:05:44.410 ⇒ 00:05:48.379 Mustafa Raja: Okay, so you should say that,
60 00:05:49.050 ⇒ 00:06:01.700 Mustafa Raja: it should dump all of this data in Mother Duck MyDB database, and it can see that we have some other dumps, in the database already.
61 00:06:07.870 ⇒ 00:06:09.629 Mustafa Raja: Yeah, that’s a good idea.
62 00:06:15.340 ⇒ 00:06:30.700 Mustafa Raja: Yeah, so it should create a schema, dump it there, and then, what it should do is, merge this new dumped data, in the data that is in raw export. Database.
63 00:06:32.180 ⇒ 00:06:34.719 Uttam Kumaran: But where is the dump in raw data?
64 00:06:35.130 ⇒ 00:06:42.810 Mustafa Raja: No, the… than MyDB, and then, the one we are using in, dbt is raw export.
65 00:06:43.810 ⇒ 00:06:44.650 Uttam Kumaran: I see.
66 00:06:45.300 ⇒ 00:06:46.190 Uttam Kumaran: Okay, okay.
67 00:06:48.950 ⇒ 00:06:58.589 Mustafa Raja: They had two exports in our drive. One was small, so I was able to merge that myself. This one was a lot bigger.
68 00:07:01.630 ⇒ 00:07:04.320 Mustafa Raja: The one I did was, around 2GB.
69 00:07:05.060 ⇒ 00:07:05.740 Uttam Kumaran: Okay.
70 00:07:13.900 ⇒ 00:07:16.510 Mustafa Raja: How long did it take you to download this?
71 00:07:17.790 ⇒ 00:07:19.270 Uttam Kumaran: In, like, 2 seconds.
72 00:07:19.430 ⇒ 00:07:20.590 Mustafa Raja: No way.
73 00:07:21.600 ⇒ 00:07:22.390 Uttam Kumaran: Yes.
74 00:07:25.400 ⇒ 00:07:27.809 Mustafa Raja: It was 24 hours for me.
75 00:07:29.150 ⇒ 00:07:31.079 Uttam Kumaran: I know, dude, just tell me next time.
76 00:07:31.350 ⇒ 00:07:32.509 Mustafa Raja: Yeah, I’ll do that.
77 00:08:32.289 ⇒ 00:08:34.749 Mustafa Raja: Why is it asking again?
78 00:08:35.250 ⇒ 00:08:36.039 Uttam Kumaran: I don’t know.
79 00:08:37.830 ⇒ 00:08:39.140 Uttam Kumaran: Failure that out later.
80 00:08:44.670 ⇒ 00:08:45.959 Uttam Kumaran: Oh, it’s gonna do the whole thing.
81 00:08:45.960 ⇒ 00:08:54.489 Mustafa Raja: I think what’s happening is we don’t have the, we don’t have the token in right, so for every request, it’s going to ask this.
82 00:08:55.570 ⇒ 00:08:56.330 Uttam Kumaran: Yeah.
83 00:08:56.910 ⇒ 00:08:57.840 Uttam Kumaran: It’s okay.
84 00:08:58.780 ⇒ 00:09:05.950 Mustafa Raja: I have the token in, OnePass, if you want to use that instead, then we’ll… we won’t have to…
85 00:09:06.220 ⇒ 00:09:11.609 Mustafa Raja: do the auth at all. It’s mother duck token in default world.
86 00:09:12.480 ⇒ 00:09:15.190 Uttam Kumaran: So, where did… so… Okay.
87 00:09:15.960 ⇒ 00:09:22.130 Mustafa Raja: This goes in the, Zsh profile.
88 00:09:25.130 ⇒ 00:09:28.680 Mustafa Raja: No, no, no, I don’t think the DNV works, but yeah, we can try that.
89 00:09:29.290 ⇒ 00:09:31.160 Mustafa Raja: It has to be in the profile, I believe.
90 00:10:09.470 ⇒ 00:10:11.650 Uttam Kumaran: Okay, I think it’s actually just going for it.
91 00:10:12.070 ⇒ 00:10:12.900 Mustafa Raja: Yeah.
92 00:10:15.020 ⇒ 00:10:15.579 Mustafa Raja: And then…
93 00:10:15.580 ⇒ 00:10:16.900 Uttam Kumaran: New dump. Okay, it’s there.
94 00:10:17.260 ⇒ 00:10:25.500 Mustafa Raja: Okay, good. Now, now we need to ask it to merge this data with, raw export tables.
95 00:10:33.840 ⇒ 00:10:38.109 Mustafa Raja: So the dump it created in MyDB, it needs to merge that in.
96 00:10:38.660 ⇒ 00:10:40.170 Mustafa Raja: raw export.
97 00:10:50.100 ⇒ 00:10:50.910 Mustafa Raja: Yes.
98 00:10:53.080 ⇒ 00:10:55.310 Uttam Kumaran: So one thing you should try is this, I forked the chat.
99 00:10:55.880 ⇒ 00:10:57.820 Mustafa Raja: Oh, I do, I do that all.
100 00:10:59.240 ⇒ 00:11:00.040 Uttam Kumaran: Nice.
101 00:11:04.400 ⇒ 00:11:07.630 Mustafa Raja: if I need to iterate on something that,
102 00:11:07.860 ⇒ 00:11:10.450 Mustafa Raja: That I left in the chat earlier.
103 00:11:10.590 ⇒ 00:11:14.939 Mustafa Raja: I just fork it, so it has fresher context on that.
104 00:11:17.910 ⇒ 00:11:23.030 Mustafa Raja: I think, the default sync is up.
105 00:11:24.600 ⇒ 00:11:29.080 Uttam Kumaran: Okay, alright. Do you want to see if you can merge this in?
106 00:11:30.670 ⇒ 00:11:36.109 Mustafa Raja: Yeah, just let me know if, if this is going to do that, or if I should do this.
107 00:11:37.450 ⇒ 00:11:44.489 Uttam Kumaran: Oh, well, I just… can you confirm, once this is done, that, it’s loaded in Omni.
108 00:11:44.740 ⇒ 00:11:46.399 Mustafa Raja: Yeah, yeah, that I can do.
109 00:12:57.720 ⇒ 00:12:58.800 Mustafa Raja: Is it good?
110 00:13:05.600 ⇒ 00:13:06.240 Uttam Kumaran: Yes.
111 00:13:07.100 ⇒ 00:13:08.110 Mustafa Raja: Oh, cool.
112 00:13:10.890 ⇒ 00:13:12.870 Mustafa Raja: Let me see if it merged.
113 00:13:22.760 ⇒ 00:13:27.049 Mustafa Raja: Okay, I need to go in the default meeting.
114 00:13:27.050 ⇒ 00:13:27.780 Uttam Kumaran: Okay, okay.
115 00:13:27.930 ⇒ 00:13:28.470 Mustafa Raja: Yeah. Okay.
116 00:13:28.470 ⇒ 00:13:29.660 Uttam Kumaran: Okay, alright, okay, bye.