Remove Data Profiling Remove Database Remove SQL
article thumbnail

11 Open Source Data Exploration Tools You Need to Know in 2023

ODSC - Open Data Science

There are many well-known libraries and platforms for data analysis such as Pandas and Tableau, in addition to analytical databases like ClickHouse, MariaDB, Apache Druid, Apache Pinot, Google BigQuery, Amazon RedShift, etc. With Great Expectations , data teams can express what they “expect” from their data using simple assertions.

article thumbnail

phData Toolkit December 2022 Update

phData

The phData Toolkit continues to have additions made to it as we work with customers to accelerate their migrations , build a data governance practice , and ensure quality data products are built. This includes things like creating and modifying databases, schemas, and permissions. Let’s dive in and take a deeper look at these.

SQL 52
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 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. This is where the SQL Translation tool can be a massive accelerator for your migration.

SQL 52
article thumbnail

phData Toolkit March 2023 Update

phData

You have tons of data and SQL to migrate, and you need to ensure that it’s done right, or it’s your job on the line! WIthin our Toolkit CLI, we primarily have two different tools: our SQL Translation Tool and our Data Source Tool. Added a default name (the folder or file name) when generating SQL reports.

SQL 52
article thumbnail

MLOps Landscape in 2023: Top Tools and Platforms

The MLOps Blog

It integrates with Git and provides a Git-like interface for data versioning, allowing you to track changes, manage branches, and collaborate with data teams effectively. Dolt Dolt is an open-source relational database system built on Git. Share features across the organization.

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

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.