Marketplace Data Model
The CData Python Connector for Amazon Marketplace models the Amazon Marketplace API as relational views, and stored procedures.
To use Marketplace Data Model, simply set Schema to Marketplace.
Views
Views are tables that cannot be modified, such as Orders, Products. Typically, model data that is read-only and cannot be updated are shown as views.
Stored Procedures
Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.
Using Reports
Created reports can be exposed as views by setting IncludeReports connection property to true. Reports can be created with the RequestReport stored procedure.
After a report has been created and finished processing with a status _DONE_ it will be exposed as a view with the name "Report{ReportType}{ReportID}".
Only Tab-Delimited reports can be used as views. You can find a full list of reports here: Report Types.
In order to avoid API throttling, it is suggested to use the CreateSchema stored procedure to create report table schemas.