website logo
⌘K
Getting Started 🚀
What is DataLakeHouse.io?
Our Business-Value Focus
Learn the Basic Concepts
Connectors
Operations Applications
ConnectWise
Google Sheets
Aloha POS
BILL
Bloom Growth
Ceridian Dayforce
Food Delivery Service Connector
Facebook Ads
Google Analytics 4
Harvest
Hubspot
Jira
McLeod Transportation
NetSuite (Oracle NetSuite)
Optimum HRIS
QuickBooks Online
Salesforce
Shopify
Square
Square Marketplace
Stripe
Workday HCM
Xero
Databases
SQL Transformations
Terraform: Reverse Terraforming
DBT Cloud Transformations
Sync Bridge (Data Pipelines)
Create a Sync Bridge
Manually Run a Sync Bridge
Deleting a Sync Bridge
Analytics
Access Analytics
Snowflake Usage Analytics
FAQ (about syncing data)
How are new columns are added to the target Data Warehouse?
....
Data Catalog
Create the Catalog
Populate the Catalog
Access the Catalog
Data Warehousing
Snowflake
Open Source DW Models
Alerts & Notifications
Integrations (Slack, etc.)
Logs & Monitoring
Security
Release Notes
April 2022
July 2022
Community Overview
Contributor Agreements
Code Contribution Guide
About
Our
License
Viewpoint
Docs powered by archbee 
4min

Square

Square.com is a payment platform that gives every business an easier way to accept credit cards. It is a larger payment that includes customer loyalty software, inventory management, and credit card processing. Square is very popular in restaurant and retail industries, as it provides its merchants with a POS / Kiosk capability to transact with large enterprise functionality in a small footprint.

Connector Pre-Requisites

Connecting to Square, you need to make sure that:

  • You have access to retrieve metadata from your Square account
  • You have access to the developer.squareup.com portal and can create an API key

Instructions (Basic Connection Setup)

DataLakeHouse.io securely connects to your Square instance.

For this advanced use of the Square developer API keys, you must have the developer credentials to access this connection.

If you are desiring to connect via the Square Marketplace you MUST USE the other Square Marketplace connector instead.

Using the form please complete the following basic steps:

  1. Enter a Name or Alias for this connection that is unique in the 'Name/Alias' field
  2. Enter a unique target schema name in your Snowflake data cloud destination in the 'Target Schema Prefix' where you wish to land the data.
  3. Enter the Square developer Application ID in the API App/Publish Key field from the Square developer portal
  4. Enter the Square developer Access Token in the API Access/Secret Key field from the Square developer portal
  5. (Optional) the API Account Id or the developer Application Name can be stored but is not required.
  6. Click the 'Authorize Your Account' button which will transport the page to the Square login, where you will enter your Square account credentials.  Once your credentials are accepted you will be automatically redirect back to this DataLakeHouse.io portal and you should be able to see a successful connection of your source.

If any issues occur with the Square authorization, simply return to the sources page in DataLakeHouse.io, edit this source and click the 'Authorize Your Account' or 'Re-Authorize Your Account' button.   If any issues persist please contact our support team via the DataLakeHouse Support Portal.

Updated 03 Mar 2023
Did this page help you?
Yes
No
UP NEXT
Change Log & Notes
Docs powered by archbee 
TABLE OF CONTENTS
Connector Pre-Requisites
Instructions (Basic Connection Setup)