Skip to main content

Connector PCC Release Notes

Cherre Connector Release Notes (Updated 05/30/2025)

Kimberly Garcia avatar
Written by Kimberly Garcia
Updated over 3 weeks ago

Summary

Cherre remains dedicated to continuously expanding our data ecosystem and enhancing platform capabilities. Each month, our team works diligently to introduce new pre-configured connectors (PCCs), refine existing ones with valuable updates, and implement performance improvements across the board. We encourage you to carefully review the latest release notes to stay fully informed about the significant advancements and new features designed to empower your real estate data strategy.

Below are the release notes for each revision of each PCC. Schema change details are provided for any revision where the set of tables changes. Revisions are listed with the most recent updates at the top.

Preconfigured Application Connectors

Altrio Origin

  • Revision 2 (Jan 2025):

    • Enables delivery of data from the deals endpoint.

  • Revision 1 (Oct 2024):

    • Renamed tables:

      • From altrio_deal_assets_field_values to altrio_sales_comps_field_values

      • From altrio_deal_assets to altrio_sales_comps

    • Added new column named field_values to all tables.

  • Revision 0 (Oct 2024):

    • Introduced the Altrio PCC, incorporating the following tables:

      • altrio_deal_assets_field_values

      • altrio_deals_field_values

      • altrio_unit_comps

      • altrio_deal_assets

      • altrio_lease_comps_field_values

      • altrio_assets

      • altrio_lease_comps

      • altrio_unit_comps_field_values

      • altrio_assets_field_values

      • altrio_deals

Argus DDI - 5-8

  • Revision 8 (Feb 2025):

    • Small corrections in data dictionary.

  • Revision 7 (Feb 2025):

    • Grammar/syntax fixes in data dictionary.

  • Revision 6 (Jan 2025):

    • Added data dictionary with column descriptions.

  • Revision 5 (Dec 2024):

    • Fixed issue with the argus_leases creating an empty table.

Table Description

Table Name

Introduced in Revision#

Accounts

argus_accounts

1

Calculated KPIs

argus_calculated_kpis

1

Chart of Accounts

argus_chart_of_accounts

1

Credit Losses

argus_credit_losses

1

General Vacancies

argus_general_vacancies

1

Inflation Rates

argus_inflation_rates

1

Leases

argus_leases

1

Line Item Types

argus_line_item_types

1

Market Leasing Assumption Details

argus_market_leasing_assumption_details

1

Market Leasing Assumptions

argus_market_leasing_assumptions

1

Portfolios

argus_portfolios

1

Properties

argus_properties

1

Property Cash Flow Results

argus_property_cashflow_results

1

Property Classifications

argus_property_classifications

1

Property Full Results

argus_property_full_results

1

Property KPI Results

argus_property_kpi_results

1

Property Resale Adjustments

argus_property_resale_adjustments

1

Property Resale Details

argus_property_resale_details

1

Property Resales

argus_property_resales

1

Scenarios

argus_scenarios

1

Tenant Classifications

argus_tenant_classifications

1

Tenant Results

argus_tenant_results

1

Units

argus_units

1

Valuation Assumptions

argus_valuation_assumptions

1

Chatham Debt API

Chatham SFTP

  • Revision 2 (May 2025): Added chatham_funds and chatham_fund_ownership tables.

  • Revision 1: Fixed empty tables for chatham_asset_values_noi_details and chatham_asset_values_property_value.

  • Revision 0: Initial preconfigured model for Chatham SFTP.

Chatham YAML

  • Revision 4 (May 2025): New revision for Chatham PCM.

  • Revision 3: Includes additional data fields and tables.

  • Revision 2: Data dictionary and new fund tables.

  • Revision 1: UI and provider name adjustments for consistency.

  • Revision 0: Initial version of Chatham PCM.

Enertiv

  • Revision 0 (Sep 2024):

    • Introduced the Enertiv PCC, incorporating the following tables:

Table Description

Table Name

Introduced in Revision#

Locations

enertiv_locations

0

Locations - Portfolio Manager Metrics

enertiv_locations_portfolio_manager_metrics

0

Locations - Client IDs

enertiv_locations_client_ids

0

Locations - Equipment IDs

enertiv_locations_equipment_ids

0

Locations - Sublocations

enertiv_locations_sublocations

0

Alerts Scores

enertiv_alerts_scores

0

Energy Star Scores

enertiv_energy_star_scores

0

Insight Scores

enertiv_insight_scores

0

Maintenance Scores

enertiv_maintenance_scores

0

Tenant Billing Scores

enertiv_tenant_billing_scores

0

Meters

enertiv_meters

0

Meters - Channels

enertiv_meters_channels

0

Meters - Meter Insight Set

enertiv_meters_meterinsight_set

0

Equipment

enertiv_equipments

0

Equipment - Equipment Metadata Set

