Strategy ONE

Import Data from a Database or Hadoop by Typing a Query

You can import data from a database or Hadoop by writing your own freeform script, or query, to retrieve data from the source.

You can import data from a database using SQL, from third-party web services using XQuery or from Hadoop using HiveQL.

The query prefixes #legacySQL and #standardSQL:

  • Are not case-sensitive.
  • Must precede the query.
  • Must be separated from the query by a newline character.
  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 Type 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. Make changes to the query.
  11. Click Finish.
  12. Click Connect Live or Import as an In-memory Dataset.
  13. Click Save.