How to run Tableau Prep flows in the command line 2020.3 & later

0:00Hey, it's Tim here. And in today's video, I

0:01'm going to be showing you how to run Table

0:03au prep in the Windows command line.

0:05Now, this is a great way of starting to

0:07automate some of the prep flows on your

0:09machine and starting to sort of understand

0:11if something like the data management add

0:13on with a lot more automation might

0:15actually be something useful in your

0:17organization.

0:18Now, as you can see on the screen, I'm

0:19actually using Tableau 2020.3. If you've

0:22got a slightly older version, you'll need

0:24to head to the description and look at the

0:26documentation that I linked to there, it

0:27will show you how to use this for slightly

0:29older versions.

0:30There's some slight modifications. If I go

0:32to the Tableau documentation page here, and

0:34I just scroll down, they show you very,

0:36very clearly what to do with slightly older

0:39versions.

0:39So this is actually what you want to follow

0:41if you're doing that. But if you're using

0:43the latest version of Tableau prep, you're

0:45in the right place.

0:46Now, the other thing I want to do is I want

0:48to show you the three different scenarios,

0:50you typically run Tableau prep in an

0:52automated way.

0:53The first is essentially just a simple

0:55workflow, or simple flow on your desktop

0:58that you just run, the inputs are located

1:00on your machine, and the output is located

1:02in the machine. Very simple.

1:04The second is actually when the inputs are

1:06located on your machine, but the outputs

1:09are located in Tableau online or Tableau

1:11server.

1:12And the final one I'll do is where the

1:14input is essentially a database and the

1:16output is essentially a published data

1:18source to Tableau server.

1:20But of course, the output can also be a

1:21database in this specific scenario.

1:24So those are the three things I'm going to

1:25cover. We're going to start with the first

1:27one.

1:27Okay, so I'm a bit of a Mac fanboy. So I'm

1:29gonna actually have to switch over to my

1:31virtualized version of Windows, where I'm

1:33actually running a Postgres database

1:35instance in the background.

1:37This will come in handy later. Stay tuned

1:39to find out more about that. Okay, so this

1:41is essentially a very simple setup that I

1:43've got on my folder.

1:44And you can see that I've already got some

1:46directories open. Now, these directories

1:49actually quite handy in Tableau's own

1:51documentation, they actually make sure that

1:53you know these up front.

1:55So the first one is essentially the

1:57installation directory of Tableau prep.

2:00And specifically in that folder, there's a

2:02script folder. So if I just go back one

2:04hierarchy here to the Tableau directory in

2:06your installation folder for all programs

2:09in your computer, you'll see that Tableau

2:11prep builder 2020.3.

2:13If I click in on that, then I go to the

2:15script folder, you'll see that Tableau have

2:17this Tableau prep CLI little batch file

2:20here.

2:21And this is actually what runs all the

2:22automations on your behalf. It's actually

2:25using a little bit of technology in the

2:26background called Java to do all the

2:28running in the background for you.

2:30Now the other thing you're going to need to

2:32hand is the folder with your prep flows and

2:34your inputs and outputs.

2:36So I've actually run this a little bit

2:37earlier on. If I go to my outputs folder,

2:39you'll see that it's empty.

2:41And this is what we want because we're

2:42going to be running these in the background

2:44, you won't see Tableau prep open at any

2:46point at all.

2:47Now, if I just go back one more, you'll see

2:49that I have some flows. If I go into that

2:51folder, you see I've been a little bit more

2:53organized.

2:54And I've got the three flows I talked about

2:56with the three different scenarios. Now the

2:58other thing you'll see is that I've

2:59actually got some other files here.

3:01And they are called essentially online cred

3:04s, and DB slash online creds.

3:06Now, if you're security buffing, you're

3:08probably panicking right now because you're

3:10probably hoping that in there is not my

3:12username and password.

3:13Unfortunately, that's exactly what's in

3:15there.

3:15So if this isn't your kind of thing, if

