Creating a data source

When you create a data source, you specify a SQL query to select the data to include.

To create a data source:

  1. Log in to Studio as an administrator.
  2. Click Configuration Options > Control Panel and navigate to Big Data Discovery > Data Source Library.
  3. Click + data source for a data connection you created previously.
  4. Provide the required authentication information for the data connection, then click Continue.
  5. Provide a name and description for the data source.
  6. In Maximum number of records, specify the maximum number of records to include in the data set.
    Studio does not control the order of the records. The SQL statement can indicate the order of records to import using an ORDER BY clause.
  7. In the text area, enter the SQL query to retrieve the records for the data source, then click Next.
    The next page shows the available columns, with a sample list of records for each.
  8. Click Save.
Once you have completed this task, the data source displays on the Studio Catalog as a new data set available to users.