Meeting Title: Brainforge x CTA: Weekly! Date: 2026-03-27 Meeting participants: Awaish Kumar, Katherine Bayless, Chi Quinn, Kyle Wandel, Uttam Kumaran
WEBVTT
1 00:00:09.220 ⇒ 00:00:10.040 Awaish Kumar: Perfect.
2 00:00:17.300 ⇒ 00:00:18.160 Awaish Kumar: Good day.
3 00:00:19.880 ⇒ 00:00:21.480 Awaish Kumar: But… Welcome.
4 00:00:31.190 ⇒ 00:00:33.200 Katherine Bayless: Hey, OH, how’s it going?
5 00:00:33.610 ⇒ 00:00:36.420 Awaish Kumar: Hi, it’s going well, how about you?
6 00:00:36.730 ⇒ 00:00:42.690 Katherine Bayless: Let me turn you up. Can you say something else? Let me just make sure.
7 00:00:42.880 ⇒ 00:00:43.560 Awaish Kumar: Huh?
8 00:00:43.940 ⇒ 00:00:44.700 Awaish Kumar: Yeah.
9 00:00:45.330 ⇒ 00:00:45.680 Katherine Bayless: Okay.
10 00:00:46.130 ⇒ 00:00:47.530 Awaish Kumar: How you doing?
11 00:00:48.010 ⇒ 00:00:52.880 Katherine Bayless: Yeah, I’m good. It’s a little quiet on my end, but I think it’s just because it’s loud in here, so it’s fine.
12 00:00:53.160 ⇒ 00:00:53.850 Awaish Kumar: Okay.
13 00:00:54.360 ⇒ 00:00:55.050 Katherine Bayless: Happy Friday!
14 00:00:55.050 ⇒ 00:00:56.579 Awaish Kumar: How has been the week?
15 00:00:57.650 ⇒ 00:01:06.140 Katherine Bayless: Been good, been good. Been, busy, which I kind of like, because then it goes by faster, but, same for you guys, I assume.
16 00:01:06.710 ⇒ 00:01:07.500 Awaish Kumar: Yeah.
17 00:01:08.130 ⇒ 00:01:13.870 Katherine Bayless: Yeah. How many, different, like, clients are you working on at a, like, at the same time?
18 00:01:15.910 ⇒ 00:01:21.499 Awaish Kumar: Yeah, it’s… it’s like, we have different people to work on those things, but
19 00:01:22.050 ⇒ 00:01:26.419 Awaish Kumar: Yeah. I do manage, all those, all those clients.
20 00:01:26.910 ⇒ 00:01:28.410 Katherine Bayless: Yeah.
21 00:01:28.630 ⇒ 00:01:43.550 Katherine Bayless: at my, at my old place, I worked on our… we had, like, two for-profit subsidiaries that were SaaS sort of companies, and every now and then, I’d be in a situation where I had, like, 4 or 5 clients that I was working with at once, and I was like.
22 00:01:46.060 ⇒ 00:01:49.189 Katherine Bayless: I get, I get overwhelmed quickly.
23 00:01:50.390 ⇒ 00:01:51.100 Awaish Kumar: Yeah.
24 00:01:55.530 ⇒ 00:01:56.819 Katherine Bayless: Hi, good morning.
25 00:01:57.610 ⇒ 00:01:58.890 Chi Quinn: Good morning!
26 00:02:04.050 ⇒ 00:02:06.390 Chi Quinn: Are you in the cafe?
27 00:02:07.910 ⇒ 00:02:11.220 Katherine Bayless: Yeah, I am. I have so…
28 00:02:11.520 ⇒ 00:02:25.830 Katherine Bayless: Some friends of mine and I, we submitted a session to speak at the ASAE conference in August, and since there are 5 of us on the session, we were like, we need to start early trying to get together and plan this, because it’s going to be a nightmare to coordinate calendars.
29 00:02:25.830 ⇒ 00:02:33.840 Katherine Bayless: So, we’re meeting for lunch today, so I was like, I’ll get close to the lunch location, and so I can just hop off calls and get there.
30 00:02:33.950 ⇒ 00:02:34.729 Katherine Bayless: But yeah.
31 00:02:34.730 ⇒ 00:02:35.420 Chi Quinn: Nice.
32 00:02:35.900 ⇒ 00:02:36.410 Katherine Bayless: Oh.
33 00:02:36.410 ⇒ 00:02:37.080 Chi Quinn: tonight.
34 00:02:37.080 ⇒ 00:02:51.700 Katherine Bayless: And actually, I have a hard stop for me at 11, because I have to meet with Christina, but, I’m actually super excited for today, because Utom is going to kind of walk us through, at least in part, the,
35 00:02:51.870 ⇒ 00:03:01.409 Katherine Bayless: he figured out how to get, like, Snowflake and Claude’s CLI wired up so that you can code the Streamlit apps and push them that way, versus kind of what we were doing the other day. Yeah.
36 00:03:01.410 ⇒ 00:03:03.350 Chi Quinn: Right, right. Oh, nice.
37 00:03:03.740 ⇒ 00:03:06.940 Katherine Bayless: Yeah, so yeah, I’m, like, exciting.
38 00:03:07.080 ⇒ 00:03:13.729 Awaish Kumar: Yeah, so while we are waiting for Utam to join, yeah, we can maybe discuss the Shopify stuff.
39 00:03:14.000 ⇒ 00:03:15.220 Awaish Kumar: Oh, we did the…
40 00:03:15.220 ⇒ 00:03:16.440 Katherine Bayless: Yeah, yeah, yeah, yeah.
41 00:03:17.080 ⇒ 00:03:31.980 Awaish Kumar: We did, like, the last pass on… so I have a few updates. One, on CES modeling, we had some reviews from Kyle that we pushed. There’s nothing new, it’s ongoing conversation between us and Kyle on a few…
42 00:03:32.610 ⇒ 00:03:43.240 Awaish Kumar: tables, and we just, back and forth on that. So, I think we are almost, done with that. Second thing is identity switching, which is,
43 00:03:43.640 ⇒ 00:03:52.049 Awaish Kumar: Where you wanted that we shouldn’t lose email and phone numbers, and that is also pushed to production, as we get an update from.
44 00:03:52.050 ⇒ 00:03:52.570 Katherine Bayless: Oh, shit.
45 00:03:52.570 ⇒ 00:04:02.060 Awaish Kumar: Second thing, he also did some, spike on using Cortex for identity stitching, but I think I just added a document in our
46 00:04:02.250 ⇒ 00:04:05.269 Awaish Kumar: shared CTA channel, and it just has some…
47 00:04:05.930 ⇒ 00:04:10.370 Awaish Kumar: points from Ashwani, that he did spike, and what he found.
48 00:04:11.030 ⇒ 00:04:16.240 Awaish Kumar: And that’s mostly, like you said, like, the deterministic way which we are doing is…
49 00:04:16.240 ⇒ 00:04:16.890 Katherine Bayless: Skarno?
50 00:04:16.890 ⇒ 00:04:24.590 Awaish Kumar: He feels, like, much more… better, in a sense that we know, for example, IDs, and sometimes we know
51 00:04:25.200 ⇒ 00:04:40.180 Awaish Kumar: how to join these things, instead of just relying on… on Cortex, because Cortex is… will be just doing the fuzzy mapping between the fields all the time, and so, yeah, that was the conclusion out of that.
52 00:04:41.910 ⇒ 00:04:50.520 Katherine Bayless: I think that makes a lot of sense. I mean, when I’ve tried to do some of the matching with AI, like, the fuzzy… I mean, it’s very good at writing code.
53 00:04:50.850 ⇒ 00:04:54.590 Katherine Bayless: But, like, the fuzzy matches just are kind of messy. I think it’s, like…
54 00:04:55.120 ⇒ 00:05:19.929 Katherine Bayless: to a certain extent, I feel like part of it is the nature of the company data, right? I mean, we’re doing fuzzy matching on one field, basically, right? Like, if we were able to fuzzy match across, like, a number of different sort of data points, it’d be maybe a little better, but yeah, like, Acme LLC and Amazon LLC have enough letters in common that they get fuzzy matched together, and so yeah, I think the deterministic approach is
55 00:05:20.050 ⇒ 00:05:21.900 Katherine Bayless: Likely to be the strongest.
56 00:05:22.010 ⇒ 00:05:24.980 Katherine Bayless: And just leverage AI for some of the messy leftovers.
57 00:05:26.630 ⇒ 00:05:27.210 Awaish Kumar: Yep.
58 00:05:28.040 ⇒ 00:05:41.540 Awaish Kumar: And the… then the Shopify stuff, I set up the snow pipes, but yeah, the data is in Snowflake right now, and I… and then I tested that, I tried to add a file.
59 00:05:41.740 ⇒ 00:05:58.410 Awaish Kumar: to Shopify customers and try to see. It does load, so it’s, like, ingestion is working. So now the new files we are going to land in the S3 will be ingested in Snowflake. The second piece is now the modeling part, so now we have to…
60 00:05:58.590 ⇒ 00:06:17.610 Awaish Kumar: And I have ingested in a way that is… that might not be the cleanest way, because, like, the fields can change. Maybe it’s tomorrow you upload a file which has some new column, or missing column, or things like that. It might break if I try to create a schema.
61 00:06:18.170 ⇒ 00:06:30.560 Awaish Kumar: while ingesting. So instead of that, I try to write it as a variant for now, so that ingestion doesn’t fail, but we are going to handle that in our DVD models, where we try to, like.
62 00:06:30.820 ⇒ 00:06:44.140 Awaish Kumar: get everything from that JSON fields to actually have some columns. So in our SDG, we are going to do that, then we move to the intermediate ones, where we maybe do some more transformation, unify the data, and
63 00:06:44.240 ⇒ 00:06:49.449 Awaish Kumar: And then the final demarz layer. So, basically, the next piece is modeling that maybe we can start.
64 00:06:49.450 ⇒ 00:06:49.990 Katherine Bayless: Oh my god.
65 00:06:50.730 ⇒ 00:07:10.659 Kyle Wandel: I, you know, I actually ended up starting this morning, that’s why I was a few minutes late, because I was getting lost in the coding that. So if you want me… Catherine, if you don’t want me to take a look at that, I certainly can, or Sweeney, or not Sweeney, I wish, sorry, if you want to QA what I do, that… I think that might be also a good way. I’m just looking to look at it now, but I defer to you, Catherine.
66 00:07:11.040 ⇒ 00:07:26.610 Katherine Bayless: Yeah, no, I mean, you guys divide and conquer however you see fit. I think next week, Kyle, at least you and I should take a look at the, the ingestion pipeline for it, because I put it together, I just don’t have it set up to, like, run. And I think there was, like, one little…
67 00:07:26.650 ⇒ 00:07:35.400 Katherine Bayless: loose end I wanted to tidy up. I can’t remember off the top of my head, but yeah, if you and I look at it for, like, I don’t know, 20 minutes, we can probably get it running, and that way it’ll be regularly flowing in.
68 00:07:35.810 ⇒ 00:07:52.089 Kyle Wandel: Okay, that sounds good, and I think when looking at it very quickly, I believe that the only, like, raw files that are coming straight from Shopify are those customers, products, and orders tables, and I think the other two are generic reports, basically, is that my assumption? I mean, I think I did the research download one.
69 00:07:52.090 ⇒ 00:07:56.189 Kyle Wandel: And I wasn’t sure about the orders by product, I’m assuming that’s straight from Shopify.
70 00:07:57.000 ⇒ 00:07:57.839 Katherine Bayless: Oh, yeah.
71 00:07:57.840 ⇒ 00:08:03.919 Kyle Wandel: Okay. Did you want to use that as, like, a template for the fact table, or is that just, like, we just thought it might be cool to have in Shopify?
72 00:08:04.750 ⇒ 00:08:18.280 Katherine Bayless: I think, actually, I think I had dropped those in at one point, because we were like, well, it gives us something to put on the engagement dashboard for membership, but we weren’t gonna, like, necessarily use it long-term. The orders, customers, products.
73 00:08:18.280 ⇒ 00:08:30.770 Katherine Bayless: those three objects from Shopify will be what’ll be automated, but it’s an interesting idea to use the report for a, like, jumping-off point for the modeling. I mean, that makes a lot of sense, actually.
74 00:08:30.810 ⇒ 00:08:35.609 Katherine Bayless: I mean, because it’s what people are familiar with downloading, which is why I downloaded it. So, yeah.
75 00:08:35.720 ⇒ 00:08:53.680 Kyle Wandel: Yeah, I’ll… honestly, I will think about it. I… I don’t think… I don’t know who’s using it, quite frankly, because other than the research group… research people, like, the only person that I know that was actually downloading Shopify was me. Like, maybe, like, one or two other people, is at MRD, so, I’ll look…
76 00:08:53.920 ⇒ 00:08:59.800 Kyle Wandel: at the order, I’ll look at the reports, and then have any, like, generic, suggestions that I want to change to it.
77 00:09:00.710 ⇒ 00:09:19.369 Katherine Bayless: Okay, yeah, I think… actually, I’ve got an email somewhere in my inbox running around. Somebody was asking about Shopify stuff again. I think there’s probably, like, more people that want it, but, like, don’t have access to it necessarily, and it is such a small slice of our universe that it just gets deprioritized every time.
78 00:09:19.370 ⇒ 00:09:23.140 Katherine Bayless: But yeah, I think something flexible in Snowflake makes sense.
79 00:09:24.140 ⇒ 00:09:39.250 Kyle Wandel: Okay, cool. I’ll take very quickly a look at, like, all of the… like, Shopify has, like, a list of, like, whatever, queries or reports that they generate, and what use… what’s most used. I’ll take a look at that to see if there’s anything that sticks out, other than the one that I… that we typically do, so…
80 00:09:40.050 ⇒ 00:09:40.610 Katherine Bayless: Okay.
81 00:09:40.820 ⇒ 00:09:41.490 Awaish Kumar: Okay.
82 00:09:41.490 ⇒ 00:09:42.180 Katherine Bayless: Oh, cool.
83 00:09:44.920 ⇒ 00:09:45.650 Uttam Kumaran: Okay.
84 00:09:45.750 ⇒ 00:09:49.959 Uttam Kumaran: So I know today we wanted to try and get everybody set up on,
85 00:09:50.270 ⇒ 00:09:55.790 Uttam Kumaran: like, Snowflake, with the Streamlit, sort of deploy process.
86 00:09:56.080 ⇒ 00:10:01.659 Uttam Kumaran: What is, like, the easiest way to do this? Does everyone want to try and just, like.
87 00:10:01.930 ⇒ 00:10:04.559 Uttam Kumaran: whole stuff from Maine, and then…
88 00:10:05.280 ⇒ 00:10:09.009 Uttam Kumaran: Honestly, just try and ask your agent to…
89 00:10:09.410 ⇒ 00:10:13.940 Uttam Kumaran: To, deploy something, and kind of… we can just kind of work through issues,
90 00:10:14.190 ⇒ 00:10:15.839 Uttam Kumaran: What do we think is the best?
91 00:10:16.980 ⇒ 00:10:20.089 Katherine Bayless: It’s a good question.
92 00:10:20.590 ⇒ 00:10:39.980 Katherine Bayless: Probably… I mean, at least I know I probably have, like, a little bit of, like, baseline to set up. Like, I don’t think I’ve actually even installed the Snowflake CLI or anything yet, so maybe we could cover the basics, and make sure that each of us have the things we need in our local. I know…
93 00:10:40.700 ⇒ 00:10:44.520 Katherine Bayless: And so let me think, too, like, so Kyle and I have Mac.
94 00:10:44.780 ⇒ 00:10:49.839 Katherine Bayless: Clawed code. I… I think flawed code is kinda sorta set up.
95 00:10:50.000 ⇒ 00:10:52.429 Katherine Bayless: Did we ever get it across the finish line?
96 00:10:53.010 ⇒ 00:11:06.209 Chi Quinn: Yeah, no, I’m still… I was gonna work on that today, because as I mentioned, I don’t even have the app, or it’s not even opening, so I might have to, like, uninstall, reinstall, but yeah, I’ll work on that today.
97 00:11:06.650 ⇒ 00:11:07.540 Katherine Bayless: Yeah…
98 00:11:07.780 ⇒ 00:11:14.860 Katherine Bayless: it also might… I was thinking, too, maybe we could all do it in BS code, and that’s, like, sort of the one…
99 00:11:15.020 ⇒ 00:11:16.820 Katherine Bayless: unified environment.
100 00:11:18.080 ⇒ 00:11:22.390 Uttam Kumaran: Yeah, that would be helpful, because then I can also make sure that there are, like, relevant
101 00:11:22.590 ⇒ 00:11:25.719 Uttam Kumaran: VS Code config stuff in the repo.
102 00:11:25.720 ⇒ 00:11:26.420 Katherine Bayless: True.
103 00:11:26.420 ⇒ 00:11:31.200 Uttam Kumaran: So yeah, Kai, if you want to also install VS Code, I would love…
104 00:11:31.400 ⇒ 00:11:36.610 Uttam Kumaran: Yeah, just to make sure everyone has the repo pulled down, and then let’s just start with installing
105 00:11:36.800 ⇒ 00:11:41.930 Uttam Kumaran: the Snowflake CLI and confirming that you can connect, I think that’s a great place to start.
106 00:11:42.480 ⇒ 00:11:43.860 Katherine Bayless: Okay, cool, cool.
107 00:11:50.780 ⇒ 00:11:53.879 Uttam Kumaran: And just… Feel free to share screen as you get blocked.
108 00:11:54.290 ⇒ 00:11:55.010 Uttam Kumaran: Yeah.
109 00:13:05.370 ⇒ 00:13:11.949 Uttam Kumaran: It should… it’ll give you a little bit of trouble on credentials, so the easiest thing you can do is
110 00:13:12.160 ⇒ 00:13:19.190 Uttam Kumaran: If you’re working with Copilot, you can just basically ask it to set up your local environment.
111 00:13:19.410 ⇒ 00:13:22.739 Uttam Kumaran: Give you a place to put your credentials, and you can just copy and paste.
112 00:13:24.720 ⇒ 00:13:32.460 Uttam Kumaran: Actually, we’re not on Okta, we actually are on Okta, so actually, what it should do is just bring up the Okta screen for you to log in.
113 00:13:32.580 ⇒ 00:13:43.110 Uttam Kumaran: So, if it’s giving… if it’s asking you for a user password, mention your SSO through Okta, it will configure the connection in a way that it will leverage that, and it should just give you the…
114 00:13:43.410 ⇒ 00:13:49.900 Uttam Kumaran: login screen. What it’s gonna ask you for, though, is, like, all of the various… Snowflake account.
115 00:13:50.090 ⇒ 00:13:53.990 Uttam Kumaran: things, so that’s also, I think, good for everybody to know where to go get that, so…
116 00:13:54.130 ⇒ 00:13:57.780 Uttam Kumaran: If you get stuck there, let me know, and I can show you how to navigate to…
117 00:13:57.950 ⇒ 00:14:01.140 Uttam Kumaran: the account identifier, Things like that.
118 00:14:02.910 ⇒ 00:14:03.560 Katherine Bayless: Okay.
119 00:14:07.230 ⇒ 00:14:09.940 Katherine Bayless: And it is the Snow CLI that we’re.
120 00:14:09.940 ⇒ 00:14:10.400 Uttam Kumaran: Yes.
121 00:14:10.400 ⇒ 00:14:13.110 Katherine Bayless: Finally, not like SnowSQL or one of the others?
122 00:14:13.110 ⇒ 00:14:14.790 Uttam Kumaran: It’s the Snow CLI, yeah.
123 00:15:11.330 ⇒ 00:15:16.250 Chi Quinn: It says I have to be the admin, when I download something.
124 00:15:16.580 ⇒ 00:15:19.880 Chi Quinn: So I need, like, my email and this interesting password.
125 00:15:20.170 ⇒ 00:15:24.170 Kyle Wandel: Yeah, you’re not gonna be able to do it. Designer needs to do it for you.
126 00:15:24.730 ⇒ 00:15:25.290 Chi Quinn: Got it.
127 00:15:26.220 ⇒ 00:15:33.500 Katherine Bayless: We might be able to call an Audible. Is Ian online? Let me Slack him real quick.
128 00:15:37.190 ⇒ 00:15:39.230 Kyle Wandel: Yeah, the perks of a Mac so far.
129 00:15:43.090 ⇒ 00:15:43.830 Chi Quinn: Nice.
130 00:16:10.670 ⇒ 00:16:19.189 Katherine Bayless: Okay. I sent Ian a Slack message. He might be able to just, like, send you the local admin password real quick so that you could get it installed.
131 00:16:19.720 ⇒ 00:16:20.530 Chi Quinn: Okay.
132 00:16:21.740 ⇒ 00:16:24.790 Katherine Bayless: Like, all the more reason… Max or better.
133 00:16:25.660 ⇒ 00:16:28.220 Chi Quinn: I see, yeah.
134 00:17:02.730 ⇒ 00:17:05.840 Katherine Bayless: What should we say are primary databases?
135 00:17:06.460 ⇒ 00:17:08.040 Uttam Kumaran: Prod Mart.
136 00:17:15.750 ⇒ 00:17:18.329 Katherine Bayless: And… Eva.
137 00:17:19.480 ⇒ 00:17:23.010 Uttam Kumaran: You may… you don’t have to actually specify the schema, it’ll just pass through.
138 00:17:23.440 ⇒ 00:17:24.650 Katherine Bayless: Oh, okay, fair enough.
139 00:17:24.810 ⇒ 00:17:28.569 Uttam Kumaran: It’s not a… yeah, it should be a required field.
140 00:17:29.750 ⇒ 00:17:30.790 Katherine Bayless: Yeah, okay.
141 00:17:44.200 ⇒ 00:17:46.210 Katherine Bayless: And is this warehouse report?
142 00:17:47.080 ⇒ 00:17:47.770 Uttam Kumaran: Correct.
143 00:18:32.850 ⇒ 00:18:36.079 Katherine Bayless: Ian says he will share it with you via 1Password.
144 00:18:44.610 ⇒ 00:18:45.490 Chi Quinn: Sounds good.
145 00:20:59.260 ⇒ 00:21:03.220 Katherine Bayless: Okay, I think mine is… Connective…
146 00:21:03.410 ⇒ 00:21:06.880 Uttam Kumaran: Were you able to just run, like, a sample query and see something?
147 00:21:07.250 ⇒ 00:21:09.569 Katherine Bayless: Let me see…
148 00:21:11.390 ⇒ 00:21:15.210 Uttam Kumaran: And are you… are you using the straight terminal, or using the co-pilot to, like…
149 00:21:16.030 ⇒ 00:21:21.000 Katherine Bayless: I was using the, Claude code in the terminal. Cool.
150 00:21:21.000 ⇒ 00:21:21.370 Uttam Kumaran: Okay, okay.
151 00:21:21.370 ⇒ 00:21:30.580 Katherine Bayless: I realized, I don’t even have VS Code installed on this machine, which I’m surprised by. Part of me wonders if I deleted it at some point.
152 00:21:30.580 ⇒ 00:21:30.960 Uttam Kumaran: big.
153 00:21:30.960 ⇒ 00:21:32.720 Katherine Bayless: just feels odd. Yeah.
154 00:21:32.720 ⇒ 00:21:33.620 Uttam Kumaran: Yeah.
155 00:21:33.620 ⇒ 00:21:35.500 Katherine Bayless: So I was like, alright, fine, terminal.
156 00:21:35.690 ⇒ 00:21:46.099 Katherine Bayless: It got it all installed, and then it was, like, asking if I had a Streamlit app ready to deploy, and I was like, I don’t know, why don’t you go find out? But 3 minutes later, it’s still poking around, so…
157 00:21:46.100 ⇒ 00:21:46.700 Uttam Kumaran: Okay.
158 00:21:46.700 ⇒ 00:21:48.090 Katherine Bayless: I might.
159 00:21:48.360 ⇒ 00:21:55.730 Uttam Kumaran: Okay, make sure you have, like, your main pulled, and then… yeah, Kyle, where are you at? Are you able to connect to Blake?
160 00:21:56.060 ⇒ 00:22:13.610 Kyle Wandel: Yep, I just did a snowflake in the Cloud Code, VS… VS… whatever, Cloud Code VS, CLI, so that’s good, looking now at the raw data of Shopify and doing that fun thing. So we can use me as, like, an example if we… if we need to, but… Okay.
161 00:22:13.610 ⇒ 00:22:16.490 Uttam Kumaran: Go ahead and ask, your…
162 00:22:17.080 ⇒ 00:22:20.930 Uttam Kumaran: AI, if it’s aware of how to
163 00:22:21.110 ⇒ 00:22:23.810 Uttam Kumaran: How… are… are, like, develop…
164 00:22:23.990 ⇒ 00:22:30.560 Uttam Kumaran: test, deploy, loop, or streamlin. There are some documents in there, I want to know that it just has access and…
165 00:22:31.790 ⇒ 00:22:33.579 Uttam Kumaran: It’s… they can explain it to you.
166 00:22:33.580 ⇒ 00:22:41.909 Kyle Wandel: Yep, one moment, I’m going… it’s creating the Snowflake pipeline star schema right now, so I’ll run it in a second.
167 00:22:49.050 ⇒ 00:22:51.359 Kyle Wandel: Alright, so what am I asking it again?
168 00:22:51.990 ⇒ 00:22:57.229 Uttam Kumaran: Just say, like, are you aware of how we test and deploy Streamlit apps?
169 00:23:01.000 ⇒ 00:23:03.370 Uttam Kumaran: And there is some…
170 00:23:05.130 ⇒ 00:23:06.020 Kyle Wandel: Oh, okay.
171 00:23:12.350 ⇒ 00:23:17.490 Uttam Kumaran: Yeah, it should find some stuff in there, in the CTA DataOps repo.
172 00:23:25.250 ⇒ 00:23:26.199 Kyle Wandel: Yes, I’m trying to hit you.
173 00:23:26.200 ⇒ 00:23:27.880 Uttam Kumaran: Yeah, I would hit yes.
174 00:23:27.880 ⇒ 00:23:29.440 Kyle Wandel: No, it’s fine.
175 00:23:29.840 ⇒ 00:23:34.479 Uttam Kumaran: I was like, yes, it’s… don’t hesitate.
176 00:23:56.850 ⇒ 00:24:00.369 Kyle Wandel: It says it’s no stream, like, currently set up in the repository.
177 00:24:00.370 ⇒ 00:24:04.980 Uttam Kumaran: Can you pull from… can you just have it pull… the latest code from main.
178 00:24:41.910 ⇒ 00:24:45.820 Kyle Wandel: I think I’m on a rebase, right? Because I am working on something now? Yes. Yep.
179 00:24:45.820 ⇒ 00:24:51.320 Uttam Kumaran: Yeah, or you can, yeah, you can just have it… if you’re working on something, you can just say, create another branch for the other work.
180 00:24:51.790 ⇒ 00:24:52.949 Uttam Kumaran: It shouldn’t… it’s not…
181 00:24:52.950 ⇒ 00:24:53.460 Kyle Wandel: shouldn’t.
182 00:24:53.970 ⇒ 00:24:55.300 Uttam Kumaran: Okay, it shouldn’t…
183 00:24:55.570 ⇒ 00:24:59.970 Kyle Wandel: It may not have actually started, I think it’s still in the planning process. Maybe not.
184 00:24:59.970 ⇒ 00:25:01.919 Uttam Kumaran: Conflict with… with that?
185 00:25:02.110 ⇒ 00:25:03.160 Uttam Kumaran: So…
186 00:25:21.530 ⇒ 00:25:24.450 Kyle Wandel: Okay, so now I need to try again, right?
187 00:25:26.140 ⇒ 00:25:28.210 Kyle Wandel: Or no, I need to…
188 00:25:44.030 ⇒ 00:25:46.710 Kyle Wandel: Okay, now, ask it…
189 00:26:07.010 ⇒ 00:26:08.260 Kyle Wandel: So now I found it.
190 00:26:11.390 ⇒ 00:26:12.330 Uttam Kumaran: Nice.
191 00:26:14.310 ⇒ 00:26:18.769 Kyle Wandel: So now knows how to also build Streamlit apps, basically, on the way we want them to.
192 00:26:25.760 ⇒ 00:26:29.280 Uttam Kumaran: Okay. I mean, you wanna give it a shot? Like…
193 00:26:30.040 ⇒ 00:26:34.570 Uttam Kumaran: could tell it, there is a Streamlit app for the Cortex work.
194 00:26:34.910 ⇒ 00:26:37.920 Uttam Kumaran: Can ask it to…
195 00:26:41.500 ⇒ 00:26:47.170 Uttam Kumaran: Yeah, you can ask it to see if he can find that, and maybe push a change. Push, like, a description change.
196 00:26:48.380 ⇒ 00:26:49.270 Kyle Wandel: This one, right?
197 00:26:49.600 ⇒ 00:26:51.850 Kyle Wandel: Yeah. Just so I know. Yeah, yeah, okay.
198 00:28:37.940 ⇒ 00:28:42.600 Kyle Wandel: Just adding in the rate… Seems good to me.
199 00:28:49.740 ⇒ 00:28:52.899 Kyle Wandel: The one thing that helps having ultra-wide is I can just do this.
200 00:28:53.500 ⇒ 00:28:54.739 Uttam Kumaran: Yeah, same.
201 00:28:57.410 ⇒ 00:28:58.370 Katherine Bayless: Damn.
202 00:28:58.770 ⇒ 00:28:59.500 Katherine Bayless: Among the spread.
203 00:28:59.840 ⇒ 00:29:01.799 Katherine Bayless: with my single screen right now.
204 00:29:01.800 ⇒ 00:29:10.420 Kyle Wandel: Yeah, it’s… it’s hard, when you do… when you have, like, 4 different, like, things open. You can move this out, but then you have to tab, basically, which is annoying.
205 00:29:10.420 ⇒ 00:29:12.020 Katherine Bayless: Yeah. Yeah.
206 00:29:16.430 ⇒ 00:29:23.199 Kyle Wandel: Okay, and so now, if I want to see if it worked on here, I would basically just hit refresh, right?
207 00:29:25.910 ⇒ 00:29:26.680 Kyle Wandel: I’m assuming? Yes.
208 00:29:26.840 ⇒ 00:29:31.269 Uttam Kumaran: Yes, you can just hit refresh, and then you should see the change.
209 00:29:34.100 ⇒ 00:29:38.739 Kyle Wandel: Depending upon where it put it. I guess I should probably ask that.
210 00:29:39.280 ⇒ 00:29:42.280 Uttam Kumaran: Added the fourth column error rate 7 days.
211 00:29:43.530 ⇒ 00:29:44.180 Kyle Wandel: Yeah.
212 00:29:46.290 ⇒ 00:29:52.320 Kyle Wandel: But then, it may not… show up on he… oh, wait, no.
213 00:29:52.320 ⇒ 00:29:54.360 Awaish Kumar: But did we deploy?
214 00:29:57.380 ⇒ 00:29:59.760 Kyle Wandel: Neo… good question.
215 00:30:00.580 ⇒ 00:30:02.510 Awaish Kumar: It made a change, but it leads to.
216 00:30:02.510 ⇒ 00:30:04.159 Kyle Wandel: Yeah, deployed, you’re right.
217 00:30:05.100 ⇒ 00:30:06.030 Kyle Wandel: Good call.
218 00:30:38.450 ⇒ 00:30:44.990 Kyle Wandel: Is it better to use the virtual environment, or to have it installed on your… Computer.
219 00:30:45.450 ⇒ 00:30:47.570 Awaish Kumar: Yeah, it’s better to use virtual environment.
220 00:30:48.640 ⇒ 00:30:49.220 Uttam Kumaran: Yeah.
221 00:31:03.620 ⇒ 00:31:05.330 Kyle Wandel: Okay, it’s not on that one either.
222 00:31:15.370 ⇒ 00:31:17.070 Kyle Wandel: I think now it’s looking for it.
223 00:31:44.420 ⇒ 00:31:48.750 Kyle Wandel: Basically, right now, I was looking to see if I have snow installed, and then I don’t… since I don’t have it installed.
224 00:31:51.890 ⇒ 00:31:53.460 Kyle Wandel: So I need to install it.
225 00:31:58.020 ⇒ 00:31:58.800 Uttam Kumaran: Yes.
226 00:32:00.510 ⇒ 00:32:05.019 Uttam Kumaran: So, basically, a virtual environment, long story short, is, like, just a box.
227 00:32:05.370 ⇒ 00:32:06.470 Kyle Wandel: That’s, like… Yeah.
228 00:32:06.680 ⇒ 00:32:11.979 Uttam Kumaran: Yeah, like a virtual box in your computer, and so it should have you do this, but this is actually good.
229 00:32:12.090 ⇒ 00:32:18.049 Uttam Kumaran: I think one thing, Kyle, once we’re done with this, one thing I always like to do is, like, once it works, say, like, hey.
230 00:32:18.390 ⇒ 00:32:23.929 Uttam Kumaran: We hit some roadblocks, please summer… please summer, please add this to our documentation for future users.
231 00:32:24.350 ⇒ 00:32:25.520 Kyle Wandel: That’s a good idea.
232 00:32:25.800 ⇒ 00:32:31.890 Uttam Kumaran: I, like, I try to remember to do that every time, because sometimes you hit, like, a point where it works, and you’re like, cool.
233 00:32:32.050 ⇒ 00:32:33.159 Uttam Kumaran: See ya, and I’m like.
234 00:32:33.160 ⇒ 00:32:33.920 Kyle Wandel: Yeah.
235 00:32:33.920 ⇒ 00:32:35.859 Uttam Kumaran: Think about the people ahead of me.
236 00:32:39.010 ⇒ 00:32:40.249 Katherine Bayless: Okay, I got one.
237 00:32:41.340 ⇒ 00:32:42.160 Uttam Kumaran: Okay.
238 00:32:42.740 ⇒ 00:32:44.080 Uttam Kumaran: With the deploy step?
239 00:32:45.000 ⇒ 00:32:50.440 Katherine Bayless: Well, I mean, I, I, I got a thing.
240 00:32:54.770 ⇒ 00:32:56.050 Kyle Wandel: Here, share screen.
241 00:32:56.510 ⇒ 00:32:58.610 Uttam Kumaran: Oh, nice! Alright, that’s it.
242 00:32:58.740 ⇒ 00:33:00.100 Uttam Kumaran: Yeah, perfect.
243 00:33:01.530 ⇒ 00:33:02.070 Uttam Kumaran: Okay.
244 00:33:02.070 ⇒ 00:33:20.149 Katherine Bayless: So all I did was basically ask it to push it up, and so it asked, like, where in the repo I wanted to keep the Streamlit script, and I was like, I don’t know, follow the docs, and then where to push it up, and sort of same thing, like, so it’ll go to the devmarts.kbalis reports.
245 00:33:20.290 ⇒ 00:33:23.179 Katherine Bayless: That was what it found in the repo, is that…
246 00:33:23.650 ⇒ 00:33:25.159 Katherine Bayless: What we’re expecting it to do.
247 00:33:25.330 ⇒ 00:33:26.010 Uttam Kumaran: Yes.
248 00:33:26.360 ⇒ 00:33:27.190 Katherine Bayless: Okay, cool.
249 00:33:27.680 ⇒ 00:33:28.530 Uttam Kumaran: Exactly.
250 00:33:28.960 ⇒ 00:33:32.129 Uttam Kumaran: So, now, I think, Catherine, if you can try the edit flow?
251 00:33:32.660 ⇒ 00:33:33.629 Katherine Bayless: Yeah, yeah, yeah, got it.
252 00:33:33.630 ⇒ 00:33:35.339 Uttam Kumaran: Edit and re-push flow? Yeah.
253 00:34:48.590 ⇒ 00:34:55.229 Katherine Bayless: That’s cool, so did you get it to do the diff as part of the, like, edit flow and repush? Yeah, nice, nice.
254 00:34:55.570 ⇒ 00:34:56.969 Uttam Kumaran: Nice.
255 00:34:58.180 ⇒ 00:35:03.959 Uttam Kumaran: Yes, I was… this was… it was like this meeting, except I was alone, and there was no meeting.
256 00:35:04.200 ⇒ 00:35:10.160 Uttam Kumaran: And I was like, this is not working at all. But, yes.
257 00:35:10.500 ⇒ 00:35:19.780 Katherine Bayless: Kai and I fumbled around for, like, 40 minutes the other day, and I mean, I think some of it was the PC limitations, but we were just like, this is gonna be so painful!
258 00:35:19.780 ⇒ 00:35:28.149 Uttam Kumaran: No, because, yeah, it’ll encourage you to test locally, but the Snowflake stream environment is not something you can replicate easily.
259 00:35:28.430 ⇒ 00:35:33.230 Uttam Kumaran: But then I, like, know the… I know the primitives that, like, you can do…
260 00:35:33.930 ⇒ 00:35:38.900 Uttam Kumaran: like, external connections and things like that, and I saw the deploy function, and I’m like.
261 00:35:39.010 ⇒ 00:35:42.979 Uttam Kumaran: There’s gotta be a way for us to do this.
262 00:35:42.980 ⇒ 00:35:43.529 Katherine Bayless: Yeah, I like those.
263 00:35:43.530 ⇒ 00:35:43.880 Uttam Kumaran: No way.
264 00:35:43.880 ⇒ 00:35:46.140 Katherine Bayless: This is how everybody’s doing it in the wild.
265 00:35:46.510 ⇒ 00:35:47.240 Uttam Kumaran: Yeah.
266 00:35:48.170 ⇒ 00:35:49.399 Katherine Bayless: So… Is that a good movie.
267 00:35:50.330 ⇒ 00:35:51.659 Katherine Bayless: That’s really cool.
268 00:35:52.130 ⇒ 00:35:57.980 Katherine Bayless: I’m actually… Probably a little too excited about this.
269 00:35:57.980 ⇒ 00:36:16.360 Uttam Kumaran: Well, I just hope that, like, now the whole team can focus on shipping Streamlit apps, not on, like, the mechanics. I think, like, what I want to figure out more, and I want to think about it more of, like, a platform, which is, like, what are things available to ship within Streamlit dashboards or things like that, but I feel like…
270 00:36:17.120 ⇒ 00:36:24.419 Uttam Kumaran: Should be able to do the basics now pretty seamlessly. I don’t know, Kyle, if your stuff got resolved on your end?
271 00:36:28.120 ⇒ 00:36:43.370 Kyle Wandel: It’s, this whole entire, like, Snowpipe involving… I don’t know if my machine’s screwed up, because I’ve done so many things, but, like, installing Python and Snowpipe has, like, really, like, screwed up my machine. It’s like, I have, like, 4 different versions of Python, it feels like, and, like, 3 different versions of Snowpipe.
272 00:36:43.370 ⇒ 00:36:44.269 Uttam Kumaran: It’ll happen.
273 00:36:44.680 ⇒ 00:36:45.070 Kyle Wandel: Yeah.
274 00:36:45.070 ⇒ 00:36:53.500 Katherine Bayless: Yeah, I want to, like, do, like, a pause for appreciation moment. Welcome to being a data engineer. Yes, yes. Like, honestly, this is a…
275 00:36:53.500 ⇒ 00:36:57.299 Uttam Kumaran: Imagine, imagine no cloud code, and you’re like.
276 00:36:57.450 ⇒ 00:36:58.319 Kyle Wandel: Doing it yourself.
277 00:36:59.230 ⇒ 00:37:02.039 Katherine Bayless: Dude, there were days where I was like, I’m gonna set my laptop on fire.
278 00:37:02.760 ⇒ 00:37:06.410 Uttam Kumaran: Well, I have, like, work… cause I have, like, work to do, and I’m like… I.
279 00:37:06.880 ⇒ 00:37:11.499 Uttam Kumaran: I don’t know, why… why do I have 3.1 versus 3.2, and like…
280 00:37:11.810 ⇒ 00:37:17.829 Uttam Kumaran: I was like, I can’t… and then I’m like, I deleted everything, and then… and then that messes something else up, I’m like.
281 00:37:18.910 ⇒ 00:37:24.300 Uttam Kumaran: I… well, just… I’m just… then I’m just gonna use Google Colab.
282 00:37:24.690 ⇒ 00:37:26.479 Uttam Kumaran: Just how these guys handle it.
283 00:37:26.760 ⇒ 00:37:34.220 Kyle Wandel: Using the terminal has been by far my biggest, reason as to not get into engineering, so, like, the cloud code is, like, damaging.
284 00:37:34.900 ⇒ 00:37:35.480 Katherine Bayless: Right.
285 00:37:36.050 ⇒ 00:37:53.330 Katherine Bayless: And actually, honestly, probably where I messed up and deleted VS Code somewhere along the way was… I did actually, last week, use blog code to do exactly that, right? I was like, I know this machine’s a mess. I just, like, started using it, like, in the panicked lead-up to CES. There’s probably shit all over the place.
286 00:37:53.330 ⇒ 00:38:01.459 Katherine Bayless: And so I did have it go through and, like, clean up all my libraries, reinstall things in the right place, put things on paths, set the environment variables, so, like…
287 00:38:01.800 ⇒ 00:38:06.600 Katherine Bayless: It’s much easier now. That was an afternoon instead of a set laptop on fire situation.
288 00:38:11.740 ⇒ 00:38:14.100 Katherine Bayless: Kai, did Ian get you the password?
289 00:38:14.320 ⇒ 00:38:19.110 Chi Quinn: Yep, I got it, I’m able to download it now, so I’m… yeah, I’m catching up.
290 00:38:19.270 ⇒ 00:38:22.110 Chi Quinn: Just keep going, I’m catching up.
291 00:40:11.850 ⇒ 00:40:20.090 Chi Quinn: So, for the terminal window, execute, supply… enter a connection name?
292 00:40:22.460 ⇒ 00:40:28.060 Katherine Bayless: Okay, so you’re probably at the step where you’re setting up the, like, the account identifiers and stuff?
293 00:40:28.060 ⇒ 00:40:30.209 Chi Quinn: Yeah, yeah, yeah, yeah.
294 00:40:30.210 ⇒ 00:40:33.769 Katherine Bayless: If you want to share your screen, we can talk through it.
295 00:40:33.770 ⇒ 00:40:35.680 Chi Quinn: Yeah, let’s do it.
296 00:40:35.680 ⇒ 00:40:38.229 Katherine Bayless: Turned out to be easier than I thought.
297 00:40:38.230 ⇒ 00:40:40.259 Chi Quinn: Ha ha ha ha. Alright.
298 00:40:47.720 ⇒ 00:40:51.590 Chi Quinn: I mean, I’m just on the terminal right now, but…
299 00:40:55.190 ⇒ 00:41:00.840 Chi Quinn: I have a very big screen, so that’s why I have it compact to just this, because otherwise it’s going to look very tiny.
300 00:41:05.980 ⇒ 00:41:06.960 Katherine Bayless: Begin.
301 00:41:13.670 ⇒ 00:41:20.810 Chi Quinn: Let me see, so it’s… So it… once it was completed… oh, sorry, go ahead.
302 00:41:20.810 ⇒ 00:41:23.570 Uttam Kumaran: I think you can just… Say anything in here.
303 00:41:23.570 ⇒ 00:41:26.299 Chi Quinn: Pretty much, like, is it just… it’s optional?
304 00:41:26.810 ⇒ 00:41:28.929 Uttam Kumaran: Yeah, I think you could just say CTA.
305 00:41:29.280 ⇒ 00:41:30.809 Uttam Kumaran: Let’s do it and see if it does.
306 00:41:31.850 ⇒ 00:41:32.650 Chi Quinn: Oh.
307 00:41:32.650 ⇒ 00:41:43.690 Uttam Kumaran: Here’s where you’re gonna have to enter some of the Snowflake account details. So if you log into Snowflake, and you look kind of in the bottom left, near your user profile, you’ll see some of these, yeah.
308 00:41:44.010 ⇒ 00:41:44.600 Chi Quinn: Yep.
309 00:41:44.850 ⇒ 00:41:46.010 Chi Quinn: Got it.
310 00:41:56.830 ⇒ 00:41:59.420 Chi Quinn: Okay, yeah, so, like, on the…
311 00:42:00.080 ⇒ 00:42:03.030 Chi Quinn: Bottom, what’s my name, role developer.
312 00:42:04.720 ⇒ 00:42:08.860 Chi Quinn: Oh, okay, I see a count. I see a count. The TJ, okay, yep.
313 00:42:08.860 ⇒ 00:42:09.590 Uttam Kumaran: Yes.
314 00:42:17.980 ⇒ 00:42:23.990 Chi Quinn: I don’t know if it’s, like… I mean, it has my name, is there any special way of putting it? Or just… it could just be, like.
315 00:42:24.190 ⇒ 00:42:25.860 Uttam Kumaran: You have to put your username.
316 00:42:26.280 ⇒ 00:42:29.420 Uttam Kumaran: So whatever your… I think it should be just your email.
317 00:42:30.520 ⇒ 00:42:32.229 Uttam Kumaran: Your Snowflake username, yeah.
318 00:42:33.070 ⇒ 00:42:34.320 Chi Quinn: Yep, I see it, okay.
319 00:42:45.380 ⇒ 00:42:48.700 Chi Quinn: I don’t even know my password. I just use the single sign-on.
320 00:42:49.160 ⇒ 00:42:52.759 Uttam Kumaran: I don’t… I… yeah, I don’t know, Catherine, did we… can we just put enter here?
321 00:42:52.920 ⇒ 00:42:55.849 Chi Quinn: Yeah, let me see… Oh. You’re on mute.
322 00:42:55.850 ⇒ 00:42:57.679 Uttam Kumaran: You’re on… you’re on mute, Catherine.
323 00:42:58.440 ⇒ 00:43:11.589 Katherine Bayless: I was trying to just downplay the cafe noise. Yeah, mine did do the external browser for the authentication, so it just, like, popped me up to log in through Okta.
324 00:43:12.600 ⇒ 00:43:14.720 Katherine Bayless: Wondering if yours will do the same?
325 00:43:15.280 ⇒ 00:43:18.399 Chi Quinn: I just pressed enter, and I… That’s fine.
326 00:43:18.400 ⇒ 00:43:19.370 Katherine Bayless: Yeah.
327 00:43:19.370 ⇒ 00:43:19.770 Chi Quinn: Okay.
328 00:43:19.770 ⇒ 00:43:23.319 Uttam Kumaran: Yeah, so now do your role, yeah. Do your role developer.
329 00:43:23.550 ⇒ 00:43:24.430 Chi Quinn: Yeah.
330 00:43:26.910 ⇒ 00:43:28.920 Chi Quinn: warehouse, that’s Pradmarks.
331 00:43:29.430 ⇒ 00:43:34.090 Awaish Kumar: No, it’s, yeah, I’m support guiding.
332 00:43:34.560 ⇒ 00:43:36.950 Uttam Kumaran: Yeah, warehouse report. Warehouse underscore report.
333 00:43:37.170 ⇒ 00:43:38.010 Chi Quinn: Okay.
334 00:43:43.110 ⇒ 00:43:43.920 Chi Quinn: And now, huh.
335 00:43:43.920 ⇒ 00:43:45.089 Awaish Kumar: This is Broadbox.
336 00:43:45.090 ⇒ 00:43:46.339 Chi Quinn: That’s very exciting.
337 00:43:48.900 ⇒ 00:43:53.969 Chi Quinn: Schema… doesn’t have to be anything specific at the moment.
338 00:43:53.970 ⇒ 00:43:55.639 Uttam Kumaran: You can just hit enter, yeah.
339 00:43:56.040 ⇒ 00:43:56.939 Chi Quinn: Oh, okay.
340 00:43:57.840 ⇒ 00:43:58.340 Uttam Kumaran: Damn.
341 00:43:58.910 ⇒ 00:43:59.650 Uttam Kumaran: boost.
342 00:44:00.780 ⇒ 00:44:02.170 Chi Quinn: this host.
343 00:44:02.170 ⇒ 00:44:03.790 Uttam Kumaran: Katherine, did you put anything here?
344 00:44:05.570 ⇒ 00:44:06.830 Uttam Kumaran: For host?
345 00:44:07.010 ⇒ 00:44:10.390 Katherine Bayless: No. I definitely did not.
346 00:44:10.390 ⇒ 00:44:14.560 Uttam Kumaran: Okay, it may give you a couple more that are like, yeah, you could just enter these, sorry, now I remember.
347 00:44:15.050 ⇒ 00:44:17.860 Uttam Kumaran: Yeah, you can just… And then Authenticator…
348 00:44:18.070 ⇒ 00:44:20.640 Uttam Kumaran: Authenticity, you may need to put something?
349 00:44:20.940 ⇒ 00:44:21.510 Katherine Bayless: Oh, no.
350 00:44:21.920 ⇒ 00:44:24.079 Katherine Bayless: One where you can put external browser.
351 00:44:24.080 ⇒ 00:44:26.120 Uttam Kumaran: Okay, just try to hit enter, see what it says.
352 00:44:29.440 ⇒ 00:44:36.529 Uttam Kumaran: You may have to do it one more time, and then do Authenticator as, like, I think it’s external-browser.
353 00:44:37.300 ⇒ 00:44:38.150 Chi Quinn: Okay.
354 00:44:49.220 ⇒ 00:44:56.280 Uttam Kumaran: Yeah, so try… try the same thing one more time, and then… under Authenticator.
355 00:44:56.440 ⇒ 00:44:58.629 Uttam Kumaran: I think, oh wait, is it external-browser?
356 00:44:58.630 ⇒ 00:44:59.280 Katherine Bayless: We’ve got it.
357 00:45:00.860 ⇒ 00:45:02.480 Katherine Bayless: I think it’s all one word.
358 00:45:02.480 ⇒ 00:45:03.260 Uttam Kumaran: Oh, okay.
359 00:45:11.360 ⇒ 00:45:13.139 Katherine Bayless: It’s kind of regular bundle.
360 00:45:20.300 ⇒ 00:45:21.250 Katherine Bayless: Okay.
361 00:45:21.590 ⇒ 00:45:30.770 Katherine Bayless: I’m gonna hop for my call with Christina, but on Slack if you need me, and totally gonna be causing trouble with Streamlit apps later.
362 00:45:32.270 ⇒ 00:45:33.559 Uttam Kumaran: Thank you. Bye.
363 00:45:41.520 ⇒ 00:45:43.550 Chi Quinn: Authenticator…
364 00:45:43.550 ⇒ 00:45:44.250 Uttam Kumaran: Yes.
365 00:45:45.160 ⇒ 00:45:48.190 Chi Quinn: And it’s External Browser.
366 00:45:49.170 ⇒ 00:45:52.020 Chi Quinn: Just external browser altogether, or…
367 00:45:52.020 ⇒ 00:45:52.490 Uttam Kumaran: Yes.
368 00:45:56.870 ⇒ 00:45:59.759 Chi Quinn: Workload identity provider.
369 00:45:59.980 ⇒ 00:46:02.730 Uttam Kumaran: You don’t have to do any… I don’t think you have to do anything for the rest.
370 00:46:02.730 ⇒ 00:46:03.660 Chi Quinn: Okay.
371 00:46:04.630 ⇒ 00:46:07.269 Chi Quinn: Connection… well, it says connection already exists, so…
372 00:46:08.720 ⇒ 00:46:11.230 Awaish Kumar: Yeah, because we had the same name for the previous one.
373 00:46:11.860 ⇒ 00:46:12.610 Chi Quinn: Got it.
374 00:46:16.970 ⇒ 00:46:19.439 Awaish Kumar: We can also directly edit the file if you want.
375 00:46:21.360 ⇒ 00:46:23.180 Chi Quinn: Oh, sorry? Sorry, say that again?
376 00:46:23.490 ⇒ 00:46:30.679 Awaish Kumar: So the connection detail we are adding, it goes into this config.tuml file.
377 00:46:31.200 ⇒ 00:46:34.649 Awaish Kumar: You can directly go in and edit if you want, instead of.
378 00:46:34.650 ⇒ 00:46:35.560 Chi Quinn: Owing.
379 00:46:35.850 ⇒ 00:46:36.620 Chi Quinn: Oh.
380 00:46:44.890 ⇒ 00:46:51.850 Chi Quinn: Sorry, it’s… I can’t even see what the blue… oh, connection at… okay.
381 00:46:52.350 ⇒ 00:46:55.960 Chi Quinn: So, from here… You said I could go to a file?
382 00:46:55.960 ⇒ 00:47:00.560 Awaish Kumar: I’m saying that there is a path for the config file.
383 00:47:00.740 ⇒ 00:47:06.899 Awaish Kumar: See, users, username, and the app data, just at the top.
384 00:47:09.500 ⇒ 00:47:10.980 Awaish Kumar: Yeah, yeah, this…
385 00:47:10.980 ⇒ 00:47:11.930 Chi Quinn: Okay, this one.
386 00:47:12.050 ⇒ 00:47:14.370 Awaish Kumar: This is the file where it is writing.
387 00:47:15.370 ⇒ 00:47:19.799 Chi Quinn: Oh, okay, so should I go to that particular location, or…
388 00:47:20.090 ⇒ 00:47:26.039 Awaish Kumar: Yeah, if you prefer to not to go with CLA, you can go in and directly edit the file as well.
389 00:47:26.340 ⇒ 00:47:29.470 Chi Quinn: Oh, edit the file there, okay, okay, okay, I think I got you.
390 00:47:46.000 ⇒ 00:47:52.960 Kyle Wandel: Tom, can you check the Cortex adoption streamlet? I may have broken it, but I don’t know if I did or not.
391 00:47:52.960 ⇒ 00:47:53.810 Uttam Kumaran: Okay.
392 00:47:55.900 ⇒ 00:48:01.500 Kyle Wandel: I think it has something to do with the fact that, like, I was… the… the packages were not updated or something, so take a look.
393 00:48:01.640 ⇒ 00:48:04.299 Kyle Wandel: Or if I’m just using the wrong warehouse.
394 00:48:18.320 ⇒ 00:48:19.909 Uttam Kumaran: Let me check…
395 00:48:34.850 ⇒ 00:48:36.669 Uttam Kumaran: Where am I? Okay.
396 00:48:46.320 ⇒ 00:48:50.669 Kyle Wandel: Because it added the new metric that I wanted to, but then nothing else is working, at least on my end now.
397 00:48:55.050 ⇒ 00:48:59.930 Uttam Kumaran: I’m just logging in… Is it giving you an error?
398 00:49:00.910 ⇒ 00:49:04.890 Kyle Wandel: It looks like…
399 00:49:09.990 ⇒ 00:49:10.700 Uttam Kumaran: Okay.
400 00:49:10.840 ⇒ 00:49:17.940 Uttam Kumaran: I mean… I guess… Oh, you mean the metrics are off? Okay, okay, cool.
401 00:49:18.300 ⇒ 00:49:26.910 Kyle Wandel: Oh yeah, like, it, like, seems like it… it removed some metrics as well, some graphs, some of it’s… the query’s not working.
402 00:49:27.280 ⇒ 00:49:40.680 Kyle Wandel: I don’t know if this is on your end or just my end, and I think what happened, what it said had happened, is that I was using the wrong pa- or the packages weren’t updated, and some of the things weren’t working, I think is what happened.
403 00:49:40.680 ⇒ 00:49:41.250 Uttam Kumaran: Okay.
404 00:49:41.480 ⇒ 00:49:43.849 Uttam Kumaran: So… So, one thing is…
405 00:49:43.960 ⇒ 00:49:56.510 Uttam Kumaran: Yeah, I can… so one thing… one thing I would… let’s… let’s see if we can actually get through this. Like, I think one thing I would suggest is… what was the error? So, it shouldn’t… you can mention to it that it shouldn’t actually…
406 00:49:57.190 ⇒ 00:50:02.839 Uttam Kumaran: run Streamlit, like, on your machine. It’s purely, like.
407 00:50:03.210 ⇒ 00:50:15.519 Uttam Kumaran: sending it to the Streamlit, and then looking if there was any errors. So yes, you’re right, I think there was a change, and now there’s, like, some… well, actually, it removed, like, a lot of stuff, so I wonder if it’s either looking at an old version, or…
408 00:50:16.440 ⇒ 00:50:25.859 Uttam Kumaran: I’m not sure, but ask it, just ask it to highlight what it did. Let’s see. I can re… I can revert, that’s… that’s… I’m not worried about that, but I want to see if we can debug a little bit.
409 00:50:26.340 ⇒ 00:50:27.180 Kyle Wandel: Okay.
410 00:50:27.460 ⇒ 00:50:31.210 Kyle Wandel: And I was working through, like, what did it…
411 00:50:31.610 ⇒ 00:50:38.739 Kyle Wandel: do a little bit, but I can ask it specifically, so as I was able to decide, are you… were you able to revert back?
412 00:50:53.070 ⇒ 00:50:55.250 Uttam Kumaran: DB Seal’s still working, okay.
413 00:50:56.210 ⇒ 00:51:00.459 Uttam Kumaran: dbt commands, I don’t know what changed… let me know, select file.
414 00:51:02.350 ⇒ 00:51:09.160 Uttam Kumaran: Yeah, I think one thing you can do is just have it deploy the app… well, yeah, this is… okay, so…
415 00:51:10.210 ⇒ 00:51:12.459 Kyle Wandel: These are the apps that changed, basically.
416 00:51:12.600 ⇒ 00:51:15.260 Kyle Wandel: Or the… the packages that it…
417 00:51:15.260 ⇒ 00:51:19.290 Uttam Kumaran: Well, looking at the dashboard, this is how it was, basically, like, yesterday morning.
418 00:51:19.660 ⇒ 00:51:31.160 Uttam Kumaran: Or, like, early on it, so I wonder if it just, like, used, like, an old version? It might have. Can you just… can you just ask it, like, summarize what the changes were? And just tell it, just say, like, hey, the…
419 00:51:31.310 ⇒ 00:51:37.120 Uttam Kumaran: You actually deployed what looks like an old version of the dashboard. Can you tell me what changed?
420 00:53:12.530 ⇒ 00:53:17.550 Kyle Wandel: Yeah, the last time it saw you make a change was 2 days ago, so it definitely was not fully.
421 00:53:17.550 ⇒ 00:53:18.070 Uttam Kumaran: Okay.
422 00:53:18.280 ⇒ 00:53:19.450 Kyle Wandel: Okay, so that’s.
423 00:53:19.450 ⇒ 00:53:19.900 Uttam Kumaran: Yes.
424 00:53:20.630 ⇒ 00:53:25.460 Uttam Kumaran: Have it… have it pull from the latest… yeah, can you just tell it, like, make sure you have the latest?
425 00:53:27.020 ⇒ 00:53:28.320 Uttam Kumaran: Version of Maine.
426 00:53:43.630 ⇒ 00:53:45.279 Kyle Wandel: I want a stash.
427 00:53:47.660 ⇒ 00:53:52.929 Kyle Wandel: No, I don’t want to keep them. Don’t keep them.
428 00:54:49.070 ⇒ 00:54:51.949 Kyle Wandel: Still says… last time.
429 00:54:53.440 ⇒ 00:54:54.250 Kyle Wandel: We’re still sism.
430 00:54:54.250 ⇒ 00:54:57.240 Uttam Kumaran: Okay.
431 00:54:58.310 ⇒ 00:55:04.399 Uttam Kumaran: And it pulled from… I don’t know. Can you.
432 00:55:05.800 ⇒ 00:55:10.770 Kyle Wandel: So, did branch fetch head main… Already up to date.
433 00:55:14.120 ⇒ 00:55:18.470 Uttam Kumaran: I don’t know, Wish, what do you think? I’ve… I don’t know.
434 00:55:23.130 ⇒ 00:55:30.250 Uttam Kumaran: Can you, do you have, like… yeah, if you… do you have… you could go… if you have GitHub Desktop, it sometimes is a bit easier, but yeah, I’ve…
435 00:55:30.440 ⇒ 00:55:32.150 Uttam Kumaran: I pushed some stuff, like…
436 00:55:32.150 ⇒ 00:55:35.160 Awaish Kumar: Like, if you don’t have anything, you can just say git stash.
437 00:55:35.400 ⇒ 00:55:39.919 Awaish Kumar: And… Pull the main, and push it, just…
438 00:55:40.990 ⇒ 00:55:45.100 Kyle Wandel: It may not have pushed it, or it may not have committed, because it’s a 0 to 1.
439 00:55:45.670 ⇒ 00:55:47.850 Uttam Kumaran: No, that’s just, like, one of our,
440 00:55:48.080 ⇒ 00:55:51.650 Uttam Kumaran: CI fixes, so all of this is actually… it should be in.
441 00:55:53.060 ⇒ 00:55:57.929 Uttam Kumaran: I’m surprised that it’s not… Picking that up.
442 00:55:58.100 ⇒ 00:56:02.239 Uttam Kumaran: Can you go in… I guess,
443 00:56:02.450 ⇒ 00:56:09.010 Uttam Kumaran: Can you go back into VS Code, and can you ins… there should be, like, a source code extension, or, like, a…
444 00:56:09.910 ⇒ 00:56:13.740 Uttam Kumaran: Version control extension on, like, the side here. Is there anything that says version control?
445 00:56:14.190 ⇒ 00:56:15.939 Uttam Kumaran: Like, one of these guys?
446 00:56:17.320 ⇒ 00:56:19.050 Kyle Wandel: Oh.
447 00:56:20.530 ⇒ 00:56:21.779 Uttam Kumaran: Yeah, that one.
448 00:56:22.620 ⇒ 00:56:25.319 Uttam Kumaran: I don’t know what any of the buttons do.
449 00:56:28.040 ⇒ 00:56:29.940 Kyle Wandel: Well, this is just opening up the GitHub.
450 00:56:29.940 ⇒ 00:56:30.530 Uttam Kumaran: Okay.
451 00:56:31.170 ⇒ 00:56:33.889 Kyle Wandel: This is DBT…
452 00:56:34.360 ⇒ 00:56:40.630 Uttam Kumaran: Like, oh, see, this is… this is, this is gonna be… the bottom here is gonna be, like, your GitHub area, looks like.
453 00:56:40.750 ⇒ 00:56:42.040 Uttam Kumaran: Yeah, so…
454 00:56:44.000 ⇒ 00:56:47.809 Uttam Kumaran: I feel like you should be able to just click on this and, like, get the latest, yeah.
455 00:56:49.610 ⇒ 00:56:52.430 Uttam Kumaran: But that’s why I’m surprised that, like, none of this has showed up.
456 00:56:53.770 ⇒ 00:56:59.299 Kyle Wandel: Well, and I… I think it did… so where would it be if it was updated again?
457 00:57:02.480 ⇒ 00:57:03.709 Kyle Wandel: Is it in models?
458 00:57:03.710 ⇒ 00:57:04.920 Awaish Kumar: Okay, cool.
459 00:57:05.800 ⇒ 00:57:08.960 Uttam Kumaran: Yeah, and models, marts, Cortex, adoption.
460 00:57:09.160 ⇒ 00:57:10.760 Uttam Kumaran: Yeah, so it’s all there.
461 00:57:11.140 ⇒ 00:57:12.039 Kyle Wandel: Okay, so now it’s…
462 00:57:12.040 ⇒ 00:57:15.970 Uttam Kumaran: I don’t know… Yeah, so maybe try now?
463 00:57:22.240 ⇒ 00:57:25.279 Kyle Wandel: Didn’t start a new one? Yeah, it started a whole new one, too.
464 00:57:34.280 ⇒ 00:57:36.299 Kyle Wandel: But now it won’t let me do…
465 00:57:37.840 ⇒ 00:57:42.400 Kyle Wandel: this. What made me do Claude Code? So, maybe I screwed up.
466 00:57:52.890 ⇒ 00:57:54.220 Kyle Wandel: I clone…
467 00:58:20.640 ⇒ 00:58:24.369 Kyle Wandel: So if it’s not letting me access Cloud Code at all right now…
468 00:58:28.120 ⇒ 00:58:29.560 Kyle Wandel: System error.
469 00:58:33.550 ⇒ 00:58:38.130 Uttam Kumaran: Okay, this I’m not exactly sure. You may just have to hard reset, VS, and like.
470 00:58:38.130 ⇒ 00:58:38.680 Kyle Wandel: Definitely.
471 00:58:38.970 ⇒ 00:58:40.179 Uttam Kumaran: Try to reopen.
472 00:58:42.090 ⇒ 00:58:42.929 Kyle Wandel: I will stop.
473 00:58:42.930 ⇒ 00:58:47.760 Awaish Kumar: It is referring to the parent folder, CTA slash data.
474 00:58:52.280 ⇒ 00:59:01.790 Kyle Wandel: Okay, where is code… And maybe it’s because I have… I pulled it the local wrong to begin with?
475 00:59:04.980 ⇒ 00:59:09.760 Uttam Kumaran: Maybe… Think so? Not sure.
476 00:59:23.510 ⇒ 00:59:30.129 Kyle Wandel: So… I’d want to clone… the dbt project, right?
477 00:59:30.740 ⇒ 00:59:32.440 Kyle Wandel: If I’m starting from scratch.
478 00:59:35.520 ⇒ 00:59:37.749 Awaish Kumar: You have to.
479 00:59:38.470 ⇒ 00:59:40.620 Kyle Wandel: Yes, so I would do this…
480 00:59:41.300 ⇒ 00:59:44.169 Kyle Wandel: I come in here, I take clone git.
481 00:59:44.410 ⇒ 00:59:46.519 Kyle Wandel: put the URL, is that correct?
482 00:59:50.010 ⇒ 00:59:54.060 Uttam Kumaran: You don’t need dbt project, you could just do CTA DataOps.
483 00:59:55.230 ⇒ 00:59:55.629 Kyle Wandel: Oh my god.
484 00:59:55.630 ⇒ 00:59:56.650 Uttam Kumaran: tree, yeah.
485 00:59:57.350 ⇒ 01:00:01.460 Kyle Wandel: So I have… I’ve done that. I’d just like to open this repository, add a current space.
486 01:00:01.840 ⇒ 01:00:02.670 Kyle Wandel: Yep.
487 01:00:07.030 ⇒ 01:00:16.080 Kyle Wandel: Okay, so now I’m in… I should be, in the most recent… Maine.
488 01:00:16.320 ⇒ 01:00:18.860 Kyle Wandel: for a dbt project, from my understanding.
489 01:00:24.640 ⇒ 01:00:26.960 Kyle Wandel: And when I go to models, I don’t have…
490 01:00:26.960 ⇒ 01:00:27.680 Awaish Kumar: dogs.
491 01:00:28.170 ⇒ 01:00:30.240 Awaish Kumar: Oh, sorry.
492 01:00:32.120 ⇒ 01:00:35.070 Kyle Wandel: There it is, okay. Okay, so now I think I have everything.
493 01:00:39.610 ⇒ 01:00:41.160 Kyle Wandel: Okay…
494 01:00:45.200 ⇒ 01:00:47.900 Kyle Wandel: Check in… bye.
495 01:01:05.670 ⇒ 01:01:11.580 Uttam Kumaran: Okay, I actually have to hop away. Do you have time? You wanna stay on for a sec to resolve?
496 01:01:11.790 ⇒ 01:01:14.130 Uttam Kumaran: Or we can continue on Slack, too. Okay.
497 01:01:16.060 ⇒ 01:01:16.780 Uttam Kumaran: Okay.
498 01:01:17.220 ⇒ 01:01:21.180 Uttam Kumaran: Thank you, guys. Oh wait, I can make you host.
499 01:01:33.290 ⇒ 01:01:37.409 Kyle Wandel: Do you know… I wish the exact PR he did?
500 01:01:41.340 ⇒ 01:01:45.760 Awaish Kumar: Yeah, a year, like, two, three PRs.
501 01:01:46.240 ⇒ 01:01:46.780 Kyle Wandel: Yeah.
502 01:01:46.780 ⇒ 01:01:50.349 Awaish Kumar: the… The ones that mention Cortex, yeah.
503 01:02:11.800 ⇒ 01:02:13.710 Kyle Wandel: Oh, it’s this one. Okay.
504 01:02:15.750 ⇒ 01:02:20.150 Awaish Kumar: But, it should be in the, like, in the scripts folder, if you go in.
505 01:02:21.230 ⇒ 01:02:23.749 Awaish Kumar: Back to… close the models.
506 01:02:25.500 ⇒ 01:02:27.430 Awaish Kumar: And then there should be a script.
507 01:02:27.680 ⇒ 01:02:30.380 Awaish Kumar: a folder called Scripts.
508 01:02:34.050 ⇒ 01:02:34.620 Awaish Kumar: Okay.
509 01:02:34.620 ⇒ 01:02:36.750 Kyle Wandel: And… in the marts?
510 01:02:42.170 ⇒ 01:02:44.090 Awaish Kumar: Okay, let me check.
511 01:02:44.500 ⇒ 01:02:46.729 Awaish Kumar: cohere, it’s in the…
512 01:02:49.950 ⇒ 01:02:58.740 Awaish Kumar: Okay, it’s outside of dbt Project. It’s, called Scripts, and then… you have… Codex folder.
513 01:03:02.190 ⇒ 01:03:03.850 Kyle Wandel: Okay, so then…
514 01:03:04.320 ⇒ 01:03:10.739 Kyle Wandel: how do I… so, right now, I’m currently in DVD Project, so I need to get not in DVD Project, basically. Is that…
515 01:03:10.740 ⇒ 01:03:19.309 Awaish Kumar: You are in dbt… yeah, you have to just, open the main repo folder, like, the CTA data…
516 01:03:19.840 ⇒ 01:03:20.790 Kyle Wandel: this one.
517 01:03:20.790 ⇒ 01:03:21.420 Awaish Kumar: Yeah.
518 01:03:25.290 ⇒ 01:03:27.859 Awaish Kumar: It has all of these files.
519 01:03:27.860 ⇒ 01:03:33.299 Kyle Wandel: then this isn’t able to access Claw for some reason.
520 01:03:36.250 ⇒ 01:03:36.930 Awaish Kumar: Yeah, but…
521 01:03:37.520 ⇒ 01:03:38.370 Kyle Wandel: Can we…
522 01:03:38.370 ⇒ 01:03:42.310 Awaish Kumar: The same where it is working, and the same… window?
523 01:03:43.390 ⇒ 01:03:47.030 Kyle Wandel: Where… No, it’s a different window. It opened a new window.
524 01:03:47.030 ⇒ 01:03:51.779 Awaish Kumar: Can we go to the same window where it is working, the cloud code, so we can try to open the…
525 01:03:52.300 ⇒ 01:03:54.359 Awaish Kumar: This folder in there.
526 01:03:54.770 ⇒ 01:03:55.540 Kyle Wandel: Totally.
527 01:03:55.840 ⇒ 01:04:01.390 Awaish Kumar: Yeah, so we can… I think you can click on File on the top.
528 01:04:03.610 ⇒ 01:04:07.360 Awaish Kumar: Yeah, and then you say… Open folder.
529 01:04:10.980 ⇒ 01:04:14.490 Awaish Kumar: And we can… Go back,
530 01:04:15.650 ⇒ 01:04:17.620 Awaish Kumar: One step back out of this.
531 01:04:19.200 ⇒ 01:04:20.080 Kyle Wandel: Sorry.
532 01:04:21.380 ⇒ 01:04:25.009 Awaish Kumar: Yeah, we have to get out of this… yeah, if you…
533 01:04:25.350 ⇒ 01:04:29.599 Awaish Kumar: Yeah, click on CT Data Ops, and just click on that, and open.
534 01:04:32.340 ⇒ 01:04:33.170 Awaish Kumar: Yeah.
535 01:04:34.080 ⇒ 01:04:35.670 Awaish Kumar: Now you should have everything.
536 01:04:44.910 ⇒ 01:04:47.740 Awaish Kumar: Scripts, under scripts. No.
537 01:04:52.070 ⇒ 01:04:52.760 Awaish Kumar: Okay.
538 01:04:53.720 ⇒ 01:04:56.540 Awaish Kumar: Now it should be able to find… you can try Cortex again.
539 01:05:00.490 ⇒ 01:05:02.580 Awaish Kumar: You can even give him the…
540 01:05:02.820 ⇒ 01:05:08.799 Awaish Kumar: path to the folder, like the… copy the path and give it… give the path to the… in the chat.
541 01:05:08.980 ⇒ 01:05:11.380 Awaish Kumar: Okay, here are my files for a student.
542 01:05:13.290 ⇒ 01:05:15.050 Kyle Wandel: You may, put my kids.
543 01:05:15.050 ⇒ 01:05:16.900 Awaish Kumar: Let’s go back to VS Code.
544 01:05:17.270 ⇒ 01:05:20.369 Awaish Kumar: Yeah. You can right-click on Cortex.
545 01:05:21.450 ⇒ 01:05:25.059 Awaish Kumar: And it says, copy relevant part, and you can just say…
546 01:05:25.980 ⇒ 01:05:29.200 Awaish Kumar: Copy relative path, it can just… Finally.
547 01:05:48.520 ⇒ 01:05:49.100 Awaish Kumar: Yeah.
548 01:05:49.590 ⇒ 01:05:50.260 Awaish Kumar: NCU.
549 01:05:50.260 ⇒ 01:05:50.970 Kyle Wandel: So…
550 01:05:51.100 ⇒ 01:05:54.900 Kyle Wandel: So now that I have you on here, and then maybe, Kai, this is a good thing for you too.
551 01:05:55.800 ⇒ 01:06:04.739 Kyle Wandel: I need to… it seems like I need to make sure that I’m always on this VS Code folder, basically. Is that right, Oish?
552 01:06:05.290 ⇒ 01:06:11.879 Awaish Kumar: No, I’m… I think it’s… there… maybe there is some misconfiguration in the cloud code.
553 01:06:12.070 ⇒ 01:06:16.770 Awaish Kumar: That is the reason it’s not working outside of this window, it should work.
554 01:06:16.910 ⇒ 01:06:21.500 Awaish Kumar: And, like… I was just trying to…
555 01:06:21.970 ⇒ 01:06:32.190 Awaish Kumar: worked right now, make it work, so we… I just ask you to create… open this here, but yeah, that error is just, like, it’s trying to find something in a folder.
556 01:06:32.320 ⇒ 01:06:43.499 Awaish Kumar: called CTA data, which was not open in our directory, and that’s the reason it was not working. There must be some fix for that, and it should work, basically.
557 01:06:44.540 ⇒ 01:06:45.300 Kyle Wandel: Okay.
558 01:06:45.800 ⇒ 01:06:48.630 Kyle Wandel: And if, so, I actually…
559 01:06:48.880 ⇒ 01:06:52.100 Kyle Wandel: But the way I would kind of want to do it is, let’s say I am…
560 01:06:52.380 ⇒ 01:06:57.289 Kyle Wandel: opening Visual Studio for the first time, and I want to create a new pipeline.
561 01:06:57.630 ⇒ 01:07:03.729 Kyle Wandel: from scratch, basically. I would open VS Code, And then.
562 01:07:04.390 ⇒ 01:07:04.930 Awaish Kumar: If I…
563 01:07:04.930 ⇒ 01:07:05.790 Kyle Wandel: I wanna go…
564 01:07:05.790 ⇒ 01:07:08.260 Awaish Kumar: Maybe just open a new window without anything.
565 01:07:09.470 ⇒ 01:07:10.290 Kyle Wandel: Just open…
566 01:07:10.290 ⇒ 01:07:12.100 Awaish Kumar: Close the window from there.
567 01:07:13.260 ⇒ 01:07:17.899 Awaish Kumar: And, and… and just open a…
568 01:07:18.720 ⇒ 01:07:21.190 Awaish Kumar: Can you now open a cloud code here?
569 01:07:22.340 ⇒ 01:07:25.550 Kyle Wandel: Yeeeeee… yes.
570 01:07:25.550 ⇒ 01:07:31.010 Awaish Kumar: Yes, you can. So, now you have to just open the folder, CTA dataOps, that’s all.
571 01:07:31.360 ⇒ 01:07:33.450 Kyle Wandel: With the GitHub, or the document?
572 01:07:33.450 ⇒ 01:07:35.810 Awaish Kumar: Telecom File, yeah, that one.
573 01:07:36.460 ⇒ 01:07:37.180 Kyle Wandel: Okay.
574 01:07:40.110 ⇒ 01:07:41.010 Kyle Wandel: Okay.
575 01:07:41.440 ⇒ 01:07:42.840 Awaish Kumar: Yeah, it will just work.
576 01:07:46.360 ⇒ 01:07:58.610 Kyle Wandel: Okay, I’ll need to clean that up a little bit on my end. I think that’s what I need to do, and this is me just talking out front, out loud, is that it sounds like I probably should not be using…
577 01:07:58.820 ⇒ 01:08:01.129 Kyle Wandel: this dbt project one…
578 01:08:01.410 ⇒ 01:08:02.050 Awaish Kumar: Yeah.
579 01:08:02.860 ⇒ 01:08:04.759 Kyle Wandel: Okay, cool. Alright.
580 01:08:05.240 ⇒ 01:08:07.079 Kyle Wandel: Now I feel better. Okay.
581 01:08:09.080 ⇒ 01:08:13.689 Kyle Wandel: Okay, well, I think I’m good. Kai, do you need any help on anything?
582 01:08:14.030 ⇒ 01:08:28.979 Chi Quinn: Well, I mean, I need to… yeah, PCs, huh. I need to reinstall Claude, because I had it on my desktop, the app on the desktop, and I… for some reason, it’s not appearing, so I need to…
583 01:08:29.240 ⇒ 01:08:33.030 Chi Quinn: I feel like I need to fix those issues, but as far as the…
584 01:08:33.920 ⇒ 01:08:41.269 Chi Quinn: Snowflake CLI. It looks like it’s installed, and I am…
585 01:08:41.700 ⇒ 01:08:44.330 Chi Quinn: getting caught out, she needs me.
586 01:08:44.970 ⇒ 01:08:49.410 Awaish Kumar: You just need to ask… you can ask Cortex to help you… help you with that.
587 01:08:51.050 ⇒ 01:09:03.960 Awaish Kumar: like, you are doing in a CLI, but you can even open the VS Code, and inside of that, start asking Cortex to, okay, it’s create a virtual environment for me, create a… install Snow CLI for me, and things like that.
588 01:09:04.420 ⇒ 01:09:05.399 Chi Quinn: Okay.
589 01:09:05.870 ⇒ 01:09:17.360 Chi Quinn: That makes sense. Yeah, I have to set some things up. I’m a little bit behind on that, but I don’t want to take too much time. I feel like that’s something I can do on my own, and then I will catch up, from there.
590 01:09:17.729 ⇒ 01:09:18.649 Awaish Kumar: Okay, sure.
591 01:09:18.649 ⇒ 01:09:19.189 Chi Quinn: No.
592 01:09:20.220 ⇒ 01:09:26.270 Kyle Wandel: Thank you, Aishin. I’ll probably, like, I’ll probably send you a PR for the Shopify stuff here tomorrow or today, so…
593 01:09:26.279 ⇒ 01:09:31.239 Awaish Kumar: Like, for the Shopify, like, what do you wanna… you have started modeling already?
594 01:09:31.410 ⇒ 01:09:39.249 Kyle Wandel: Yeah, I started a little bit. I can… I can take it, and then have you do a quick QA. I don’t think it would be too difficult, because I’m already in, like, halfway through it.
595 01:09:39.640 ⇒ 01:09:40.620 Awaish Kumar: Okay, okay.
596 01:09:42.640 ⇒ 01:09:43.240 Awaish Kumar: Tagosh.
597 01:09:43.240 ⇒ 01:09:46.049 Kyle Wandel: Alright, I’m gonna go get lunch. So, thanks guys.
598 01:09:46.050 ⇒ 01:09:47.380 Chi Quinn: Okay, thank you!
599 01:09:47.380 ⇒ 01:09:50.859 Awaish Kumar: So, made some changes on CS, and the ones you asked.
600 01:09:50.970 ⇒ 01:09:53.419 Awaish Kumar: So, maybe you can review that.
601 01:09:53.420 ⇒ 01:10:03.819 Kyle Wandel: Yeah, yeah, yeah, I took a look, sorry. I thought I… I thought I okayed the PR this morning. Maybe I forgot to hit merge. I’ll take a final look at it, I think it’s… but I think it’s probably good to go.
602 01:10:04.660 ⇒ 01:10:08.529 Awaish Kumar: Okay, I think the seat check is failing, I will look at that.
603 01:10:09.610 ⇒ 01:10:16.200 Awaish Kumar: Yeah, just approve it, if you are okay with it, I will merge it, because the check is failing, and I need to solve it.
604 01:10:16.730 ⇒ 01:10:19.700 Kyle Wandel: Okay, sounds good. Alright, I’ll take a look as well.
605 01:10:20.030 ⇒ 01:10:20.540 Awaish Kumar: Correct.
606 01:10:20.990 ⇒ 01:10:22.059 Kyle Wandel: Thank you.
607 01:10:22.060 ⇒ 01:10:23.200 Chi Quinn: Yeah, thanks.