enertiv_equipments_equipmentmetadata_set

0

Equipment - Channels

enertiv_equipments_channels

0

Sublocations

enertiv_sublocations

0

Sublocations - Equipment

enertiv_sublocations_equipments

0

MRI API

  • Revision 5 (May 2025):

    • UI enablement; added config fields for UI and v1 temporary versioning for safe rollout.

    • Summary: MRI PCC UI Enablement - PCS. Added config fields to enable in UI, bumped SHA to reflect ingest code updates for UI config.

    • Tables:

      • ​mri_commercial_buildings

      • mri_commercial_building_sqft

      • mri_commercial_building_suites

      • mri_commercial_leases

      • mri_commercial_leases_recurring_charges

      • mri_commercial_suite_sqft

      • mri_commercial_tenant_types

      • mri_entity_listings

      • mri_income_categories

  • Revision 4 (May 2025):

    • Upstream unnesting update for mri_commercial_building_suites.

    • Summary: Updated unnesting logic for mri_commercial_building_suites.

    • Tables:
      Same as Revision 5 but without the mri_commercial_suite_sqft table and SOURCE_SUFFIX env.

  • Revision 3 (May 2025):

    • New revision for test DAGs.

    • Summary: Created new revision to test the DAG.

    • Tables:
      Same as Revision 4.

  • Revision 2 (May 2025):

    • Released new tables in prod.

    • Summary: Created revision 0002 to release new tables in prod.

    • Tables:
      Same as Revision 4.

  • Revision 1 (May 2025):

    • Added compatible source for MRI model.

    • Summary: Creating a new revision 0001 to MRI so new changes are available.

    • Tables:
      Same as Revision 4.

  • Revision 0 (May 2025):

    • Initial preconfigured model for MRI PCC.

    • Summary: Initial creation of MRI preconfigured model.

Description

Table Name

Introduced in Revision#

Commercial Buildings

mri_commercial_buildings

Commercial Building Square Footage

mri_commercial_building_sqft

Commercial Building Suites

mri_commercial_building_suites

Commercial Leases

mri_commercial_leases

Commercial Lease Recurring Charges

mri_commercial_leases_recurring_charges

Commercial Tenant Types

mri_commercial_tenant_types

Entity Listings

mri_entity_listings

Income Categories

mri_income_categories

RealPage AIRM

Coming soon!

RealPage Onesite

Coming soon!

Reltio

Coming soon!

Venminder

Coming soon!

VTS Historical

Cherre has introduced historical data tracking for tables within the VTS preconfigured connector (PCC). This enhancement addresses the absence of native historical data provisioning in VTS.

  • Revision 0 (Jan 2025):

    • Introduced the VTS Historical PCC, incorporating the following tables:

    • Assets Historical

    • Assets Asset Managers Historical

    • Assets Clients Historical

    • Assets External IDs Historical

    • Assets JV Partners Historical

    • Assets Property Funds Historical

    • Assets Years Renovated Historical

    • Blended Budgets Historical

    • Budgets Historical

    • Budgets Blended Budgets Bridge

    • Budgets Base Rents Historical

    • Budgets Commissions Historical

    • Budgets Commissions Schedules Historical

    • Budgets Costs Historical

    • Budgets Free Rents Historical

    • Budgets Other Incomes Historical

    • Budgets Percentage Rents Historical

    • Budgets Percentage Rents Sales Overage Breakpoints Historical

    • Budgets Reimbursable Expenses Historical

    • Budgets Rent Escalations Historical

    • Budgets Rent Schedules Historical

    • Budgets Tenant Improvements Historical

    • Coordination Project Milestones Historical

    • Coordination Projects Historical

    • Deal Approvals Historical

    • Deal Approvals Approvers Historical

    • Deal Comments Historical

    • Deal Financials Historical

    • Deal Iterations Historical

    • Deal Tasks Historical

    • Deal Terms Historical

    • Deal Terms Spaces Bridge

    • Deal Terms Commissions Historical

    • Deal Terms Commissions Schedules Historical

    • Deal Terms Costs Historical

    • Deal Terms Other Incomes Historical

    • Deal Terms Percentage Rents Historical

    • Deal Terms Percentage Rents Sales Overage Breakpoints Historical

    • Deal Terms Reimbursable Expenses Historical

    • Deal Terms Remaining Lease Obligations Historical

    • Deal Terms Rent Escalations Historical

    • Deal Terms Rent Schedules Historical

    • Deal Terms Tenant Risks Historical

    • Deal Tours Historical

    • Deals Historical

    • Deals Assets Bridge

    • Deals Deal Leads Bridge

    • Deals Spaces Bridge

    • Deals Brokers Historical

    • Deals Contacts Historical

    • Deals Requirements Target Locations Historical

    • Global Tenants Historical

    • Lease Terms Historical

    • Lease Terms Spaces Bridge

    • Lease Terms Base Rents Historical

    • Lease Terms Commissions Historical

    • Lease Terms Costs Historical

    • Lease Terms Free Rents Historical

    • Lease Terms Other Incomes Historical

    • Lease Terms Percentage Rents Historical

    • Lease Terms Percentage Rents Sales Overage Breakpoints Historical

    • Leases Historical

    • Leases Retail Sales Historical

    • Proposals Historical

    • Proposals Deal Terms Bridge

    • Spaces Historical

    • Spaces External Ids Historical

    • Tenant Contacts Historical

    • Tenant Industries Historical

    • Tenant Updates Historical

    • Tenants Historical
      ​

