Data Model
The CData JDBC Driver for Amazon S3 models Amazon S3 data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures. Live connectivity to these objects means any changes to your Amazon S3 account are immediately reflected.
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 Amazon S3 account.
The following tables are included:
| Table | Description |
| Buckets | Provides detailed information about S3 buckets, which are top-level containers used to organize and store objects and their associated metadata. |
| BucketsACL | Displays the access control list (ACL) for a bucket, showing user- and group-level permissions that define who can read, write, or manage bucket contents. |
| BucketsAnalytics | Retrieves bucket analytics configurations, which define storage class analysis and data usage patterns used to optimize storage costs. |
| BucketsCORS | Returns the CORS (Cross-Origin Resource Sharing) rules configured for a bucket, allowing controlled access to S3 resources from external domains. |
| BucketsInventory | Provides bucket inventory configurations, which define scheduled reports listing objects and their metadata for auditing or data management purposes. |
| BucketsLifecycle | Shows lifecycle rules for a bucket, which automate object transitions between storage classes or schedule deletions to optimize data retention. |
| BucketsReplication | Displays replication settings for a bucket, including cross-region replication rules that automatically copy objects across buckets. |
| Objects | Provides detailed information about objects stored within a bucket, including metadata, size, and storage class. |
| ObjectsACL | Displays the ACL for a specific object, defining read and write permissions at the object level. |
| PublicAccessBlock | Retrieves the PublicAccessBlock settings for a bucket, which control whether public access to bucket data is allowed or restricted. |
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 objects and managing OAuth tokens.