You can transform data to perform operations on it. For example, you can aggregate or filter data, or you can join multiple data sets. You can also see the SQL code used to generate the transformed table.
You can store the output in a target table by creating an ELT pipeline that reads the data from the source and writes it to a target. To edit, save, and run the pipeline, open it as a mapping in Data Integration. The mapping represents the data flow logic in the pipeline as a series of transformations.
You can save sample data in a CSV file for future reference. Due to privacy guidelines, CLAIRE GPT doesn't save the sample data. If you refresh the browser or log out of CLAIRE GPT, the sample data will no longer be visible in the conversation, and you will be unable to download it.
CLAIRE GPT integrates with the following Intelligent Data Management Cloud services to help you transform data:
•Data Governance and Catalog
•Data Integration
Note: CLAIRE GPT can transform data from the catalog and create a pipeline that you can run as a mapping in Data Integration. You can't use CLAIRE GPT to edit existing mappings in Data Integration.