Square
Square is a financial services, merchant services aggregator, and mobile payment company.
Features
| Feature Name | Supported | Notes | 
|---|---|---|
| Capture deletes | ||
| History mode | check | INVENTORY_COUNT_HISTORYtable only | 
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration | 
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check | 
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step Square setup guide to connect Square with your destination using Fivetran connectors.
Sync overview
We incrementally sync the following tables to capture new records.
- ADDITIONAL_REFUND_RECIPIENT
- GIFT_CARD_ACTIVITY
- REFUND
- SHIFT
- SHIFT_BREAK
We also re-import these tables to capture updates and deletes.
The re-import frequency depends on the duration of the last re-import for the table:
- If the last re-import took less than 2 hours, we re-import the table once a day.
- If the last re-import took more than 2 hours, we re-import the table once a week on Saturdays.
Schema information
This schema applies to all Square connections.
To zoom, open the ERD in a new window.