Connect Xero to Snowflake

Authorize Xero through OAuth2, select the relevant Xero tenant, save your Snowflake connection, and pair the source and destination in a datastream. You can then choose and preview the columns to load into Snowflake.

Choose from 20 metrics and 112 dimensions covering contacts, invoices, invoice lines, and payments. Available fields include invoice totals, amounts paid and due, tax, receivable and payable balances, account details, and contact regions.

A Snowflake job can start with a historical Xero fetch and continue on a recurring schedule. The available history and scheduling frequency depend on the Xero API and your Catchr plan.

When the selected Xero data includes a valid date field, Catchr can delete and rewrite the scheduled window to limit duplicates across overlapping runs. Xero timestamps returned in its native format are normalized to ISO-8601 UTC before rows are written.

Agencies and freelancers can query invoice totals, tax, paid and outstanding amounts, overdue receivables or payables, and payment account details in Snowflake. These fields support reusable views for finance and 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.