Retrieve the available Contact properties history in HubSpot.

Select

The PropertyName filter is required to retrieve data from this view:

SELECT * FROM ContactPropertiesHistory WHERE PropertyName = 'Create Date'

Columns

Name	Type	References	Filterable	Description
PropertyName	String		False	The name of the property.
Value	String		False	The historical value of the property.
SourceType	String		False	The method by which the property was changed.
SourceId	String		False	Additional data related to the source. May not be populated for all sources.
Timestamp	Datetime		False	Datetime when the property was updated.
ContactId	Long		False	The contact identifier.
ContactEmail	String		False	The contact's email address.
ContactPhoneNumber	String		False	The contact's primary phone number.