Customize Your Query While Importing Data from a Database or Hadoop

While you are building a query for importing data, you can customize the query manually.

1. Create a document or open an existing one.
2. Choose Data > Add Dataset.
3. Click Add External Data.
4. Select a database type and build a query.
5. Click Edit SQL.
6. Click Yes to exit Build Query mode.
7. Make changes to the query.
8. Write the query as a single-pass SELECT statement.
9. If you are creating a join between tables, the syntax of the JOIN clause that you write depends on the size of the tables that you are joining.
10. Click Finish.