3:17security is not going to let you do this,

3:19then this isn't going to work for you.

3:20Something like Tableau prep conductor as

3:22part of the data management add on is

3:24probably going to be the better option here

3:26.

3:26So you can do this in a much, much more

3:28secure and governed way.

3:29But if you're just running something on

3:31your laptop, you just need to automate

3:33something very, very quickly.

3:34And you're the only person with access to

3:36your laptop, and this is a solution that

3:38can work for you.

3:39Now, these online credential files are

3:42essentially just JSON files.

3:44And these JSON files contain information,

3:46you can actually see that I've got one here

3:48in the background.

3:49So let's just have a look at the anatomy of

3:50this very, very quickly.

3:51Now, the very top, you've got a section for

3:54Tableau connections.

3:55This is basically for connections to Table

3:58au server or Tableau online.

4:00And the thing I want to call out here is if

4:02you're connecting to Tableau server, it's

4:04actually quite straightforward.

4:05You just get the URL of your Tableau server

4:07, and that's what you put here in the very

4:09sort of top section.

4:11But if you're connecting to Tableau online,

4:13you don't actually use the traditional

4:15online dot Tableau dot com URL.

4:18You need to know the specific pod that your

4:20Tableau online server runs in.

4:22Now, the pod is essentially just the AWS

4:24cluster or the specific sort of environment

4:27that the Tableau online instance runs on.

4:29And actually, if you've ever logged into

4:30Tableau online, you'll see that the URL

4:32changes to reflect this pod.

4:34So here I've actually copied that on here.

4:37So I actually have a Tableau online dev

4:39instance that's located in America.

4:41So the URL is actually reflecting that.

4:43So 10 AX online is an instance that runs as

4:46a dev instance that runs in America.

4:49And that's my own specific instance.

4:51Now, the other thing to note is this

4:54content URL.

4:55Now, when you log into a Tableau server,

4:57you typically have something called a site.

4:59But on Tableau online, this is just

5:02actually a generic sort of short URL or

5:05short parameter that's added to specify

5:09where in Tableau online your particular

5:11environment is.

5:12If I switch back to Mac here and I switch

5:14over to this tab, you'll see here that at

5:17the top, the URL is essentially, as I

5:19mentioned before, 10 AX online dot Tableau

5:21dot com.

5:22But the other thing you can see here is

5:24this short statement that says site, which

5:26is essentially pointing to my specific

5:28environment and Tableau online.

5:30And then this sort of code here that

5:32specifies what my Tableau online instance

5:35actually is.

5:36It's essentially like a folder on a server.

5:38And so that specifies my specific server.

5:41I need to make sure that that's what I copy

5:43into this content URL section.

5:45Now, the last few things you need to set up

5:47is the port, port 443 is the standard sort

5:50of port to open up.

5:51You can also open up port 83.

5:53But if you follow the Tableau documentation

5:54, those are the two ports that you can use.

5:56The username and password.

5:58This is what I said the security guys

6:00wouldn't be a fan of.

6:01Having username and password in plain text

6:04on your machine is not a good idea.

6:07If you're the only person who has access to

6:09your laptop, then you might just get away

6:11with it.

6:11But in security terms, this is not best

6:13practice.

6:13So by all means, don't take this as advice

6:16to go ahead and do this.

6:17But again, if you're just running this on

6:19your machine, then this should be fine as

6:21long as you're the only one with access to

6:23your machine.

6:24Now, the other thing you can see here is a

6:26database connection section.

6:28Now, this is essentially just where we put

6:30information about our database and where it

6:33is, because if you think about it, we're

6:35going to run this flow.

6:36And what we won't be doing is opening up

6:38Tableau prep and logging in.

6:40So Tableau prep is going to need to know

6:42whether the person running this flow

6:45actually has the rights to go and look at

6:47this data.

6:48So the only way you can do that is by

6:50specifying it in this document.

6:52So here you can see that I've actually got

6:54a local Postgres instance running on my

