Notifications
Announcements
No record found.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 171 Super User 2025 Season 2
#ManoVerse 83
Jimmy Passeti 50 Most Valuable Professional
