Skip to main content

Why Data Product Access Still Takes Weeks, and How Governed Provisioning Fixes It

Samuel Nagy
Samuel Nagy
VP of Strategic Growth

Data product access still takes weeks in many organizations because the request ends up in a ticket queue. The data product describes what a consumer could have, while the permission is created in a different system, by different people, on a different schedule. Governed provisioning closes that gap. The request is checked against policy, approved by the owner and granted in the platform where the data lives, with an end date set at the same moment.

TL;DR

Most data product programs stop at the description. Getting access often still means a ticket, an approval chain and a manual grant in each platform, and in one US survey 55% of data experts put the average turnaround for a data request at one to four weeks. Governed provisioning runs the request, the policy check, the approval and the grant as one chain, and gives every grant an end date so that access does not quietly become permanent.

What is data product access provisioning?

Data product access provisioning is the step that turns an approved request into a working permission in the platform where the data lives, such as a warehouse role, a lakehouse grant or a BI workspace membership. It is the last mile of a data product. Everything before it, the definition, the contract and the listing in a data marketplace, tells a consumer what they could have. Provisioning is what lets them actually query it.

A governed access flow has three parts.

  • The request. Who is asking, for which product or which of its ports, for what purpose and for how long.
  • The decision. A policy check based on the data's classification, followed by approval from the product owner or the domain where the policy requires one.
  • The grant. The permission created in the source platform, scoped to what was approved, recorded, and removed when its validity period ends.

Data access management is the broader discipline of deciding who may read, change and share data. Provisioning is where those decisions are executed, one request at a time, and it is where most organizations still lose the most time.

Why does data product access still take weeks?

Access takes weeks because the request crosses several systems and several people, and none of them owns the whole path. In a survey of 801 data experts at US companies, commissioned by Sigma Computing and run by Atomik Research in 2020, 55% put the average turnaround for a data request at one to four weeks. Data products were supposed to shorten that by packaging data into something a consumer can find and trust. They helped with finding. In many organizations, getting access still works the way it did before.

The delay comes from five places.

  • Two systems with a ticket between them. The catalog or marketplace describes the product, and an identity tool or a platform administrator creates the permission. The service ticket is the only interface between the two, and it rarely carries the product's owner, contract or classification with it.
  • Requests at the wrong level. Consumers often request individual tables, although a real analysis almost always needs several. Each table becomes its own approval, and the consumer finds out about a missing one only after the first grant lands.
  • Approvers without context. The person who receives the request often cannot judge it, so it gets forwarded to the data team, then to the owner, then back with a question about scope.
  • Manual execution. Once approved, someone writes the grant by hand in each platform the product touches, in between other work.
  • No end date. When every grant is effectively permanent, every approval is a high-stakes decision, and careful approvers slow down accordingly.

A described data product tells a consumer what they could have. Until the request ends in a working permission, the consumer still has nothing.

The expectation on the business side has also changed. When an analyst could spend weeks preparing data before it was useful, a few weeks of waiting for access disappeared in the overall timeline. With AI assistants and agents that can answer a question minutes after they reach the data, the wait for access becomes most of the elapsed time.

Two paths from a request to working access TICKET-BASED ACCESS Find thedata product Raise aservice ticket Triage andforward by email Manual grantper platform Access staysindefinitely Each handoff drops context, and every grant is effectively permanent GOVERNED PROVISIONING Find andread the contract Request scopeand end date Policy check,owner approval Provisioned inthe data platform Removed onthe end date One chain records who asked, who approved, what was granted and until when
Click to enlarge

How governed data product access works

Governed data product access runs the request, the decision and the grant as one chain, with the product's metadata attached at every step. A typical flow has six steps.

  1. Discover. The consumer finds the product in a marketplace by subject, domain or platform, without needing to know which team owns it.
  2. Evaluate. Before requesting, the consumer checks the owner, the data contract and its schema, the service levels, the quality checks, the license and whether the product is in production or being retired.
  3. Request. The consumer states the use case, the scope (the whole product or specific ports, masked or unmasked personal data, a subset of rows) and the duration.
  4. Decide. A policy evaluates the request against the data's classification. Depending on the policy, the access is granted immediately or routed to the approvers it names, such as the product owner or the owning domain.
  5. Provision. The approved scope is granted in the platform where the data lives, with sensitive columns masked where the policy requires it, and the grant is recorded together with its reason.
  6. Expire. When the validity period ends, the access is removed. Continuing to use the data is a new request and a new decision.

