February 2023 Release Notes

Shopify (v 2.1.1)

Panoply now support the collection of Shopify Metafield Definitions and the values of metafields for the following Shopify objects:

• Customers
• Orders
• Products

What You Need To Know

• The Metafield Definitions resource is collected incrementally. This means that the collected data includes new or updated data since the last time the data source succeeded.
• In order to get the metafields' values for Customers/Orders/Products records that were not updated since the last successful collection of the data source, you will need to change the incremental value to a certain point of time in the past you wish to collect data since.

Hubspot (v 2.4.0)

Panoply now supports the collection of six new Hubspot resources:

• Companies History
• Contacts History
• Deals History
• Line Items History
• Products History
• Tickets History

Every one of these resources will create a new table with a postfix of _history. For example, the Companies History resource will create the hubspot_companies_history.
Every one of these resources can only be selected if the parent resource is selected as well. For example, in order to collect the Contacts History resource, you must select the Contacts resource as well.

Each table will include a record for each property change. For example, if first name, last name and email address were updated for a certain company on a certain time, that will create 3 records in the history table (one for each property update). the main four columns in the history tables are property, value, timestamp and the parent identifier column (For example, company_id).

Best Practice

To collect historical data for the the new resources, it is recommended to create a new Hubspot data source. This will ensure that all records from the new resources are collected, regardless of whether older Hubspot data sources were previously configured to collect incrementally.

Queries Page

The new Queries feature allows Panoply admins to view all executed queries within the last two days.
Search for the new Queries tab in your Panoply tool bar.

What you need to know

• Available for BigQuery accounts
• Executed queries may easily be copied to your clipboard
• Panoply ingestion queries may not be viewed
• You may cancel running queries from the Queries page
• The estimated query bytes cost is displayed before loading any previously executed queries
• Viewed queries are marked: Running, Done, Error, or Canceled
• If a query fails, the Queries page will show the error that had occurred