Compass

Compass is a Data Fabric tool for querying the contents of Data Lake for data analysis & exploration, ad-hoc data exports, data management, and troubleshooting.

There are two ways to start Compass in the Data Fabric application.

• Click the Query the Data Lake link on the Home page
• In the navigation menu on the left side of the page, expand Data Lake and click Compass.

In Compass, you can run these tasks:

• Write and run SQL queries.
• Create Views on top of your data objects stored in Data Lake.
• Export data.
• Explore data objects and properties.
• Execute administrative tasks within Data Lake.

Compass offers these elements and functionality:

• Multi-tabbed query development with up to 10 concurrent tabs.
• Data Objects and Views Panel - for exploring Data Catalog objects and Views.
• Ability to search and filter the data objects and data object properties
• Generate contextual SQL statements and SQL hints to influence data retrieval behaviors
• Generate contextual administrative SQL code for managing & troubleshooting data residing in Data Lake
• Query Editor - for writing SELECT statements and running them.
• Syntax highlighting
• Contextual auto-suggest for MS SQL keywords, custom keywords, data object and data object property names
• SQL formatting
• Font size controls
• Results Panel - for previewing the query results
• Success and error messages
• Result set in a data grid
• Exporting a result set

With Compass editor you can write simple or advanced SQL SELECT statements and run them to retrieve data from Data Lake.

These are the supported SQL statements:

• SELECT statements.
• MS SQL dialect.
• SQL Comments are supported within a statement.
• SELECT statement with Hints, to retrieve data variations.
• Admin statements to manage the formatted data lake objects.
• CREATE, ALTER, DROP statements for Views.