Software

Accelerate and automate your data projects with the phData Toolkit

Introducing the phData Toolkit

Over the past few years, phData has been building a suite of automation tools to help our customers and community get more out of their data. Now, we’re excited to introduce an easier way to access and utilize these tools. 

The phData Toolkit is a new unified interface for all of phData’s apps and tools that help to accelerate and automate your data projects. With central access, detailed documentation, unified updates, and a robust resource library, it’s now easier than ever for you leverage phData’s automation software with our Toolkit.

phData Toolkit Dashboard

What apps and tools are included in the Toolkit?

Privilege Audit

The Privilege Audit app provides powerful visualization and reporting that enables Snowflake data access auditing and troubleshooting.

Application Monitoring

The Application Monitoring tool is a set of packaged tools to aggregate data from data products to make understanding the performance, errors, and costs of data products easy. 

SQL Translation

The SQL Translation app can instantly translate SQL from one language to another, eliminating a usually time-consuming, error-prone, and highly manual process. Essentially, it functions like Google Translate — but for SQL dialects.

Project Administration

The Project Administration tool automates creating and managing project resources within Snowflake including users and their privileges. Once set up and configured with your existing ticketing systems or Active Directory installations, you can fully manage your self-service Snowflake environments without relying on manual SQL commands.

Pipeline Automation

The Pipeline Automation tool simplifies the process of ingesting data onto new platforms and generating scripts for common pipeline patterns.  It then generates pipeline code from a series of templates that you can use to ingest or transform data for the migration of a legacy database or ongoing ingestion of an operational database. It’s also an Apache-licensed open source project that anyone can contribute to. 

Automated Infrastructure

The Automated Infrastructure tool is an accelerator that allows you to deploy and manage cloud infrastructure using Infrastructure-as-Code. It consists of prebuilt CloudFormation templates and a library to enable automatic testing and execution of your customized templates along with the promotion of changes from development to production environments in your CI/CD pipelines.

Automation to accelerate every step of your data journey

Step 1

Get started by defining and deploying Cloud Infrastructure with our Automated Infrastructure tool.

Step 2

Securely provision and manage users, projects and privileges with our Privilege Audit and Project Administration tools.

Step 3

Quickly define pipelines to ingest legacy or operational data with our Pipeline Automation tool.

Step 4

Migrate legacy SQL workloads quickly and accurately with our SQL Translation tool.

Step 5

Monitor and alert for platform usage, costs, problems, and performance with our Application Monitoring tool.

The Toolkit is utilized by

Cargill Logo
Medtronic Logo
Thrivent Logo

How does the Toolkit makes automation simple?

Take the next step
with phData.

Accelerate and automate your data projects today with the phData Toolkit.

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