Square logo

Square

Sync Square payments, orders, and catalog data into your warehouse.

Overview

The Square connector syncs your payments and point-of-sale data into analytics-ready tables in your data warehouse. Pull payments, orders, customers, catalog, and inventory from the Square API, with Ingest handling auth, pagination, and retries so the tables stay current.

What you can sync

Ingest syncs the following Square data into your data warehouse, each as its own table refreshed on your schedule:

  • Payments
  • Orders
  • Customers
  • Catalog
  • Inventory

Authentication

Access token (OAuth2)

Create an application in the Square Developer Console and copy its access token, or complete the OAuth2 flow for apps serving multiple sellers.

You enter credentials in a secure form, never in chat. Ingest stores and rotates them for you.

Resources