Meeting Title: Brainforge x LMNT: Snowflake Initial Setup Date: 2025-12-17 Meeting participants: Uttam Kumaran, Jason Wu
WEBVTT
1 00:01:20.270 ⇒ 00:01:21.490 Uttam Kumaran: Hey!
2 00:01:21.490 ⇒ 00:01:22.560 Jason Wu: Sorry, man, I…
3 00:01:22.560 ⇒ 00:01:25.979 Uttam Kumaran: No problem. I got… I was also late, by the way, so I was…
4 00:01:25.980 ⇒ 00:01:29.690 Jason Wu: No, that’s good. You take your own time and make you feel better.
5 00:01:29.690 ⇒ 00:01:31.389 Uttam Kumaran: No, no, no, no.
6 00:01:31.390 ⇒ 00:01:39.460 Jason Wu: I literally was, like, racing with Steve, we got, like, this last-minute, like, thing, and we’re like, oh man, how we did this work? And then…
7 00:01:39.640 ⇒ 00:01:54.069 Jason Wu: you know, TLDR is… got the business to say, yes, I think we can commit to it, after a lot of running around, and then I just got a call from, like, the business owner, and she’s like, actually, I spoke to James, our CEO, he’s like, he doesn’t think we need it anymore. I’m like.
8 00:01:54.440 ⇒ 00:02:02.689 Jason Wu: Man! We could have talked about this first, but, it’s all good, it’s just all part of the… part of the process.
9 00:02:02.850 ⇒ 00:02:08.629 Uttam Kumaran: Okay, cool. How’s, so next week… next week, you guys are off, or the next two weeks, basically?
10 00:02:08.630 ⇒ 00:02:09.909 Jason Wu: Yeah, rough the next two weeks, I mean.
11 00:02:09.910 ⇒ 00:02:10.320 Uttam Kumaran: Nice.
12 00:02:10.320 ⇒ 00:02:14.819 Jason Wu: I don’t know, I wouldn’t call it a mini shutdown, you know, it’s like, you know, we do these rest and assess periods.
13 00:02:14.820 ⇒ 00:02:15.330 Uttam Kumaran: Yeah.
14 00:02:15.330 ⇒ 00:02:29.129 Jason Wu: You know, where you can, but it’s, it’s funny, there are two teams that really kind of don’t sleep, and that’s, like, supply chain and tech. Tech. We’re always kind of there, you know, sites gotta be up, and, like, products gotta be sent out, so…
15 00:02:29.130 ⇒ 00:02:36.399 Uttam Kumaran: Yeah, for us, I… I also told our team, like, probably after Wednesday, like, a lot of US folks are gonna be out.
16 00:02:36.550 ⇒ 00:02:36.910 Jason Wu: Yep.
17 00:02:36.910 ⇒ 00:02:40.610 Uttam Kumaran: But, like, there’s a lot of people, like, a lot… our company’s filled with, like, engineers who…
18 00:02:40.790 ⇒ 00:02:43.900 Uttam Kumaran: Want to, like, just, like, want to be on the computer working on stuff.
19 00:02:43.900 ⇒ 00:02:45.050 Jason Wu: It’s funny.
20 00:02:45.050 ⇒ 00:02:48.630 Uttam Kumaran: I almost, I’m like, a lot of people are like, hey, do you mind if I work?
21 00:02:48.940 ⇒ 00:02:53.050 Uttam Kumaran: And who am I? I’m gonna be, I’m gonna be doing stuff, who am I?
22 00:02:53.420 ⇒ 00:02:59.249 Uttam Kumaran: don’t. I’m like, yeah, there’s gonna be client asks, you can work on that, or if we have internal stuff, you wanna work on that, go ahead.
23 00:02:59.250 ⇒ 00:03:01.379 Jason Wu: Yeah, it’s funny is, is,
24 00:03:01.750 ⇒ 00:03:16.430 Jason Wu: you know, we’ve got a pretty packed next quarter when it comes to dev, and Steve was like, well, you know, it’s like, maybe I can get ahead of some stuff, you know, during the break. I’m like, hey man, it’s like, I gotta say this as a manager, but you don’t need to do that, right? This is the reason I always…
25 00:03:16.430 ⇒ 00:03:17.980 Uttam Kumaran: also what I said, but…
26 00:03:17.980 ⇒ 00:03:24.069 Jason Wu: But it’s just like that, it’s like, when you’re in tech, it’s like, you can’t help, you just… you feel like you’re just sitting around.
27 00:03:24.070 ⇒ 00:03:25.400 Uttam Kumaran: This is what I love to do, I don’t know.
28 00:03:25.400 ⇒ 00:03:25.780 Jason Wu: Yeah, this is…
29 00:03:25.780 ⇒ 00:03:30.469 Uttam Kumaran: my hobby, this was my hobby, and now is my full-time job, right?
30 00:03:30.470 ⇒ 00:03:36.430 Jason Wu: So I almost kind of, like, have to be like a… I’m gonna officially say this as the party line, but…
31 00:03:37.180 ⇒ 00:03:54.270 Jason Wu: I also know just, like, how we just work, you know? Yeah. We just work a certain way. You know, you know, I had a call with my, my boss’s boss, yesterday, and he’s like, dude, you don’t have to keep answering your, like, messages, like, right away, it’s like, you know, 10.30 at night. And I’m like.
32 00:03:54.310 ⇒ 00:03:59.350 Jason Wu: That’s kind of what I’m working, though, you know? It’s just like, you know, it’s like, the day times for meetings.
33 00:03:59.660 ⇒ 00:04:00.160 Uttam Kumaran: Yeah.
34 00:04:00.160 ⇒ 00:04:02.590 Jason Wu: Great times when you actually get shit done, so…
35 00:04:03.040 ⇒ 00:04:07.289 Uttam Kumaran: Yeah, it’s very funny, like, we have people, like, sort of all over the world.
36 00:04:07.480 ⇒ 00:04:23.599 Uttam Kumaran: kind of, like, a lot of people are like, oh, like, you hire… are you, like, outsourcing? I’m like, I kind of just hired bar people wherever they are, and a lot of smart people, they just, like, want to go work wherever they feel like, and, like, we’ve hired people off, like, Discord and Slack and, like, friends of friends.
37 00:04:23.600 ⇒ 00:04:23.940 Jason Wu: Yeah.
38 00:04:23.940 ⇒ 00:04:26.220 Uttam Kumaran: But most of our company’s engineers, so…
39 00:04:26.390 ⇒ 00:04:29.989 Uttam Kumaran: it’s like, everybody’s just on… everybody uses Slack, and…
40 00:04:29.990 ⇒ 00:04:30.320 Jason Wu: Yup.
41 00:04:30.320 ⇒ 00:04:37.259 Uttam Kumaran: people are just on, like, and… but they… like, everybody loves it, like, I’ll… I’ll… I’ll be on in Sunday, like, I’ll send a message, like, do not respond.
42 00:04:37.450 ⇒ 00:04:42.399 Uttam Kumaran: Don’t worry about this message, but on my mind, I need to send it, or it’ll get lost.
43 00:04:42.400 ⇒ 00:04:46.039 Jason Wu: It’s just, you know, we’re just bred that way, like, starting from, like, college, right?
44 00:04:46.040 ⇒ 00:04:47.349 Uttam Kumaran: Yeah, yeah, just like…
45 00:04:47.610 ⇒ 00:04:48.839 Jason Wu: We’re, we’re wired.
46 00:04:48.840 ⇒ 00:04:54.070 Uttam Kumaran: Or I’m, like, reading Hacker News, or I’m, like, texting somebody of, like, something that came out, and so…
47 00:04:54.190 ⇒ 00:05:01.940 Uttam Kumaran: Yeah, I’m just glad. Even the AI stuff in particular, I feel really lucky, because we get to do it now for work. It just stays super up-to-date.
48 00:05:02.070 ⇒ 00:05:16.700 Uttam Kumaran: And I get to try a lot of it, stuff for ARC, for Brainforge first, because I’m like, hey, if it’s helping, we should try it, and then we find out sort of what’s working, and then we’re trying to bring that to clients, so… like, it’s like super dog-fooding, which is… which is awesome.
49 00:05:16.820 ⇒ 00:05:17.610 Jason Wu: Nice.
50 00:05:17.610 ⇒ 00:05:18.500 Uttam Kumaran: Nice.
51 00:05:19.030 ⇒ 00:05:20.680 Jason Wu: Alright, let’s.
52 00:05:20.680 ⇒ 00:05:21.299 Uttam Kumaran: Let’s go through.
53 00:05:21.300 ⇒ 00:05:22.580 Jason Wu: Get set up, huh?
54 00:05:23.160 ⇒ 00:05:24.770 Jason Wu: Hold on, let me share my screen.
55 00:05:24.930 ⇒ 00:05:27.940 Jason Wu: Yeah, thanks for the time. I just wanted to make sure that we were just…
56 00:05:28.120 ⇒ 00:05:33.049 Jason Wu: You know, if there’s any specific settings that, like, we can just kind of get ahead of now, it’s like, let’s just go for it now.
57 00:05:35.240 ⇒ 00:05:40.959 Jason Wu: Alright, so… it sounds like we just want to kind of, like… I’m literally just kind of signing up for a trial, I assume, right?
58 00:05:40.960 ⇒ 00:05:41.570 Uttam Kumaran: Yeah.
59 00:05:42.840 ⇒ 00:05:46.530 Jason Wu: Alright, let’s get this all set up here.
60 00:05:54.220 ⇒ 00:05:56.049 Jason Wu: It’s a slow to respond right now.
61 00:06:02.210 ⇒ 00:06:07.109 Uttam Kumaran: Yeah, so there should be two steps. It’ll ask you for some info, and then it’ll have you pick
62 00:06:07.950 ⇒ 00:06:11.050 Uttam Kumaran: Like, a cloud provider to sit on top of, so…
63 00:06:12.050 ⇒ 00:06:13.500 Jason Wu: Wow, that’s what’s going on?
64 00:06:14.170 ⇒ 00:06:16.790 Jason Wu: Just like… Hello.
65 00:06:27.980 ⇒ 00:06:33.609 Jason Wu: Hmm… And that’s remind me again, where are you based out of?
66 00:06:33.610 ⇒ 00:06:34.649 Uttam Kumaran: I’m in Austin.
67 00:06:34.860 ⇒ 00:06:35.570 Jason Wu: Nice.
68 00:06:36.410 ⇒ 00:06:38.220 Uttam Kumaran: You’re in, in LA?
69 00:06:38.220 ⇒ 00:06:40.530 Jason Wu: San Francisco, or Santa Clara.
70 00:06:40.840 ⇒ 00:06:43.830 Uttam Kumaran: Oh, okay, I’m gonna be in… I’ll be in the Bay on Friday.
71 00:06:44.050 ⇒ 00:06:45.709 Uttam Kumaran: Sweet. I grew up in Santa Monica.
72 00:06:45.710 ⇒ 00:06:47.519 Jason Wu: Or doing some vacation?
73 00:06:47.680 ⇒ 00:06:51.390 Uttam Kumaran: Just visiting some friends. I grew up in San Ramon, so…
74 00:06:51.390 ⇒ 00:06:51.850 Jason Wu: Nice.
75 00:06:51.850 ⇒ 00:06:57.689 Uttam Kumaran: Yeah, that’s where… so, just visiting some friends and family, but I’ll be back here for Christmas, so…
76 00:07:00.470 ⇒ 00:07:03.230 Uttam Kumaran: Yeah, I do not know why. I mean, let me try it on my end.
77 00:07:03.230 ⇒ 00:07:08.329 Jason Wu: Yeah, let me… let me stop sharing my screen. I wonder if there’s something going on with the screen share or something like that that’s causing it.
78 00:07:12.600 ⇒ 00:07:17.410 Uttam Kumaran: Okay, it’s working on my end. I can send you the…
79 00:07:20.310 ⇒ 00:07:22.239 Uttam Kumaran: I can send you the trial.
80 00:07:25.600 ⇒ 00:07:26.400 Jason Wu: Is there, like, a…
81 00:07:26.400 ⇒ 00:07:27.130 Uttam Kumaran: link.
82 00:07:27.230 ⇒ 00:07:29.270 Uttam Kumaran: And maybe you can see if that opens up directly.
83 00:07:29.270 ⇒ 00:07:29.830 Jason Wu: Yeah.
84 00:07:34.770 ⇒ 00:07:36.200 Jason Wu: Yep, that worked.
85 00:07:37.510 ⇒ 00:07:38.350 Jason Wu: Okay, hold on.
86 00:08:02.600 ⇒ 00:08:05.860 Jason Wu: Choose your Snowflake Edition Enterprise, or Standard?
87 00:08:06.320 ⇒ 00:08:09.540 Uttam Kumaran: Do you mind sharing screen? But it should be standard.
88 00:08:10.620 ⇒ 00:08:11.580 Jason Wu: Give me a sec here.
89 00:08:14.670 ⇒ 00:08:15.360 Jason Wu: Standard?
90 00:08:15.360 ⇒ 00:08:16.689 Uttam Kumaran: Yeah, I’ll do standard.
91 00:08:16.850 ⇒ 00:08:18.580 Jason Wu: Okay, clock… And then…
92 00:08:18.580 ⇒ 00:08:22.660 Uttam Kumaran: I would pick AWS, and then just do the standard US East.
93 00:08:22.810 ⇒ 00:08:23.970 Uttam Kumaran: Whatever the most popular…
94 00:08:23.970 ⇒ 00:08:24.819 Jason Wu: the UCs.
95 00:08:25.680 ⇒ 00:08:32.669 Uttam Kumaran: Yeah, I mean, what do you… do you guys… yeah, I mean, it doesn’t really matter, USCIS is just gonna be the base.
96 00:08:32.679 ⇒ 00:08:34.519 Jason Wu: I don’t think it really matters for us as much.
97 00:08:34.960 ⇒ 00:08:36.330 Uttam Kumaran: Yeah, then I would go ahead.
98 00:08:36.740 ⇒ 00:08:40.369 Uttam Kumaran: Okay. They’re gonna try to get… segment your…
99 00:08:40.659 ⇒ 00:08:42.600 Uttam Kumaran: Your customer profile a little bit.
100 00:08:44.340 ⇒ 00:08:46.759 Jason Wu: None of these.
101 00:08:48.970 ⇒ 00:08:50.670 Jason Wu: Can I just continue? Alright.
102 00:08:50.800 ⇒ 00:08:57.540 Jason Wu: What we use Snowflake for… data warehouse… Check your inbox…
103 00:09:11.190 ⇒ 00:09:12.340 Jason Wu: Alright.
104 00:09:14.320 ⇒ 00:09:23.410 Uttam Kumaran: Great, so, I mean, typically I would just either do… we typically just do all capital, first, last, as, like, username, yeah, and then password is whatever.
105 00:09:25.260 ⇒ 00:09:26.089 Jason Wu: Oh, okay.
106 00:09:27.630 ⇒ 00:09:28.870 Uttam Kumaran: And then…
107 00:09:29.550 ⇒ 00:09:30.629 Jason Wu: Get started?
108 00:09:30.630 ⇒ 00:09:34.149 Uttam Kumaran: Yes And I can give you a little tour.
109 00:09:37.440 ⇒ 00:09:39.129 Jason Wu: Alright, give me one second here.
110 00:09:44.070 ⇒ 00:09:46.149 Uttam Kumaran: So you can skip for now.
111 00:09:46.570 ⇒ 00:09:46.920 Jason Wu: Coach?
112 00:09:46.920 ⇒ 00:09:51.310 Uttam Kumaran: So, yeah, maybe if I give you a little tour. So this is just, like, the homepage where you land.
113 00:09:53.230 ⇒ 00:10:12.500 Uttam Kumaran: On the left side, you have, like, several different sort of areas. Maybe if you want to first click on projects, we can just go through, kind of, down the list. So projects, this is where you’re, like, you’re, like, starting to do something. So if you hover on project, you’re gonna see there’s, like, several types of things you can do. Notebooks, Streamlit, Dashboard, so let’s go ahead and just click on worksheets.
114 00:10:12.660 ⇒ 00:10:16.500 Uttam Kumaran: And I think you may already be in this section, and you can go ahead and just click plus.
115 00:10:17.040 ⇒ 00:10:20.870 Uttam Kumaran: And now you’re in, like, a worksheet.
116 00:10:21.000 ⇒ 00:10:30.620 Uttam Kumaran: Got it. So, for example, and then let’s just start here. So if you go to the left, you see databases, if you scroll down and go Snowflake Learning, or Snowflake Sample Data.
117 00:10:31.000 ⇒ 00:10:32.719 Uttam Kumaran: And you just open this one?
118 00:10:33.220 ⇒ 00:10:35.760 Uttam Kumaran: You can just open any of them.
119 00:10:36.570 ⇒ 00:10:42.910 Uttam Kumaran: So, the nice thing about Snowflake is, again, it’s just really easy to show. You can click on this, you can easily profile it, see all the…
120 00:10:43.140 ⇒ 00:10:48.889 Uttam Kumaran: columns, see the types, kind of see what’s in there. Go ahead and click on the preview, like, which is…
121 00:10:49.050 ⇒ 00:10:52.700 Uttam Kumaran: This little button… Here?
122 00:10:53.820 ⇒ 00:10:54.380 Jason Wu: Yep.
123 00:10:55.470 ⇒ 00:10:57.870 Uttam Kumaran: Yep.
124 00:10:59.700 ⇒ 00:11:06.390 Uttam Kumaran: And you can go ahead and see all the columns, and go to Data Preview, and you should think about probably a bunch of fake.
125 00:11:06.870 ⇒ 00:11:07.230 Uttam Kumaran: Okay.
126 00:11:07.930 ⇒ 00:11:16.990 Uttam Kumaran: So, this is like, you know, if you’re coming in and just profiling data, we can go back to the worksheet, and we can just run a simple,
127 00:11:17.090 ⇒ 00:11:18.570 Uttam Kumaran: select star.
128 00:11:18.770 ⇒ 00:11:19.320 Jason Wu: Yep.
129 00:11:19.770 ⇒ 00:11:23.020 Uttam Kumaran: Select star from, and then you can just type in…
130 00:11:23.200 ⇒ 00:11:26.519 Uttam Kumaran: Snowflake Sample Data, which is the database.
131 00:11:26.730 ⇒ 00:11:33.480 Uttam Kumaran: dot… TPCH dash… TPCH underscore SF1.
132 00:11:33.980 ⇒ 00:11:34.590 Jason Wu: Yep.
133 00:11:34.590 ⇒ 00:11:35.810 Uttam Kumaran: dot customer.
134 00:11:37.130 ⇒ 00:11:43.079 Uttam Kumaran: And then you can go ahead and just hit Command-Enter, or press the… Plus, either one.
135 00:11:43.540 ⇒ 00:11:46.820 Uttam Kumaran: And… This is running a query.
136 00:11:47.090 ⇒ 00:11:48.110 Uttam Kumaran: So…
137 00:11:48.440 ⇒ 00:12:02.489 Uttam Kumaran: a lot of our work is going to be, like, exploratory in here, and then once we kind of get a query, we’re gonna move it to dbt to get scheduled. So, for example, in this situation, if we wanted to combine customer with orders with regions.
138 00:12:02.680 ⇒ 00:12:13.000 Uttam Kumaran: our development workflow would be like, okay, let’s just explore these tables, find the foreign and join keys, write the query here, and then get it scheduled in dbt to sort of execute.
139 00:12:14.750 ⇒ 00:12:21.480 Uttam Kumaran: So yeah, so this is just, like, the worksheet. The nice thing is you can create multiple worksheets at the top, so it’s just nice for, like, workflow.
140 00:12:21.620 ⇒ 00:12:23.959 Uttam Kumaran: If you go back here…
141 00:12:24.360 ⇒ 00:12:28.449 Uttam Kumaran: To the top left, and, like, open this, like, carousel thing again.
142 00:12:28.610 ⇒ 00:12:32.369 Uttam Kumaran: We can go ahead and go to, ingestion.
143 00:12:36.360 ⇒ 00:12:55.850 Uttam Kumaran: And this is where, like, there’s several native ingestion, options within Snowflake. Again, for… in our situation, we’re gonna be using Polyatomic, but, like, for example, as you can see, they’re, investing in native connectors, which I didn’t even know they added Google Analytics, so we may actually avoid…
144 00:12:55.850 ⇒ 00:12:57.089 Jason Wu: Yay, that’s cool.
145 00:12:57.090 ⇒ 00:12:57.729 Uttam Kumaran: That would be cool.
146 00:12:57.730 ⇒ 00:13:00.330 Jason Wu: I wonder how Google… I wonder how nice they’re gonna play with them.
147 00:13:00.330 ⇒ 00:13:18.489 Uttam Kumaran: Yeah, so… so this is all kind of, like, what I… what I’ve been enjoying seeing is they started adding these native connectors, so you kind of skip ETL altogether, which, like, for the polyatomics of the world, they’re not… they won’t… they may not make money on that, but for Snowflakes, they’re like, we own the compute, landed directly, so…
148 00:13:19.020 ⇒ 00:13:24.750 Uttam Kumaran: That, and then there’s Snowflake Marketplace is also interesting to poke around at some point. You can buy data.
149 00:13:25.070 ⇒ 00:13:27.689 Uttam Kumaran: There may be even some providers that
150 00:13:28.080 ⇒ 00:13:38.200 Uttam Kumaran: element uses that maybe they’re like, oh, actually, instead of us sending flat files, you can just buy our stuff directly from Marketplace. You can use your own Snowflake credits, and it stays governed, so…
151 00:13:38.450 ⇒ 00:13:43.589 Uttam Kumaran: this, like, interesting feature there. The other thing, if we want to go to, monitoring here on the left…
152 00:13:45.260 ⇒ 00:13:53.089 Uttam Kumaran: you can start to see, a query history. So, this was your query history before.
153 00:13:53.090 ⇒ 00:13:53.405 Jason Wu: Sure.
154 00:13:53.990 ⇒ 00:14:03.199 Uttam Kumaran: And so, for example, if we’re, like, if someone’s like, oh, my BI job is failing, this is usually where I go to just see, like, hey, what was it that failed?
155 00:14:04.790 ⇒ 00:14:07.610 Uttam Kumaran: And then the next piece, you can actually go into…
156 00:14:07.710 ⇒ 00:14:12.950 Uttam Kumaran: is, like, maybe I’ll share with you the governance and security piece.
157 00:14:13.130 ⇒ 00:14:14.459 Uttam Kumaran: So this is where…
158 00:14:14.620 ⇒ 00:14:27.619 Uttam Kumaran: sort of, like, user roles, trust center security policies are. I don’t… I don’t know if you guys have any, like, IP restrictions, or if you guys do IP whitelists. It’s easy for us to set up network policies and stuff like that.
159 00:14:27.620 ⇒ 00:14:28.870 Jason Wu: Okay.
160 00:14:28.870 ⇒ 00:14:32.599 Uttam Kumaran: But this is exactly where you’d add a user. So you could go to Add Me.
161 00:14:32.850 ⇒ 00:14:37.030 Uttam Kumaran: And then I will come in here and sort of add everybody else.
162 00:14:37.030 ⇒ 00:14:38.860 Jason Wu: So it’ll ask you to… So, user or invites.
163 00:14:38.860 ⇒ 00:14:41.120 Uttam Kumaran: Create… you can…
164 00:14:41.250 ⇒ 00:14:52.650 Uttam Kumaran: I… I guess you can… maybe let’s go through Create User, I’ll just kind of show you what the dialogue is. So yeah, you can just type in U-T-T-A-M, and then K-U-M-A-R-A-N.
165 00:14:52.880 ⇒ 00:14:56.390 Uttam Kumaran: And then it’s just utam at brainforge.ai.
166 00:14:57.070 ⇒ 00:15:00.499 Uttam Kumaran: You can set some type of temp password.
167 00:15:01.070 ⇒ 00:15:04.389 Uttam Kumaran: Oh, is it… it’s optional? Oh, they may have changed it.
168 00:15:05.080 ⇒ 00:15:10.410 Uttam Kumaran: Yeah, you can just type… yeah, or you can just type in some type of temporary password.
169 00:15:11.170 ⇒ 00:15:17.659 Uttam Kumaran: I don’t know, I feel like it used to not be optional, so I wonder if they just changed it recently. They’re trying to move everything to passwordless.
170 00:15:18.230 ⇒ 00:15:19.909 Jason Wu: 14 characters.
171 00:15:20.140 ⇒ 00:15:21.220 Jason Wu: Alright, hold on.
172 00:15:30.500 ⇒ 00:15:33.039 Jason Wu: No, I recall this when I…
173 00:15:33.810 ⇒ 00:15:35.959 Jason Wu: Got you guys the, other stuff.
174 00:15:35.960 ⇒ 00:15:47.639 Uttam Kumaran: Okay, okay. And then, if you click on Advanced User Options, this is where you’ll just be able to specify, like, any other details. The only thing I’d ask, if you can put role, and you can just put here as account admin.
175 00:15:47.830 ⇒ 00:15:54.660 Uttam Kumaran: Okay. So that’ll give me, sort of, kind of super user access. This… everything else is fine. So you can go to head and click Create User.
176 00:15:55.030 ⇒ 00:16:01.260 Jason Wu: Okay. Hold on, I just… The password’s no surprise.
177 00:16:01.260 ⇒ 00:16:02.899 Uttam Kumaran: Oops, okay, cool.
178 00:16:03.190 ⇒ 00:16:04.299 Jason Wu: It’s in the Zoom.
179 00:16:04.520 ⇒ 00:16:06.070 Jason Wu: Just put a T, didn’t you right now.
180 00:16:06.340 ⇒ 00:16:07.120 Uttam Kumaran: Okay, great.
181 00:16:07.800 ⇒ 00:16:08.940 Jason Wu: Pretty simple.
182 00:16:10.220 ⇒ 00:16:15.619 Jason Wu: So, I’m curious, right? Obviously, this isn’t gonna be… this isn’t your first snowflake.
183 00:16:16.050 ⇒ 00:16:21.980 Jason Wu: Is your login tied specifically now to our instance, or is, like, is this, like, a shared login that you.
184 00:16:21.980 ⇒ 00:16:31.189 Uttam Kumaran: No, so if you’ll… that’s a good question. This was on my, agenda today, but let’s skip there. So if you hover over your, thing right here on the bottom left.
185 00:16:31.590 ⇒ 00:16:33.140 Jason Wu: Go ahead.
186 00:16:33.140 ⇒ 00:16:34.560 Uttam Kumaran: Like, just go ahead and click that.
187 00:16:35.350 ⇒ 00:16:41.710 Uttam Kumaran: and go ahead and hover or click on this. This is where you’re gonna actually see your…
188 00:16:41.710 ⇒ 00:16:42.380 Jason Wu: Oh, okay.
189 00:16:42.380 ⇒ 00:16:43.310 Uttam Kumaran: count here.
190 00:16:43.680 ⇒ 00:16:47.409 Uttam Kumaran: So, I assume this is probably the Emerson…
191 00:16:47.410 ⇒ 00:16:48.799 Jason Wu: This is Emerson, yeah.
192 00:16:48.800 ⇒ 00:16:56.710 Uttam Kumaran: Yes, so this is how… on mine, there’s, like, 10 of these, but every… everyone has different account identifiers.
193 00:16:56.710 ⇒ 00:16:59.969 Jason Wu: And is that tied to the email, or to the username?
194 00:17:01.190 ⇒ 00:17:07.450 Uttam Kumaran: Username, meaning you log… you would… you log in with your username.
195 00:17:07.750 ⇒ 00:17:08.599 Jason Wu: Okay.
196 00:17:08.970 ⇒ 00:17:13.919 Uttam Kumaran: The email, I think, is primarily for password reset and an initial invitation.
197 00:17:14.089 ⇒ 00:17:14.969 Jason Wu: Got it.
198 00:17:15.950 ⇒ 00:17:21.160 Uttam Kumaran: Yeah, so let me just make sure I got…
199 00:17:22.089 ⇒ 00:17:24.780 Uttam Kumaran: And I’ll just confirm I can log in on my side.
200 00:17:37.790 ⇒ 00:17:39.000 Uttam Kumaran: A…
201 00:18:09.140 ⇒ 00:18:10.149 Uttam Kumaran: Okay, I’m in.
202 00:18:10.320 ⇒ 00:18:11.000 Uttam Kumaran: Great.
203 00:18:11.720 ⇒ 00:18:12.350 Jason Wu: Cool.
204 00:18:12.350 ⇒ 00:18:20.410 Uttam Kumaran: So, maybe another thing I can share with you is, if under Manage, on the left here.
205 00:18:20.820 ⇒ 00:18:24.760 Uttam Kumaran: You’ll see Compute, so if you go to Compute and warehouses.
206 00:18:24.980 ⇒ 00:18:30.869 Uttam Kumaran: So, Warehouse is, sort of like your box, and so we’ll be creating
207 00:18:31.140 ⇒ 00:18:45.459 Uttam Kumaran: basically three boxes, one for ingestion, one for transformation, and one for, reporting. The reason why we do that is their workloads are different, right? So, ingestion is all, typically, like, copy commands.
208 00:18:45.600 ⇒ 00:18:53.549 Uttam Kumaran: Because the way Polyatomic typically works is they land a data in a stage environment, copy it over, and sort of, like, almost like this, like, batch…
209 00:18:53.710 ⇒ 00:19:01.159 Uttam Kumaran: mix of, like… yeah, it’s basically, like, just batch dumping things. Transformations are all create and update table commands.
210 00:19:02.200 ⇒ 00:19:07.680 Uttam Kumaran: And, the BI tools are all select stars. Additionally.
211 00:19:07.850 ⇒ 00:19:16.490 Uttam Kumaran: the ingestions, they run, like, sort of, like, all the time, like, on a schedule, right? So, you wanna… you don’t… you’re not really caring that, like, they take
212 00:19:16.980 ⇒ 00:19:21.509 Uttam Kumaran: Two more minutes, or, like, your cluster doesn’t need to be up in, like, 5 seconds.
213 00:19:21.510 ⇒ 00:19:23.890 Jason Wu: Whereas for your BI tool.
214 00:19:23.890 ⇒ 00:19:32.459 Uttam Kumaran: you may have longer, you may have your cluster stay on longer instead of getting auto-suspended. So there’s these, like, tweaks that we do to make sure that
215 00:19:32.590 ⇒ 00:19:39.460 Uttam Kumaran: One, you’re not, like, blowing through credits, and then second, that the workload is tied to the right warehouse.
216 00:19:39.850 ⇒ 00:19:40.890 Uttam Kumaran: Yeah, go ahead.
217 00:19:41.180 ⇒ 00:19:44.969 Jason Wu: I was like, why have 3? Ingestion and, like…
218 00:19:45.180 ⇒ 00:19:46.870 Jason Wu: I’m sorry, a second like transformation?
219 00:19:46.870 ⇒ 00:19:47.820 Uttam Kumaran: transformation.
220 00:19:47.820 ⇒ 00:19:54.250 Jason Wu: Yeah, so… isn’t transformation to already get that ready for the BI tool?
221 00:19:54.250 ⇒ 00:19:54.989 Uttam Kumaran: Yeah, the…
222 00:19:54.990 ⇒ 00:19:56.219 Jason Wu: We’ll separate it out again further.
223 00:19:56.220 ⇒ 00:20:05.240 Uttam Kumaran: the transformation isn’t to take the raw data and build the reporting marts, right? So, combine customers with orders with whatever, and create
224 00:20:05.900 ⇒ 00:20:14.480 Uttam Kumaran: orders table, right? The canonical orders table. The reason why is you don’t want your ingestion jobs to get tripped up with
225 00:20:14.690 ⇒ 00:20:21.609 Uttam Kumaran: by… transformation, meaning, like, let’s say your… your transformation job is eating all of your compute.
226 00:20:21.810 ⇒ 00:20:24.170 Uttam Kumaran: You don’t want that to affect your, like.
227 00:20:24.480 ⇒ 00:20:42.530 Uttam Kumaran: data ingestion. Like, you will just want those sep… you want those separate. And, like, that’s the primary reason. Another example is, sometimes, commonly, people make a mistake with Snowflake, where they never change this, they stay with Compute Warehouse, and then they just… everything uses it. What happens is, like, you have, like, all these users, like.
228 00:20:42.700 ⇒ 00:20:49.319 Uttam Kumaran: The service users on all end days, and everybody’s using this, and you just, like, will start to queue resources.
229 00:20:49.330 ⇒ 00:21:02.999 Uttam Kumaran: So that’s… it’s sort of our standard way. You will see a lot… a lot of enterprise places will have small, medium, large warehouses in each thing, just depending on the type of…
230 00:21:03.050 ⇒ 00:21:07.340 Uttam Kumaran: job you’re running, or the priority. For example, your executive dashboard.
231 00:21:07.420 ⇒ 00:21:14.199 Uttam Kumaran: You want to always run no matter what, versus, like, someone’s, like, random dashboard that they’re just playing around with.
232 00:21:14.200 ⇒ 00:21:17.349 Jason Wu: can sit lower in the queue. So that’s sort of how we’re doing…
233 00:21:17.720 ⇒ 00:21:19.560 Uttam Kumaran: Workload management, you know?
234 00:21:19.560 ⇒ 00:21:20.120 Jason Wu: Good.
235 00:21:22.590 ⇒ 00:21:29.830 Uttam Kumaran: And then, I think if you go to Admin as well, I’ll just share, there is a, Cost Management tab.
236 00:21:30.130 ⇒ 00:21:35.189 Uttam Kumaran: Okay. So, as… Start to run queries.
237 00:21:36.890 ⇒ 00:21:50.149 Uttam Kumaran: you’ll start to use credits. Again, we have a 30-day free trial with $400 in credits. We will not end up using that amount, for sure. But you’ll start to see, as Polyatomic starts to land data.
238 00:21:50.360 ⇒ 00:21:53.289 Uttam Kumaran: Like, the commands they’re running and, like, how it uses this.
239 00:21:54.310 ⇒ 00:21:58.340 Uttam Kumaran: There’s a lot we could do on cost management, too, so…
240 00:21:58.590 ⇒ 00:22:09.149 Uttam Kumaran: I’m not, like, too worried about, and especially in the next, like, few months, this, like, really, really ramping. Where cost comes into play a lot is that once you start to have a BI tool, and people are, like.
241 00:22:09.300 ⇒ 00:22:16.630 Uttam Kumaran: scheduling tons of reports, or, like, at peak periods, they’re running a lot of stuff. It’s just being mindful of, like.
242 00:22:16.790 ⇒ 00:22:22.629 Uttam Kumaran: okay, should we have a higher cluster at this point and lower later? And there’s ways to sort of manage, just like…
243 00:22:22.800 ⇒ 00:22:25.210 Uttam Kumaran: You know, any sort of… Management.
244 00:22:26.150 ⇒ 00:22:40.730 Uttam Kumaran: That’s… and that’s kind of it. I mean, we’ll be kind of going through and trying to show some of the AI features, you know, as part of the demo, as part of, like, this process as we start to land data. This is all brand new, though, the AI… that basically that whole AI tab.
245 00:22:40.800 ⇒ 00:22:49.329 Uttam Kumaran: Like, brand new as in, like, last, like, 90 days, there’s, like, new features coming. So, it’s gonna be interesting for us to, like, test and…
246 00:22:49.720 ⇒ 00:22:52.679 Jason Wu: And show, like, what’s possible within Snowflake directly.
247 00:22:52.840 ⇒ 00:23:00.379 Uttam Kumaran: So I noticed I did not need to put in a credit card yet, but… Yeah, so actually, again, I think they… they changed it where…
248 00:23:00.380 ⇒ 00:23:01.509 Jason Wu: of the credits.
249 00:23:01.510 ⇒ 00:23:01.990 Uttam Kumaran: Yes.
250 00:23:01.990 ⇒ 00:23:09.139 Jason Wu: I mean, and then charge later. Yeah. Okay, cool. So you’ve got access to this.
251 00:23:09.340 ⇒ 00:23:12.019 Jason Wu: On my side, just heads up,
252 00:23:12.270 ⇒ 00:23:14.640 Jason Wu: How do I pronounce… is it Golib, or…
253 00:23:14.640 ⇒ 00:23:15.490 Uttam Kumaran: Gob.
254 00:23:15.490 ⇒ 00:23:19.919 Jason Wu: Okay, so I… I… I actually just asked Gala, just as a…
255 00:23:20.070 ⇒ 00:23:24.649 Jason Wu: standard thing, if you can just get our standard NDA signed.
256 00:23:24.650 ⇒ 00:23:25.160 Uttam Kumaran: Sure.
257 00:23:25.160 ⇒ 00:23:29.069 Jason Wu: He’s like, yeah, send it to me. So I sent it to him. I’m still waiting for him to sign it.
258 00:23:29.070 ⇒ 00:23:29.640 Uttam Kumaran: Okay, okay.
259 00:23:29.640 ⇒ 00:23:42.940 Jason Wu: I’ve already created the Shopify dev app, but once he signs it, I’ll go ahead and just, like, add the API keys to the Polytomic. Okay. Although, maybe since you’re here, because I’m not… I’m not actually logged into the Polyatomic yet.
260 00:23:43.050 ⇒ 00:23:46.170 Jason Wu: And I think you sent me an invite for that, if I recall.
261 00:23:46.170 ⇒ 00:23:49.419 Uttam Kumaran: Yeah, I think it’s that one up… It’s this one, right?
262 00:23:49.930 ⇒ 00:23:51.620 Jason Wu: Won’t allow it just.
263 00:23:51.620 ⇒ 00:23:55.299 Uttam Kumaran: Oh, that’s the docs. Yeah, go ahead and just go to polyatomic.com.
264 00:23:55.440 ⇒ 00:23:57.979 Uttam Kumaran: I think he should’ve… he should’ve received it, yeah.
265 00:23:58.260 ⇒ 00:23:58.900 Jason Wu: Yep.
266 00:24:00.110 ⇒ 00:24:01.500 Jason Wu: Let me just log in.
267 00:24:03.520 ⇒ 00:24:04.960 Jason Wu: Cool.
268 00:24:10.070 ⇒ 00:24:13.820 Jason Wu: Oh, okay. And then, under connections, I add a connection.
269 00:24:14.020 ⇒ 00:24:15.579 Jason Wu: For Shopify, I assume?
270 00:24:15.580 ⇒ 00:24:16.200 Uttam Kumaran: Correct.
271 00:24:16.400 ⇒ 00:24:26.989 Jason Wu: Okay, cool. So, yeah, once he, signs the NDA, I’ll get that squared out. And then if there’s any other connections that he’s looking for, just kind of send them our way.
272 00:24:27.400 ⇒ 00:24:35.749 Uttam Kumaran: Yeah, I’ll, and I’m gonna… I’ll… we’ll go in, and I’m gonna add a connection to Snowflake also, and then I’ll record a quick loom of how we
273 00:24:35.990 ⇒ 00:24:43.769 Uttam Kumaran: basically connects Shopify to Snowflake, so then anytime we need to add a new connector, it’s like there’s at least a video on how to do that.
274 00:24:43.960 ⇒ 00:24:46.379 Jason Wu: Is there, just like… hold on, where am I.
275 00:24:46.380 ⇒ 00:24:53.620 Uttam Kumaran: So, yeah, in Snowflake, we… I’ll have to create, like, the places to land all this, so we’ll go in and we have… we have a typical…
276 00:24:53.760 ⇒ 00:24:56.140 Uttam Kumaran: Sort of, like, setup script that we run.
277 00:24:56.250 ⇒ 00:24:59.239 Uttam Kumaran: That creates, you know, sort of all the core things.
278 00:24:59.690 ⇒ 00:25:03.240 Jason Wu: I’m gonna create… Just as a…
279 00:25:03.590 ⇒ 00:25:09.519 Jason Wu: So I’m not the only one. I’ll create an account for Steve and for Andy as well.
280 00:25:09.520 ⇒ 00:25:14.349 Uttam Kumaran: Sure, yeah, and then I’ll… I can go ahead and… I can invite Shivani and…
281 00:25:14.350 ⇒ 00:25:15.829 Jason Wu: Yeah, you should rest.
282 00:25:16.140 ⇒ 00:25:20.040 Uttam Kumaran: Yeah, you can try the invite feature. They used to not have that, so I feel like…
283 00:25:20.210 ⇒ 00:25:20.505 Jason Wu: like…
284 00:25:20.800 ⇒ 00:25:23.910 Uttam Kumaran: Maybe they… yeah, this is actually, like, much better.
285 00:25:24.350 ⇒ 00:25:26.200 Jason Wu: Oh, jeez, yeah, this is easy.
286 00:25:27.180 ⇒ 00:25:29.039 Jason Wu: Look at that, always improving, right?
287 00:25:29.040 ⇒ 00:25:38.650 Uttam Kumaran: Yeah, I know. Well, it’s just, like, it’s just crazy. It just used to be so… like, they did really a good job, and then there’d be, like, small things where they’re like, yeah, to create users, you have to, like.
288 00:25:38.940 ⇒ 00:25:42.329 Uttam Kumaran: Go through this whole process, but they’re making it more shareable.
289 00:25:46.600 ⇒ 00:25:47.650 Jason Wu: Oh, that’s easy.
290 00:25:47.790 ⇒ 00:25:48.570 Jason Wu: Cool.
291 00:25:51.930 ⇒ 00:25:52.750 Jason Wu: Awesome.
292 00:25:53.980 ⇒ 00:25:58.019 Uttam Kumaran: Okay, great. Anything else I can help with?
293 00:25:58.800 ⇒ 00:26:05.050 Jason Wu: I don’t… I don’t think so, I mean, just more just, like, administration,
294 00:26:05.900 ⇒ 00:26:09.869 Jason Wu: I’ll be out of the country starting on Saturday.
295 00:26:09.870 ⇒ 00:26:11.250 Uttam Kumaran: Okay.
296 00:26:11.250 ⇒ 00:26:29.929 Jason Wu: it’s in China, unfortunately, which means I don’t know what my email access is gonna be. Okay. But Steve is the one kind of holding down the fort, so use a Slack channel for anything. Okay. You know, but in terms of, you know, I know your team is probably working, you know, through more of the holiday than we probably are, so…
297 00:26:30.200 ⇒ 00:26:42.739 Jason Wu: you know, reach out to Steve, and he’s available to the 24th, you know, but we’ll have someone, you know, available to kind of, like, help provide any connections. All of us kind of have the keys, so that’s going to be a problem in terms of getting access to anything.
298 00:26:42.880 ⇒ 00:26:43.470 Uttam Kumaran: Okay, okay.
299 00:26:43.470 ⇒ 00:26:43.930 Jason Wu: Okay.
300 00:26:43.930 ⇒ 00:26:44.560 Uttam Kumaran: Perfect.
301 00:26:44.560 ⇒ 00:26:56.360 Jason Wu: Yeah, so that’s just kind of more point of order, and then… yeah, I mean, we’ll continue, obviously, with our calls, but… you know, I think we’re feeling pretty good, kind of, the direction it’s going. Excited for what it’s worth. Again, it’s just…
302 00:26:56.470 ⇒ 00:26:59.069 Jason Wu: Double downing on, like, the need for this stuff.
303 00:26:59.180 ⇒ 00:27:04.529 Jason Wu: I was talking with our supply chain guy, and he’s like, is there any way that you can give me an export of, like.
304 00:27:04.920 ⇒ 00:27:18.989 Jason Wu: recharge reports for subscriptions. I need to forecast better how many boxes of, like, different varieties we need. And I’m like, yes. So, you know, we pulled an export, but at the same time, I was like, guess what? This all’s gonna get ported.
305 00:27:18.990 ⇒ 00:27:20.010 Uttam Kumaran: Yeah, like, just felt.
306 00:27:20.010 ⇒ 00:27:22.869 Jason Wu: Fast forward a few months, please. Yeah.
307 00:27:23.490 ⇒ 00:27:31.740 Uttam Kumaran: That’s awesome. My other question was gonna be about, like, if you’re able to shoot that message over to Emerson. I wrote a little bit of a.
308 00:27:31.740 ⇒ 00:27:33.609 Jason Wu: reminder of that. Let me get that out right now.
309 00:27:33.610 ⇒ 00:27:38.030 Uttam Kumaran: I’ll… I’ll just bump you… I’ll just… I’ll bump in that channel one more time.
310 00:27:38.420 ⇒ 00:27:44.199 Uttam Kumaran: It’s just a message being like, hey, we’re working on this, any chance there’s any other options, let me know.
311 00:27:44.730 ⇒ 00:27:45.380 Jason Wu: Okay.
312 00:27:46.000 ⇒ 00:27:47.290 Jason Wu: Cool, sounds good.
313 00:27:48.380 ⇒ 00:27:51.189 Uttam Kumaran: Okay, perfect. And, yeah, I guess we’ll talk tomorrow, but…
314 00:27:51.670 ⇒ 00:27:52.210 Jason Wu: Yeah.
315 00:27:52.370 ⇒ 00:27:54.109 Jason Wu: Sounds good. Thanks, I appreciate it.
316 00:27:54.110 ⇒ 00:27:56.139 Uttam Kumaran: Thanks, Jason. Yeah, talk to you soon.
317 00:27:56.140 ⇒ 00:27:56.730 Jason Wu: Bye.