Blue icon with binoculars.

Browse In-DB Tool

Version:
Current
Last modified: December 02, 2019

The Browse In-DB tool lets you view your data at any point in an In-DB workflow. Use the Browse In-DB tool as you build an In-DB workflow to ensure data is passing through the way you intend it to. It allows you to view results at any point in the In-DB workflow.

In-Database enables blending and analysis against large sets of data without moving the data out of a database and can provide significant performance improvements over traditional analysis methods. For more about the In-Database tool category, see In-Database Overview.

Each Browse In-DB tool triggers a database query and can impact performance.

 

Tool Configuration

Browse first 100 records: Specify the number of records to display in the Browse In-DB window when the workflow is run. The default of 100 records can be changed. Entering 0 displays the maximum of 2 billion records.

Enable caching: The Browse In-DB tool will cache the number of records returned when the workflow is run. This option will default checked, but can be turned off. If the database connection or query (including the number of records to browse) does not change then the query will not be re-run, but instead the records that display in the window are pulled from the cache.

Clear Cache: Click the Clear Cache button to clear the data from the cache.

The tool has a display limitation of 2 billion records. If there are more than 2 billion records in the data stream, there will be a message in the Data View statistics. All records will be written to the desired file type when exporting from the Browse.

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.