Strategy ONE

Import Data from a Database or Hadoop by Selecting Tables

You can import data from a database or Hadoop by selecting tables to retrieve data from the source. An intuitive visual interface makes it easy to build to import your data by dragging and dropping tables.

  1. Create a document or open an existing one.
  2. Choose Data > Add Dataset.
  3. Click Add External Data.
  4. Select a database source. To import data without specifying a database source, click Databases.
  5. Select Select Tables and click Next.
  6. Click on a data source/project from the Data Sources pane.
  7. To view the last time the database's tables and columns were cached, hover over the Information icon next to Available Tables.
  8. If your data source/project supports namespaces, select a namespace from the Namespace drop-down.
  9. Double-click the tables you want to import.
  10. Click Finish.
  11. Click Connect Live or Import as an In-memory Dataset.
  12. Click Save.