Skip to main content

Data Quality in Hours
Not Months

The data quality automation plugin for data teams. Experience data quality observability in your ELT/ETL pipeline that would usually take a year to build, in just a few hours.

Book a demo 🚀
Run locally in 4 steps 💻

Platforms we support

Zero-infrastructure. Zero-code setup.

Experience hassle-free integration with Swiple's zero-infrastructure and zero-code setup. Seamlessly incorporate data quality checks into your existing workflows without any coding or infrastructure changes, allowing you to focus on what matters most - your data.

Automated Data Profiling

Create tailored checks for each dataset without a data expert

Save engineers weeks of time generating data quality checks. Swiple analyzes your dataset and builds data quality checks based on what is observed in your data. You just pick the ones you want.

Data Quality Reporting

Gain a comprehensive view of your data quality health

Data teams often encounter unforeseen data quality issues. Understanding past trends empowers them to make informed decisions and proactively tackle data challenges.

Incident Alerting

Stay ahead of data quality issues

Boost your teams efficiency and confidence with Swiple alerting capabilities. Ensure your data teams are the first to know about data quality concerns with notifications dispatched to your team as they occur.

Scheduling

Effortless scheduling for seamless data validations

Built in scheduling enables autonomous data validations at any recurrence interval, allowing for easy integration into your data pipeline.

Expectations

30 Total
Expectations are the assertions executed against your data and are what drive your data quality results.

ExpectColumnToExist

Expect the specified column to exist.

ExpectTableColumnsToMatchOrderedList

Expect the columns to exactly match a specified list.

ExpectTableColumnsToMatchSet

Expect the columns to match a specified set.

ExpectTableRowCountToBeBetween

Expect the number of rows to be between two values.

ExpectTableRowCountToEqual

Expect the number of rows to equal a value.

ExpectTableColumnCountToBeBetween

Expect the number of columns to be between two values.

ExpectTableColumnCountToBeEqual

Expect the number of columns to equal a value.

ExpectColumnValuesToBeUnique

Expect each column value to be unique.

ExpectCompoundColumnsToBeUnique

Expect that the columns are unique together, e.g. a multi-column primary key

ExpectSelectColumnValuesToBeUniqueWithinRecord

Expect the values for each record to be unique across the columns listed. Note that records can be duplicated.

ExpectColumnValuesToNotBeNull

Expect column values to NOT be null. Values must be explicitly null or missing. Empty strings don’t count as null unless they have been coerced to a null type.

ExpectColumnValuesToBeNull

Expect column values to be null.

ExpectColumnValuesToBeInSet

Expect each column value to be in a given set.

ExpectColumnValuesToNotBeInSet

Expect each column value to NOT be in a given set.

ExpectColumnValuesToBeBetween

Expect column entries to be between a minimum value and a maximum value.

ExpectColumnValueLengthsToBeBetween

Expect column entries to be strings with length between a minimum value and a maximum value. This expectation only works for string-type values.

ExpectColumnValueLengthsToEqual

Expect column entries to be strings with length equal to the provided value. This expectation only works for string-type values.

ExpectColumnValuesToMatchRegex

Expect column entries to be strings that match a given regular expression.

ExpectColumnValuesToNotMatchRegex

Expect column entries to be strings that do NOT match a given regular expression. The regex must NOT match any portion of the provided string. .

ExpectColumnValuesToMatchRegexList

Expect the column entries to be strings that can be matched to either any of or all of a list of regular expressions. Matches can be anywhere in the string.

ExpectColumnValuesToNotMatchRegexList

Expect the column entries to be strings that do not match any of a list of regular expressions. Matches can be anywhere in the string.

ExpectColumnMeanToBeBetween

Expect the column mean to be between a minimum value and a maximum value (inclusive). min_value and max_value are both inclusive unless strict_min or strict_max are set to True.

ExpectColumnMedianToBeBetween

Expect the column median to be between a minimum value and a maximum value.

ExpectColumnUniqueValueCountToBeBetween

Expect the number of unique values to be between a minimum value and a maximum value. (inclusive)

ExpectColumnProportionOfUniqueValuesToBeBetween

Expect the proportion of unique values to be between a minimum value and a maximum value. For example, in a column containing [1, 2, 2, 3, 3, 3, 4, 4, 4, 4], there are 4 unique values and 10 total values for a proportion of 0.4.

ExpectColumnSumToBeBetween

Expect the column to sum to be between an min and max value

ExpectMultiColumnSumToEqual

Expect the sum of row values is the same for each row, summing only values in column_list, and equal to sum_total.

ExpectColumnMinToBeBetween

Expect the column minimum to be between an min and max value

ExpectColumnMaxToBeBetween

Expect the column maximum to be between an min and max value

ExpectColumnPairValuesToBeEqual

Expect the values in column A to be the same as column B.

Choose the perfect plan for your data team

Discover the benefits of Swiple with our flexible and cost-effective pricing plans, designed to suit data teams of all sizes and requirements.