Two details separate a governed flow from a request form bolted onto a catalog. The approver sees the request with the product's owner, contract and classification attached, so the decision can be made where the request lands. And the grant is executed by the same chain that made the decision, so approval and enforcement stay connected.

Ticket-based access vs governed provisioning

The two models differ in where context and accountability live, and the difference in speed follows from that.

Ticket-based accessGoverned provisioning
Unit of requestIndividual tables or schemasA data product, or the ports of one
Where the request livesA service desk, separate from the catalogThe marketplace where the product is listed
Context for the approverWhatever the requester typed into the ticketOwner, contract, classification and purpose attached
Approval routingManual, often forwardedPolicy-driven, by classification and domain
Who executes the grantAn administrator in each platformThe access chain itself, in the source platform
DurationUsually open-endedSet at approval, removed automatically
Audit evidenceReconstructed from tickets, email and platform logsOne record of request, reason, approval and grant

Ticket-based access still has a place. Organizations with a mature IT service management process sometimes need provisioning to stay inside it, and a governed marketplace can hand the request over as a ticket. What it should not do is leave the consumer to translate a data product into a ticket by hand.

Why time-bound access matters

Time-bound access gives every grant an end date set at the moment it is approved, and removes the permission automatically when that date arrives. It matters because the default alternative, access that stays until someone revokes it, accumulates. Permissions granted years ago to people who needed them once are a familiar finding in access reviews, and they often exist because removing them was always someone's job and never anyone's priority.

Security frameworks have asked for this for a long time. NIST SP 800-53 includes controls for least privilege, allowing only the access needed for assigned tasks (AC-6), for reviewing assigned privileges periodically and removing those no longer needed (AC-6(7)), and for automatically removing or disabling temporary and emergency accounts after a defined period (AC-2(2)). An end date on a data grant applies the same logic to data access. Least privilege then covers how long access lasts, as well as what it covers.

There is a less obvious benefit as well. Ninety days is an easier decision than forever. When the worst case of a mistaken approval is a bounded period rather than a permanent grant, an approver has less reason to hold a request back.

The same 90-day analysis, two access records Illustrative timeline Without an end date Analysis finished, access still active With an end date Removed automatically on day 90 Grant Day 90 Year 1 Year 2 Year 3
Click to enlarge

How long should data product access last?

Match the duration to the use case rather than picking one number for everything. A one-off analysis needs weeks or a quarter. A recurring report or a production pipeline needs longer, ideally aligned with the review cycle of the product's contract, so renewal becomes a deliberate check that the dependency is still wanted. An AI agent working on a defined task should get the shortest period that covers it. Whatever the duration, the approver should be able to shorten what was requested, and the consumer should be able to extend access as a new request rather than as a silent default.

Best practices for data product access requests

These practices apply whatever tooling you use. Each one removes a reason for a request to stall.

  • Request the product, not the table. A data product carries its owner, contract and terms. A raw table carries none of them, so the approver has less to go on and the consumer has no agreed schema to rely on.
  • Read the contract before you request. The schema, refresh time and quality checks tell you whether the product answers your question. If the product refreshes at 6am and your report runs at 3am, raise it with the owner before you request access.
  • Ask for the narrowest scope that covers the use case. Specific ports, a subset of rows and masked personal data give the approver less to weigh, and narrow requests are usually approved fastest.
  • Mask personal data by default. Make masked access the starting point and unmasking of personal data an explicit, justified choice.
  • Check existing access first. Duplicate requests waste approver time. A good request flow tells the consumer what they already hold and offers an extension instead.
  • Put an end date on every grant. Open-ended access should be the exception that needs a reason.
  • Give AI agents the same path as people. An agent is a data consumer and needs its own identity, purpose, scope and end date. A shared service account with standing rights hides what each agent can reach.
  • Name an owner on every product. A product nobody owns has nobody to approve its access, which is why ownership belongs before publication.

How Dawiso handles data product access

The Dawiso Data Product Platform, currently in public preview, runs the chain described above in one platform. A team defines a data product in the Data Product Wizard, publishes it to the Data Market, and a consumer's request goes through the Access Gate, which handles the approval and provisioning of data access.

Definition happens in seven steps. The Data Product Wizard walks the producing team through Basics, Business Context, Ownership, Data Assets, Ports, Contracts and Review. Publishing requires a named owner, so every product in the market has someone who can answer for it.

Dawiso Data Product Wizard on step 4, Data Assets, with the seven steps Basics, Business Context, Ownership, Data Assets, Ports, Contracts and Review across the top, technology and asset type filters, an optional shortcut to consume an upstream port, and a list of available Databricks catalogs with two selected
Click to enlarge

