tVerifyEmail properties for Apache Spark Structured Streaming

Schema

• A schema is a row description. It defines the number of fields (columns) to be processed and passed on to the next component. When you create a Spark Job, avoid the reserved word line when naming the fields.

• Built-In: You create and store the schema locally for this component only.

• Repository: You have already created the schema and stored it in the Repository. You can reuse it in various projects and Job designs.

Edit Schema

Click Edit schema to make changes to the schema. If you make changes, the schema automatically becomes built-in.

The output schema of tVerifyEmail has different read-only columns depending on the options you select in the component Basic settings view. Read-only output columns include:

VerificationLevel: provides you with the verification status of the processed email addresses as the following:

-VALID: means that the email address comply with the defined rule.

-VALID: means that the email address comply with the defined rule.

-INVALID: means that the email address does not comply with the defined rule.

-INVALID: means that the email address does not comply with the defined rule.

-CORRECTED: means that the input email does not comply with the defined rule and has been corrected by using the content of the selected columns. This column is available only when you select the Use column content option in the LOCAL Part Options section.

-VERIFIED: means that the email address does exist at the domain. This column is available only when you select the Check with mail server callback option.

-REJECTED: means that the email address does not exist at the domain. This column is available only when you select the Check with mail server callback option.

Suggested_Email: provides you with a suggested content for the email part before the @ sign. The email string is built up from the columns you select from the Use column content view.

Column to validate

Select from the list the column you want to validate with tVerifyEmail.

Check the entire email with regular expression

Select this check box if you want to match the complete email address against a specific regular expression.

Complete regular expression: enter the regular expression against which you want to match email addresses.

This match is done as a first step to optimize the matching process and exclude addresses that have problems before going any further to match the local and domain parts of email addresses.

LOCAL Part Options

Fields in this section will vary according to what option you select. "LOCAL part" in an email address refers to the string before the @ sign.

-Use regular expression: enter in the Pattern field the expression against which you want to check the local part of the email address.

-Use simplified pattern: enter in the Pattern field the simplified pattern against which you want to check the local part of the email address. Select the Show syntax of simplified pattern option to display the syntax to use for simplified patterns. For more information about the syntax, see Simplified pattern syntax for tVerifyEmail.

-Use column content: use the fields in this view to decide the content against which you want to check the local part of the email. If the local part does not match what you have defined, it will be rewritten by using the content of the fields.

-Enable case-sensitive pattern matching: select this check box to enable a case sensitive pattern matching of the local part of email addresses. You can use case sensitive pattern matching with each of the above options.

DOMAIN Part Options

Fields in this view will vary according to what option you select.

-Check the Top-level Domains and the following ones: select this check box to verify the part of the email address which follows the last dot. You can use the Additional Top-level Domains table to add additional top-level domains against which you want to validate email addresses.

-Check domains with a black list: select this option to verify the domains you define in the Domain list table as black listed.

-Check domains with a white list: select this option to verify the domains you define in the Domain List table as white listed.

This component is used as an intermediate step.

This component, along with the Spark Structured Streaming component Palette it belongs to, appears only when you are creating a Spark Structured Streaming Job.

You need to use the Structured Streaming Configuration tab in the Run view to define the connection to a Spark cluster for the whole Job.

This connection is effective on a per-Job basis.