Create Data Sets from Databases

After you create database connections, you can use those connections to create data sets.

Note:

The maximum number of tables displayed is 10,000. If your connection provides access to additional tables and the tables you want aren't displayed, enter the SQL statement for the data set manually by selecting the Enter SQL option.

1. On the Home page, click Create, and then click Data Set.
2. In Create Data Set, click the database connection containing the data to use.
3. In Add Data Set, click the schema containing the table with your data. Click the table to use for the data set.
4. In the column list, browse or search for the columns you want to include in the data set. You can click Add All, or select a column or columns and then click Add Selected.
5. Optional: Use the Data Access option to specify how to refresh the data set.
   Alternatively, you can select the Enter SQL option to view or modify the data source’s SQL statement or to write a SQL statement.
6. Click Add.