Default Snowflake Virtual Warehouse support: New in Tableau 2021.1

0:00Hey, it's Tim here. In Tableau 2021.1,

0:03Tableau added the ability for Tableau to

0:05support virtual

0:06warehouses in Snowflake. Now, at first I

0:09was initially confused because Snowflake

0:11call

0:12all their warehouses virtual warehouses. So

0:14I was sort of confused when I sort of read

0:16this message and I saw, well, what do they

0:18actually mean by this? So I had a little

0:20bit

0:20of a play around and I think I've managed

0:21to figure it out. So you can see here that

0:23beginning in 2021, Tableau automatically

0:26uses your default Snowflake virtual

0:28warehouse.

0:29If none is specified. So let me show you

0:32this behavior first, then I'll show you how

0:34to

0:34find out which is your default virtual

0:36warehouse in Snowflake. Okay, so let's go

0:39over to Tableau

0:40Online here and I'm just going to open up a

0:43basically a new workbook in the browser.

0:45So I'm going to go create a workbook. And

0:48the first thing we're going to do is

0:48connect

0:49to a data source. Now, not many people know

0:51this, but actually the third option here is

0:52the connectors and there's a whole host of

0:55connectors. In 2020.1, they've actually

0:57added

0:57a few more connectors that you can connect

0:59to directly here from the browser. Okay, we

1:02're

1:02going to go ahead and just connect to Snow

1:04flake. And what I need to do is essentially

1:05get a

1:06few bits of information. So let me get my

1:08Snowflake server URL. Let's just put that

1:10in there. Use a username and password. And

1:13for this, I'm just going to probably select

1:15this one, hit tab, that should take me to

1:18the new window. So I can enter my password

1:23Tableau Tim, TMMD. And in here, I just need

1:27to enter the password. I'm going to sort of

1:31probably skip this and blur it all out. But

1:33once you're signed in, you'll see that you

1:36get this successful notification. And the

1:38key thing here is this particular step, you

1:41can see here that select the warehouse is

1:43now optional, it wasn't required before.

1:46Okay,

1:47so what we can now do is go ahead, just

1:49skip that question, just tell Tableau which

1:51database

1:52you want to work, what connect to, there's

1:54no warehouse selected. So let's just choose

1:56a Snowflake sample data set. And let's just

1:59go choose a reasonably small schema, going

2:02to drag in a few things. And I'm just going

2:04to drag in the orders and the customer key,

2:06create a simple relationship here between

2:09those two using the customer key, hit close

2:11,

2:11and then go straight to sheet one. And I'm

2:14going to do a very basic count of records

2:17here for orders 150 million rows read in.

2:20So we're pretty much done there. Now, you

2:23're

2:24probably wondering, well, I didn't specify

2:26the warehouse. So how do I find out which

2:27warehouse was actually used for that query?

2:29Well, if we head over to Snowflake, you'll

2:31see this as my list of databases, I'm

2:34actually going to go here to my the role

2:36that I'd actually

2:37be using in this particular instance, in

2:39this particular setup, I'm only the only

2:42one here.

2:42So if I go to my history tab, I can

2:44actually see all the queries that I've just

2:47done. And

2:47you can see here that it's used the small

2:50and it's used the default compute warehouse

2:52.

2:52Now you're probably wondering, well, why

2:54did it use that particular warehouse? Well,

2:56the

2:56key thing is essentially to do with the

2:58settings. So let me just refresh and make

3:00sure that

3:01is the most recent one. Yeah, definitely

3:03use the small warehouse. And if I just do

3:05this,

3:06I can actually see that I queried all the

3:08orders. So if I actually go into this, and

3:11let's just let's just open this query up,

3:14you can see here that we do a simple count

3:16of orders there. And it's it's really sort

3:18of simple to see. Now, to find out which is

3:21your default data set, what you need to do

3:23is essentially go to an admin role. And

3:26essentially,

3:27this role I'm on isn't actually senior

3:28enough to be able to see that. So if I go

3:30to account

3:31admin, one thing I can then do is basically

3:34go to this account tab here. And it gives

3:37me a lot more information about what's

3:39going on. Okay. And what I can do is

3:41essentially

3:41go to users and I can see myself here is

3:43Tableau Tim TnMD. And you can see my

3:46default warehouse

3:47is the compute warehouse. So this is how

3:49you find out what your default warehouse is

3:51. Essentially,

3:52when a user logs in, it's going to use

3:54their default warehouse. Now, that's not

3:56the only

3:56reason that Snowflake will use to compute a

3:59default warehouse. There's actually this

4:01really nice guide here that gives a

4:03criteria in which it's going to work

4:04through. And so

4:05you can see here that the first one here

4:07overridden, this particular one default

4:09warehouse for

4:10the user is the first thing it checks. It's

4:13then overridden by another default if it's

4:16specified for the particular client, let's

4:18say I'm using snow sequel JDBC, whatever,

4:21that's then overrides the previous one. And

4:23then that is again overridden by the

4:25default

4:25warehouse specified on the client command

4:27line, or through the driver connector

4:29parameters

4:29used to Snowflake. So essentially, if I

4:32specifically specify one, that's what it

4:34will use instead.

4:35So if in tab, I'd selected a warehouse,

4:38this particular option here, number three

4:42would

4:42have actually been the one that would

4:44choose my warehouse. So that's how the

4:46default warehouse

4:47is decided by Snowflake and Tableau in

4:49conjunction with each other. So that's a

4:52nice sort of

4:53small quality of life improvement. If you

4:55Snowflake a lot, you no longer need to be

4:57picking things as long as you've got your

4:58defaults intelligently set up, it's not

5:00going

5:00to go crazy. Now, the reason you'd want to

5:03choose your warehouse is let's say I'm

5:05working

5:05on a really big workbook. And I know that

5:08my default warehouse is not really sort of

5:10geared up for the challenge. What I can

5:12then do is come here and choose my more

5:14powerful

5:15warehouse because that's actually going to

5:17give me more compute and more resources for

5:19the, you know, response for the server to

5:22be nice and zippy when I'm querying the

5:24database.

5:25So that's pretty much it for this video.

5:26There's not much more to that. I was just

5:27sort of

5:28curious how that sort of dynamic work and I

5:29managed to figure it out. So I thought I'd

5:31share it with you. Thanks for watching.

5:33Check out some of the other videos on this

5:35playlist

5:35about 2020.1 features and I'll catch you in

5:38the next video.

5:39[Music]