Data Model
The CData Excel Add-In for Azure Data Lake Storage models Azure Data Lake Storage data as an easy-to-use SQL database. There are two parts to the data model: views and stored procedures. Live connectivity to these objects means any changes to your Azure Data Lake Storage account are immediately reflected.
Views
The Views section describes read-only SQL tables. Views are statically defined to model Resources and Permissions.
The following views are included:
| Views | Description |
| FileSystems | Returns a list of available filesystems in the connected Azure Data Lake Storage account, useful for browsing and managing storage containers. |
| Resources | Displays the contents of a specified path within a filesystem, enabling you to explore folders and files stored in Azure Data Lake. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard Create, Read, Update, Delete (CRUD) operations, including downloading and uploading documents and managing OAuth tokens.