Overview

This section shows the available API objects and provides more information on executing SQL to Azure Data Lake Storage APIs.

Key Features

• The add-in models Azure Data Lake Storage entities like documents, folders, and groups as relational views, allowing you to write SQL to query Azure Data Lake Storage data.
• Stored procedures allow you to execute operations to Azure Data Lake Storage.
• Live connectivity to these objects means any changes to your Azure Data Lake Storage account are immediately reflected when using the add-in.

Views

Views describes the available views. Views are statically defined to model Resources and Permissions.

Stored Procedures

Stored Procedures are function-like interfaces to Azure Data Lake Storage. Stored procedures allow you to execute operations to Azure Data Lake Storage, including downloading documents and moving envelopes.