System and Location Schemas

The Square API operates at System and Location levels. Organization-wide information objects and operations are surfaced under the System schema. Data for individual locations are surfaced under their own schema, according to their Location nickname (defined in the Location table).

Example query for the System schema:

SELECT * FROM Employees

SELECT * FROM SYSTEM.Employees

SELECT * FROM "SYSTEM".Employees

Example query for the Location schema:

SELECT * FROM "Location_Nick_Name".Payments

Users can only see the schemas, stored procedures, and tables that they have access to according to their login credentials.