​VTS

  • Revision 6 (Apr 2025):

    • Summary:

      • Latest revision as of this release.

      • Expanded and updated transformation logic.

      • Ensured up-to-date integration with VTS sources and the latest requirements.

  • Revision 5 (Jan 2025):

    • Summary:

      • Introduced a new revision focused on VTS Historical data.

      • Extended or adapted the model for historical context and reporting use cases.

        • Added/updated vts_appraisals, vts_appraisals_base_rents, vts_appraisals_commissions.

      • Maintained compatibility with existing data pipelines.

  • Revision 4 (Dec 2024):

    • Summary: Added new revision for VTS PCM.

    • This PR contains several cleanups and improvements.

      • Aligning data dictionary

        • vts_assets

          • Missing field legal_entity added

        • vts_blended_budgets

          • total_free_rent_uom was incorrectly named total_free

        • vts_deal_financials

          • Removed rent_escalation_frequency, rent_escalation_frequency_interval (all null for all clients using, was not part of DD)

        • vts_deal_tours

          • The DD had specified deals_id, users_id, and spaces_id but they were missing from the dbt models. They just needed to be extracted from the relationships object.

        • vts_coordination_project_milestones

          • rename milestones_id to coordination_project_milestones_id

      • Deduplicating bridge tables

        • Assigned deduplication to:

          vts_deals__deal_leads__bridge vts_deals__assets__bridge vts_budgets__blended_budgets__bridge vts_proposals__deal_terms__bridge vts_lease_terms__spaces__bridge vts_deal_terms__spaces__bridge vts_deals__spaces__bridge

      • Remove cherre_hash/stream_name from cardinal

        • We need to start following the standard. Removed cherre_hash from:

          vts_deal_terms_cardinal.sql vts_leases_cardinal.sql vts_deal_iterations_cardinal.sql vts_users_cardinal.sql vts_coordination_projects_cardinal.sql vts_tenants_cardinal.sql vts_assets_external_ids_cardinal.sql vts_assets_cardinal.sql vts_deal_tasks_cardinal.sql vts_deal_tours_cardinal.sql vts_blended_budgets_cardinal.sql vts_appraisals_cardinal.sql vts_global_tenants_cardinal.sql vts_tenant_updates_cardinal.sql vts_leases_retail_sales_cardinal.sql vts_deal_comments_cardinal.sql vts_deal_approvals_cardinal.sql vts_coordination_project_milestones_cardinal.sql vts_lease_terms_cardinal.sql vts_tenant_industries_cardinal.sql vts_tenant_contacts_cardinal.sql vts_spaces_external_ids_cardinal.sql vts_spaces_cardinal.sql vts_deal_financials_cardinal.sql vts_proposals_cardinal.sql vts_budgets_cardinal.sql vts_deals_brokers_cardinal.sql vts_deals_cardinal.sql

        • Removed cherre_stream_name from

          vts_deal_tours_cardinal.sql vts_appraisals_reimbursable_expenses_cardinal.sql vts_appraisals_cardinal.sql vts_budgets_cardinal.sql

  • Revision 3 (Dec 2024):

    • Summary:

      • Enhanced transformation logic and mappings.

      • Incorporated feedback and improved metadata.

      • Continued improvements for stability and client-specific requirements.

  • Revision 2 (Nov 2024):

    • Summary:

      • Incremental update to the model.

      • Ongoing support for the existing set of VTS tables and data flows.

      • Included bug fixes and performance improvements.

Note:
If any future revision introduces changes in the table schema (such as new tables, removed tables, renamed tables, or changes in table structure), those changes will be detailed in the "Schema Change Details" section under the respective revision.

Yardi AssetIQ

  • Revision 1 (May 2025): Data dictionary added.

  • Revision 0 (Apr 2025): Initial creation of the Yardi Asset IQ preconfigured model.

    • Tables:

      • yardi_assetiq_kpi_financials

      • yardi_assetiq_kpi_operations

      • yardi_assetiq_kpi_rents

      • yardi_assetiq_kpi_prospects
        ​

