Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Data sources that are represented as views are typically read-only data sources. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard. To find out more about tables and stored procedures, please navigate to their corresponding entries in this help document.

Name	Description
	This table lists formulas for the specified TableName.
JobRecordResultsV2	Retrieves a list of records for a specific job.
PickListValues	This table lists picklist values for the specified TableName.
TableRelationships	Lists relationships in the specified table.

Note: Querying the table without a TableName filter specified will attempt to retrieve column metadata for all objects in your Salesforce with SSO account. Depending on the number of objects, this can take a while.

Name	Type	Description
TableName	String	The name of the table. This must be specified when retrieving data from Formulas.
ColumnName	String	The name of the column associated with the Formula.
Formula	String	The formula associated with this field.

Name	Type	Description
ID [KEY]	String	ID of the record that was successfully processed.
Created	Boolean	The name of the table. This must be specified when retrieving data from PickListInformation.
RowFromOriginalCSV	String	Truncated row that was provided in the original job data upload request.
JobId	String	Specified the unique Id of the job.
RecordState	String	Specifies the type of the records that were processed by Salesforce. Valid values are 'Successful', 'Failed', 'Unprocessed'.
ColumnDelimiter	String	The column delimiter used for CSV job data. Valid values are 'BACKQUOTE','CARET','COMMA', 'PIPE', 'SEMICOLON', 'TAB'.

Name	Type	Description
ID [KEY]	String	The unique identifier of the picklist in the format ColumnName\|Picklist_Value.
TableName	String	The name of the table. This must be specified when retrieving data from PickListInformation.
ColumnName	String	The name of the column associated with the picklist entry. This may be optionally specified to only retrieve picklist information with regards to the specified column.
PickList_Value	String	The picklist value.
PickList_Label	String	The label for the picklist value.
PickList_IsActive	Boolean	A boolean indicating if the picklist value is active.
PickList_IsDefault	Boolean	A boolean indicating if this picklist value is the default value for the column it is associated with.

Name	Type	Description
ChildsObject [KEY]	String	The child table that is related to the specified TableName in the input.
RelationshipName [KEY]	String	The name of the relationship.
Field	String	The field the relationship is associated on. Found in the ChildsObject.
ParentObject	String	The parent object in the relationship. This is the same as the input TableName.
DeprecatedAndHidden	Boolean	Boolean indicating if the relationship is deprecated and now hidden.
CascadeDelete	Boolean	Boolean stating if this entity is deleted, does the child object also get deleted.

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.