6:56machine.

6:57That's what you saw earlier on.

6:58And it's essentially just basically

7:01pointing to that database.

7:03Now, this is an example database.

7:04It's not actually my password isn't Post

7:07gres password.

7:08And obviously, my password up here is not

7:101234.

7:11Make sure yours isn't.

7:12But this is basically the simple setup you

7:15need.

7:15And once you've got this set up, you just

7:17need to save this somewhere because we're

7:19going to reference it in the command line a

7:21little later on.

7:21So those are the basics of basically making

7:23sure everything's going to work.

7:25You need to know where Tableau prep is

7:27installed.

7:27If you need any credentials to a database

7:30or Tableau online or Tableau server, you

7:32need to have them here in the credentials

7:34file.

7:34And the next thing you need to do is know

7:36where your flows are and know where those

7:39credential files are.

7:40Now, to make things easier, I've got

7:42everything in a folder here called prep

7:44command line because I'm obviously doing

7:46this demo.

7:46But that's the best way to do this.

7:48And then for the next step, what we're

7:50going to do is open up the command line and

7:52I'm going to show you how to run a very

7:54simple flow.

7:54So we can actually run this first one here

7:56called Superstore simple flow.

7:58Okay, let's get stuck in.

7:59Okay, so what we need to do is we need to

8:01open up the command line.

8:02In order to do that, I'm just going to go

8:04here to the search icon and just type in C

8:06MD and it will come up.

8:08Now, if you're not using the search icon

8:10like I am or if you're running an older

8:11version of Windows, just have a Google and

8:14try and find the best way to open up the

8:15command prompt.

8:16I'm just going to open it up.

8:17I'm not running it as an administrator.

8:19I'm just going to keep it nice and simple.

8:20It's actually easier to use it if you don't

8:22run it as an administrator.

8:23I'll show you why in a second.

8:24The main reason is I always forget how to

8:26use the command line.

8:28So I like some prompts and one of the

8:30prompts I like is being able to drag the

8:32thing in I need into the command line

8:35rather than having to type a whole bunch of

8:36stuff.

8:37As someone who's dyslexic, that's just my

8:39worst nightmare.

8:40So let's go ahead and change the directory.

8:42That's just CD.

8:43And what we want to do is we want to drag

8:45the directory where we have this Tableau

8:47prep CLI here on the left hand side.

8:49So what I'm going to do is I'm just going

8:51to go back one and I'm going to just drag

8:53scripts into the window here.

8:55And you can see that it changes the text

8:57there for me.

8:58And now I'm back in here.

8:59If I just enter twice just to make that go,

9:02you'll see that it's changed the directory

9:04for me.

9:04So now I'm in the right place.

9:06I can now do something like DIR just to see

9:08what's in the directory.

9:10And it will show me here that I've got a

9:11bunch of different things, including the

9:14Tableau prep CLI.

9:15B.A.T.

9:16Now, what you can do is you can just

9:18basically just run that if you just go

9:21Tableau prep CLI.

9:22B.A.T. And what you saw me do there is as I

9:25hit TABL, I just hit tab because that's

9:27like a shortcut to autocomplete.

9:29So you don't any don't get any typos or

9:31anything like that.

9:32So let's hit enter just to see if that's

9:34working.

9:34And you can see that when I run that

9:36without any command entered, it basically

9:39shows you how the Tableau prep command

9:41lines all work.

9:42So it's basically working, it's firing, and

9:44we now know we're in the right place.

9:46Let's go ahead and set ourselves up to run

9:48the very first flow.

9:50OK, so in order to do this, we're going to

9:52need two things.

9:53We're going to need to know the location of

9:55our flow and then we're going to need to be

9:58able to enter it into our command line.

10:00So what I'm going to do is I'm going to

10:02call the command line tool again.

10:04You have to do this each time.

10:05So I'm going to hit up as another shortcut

10:07for bringing back what you previously typed

10:10.

10:10And when you know something like that works

