Import Data from a Database or Hadoop by Building a SQL Query

You can import data from a database or Hadoop by building your own SQL query, or script, to retrieve data from the source. An intuitive visual interface makes it easy to build the SQL query that imports your data by dragging tables, selecting columns, defining joins, and specifying filter conditions.

Importing data from a database requires a connection to a data source.

1. Create a document or open an existing one.
2. Choose Data > Add Dataset.
3. Click Add External Data.
4. Select a database type. To import data without specifying a database type, click Databases.
5. Select Build a Query and click Next.
6. Click on a data source/project from the Data Sources pane.
7. If your data source/project supports namespaces, select a namespace from the Namespace drop-down.
8. To view the last time the database's tables and columns were cached, hover over the Information icon next to Available Tables.
9. Double-click the tables you want to import.
10. Double-click the columns you want to import. .
11. To exclude a column from import, hover over it in the Sample Preview pane, click the drop-down, and choose Delete.
12. To perform functions on column data, right-click the column in the Query Builder pane and choose a function.
13. To create a filter on column data, right-click the column in the Query Builder pane and choose a filter.
14. Click Finish.
15. Click Connect Live or Import as an In-memory Dataset.
16. Click Save.