AV | Define Targets

Data Quality Guide > Design > Creating a Data Profile > Define Targets

Was this helpful?

Define Targets

Note: Before reading this topic, ensure that you have read Creating a Data Profile.

On the Targets page, specify where Pass data and Fail data are written. You will first specify the warehouse instance and table to which Pass data will be written. Then you will specify the warehouse instance and table to which Fail data will be written.

The target connection can be any Actian Warehouse that you have access to, and either an existing or newly created Actian Warehouse table can be used for storing the data. For more information, see Target Details for Actian Warehouse.

Note that to facilitate the process of designing and testing rules against your data set, the Pass and Fail data generated by a profile are not saved until the Pass and Fail target connections are defined. Once the Pass and Fail Target connections are established, the profile will write the Pass and Fail data to the specified Actian Warehouse tables.

To define a target connection

1. Select the desired Actian Warehouse for the Pass Target data from the list.

If the selected warehouse is not in a Running state, click the Click here link which appears in a popup dialog (at the top right). This link is displayed only after you select the warehouse. After you click this link, it will take some time for the warehouse to start. The status will be displayed as Starting, Initializing, and then Running. For more information, see Target Details for Actian Warehouse.

2. Specify the User name and Password for the selected warehouse by doing one of the following:

• Enable Connect to Actian Warehouse as current user and connect using the credentials you used to login into the Actian Data Platform,

• Disable Connect to Actian Warehouse as current user and login with different credentials. This is useful when your Actian Data Platform credentials don’t grant access to the warehouse or table you need and you have alternate credentials that do grant access to them. For more information, see Target Details for Actian Warehouse.

For information about different types of users and how to add a new users, see Manage Users and Update Allow List IP Addresses.

3. Click Test Credentials to verify the connection.

A “Connection successful” message is returned or an appropriate error message is displayed if the connection attempt fails.

4. Specify the table where Pass Target data will be written by doing one of the following:

• Overwrite Existing Table – Select this option to store Pass data in an existing Actian Warehouse table:

a. The Existing Table Name drop-down appears. You can either scroll through the list of tables manually to select an existing table, or type in a text to filter table names that match the specified string.

b. If your existing table contains data, the data inside the table can be visually inspected by clicking the Preview the first 20 records link. The data for the selected table is displayed in the source data preview pane. Use this to verify that you’re connected to the correct table. Click outside of the pane to close it.

Note: Selecting an existing table option replaces data in the existing table. That is, the existing table is deleted and a new table with current schema is created. This may result in data loss.

• Create New Table – Select this option to store Pass data in a new table, and enter a New Table Name.

Note: Table names can contain only alphanumeric characters and must begin with an alphabetic character or an underscore (_). Names can contain (but cannot begin with) the following special characters: 0 through 9, #, @, and $. Names specified as delimited identifiers (in double quotes) can contain additional special characters.

5. Select the Provide table access in Actian Query Editor option to grant table access to the dbadmingrp group.

6. Specify the Fail Target connection by doing one of the following:

• Enable Same as pass target to set the Fail target connection to use the same Actian Warehouse that you selected for the Pass target connection, then proceed to the next Step.

• Disable Same as pass target, choose a different warehouse, and specify the User name and Password for the selected warehouse (as previously done for the Pass Target connection). For more information, see Target Details for Actian Warehouse.

7. Specify the table where Fail data will be written by doing one of the following:

• Overwrite Existing Table – Select this option to store Fail Target data in an existing Actian Warehouse table:

Note: Selecting an existing table option replaces the existing table. That is, the existing table is deleted and a new table with current schema is created. This may result in data loss.

• Create New Table – Select this option to store Fail Target data in a new table. Enter a New Table Name.

8. Click Save and Run.

The Running Data Profile dialog opens. Click Cancel to stop executing the profile. Click Run in background to execute the profile in the background, close the editor and return to the Data Profiles page. The Data Profile execution status is shown on the profile tile as Running. When the profile finishes executing the status changes to Finished and a popup message is returned with a View Results link. Click View Results to view execution results in the profile editor Results page. If the profile execution fails the popup message returns an error message.

Note:
- Both targets must be configured to enable the Continue and Run button.
- Inaccurate source field lengths are common with delimited files. In such cases, the creation of profile jobs may fail with a The string supplied is too long to fit into the resulting string type error. To prevent this, adjust the sample size on the source page to a higher number so that more records are considered to calculate the target field size.

Last modified date: 10/30/2024