10:12, I just do that rather than typing it again

10:14and risking any typos.

10:16Now, the next thing we need to do is to

10:18give it an argument.

10:19One of the things you can see here is that

10:21I need to reference the file.

10:22So -t is essentially just a little sort of

10:25shortcut that allows me to reference the

10:27file immediately after.

10:29So if I just type in -t, then enter a space

10:33, I can now go to my Tableau command line

10:36folder that I've got here.

10:37And again, I love my shortcut.

10:39So what I'm going to do, I'm going to move

10:41this window and I'm just going to drag this

10:43here into the window.

10:43And you can see autocomplete that for me.

10:47So now if I come back in here, I should

10:49actually be ready to run the flow.

10:51So just to summarize what I've done here, I

10:53've retyped the command line instruction

10:55again.

10:56I've put a -t to basically signal that I

10:59want to specifically run this flow.

11:02And then what this does is basically put

11:03the location of the flow so the command

11:05line tool knows where the flow is.

11:08And now if I hit enter twice, just once in

11:10this case, actually, you can see that it

11:12starts running.

11:13And actually, it's running successfully

11:15because it's starting to load the flow.

11:17It's creating a temp directory.

11:19That's normally a good sign, right?

11:20And when it finishes, you should just get a

11:22completion sort of signal here.

11:24So I just got to wait a little bit until

11:26this is complete.

11:28When it completes, what I'll also do is I

11:30'll go to the outputs folder that I set up

11:32the flow to output to and we'll check that

11:34everything is in there.

11:35And actually, as I'm speaking here, it

11:37seems to be running the flow, which is

11:39great.

11:39There's no errors, there's no document

11:41errors.

11:41So it validates the flow before it runs it

11:43to make sure there's no errors.

11:45And you can see here that it's finished

11:46running the flow successfully.

11:48So we have a success.

11:49Now let me go show you the output folder.

11:52If I go back to my folder here, actually,

11:56it's over here instead.

11:57If I just go back up one, now what I should

12:00see in this outputs folder is two flows.

12:02If I just refresh this.

12:10Where did I output this to?

12:13OK, so I know exactly what's happened

12:19because I'm a Mac fanboy and I'm on the

12:21command line, it's put it to a different

12:23desktop.

12:24Yes, when you're running Parallels, there

12:26are two desktops.

12:27It's super confusing.

12:28It just confused me right now.

12:29I'll go ahead and show you where this

12:31should actually be.

12:32So if I go to this desktop, go to the prep

12:34command line and go to the outputs, you'll

12:36see I have my two hyper files.

12:38There you go.

12:39I saved myself 10, 14.

12:40That's roughly a minute ago.

12:42If you're looking at the timestamps down

12:43here.

12:43We're all good.

12:45We're all good.

12:45So I managed to nearly trick myself there,

12:48but you can see that it worked.

12:49It worked really, really well.

12:50And we also got the success signal over

12:52here.

12:53Thankfully, we don't have to publish

12:55anything else to my desktop, so that trick

12:57won't get me again.

12:58OK, let's head to the next run.

13:00This time, what we're going to do is we're

13:02going to run the same flow.

13:04We're going to publish the output to Table

13:06au online.

13:08OK, let's set ourselves up.

13:09OK, so we're back in.

13:11What I'm going to do again to be lazy, I'm

13:14going to hit up and what we'll do and what

13:17that will do is it will load up the

13:19previous command that we ran.

13:20So we're just here at the bottom.

13:21It's going to go back and delete a few

13:24lines here because I don't need the entire

13:27flow.

13:28I'm just going to go all the way back to

13:30where it says T.

13:31And if you look up a little bit here, you

13:34'll see that the shortcut for specifying

13:37connections is actually -c.

13:39And we need to do that first before we

13:41specify the flow.

13:42So I'm going to go actually go ahead and

13:44delete the T and this time say C.

13:47And for the second flow, I've actually got

13:49a different credentials file.

