Remove Data Profiling Remove Definition Remove SQL
article thumbnail

phData Toolkit August 2023 Update

phData

Over the last month, we’ve been heavily focused on adding additional support for SQL translations to our SQL Translations tool. Specifically, we’ve been introducing fixes and features for our Microsoft SQL Server to Snowflake translation. Let’s dive in! Let’s take a look at some of the more interesting translations.

SQL 52
article thumbnail

Alation 2022.2: Open Data Quality Initiative and Enhanced Data Governance

Alation

Prime examples of this in the data catalog include: Trust Flags — Allow the data community to endorse, warn, and deprecate data to signal whether data can or can’t be used. Data Profiling — Statistics such as min, max, mean, and null can be applied to certain columns to understand its shape.

professionals

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

phData Toolkit June 2023 Update

phData

While many of our customers leverage our UI for tools like our SQL Translation or Privilege Audit tooling, there are limitations when it comes to using a UI. You wouldn’t want to pay someone (or perform yourself) to manually copy/paste each file into a browser window and copy/paste the translated SQL back.

SQL 52
article thumbnail

Data Hygiene Explained: Best Practices and Key Features

Pickl AI

By maintaining clean and reliable data, businesses can avoid costly mistakes, enhance operational efficiency, and gain a competitive edge in their respective industries. Best Data Hygiene Tools & Software Trifacta Wrangler Pros: User-friendly interface with drag-and-drop functionality. Provides real-time data monitoring and alerts.

article thumbnail

What Orchestration Tools Help Data Engineers in Snowflake

phData

Top Orchestration Tools for Snowflake Snowflake Snowflake has a native feature called tasks that can be used to schedule a single SQL statement, call a stored procedure or run procedural logic via Snowflake Scripting. These logs can be used for compliance reporting, audit purposes, or investigation of data-related issues.