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]
Snowflake | Data prep | Tool strategy