13:51This is essentially the JSON file I was

13:52talking about earlier on, which looks a

13:54little something like this.

13:56So the file that I need is actually, I just

14:00go back a few folders.

14:01Let's go back to my fake desktop, as it

14:04were.

14:04Here we are.

14:05This is the DB online creds file here that

14:08I have.

14:08And I actually just need my online creds

14:10because I don't need any access to a

14:12database.

14:13It's always good to only specify what's

14:15absolutely necessary.

14:16In security, that's always basically what

14:18you do.

14:18Only give something as much access as it

14:20needs to get the job done.

14:21So in this particular case, let me just

14:24drag this down here so I can see it as I

14:26drag it.

14:26And then I'm going to drag the online creds

14:28folder here.

14:29I'm going to use my mouse rather than touch

14:31pad and just drop it down there.

14:33And you can see that that auto complete.

14:34So that's now there and set up.

14:36So now the next thing we're going to do is

14:38specify the flow.

14:39And the thing I need to specify now is

14:41actually this second flow, not the first

14:43one, because this second flow is the one

14:45that outputs to Tableau online.

14:47So let's go ahead and put that just there.

14:49And now, believe it or not, we're pretty

14:51much set up and ready to go.

14:53Before I run this, I want to show you the

14:55directory in which it's actually going to

14:57publish this.

14:58So you know that I haven't done any sort of

15:00trickery in the background to get this to

15:02work.

15:02This is the folder 2020.3 release folder.

15:06I actually created this a while back and it

15:07's going to publish the output of the flow,

15:10one single output to this particular

15:13directory.

15:13So let's go back and let's hit enter and

15:16make sure that this is working.

15:18OK, might need to enter this twice.

15:20Sometimes when you're not in the flow

15:22properly, it just doesn't sort of run

15:24properly.

15:25So now it's running.

15:26You can see everything is good.

15:28It's creating the temporary directory again

15:29.

15:29This is actually something that prep does

15:31in the background anyway.

15:32And we just got to wait for this to run.

15:35This is going to run slightly differently

15:36because it first needs to check the inputs,

15:39then check the outputs of which one of them

15:41is going to be a Tableau online connection.

15:43You can see that it established input

15:45connections.

15:46OK, no server connection detected in the

15:48input, starting to establish a server

15:51connection for publishing extract.

15:53And you can see that it's signed in

15:54successfully with my credentials to the

15:56right Tableau online instance.

15:58So now it's checking the document.

16:00There's nothing wrong there.

16:01So now it's running the flow and it's

16:03finished running the flow successfully,

16:05which means if I go back to my other tab,

16:08we should see something there.

16:09So let's swipe back and let's refresh this

16:12folder.

16:12And we should see we've got now two files,

16:15one of which should be a published data

16:16source.

16:17And there we have it.

16:18This was the locally published data source

16:20that was done in the command line.

16:22So again, this is really, really cool

16:24because if you need to automate something

16:26or get something up to Tableau online or

16:28Tableau server really quickly,

16:30you could actually set up a nice little

16:32script to get a bunch of these files up to

16:34Tableau online very, very quickly.

16:36And don't forget, all of these things we're

16:38doing in the command line can be scheduled

16:40using Windows Task Manager, not Windows

16:42Task Manager, Windows Schedule Manager even

16:44.

16:44So that's a really great way to automate

16:47this and get some basic automation up and

16:49running.

16:50Of course, if you're not worried about

16:51security, as I mentioned earlier on.

16:53So that's the second flow that we've set up

16:56running.

16:57Now, the last one is a little bit more

16:59tricky, but it's actually pretty much runs

17:01in exactly the same way.

17:03The only thing different here is we need to

17:05specify the credentials of the database and

17:08the credentials of Tableau server or Table

17:10au online instance.

17:12And so let's go ahead and set that up.

17:14I'm just going to hit space here and then

17:17hit up again to bring back the previous

17:19file that we ran.

17:20So I'm just going to go back and this time

