Request: I am looking for the data related in Subscribe and save orders in amazon vendor central. which might present in the "PromotionsPerformanceReport" table. But this table is not present in Fivetran to fetch this data.

Response from fivetran support:

After reviewing your connection and our current Amazon Selling Partner connector capabilities, I can confirm that the GET_PROMOTION_PERFORMANCE_REPORT (which surfaces as PromotionsPerformanceReport) is not currently supported by Fivetran.
 
Current Status:

• While Amazon's SP-API does provide the GET_PROMOTION_PERFORMANCE_REPORT for both vendors and sellers (which includes data on Best Deal, Lightning Deal, and Price Discount promotions), this report is not yet part of Fivetran's supported report set
• Our connector currently supports various Vendor reports including Sales, Inventory, Traffic, and Net Pure Product Margin reports, but promotions and Subscribe & Save data specific to Vendor Central is not yet available
• We do support Subscribe & Save reports (GET_FBA_SNS_PERFORMANCE_DATA and GET_FBA_SNS_FORECAST_DATA), but these are only available for FBA Seller accounts, not Vendor Central.