Meeting Title: ABC Standup Date: 2025-07-31 Meeting participants: Amber Lin, Mustafa Raja, Annie Yu, Casie Aviles, Vashdev Heerani, Awaish Kumar
WEBVTT
1 00:00:43.650 ⇒ 00:00:44.710 Amber Lin: Hello
2 00:00:49.150 ⇒ 00:00:50.130 Amber Lin: bye!
3 00:00:50.790 ⇒ 00:00:51.410 Mustafa Raja: Hey!
4 00:00:52.644 ⇒ 00:01:02.180 Amber Lin: I’ll share my screen. I want to keep this short because I need to make slides, and I haven’t made slides in my meeting with the clients is in the hour. So I’m gonna keep this really, really short.
5 00:01:03.860 ⇒ 00:01:04.780 Mustafa Raja: Okay.
6 00:01:05.640 ⇒ 00:01:12.340 Amber Lin: So this is Okay,
7 00:01:15.400 ⇒ 00:01:24.590 Amber Lin: I check that. I’m gonna say it’s done that we also got that’s done.
8 00:01:30.110 ⇒ 00:01:31.389 Amber Lin: any any other.
9 00:01:31.390 ⇒ 00:01:32.600 Annie Yu: It’s also done. No one’s.
10 00:01:32.600 ⇒ 00:01:36.939 Amber Lin: Oh, oh, have we sent an update about that.
11 00:01:37.217 ⇒ 00:01:39.160 Annie Yu: No, I think I wish at you.
12 00:01:39.950 ⇒ 00:01:41.290 Amber Lin: And that’s where the
13 00:01:41.290 ⇒ 00:01:47.289 Amber Lin: okay, I will go. I will go look at it. Mashed up. Did you get all the access
14 00:01:49.250 ⇒ 00:01:50.180 Amber Lin: you need.
15 00:01:53.335 ⇒ 00:01:56.660 Mustafa Raja: I don’t think is in the meeting yet.
16 00:01:56.890 ⇒ 00:02:05.180 Amber Lin: Never mind my bad. So he’s not here yet. That’s okay. Okay.
17 00:02:05.960 ⇒ 00:02:20.369 Amber Lin: Annie, I’ll call your name when Vasha comes and we do the data platform just feel free to zone off. Now do other stuff I’m gonna talk about. ABC, stuff be be. And then when Vasha joins so we can talk about the other.
18 00:02:21.090 ⇒ 00:02:21.830 Annie Yu: Okay. Cool.
19 00:02:21.830 ⇒ 00:02:25.919 Amber Lin: Yeah, is he invited? He is invited. Okay.
20 00:02:28.610 ⇒ 00:02:29.960 Amber Lin: Alright.
21 00:02:30.280 ⇒ 00:02:33.230 Amber Lin: That’s my stuff okay,
22 00:02:40.080 ⇒ 00:02:42.419 Amber Lin: questions on these 2,
23 00:02:45.470 ⇒ 00:02:47.255 Amber Lin: how our progress
24 00:02:51.230 ⇒ 00:02:52.099 Mustafa Raja: This I mean.
25 00:02:52.100 ⇒ 00:02:52.840 Casie Aviles: Tickets.
26 00:02:53.080 ⇒ 00:02:53.820 Mustafa Raja: Yeah. The book.
27 00:02:53.860 ⇒ 00:02:54.740 Casie Aviles: 5!
28 00:02:55.140 ⇒ 00:02:56.370 Mustafa Raja: Yeah. Guess you go on.
29 00:02:57.500 ⇒ 00:03:05.580 Casie Aviles: Yeah. Yeah. So 4, 5, 4, 6 I’m adding them right now. I think the only thing that I have to add
30 00:03:06.690 ⇒ 00:03:09.160 Casie Aviles: and left this electrical.
31 00:03:09.690 ⇒ 00:03:10.130 Amber Lin: Hmm.
32 00:03:10.550 ⇒ 00:03:14.959 Casie Aviles: Wait. I’m not sure. Did you work on this Mustafa like plumbing.
33 00:03:16.700 ⇒ 00:03:22.000 Mustafa Raja: Apologies, appliance, repair, and water quality. I did review them.
34 00:03:23.330 ⇒ 00:03:28.189 Casie Aviles: So for Hvac. Hvac’s good. Now I did. The more granular.
35 00:03:28.190 ⇒ 00:03:28.760 Amber Lin: Oh!
36 00:03:28.760 ⇒ 00:03:29.650 Casie Aviles: Pasting.
37 00:03:30.320 ⇒ 00:03:37.580 Mustafa Raja: Yeah, I would want to look at the phone numbers with you one time.
38 00:03:38.000 ⇒ 00:03:38.630 Amber Lin: Me.
39 00:03:38.800 ⇒ 00:03:40.500 Amber Lin: We’re with Casey. Oh, okay.
40 00:03:42.060 ⇒ 00:03:46.340 Amber Lin: Let’s look at the phone numbers right now.
41 00:03:48.120 ⇒ 00:03:52.040 Amber Lin: Oh, no, this
42 00:03:53.850 ⇒ 00:03:59.929 Mustafa Raja: Yeah, so this is what I could infer from it.
43 00:04:00.822 ⇒ 00:04:06.990 Mustafa Raja: And so I be based on the data. I did try to split or flatten it.
44 00:04:07.300 ⇒ 00:04:18.049 Amber Lin: Okay, yeah, I will. I will take this to let them confirm. There’s not much we can do after this. Thank you for doing this. I’m gonna grab this and share this with mechanical
45 00:04:19.930 ⇒ 00:04:31.319 Amber Lin: amber to firm spreadsheets.
46 00:04:32.355 ⇒ 00:04:37.539 Amber Lin: Casey, what about? Or do we add these to the central dock for the mechanical.
47 00:04:37.720 ⇒ 00:04:40.040 Amber Lin: or is it in the document you shared.
48 00:04:40.480 ⇒ 00:04:41.959 Casie Aviles: Yeah, it’s still there in the doc.
49 00:04:41.960 ⇒ 00:04:42.760 Casie Aviles: Yeah, that.
50 00:04:42.760 ⇒ 00:04:51.300 Amber Lin: Okay, that’s okay. That’s okay. I’ll go get them to check this.
51 00:04:53.170 ⇒ 00:04:53.810 Casie Aviles: Okay.
52 00:04:53.810 ⇒ 00:04:57.920 Amber Lin: Alright. Yeah, I’ll go fuck.
53 00:05:01.770 ⇒ 00:05:06.200 Amber Lin: Let me know when the electrical is done, and I can move it to client review.
54 00:05:07.280 ⇒ 00:05:08.170 Amber Lin: Right sure.
55 00:05:08.170 ⇒ 00:05:13.889 Amber Lin: Oh, I saw this one, that there was pest! I I saw that there were some changes.
56 00:05:14.640 ⇒ 00:05:21.560 Casie Aviles: Yeah, although I I haven’t really gotten around to this part, like I mean, for, like the automation getting it.
57 00:05:21.560 ⇒ 00:05:22.260 Amber Lin: Hmm.
58 00:05:23.210 ⇒ 00:05:31.550 Casie Aviles: Yeah, I was just prioritizing the 1st ticket. this is until tomorrow. Right?
59 00:05:31.907 ⇒ 00:05:36.560 Casie Aviles: Let’s see when our cycle ends. I really don’t think it’s that urgent.
60 00:05:37.236 ⇒ 00:05:53.490 Amber Lin: Cause. There’s not that much coming in for mechanical. We can survive with a little bit of manual filtering right now. I will push this back. So we have more breathing room. I’m gonna say, for next Thursday.
61 00:05:55.650 ⇒ 00:05:56.580 Amber Lin: Okay,
62 00:05:59.030 ⇒ 00:06:18.119 Amber Lin: I think that’s it. I wanted to ask something for the cancellations side. Because right, I’ll add more requirements, just just like a heads up because they cause we really want to focus on cancellation, because that’s the revenue impacting one. So they wanna they want Andy to give.
63 00:06:18.660 ⇒ 00:06:27.950 Amber Lin: Very specific scripts and responses. And right now, because we did rag, we we give like summaries of responses which is
64 00:06:28.180 ⇒ 00:06:33.880 Amber Lin: too high level for cancellations. But I’ll I’ll add requirements. And I’ll let you guys know.
65 00:06:35.710 ⇒ 00:06:44.170 Amber Lin: Okay, I think that’s most of it anything on yeah, it says.
66 00:06:44.591 ⇒ 00:06:47.539 Mustafa Raja: Yeah. So for the people who
67 00:06:47.710 ⇒ 00:07:00.009 Mustafa Raja: who are in more than one department. When they ask a question, Andy 1st asks them? Which which department do they want to talk about?
68 00:07:00.760 ⇒ 00:07:08.530 Mustafa Raja: So if someone is from pest and mechanical, both and you will clarify which department either pest or mechanical.
69 00:07:09.905 ⇒ 00:07:15.800 Mustafa Raja: And sounds good through the session until they ask to change the department.
70 00:07:15.800 ⇒ 00:07:19.809 Amber Lin: Awesome. That’s great, that’s great, that’s good. I think that’s all. The.
71 00:07:19.810 ⇒ 00:07:20.400 Mustafa Raja: You know.
72 00:07:20.610 ⇒ 00:07:31.029 Amber Lin: Yay, okay, I think that’s all the tasks for the AI side. Vasha, thanks for joining our stand up. So do you have access to all of these.
73 00:07:41.660 ⇒ 00:07:45.350 Amber Lin: Oh, gosh! If you’re on mute, if you’re talking.
74 00:07:45.930 ⇒ 00:07:48.280 Casie Aviles: I gave Vashtev, s. 3 and real.
75 00:07:48.720 ⇒ 00:07:49.299 Amber Lin: Oh, okay.
76 00:07:50.210 ⇒ 00:07:59.750 Vashdev Heerani: Yeah. So I I have access to 2 A/C get repo rail. Yes, and Snowflake as well.
77 00:08:00.120 ⇒ 00:08:01.150 Amber Lin: Hmm, okay.
78 00:08:02.229 ⇒ 00:08:09.429 Amber Lin: Let me see, can someone share our ABC one pass with Vasha just in case he needs it?
79 00:08:14.270 ⇒ 00:08:15.000 Casie Aviles: Okay.
80 00:08:19.080 ⇒ 00:08:23.730 Amber Lin: Think on this side. Have you had a chance? I think we have.
81 00:08:24.320 ⇒ 00:08:25.180 Amber Lin: Okay?
82 00:08:26.400 ⇒ 00:08:29.969 Amber Lin: I think you have. S 3 access.
83 00:08:31.080 ⇒ 00:08:35.669 Amber Lin: Do you have access to the Api key.
84 00:08:36.809 ⇒ 00:08:37.489 Vashdev Heerani: Nope.
85 00:08:38.461 ⇒ 00:08:44.489 Amber Lin: Who can give Asha access to the Api key? Casey, is it you? Or is going to be a wish.
86 00:08:44.490 ⇒ 00:08:48.930 Casie Aviles: Yeah, I, I think I can share it from, yeah, I think.
87 00:08:50.158 ⇒ 00:08:55.130 Amber Lin: Casey to share Api key. Okay.
88 00:08:55.579 ⇒ 00:09:04.279 Amber Lin: once you read this ticket, let let me know in the slack channel what questions you have and me, and a wish will try to help you on that.
89 00:09:05.980 ⇒ 00:09:10.989 Amber Lin: Yeah, I’ll set the due date for probably next Thursday.
90 00:09:11.481 ⇒ 00:09:17.439 Amber Lin: So that you have some time to ramp up and then understand what’s going on and troubleshoot anything.
91 00:09:18.990 ⇒ 00:09:24.279 Amber Lin: Okay? I believe that’s all of it. On the ABC side.
92 00:09:25.400 ⇒ 00:09:30.829 Amber Lin: Mustafa and Casey feel free to hop. I’m going to talk about data platform with Annie and Chef.
93 00:09:31.210 ⇒ 00:09:32.659 Mustafa Raja: Okay. Thank you. Bye.
94 00:09:32.660 ⇒ 00:09:33.350 Amber Lin: Yeah, thank, you.
95 00:09:33.350 ⇒ 00:09:34.229 Casie Aviles: Thank you. Everyone.
96 00:09:34.520 ⇒ 00:09:35.420 Amber Lin: Bye.
97 00:09:36.050 ⇒ 00:09:36.760 Vashdev Heerani: Bye.
98 00:09:37.930 ⇒ 00:09:42.810 Amber Lin: Okay, let me see if a wish is okay. Okay. He didn’t join. That’s okay.
99 00:09:45.410 ⇒ 00:09:46.600 Amber Lin: All right.
100 00:09:47.630 ⇒ 00:09:50.109 Amber Lin: Checking on these 2 tickets.
101 00:09:50.990 ⇒ 00:09:55.040 Amber Lin: Were you able to check the Prs and see what they were like.
102 00:10:00.780 ⇒ 00:10:03.420 Annie Yu: Wait! Is Vashti off.
103 00:10:04.610 ⇒ 00:10:05.240 Amber Lin: Hmm.
104 00:10:05.240 ⇒ 00:10:07.419 Annie Yu: I think Boshev left.
105 00:10:07.640 ⇒ 00:10:09.029 Amber Lin: Oh, that’s so funny.
106 00:10:09.810 ⇒ 00:10:14.580 Amber Lin: Oh, okay, well, so let me go ping him
107 00:10:20.550 ⇒ 00:10:26.530 Amber Lin: data. But no data platform.
108 00:10:34.800 ⇒ 00:10:35.710 Amber Lin: Okay?
109 00:10:36.420 ⇒ 00:10:42.389 Amber Lin: Oh, well, were you able to look at snowflake stuff.
110 00:10:42.840 ⇒ 00:10:56.369 Annie Yu: So yes, I. There are 7 tables for linear, which I I kind of get a sense of what each table is doing, and I will try to put together
111 00:10:57.430 ⇒ 00:11:02.859 Annie Yu: An expected model that I want to see for the linear itself.
112 00:11:03.562 ⇒ 00:11:05.210 Annie Yu: I’m trying to see
113 00:11:05.360 ⇒ 00:11:11.859 Annie Yu: how I want them to be joined on what granularity. And I can provide that to vast dev. And I think I can
114 00:11:12.980 ⇒ 00:11:23.800 Annie Yu: put together something today. But the connecting those sources to real. That’s something. I’m stuck, and I shared that in a thread.
115 00:11:23.800 ⇒ 00:11:25.789 Amber Lin: Yeah. I saw that you asked a wish.
116 00:11:25.790 ⇒ 00:11:26.240 Annie Yu: Yeah,
117 00:11:26.800 ⇒ 00:11:29.900 Annie Yu: He hasn’t got back to me today.
118 00:11:29.900 ⇒ 00:11:34.470 Amber Lin: Yeah, he he has been swamped, so he has a lot up.
119 00:11:34.770 ⇒ 00:11:35.420 Amber Lin: But I.
120 00:11:35.420 ⇒ 00:11:44.239 Annie Yu: I I think it’s not an actual blocker, I guess not until when bosh dev!
121 00:11:44.360 ⇒ 00:11:46.259 Annie Yu: It’s going to do some modeling.
122 00:11:46.640 ⇒ 00:11:47.050 Amber Lin: No.
123 00:11:47.050 ⇒ 00:11:50.589 Annie Yu: I can still do exploration on Snowflake.
124 00:11:50.810 ⇒ 00:11:55.410 Amber Lin: Okay. But you have access to snow, the need, the permissions you need for Snowflake. Right?
125 00:11:55.410 ⇒ 00:11:56.100 Annie Yu: I do?
126 00:11:56.100 ⇒ 00:11:57.970 Amber Lin: Okay, let me cancel that.
127 00:11:58.822 ⇒ 00:12:08.280 Amber Lin: So I was thinking, well, I for the requirements side. I’m gonna get what Utam has planned for requirements.
128 00:12:09.156 ⇒ 00:12:37.459 Amber Lin: And then I probably would want to get a meeting with you, Vashtab, and wish so we can do it. Maybe do a diagram and fix sham of. Okay, here here is all our sources. Here’s what we might want for the tables, and so that you don’t have to be the only person thinking about. Oh, this is the table, that’s it. That’s what we need. So we can make that decision together, and that will help inform, like the requirements for dashboarding.
129 00:12:37.680 ⇒ 00:12:39.160 Annie Yu: Okay, yeah, yeah.
130 00:12:39.160 ⇒ 00:12:48.500 Amber Lin: Yeah, I think that will make your life nicer. So I will say Friday or Monday.
131 00:12:50.970 ⇒ 00:12:51.930 Amber Lin: Hi.
132 00:12:52.305 ⇒ 00:12:52.680 Annie Yu: Oh.
133 00:12:52.680 ⇒ 00:12:56.430 Awaish Kumar: Are we talking about finding like for the initial charts.
134 00:12:56.990 ⇒ 00:13:20.139 Amber Lin: Yeah. So this is I. I’m gonna get all what I already wrote. So I will do that. And then I want a meeting between you, Annie Bashev and me. So we we can make a architecture diagram if we need. And then we can list out in a fig jam of okay, here are all the different fields. So we have, like as a team, we understand
135 00:13:20.210 ⇒ 00:13:27.689 Amber Lin: our requirements. I might ask Rico to join as well, because he’s going to be the end user as well. So we can define that together.
136 00:13:28.483 ⇒ 00:13:34.640 Annie Yu: Amber. But right now we’ve only got linear tables, and I imagine.
137 00:13:35.410 ⇒ 00:13:39.309 Annie Yu: All the requirements. We also want to include cloud.
138 00:13:39.310 ⇒ 00:13:42.399 Amber Lin: Yeah, these should be in right
139 00:13:42.950 ⇒ 00:13:50.430 Amber Lin: vash have dropped off after the ABC stand. I don’t really know why, but I wanted to check if these are like these 2 or.
140 00:13:50.430 ⇒ 00:13:52.910 Awaish Kumar: Yeah, like, these are not done yet. But I have.
141 00:13:53.595 ⇒ 00:13:54.540 Awaish Kumar: They’re looking good.
142 00:13:54.820 ⇒ 00:13:55.860 Awaish Kumar: December.
143 00:13:55.860 ⇒ 00:13:56.590 Amber Lin: Okay.
144 00:13:57.833 ⇒ 00:14:02.826 Awaish Kumar: And for the initial scoping I would rather like just want
145 00:14:03.630 ⇒ 00:14:07.610 Awaish Kumar: for the charts. Like as we as we mentioned, linear data, is there
146 00:14:07.780 ⇒ 00:14:12.010 Awaish Kumar: so like any of them start building 1st dashboard?
147 00:14:12.730 ⇒ 00:14:17.110 Awaish Kumar: I think it would be nicer if you’re gonna ask AI like Chat Gpt, of
148 00:14:17.770 ⇒ 00:14:23.829 Awaish Kumar: what productivity that like, for what metrics you can measure from lean.
149 00:14:25.560 ⇒ 00:14:28.390 Amber Lin: My, yeah, I see. I see.
150 00:14:28.720 ⇒ 00:14:31.899 Amber Lin: I I guess my pushback on. That is just that
151 00:14:32.050 ⇒ 00:14:54.119 Amber Lin: I don’t think as a team. I think you wish. You understand a lot of the requirements like, even for me. It’s not the clear wrist, and it could just be like a 15 min, 30 min meeting. Make sure that we’re all aligned and make sure that we have all the knowledge documented, and we can take that and then use AI, and it can do the initial charts. Do you? Is that okay with you?
152 00:14:54.630 ⇒ 00:15:00.410 Amber Lin: Cause I want Rico to be involved as well. He’s cause he’s Gonna be the end user. And I want, so
153 00:15:00.410 ⇒ 00:15:01.860 Amber Lin: one user is going to be like.
154 00:15:01.860 ⇒ 00:15:02.470 Awaish Kumar: Hey! Rico!
155 00:15:02.470 ⇒ 00:15:03.399 Amber Lin: So utam.
156 00:15:04.020 ⇒ 00:15:11.289 Awaish Kumar: Why I wanted like to be like the other way is just because I can share some
157 00:15:13.860 ⇒ 00:15:17.030 Awaish Kumar: like things things like which
158 00:15:17.350 ⇒ 00:15:27.649 Awaish Kumar: which I know put them already shared so many meetings which we can get from transcripts. But the thing is that we can only give right feedback when we see something.
159 00:15:28.840 ⇒ 00:15:33.510 Awaish Kumar: Like, if you like, for example, for matter more, how we work for matter, more like.
160 00:15:33.510 ⇒ 00:15:33.980 Amber Lin: I see.
161 00:15:33.980 ⇒ 00:15:37.079 Awaish Kumar: We like, we build some charts. And then we.
162 00:15:37.260 ⇒ 00:15:42.780 Awaish Kumar: we figure out, okay, like, add more filter or add one more category or things like that.
163 00:15:43.060 ⇒ 00:15:48.619 Amber Lin: Okay? So we should, before we do that meeting, we should based on
164 00:15:48.830 ⇒ 00:15:53.110 Amber Lin: existing fields, use AI to suggest
165 00:15:53.320 ⇒ 00:16:08.309 Amber Lin: possible analysis. I think for that I would like to have. I would like us to have access to these 2. We can get it started on linear. But I really would like to have fields for clockify as well.
166 00:16:09.110 ⇒ 00:16:14.810 Awaish Kumar: Yeah. So yeah, okay, like, I’ve already informed Vash, they have to finish.
167 00:16:15.290 ⇒ 00:16:16.340 Amber Lin: Sounds good.
168 00:16:16.490 ⇒ 00:16:19.458 Amber Lin: Yeah, I’ll ping him as well. Don’t worry.
169 00:16:20.930 ⇒ 00:16:23.004 Amber Lin: Annie, if that’s okay with you.
170 00:16:23.660 ⇒ 00:16:29.049 Amber Lin: use AI. Use what you have like. Let us suggest it so that we can have something to comment on.
171 00:16:29.240 ⇒ 00:16:38.289 Annie Yu: And what about the modeling? So do I do. I assume they are joined together, or separately.
172 00:16:38.290 ⇒ 00:16:42.609 Awaish Kumar: Like like for linear like. Right now, just for linear. If you work just for linear.
173 00:16:42.610 ⇒ 00:16:45.730 Annie Yu: Oh, yeah, but there are 7 tables for linears.
174 00:16:45.730 ⇒ 00:16:52.599 Awaish Kumar: Yeah, like, these are simple joins. Right? There’s not much of like big transformations right? There.
175 00:16:53.050 ⇒ 00:16:53.850 Annie Yu: So what I guess.
176 00:16:53.850 ⇒ 00:16:54.460 Awaish Kumar: Trying to be the.
177 00:16:54.460 ⇒ 00:16:56.210 Annie Yu: Word on that part.
178 00:16:58.160 ⇒ 00:17:25.310 Awaish Kumar: When we have to join with multiple different platforms data, we might need to like, aggregate it and bring them all on a same aggregate, get it level, and then join things like that. We might need modeling like right now, for example, if the tickets most we need to join with the user table. You will have some user id common id between these. And if you just join, you can get the user names. So right now, it’s it’s not that
179 00:17:25.579 ⇒ 00:17:31.890 Awaish Kumar: like on the complex observations there, you can just join in regular or something.
180 00:17:34.800 ⇒ 00:17:38.060 Annie Yu: And I’m not expected to do that by today. Right?
181 00:17:39.670 ⇒ 00:17:43.430 Annie Yu: So right now, I just.
182 00:17:43.430 ⇒ 00:17:45.320 Awaish Kumar: Yeah, like, what go back to say?
183 00:17:45.320 ⇒ 00:17:45.820 Annie Yu: That issue.
184 00:17:45.820 ⇒ 00:17:52.380 Awaish Kumar: If you open up, if I just go in in a linear table like issues. And if I
185 00:17:52.700 ⇒ 00:18:03.649 Awaish Kumar: read the schema, if you just copy paste both of those schema into a chat gpt, and ask it. It will recommend you to like which fields you should join
186 00:18:04.240 ⇒ 00:18:05.730 Awaish Kumar: to get the day. The 5.
187 00:18:05.730 ⇒ 00:18:12.230 Annie Yu: Yeah, yeah, I get that. But I I don’t have to join them yet. Right before scoping out the charts.
188 00:18:12.780 ⇒ 00:18:16.040 Annie Yu: I want to figure out the the priorities now.
189 00:18:20.700 ⇒ 00:18:23.590 Awaish Kumar: What do you mean by scoping of the charts like.
190 00:18:23.940 ⇒ 00:18:26.440 Annie Yu: Cause. I think there’s a ticket for me that’s
191 00:18:26.720 ⇒ 00:18:29.479 Annie Yu: planning some charts is that it? Amber.
192 00:18:31.660 ⇒ 00:18:38.610 Amber Lin: That one is using the fields we have to think about possible.
193 00:18:38.930 ⇒ 00:18:39.520 Amber Lin: Say.
194 00:18:39.520 ⇒ 00:18:42.129 Annie Yu: But I don’t have to. Actually.
195 00:18:42.680 ⇒ 00:18:49.039 Annie Yu: you don’t have to make the charts. We’re just thinking about what possible, what possibilities there are.
196 00:18:50.420 ⇒ 00:18:52.811 Amber Lin: Let me clarify this ticket like
197 00:18:55.074 ⇒ 00:19:10.069 Amber Lin: Drafts, analysis draft analysis plans, dashboard plan like output. A document.
198 00:19:12.170 ⇒ 00:19:13.570 Annie Yu: And this is for linear.
199 00:19:14.515 ⇒ 00:19:21.919 Amber Lin: Yes. And when we get more data we will do that for the other sources as well.
200 00:19:21.920 ⇒ 00:19:22.640 Annie Yu: Okay.
201 00:19:24.820 ⇒ 00:19:29.190 Amber Lin: Yeah, I have to hop, guys. I am. Oh, Hi, Vashav.
202 00:19:29.310 ⇒ 00:19:36.259 Amber Lin: I didn’t make the message clear with I just combined the 2 Cnn’s, because I really don’t have that much
203 00:19:36.440 ⇒ 00:19:43.410 Amber Lin: fine for meetings. I know a wish already pinged you on these. We will need this so that Annie can
204 00:19:43.520 ⇒ 00:19:51.710 Amber Lin: start doing. Her analysis is a bit blocked by that right now. So would love to see this done by the end of day.
205 00:19:52.450 ⇒ 00:19:53.340 Vashdev Heerani: Okay. Sure.
206 00:19:53.610 ⇒ 00:19:54.770 Amber Lin: Yeah, okay.
207 00:19:56.510 ⇒ 00:20:02.560 Annie Yu: For connecting the tables too real. I still need awareness. Help.
208 00:20:02.850 ⇒ 00:20:03.470 Amber Lin: Hmm!
209 00:20:04.050 ⇒ 00:20:06.740 Amber Lin: I’ll let you guys figure out how to
210 00:20:07.950 ⇒ 00:20:12.849 Amber Lin: how to help that. I need to hop. I I need to make my slides.
211 00:20:13.030 ⇒ 00:20:13.830 Annie Yu: Yeah, yeah.
212 00:20:13.830 ⇒ 00:20:15.670 Amber Lin: Okay. Thanks. Everybody.
213 00:20:17.253 ⇒ 00:20:23.509 Awaish Kumar: Like I in the yeah, it’s just for any you can if you want to.
214 00:20:23.800 ⇒ 00:20:24.659 Awaish Kumar: You need this.
215 00:20:24.660 ⇒ 00:20:30.370 Amber Lin: You can. You can use my meeting room. I’m gonna hop! I have this meeting room for another.
216 00:20:30.790 ⇒ 00:20:32.980 Amber Lin: 40 min.
217 00:20:33.490 ⇒ 00:20:38.519 Amber Lin: So feel free to use this, I will hop off. You guys can use this to discuss.
218 00:20:39.490 ⇒ 00:20:41.099 Awaish Kumar: Okay, yeah, sure. Thank you.
219 00:20:41.250 ⇒ 00:20:42.109 Amber Lin: Thank you so much.
220 00:20:42.510 ⇒ 00:20:43.000 Annie Yu: Thanks.
221 00:20:43.480 ⇒ 00:20:54.880 Awaish Kumar: Yeah, any in the one pass. Basically, if you search for like snowflake internal user, and
222 00:20:55.460 ⇒ 00:20:59.135 Awaish Kumar: you can find out the private key,
223 00:21:02.118 ⇒ 00:21:04.749 Annie Yu: Okay, is that in the share.
224 00:21:04.750 ⇒ 00:21:10.629 Awaish Kumar: Yeah, it is internal input shared water. Yeah.
225 00:21:11.690 ⇒ 00:21:12.690 Annie Yu: And then.
226 00:21:13.190 ⇒ 00:21:21.069 Awaish Kumar: It’s internal service user. Reader, Snowflake, and there is private key available there. You just use that one.
227 00:21:21.210 ⇒ 00:21:24.472 Awaish Kumar: And should you should be able to access
228 00:21:25.360 ⇒ 00:21:28.179 Awaish Kumar: these data and stuff like using this key.
229 00:21:28.450 ⇒ 00:21:36.679 Annie Yu: What about before? So the whole string is composed with part of this, and then part of other things. Right? So what about before that
230 00:21:37.580 ⇒ 00:21:38.550 Annie Yu: I.
231 00:21:39.440 ⇒ 00:21:39.790 Awaish Kumar: Sorry.
232 00:21:39.790 ⇒ 00:21:43.849 Annie Yu: I I think yesterday I was able to get a private key, but it’s
233 00:21:45.750 ⇒ 00:21:49.800 Annie Yu: still saying so for that whole string.
234 00:21:50.610 ⇒ 00:21:54.000 Annie Yu: It’s not just the private key. It’s.
235 00:21:54.000 ⇒ 00:21:54.840 Awaish Kumar: Oh, okay. Cool.
236 00:21:54.840 ⇒ 00:21:57.590 Annie Yu: Warehouse, and then database.
237 00:21:57.590 ⇒ 00:21:58.260 Awaish Kumar: Yes.
238 00:22:04.320 ⇒ 00:22:07.169 Awaish Kumar: just purely of both hands.
239 00:22:08.700 ⇒ 00:22:11.580 Annie Yu: Okay, let me try it.
240 00:22:41.580 ⇒ 00:22:48.489 Annie Yu: And I should use the slack analytics. Right? That’s why I’m I’m in now.
241 00:22:52.340 ⇒ 00:22:53.020 Awaish Kumar: Sorry.
242 00:22:53.430 ⇒ 00:22:55.540 Annie Yu: Because there are different projects
243 00:22:56.330 ⇒ 00:23:04.710 Annie Yu: in in real. And should I be continue continuing using the slack analytics for our internal work.
244 00:23:05.620 ⇒ 00:23:08.259 Awaish Kumar: No, no like in the real right? You can.
245 00:23:09.050 ⇒ 00:23:14.350 Awaish Kumar: Yeah, you can use slack analytics. Or if you want to create new one, you can do that.
246 00:23:15.000 ⇒ 00:23:21.900 Annie Yu: Okay, I think I’ll use the slack analytics. I don’t really know how to create a new project.
247 00:23:26.390 ⇒ 00:23:28.620 Awaish Kumar: I I just have to find.
248 00:23:30.240 ⇒ 00:23:31.850 Awaish Kumar: Okay. I will
249 00:23:38.410 ⇒ 00:23:40.340 Awaish Kumar: just give me a moment.
250 00:23:41.170 ⇒ 00:23:41.820 Annie Yu: Okay.
251 00:23:51.100 ⇒ 00:23:53.459 Awaish Kumar: Main discussion. That’s good.
252 00:25:26.200 ⇒ 00:25:31.840 Awaish Kumar: Yeah, like any. I I just was finding out this slack thread.
253 00:25:32.070 ⇒ 00:25:36.560 Awaish Kumar: So yeah, I connected the oh.
254 00:25:39.290 ⇒ 00:25:41.150 Annie Yu: The one pass or.
255 00:25:41.150 ⇒ 00:25:43.370 Awaish Kumar: I connected Will with the
256 00:25:47.020 ⇒ 00:25:51.610 Awaish Kumar: snowflake. If you can read that and try to see
257 00:25:52.910 ⇒ 00:25:54.720 Awaish Kumar: I have tagged you in this thread.
258 00:25:56.150 ⇒ 00:25:57.440 Annie Yu: Okay, let me.
259 00:25:57.440 ⇒ 00:26:07.329 Awaish Kumar: So it it is about both. The document is showing how to create a service account and then use it. But you don’t have to create anything. It’s already there.
260 00:26:07.690 ⇒ 00:26:14.730 Awaish Kumar: You just have to look at the part where it is saying how to connect, to win.
261 00:26:15.210 ⇒ 00:26:17.590 Awaish Kumar: So yeah, maybe I.
262 00:26:18.270 ⇒ 00:26:23.490 Annie Yu: Is it the the step? 3, that you’re talking about?
263 00:26:25.120 ⇒ 00:26:25.730 Awaish Kumar: Got it.
264 00:26:26.060 ⇒ 00:26:29.179 Annie Yu: Is this step 3 that you’re talking about, or.
265 00:26:29.770 ⇒ 00:26:33.940 Awaish Kumar: And I would let me open the page. I just tagged you.
266 00:26:34.360 ⇒ 00:26:42.950 Annie Yu: Yeah, yeah, I’m in that page. And I’m looking at. So this is similar to what I saw yesterday from real stock. And
267 00:26:44.130 ⇒ 00:26:48.170 Annie Yu: and I think I know what to do. But I just I just keep failing
268 00:26:48.810 ⇒ 00:26:54.660 Annie Yu: after I got my user’s account, database, schema and role.
269 00:26:54.860 ⇒ 00:26:56.970 Awaish Kumar: Let me join. Like
270 00:27:03.140 ⇒ 00:27:11.870 Awaish Kumar: to go to ABC. Home and settings, and I’ve noticed.
271 00:27:11.940 ⇒ 00:27:13.930 Annie Yu: Are you sharing the screen or not?
272 00:27:14.890 ⇒ 00:27:17.129 Annie Yu: Or are you trying to share or not?
273 00:27:17.130 ⇒ 00:27:19.730 Awaish Kumar: Yeah, I’m I’m just saying that
274 00:27:21.290 ⇒ 00:27:27.189 Awaish Kumar: I’m not sharing anything. I I just added this using the same doc process in the doc.
275 00:27:27.891 ⇒ 00:27:39.440 Awaish Kumar: I just added this for the ABC. Home and Commercial will. So Connector dot Snowflake, dot Dsm is the key. And I added this basically
276 00:27:40.170 ⇒ 00:27:42.100 Awaish Kumar: in the in the same format.
277 00:27:44.160 ⇒ 00:27:48.860 Annie Yu: Oh, okay. So we so our service account is still called ABC.
278 00:27:49.380 ⇒ 00:27:54.039 Awaish Kumar: No, no, no, this is for ABC. I’m just showing an example.
279 00:27:54.457 ⇒ 00:27:57.280 Awaish Kumar: Do you have to use the other one? Which is
280 00:27:57.790 ⇒ 00:28:05.500 Awaish Kumar: which? Which is this one right in one pass. It’s called internal right. This is the one
281 00:28:05.630 ⇒ 00:28:07.880 Awaish Kumar: internal service reserve
282 00:28:08.130 ⇒ 00:28:13.720 Awaish Kumar: and the the this is the private key. But you just have to follow the steps. I don’t know. Like
283 00:28:14.250 ⇒ 00:28:18.979 Awaish Kumar: in the document, it must must say like what to do right
284 00:28:20.378 ⇒ 00:28:21.891 Awaish Kumar: let me open it.
285 00:28:22.870 ⇒ 00:28:31.429 Awaish Kumar: So step step one is the step. 2 like you can start from state. Step number.
286 00:28:33.160 ⇒ 00:28:39.470 Annie Yu: Oh, yeah, wait. This is this is what I’ve already tried. So so
287 00:28:41.230 ⇒ 00:28:52.560 Annie Yu: how do I explain this? So before that private key, there are lots of strings, right? And this is, I’ve already have a string where it starts with my account.
288 00:28:52.840 ⇒ 00:29:02.540 Annie Yu: and then anything before. So I have all these string where I follow the doc. But for some reason it’s still not working.
289 00:29:03.170 ⇒ 00:29:07.190 Awaish Kumar: Okay, so have you tried running this.
290 00:29:07.740 ⇒ 00:29:08.350 Annie Yu: Yes.
291 00:29:08.350 ⇒ 00:29:08.760 Awaish Kumar: Or.
292 00:29:08.760 ⇒ 00:29:11.150 Annie Yu: That’s how I got the private key.
293 00:29:11.580 ⇒ 00:29:15.179 Awaish Kumar: Yeah, you have to store the private key in some file
294 00:29:15.750 ⇒ 00:29:18.759 Awaish Kumar: right? And then run this command.
295 00:29:19.320 ⇒ 00:29:21.059 Awaish Kumar: So you will get a
296 00:29:21.810 ⇒ 00:29:28.440 Awaish Kumar: so clean a warrior of private key whatever is output of this command, and then you have to copy that.
297 00:29:28.790 ⇒ 00:29:32.050 Awaish Kumar: I’ll put it in this private key.
298 00:29:32.490 ⇒ 00:29:33.380 Awaish Kumar: Yeah.
299 00:29:34.260 ⇒ 00:29:44.930 Annie Yu: Yeah, I actually did that multiple times yesterday, and I still can’t get it right. And I don’t know if it’s the user account database, schema.
300 00:29:44.930 ⇒ 00:29:47.659 Annie Yu: But what where is that like? If you can re.
301 00:29:47.980 ⇒ 00:29:55.770 Awaish Kumar: Where, where you have tried. Like, you know, if I go to real data, I can’t see anything. If you show me something I can maybe
302 00:29:55.920 ⇒ 00:30:03.450 Awaish Kumar: debug it right if you add it here, and then we can. I can see like, if it’s not working, what is the issue?
303 00:30:04.420 ⇒ 00:30:05.120 Awaish Kumar: Should be.
304 00:30:07.062 ⇒ 00:30:10.919 Annie Yu: I I can add it here right now.
305 00:30:12.040 ⇒ 00:30:15.180 Annie Yu: I I don’t really know what the key is.
306 00:30:15.750 ⇒ 00:30:18.839 Awaish Kumar: Yeah, but that’s what I just showed you like. If you go into this
307 00:30:19.000 ⇒ 00:30:22.299 Awaish Kumar: page in this project like, this is the key.
308 00:30:23.070 ⇒ 00:30:28.020 Annie Yu: Yeah. And and that’s why I’m saying I’ve tried this.
309 00:30:29.010 ⇒ 00:30:41.219 Awaish Kumar: I’m what that’s the. I can’t see it here. Right? That’s what I’m asking in this project. I can’t see what you’re saying right. There’s no snowflake connection. If you add it here, I can see actually see the error
310 00:30:44.270 ⇒ 00:30:47.810 Awaish Kumar: if you add it here, the the key and value.
311 00:30:48.210 ⇒ 00:30:51.299 Awaish Kumar: Then I can see the error. Otherwise I don’t know. Like.
312 00:30:51.460 ⇒ 00:30:54.990 Awaish Kumar: if you, the key you have created like, where is where it is
313 00:30:58.650 ⇒ 00:31:03.099 Awaish Kumar: the connection listing that mediated. I can’t see it right? So just add it here.
314 00:31:04.620 ⇒ 00:31:06.979 Awaish Kumar: So I can see basically.
315 00:31:06.980 ⇒ 00:31:08.147 Annie Yu: Okay, I just did.
316 00:31:10.100 ⇒ 00:31:13.410 Annie Yu: If you refresh, you should be able to see it.
317 00:31:18.520 ⇒ 00:31:19.090 Awaish Kumar: Okay.
318 00:31:20.290 ⇒ 00:31:21.819 Annie Yu: And that’s my account.
319 00:31:21.820 ⇒ 00:31:26.350 Awaish Kumar: So this should not be, it should not be any right.
320 00:31:27.460 ⇒ 00:31:29.070 Awaish Kumar: It’s not your.
321 00:31:29.200 ⇒ 00:31:31.250 Awaish Kumar: This. This is not like.
322 00:31:32.495 ⇒ 00:31:33.359 Awaish Kumar: Well.
323 00:31:37.180 ⇒ 00:31:41.689 Awaish Kumar: this should be like as of as of this example.
324 00:31:44.060 ⇒ 00:31:47.800 Awaish Kumar: So this is the name of the
325 00:31:48.680 ⇒ 00:31:59.770 Awaish Kumar: user. It’s it’s not your name. If it is this internal service user, we are not using personal accounts here because we can’t use because of this 2 factor, authentication.
326 00:32:00.750 ⇒ 00:32:03.910 Awaish Kumar: The name is the name of that user is this.
327 00:32:05.033 ⇒ 00:32:14.099 Awaish Kumar: I don’t know why it’s not at full scale. It it is not showing you complete name, but it is called Internal Service user reader, something like that.
328 00:32:14.720 ⇒ 00:32:16.300 Awaish Kumar: and that is the name
329 00:32:16.460 ⇒ 00:32:23.640 Awaish Kumar: 8. This, this is great. This is the fine. This can be the same because we are in the same sort of like account.
330 00:32:24.460 ⇒ 00:32:34.940 Awaish Kumar: And then you can use ABC logs, database schema you want to connect with basically, that’s correct. And so
331 00:32:36.380 ⇒ 00:32:39.140 Awaish Kumar: you have to update this. This is what
332 00:32:39.510 ⇒ 00:32:43.809 Awaish Kumar: should should be. And also it’s not required.
333 00:32:47.970 ⇒ 00:32:56.670 Awaish Kumar: Polytropic media. Okay, I have this, except this.
334 00:32:57.080 ⇒ 00:33:04.019 Annie Yu: But is this? Are you? Have you just ran that command here for this key?
335 00:33:09.530 ⇒ 00:33:12.520 Annie Yu: Let me get the ones.
336 00:33:18.280 ⇒ 00:33:26.559 Annie Yu: So this I I’m seeing this stock is is this is the same thing as what real real stock saying.
337 00:33:27.000 ⇒ 00:33:29.270 Annie Yu: right? And that’s what I ran.
338 00:33:30.700 ⇒ 00:33:36.900 Awaish Kumar: Yeah, but that’s like what I’m doing is exactly
339 00:33:38.130 ⇒ 00:33:46.270 Awaish Kumar: what Will says to me like, I just copy pasted few few things from there
340 00:33:46.730 ⇒ 00:33:48.420 Awaish Kumar: to keep it in our own
341 00:33:49.120 ⇒ 00:33:58.120 Awaish Kumar: talks and it’s and that’s what it work what worked for for while I was connecting ABC. Data
342 00:33:59.260 ⇒ 00:34:09.159 Awaish Kumar: whatever command I ran for, so private private key, are you? I don’t know if
343 00:34:09.580 ⇒ 00:34:12.929 Awaish Kumar: if if it is, if it is the pro output of.
344 00:34:13.750 ⇒ 00:34:16.989 Awaish Kumar: did you run. This command is this output.
345 00:34:17.170 ⇒ 00:34:21.649 Annie Yu: I just use the one in one pass with.
346 00:34:21.659 ⇒ 00:34:25.059 Awaish Kumar: Yeah, but you can’t just use directly that right?
347 00:34:25.299 ⇒ 00:34:29.419 Awaish Kumar: You have to run this command on top of them
348 00:34:31.679 ⇒ 00:34:34.529 Awaish Kumar: like this is not, then the dogs right. This.
349 00:34:34.919 ⇒ 00:34:38.169 Awaish Kumar: whatever is there, is actual private key, right?
350 00:34:38.819 ⇒ 00:34:44.859 Awaish Kumar: This was actually generated using some commands which are in Step one.
351 00:34:46.051 ⇒ 00:34:52.169 Awaish Kumar: This is an actual private key. But on that private key you have to run this step. Number 2.
352 00:34:54.030 ⇒ 00:34:56.690 Annie Yu: What do you mean by on that.
353 00:34:57.450 ⇒ 00:35:03.700 Awaish Kumar: So whatever is in the one pass is output of this step, one
354 00:35:03.950 ⇒ 00:35:10.830 Awaish Kumar: in the step one. I’m generating a key pair which basically generates a private key and a public key, right?
355 00:35:12.130 ⇒ 00:35:16.319 Awaish Kumar: So that that I already generated and I have.
356 00:35:16.690 ⇒ 00:35:27.589 Awaish Kumar: I have provided a private public key to the service user account, which is in Snowflake. That’s why we don’t need to regenerate this again and again. Because.
357 00:35:28.194 ⇒ 00:35:37.099 Awaish Kumar: we already generated one which we are sharing with each other. So for that reason we have to use these
358 00:35:37.400 ⇒ 00:35:44.090 Awaish Kumar: public and private public private key. And this is the public key, right? So
359 00:35:44.420 ⇒ 00:35:47.569 Awaish Kumar: this is the output of you can say the step number one.
360 00:35:48.020 ⇒ 00:35:49.680 Annie Yu: But when you.
361 00:35:49.810 ⇒ 00:35:52.710 Awaish Kumar: But after that there’s a step number 2,
362 00:35:52.940 ⇒ 00:35:55.000 Awaish Kumar: and then there is shipment with we.
363 00:35:55.170 ⇒ 00:35:58.050 Awaish Kumar: So you have to run, save number 2, and
364 00:35:58.420 ⇒ 00:36:02.049 Awaish Kumar: after you run the step number 2, you will get some output.
365 00:36:02.280 ⇒ 00:36:08.509 Awaish Kumar: So you have to copy that output. Just just as as I mentioned here, copy the output right.
366 00:36:08.620 ⇒ 00:36:18.890 Awaish Kumar: Once you run this command on your private key, you will have some output, copy that output and paste it at this place. This will.
367 00:36:19.280 ⇒ 00:36:26.130 Awaish Kumar: so this will go into your Dsn. Like the slow flight connection as the private key parameter, and that is this one.
368 00:36:28.220 ⇒ 00:36:28.920 Annie Yu: So.
369 00:36:28.920 ⇒ 00:36:32.160 Awaish Kumar: The last last part of this sorry.
370 00:36:32.360 ⇒ 00:36:39.979 Annie Yu: Then for the username, you are saying, Okay, I I just ran that. And so I I do have some output here. Now.
371 00:36:39.980 ⇒ 00:36:43.249 Awaish Kumar: This. This is the user date. That’s I’m saying that this.
372 00:36:43.570 ⇒ 00:36:47.499 Awaish Kumar: the the heading of this private key is is the username.
373 00:36:47.730 ⇒ 00:36:54.610 Annie Yu: Okay, and including including the space snowflake, or just up.
374 00:36:54.610 ⇒ 00:36:57.670 Awaish Kumar: No, no, no, just the internal service user reader.
375 00:36:59.140 ⇒ 00:37:07.690 Annie Yu: Bye and that you have to specify.
376 00:37:08.290 ⇒ 00:37:13.490 Awaish Kumar: This one. Yeah, this one is the institution.
377 00:37:15.890 ⇒ 00:37:16.720 Annie Yu: Let me!
378 00:37:16.720 ⇒ 00:37:23.369 Awaish Kumar: Use that one out and use output of this command and then generate a connection like this.
379 00:37:24.230 ⇒ 00:37:35.040 Awaish Kumar: Here’s an example from ABC. How it should work, and you don’t have to perform step number 4, because
380 00:37:35.190 ⇒ 00:37:36.989 Awaish Kumar: I’ve already done that.
381 00:37:38.420 ⇒ 00:37:41.679 Annie Yu: But then, yeah, that’s what I tried.
382 00:37:42.370 ⇒ 00:37:52.909 Annie Yu: Okay, I I have a new string that I’m updating now in the setting. This is what I just ran and used
383 00:37:54.451 ⇒ 00:37:58.670 Annie Yu: yeah, you can refresh now, and you’ll you’ll see that.
384 00:38:00.720 ⇒ 00:38:22.910 Annie Yu: So I specify that username. And then the ad and raw polyatomic, so polyatomic. Linear warehouse.
385 00:38:34.200 ⇒ 00:38:35.759 Annie Yu: Yeah, I think I’m following.
386 00:38:35.760 ⇒ 00:38:38.520 Awaish Kumar: It only includes warehouse. It does not include room.
387 00:38:38.650 ⇒ 00:38:44.340 Awaish Kumar: I’m not sure where my the this example.
388 00:38:45.440 ⇒ 00:38:49.969 Awaish Kumar: Okay, hey, this basically includes role. But yeah, it’s not necessary.
389 00:38:50.660 ⇒ 00:38:56.950 Awaish Kumar: But this one is important. Authenticator is so flex. Jwt.
390 00:38:57.660 ⇒ 00:39:00.143 Annie Yu: So I should follow that
391 00:39:01.250 ⇒ 00:39:03.210 Awaish Kumar: That’s okay. I think if it’s.
392 00:39:04.870 ⇒ 00:39:05.820 Annie Yu: Wrong.
393 00:39:05.820 ⇒ 00:39:17.019 Awaish Kumar: Warehouse control, and then authenticators. So you run. This is the output of this command, right.
394 00:39:17.020 ⇒ 00:39:20.180 Annie Yu: Yes, I I just. I just ran it and then copy it.
395 00:39:20.180 ⇒ 00:39:23.989 Awaish Kumar: Okay, so how to test it? Right? If it’s working
396 00:39:26.608 ⇒ 00:39:31.269 Awaish Kumar: so you actually, it worked right? You just got all these modern
397 00:39:31.620 ⇒ 00:39:35.429 Awaish Kumar: channels has users from? Are they from linear or not?
398 00:39:37.658 ⇒ 00:39:41.339 Annie Yu: I don’t know. What. What do you? What you mean?
399 00:39:41.680 ⇒ 00:39:45.929 Awaish Kumar: Oh, okay, no like. Now, we added this
400 00:39:46.040 ⇒ 00:39:52.559 Awaish Kumar: snowflake connection. Now, how to test right in the room if it is connected or not.
401 00:39:53.590 ⇒ 00:40:00.250 Annie Yu: I I can share. Is that a question for me? I I can show you how I tested.
402 00:40:01.330 ⇒ 00:40:08.360 Awaish Kumar: Yeah, like. So now you have. Added the connection. If you now do something, then we can see if it’s working or not.
403 00:40:08.360 ⇒ 00:40:16.110 Annie Yu: Yeah, yeah. And I can share my screen. I I haven’t pushed anything. But I have a source yellow file. Okay.
404 00:40:16.900 ⇒ 00:40:20.859 Annie Yu: I have a can you see my screen?
405 00:40:21.780 ⇒ 00:40:28.018 Annie Yu: I have this. So I just that’s the the whole string that I I put in the
406 00:40:29.180 ⇒ 00:40:37.300 Annie Yu: in here, and then I have a source file here where I type in here and then
407 00:40:37.800 ⇒ 00:40:40.170 Annie Yu: saying that this decode failed.
408 00:40:41.140 ⇒ 00:40:43.490 Annie Yu: So that’s how that’s how I tested.
409 00:40:47.850 ⇒ 00:40:50.360 Annie Yu: So this will reflect how this.
410 00:40:50.860 ⇒ 00:40:57.210 Annie Yu: how this is. So let’s say I cut it okay and save
411 00:40:57.720 ⇒ 00:41:04.820 Annie Yu: and then, now it’s saying missing. So then I add this back in save.
412 00:41:05.280 ⇒ 00:41:08.420 Annie Yu: and then, not saying this, still fails.
413 00:41:09.720 ⇒ 00:41:11.670 Awaish Kumar: This is, what source.
414 00:41:12.570 ⇒ 00:41:13.330 Annie Yu: Yes.
415 00:41:14.170 ⇒ 00:41:20.500 Awaish Kumar: Can you push it to? To the because I
416 00:41:20.880 ⇒ 00:41:23.521 Awaish Kumar: this was not working for
417 00:41:25.110 ⇒ 00:41:31.830 Awaish Kumar: look in the local machine, but it worked in the cloud version. So can you push this.
418 00:41:32.340 ⇒ 00:41:39.900 Annie Yu: Like push without, because I usually just do Pr. And I don’t really know if there’s another way.
419 00:41:40.790 ⇒ 00:41:48.280 Awaish Kumar: Yeah, you create a Pr with simple, like, simple model, or something which we can see in the.
420 00:41:51.950 ⇒ 00:41:53.250 Annie Yu: Think this one.
421 00:41:54.140 ⇒ 00:41:57.280 Awaish Kumar: Which you can just merge and test right if it’s working or.
422 00:41:58.320 ⇒ 00:41:59.030 Annie Yu: Okay.
423 00:42:04.650 ⇒ 00:42:06.310 Annie Yu: and what?
424 00:42:06.810 ⇒ 00:42:08.699 Awaish Kumar: You don’t have to push the private key.
425 00:42:10.901 ⇒ 00:42:15.270 Annie Yu: Yeah, I did not. I did not. I just pushed this this one source file.
426 00:42:16.500 ⇒ 00:42:17.300 Awaish Kumar: Okay.
427 00:42:20.070 ⇒ 00:42:22.659 Annie Yu: But then, where do I go?
428 00:42:26.060 ⇒ 00:42:27.600 Awaish Kumar: Our project wasn’t true.
429 00:42:30.010 ⇒ 00:42:34.849 Annie Yu: This you on? Github? Okay?
430 00:42:35.750 ⇒ 00:42:36.370 Annie Yu: Yeah.
431 00:42:36.370 ⇒ 00:42:38.319 Awaish Kumar: Okay, so yeah, that’s great.
432 00:42:39.370 ⇒ 00:42:40.420 Awaish Kumar: Yeah.
433 00:42:48.170 ⇒ 00:42:49.556 Awaish Kumar: Yeah, just
434 00:42:53.170 ⇒ 00:42:57.930 Awaish Kumar: okay. And also for you can test check in the ABC
435 00:42:58.050 ⇒ 00:43:07.460 Awaish Kumar: project, or like, open any environment file for ABC like, and see like how Luke was connecting.
436 00:43:07.820 ⇒ 00:43:15.250 Annie Yu: I did. That’s why I think I followed everything. That’s how I got the whole string.
437 00:43:15.730 ⇒ 00:43:18.189 Annie Yu: And then I I did check the ABC.
438 00:43:18.190 ⇒ 00:43:21.585 Awaish Kumar: Have you seen? Hey? We see any.
439 00:43:26.250 ⇒ 00:43:32.290 Awaish Kumar: Any like source which would just gets data for that’s all.
440 00:43:36.060 ⇒ 00:43:39.159 Awaish Kumar: Should we see a real project? Yeah.
441 00:43:47.170 ⇒ 00:43:47.760 Annie Yu: Right?
442 00:43:48.330 ⇒ 00:43:57.140 Annie Yu: So here, the ABC one, yeah, I also check this. And then so the source when it’s working it should
443 00:43:57.580 ⇒ 00:43:59.919 Annie Yu: load with no no red.
444 00:44:06.520 ⇒ 00:44:09.110 Awaish Kumar: But it’s reading from Snowflake and.
445 00:44:09.440 ⇒ 00:44:11.599 Annie Yu: Yeah, like, just like this.
446 00:44:12.810 ⇒ 00:44:13.720 Annie Yu: And it’s.
447 00:44:14.410 ⇒ 00:44:26.439 Annie Yu: I think we, I bet we can refresh this anymore. But yeah, I copy. I copied all these and then do that in the data platform.
448 00:44:28.210 ⇒ 00:44:33.100 Awaish Kumar: Okay, so is it. Did you merge the Pr.
449 00:44:34.308 ⇒ 00:44:35.850 Annie Yu: Not yet. Should I? Just.
450 00:44:35.850 ⇒ 00:44:41.380 Awaish Kumar: Yeah, we, yeah, there’s nothing much. Just.
451 00:44:41.756 ⇒ 00:44:42.133 Annie Yu: Okay.
452 00:44:46.040 ⇒ 00:44:46.810 Annie Yu: Okay.
453 00:44:49.220 ⇒ 00:44:52.499 Awaish Kumar: Okay, can now receive that in real cloud.
454 00:44:52.500 ⇒ 00:44:54.839 Annie Yu: Let me. I think we have to.
455 00:44:55.360 ⇒ 00:44:58.560 Annie Yu: We’ve leave one.
456 00:45:00.000 ⇒ 00:45:07.820 Awaish Kumar: But yeah, we but that we were just now looking in real cloud, not your local, a little machine.
457 00:45:08.370 ⇒ 00:45:10.109 Annie Yu: Oh, wait! What’s the difference?
458 00:45:10.960 ⇒ 00:45:15.980 Awaish Kumar: Yeah, because we we deployed it to production. It’s now it should.
459 00:45:16.380 ⇒ 00:45:17.830 Awaish Kumar: If you open real.
460 00:45:18.390 ⇒ 00:45:19.130 Annie Yu: Hmm!
461 00:45:19.890 ⇒ 00:45:22.670 Annie Yu: Oh, you mean go to real here.
462 00:45:22.910 ⇒ 00:45:27.909 Awaish Kumar: But real cloud slack analytics. It’s not connected to Github, is it?
463 00:45:29.980 ⇒ 00:45:34.520 Annie Yu: I thought it. I thought it was. I think so.
464 00:45:34.520 ⇒ 00:45:36.029 Awaish Kumar: How do we open the status?
465 00:45:36.760 ⇒ 00:45:39.810 Awaish Kumar: Can you see in the real real cloud status.
466 00:45:40.650 ⇒ 00:45:42.719 Annie Yu: Where to see that status.
467 00:45:42.720 ⇒ 00:45:46.456 Awaish Kumar: Stated, yeah, it’s not, is it?
468 00:45:47.780 ⇒ 00:45:49.470 Annie Yu: I don’t know. It says that.
469 00:45:51.460 ⇒ 00:45:59.100 Annie Yu: Let me see. Let’s see. ABC, okay it is.
470 00:45:59.270 ⇒ 00:46:01.080 Annie Yu: And then now it isn’t.
471 00:46:01.080 ⇒ 00:46:09.060 Awaish Kumar: It’s not so. It’s not connected to Github. I don’t know where these, how you deployed them. There.
472 00:46:09.320 ⇒ 00:46:14.170 Awaish Kumar: the select data. How how is it deployed from local machine.
473 00:46:14.520 ⇒ 00:46:20.140 Annie Yu: I I don’t think so. I these are not done by me, so I don’t know.
474 00:46:21.040 ⇒ 00:46:29.670 Awaish Kumar: Yeah, like. But Luke did deploy the slack analytics without connecting to Github. So he must have deployed from the local machine.
475 00:46:30.000 ⇒ 00:46:30.590 Annie Yu: Oh!
476 00:46:31.390 ⇒ 00:46:38.739 Awaish Kumar: You can search for that and see like, if you can just deploy this single source
477 00:46:39.580 ⇒ 00:46:48.430 Awaish Kumar: to cloud, then I can then further see issue with the connection string.
478 00:46:50.870 ⇒ 00:46:55.479 Awaish Kumar: If you can just search in Chat Gpt and ask like how to deploy.
479 00:46:55.650 ⇒ 00:47:01.790 Awaish Kumar: I have source inland data. I want to deploy it, Cloud, how to do that, and that’s all.
480 00:47:05.080 ⇒ 00:47:08.860 Awaish Kumar: And I have to finish some Indian work. So I I will get.
481 00:47:09.440 ⇒ 00:47:11.759 Awaish Kumar: I can pair sometime later.
482 00:47:13.010 ⇒ 00:47:19.890 Annie Yu: Okay, okay, alright. So it’s.
483 00:47:21.450 ⇒ 00:47:24.919 Awaish Kumar: Just search like just Google it or chat. Ask chat. Jbd.
484 00:47:24.920 ⇒ 00:47:25.420 Annie Yu: Yeah.
485 00:47:25.420 ⇒ 00:47:28.104 Awaish Kumar: Deploy this thing, and then we I can.
486 00:47:30.681 ⇒ 00:47:35.348 Awaish Kumar: once it is there. Just let me know, and I can then work on this
487 00:47:36.930 ⇒ 00:47:39.950 Awaish Kumar: private key thing. Okay?
488 00:47:41.850 ⇒ 00:47:42.710 Annie Yu: Okay.
489 00:47:43.190 ⇒ 00:47:43.610 Awaish Kumar: Thank you.