17:22I'm going to go all the way back and I'm

17:23going to delete everything up until hyphen

17:26C.

17:26This is essentially where we specify the

17:27credentials.

17:28Again, if you're pretty comfortable with

17:30the command line, you could probably be

17:32typing away here and making sure everything

17:34works, but I'm not.

17:36So I'm going to be dragging and dropping

17:37things just like you do in Tableau.

17:39So the first thing I need to do is make

17:41sure I get the right one, not the example,

17:43because that won't work.

17:44That's got the wrong details in there.

17:45So I grab my DB online creds just onto that

17:49.

17:50So you can see that's been entered.

17:51Then I hit hyphen T just to move on to the

17:54next bit.

17:55And we're going to grab the Postgres to

17:57Tableau online.

17:58So what I've got here is I've got a Post

18:00gres instance running on my machine locally

18:03in a virtualized version of Windows on a

18:05Mac.

18:06Very, very complicated.

18:07But it's actually going to publish the data

18:10from that database to Tableau online.

18:13So we'll get a second file, a second output

18:15in that directory that I showed you earlier

18:18on.

18:18So we're going to go ahead and drag this in

18:20just so you can see that.

18:22So now we've got our query really nicely

18:24built out.

18:25So this is now working really, really

18:27nicely.

18:27And I think we can go ahead and run this.

18:30We shouldn't get any errors.

18:31I've used the correct credential files this

18:33time.

18:33And I've also got a third flow that I

18:36wanted to run, which is the third example I

18:38was going to show you today.

18:39So let's hit enter and hit that twice just

18:41to make sure that gets going.

18:44And again, we get going now.

18:46It's got three things to check now.

18:47The input is a database.

18:49The output is Tableau online.

18:51Then it's got to check the Tableau flow

18:52itself and make sure there's no errors.

18:54So it actually starts again in the same way

18:56, creates a temporary directory.

18:58The next thing we should do is we should

19:00see it checking the inputs, basically.

19:02So updating credential for connections for

19:04the local host, which is my database.

19:07It's made sure that everything's been

19:08established successfully.

19:10No server connections detected in the input

19:12.

19:12It's moving over to the output.

19:14It's connected to Tableau online here.

19:16Now it's checking the flow and now it's

19:18starting to run the flow.

19:20So that's a really cool way of automating

19:22this.

19:22And you can see it's actually finished and

19:24running the flow successfully.

19:26Now, I think what's happening there, the

19:28reason it's getting faster

19:29is because in the background, it's probably

19:30cached some of the data.

19:31But this whole time, Tableau prep hasn't

19:34opened.

19:35So you haven't seen any Tableau prep in

19:37this video, which is probably

19:38what you weren't expecting.

19:39And if I go back over here and I just go

19:42back to the 2020 release folder,

19:45you'll see that I've got here prep command

19:47line, which was the third

19:48file that I was running, published just a

19:50few minutes ago.

19:51So that's pretty much it.

19:53That's pretty much the video in a nutshell.

19:54And I'm really, really sorry that all I did

19:57was show you text in the command line.

19:59This is not user friendly at all.

20:01What I'll probably do is I'll put some of

20:03the scripts that I run

20:04in the description below so you can take a

20:06look at them in your own time

20:07and maybe just use them as a way of sort of

20:10setting up.

20:10And the thing I'd actually call out to is

20:12actually Tableau's

20:13own documentation on this.

20:14It's actually really, really good.

20:15It's really, really detailed.

20:17And it gives many of the same examples.

20:19If I scroll down, you can actually see that

20:22I was actually searching

20:23for things in here.

20:24So one little trick that I do, like if I'm

20:26searching for something

20:27in documentation, what I normally do is hit

20:29command F.

20:29That opens up the search parameter.

20:32And if I'm stuck on something, let's say I

20:33'm looking for something

20:34referencing Tableau online.

20:36I just type in like a keyword.

20:38And of course, what your browser will do is

