Tableau Connector for Square

Build 21.0.8137

データモデル

The CData Tableau Connector for Square models the Square v1 and Square v2 APIs as relational tables, views, and stored procedures. These are defined in schema files, which are simple, text-based configuration files.

The available entities are documented in Square v1 データモデル and Square v2 Data Model.

Using Collaborative Query Processing

The connector offloads as much of the SELECT statement processing as possible to the Square APIs and then processes the rest of the query within the connector. The following sections document API limitations, requirements, or particularities. See SupportEnhancedSQL for more information on how the connector circumvents API limitations with in-memory client-side processing.

Querying Several Business Locations

You can query tables/views from different business locations by specifying multiple LocationIds in the "IN" operator. Note however that for tables/views like Customers, Employees, Orders, and OrderItems, this is not possible.

Select * FROM Transactions WHERE LocationId IN('CBASEDbVhLxAJeGrBRLi-BxZ3XcgAQ','CBASEGJDarn_hucmacLdA_iGNGwgAQ','CBASEFsuPlSmrLHXu9a5Lmlv4D4gAQ')

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137