Using the transformation builder in a Kafka data store - Data360_DQ+ - Latest

Data360 DQ+ Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
Latest
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Help
Copyright
2024
First publish date
2016
ft:lastEdition
2024-07-09
ft:lastPublication
2024-07-09T15:09:58.774265

If the Store Repository Type of a data store is Kafka, the Layout panel contains a Build Schema and Transformations button. Click this button to open the Build Schema and Transformations dialog.

You can build a schema manually, or by using sample content. Click Add, then select an option from the drop down menu:

  • Field - Select the Field option to start creating the schema manually, or to add a field to or edit an existing schema. For details, see Building schema manually.
  • From Sample JSON - This option is available if the Layout Type is JSON. Select this option if you have an example of the JSON that the Kafka store holds. For details, see Building schema by using sample content.
  • From Avro File - This option is available when the Layout Type is Avro. Select this option to use a sample Avro file to generate the schema. For details, see Building schema by using sample content.
  • From XML File - This option is available when the Layout Type is XML. Select this option to use a sample XML file to generate the schema. The Row Tag also needs to be specified. For details, see Building schema by using sample content.

If the This channel will be used to write to Kafka data store property is selected, the fields tab includes only the "key" and "value" fields. Both fields are of type string.

If the This channel will be used to write to Kafka data store property is not selected, when you save any changes in the transformation dialog, the output structure is used to create the data store field definitions. The following fields are automatically added:

  • kafka_original_value (string)
  • kafka_message_timestamp (datetime)
  • kafka_parse_failed (string)
Note: If you already have generated or added a schema, the schema that is built will replace the existing schema.
  1. With the Schema and Transformation Builder open, Click Add.
  2. Select the option from the drop down list.
  3. Click in the text area.
  4. Enter the sample content that represents the content you want to parse. For example, you might have the following sample JSON: {"region":"name", "city": "name"}.
  5. Click Build Schema. The transformation is automatically generated using the default parsing options.
  6. Click OK to close the Edit Transformations Window
  7. Click Accept Changes.

If you use the generator to build your schema, the first field in the schema will always be a Struct with no Source Name given.