Announcements
Which datatype is recommended to use for Customer table primary key and how it affects on refresh performance?
There's not quite the same number of datatypes you're probably used to in a RDBMS. I believe everything is ultimately ingested into SPARK / parquet files so most things will ultimately end up as Strings. Guids for instance do. Unless it's changed recently you can't use Integers so overall, Strings are the most common type. Regarding performance, I don't think there's a whole lot of difference, the m3 process takes a while to process and I don't think you'll notice a whole lot of difference one way or other in general.
Hi James,
The primary key is an attribute unique to the table.
For an attribute to be a valid primary key, it shouldn't include duplicate values, missing values, or null values. String, integer, and GUID data type attributes are supported as primary keys.
https://learn.microsoft.com/en-us/dynamics365/customer-insights/data-unification-map-tables#select-primary-key-and-semantic-type-for-attributes
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 59
Manoj - ManoVerse 50 Super User 2026 Season 1
Muhammad Shahzad Sh... 31 Most Valuable Professional
