Creating and Deleting Deltas

Creating a New Delta

Clicking on the Deltas link at the top of the navigation menu will produce a list of existing Deltas and a button for New Delta in the upper right. Click on New Delta.

776776

Tables

19301930

On each side of a Delta is a table definition: Table A on the left and Table B on the right. We recommend using Table A for your target table (the table receiving information from Table B).

To proceed, select the A side and B side Source/Table. Tables are listed with their schema name. Once you select both tables, the column information will automatically populate in the next section.

Column Mapping

11361136

In this section, your table columns are mapped together and Deltas selects the appropriate metrics for each column comparison.

The columns from Table A are presented as a fixed list. Your objective is to select the Table B columns needed to validate that the Table A columns are correct.

If your column names match between tables, Deltas will map them automatically. If these Automappings are correct, you can move on to the Filters section. Otherwise, if you’d like to make changes, these are your options:

  • Set or Change the B Column Value
    Click on the green downwards carrot symbol and either choose Unmapped (which stops the column pair from being compared) or choose another column. Note: you can only choose another B column if it is not matched in another pairing.

  • Remove a Column Pair From the Delta
    Click on Remove and this pair will not be compared when the Delta is executed. Note that the metric count changes to 0.

  • Add a Column Pair To the Delta
    Click on Add and this pair will be compared when the Delta is next executed.

  • Remove All Columns From Table B
    Click on Clear Table B and all B column values will change to Unmapped. This is useful if you want to clear the Automapping and make a few specific custom mappings.

  • Apply the Automapping Again
    Click on Remap Columns and the Automapping will occur again, overwriting any changes you’ve made. This is useful when you want to reset to the baseline mapping.

  • Note: None of these changes will be permanently saved until you click Save Delta or Update Delta at the bottom of the page. You can always click Cancel to revert to the prior Delta definition.

Filters

18821882

Filters are added to the Deltas’ queries as a WHERE clause. Write your filters in the SQL dialect of the source tables, but omit the actual WHERE keyword.

Filters are useful to restrict the rows used in the Delta. You may wish to exclude rows from the source that are not in the target. You may wish to limit the Delta to a recent time period or a particular dimension of the data.

Filters are optional and you can choose to filter one table only. Your filters can be different on each table.

After you enter the SQL in the Conditions A box, you can automatically apply it to the Conditions B box by clicking Copy to Conditions B.

Note: you might need to modify the SQL in Conditions B depending on the database and the specific functions used.

Group By

18761876

Group By columns are added to a Delta query as a GROUP BY clause.

Group Bys are useful to understand column differences at a finer grain of dimensionality. You may select more than one column for the grouping.

Group Bys are optional but if you select one or more columns on one side you must select the same/equivalent columns on the other side. One-sided grouping is not supported.

When you select a column on the A side, its mapped pair (if one exists) will automatically be selected on the B side. If the A side column is not mapped to a B side column, the value Unmapped will appear on the B side. You can change this to an appropriate column.

Name

18861886

A default name of [A schema].[A table name] - [B schema].[B table name] will be created for your Delta. You can change this name. Each Delta’s name must be unique.

Schedule

19141914

In this section you may choose an existing schedule (click in the box to see available choices), no schedule (choose None), or a new schedule (choose Create new schedule). See the Administering Schedules section of this document for creating schedules.

Deleting Deltas

To delete a single Delta, go to the Delta list, click on the Actions link (...) on the far right side of the Delta, and then select Delete in the drop down.

19991999

To delete multiple Deltas, select them with the checkboxes on the left side of the list, then click , then click Delete.

19991999