Data Model
The CData Tableau Connector for Dropbox models Dropbox data as an easy-to-use SQL database, using tables, views, and stored procedures. These are defined in schema files, which are simple, easy-to-read text files that define the structure and organization of data. Some Dropbox data is related to other data. For instance, in the tables, foreign keys (like matching IDs) show how different records are related.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Dropbox account.
The following tables and views are shipped with the connector:
| Table | Description |
| FileLinks | Lists all shared links associated with files in a user's Dropbox, enabling insight into external sharing activity. |
| Files | Provides detailed information about all files stored in a user's Dropbox, including metadata such as size, path, and last modified time. |
| FolderLinks | Displays shared links for folders in a user's Dropbox, allowing you to audit folder-level sharing. |
| Folders | Lists folders within a user's Dropbox account, along with metadata including folder paths and creation details. |
| DeletedResources | Displays files or folders that have been deleted from a user's Dropbox account, useful for tracking removals or recovering data. |
| Events | Captures activity logs for a Dropbox Business team, including file sharing, edits, logins, and permission changes. |
| FileRequests | Shows active and past file requests initiated by the user, including requester details and file submissions. |
| FileSharedMembers | Returns a list of users who have access to a specific shared file, including their permissions and roles. |
| FolderSharedMembers | Returns users who have been granted access to a shared folder, along with their permission levels. |
| SharedFiles | Provides a list of files the user has shared with others, including file paths, access settings, and shared link info. |
| SharedLinkMetadata | Retrieves metadata about a shared link, such as link visibility, expiration date, and associated resource details. |
| TeamMembers | Lists all members of a Dropbox Business team, including account details, status, and assigned roles. |
| Teams | Returns metadata about the current Dropbox Business team, such as team ID, name, and sharing policies. |
| Users | Retrieves account information for multiple users, helpful for team administration or access audits. |
Stored Procedures
Stored Procedures are SQL scripts that extend beyond standard CRUD operations. These stored procedures enable advanced operations such as monitoring asynchronous job status, managing access by adding members to shared files, and facilitating OAuth authentication and token management.