# PeopleSocialMediaProfiles - Catalog: `Crisp` - Schema: `Views` This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `PeopleSocialMediaProfiles` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `company_name` | `varchar2` | | ☐ | Company name. | | `handle` | `varchar2` | | ☑ | User handle on online platform. | | `people_id` | `varchar2` | | ☑ | People identifier. | | `person_created_at` | `datetime` | | ☑ | Profile creation timestamp. | | `person_email` | `varchar2` | | ☑ | Email for people profile. | | `person_updated_at` | `datetime` | | ☑ | Profile update timestamp. | | `type` | `varchar2` | | ☑ | Type of social media profile, such as facebook or twitter. | | `url` | `varchar2` | | ☐ | URL for the profile. |