Yardi Voyager 7S ETL 31-35

  • Revision 25:

    • New Tables Added:

      • Residential_ResRoommate

      • Residential_ResTenantHistory

    • New Columns Added to Existing Tables:

      • Commercial Leases (CommLeases):

        • is_quantity_billing

        • lease_type_lease_recovery_type_code

        • lease_type_system_type_code

      • Commercial Lease Types (CommLeaseTypes):

        • lease_type_system_type_code

        • lease_type_lease_recovery_type_code

      • Tech Debt/Backend Improvements:

        • ResProspects ETL will discard records with NULL prospect_code


​

Yardi ETL Move Model

  • Revision 3 (Mar 2025): Producer/consumer enablement for UI flow.

  • Revision 2: Added passthrough attributes

    • Tables:

      • yardi_one_to_manys

      • yardi_one_to_manys_attributes

      • yardi_commercial_kpis

      • yardi_commercial_kpis_attributes

      • yardi_residential_kpis

      • yardi_residential_kpis_attributes

  • Revision 1: Added support for yardi_im_kpis.

    • Tables:

      • yardi_one_to_manys

      • yardi_im_kpis

  • Revision 0: Initial PCM for yardi-etl-passthrough.

    • Tables:

      • yardi_one_to_manys

Yardi ETL Passthrough (One to manys)

Info coming soon!

Yardi Voyager 7S Replicate 1-7

  • Revision 7 (May 2025): Hotfix – Added deduplication logic for all models.

  • Revision 6 (May 2025): New revision for Yardi Replicate.

  • Revision 5 (May 2025): PCM revision for incident fix.

  • Revision 4 (Apr 2025): PCM revision for bugfixes/updates.

Yardi Voyager 7S Replicate Move Model

  • Revision 4

    • Summary: Addition of 11 new tables.

  • Revision 2

    • Summary: Added _move suffix to output tables as per new standards.

  • Revision 1

    • Summary: Changed datatype for BIGNUMERIC column to STRING for Snowflake egress compatibility.

Zoneomics 1

yaml

  • Revision 1 (May 2025): Zoneomics PCM Revision 1, additional tables, and data available.

  • Revision 0 (May 2025): Initial preconfigured model for Zoneomics, with compatible preconfigured sources and initial tables.

  • Tables:

    • parcel_boundary_v2__zoneomics_bridge

    • usa_map_parcel_v2__zoneomics_bridge

    • zoneomics_jurisdictions

    • zoneomics_jurisdictions_data_available

    • zoneomics_jurisdictions_details_properties

To the Top!

Preconfigured Data Connectors

AGS Canadian Demographics

Altus Databridge

  • Revision 0 (Jan 2025):

    • Creation of the Altus Databridge PCC which includes the following tables:

      • altus_databridge_client_assets

      • altus_databridge_benchmarks

Attom Rental AVM

BuildCentral

BuildZoom Permits

Clear Capital

CompStak Leases

CompStak Market Trends

CompStak Sales

Constellation1

  • Revision 9 (May 2025): PCM revision for bug fixes and improvements.

  • Revision 8: Various updates and new address source.

Dwellsy

Green Street Connect Model

  • Revision 5

    • Details: Added new preconfigured model revision for greenstreet_connect.yaml to pick up latest changes and bug fixes.

    • Tables: Includes all Green Street Connect tables such as green_street_connect_company_cvni, green_street_connect_company_market_breakouts, ..., green_street_connect_us_market_zip_mappings.

  • Revision 4

    • Details: Added missing source suffix (SOURCE_SUFFIX: v0). All external tables included the source suffix. Ensured all tables and structure match the latest requirements.

    • Tables: Same as revision 5.

  • Revision 3

    • Details: Created a new revision for recent dbt changes.

      • Tables: Same as revision 4 (all connect tables).

  • Revision 2 and 1

    • Details: Initial creation and early revisions for Green Street Connect Preconfigured Model, introduced the structure and basic table set.

Green Street Move Model

Info coming soon!

Hazard Hub

NCREIF NPI and ODCE

RCA Market Trends

  • Revision 1 (May 2025): Initial PCM for RCA Connect Transactions. Enables deployments for client-specific RCA transactions dataset.

MSCI - RCA Sales Connect Model

  • Revision 3 (May 2025): Data dictionary model revision.

  • Revision 2: Update to pick up latest dbt changes.

  • Revision 1: Transform revision to include latest field updates.

  • Revision 0: Initial PCM for RCA Connect.

  • Table:

    • rca_sales

MSCI - RCA Sales Movel Model

  • Revision 2 (Dec 2024): Latest dbt changes for RCA Move.

  • Revision 1: Transform revision for field updates.

  • Revision 0: Initial PCM for RCA Move.

  • Table:

    • rca_move_sales

RealPage Axiometrics

Trepp CRE Income Aggregates

Trepp Loan Universe

Trepp Operating Statements (FKA CMBS)

Did this answer your question?