When you create a data source, you specify a SQL query to select the data to include.
- Log in to Studio as an administrator.
- Click and navigate to .
- Click + data source for a data connection you created previously.
- Provide the required authentication information for the data connection, then click Continue.
- Provide a name and description for the data source.
- 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.
- 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.
- Click Save.
Once you have completed this task, the data source displays on the Studio Catalog as a new data set available to users.