July 2024 Release Notes

Hubspot (v 2.9.5)

Panoply now supports non-incremental collection. Users can disable the incremental load through the advanced settings of the Hubspot connector. This will force the connector to always extract all the data of the selected resources.

Workbench Query Builder - Join

Panoply's query builder now supports joining multiple tables together. Users can either drag columns from different tables or open the Join Query menu directly to define different joins for their query.
Users can choose the join type (Inner, left, right or full) and the join condition in order to get their desired result.

New metadata column

Panoply now notes the initial creation time of a record in each table. The column __createtime will hold the timestamp of the first appearance of a record. If a record already existed before the release of this feature, the value of this column will be null.