Connect Amazon Vendor Central to Snowflake

Authorize Amazon Vendor Central through OAuth2, select the marketplace you want to report on, save your Snowflake connection, and pair both in a datastream. The associated job can preview and write your selected columns to Snowflake.

Build your Snowflake schema from Amazon Vendor Central fields such as ordered revenue, shipped revenue, ordered units, open purchase order units, sellable inventory cost, and average vendor lead time. You can also select report-level and normalized date dimensions, then rename the chosen columns before loading them.

Catchr reads vendor sales, traffic, inventory, forecasting, and net pure product margin reports. Aggregate and ASIN sections are identified by report level, helping agencies organize marketplace reporting at the appropriate level in Snowflake.

Sales, traffic, inventory, and net pure product margin reports use the requested date window, while forecasting returns Amazon's latest forecast snapshot without a date window. Available history and recurring job frequency depend on the source API and your plan.

Snowflake queries can compare ordered and shipped revenue, track ordered and unfilled units, monitor open purchase orders, and review sellable, unhealthy, or aged inventory costs. Saved views can organize these indicators by normalized calendar periods and report level for repeatable client reporting.

Yes. Connect an existing Snowflake database first. The Catchr job creates and populates the destination table you configure inside that database.

Yes. Create a separate datastream and job for each source, write each export to its own table, then combine the data downstream with SQL, views, or your BI tool.