Remarks
The Simba Salesforce Marketing Cloud ODBC Driver provides a Remarks column with the data. This column contains additional metadata for each column and table.
The metadata is provided in the form of a flattened JSON string. It is recommended that you use a third-party JSON formatting tool to view the metadata.
The Remarks column for a column includes some or all of the JSON fields described below. The Remarks column for a table includes only the label and privileges JSON fields.
- label: The server-side column or table label. Only present if the server-side label does not match the connector-side label.
- privileges: Indicates whether the column or table can be created, selected, updated, or deleted. For example, a column that is selectable and updatable would have the value
{"privileges":{"select":"true","update":"true"}. - picklistValues: The available values and labels for an ENUM column. Only present if the column is an ENUM column.
- typeName: The server-side name for the column's data type. Only present if the server-side data type is a customized data type that does not match the connector-side data type.
- compoundFieldName: The name of the compound JSON field that the column is a member of. Only present if the column is a member of a compound JSON field in a server-side response.
- compoundFieldSchema: The complete JSON content for the column. Only present if the column is a member of a compound JSON field, and the connector cannot determine the schema for the field. In this case, the field contains all the schema information so that the user can determine the schema for the compound JSON field.
For example, consider an ENUM column named email, which accepts 0, 1, and
2 as values. 0 indicates the primary email address, 1 indicates alternative email
address 1, and 2 indicates alternative email address 2. The Remarks column
would include the following:
"picklistValues":[{"value":"0","label":"Primary"},{"value":"1","label":"Alternative1"},{"value":"2","label":"Alternative2"}]