April 2021 Release Notes

Square

Panoply has released the new Square data source. Using the Square API, Panoply can collect your data into your data warehouse. The resources available are:

• Terminal Checkouts
• Payments
• Payment Refunds
• Orders
• Catalog Objects
• Inventory Counts
• Inventory Changes
• Customers
• Customer Groups
• Customer Segments
• Locations
• Cash Drawer Shifts
• Cash Drawer Shift Events
• Team Members
• Wage Settings
• Break Types
• Team Member Wages
• Shifts
• Workweek Configs
• Bank Accounts

Google Drive (v 2.0)

Panoply has refreshed the Google Drive data source. As a part of this refresh, additional features have been added. These include:

• Dropdown with all avaliable Folders
• Collect All feature
• Support for .gzip files
• Incremental loading
• Support for Google Sheets
• Delimeter files in UI config
• Support for delimited files with txt extension
• Support for reading in batches of the some file types
• Support of XML files parsing

Panoply no longer provides a default destination. Users must provide a destination when setting up the data source. When migrating to the new Google Drive data source, users will need to use their existing table names as the destination if they want the data to be collected into those existing tables.Schema changes include the addition of several metadata fields, and one has been removed.

Added:

• __folder: The name of the parent folder of the file
• __xml_item: The name of a child element that represents the record of xml file
• __xml_root: The root tag of xml files

Removed:

• __tablename metadata column

Shopify

The Shopify API version was updated from 2020-01 to 2020-07.