Article
Entropy Data with Snowflake
Dr. Simon Harrer
Co-Founder & CEO, Entropy Data ·
Snowflake is a great platform to store, process, and analyze your data products. Entropy Data integrates well with Snowflake. Entropy Data adds a user-friendly data marketplace for users and agents, data product and data contract management capabilities, a semantic editor experience with full downstream integrations, and governance features to make a data product architecture a success.
Why Snowflake is not enough
Snowflake is a great platform for data engineers and analysts to run SQL on elastic warehouses, build data pipelines, write Snowpark code and notebooks, and share data across accounts. Snowflake CoWork and Cortex Agents, built on semantic views, provide great value for asking the data questions in natural language.
Entropy Data extends Snowflake with capabilities that go beyond data engineering:
- Data marketplace
- Data product ownership, management, and governance
- Data contract enforcement
- Semantic data with open standards
- Multi-platform metadata distribution
Entropy Data integrates well with Snowflake to read information from Snowflake and write semantic data back. But Entropy Data also populates other application, data, and AI platforms with the same semantic definitions.
Data marketplace for users and agents
Data is becoming the driver for decision-making, new business processes, and most agent use cases. A challenge is to find trustworthy data. Entropy Data optimizes for an easy-to-use data marketplace that helps data users and agents find the semantically relevant data products, with trust signals to evaluate them.
In contrast to technical data catalogs, Entropy Data focuses on the few hundred high-quality data products, not the millions of technical data assets.
A colleague from marketing who needs customer data for a campaign does not open a list of databases. They open one page, type what they are looking for in their own words, and get data products back, because the search works on the descriptions, the contracts, and the semantic business definitions. They can also browse: they start from the domains, filter the products by team, type, certification, classification, or tag, and switch between cards and a list until the candidates are down to two or three.
The data map is another way to find data products when you already know which systems and domains are relevant for you. The data map draws every domain with its data products and the flows between them, from the source systems on the left to the reports and semantic models on the right, so a user sees where the customer data comes from, whether there are aggregated data products that might also be interesting, and who else is using them.
Each data product page is written for the person who wants to use the data. The header tells them at a glance which team owns the product and how to reach that team, which domain it belongs to, whether it is certified, how its data is classified, and how its quality checks are doing, and below it they find the description, the output ports with their data contracts, the lineage, example data, and the terms of use, so they can judge in a few minutes whether the product fits their case before they ask anyone.
When the product fits the business case, the access and approval workflow guides the user through the process to actually get access to the data in Snowflake, Power BI, or any other tool they want to use. The user says whom the access is for, themselves, their team, one of their data products, or an AI agent, writes down the purpose (a mandatory field!), and accepts the terms of use of the contract with its purpose and limitations. Entropy Data routes the request to the data product owner to review and approve. When it is approved, the Snowflake connector (built-in provisioning is coming soon) creates the grants in Snowflake, and the access in Power BI or any other tool the user works with.
Of course, more and more agents require access to business data. A data marketplace is the perfect entry point for agents to find data products that are well-documented and of high quality. All features and workflows are designed to be accessible via MCP, APIs, and CLI. In any case, the data product owner stays in control of the data and has an overview of who or what uses which of their data for which purposes.
Snowflake offers marketplace options of its own, but they are built for sharing data between accounts, not for data products:
-
Internal Marketplace with organizational listings.
- It uses the listings of the Snowflake Marketplace, which was designed to share and sell data to other companies, and limits them to the accounts of one Snowflake organization.
- A consumer is a Snowflake account, optionally narrowed to roles in it, not a team, a data product, or an AI agent with an identity of its own.
- Publishing needs an organization administrator and the privileges to create organization listings and shares, so data product owners cannot publish on their own.
- A listing contains a share or a Native App, so it covers only data in Snowflake.
- An access request asks for a role and a reason in free text, with no purpose binding, no accepted terms of use, and no expiry. The approval runs in Snowsight, and programmatic options are only announced.
- Listings carry a description, a few featured tables, sample queries, a refresh rate, a support contact, and a link to terms, but no data contract, semantics, or quality checks.
-
Horizon Catalog.
- Universal Search finds objects by their names, comments, and tags, and the Catalog Explorer lists databases, schemas, and tables.
- It organizes Snowflake objects. Metadata from other platforms such as Power BI, dbt, and Databricks arrives through Horizon Context, which is still in Preview, as is the new Catalog Explorer.
- Business Ontology, announced in November 2026 and in private preview for selected accounts, adds a glossary of business concepts grouped by domain, with relationships and bindings to tables, columns, and semantic views. Its bindings point to Snowflake objects only, and most of the authoring happens in Snowflake CoCo.
- Data quality monitoring and sensitive data classification work on tables, not on promises to consumers, and need the Enterprise Edition.
- It has no access request or approval workflows outside of listings.
The Horizon Catalog in Snowsight organizes databases, schemas, and tables.
Enterprises have more data platforms than just Snowflake: Databricks, legacy data warehouses, operational systems, SAP, MDM, Kafka, and more. A third-party data marketplace such as Entropy Data can provide access to data in all relevant platforms.
Domain ownership for data products
A table with the rows is not usable data yet. Say you find a CUSTOMERS table in
Snowsight and it has the columns you need. But is it the authoritative one, or one of the
three copies other teams made? What does STATUS = 4 mean? Is it refreshed every
night or whenever someone remembers? May you use it for a newsletter? And who do you ask when
a column disappears next month?
The platform cannot answer these from the tables alone. Someone who knows the business has to write it down, and it has to be written down once, where every consumer, human or AI agent, can read it. Without that, every consumer guesses, and AI agents guess even faster.
That is what Entropy Data holds. Data products are the curated tables, exposed as output ports, with everything else hidden. Data contracts describe them with a schema that carries business names and classifications, with terms of use, an SLA, and executable quality rules. Semantics holds the business concepts, Customer, Order, Gross Merchandise Value, with definitions, relationships, and metric formulas, linked from the contract columns. Around all of it sit the owners, the access agreements, and the policies, so it is clear who is responsible, who may use what for which purpose, and what the rules are.
The overall picture
Entropy Data sits above Snowflake, so nothing about how you run Snowflake changes, while Entropy Data adds the layer in which a table becomes a data product with a contract, an owner, consumers, and a meaning. The two layers are connected in both directions, because Entropy Data reads the assets from Snowflake, and whatever the business decides in that upper layer comes back down to the tables as comments, tags, and grants.
Everything in that upper layer is kept in open standards. Data products are stored in ODPS, data contracts in ODCS, semantics in Apache Ossie, and lineage in OpenLineage, all of it YAML you can keep in Git. Snowflake gets it as comments and tags, Databricks, BigQuery, and AWS Glue get the same definitions in their own vocabulary, and your AI agents read it over MCP. That matters because hardly any organization runs on one platform. About 60 percent of Databricks accounts also run Snowflake, according to an ETR survey of 1,800 IT decision makers, and the warehouse that came with the ERP, the BI tool, and a message broker add to the list. Replace a platform, and the definitions stay.
Read from Snowflake, write back to Snowflake and to all your other platforms
Entropy Data reads the databases, schemas, tables, views, and columns of your Snowflake account as assets, through a built-in ingestion that runs on a schedule. Give it a warehouse, an X-Small one is enough, and it imports your semantic views as well, more on those below.
An asset is not a data product yet. Take your orders team. It has forty tables in its schema,
and four of them are the curated result. You pick the four, and they become the output port
of the Orders data product. The other thirty-six stay internal. Entropy Data drafts the data
contract from the asset, so the physical columns are already there, and you add what the
catalog cannot know, such as what CUSTOMER_ID means, how fresh the data is, and
what it may be used for.
Then the metadata flows back through the
metadata writer.
Whenever an active contract changes, Entropy Data writes the
descriptions of the contract's tables and columns as table and column comments in Snowflake,
and the contract's tags, classifications included, as Snowflake tags on the tables and columns. A column
without a description of its own gets the description of its linked concept. The tags
ENTROPY_DATA_CONTRACT, ENTROPY_DATA_URL, and ENTROPY_DATA_CONCEPT
link back to the contract and the concept. Whoever finds the table in Snowsight, or reads
INFORMATION_SCHEMA, reads the definition your business agreed on and can jump to its source.
The metadata writer asks for little. Its role needs no access to the data: REFERENCES
lets it see a table without reading its rows, and APPLY COMMENT and APPLY TAG
let it write without owning the table. It only touches the tags it set itself, so the tags your
platform team or another tool maintains stay as they are, and when a contract is retired, it removes
what it wrote.
Quality rules take the other direction. A scheduled job in your orchestrator or CI pipeline runs the Data Contract CLI against the Snowflake output port and publishes the results to the contract. The Data Quality Score tracks the trend, and you and your consumers get a notification when a check fails or recovers. A schema change that breaks the agreement shows up as a failed check, before a consumer notices.
In Snowflake you see comments and tags on tables and columns, maintained by Entropy Data, and the checks run as SQL on your warehouse.
Semantics give every column a meaning
A contract says that EMAIL is a string and may not be used for marketing. It does
not say what a customer is, whether the customer in the Orders product is the same as the one
in the CRM export, or how Gross Merchandise Value is calculated. That is the job of
semantics. Business concepts such as Customer, Order, and Gross
Merchandise Value live in a namespace with a definition, their properties, their
relationships, and metric formulas, written in Apache Ossie YAML and owned by a team like
everything else. Apache Ossie started in 2025 as the Open Semantic Interchange, launched by
Snowflake and its partners, so the format is native to the Snowflake ecosystem.
Together, the concepts and their relationships form a business ontology: Order has part Line Item, Customer places Order, Region classifies Customer. You do not have to start from a blank page. Entropy Data ships industry ontologies such as FIBO for finance, GoodRelations for e-commerce, and TM Forum SID for telcos, and it imports your own OWL and RDF files, so the vocabulary your architects already maintain becomes the vocabulary of your data products.
Contract columns link to these concepts. A column that links to Customer Email inherits its description, its classification, and its validation rule, so the definition is written once and a change reaches every contract that uses it. The reverse lookup answers the question a privacy officer asks first, which data products contain customer email addresses. Colleagues and AI agents propose changes on a branch, domain experts review them in the UI, and the merge lands in every contract.
Snowflake has started down the same road. Its Business Ontology, announced in November 2026 and in private preview, lets data stewards approve one definition per business concept, relate the concepts, and bind them to tables, columns, and semantic views, so that Cortex works from the approved meaning. That is a good sign for everyone who argued that agents need governed meaning, and it fits well with Entropy Data. The difference is the scope. Snowflake's ontology describes Snowflake objects for Snowflake's AI. The ontology in Entropy Data describes your business, in the open Apache Ossie format, kept in Git, reviewed on branches, and linked to data products on every platform, Snowflake included. When the same Customer concept is implemented in Snowflake, in Databricks, and in a Kafka topic, it is defined once and reaches all three.
If your analysts already model metrics in Snowflake semantic views, that work is not lost. The ingestion imports every semantic view with its logical tables, dimensions, facts, and metrics, and links it to the base tables it uses. A data contract created from a semantic view states each dimension, fact, and metric with its expression and its source table, so the logic that Cortex Agents and Snowflake CoWork query becomes visible, owned, and governed next to the rest of the data product.
In Snowflake, the concept arrives as the column comment where the contract has
none of its own, and as the tags ENTROPY_DATA_CONCEPT and
ENTROPY_DATA_CONCEPT_URL, so everyone who looks at the column sees the agreed
definition and a link back to it. Once Business Ontology has an API, the concepts will be
written there as well, so Cortex works from the definitions your business agreed on in Entropy Data.
Ownership
A table in Snowflake has an owner role for its privileges. A data product needs an owner for its promises, someone who answers questions, approves access, and fixes the pipeline when a check fails.
In Entropy Data, a team is the smallest unit of ownership. Every data product, data contract, and semantic namespace belongs to a team, teams belong to domains, and roles are inherited down the hierarchy. Consumers see who is responsible and how to reach you on every product page.
Access requests go to the people with the Approver role on your team. Quality
alerts reach you and the consumers who watch the contract. Change requests for your products
land in your inbox. And the
Data Product Score
shows which products still lack an owner, a description, or a contract. We wrote down the
reasoning in The 4 Principles of Data Ownership.
In Snowflake, the owner role stays the technical owner of the objects. The business owner, the team, and their roles live in Entropy Data, where the requests arrive.
Access for humans and agents
A consumer who has found a data product in the marketplace and read its contract requests access with a purpose and accepts the terms of use as part of the request, and your team approves or rejects it with an AI evaluation of the request against those terms right next to the buttons, while every step lands in the audit trail. Where a manual decision adds nothing, access can be auto-approved per output port, and where you already run an approval workflow, it can take over through the API.
Today, the consumer is not necessarily a person. A request can come from a user with their company SSO account, from a team so that everyone on it gets access at once, from another data product that builds on this one, or from an AI agent with an identity of its own, and none of them needs a Snowflake login to browse the marketplace and ask. What they asked for is also what they get, because purpose-based access control checks at query time that the data is used for the purpose that was approved.
Once the access agreement is active, the open-source Snowflake connector turns it into grants in Snowflake, and when the agreement is deactivated, it takes them back. The connector runs in your own network, in a DMZ if your security team prefers, and since it is open source, you can fork it to match the role model you already have.
Built-in access provisioning for Snowflake is coming soon. Like the metadata writer, it will run inside Entropy Data with no deployment of your own, turn active access agreements into grants, take them back when an agreement expires or is canceled, and report the provisioning status back to the agreement. The connector stays the option for teams that want the provisioning to run in their own network.
When people and agents query the data from Entropy Data, through MCP or the Entropy Intelligence chat, the query runs with their own Snowflake credentials, set up once as a personal connection, optionally through External OAuth with your identity provider. Snowflake keeps enforcing its roles, masking policies, and row access policies, and Entropy Data never copies a row.
Governance
Governing tables does not scale, because a platform holds millions of them and a rule such as "every dataset with personal data has a retention period" cannot be checked table by table, whereas an organization has a few hundred data products, each with a contract that states what it contains and a team that answers for it, which is a number governance can actually work with.
Entropy Data governs at the level of products, contracts, and access agreements, and the tables underneath them inherit the result. Policies are written in plain language, and Data Governance AI checks every product and contract against them continuously and reports its findings to the owner, who stays in charge of the fix. Certifications with defined criteria mark the products consumers can rely on, while classifications such as GDPR categories are derived from the contract and the linked concepts and inherited by every column that carries the concept, so nobody tags personal data column by column. The terms of use a consumer accepted when requesting access are enforced when the data is queried, every change is kept in the audit trail with a side-by-side comparison, and an optional change process requires approval before a product or contract changes at all.
The Data Product Score is where you define what a good data product looks like in your organization. It rates every product against rules grouped by the FAIR principles, such as a description of a useful length, an owner, a contract, recent test results, and example data, and you weight the rules, scope them to product types, or add your own as expressions or as instructions an AI judges. The leaderboard under Governance then ranks every product and names the biggest gap of each one, which brings a bit of gamification into governance, because teams see where they stand next to the others and what one change would move them up, and the team and domain averages make it visible where to help.
In Snowflake, classifications and certifications arrive as tags, and access decisions arrive as grants, while the policy, the reasoning, and the history stay in one place.
Everything is an API
A business view that only exists in a UI would be one more place to maintain by hand, so everything you see in Entropy Data is also an API, and the layer fits into the tooling you already run. The REST API covers data products, contracts, semantics, access, teams, policies, test results, and the Snowflake metadata writer itself. Two command-line tools bring it into CI pipelines. The open-source Data Contract CLI lints a contract, runs its quality checks against the Snowflake output port, and publishes both the contract and the results to Entropy Data, while the Entropy Data CLI works on the organization as a whole, exporting and applying data products, contracts, semantics, teams, and settings as YAML, or syncing them from one instance to another.
Contracts, products, and semantic namespaces can be synced with GitHub, GitLab, Azure DevOps, or Bitbucket, so changes arrive as pull requests and go through the review your code already gets, and an event feed turns every access that is activated, deactivated, or provisioned into something your own systems can react to. That event feed is also what the Snowflake connector listens to. AI agents get the same business view through an MCP server, with the same access rules a person has in the UI, and users, teams, and roles come from your identity provider through SCIM and SSO.
In a typical setup, the contract lives in Git, a CI job runs the Data Contract CLI to test it on Snowflake and publish the contract and the results, and your agents read the whole thing over MCP, while the UI is where people request, approve, and look things up.
Entropy Data works across all your app, data, and AI platforms
Snowflake was the example on this page, but nothing above is specific to it. Entropy Data reads assets from Databricks, BigQuery, AWS Glue and S3 Tables, Microsoft Fabric, Redshift, Trino, and the other platforms you run, it writes the same descriptions and tags back to Databricks Unity Catalog, the BigQuery Knowledge Catalog, and AWS Glue in each one's own vocabulary, and it provisions access through open-source connectors where the platform has no native writer yet. The integrations page keeps the current list.
That is what makes the layer above the platforms worth having. A data product with an output port on Snowflake and another on Databricks is one product with one owner, one contract, and one set of definitions, and whatever changes in Entropy Data lands in both places at once, while a consumer who requests access does not have to know, or care, which platform holds the tables.
What to do where
The short version of this article is a split of responsibilities, with each side handing the other what it needs. The highlighted cell shows where a task lives.
| What you want to do | Snowflake | Entropy Data |
|---|---|---|
| Store, process, and query the data | Primary place. The tables never leave Snowflake. | Reads the assets and links back to them, and lets you query the data through Entropy Intelligence and the MCP server with your own Snowflake credentials. Never copies a row. |
| Find data by business need | Snowsight search and the Horizon Catalog for databases, schemas, and tables. | Primary place. Marketplace search, domains, and the data map, for people and agents without a Snowflake login. |
| Describe data as a product with a contract, terms of use, and an SLA | Receives the descriptions and tags as comments and tags. | Primary place. Data products in ODPS, data contracts in ODCS, in Git if you like. |
| Define business concepts, relationships, and metrics | Semantic views for the metrics that Cortex Agents query, imported by Entropy Data. Receives the concept as a comment and tag on the column. Business Ontology follows once the API is available. | Primary place. Business ontology in Apache Ossie, with industry ontologies to start from, linked from the contract columns on every platform. |
| Run the quality checks of a contract | Primary place. The Data Contract CLI runs the checks as SQL on your warehouse. | Receives the results, tracks the Data Quality Score, and notifies the owner and consumers. |
| Name the team that answers for a data product | The owner role stays the technical owner of the objects. | Primary place. Teams, domains, roles, and the inbox where requests and alerts arrive. |
| Request, approve, and audit access with a purpose | Enforces the grants that the Snowflake connector writes, built-in provisioning coming soon, plus your masking and row access policies. | Primary place. Requests with purpose and terms, approval with an AI evaluation, audit trail, and expiry. |
| Govern with policies, certifications, and classifications | Receives classifications and certifications as tags. | Primary place. Plain-language policies checked by AI, certifications, classifications inherited from concepts, and the Data Product Score. |
| Let AI agents find and use data | Primary place. Cortex Agents and Snowflake CoWork work on the tables and semantic views. | Primary place. The MCP server gives agents the business view, their own identity, and purpose-checked access. |
Getting started
- Connect your Snowflake account based on our Snowflake integration guide, and add the metadata writer to write descriptions and tags back.
- Create your first data product from a Snowflake table or semantic view, write its contract, and run the checks with the Data Contract CLI.
- Deploy the open-source Snowflake connector to turn approved access requests into grants, until the built-in access provisioning arrives.
- Try the flow end to end in the Entropy Data demo, or start with the free Community Edition.
About the author
Dr. Simon Harrer
LinkedIn of Simon HarrerCo-Founder & CEO, Entropy Data
Simon builds tools that help data, people, and AI work together. He holds a PhD in distributed systems, spent seven years at INNOQ as a software architect and consultant, and co-founded Entropy Data, where he leads the company as CEO.