--- title: "Data Quality Studio: Pre-built Data Quality Rule Creation" url: "https://atlan.com/demos/data-quality-studio-pre-built-data-quality-rule-creation/" description: "Strengthen data trust instantly! Apply powerful, no-SQL data quality checks in seconds using Atlan’s pre-built rules and tailor configurations with a few clicks." format: "Video" video: "https://videos.ctfassets.net/nwa1c00rtgxb/3L34MVdnRygAqzVcEAw4DE/616863ad23010bf4219ffec264274acf/Pre-built_Data_Quality_Rule_Creation.mp4" content_purpose: ["Product Overview"] target_persona: ["General", "Data Analyst", "Data Scientist", "IT Administrator", "Data Steward", "Data Governance Lead", "Data Engineer"] journey_stage: ["S2 - Discovery", "C1 - Onboarding", "C4 - Expansion", "C3 - Adoption"] use_case_context: ["Training"] product: ["Data Marketplace - Data Quality"] content_type: "video transcript" transcript_source: "contentful" --- # Data Quality Studio: Pre-built Data Quality Rule Creation Transcript of the video at https://atlan.com/demos/data-quality-studio-pre-built-data-quality-rule-creation/ ## Pre-built Data Quality Rule Creation Data quality plays a big role in building trust—but too often, it’s something only SQL-savvy users can tackle. With Atlan’s Data Quality Studio, that barrier disappears. Thanks to a growing set of pre-built rules, anyone on your team can start adding checks and improving data reliability—no SQL required. Let’s take a look at how this works in action. Going to the asset discovery page and filtering on the Databricks connection where we have Atlan’s data quality studio enabled returns all of our databricks assets. We then filter on, tables, and views, along with applying the Databricks data quality filter for no rules, giving us a listing of all the tables and views that do not yet have any data quality rules and a great place to apply a pre-built rule. Clicking on the first result opens the table. Rules for columns can be created in two different places, either by clicking on the columns tab for the table, where we see the data quality listing for each column, allowing us to either use the drop down or Atlan AI to add rules for the column. You can also create rules for columns and the table itself by clicking on the data quality tab, which we do. The page updates, and since we do not have any rules yet on this table, we are presented with the options to add a new rule or get suggestions on the entire table. As we are going to apply a pre-built rule for this asset, we click on the drop down. Here, we are presented with various options for rule creation. At the top, we can search for pre-built rules, below which we could create our own SQL for our rule, but in this case, we are looking for the pre-built rules, which are listed below. They are categorized into distinct groups, each with unique rule types. We have numerous options, and in this case, we are specifically aiming to ensure that the length of our buying groups column does not exceed 30 characters, as all should adhere to these constraints. We scroll down and select the string length rule. The popup window appears and at the top, we are given the ability to select which column we want to apply this rule to. As we see, it restricts the options to only applicable data types, and each pre-built rule does the same based on the type of rule, ensuring that you do not apply a rule that is not applicable. We select our column, and then below, are able to use the vailidator to apply the length for which the rule should check. When entering in the value, we are specifying what values would result in a pass, and since we want to ensure that the string length is 30 or less, we keep the option of is less than or equal to and enter the value of 30. Below this, we can enter in a failure amount, where we could specify only when a certain number of results break the rule, then it would fail, but in this case, we are looking to ensure that all rows follow our rules, so we keep it at zero. if we want to customize the notifications on this rule, we can click on the advanced settings. Here, we can use the drop down to select our notification settings, and finally we could also set this to only look at rows that have been modified in the last 24 hours by clicking that checkbox. We click on create, the page updates, and our new rule is created. With that, we have added our data quality rule, ensuring that the string length for our buyer groups field is always within the required length, without even writing a line of SQL, giving any data consumer the ability to add the trust they need to the data they are using.