Microsoft Dynamics 365 for Sales to Google BigQuery mapping

AutoSync maps Dynamics 365 for Sales data types to the following Google BigQuery column types:


Microsoft Dynamics 365 for sales data type	BigQuery column type
`BigIntType`	`INT64`
`BooleanType`	`BOOL`
`CalendarRulesType`	`STRING`
`CustomerType`	`STRING`
`CustomType`	`STRING`
`DateTimeType`	`DATETIME`
`DecimalType`	`NUMERIC`
`DoubleType`	`FLOAT64`
`EntityNameType`	`STRING`
`FileType`	`STRING`
`ImageType`	`BYTES`
`IntegerType`	`INT64`
`LookupType`	`STRING`
`ManagedPropertyType`	`JSON`
`MemoType`	`STRING`
`MoneyType`	`NUMERIC`
`MultiSelectPicklistType`	`STRING`
`OwnerType`	`STRING`
`PartyListType`	`STRING`
`PicklistType`	`INT64`
`StateType`	`INT64`
`StatusType`	`INT64`
`StringType`	`STRING`
`UniqueidentifierType`	`STRING`
`sl_timestamp`	`TIMESTAMP`