Managing Data Sources

You can use the Data Sources page to see all the data sources available for you to use in projects and analyses. This includes the data files you uploaded and the data files that others share with you.

You can also use the Data Sources page to examine data source properties, change column properties such as the aggregation type, set permissions, and delete data sets that you no longer need in order to free up space. Data storage quota and space usage information for the entire service are also displayed, so that you can quickly see how much space is free.

To manage data sources:

1. On the Home page, click Data Sources.
2. On the Data Sources page, to the right of the data source you want to manage, click Options. The options available in the drop-down list depend on the data source type.
   Data sources that are based on Oracle application connections are indicated by the connection name. For more information, see Connecting to Oracle Application Data Sources.
   
   Description of the illustration GUID-2D696BAB-E78C-40B9-92B7-00A7A5592BA0-default.jpg
3. Optionally, use the Inspect option to review data source columns and change the data source properties. For example, for an uploaded data source, you could change the Product Number column aggregation type to Minimum.
   
   Description of the illustration GUID-E28ED16C-C964-4387-9E34-F9F89665EE95-default.jpg
4. Optionally, change whether to treat data source columns as measures or attributes. You can't change how a column is treated if it is already matched to a measure or attribute in the data model. For more information on removing matches, see Blending Data That You Added.
5. Optionally, change the Query Mode for a database table. The default is Live because database tables are typically large and shouldn’t be copied to cache. If your table is small, then choose Auto and the data is copied into the cache if possible. If you select Auto, you will have to refresh the data when it is stale.

Note:

If you have Full Control permissions, you can grant permissions to others and delete uploaded data sets, but be careful not to delete a data file that is still a data source for reports. For more information, see Deleting Data that You Added.