Insight into data requires users to build performant data models. Key and unique constraints provide structures to access data efficiently. Key Finder mines a data source to automatically find all valid key and unique constraints. Sample data and various measures of validity help users choose the key and unique constraints helpful for tasks such as managing entity and referential integrity, defining index structures, identifying dirty data, and finding all ids that reference the same entity.
- Data Integration: Key Finder is capable of automatically discovering keys that hold exactly on your dataset and checking the degree to which any other attribute combinations hold as keys. This information serves as a foundation for finding correct foreign keys and joining tables.
- Data Quality: A very common problem that exists in production databases is data duplication. The same entity will often appear more than once in a table with different auto-generated ids. Key Finder makes it easy to quickly discover if this problem is present in your data.
- Performance Optimization: One of the most important aspects of building a performant data model is choosing the right indexes to speed up data access. Key Finder quickly finds and suggests all attribute combinations that may serve as indexes.
Additionally, Key Finder automatically calculates metadata for sampled tables such as the number of null values and the number of distinct not-null values in the original table.
Free – This is a demo version of the extension available when you access it through the Tableau Exchange. It has some limitations compared to the full version that make it suitable for testing and evaluation purposes only. The restrictions for the demo version are: tables that are sampled cannot contain more than 1 million rows, samples are only stored for 1 hour and permanently deleted after that. Additionally, the demo version runs on our servers and cannot be deployed to the infrastructure that you manage.
Paid – None of the restrictions of the demo version apply to the full version. Please contact us if you are interested in purchasing the full version.
To find out more about pricing and watch a demo video of this dashboard extension, please visit our website.