Meeting Title: Bi-Weekly—Uttam <> Brian Date: 2023-11-09 Meeting participants: Brian, Uttam Kumaran
WEBVTT
1 00:02:16.840 ⇒ 00:02:18.160 Uttam Kumaran: Yo.
2 00:02:20.170 ⇒ 00:02:21.380 Brian: hey! Hey!
3 00:02:21.770 ⇒ 00:02:22.780 Uttam Kumaran: What’s up?
4 00:02:24.410 ⇒ 00:02:27.820 Brian: Not much. Just played some tennis out back
5 00:02:28.150 ⇒ 00:02:33.400 Brian: sound work. Oh, how are you. good man? What time is it. There.
6 00:02:34.440 ⇒ 00:02:39.510 Brian: We’re 7 h ahead, I think. Now, with daylight savings. 5 pm.
7 00:02:39.680 ⇒ 00:02:41.670 Uttam Kumaran: Oh, cool. Okay, not bad.
8 00:02:42.330 ⇒ 00:02:43.930 Brian: Yeah. What about you?
9 00:02:44.780 ⇒ 00:02:45.820 Uttam Kumaran: I’m good.
10 00:02:46.100 ⇒ 00:02:51.049 Yeah. Just did some work earlier. Yeah, I’ve been trying to get up like
11 00:02:51.660 ⇒ 00:03:04.439 Uttam Kumaran: earlier these days, and like, try to get some work done. I was. I was in California last week. So kinda like messed up my schedule a bit. But yeah, back in Austin right now. So
12 00:03:05.000 ⇒ 00:03:06.490 Brian: cool. What are you doing there.
13 00:03:07.280 ⇒ 00:03:18.220 Uttam Kumaran: It was my birthday last week, so it was just hanging out and then seeing family. yeah, nothing crazy. Nothing work related.
14 00:03:18.770 ⇒ 00:03:21.400 Uttam Kumaran: just taking a little bit of a break. So
15 00:03:22.470 ⇒ 00:03:24.289 Brian: nice happy birthday.
16 00:03:24.860 ⇒ 00:03:28.170 Brian: Thank you. Thanks.
17 00:03:28.690 ⇒ 00:03:33.229 Uttam Kumaran: What are you like? 26. I’m turning 27,
18 00:03:33.480 ⇒ 00:03:36.389 Brian: 20, turning. Okay? Nice
19 00:03:36.690 ⇒ 00:03:38.020 Uttam Kumaran: healing old.
20 00:03:38.960 ⇒ 00:03:44.970 Brian: Yeah, just wait till you’re my age. I’m like, I’m turning 30, fucking 33
21 00:03:45.120 ⇒ 00:03:55.720 Uttam Kumaran: in 2 weeks. But you’re like, you’re full of energy, like I don’t know. I feel like I know a lot of 33 year olds that are dead. What? Like dead walking?
22 00:03:56.230 ⇒ 00:04:00.999 Uttam Kumaran: so I mean, that’s cause I’m not pouring
23 00:04:01.220 ⇒ 00:04:04.719 Brian: my life into. We work. We just went bankrupt. So you know.
24 00:04:04.880 ⇒ 00:04:08.190 Uttam Kumaran: yeah, what’s the what’s the internal scoop?
25 00:04:09.290 ⇒ 00:04:15.550 Brian: They sent out an email saying, You know it’s chapter 11. Nothing really changes.
26 00:04:15.600 ⇒ 00:04:17.750 Brian: Core is all the tools.
27 00:04:18.040 ⇒ 00:04:27.180 Brian: So we’ll see how Churchill it is. And then they were like we, we’re we could have like gotten ourselves out of it. If we could just like.
28 00:04:27.750 ⇒ 00:04:29.460 Brian: you know, not
29 00:04:30.590 ⇒ 00:04:36.470 Brian: just not continue doing what we’re doing, but like we’d have to pay a bunch of interest and had more need more runway.
30 00:04:36.600 ⇒ 00:04:43.620 Brian: So that’s why we we did this thing. So help us renegotiate our visas, which
31 00:04:43.880 ⇒ 00:04:48.340 Uttam Kumaran: it’s no, it’s there’s no truth at all. Bro. Because you could forecast all of that
32 00:04:48.930 ⇒ 00:05:00.869 Uttam Kumaran: like they knew coming up for probably more than a year like I just think like there was with a lot of the rising interest rates.
33 00:05:00.880 ⇒ 00:05:06.120 Uttam Kumaran: There was no way they were going to be able to like, make enough money to turn the business around.
34 00:05:07.380 ⇒ 00:05:18.030 Uttam Kumaran: because, like, what do you do? You either charge your existing customers more so. So they churn. or you get a bunch of more customers in the door, which Weorg was never good at.
35 00:05:19.740 ⇒ 00:05:24.349 Uttam Kumaran: At like high prices, right? Like the whole thing was like, it. Wasn’t that expensive?
36 00:05:26.130 ⇒ 00:05:32.700 Brian: Yeah. yeah. The I mean, the the bottom line is, it’s just there. The the building costs are just too high.
37 00:05:32.900 ⇒ 00:05:33.860 Uttam Kumaran: Yeah.
38 00:05:34.410 ⇒ 00:05:40.539 Brian: So that’s why they did it right. So now they’re trying to use this to help renegotiate some stuff, and also like.
39 00:05:41.010 ⇒ 00:05:47.360 Brian: I think so, we had that Guy Sandeep right for a while, as our CEO. And then he left. I think he was very
40 00:05:47.650 ⇒ 00:05:56.810 Brian: I mean Gen. Jen Perata, who’s like our C CTO. She’ll she’s also the chief product officer now, just because there’s like so few people left but
41 00:05:57.440 ⇒ 00:06:08.390 Brian: She she kind of hinted that, you know Sandy knew this was a thing on the table. But never I love was a pride thing, or or what didn’t didn’t really. Wanna wanna be there when it happened?
42 00:06:08.640 ⇒ 00:06:14.669 Brian: Yeah, exactly, even though, like like you’re saying, if you just looked at the numbers, they knew that it wasn’t gonna work.
43 00:06:15.710 ⇒ 00:06:17.010 Uttam Kumaran: That’s funny.
44 00:06:17.260 ⇒ 00:06:39.030 Uttam Kumaran: Yeah, I mean, I don’t know th there was only one like month where we actually made money. It’s a while ago, but like they they just like, had we just not acquired as many buildings as we did, and had a little bit more diligence, maybe could have worked. But there’s so many leases on the balance sheet that it’s like insane.
45 00:06:40.130 ⇒ 00:06:46.669 Brian: Yeah, we have. We have like empty buildings that we’re paying for still, and there was no way out of them
46 00:06:46.730 ⇒ 00:06:50.919 Brian: when we were sort of on our like expansion phase. So I think with this like Chapter 11,
47 00:06:51.240 ⇒ 00:06:58.200 Brian: I think it helps us, maybe get out of those leases that we signed that there’s just no demand. Or you know that we didn’t build out.
48 00:06:58.740 ⇒ 00:06:59.790 Uttam Kumaran: Yeah.
49 00:07:06.640 ⇒ 00:07:09.609 Brian: Yeah. So we’ll see. We’ll see what happens.
50 00:07:09.960 ⇒ 00:07:20.270 Brian: out of my out of my period. Yeah, yeah. Yeah. But was it above my ma? Above my pay grade to worry about that stuff? Yeah. Above.
51 00:07:20.940 ⇒ 00:07:24.769 Brian: yeah. Oh, speaking of that, my
52 00:07:25.140 ⇒ 00:07:32.060 Brian: I did my change of address. And I put yours down. So thank you again for letting me do that.
53 00:07:32.900 ⇒ 00:07:33.740 Uttam Kumaran: Well.
54 00:07:33.950 ⇒ 00:07:37.160 Uttam Kumaran: perfect
55 00:07:37.640 ⇒ 00:07:53.649 Brian: cool. Yeah, I think I said everything. I think I set everything up to send to Marilyn, but there might be like one or 2 things, or I don’t know. I don’t know. Maybe something falls through the packs. But I think I’ve set up my work day to make sure you don’t get anything. But yeah, really appreciate you helping out
56 00:07:55.240 ⇒ 00:07:56.829 Brian: me a ton of headache.
57 00:07:57.350 ⇒ 00:08:10.529 Uttam Kumaran: Yeah. And I’m I’m I’m thinking about trying to rent a house when my lease is up next year. yeah, that’s like, that’s like my current plan. So I’m kinda like.
58 00:08:11.150 ⇒ 00:08:19.969 Uttam Kumaran: as long as the business is okay, like, I’ll be okay to do it. So finally, like, out of apartment mode a little bit
59 00:08:20.450 ⇒ 00:08:22.089 Brian: nice. Are you? Gonna get
60 00:08:22.480 ⇒ 00:08:26.519 Brian: some roommates or something, or like house is a big thing for one person
61 00:08:26.820 ⇒ 00:08:31.170 Uttam Kumaran: dude, but it’s like pretty much the same price. That’s what I’m saying.
62 00:08:31.180 ⇒ 00:08:33.570 Brian: Oh, really. Oh, okay, yeah.
63 00:08:33.720 ⇒ 00:08:36.039 Uttam Kumaran: And like, I don’t know. I
64 00:08:36.230 ⇒ 00:08:40.049 Uttam Kumaran: I have a lot of friends in town, and like, I’m kind of over
65 00:08:40.419 ⇒ 00:08:46.720 Uttam Kumaran: like being in an apartment like I don’t. I don’t need all the amenities and stuff. And
66 00:08:47.380 ⇒ 00:08:55.140 Uttam Kumaran: yeah, I don’t know. I just kinda like, want more space. And I want enough space for people to come visit and like have their own shit.
67 00:08:56.140 ⇒ 00:09:00.670 Uttam Kumaran: And yeah, dude, it’s like it’s not much more expensive than what I’m paying, anyway. So
68 00:09:01.570 ⇒ 00:09:02.390 Brian: yeah.
69 00:09:03.380 ⇒ 00:09:09.900 Brian: yeah, let me know. Obviously, like, yeah, if you move, let me give me a heads up, and I’ll change my address again on that
70 00:09:09.970 ⇒ 00:09:14.119 Brian: on the workday. But yeah, I’d love to come visit you again. We play some tennis.
71 00:09:16.520 ⇒ 00:09:18.960 Brian: There’s some tennis hanging out.
72 00:09:19.340 ⇒ 00:09:21.550 Uttam Kumaran: Yeah. Otherwise, business stuff is
73 00:09:21.590 ⇒ 00:09:40.020 Uttam Kumaran: good. I have like one client that I think is gonna sign. And then I have the 2 that I’m still working on I think it’s just been like it’s been a lot of up and down in terms of like figuring out my like daily schedule with like managing them.
74 00:09:40.210 ⇒ 00:09:46.210 Uttam Kumaran: because I just need to do a lot more development work which takes, like.
75 00:09:47.240 ⇒ 00:09:57.660 Uttam Kumaran: you know, 3, 4 h of like sitting down and doing that. But it’s like I was having meetings and stuff like that. So I’m now just getting a lot more strict with my time, and being a little bit more methodical.
76 00:09:58.140 ⇒ 00:10:15.200 Uttam Kumaran: But like, it’s not too hard data stuff. It just takes, like, you know, quite a while to get done. So yeah, that’s kind of where I’m at is just like, really like starting to get like, really focused. And then I wanna, I’m trying to start
77 00:10:15.280 ⇒ 00:10:21.540 Uttam Kumaran: doing some more internal stuff to save me time on the development side, like adding more like CI CD tests
78 00:10:22.000 ⇒ 00:10:27.170 Uttam Kumaran: and like seeing where I can bring people on to take on tasks for clients.
79 00:10:28.230 ⇒ 00:10:31.649 Uttam Kumaran: yeah, that’s mainly it.
80 00:10:32.000 ⇒ 00:10:33.590 Uttam Kumaran: It’s kind of saying, Yeah, hold on
81 00:10:34.180 ⇒ 00:10:40.359 Brian: nice. Well, if you get like one more and you need some help with development work. I’m totally help.
82 00:10:41.050 ⇒ 00:10:42.790 Uttam Kumaran: Especially given that.
83 00:10:42.980 ⇒ 00:11:00.270 Brian: Given that, we work is probably not going to be around for too much. Yeah, I mean depending on what you’re gonna do like. I mean, if if you’re if you’re I don’t know if you’re thinking about getting another job or what you’re thinking about. But even if you take a month or 2 like we could totally try to get some more clients.
84 00:11:00.430 ⇒ 00:11:11.650 Uttam Kumaran: I for me, the biggest thing is like. I don’t have a shit ton of time to do sales. but. like I have all of the necessary resources to close clients, and
85 00:11:11.660 ⇒ 00:11:26.549 Uttam Kumaran: I have a really good bank of like potential leads. So even if you wanna like help out and like help, kind of go through that, that would be we could. I mean, I’m pretty confident I can get at least one more, if not a couple more.
86 00:11:26.610 ⇒ 00:11:37.580 Uttam Kumaran: right in line with, like what we’re doing. So I just haven’t. I just really haven’t spent like a ton of time doing it? Cause I’m just want to make sure the current clients are getting what they need.
87 00:11:39.080 ⇒ 00:11:41.249 Brian: Yeah, what happened to that?
88 00:11:41.460 ⇒ 00:11:51.000 Brian: You said you had a friend that’s working with you like young, hungry with the sales stuff he was. He got a new job at work day.
89 00:11:51.140 ⇒ 00:11:53.639 Uttam Kumaran: And it’s like we’re on computing.
90 00:11:55.020 ⇒ 00:11:58.329 Uttam Kumaran: So either, either, what I’m gonna do is
91 00:12:00.560 ⇒ 00:12:03.339 Uttam Kumaran: I don’t know. I’m either gonna try and
92 00:12:04.790 ⇒ 00:12:08.280 like I’m either gonna try and automate some of that work which is like
93 00:12:08.880 ⇒ 00:12:21.660 Uttam Kumaran: somehow using a I to help me draft up emails and like, find those folks and then manage communication, or I’m gonna try and see whether I can get somebody outsourced to help me.
94 00:12:22.060 ⇒ 00:12:27.179 I just need to do honestly like a month long sprint on sales
95 00:12:27.560 ⇒ 00:12:36.669 Uttam Kumaran: like maybe or like in January, because selling all the time really fucks up my development like
96 00:12:37.370 ⇒ 00:12:43.360 Uttam Kumaran: like how much I can do development, because it’s like really exhausting. And it’s a totally different brain.
97 00:12:43.810 ⇒ 00:12:47.150 Uttam Kumaran: And then it really cuts into like me delivering work.
98 00:12:47.300 ⇒ 00:13:00.629 Uttam Kumaran: So I’m trying to just figure out like what the good balance is. I mean, I like again. I don’t. I don’t. I think this thing is so set like I’m not. I’m not like worried about getting clients
99 00:13:00.780 ⇒ 00:13:04.730 Uttam Kumaran: and like closing sales. It’s actually just like doing the outreach
100 00:13:04.940 ⇒ 00:13:15.679 Uttam Kumaran: setting up the intro calls, preparing for those executing on those following up. It’s like that’s quite a bit of work. And then, if you’re doing like, for example, if I have to do 10 of those for one to close.
101 00:13:15.740 ⇒ 00:13:31.850 Uttam Kumaran: Think about how many meetings that is. In a week. And then I also am doing like. you know, 6 h or 8 h of development work on top of like billing and payroll and shit like that. So that’s the
102 00:13:32.190 ⇒ 00:13:34.870 Uttam Kumaran: that’s the challenge is like the amount of stuff.
103 00:13:35.120 ⇒ 00:13:53.750 Uttam Kumaran: So I’m kinda like I wanna get these 2 clients on like a steady state, maybe even get ahead on some work for them and then buy myself some time to do that. Ii want it like Bp. Is helping me with some stuff, and like II told him, I’m like dude you’d be perfect to do some sales shit, but he’s so fucking lazy
104 00:13:55.820 ⇒ 00:14:13.589 Uttam Kumaran: and doesn’t wanna do it. And so he’s like, what do you need? He’s like, he’s like, what do you, who do you need me to email? I’m like, Bro, you have to do the all the work. And he’s like, Oh, I don’t know about that. So like, I’m not gonna be here. And like, Do part, I’m like the take the whole thing. Here’s a list.
105 00:14:14.080 ⇒ 00:14:17.660 Here’s a list of companies that have opened snowflake job racks.
106 00:14:17.930 ⇒ 00:14:22.200 Uttam Kumaran: You need to go email, every single one of them like. that’s the work.
107 00:14:22.960 ⇒ 00:14:29.089 Uttam Kumaran: so yeah, I mean, it’s I. Just, I’ll figure it out. But yeah, I
108 00:14:29.290 ⇒ 00:14:42.280 Uttam Kumaran: I you know I’m I’m charging, starting to charge more and more, so there’s totally opportunity. So I don’t know. Maybe if you end up with little break, and you wanna try your hand. I could totally use the help, and I think we’d secure another client pretty easily.
109 00:14:42.950 ⇒ 00:14:53.159 Brian: Yeah, pretty fun like automating some of that stuff, too, with like email templates or something. Yeah, like, pretty much like what I was thinking was like.
110 00:14:53.380 ⇒ 00:14:58.630 Uttam Kumaran: so I get these job wrecks, or I have like companies. It’d be great to like.
111 00:14:59.410 ⇒ 00:15:13.840 Uttam Kumaran: Put that into some sort of like tool or a slack channel, and then it gives me, not only like a one pager on the company like who works there on data, but it also gives me, like the Intro email, to send.
112 00:15:14.530 ⇒ 00:15:19.429 Uttam Kumaran: and then you can also leverage it to to do. Follow up emails
113 00:15:19.520 ⇒ 00:15:23.179 Uttam Kumaran: that would save me so much time.
114 00:15:23.640 ⇒ 00:15:31.030 Uttam Kumaran: Because that’s why I secure the contracts because I do a lot of research. And I’m like, I’ve become, try tried to become a little bit knowledgeable about the company.
115 00:15:31.510 ⇒ 00:15:34.080 But it takes it takes time.
116 00:15:35.200 ⇒ 00:15:50.079 Brian: Yeah. So you send out like a pretty targeted, not almost like a cover letter, I guess, saying, like what you’ve done. And stuff is that kind of how you cause. I just find a way to get in the door. Either I email like a data person there or I, I’ll I’ll apply for the job
117 00:15:50.110 ⇒ 00:15:51.460 Uttam Kumaran: stuff like that?
118 00:15:53.190 ⇒ 00:15:54.099 Brian: Got it?
119 00:15:55.020 ⇒ 00:15:56.020 Uttam Kumaran: Yeah.
120 00:15:58.110 ⇒ 00:16:00.370 Brian: yeah, yeah, it’s
121 00:16:00.870 ⇒ 00:16:04.489 Brian: yeah. Try some of that. If we were those.
122 00:16:05.030 ⇒ 00:16:06.379 Brian: I hope it’s under.
123 00:16:06.440 ⇒ 00:16:08.840 Uttam Kumaran: Yeah.
124 00:16:09.070 ⇒ 00:16:21.419 Brian: I mean, where’s the automated like AI? What’s what’s the automated like AI solution right now for sales? Is there like nothing? No one doing this? No, but dude. They just do like part of it, like they don’t do the whole thing. I wanna do the whole fucking thing
125 00:16:21.960 ⇒ 00:16:26.790 Uttam Kumaran: like because it’s like it’s tools, sales, reps, use to like automate like certain things
126 00:16:27.190 ⇒ 00:16:32.720 Uttam Kumaran: like II want, like. I just want the I don’t want to hire like a Bdr
127 00:16:33.750 ⇒ 00:16:35.980 Brian: what’s a Pdr.
128 00:16:36.180 ⇒ 00:16:42.890 Uttam Kumaran: It’s like a business development rep. It’s pretty much like the lowest salesperson. All they do is like, look for leads and set up meetings.
129 00:16:43.480 ⇒ 00:16:45.670 Uttam Kumaran: and that’s like a human’s job
130 00:16:46.950 ⇒ 00:16:52.260 Uttam Kumaran: like I want, I don’t want to hire that person like I need to hire that person right now. I don’t want to.
131 00:16:53.260 ⇒ 00:16:57.710 Uttam Kumaran: So
132 00:17:00.690 ⇒ 00:17:01.829 Uttam Kumaran: yeah, that’s
133 00:17:03.170 ⇒ 00:17:05.480 Brian: sales. Same psychotes that you guessed.
134 00:17:06.800 ⇒ 00:17:12.209 Brian: Do you want to see a I mean, I’m I haven’t done a lot of progress on my on my project.
135 00:17:13.030 ⇒ 00:17:17.549 Brian: but I did a little bit. I did a little bit gain up the ui a little bit.
136 00:17:18.500 ⇒ 00:17:21.540 Brian: still some front-end stuff to do. But then
137 00:17:22.050 ⇒ 00:17:26.029 Brian: I want to start on working on the back end soon, because that seems more interesting.
138 00:17:27.930 ⇒ 00:17:28.770 Brian: You want to see.
139 00:17:28.970 ⇒ 00:17:29.770 Uttam Kumaran: Yeah.
140 00:17:34.020 ⇒ 00:17:35.649 Brian: alright, you see.
141 00:17:37.920 ⇒ 00:17:45.269 Brian: So this this part hasn’t really changed. I need to create like a dashboard page where you can like load your recent projects and stuff.
142 00:17:45.540 ⇒ 00:17:49.479 Brian: But then this is kind of like the develop page that we talked about.
143 00:17:49.590 ⇒ 00:17:52.739 Brian: This is where you write your sequel. This would actually just be like a
144 00:17:54.480 ⇒ 00:17:59.669 Brian: whatever right? This is just your sequel. I’ve decided to not add the Pre render here.
145 00:17:59.690 ⇒ 00:18:13.560 Brian: just because that opens another can of worms with like not storing your data and compliance and stuff. And I don’t know if people use it. Probably people will probably just use Vs code, or whatever they or like the snoofick editors, or to write their sequel, and the ideas like you paste it in here.
146 00:18:14.730 ⇒ 00:18:15.440 Brian: Right?
147 00:18:15.590 ⇒ 00:18:26.950 Brian: So then, I kind of clean up the section on the right. I put everything kind of those in multiple steps. But I put everything in one step now. So here’s like where your object is.
148 00:18:27.180 ⇒ 00:18:33.050 Brian: So you wanna make a table or view, I’m gonna have to support materialized views and also dynamic tables here.
149 00:18:33.270 ⇒ 00:18:39.379 Brian: This is what you wanna make call it, and some validation here. Maybe this was already there. but it’s a validation on like the name.
150 00:18:39.920 ⇒ 00:18:42.190 Brian: So my database whatever.
151 00:18:42.500 ⇒ 00:18:43.510 Uttam Kumaran: Yeah.
152 00:18:44.870 ⇒ 00:18:48.379 Brian: Name schema table comment on the specific.
153 00:18:49.430 ⇒ 00:18:57.390 Brian: whatever and then I clean up these. The section kind of these are the specific options for your object. So like with table, you have.
154 00:18:57.410 ⇒ 00:19:04.030 Brian: you can like, retain the permissions, or like clustering, or, like, you know, on a snowflake view. You can like pick it a secure view or unsecure view.
155 00:19:04.040 ⇒ 00:19:07.490 Brian: but all all the other, like snowflake object, specific
156 00:19:07.900 ⇒ 00:19:11.990 Brian: options. You can set here, so you don’t have to
157 00:19:12.030 ⇒ 00:19:14.470 Brian: know all the syntax and whatever to set all that stuff.
158 00:19:14.630 ⇒ 00:19:22.520 Brian: So that’s your table options or your view options. So that’s no click options, and then to schedule. So you can like run it as a round drop. So
159 00:19:22.710 ⇒ 00:19:34.930 Brian: it’s like, this is a prom schedule for the actual job. So if I run it, 1, 2, 3, 4, 5 added this thing, which explains the Chron. So this runs on whatever at 201 am. On day, 3 every month.
160 00:19:35.190 ⇒ 00:19:38.239 Brian: So that’s the scheduling, or you can run it after
161 00:19:38.820 ⇒ 00:19:44.379 Brian: Another another task, which is basically another transformation job. So I
162 00:19:44.700 ⇒ 00:19:45.560 Brian: first
163 00:19:46.040 ⇒ 00:19:47.569 Brian: trigger priority
164 00:19:47.800 ⇒ 00:19:50.269 Brian: or my second.
165 00:19:50.470 ⇒ 00:20:05.489 Brian: So these are just like other tables that you wanted to run after. And you can see that I’ve added this this like green check mark and stuff which is like the validation of whether like it’s good to go or whatever. So you have to, you have to basically have add one trigger for one job actually runs. So if I don’t have anything
166 00:20:05.840 ⇒ 00:20:11.289 Brian: that this turns red. And you know, this turns red up here. So yeah, validation. There.
167 00:20:11.360 ⇒ 00:20:14.660 Brian: let’s just do front task for now
168 00:20:14.730 ⇒ 00:20:23.880 Brian: and then the run option. So like, where do you want to run it? Do you want to run in the snowflake provided warehouse or user warehouse. So if it’s a user warehouse, I need to like do this part which will
169 00:20:24.000 ⇒ 00:20:27.259 Brian: load up all your warehouses that you have access to here.
170 00:20:27.500 ⇒ 00:20:34.470 Brian: and you can select them, which warehouse you want it to run it at the time out of time out 30 min, 35 min.
171 00:20:34.860 ⇒ 00:20:37.400 Brian: This is suspension. So like
172 00:20:37.530 ⇒ 00:20:43.599 Brian: this is like the same thing in airflow, like suspend after like do I pause and task after one failure to be there. So whatever
173 00:20:43.640 ⇒ 00:20:57.079 Brian: and like allow, allow overlapping execution is, if you can wanna allow, like 2 tasks to run at the same time. But basically, these are all the options you’re allowed to tweak on the actual snowflake tasks. But I’ve just put it into a Ui here
174 00:20:58.590 ⇒ 00:21:01.059 Uttam Kumaran: sick dude. This looks great.
175 00:21:01.600 ⇒ 00:21:09.100 Brian: Yeah. And then this I need the. I need to do this stuff. But like save or push, like the current config to the working branch, because this will be like Github, like
176 00:21:09.170 ⇒ 00:21:20.830 Brian: like, get Github like back. Then everything like that working grace. You know. You know how the PVC stuff works, but basically that. So and then I need to redo this explore to figure out what the file structure is.
177 00:21:20.850 ⇒ 00:21:29.220 Brian: I think the file structure will actually look something more like this which I think I showed you last time. But it’ll just basically be
178 00:21:31.100 ⇒ 00:21:35.010 Brian: It’ll like, basically be this kind of
179 00:21:35.150 ⇒ 00:21:47.190 Brian: what this is like a one-to-one mapping of what your database looks like, so you can use it for documentation. So you can say, like, your source. Tables aren’t made here. So like. But you can still use this to document, right? So you can still use this document, those
180 00:21:47.330 ⇒ 00:21:56.530 Brian: but basically, every table. So like Ct. One underscore Qus, or table name. Sandbox being is a
181 00:21:56.580 ⇒ 00:22:02.689 Brian: schema name, and then central Bev user database. But everything has a config file, a Docs file and a query file.
182 00:22:02.700 ⇒ 00:22:07.160 Brian: So the query is just the raw SQL. For the actual query.
183 00:22:07.250 ⇒ 00:22:17.310 Brian: The docs is what’s getting automatically generated. So you can go into Github and like, look at your your docs, because this is Github compliant, doc Markdown, so you can go there. It’s just like the read me.
184 00:22:17.340 ⇒ 00:22:25.470 Brian: and then config is like the actual yaml file for all the config that I’ve built using this ui, basically.
185 00:22:25.770 ⇒ 00:22:28.470 Brian: So I fill this thing out. Hi.
186 00:22:28.830 ⇒ 00:22:36.120 Brian: go to the next page. I have to figure out this navigation of like, I don’t know what this is next, or whatever so once you’re done with this page right.
187 00:22:36.230 ⇒ 00:22:49.340 Brian: this page. When you click this page, this will actually run a snowplate query like, it won’t actually run. It will run the like. It’ll run it where? Where? It will just fetch all your column names, so this will be dynamically flash, or whatever.
188 00:22:49.380 ⇒ 00:23:11.099 Brian: So this will tell you your column name. You have the column type, and then you can. Add tests here. I have to figure out how to clean up this test interface. But you get the idea, you know, warning test or an error test. A warning test is like it will send you a warning that the job will keep running an error test is like it’ll actually error the the job. So that’s the whole promotion process of like.
189 00:23:11.110 ⇒ 00:23:28.369 Brian: If if it fails an error test. I’m not gonna push this data to production. I’m gonna like, I’m gonna keep that table around or for you to like. Look at. But I won’t push it to. But you remember that both promoter production thing. So that’s what these are. But you can add your tests here, based on the columns, or whatever
190 00:23:28.450 ⇒ 00:23:30.450 Brian: you see, like as oops.
191 00:23:31.220 ⇒ 00:23:39.200 Brian: But you see that after I’ve added to the test this became this red
192 00:23:39.860 ⇒ 00:23:43.069 Brian: thing became red because I need to tell someone to
193 00:23:43.400 ⇒ 00:23:51.190 Brian: II need. I need a if it. If I have a test, I need someone to order for that test. So
194 00:23:52.800 ⇒ 00:23:56.499 Brian: okay, so I added, some added some emails for alert.
195 00:23:56.850 ⇒ 00:24:01.990 Brian: And again, this is all like in Snowflake. I don’t need to do anything. This is using snowflake. Send email
196 00:24:02.190 ⇒ 00:24:03.290 Brian: functionality.
197 00:24:04.380 ⇒ 00:24:05.520 Brian: Okay? So
198 00:24:06.210 ⇒ 00:24:10.590 Brian: yeah. And then, oh, yeah, this is so, this is the id column, whatever
199 00:24:10.770 ⇒ 00:24:13.889 Brian: this is. And then once you fill figure figure
200 00:24:14.570 ⇒ 00:24:36.069 Brian: remember, it’s all it’s all like config based. So like, I’m filling up the documentation for this column. So then, once you’re done with the column section and you’ve written it written everything. The Doc section. A lot of it is automatically generated. This is like, I guess, probably the coolest thing I built the coolest thing so far. So like these are the the basically, the properties that we set on the first step.
201 00:24:36.280 ⇒ 00:24:38.750 Brian: These are all your your pollen properties.
202 00:24:39.030 ⇒ 00:24:46.040 Brian: I could. Even I built. I built up the lineage as well, because I can use the explain on Snowflake, and and to kind of on the table scans.
203 00:24:46.070 ⇒ 00:24:58.660 Brian: and it can pull out all these like column names, and like, I know it’ll actually tell you which columns are being used from like this like table. So I can just say, like these 2 columns, so you have your lineage here for that table.
204 00:24:59.300 ⇒ 00:25:10.060 Brian: These are your run properties that we we set earlier. So like when it’s actually getting run. What it’s being run on. And then here’s your the actual SQL. So again, all this gets pushed to Github
205 00:25:11.060 ⇒ 00:25:14.819 Brian: and the the section I was working on. Oh, and then you can write your
206 00:25:16.820 ⇒ 00:25:23.090 Brian: this. You can write your custom documentation whatever, and it’ll just get injected here. On the final final version.
207 00:25:24.280 ⇒ 00:25:25.090 Brian: And
208 00:25:25.530 ⇒ 00:25:36.509 Brian: so now I’ve set everything up right. So, like the sequels done. The columns are documented. I’ve documented the table and now it’s just kind of the validate page that I was just working on. But basically I’m gonna
209 00:25:36.640 ⇒ 00:25:46.179 Brian: try to create and execute the job. So then this will be like, okay, I have to check with 5%. Right? So big permissions. Okay, it’s success.
210 00:25:46.270 ⇒ 00:25:59.470 Brian: If this fails, then you have to go into like an admin to grant some more permissions or whatever. Then this is creating the transformation job which is like creating the the actual snowflake task and and all the all the snowflake assets you need to make.
211 00:25:59.590 ⇒ 00:26:10.000 Brian: And I mean, these are just dummy calls right now, but you get the idea. It you know, make the snowflake stuff. And then this can actually run the run. The actual pipeline to make sure everything is okay.
212 00:26:10.920 ⇒ 00:26:18.700 Brian: And if everything’s running, then it’s all good, and your job is scheduled and off off to the races on Snowflake.
213 00:26:23.070 ⇒ 00:26:26.229 Uttam Kumaran: Can you? Can you go back to the like, config
214 00:26:28.040 ⇒ 00:26:28.960 Brian: this one?
215 00:26:29.100 ⇒ 00:26:29.940 Uttam Kumaran: Yeah.
216 00:26:30.410 ⇒ 00:26:31.710 Uttam Kumaran: interesting.
217 00:26:34.360 ⇒ 00:26:35.580 Uttam Kumaran: Let’s dope.
218 00:26:38.380 ⇒ 00:26:39.150 Brian: Thanks.
219 00:26:40.920 ⇒ 00:26:53.489 Brian: So like. yeah, I think like it would be useful for like even for like your use case right like what what happens if, like your you close your Dbt account, or your dbt count goes down, or something or Dbt. Goes down, or Dbt. Starts charging for
220 00:26:54.120 ⇒ 00:27:01.939 Brian: their their cloud version, or something right, because the executions kicked off from Dbt. Then your clients are could be a little bit in trouble. Right?
221 00:27:01.990 ⇒ 00:27:11.880 Brian: Yeah, it’s like, it’s probably not gonna happen. But like, this is all because this is all snowflake native with it. I mean, if Snowflake goes down that your your jobs aren’t going to run, anyway, there’s like one fewer dependency.
222 00:27:12.040 ⇒ 00:27:24.029 Uttam Kumaran: Yeah. I mean, it would almost be cool to like. yeah, I mean, dude is Dvt is now charging like quite a bit like they charge on model runs now.
223 00:27:25.520 ⇒ 00:27:28.690 Brian: Oh, really, yeah. So it’s like, really bad.
224 00:27:29.830 ⇒ 00:27:31.449 Brian: Yeah, then.
225 00:27:31.980 ⇒ 00:27:32.800 Brian: yes.
226 00:27:32.910 ⇒ 00:27:34.649 Brian: yeah, it’s like a
227 00:27:35.690 ⇒ 00:27:41.800 Brian: yeah, cause you’re paying for their compute as well. Now. So like with this, you don’t need to pay for their computer. You just pay for the role.
228 00:27:41.850 ⇒ 00:27:45.240 Brian: They’re all stuff that the bare minimum that you need on snowflake.
229 00:27:45.380 ⇒ 00:27:47.180 Uttam Kumaran: Yeah, exactly
230 00:27:51.210 ⇒ 00:27:52.790 Uttam Kumaran: nice. What’s next?
231 00:27:54.070 ⇒ 00:27:56.429 Brian: I need to finish. I need to finish this
232 00:27:56.660 ⇒ 00:28:11.740 Brian: this confirmation page. I need to redo this file explorer, maybe move something around some things around. But I think I want to start. Now, I actually want to start. I’m going to start working on the back end for this like develop page. Because now, like.
233 00:28:11.810 ⇒ 00:28:15.100 Brian: imagine this page actually just creates like,
234 00:28:15.700 ⇒ 00:28:24.739 Brian: this config. So now I can start working on like the rest rest Api, or whatever to take this config and then return the actual SQL. Code
235 00:28:24.770 ⇒ 00:28:28.779 Brian: and write it to a file. Connect it to github.
236 00:28:28.900 ⇒ 00:28:42.279 Brian: all the all the all the back end for that work. That’s that’s probably what’s next. Basically taking this config and building this query, it’s like, which is like all the testing and stuff.
237 00:28:42.960 ⇒ 00:28:44.350 Uttam Kumaran: Oh, where it’s
238 00:28:47.330 ⇒ 00:28:49.160 Brian: yeah, so a lot of work
239 00:28:50.200 ⇒ 00:28:51.970 Brian: get little scan there.
240 00:28:54.750 ⇒ 00:28:57.699 Uttam Kumaran: It looks like Jay. It looks like a real product. Actually.
241 00:28:59.010 ⇒ 00:28:59.920 Brian: thanks.
242 00:29:00.910 ⇒ 00:29:04.190 Brian: I drew a lot of inspiration from Bpt
243 00:29:04.200 ⇒ 00:29:07.870 Brian: 6, 9. We’re free to tab. You act.
244 00:29:09.060 ⇒ 00:29:14.129 Brian: Yeah. And like even the text editor, like, I need, I want to replace it because, you know, like.
245 00:29:14.910 ⇒ 00:29:18.539 Brian: like, I use Vs code for all this. And Vs code is free.
246 00:29:18.640 ⇒ 00:29:23.649 Brian: It’s open source, the actual product. So I could just inject the Vs code into my product as well.
247 00:29:24.100 ⇒ 00:29:25.339 Uttam Kumaran: Oh, Seth.
248 00:29:26.200 ⇒ 00:29:27.390 Brian: yeah, Noah.
249 00:29:27.860 ⇒ 00:29:31.389 Brian: it’s called like Cortana or something or no, it’s but
250 00:29:32.150 ⇒ 00:29:33.110 Brian: source.
251 00:29:39.930 ⇒ 00:29:49.000 Brian: Yeah. Microsoft slash Vs code. It’s a public info, so you can just run it in the browser, so I might might run it in the browser. So I can have like
252 00:29:49.260 ⇒ 00:29:56.300 Uttam Kumaran: everything that Vs code can do on snowflakes like everything. Yeah, I mean, I use the snowflake Vs code thing. I’ve been using it a lot.
253 00:29:56.970 ⇒ 00:29:58.090 Brian: Yeah, same.
254 00:29:58.370 ⇒ 00:30:01.109 Brian: So I can use them now. So you can install extensions, too.
255 00:30:01.250 ⇒ 00:30:02.230 Uttam Kumaran: Yeah.
256 00:30:08.200 ⇒ 00:30:11.350 Brian: yeah, that’s where that is. Thanks.
257 00:30:12.290 ⇒ 00:30:14.219 Uttam Kumaran: alright. Let me know.
258 00:30:14.270 ⇒ 00:30:18.599 Uttam Kumaran: let me know how the stuff that we work goes. And then, yeah, maybe sometime.
259 00:30:18.770 ⇒ 00:30:26.279 Uttam Kumaran: I don’t know when I’m gonna kind of kick off more sales stuff, but you would love to like collab on that.
260 00:30:26.870 ⇒ 00:30:30.750 Uttam Kumaran: especially if you have a low free, I think it will be lucrative. So
261 00:30:31.850 ⇒ 00:30:44.830 Brian: yeah, let me know, even if it’s just well, you know how I am with like sales meetings. I was never on like the finance or the model. I don’t even really need like, yeah, I mean, I don’t know. We just gotta. I just need like, I
262 00:30:44.970 ⇒ 00:30:54.049 Uttam Kumaran: yeah, it’s just right there to get the money, and I’m happy to sit in every meeting. I don’t know. We just go figure out like how to do that. I don’t know.
263 00:30:54.540 ⇒ 00:31:05.599 Brian: Yeah. If you walk me through like one of your like sales sales calls or like your sales, like process. So I can see what I can like automate using. I don’t know. Chat, Gbt or something.
264 00:31:05.650 ⇒ 00:31:11.200 Brian: See which parts can even to just build some simple automation on that. Some python scripts or something.
265 00:31:11.320 ⇒ 00:31:13.769 Uttam Kumaran: Yeah, yeah, maybe we could try that.
266 00:31:16.860 ⇒ 00:31:18.479 Brian: Yeah. Sounds good.
267 00:31:18.940 ⇒ 00:31:23.130 Uttam Kumaran: Alright dude. I’ll talk to you soon. Let me know about learning us.
268 00:31:23.860 ⇒ 00:31:25.950 Brian: Yeah. Sounds good. Good chatting
269 00:31:26.130 ⇒ 00:31:29.210 Uttam Kumaran: soon. Alright talk to you later. Bye.