January 2022 Release Notes

Postgres (v 3.3.0)

Collecting data using logical replication is now available. In order to use logical replication in your data source you need to:

• Have logical replication enabled on your Postgres server:
  • Server version 10 and higher
  • Set wal_level to logical.
  • Create a publication on specific tables or all tables.
    CREATE PUBLICATION panoply_publication FOR TABLE table1, table2 WITH (publish = 'insert, update'); or CREATE PUBLICATION panoply_publication FOR ALL TABLES WITH (publish = 'insert, update');
  • Set the desired tables to have the replica identity set to FULL: ALTER TABLE table1 REPLICA IDENTITY FULL;
  • Create a Panoply dedicated replication slot.
    SELECT pg_create_logical_replication_slot('panoply_replication_slot', 'pgoutput');
  • Make sure that the connected user in the Panoply data source has replication permissions: ALTER USER replication_user REPLICATION;
• Enable logical replication in the advanced options
• Select the desired publication name.
• Select the desired replication slot name.

Once the logical replication is enabled in Panoply, only tables that are part of the selected publication will be available for selection.

Hubspot (v 2.1.0)

An additional resource was added to the Hubspot data source and is available for collection. The Deals History resource will allow you to see all the changes done in each and every one of the properties of a deal.