Connector name: Amazon Selling Partner  

Table name: promotions

API documentation link: https://developer-docs.amazon/sp-api/docs/promotions-api

Additional details: we surface promotion id in the orders table but no promotions dimension in the fivetran connector. It would be nice to get be able to get the promotions dimension so we can join to the orders