Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Important
This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Azure Databricks previews.
The managed Square connector in Lakeflow Connect ingests point-of-sale data such as payments, orders, customers, catalog items, and inventory from Square into Azure Databricks.
Feature availability
| Feature | Availability |
|---|---|
| UI-based pipeline authoring |  Supported |
| API-based pipeline authoring | Supported |
| Declarative Automation Bundles | Supported |
| Incremental ingestion | Supported |
| Unity Catalog governance | Supported |
| Orchestration using Databricks Workflows | Supported |
| API-based column selection and deselection | Supported |
| API-based row filtering |  Not supported |
| SCD Type 2 | Supported |
| Automated schema evolution: New and deleted columns | Supported |
| Automated schema evolution: Data type changes | Not supported |
| Automated schema evolution: Column renames | Not supported Requires a full refresh. |
Authentication methods
| Authentication method | Availability |
|---|---|
| OAuth U2M | Not supported |
| OAuth M2M | Not supported |
| Basic authentication (username/password) | Not supported |
| Basic authentication (API key) | Supported Square API token. |
Ingest from Square in 3 steps
Note
Before starting, review the Azure Databricks user persona, supported interfaces, ingestion frequency, and common patterns.
Start ingesting from Square
- Configure Square for ingestion (Admins) — Set up Square to authenticate with Azure Databricks.
- Create a Unity Catalog connection (Admins) — Create a connection in Catalog Explorer so non-admins can create pipelines.
- Create an ingestion pipeline (Admins or non-admins) — Select any supported interface and create a pipeline from an existing connection.