Learn how to connect to Presto from Tableau 10.
- [Instructor] For many of you,…you'll be using Presto and connecting to it…from a platform like Tableau or R,…or some other tool that you use to do your work.…And so I wanted to go through now…and show you a couple of these examples.…I'm going to start with Tableau.…And if you don't have it yet,…you can get a free trial from tableau.com.…Click on Try Now,…enter your e-mail,…and download the free trial.…It works on Windows and Mac.…And then once you get the download,…just double-click the installer, click Next.…
You'll have to enter some info to activate your trial,…and then you can fire it up and follow along.…Once you've done that,…you can see the Connect to Data window,…as I have here, up in Tableau.…And I'm running this on a Mac,…but it'll work almost identical to Windows.…So once you have Tableau opened…and you're looking to connect,…in order to connect to Presto,…I need to look for my servers under More here,…and find the Presto option.…Tableau works with many, many data sources.…And Presto is now natively supported as of Version 10.1.…
Data science expert Ben Sullins helps you get up to speed with Presto, and leverage it to accomplish a wide-range of data science and analytics tasks. He uses different interfaces with Presto—such as R and Tableau—and digs into the expressive SQL language that Presto offers for your analysis. At the end of this course, you'll know the key concepts of Presto and how to use them to take full advantage of your modern big data system.
- What does Presto do?
- Running Presto
- Connecting from Tableau and R
- Connecting to Hive, MySQL, and the local system
- Retrieving data
- Combining data sources
- Basic SQL functions
- Advanced SQL functions
- Migrating from Hive
Skill Level Intermediate
SQL: Data Reporting and Analysiswith Emma Saunders2h 16m Intermediate
Advanced SQL for Data Scientistswith Dan Sullivan1h 24m Advanced
1. Introducing Presto
2. Running Presto
4. SQL Syntax
5. Basic SQL functions
6. Advanced SQL Functions
7. Migrating from Hive
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.