20:40highlight each instance.

20:41But then it allows me to skim this document

20:43very quickly

20:44to see where they mention Tableau online.

20:46Then I'm actually able to see here some of

20:48the specifics I mentioned.

20:49And so it's a nice way of sort of just

20:51browsing this.

20:51But as you can see, they have examples here

20:53that you can follow.

20:54And they basically detail how to run each

20:57and every scenario,

20:58including if you're using something like a

21:00SharePoint server

21:01where you need to use the UNC path in your

21:03command line

21:04rather than the local directory on your

21:06actual machine.

21:08So that's a really good use case that you

21:10can use to get data

21:11that's in a shared drive to run.

21:13And also your Tableau prep folder can also

21:15be in that shared drive.

21:17So you can have flows in a shared folder

21:19running in an automated way,

21:21admittedly using this script and then

21:24publishing that to Tableau

21:25online or Tableau server as you so see fit.

21:28Hey, this is Tim from the future.

21:31I'm editing this video and I realize I didn

21:33't actually show you the command

21:34options that are actually available when

21:36you're running the flows in the command

21:38line.

21:38So I just wanted to give one moment just to

21:40highlight where those are very, very

21:42quickly.

21:42If you head to the documentation that I

21:44actually referenced and scroll down

21:45a little bit, you'll see that towards the

21:47bottom or here,

21:48if I click on the right hand side, there's

21:49an option here for command options.

21:51This is actually really important because

21:53it shows you some of the other options

21:55that are available that I didn't cover in

21:56the video.

21:57One of those includes debugging, but also

22:00including

22:01disabling validations.

22:02This is basically when you're checking

22:04certain things in the flow.

22:06OK. And specifically for Mac OS is actually

22:08really, really important.

22:10The other thing to be aware of is you can

22:12actually add a tag

22:14to enable incremental refreshes.

22:16So if you've not got the Tableau

22:19prep conductor or the data management add

22:21on to enable that,

22:22you can actually use this to do incremental

22:24refreshes

22:25to see if that's something that suits you.

22:27And then if that becomes something that you

22:29want to do in a production

22:30sort of level set up, then actually then

22:32you can you know

22:33that it's going to be worth your while.

22:35So these are just some very useful command

22:38line options here.

22:39Hyphen Inc, hyphen H for help if you don't

22:42know what you're doing.

22:43DSV and D, you know, you probably don't

22:47need to use them unless there's a problem

22:48or you need to do some really quirky things

22:50.

22:50Or if you're running a Mac, you need to do

22:52some specific validation

22:54because Mac OS has slightly different

22:56security settings.

22:57And then the last thing I didn't mention is

22:59that, of course,

22:59if you're running this on a Mac, many of

23:01the settings are actually the same.

23:02You just need to be aware of the Mac nomen

23:05clature for this.

23:06And also, again, in the documentation,

23:08Tableau have done the alternative.

23:10So more or less it's exactly the same.

23:12You're referencing the exact same script

23:14folder.

23:14It's just in a different place and your

23:16flows are also in a different place.

23:18But it works pretty much the same way.

23:20And it's a really nice way of sort of

23:21getting around it.

23:22So that's that's it from future Tim.

23:24We'll head back to the video.

23:25So that's the video. Sorry, this was a

23:27little bit long.

23:28It was a little bit detailed as well.

23:29And we spent most of our time looking at

23:31really boring command line scripts.

23:33But hopefully you found this video really

23:35useful.

23:35Hopefully you found it something that you

23:37can maybe go and apply to your work

23:40if your security guys let you do that.

23:42But if you've enjoyed this video, you know

23:43what to do.

23:44Drop a comment below. Drop a like.

23:46Subscribe to the channel if you haven't

23:48done so.

23:48Otherwise, if you didn't like it, let me

23:50know what kind of content

23:51you'd like to see instead, and we'll try

23:53and work on some of that in the future.

23:54All right. Thanks for watching.

23:55I'll catch you in the next one.