Skip to main content
Don’t miss what’s next at Microsoft Ignite
Don’t miss what’s next at Microsoft IgniteGet direct access to the people, products, and expertise behind Microsoft technology, with opportunities to ask questions, build skills, and learn alongside the community.
Register now
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/datameaning.dm-data-control-tower-e45e80fd-4667-4e31-8fea-ed391c79ef75/image5_logo300216x216.png

Data Control Tower

by Data Meaning Services Group Inc

See who uses your Redshift, Databricks or Snowflake data, what it costs, and who has access.

Is your data used, and is access under control?

Your catalog lists the data you have. Data Control Tower shows what happens to it on Amazon Redshift, Databricks and Snowflake, any one of them or all three: who uses which data and how much, what it is used for, what it costs, whether access is under control, and where access changed. Every page ends in ranked actions, grouped by who acts. It deploys into your own Azure subscription, reads the records each platform already keeps, and never writes to any of them.

For the data office and security: eight pages

  • Home: every platform in one view, and the top action for each question.
  • Usage: who uses the data by department, the tables nobody reads, and people with access they never use.
  • Query patterns: what people do, with which tools, when, and which tables they combine by hand.
  • Cost: the monthly bill for each platform, split by person and department, with idle Snowflake warehouses.
  • Access: leavers who still hold access, admin power, refused attempts, personal data that left, and every change with who made it.
  • Service accounts: what each automated account does and costs, and any a person opened from a laptop.
  • Production: sensitive production data copied into sandbox and development, and test tables nobody reads.
  • Actions: every action from every page, ranked by severity, each with how to fix it.

Leaders can also ask the same questions from Claude, or another assistant that supports the Model Context Protocol (MCP), and get the same numbers the pages show.

For data owners and stewards: My assets

Each owner and steward sees only the tables and views they look after, on any platform: who uses them, who can reach them, whether any of the data left, and whether it was copied outside production.

What it reads, and what it keeps

  • Redshift, provisioned or Serverless, through the Redshift Data API. The product signs in with its own Azure identity, trusted by a read-only AWS role, so no Redshift password or AWS key is stored.
  • Databricks system tables, through read-only grants. No Databricks token is stored.
  • Snowflake's usage history (ACCOUNT_USAGE), through a read-only role. The product signs in with its own Azure identity, so no Snowflake password or key is stored. Which tables people read needs Snowflake Enterprise Edition.
  • The AWS bill for Redshift cost, your HR file for departments and leavers, and, if you use it, your Alation catalog.
  • Query text is read only to find exports, grants and refused attempts, then dropped. What is kept: who, when, which tables and how many rows.

On Redshift and Databricks, cost per person is an estimate, and the Cost page says so: each hour of a shared warehouse is split by each account's share of query time. Snowflake reports each query's cost itself. Access changes are tracked from the day you install it; on Snowflake, from up to 90 days before.

What gets deployed

  • A web app with Microsoft Entra ID sign-in (Azure App Service)
  • A nightly job that collects from each platform (Azure Functions)
  • An Azure Database for PostgreSQL server on a private network, with public access off
  • A storage account for the HR file, and a Key Vault for every secret

Before you deploy

  • An app registration in Microsoft Entra ID for sign-in.
  • Which platforms you use, any one or all three, and only their addresses: your Redshift cluster or Serverless workgroup, your Databricks workspace, your Snowflake account identifier and price per credit.
  • An HR file with each person's department, manager and end date, placed in the storage account after deployment.

After the install, a setup page lists the grants your admins make, for the platforms you picked only: for Redshift, a read-only AWS role from the template provided and read-only Redshift grants; for Databricks, read access to its system tables; for Snowflake, a read-only role and user from the script shown.

How the engagement works

The solution template is free to deploy. Data Meaning provides a fixed-price package: installation on your platforms, then quarterly reviews with your leadership. Data Meaning does not host the deployment and does not receive your data. You pay Microsoft for Azure consumption and Data Meaning for the engagement.

At a glance

https://catalogartifact.azureedge.net/publicartifacts/datameaning.dm-data-control-tower-e45e80fd-4667-4e31-8fea-ed391c79ef75/image3_listing1.11home.png
https://catalogartifact.azureedge.net/publicartifacts/datameaning.dm-data-control-tower-e45e80fd-4667-4e31-8fea-ed391c79ef75/image0_listing1.12access.png
https://catalogartifact.azureedge.net/publicartifacts/datameaning.dm-data-control-tower-e45e80fd-4667-4e31-8fea-ed391c79ef75/image7_listing1.13cost.png
https://catalogartifact.azureedge.net/publicartifacts/datameaning.dm-data-control-tower-e45e80fd-4667-4e31-8fea-ed391c79ef75/image8_listing1.14usage.png
https://catalogartifact.azureedge.net/publicartifacts/datameaning.dm-data-control-tower-e45e80fd-4667-4e31-8fea-ed391c79ef75/image1_listing1.15actions.png
English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies