WEBVTT NOTE This file was generated by Descript 00:00:00.000 --> 00:00:01.109 C922 Pro Stream Webcam & C922 Pro Stream Webcam-1: Hi, I'm Erica, Lena. 00:00:01.109 --> 00:00:03.959 And today I've got to walk you through how to set up the snowflake pack for Coda. 00:00:04.559 --> 00:00:08.250 Setting it up requires a bunch of different steps from different actors. 00:00:08.529 --> 00:00:10.660 So follow along with me and I'll show you how to do this 00:00:10.660 --> 00:00:12.219 process from start to finish. 00:00:12.219 --> 00:00:12.549 C922 Pro Stream Webcam & C922 Pro Stream Webcam-2: All right. 00:00:12.549 --> 00:00:15.340 So let's pretend I'm a coded user and in my doc and I want 00:00:15.340 --> 00:00:16.599 to use the snowflake pack. 00:00:17.169 --> 00:00:18.399 I can click the insert menu. 00:00:18.399 --> 00:00:19.869 I search for snowflake. 00:00:21.219 --> 00:00:22.240 And there's the pack. 00:00:23.259 --> 00:00:25.569 Now, we'll see here that request access button. 00:00:26.109 --> 00:00:30.039 Even if you're not limiting what packs people can use because the snowflake 00:00:30.069 --> 00:00:31.659 pack requires some extra setup. 00:00:32.110 --> 00:00:33.789 All users will see this button to start. 00:00:34.360 --> 00:00:39.009 So a user may request access saying I'd really like to use this pack. 00:00:40.989 --> 00:00:42.160 And send a request. 00:00:43.209 --> 00:00:43.989 For the user. 00:00:44.019 --> 00:00:46.690 Now it's just wait to see how that request is handled. 00:00:46.690 --> 00:00:47.020 All right. 00:00:47.020 --> 00:00:49.900 So now I'm the Coda admin, and I've got an email saying that someone 00:00:49.900 --> 00:00:50.919 would like to use this pack. 00:00:51.550 --> 00:00:53.889 Clicking the button will take you into the Coda UI. 00:00:54.220 --> 00:00:56.020 Where you can then review that request. 00:00:56.560 --> 00:01:00.550 If you're using pack approvals, you probably familiar with this screen, but 00:01:00.550 --> 00:01:02.109 if not, it may be a little new to you. 00:01:02.609 --> 00:01:05.340 I can expand the details of their quest to see which user. 00:01:05.669 --> 00:01:08.160 May the request and what their justification is. 00:01:08.770 --> 00:01:11.919 You can approve a snowflake pack and start setting it up by using the configure 00:01:11.919 --> 00:01:15.489 manually button here, or if it gives her hasn't requested it, you can actually 00:01:15.489 --> 00:01:17.289 just search for it in the box below. 00:01:17.739 --> 00:01:18.939 Find the snowflake pack. 00:01:19.509 --> 00:01:22.569 And expand it to start the configuration process. 00:01:23.080 --> 00:01:25.719 Now, what you see here is that snowflake does have special 00:01:25.719 --> 00:01:27.489 requirements compared to other packs. 00:01:27.909 --> 00:01:28.960 And this learn more link. 00:01:28.960 --> 00:01:31.899 It takes you to our help center, where you can get the specific set 00:01:31.899 --> 00:01:33.369 of steps required to set it up. 00:01:33.609 --> 00:01:35.619 And we're going to be using this throughout the process. 00:01:36.249 --> 00:01:40.090 As this article details in order to set up the pack, you need your snowflake admin 00:01:40.090 --> 00:01:43.900 to create some settings on their side before you can finish the setup and Coda. 00:01:44.050 --> 00:01:47.140 So send this article over to your snowflake admin so they can 00:01:47.140 --> 00:01:48.460 take care of their tests first. 00:01:49.140 --> 00:01:51.750 All right now I'm a snowflake admin, and I got this article. 00:01:51.779 --> 00:01:54.870 I want to go down to the section here on adding a security 00:01:54.870 --> 00:01:55.919 integration of snowflake. 00:01:56.580 --> 00:02:00.149 Well, you're essentially doing is creating a new set of credentials that 00:02:00.149 --> 00:02:04.589 the snowflake pack can use to access your specific snowflake instance. 00:02:05.179 --> 00:02:07.790 This process uses standard snowflake queries that your 00:02:07.790 --> 00:02:09.230 admin may be familiar with. 00:02:09.440 --> 00:02:11.660 But we also have included here in the documentation. 00:02:11.960 --> 00:02:14.540 A pattern for the exact type of query they'll need to run. 00:02:15.239 --> 00:02:15.480 All right. 00:02:15.480 --> 00:02:18.840 So as a snowflake admin, the first queer I have to run is to create the integration. 00:02:19.169 --> 00:02:20.399 I copied this out of the docks. 00:02:20.429 --> 00:02:24.329 And the only thing I changed here, what roles I want to pre-authorize to use 00:02:24.359 --> 00:02:27.879 this integration, everything else I can leave the same and execute the command. 00:02:29.469 --> 00:02:29.769 All right. 00:02:29.799 --> 00:02:31.839 I've now created my new integration. 00:02:31.839 --> 00:02:32.889 Any back to the documentation. 00:02:32.920 --> 00:02:35.199 The next step is to get the secrets for this new integration. 00:02:38.199 --> 00:02:39.099 I can run this command. 00:02:40.390 --> 00:02:44.320 And what will be output are a client ID and two client secrets. 00:02:44.800 --> 00:02:47.380 I want to take these and send them back to my COTA admin, 00:02:47.440 --> 00:02:48.700 to complete the process there. 00:02:49.240 --> 00:02:51.100 C922 Pro Stream Webcam & C922 Pro Stream Webcam-3: Now action goes back to the code admin 00:02:51.250 --> 00:02:54.640 who uses those snowflake credentials to build a pack configuration. 00:02:55.030 --> 00:02:55.600 To do that. 00:02:55.630 --> 00:02:57.910 Let's start by clicking the add new configuration button. 00:02:59.330 --> 00:03:01.070 Start by giving your configuration a name. 00:03:01.550 --> 00:03:05.180 When you have multiple configurations, this helps identify which specific 00:03:05.180 --> 00:03:08.750 groups or level of access this configuration allows here. 00:03:08.750 --> 00:03:10.430 Let's just say, this is all access. 00:03:11.430 --> 00:03:15.750 Next choose which group of users can use this configuration in their docks. 00:03:16.050 --> 00:03:19.050 The default everyone can use, or you can switch to selecting 00:03:19.080 --> 00:03:21.060 individual users or groups. 00:03:21.390 --> 00:03:24.120 Those groups could be sinked in from your identity provider, 00:03:24.300 --> 00:03:26.550 like Okta, Microsoft, et cetera. 00:03:27.330 --> 00:03:30.060 In this case, I'll go back to say, everyone can use this configuration. 00:03:31.060 --> 00:03:35.110 Next you want to complete the URL to your specific snowflake instance. 00:03:35.380 --> 00:03:37.210 Your snowflake admin can provide this. 00:03:37.690 --> 00:03:40.120 But it's just going to be a unique ID. 00:03:40.450 --> 00:03:42.400 In front of a snowflake computing.com. 00:03:43.520 --> 00:03:46.940 Next you want to specify under which snowflake role users should connect. 00:03:47.330 --> 00:03:51.020 This allows you to control exactly what types of data are brought into Coda. 00:03:51.620 --> 00:03:53.990 So that maybe your most sensitive data stays, locked up. 00:03:54.560 --> 00:03:57.980 In this case, I created a roll call pack user, but this will be whatever 00:03:57.980 --> 00:03:59.300 your snowflake admin sets up. 00:04:00.300 --> 00:04:02.310 With that the base configuration is done. 00:04:03.990 --> 00:04:07.410 But we'll still have a little red exclamation point here because we 00:04:07.410 --> 00:04:09.300 haven't finished setting up VOR. 00:04:09.360 --> 00:04:12.540 So click the three dots and click off settings. 00:04:13.020 --> 00:04:16.290 And here we have just a couple of keys that we need to enter. 00:04:16.320 --> 00:04:18.720 This is what the snowflake admin just created for us. 00:04:19.170 --> 00:04:20.850 So I'll paste in our client ID. 00:04:21.720 --> 00:04:24.360 And our clients secret that were generated in snowflake. 00:04:25.560 --> 00:04:26.160 And hit save. 00:04:28.890 --> 00:04:32.040 With that our configuration is set up and we're ready for the user to try it out. 00:04:33.040 --> 00:04:33.310 C922 Pro Stream Webcam & C922 Pro Stream Webcam-2: Okay. 00:04:33.340 --> 00:04:35.320 The Cody user who originally made the request. 00:04:35.350 --> 00:04:37.270 I got an email saying the pack is ready to use. 00:04:37.300 --> 00:04:38.080 Let's try it out. 00:04:38.740 --> 00:04:42.550 So click the stuff like pack and now says, add to doc because I've been approved. 00:04:44.770 --> 00:04:47.350 I can expand this query table connect to snowflake. 00:04:48.100 --> 00:04:48.670 And sign in. 00:04:57.970 --> 00:04:59.020 I can say complete setup. 00:05:00.130 --> 00:05:03.070 And I have now connected my account and I'm ready to start making a query. 00:05:04.729 --> 00:05:07.369 I hope this has given you a good idea about what to expect when setting 00:05:07.369 --> 00:05:08.779 up the snowflake pack for Coda. 00:05:09.110 --> 00:05:12.770 If you have any questions or run into any issues along the way, please reach out. 00:05:12.770 --> 00:05:16.070 We're here to help you get this up and running, and good luck.