March 21, 2023

phData Launches the Provision Tool for Automated Snowflake Onboarding

By Grant Henke

We are thrilled to announce the release of the newest tool in the phData Toolkit, the Provision tool!

The Provision tool automates the onboarding of users and projects into the Snowflake Data Cloud, allowing Snowflake customers to focus on solving business problems.

A major bottleneck to getting value from a Snowflake Data Cloud environment is creating the databases, schemas, roles, and access grants that make up an ‘information architecture’. Creating, applying, and evolving this information architecture can be a major time-consuming, and error-prone process.

The Provision tool gives flexibility to phData customers, allowing them to define and apply their own information architecture in a standardized way. The Provision tool’s high-performance, template-driven engine can manage and enforce that architecture to quickly and automatically provision resources in Snowflake, even for the largest accounts. 

Additionally, the Provision tool can be integrated with popular ticketing systems like Jira or ServiceNow to allow self-service project creation and user access grants with existing enterprise approval processes.

The Provision tool is an upgraded version of our existing Snowflake resource management tool, Tram, that offers several simplifications and improvements. Tram has been successfully used for years by phData customers to manage their Snowflake environments; this new tool will improve that experience.

Some of the notable Provision tool improvements include:

  • Full integration into our Toolkit CLI, allowing us to provide a consistent user experience across all of our tools.
  • Simplified information architecture definition with Jinja templates.
  • Simplified configuration.
  • Improved resource create/destroy behavior, making it easy to destroy even individual objects.
  • Improved resource validation for faster development and deployment.
  • Improved error handling and user experience when developing complex information architectures.
  • Multithreaded plan and apply for faster runtimes in very large Snowflake environments.
  • A built-in local tutorial to make getting started easy.

To see all improvements and changes, explore our Tram Migration Guide.

Who Can Use The Provision Tool?

The Provision tool is available for everyone to try and demo at a small scale and is available to all phData customers for free without limitations.

How To Get The Provision Tool

The Provision tool is now available in the phData Toolkit for all existing customers to start leveraging. To get started, we encourage you to visit the Provision tool documentation section of our phData Toolkit webpage and try the built-in tutorial

If you’re interested in seeing the tool in action, contact us to get a detailed demo!

Data Coach is our premium analytics training program with one-on-one coaching from renowned experts.

Accelerate and automate your data projects with the phData Toolkit