Discovery and evaluation happen in the Data Market. Only products in the production workflow state are listed. Each listing shows the product's purpose, output ports, data contract and terms where one is defined, and pricing and license, so a consumer can judge fit before asking for anything.

Dawiso Data Market searched for KPI, showing a data product card for Network Performance KPIs in the Operations domain with its description, two output ports with PII and confidentiality labels, the Production state and an Add to cart button
Click to enlarge

Requests go through the cart and checkout. With the Access Gate as the checkout target, which is the default, the consumer states the reason, the use case and the duration once for everything in the cart. Each product then gets its own card with the request scope.

  • Ports. All offered ports are selected by default, so the whole product is requested unless the consumer narrows it.
  • Personal data. Masked access is the default. Unmasking basic or sensitive personal data is an explicit choice, and for sensitive data the consumer picks which protected categories to unmask.
  • Row scope. Where the policy requires it, the card asks the consumer to limit the request to a subset of rows, such as the requester's own business unit.
  • Existing access. If the consumer already holds access to some of the selected ports, the card says so and can block a duplicate request or offer to extend the current access.
  • Outcome preview. Before submitting, the card shows what the Access Gate would grant, for example immediate access, access after approval or a blocked request, together with the approvers and the validity period.

The Access Gate applies its approval policy and provisions the access. The policy can approve a shorter duration than the consumer asked for. Where a validity period is set, the access is removed automatically when it ends. Submitted requests and granted access are tracked under My Access. For a closer look at how the Access Gate works alongside Unity Catalog, see what Dawiso adds to Databricks Unity Catalog.

Organizations that want provisioning to stay inside their existing service management process can set Jira Service Management or ServiceNow as the checkout target instead. Dawiso then raises one request or record per product, and fulfillment follows the organization's own process.

Underneath, the data product model is built on open standards, the Open Data Product Specification, the Bitol Open Data Contract Standard and Open Data Mesh ports, and products can be exported back to ODPS and ODCS. The launch announcement covers the wizard and the standards in more detail.

FAQ

What is data product access provisioning?
Data product access provisioning is the step that turns an approved request for a data product into a working permission in the platform where the data lives, such as a warehouse role or a lakehouse grant. A governed version of it records who asked, why, who approved, what scope was granted and until when, and removes the access when that period ends.
How long does it take to get access to data in an enterprise?
Often weeks. In a survey of 801 data experts at US companies, commissioned by Sigma Computing and run by Atomik Research in 2020, 55% said the average turnaround time for a data request is one to four weeks. Much of that time is typically spent waiting between systems and people, in a ticket queue, an approval email or a manual grant.
What is time-bound data access?
Time-bound data access is a permission granted with an end date that is set at the moment of approval. When the period ends, the access is removed automatically and continuing to use the data requires a new request. It applies the least-privilege principle over time and keeps a one-off analysis from turning into standing access that nobody reviews.
Should AI agents request data access the same way people do?
Yes. An agent that reads or acts on enterprise data is a data consumer, and it should have its own identity, a stated purpose, a scoped grant and an end date, exactly like a person. Agents running under a shared service account with broad standing permissions are hard to tell apart in an access review and hard to restrict when something goes wrong.

Sources

See it in action

From request to granted access

See how the Dawiso Data Product Platform takes a data product from the market to a provisioned, time-limited access.

A cookie a day keeps bad UX away.

We use cookies to personalize content, ads and to analyze our traffic. We also share information about your use of our site with our advertising and analytics partners who may combine it with other information that you've provided to them or that they've collected from your use of their services. By clicking "Accept All", you allow us to use cookies for analytics and ads via Google Tag Manager. You can also customize cookies.

Customize Consent Preferences

We use cookies to personalize content, ads and to analyze our traffic. We also share information about your use of our site with our advertising and analytics partners. Privacy Policy

Necessary cookies allow core website functionality such as user login and account management. The website cannot be used properly without strictly necessary cookies.

Functionality cookies are used to remember visitor information on the website, eg. language, timezone, enhanced content.

Analytics cookies are used to see how visitors use the website, eg. analytics cookies. Those cookies cannot be used to directly identify a certain visitor.

We use Microsoft Clarity to see how you use our website (including heatmaps and session replays) so we can improve it. By using our site, you agree that we and Microsoft can collect and use this data. See our Privacy Policy for details.

Advertisement cookies are used to identify visitors between different websites, eg. content partners, banner networks. Those cookies may be used by companies to build a profile of visitor interests or show relevant ads on other websites.