You can access the schema and transformation builder from an external data store that has one of the following layout types.
- Avro
- JSON
- ORC
- Parquet
- XML
Viewing and schema transformations
Note: These steps apply if the Store Repository Type is S3 or Default. For information about Kafka data stores, see Using the transformation builder in a Kafka data store.
Complete the following steps to view the current transformations.
- Navigate to the data store.
- Click Edit > Edit Stage.
- Select the Details tab.
- In the Layout panel, click Edit Transformations. The Edit Transformations dialog is displayed.
Editing schema transformations
With the Edit Transformations dialog open, you can add or edit existing schema elements. For more information, see Building schema manually.
Refreshing the schema
If the schema is not displayed, click Refresh Schema. The schema is generated from the sample input file, and displayed. For example, `age` BIGINT,`registered` BOOLEAN,`email` STRING.
If you have made changes to the generated schema, for example by changing the way an array in the input is handled, these changes will be preserved
Viewing SQL