Reading a Project Source

Astera Dataprep supports two ways to add sources:

• By interacting with the AI-powered chat interface

• Manually through Data Source Browser

Option 1: Add Sources using Chat

You can simply ask the Dataprep chat interface to load your data by:

• Providing it the name of the source:

• Providing it the file path of your source:

The system will automatically load it as a dataset, making it ready for use in your data preparation workflow.

Option 2: Toolbar Method

1. Open Astera Dataprep.

1. Navigate to the Toolbar and select Read > Project Source.

1. Once clicked, the recipe action is added to the Recipe Panel. Here, we have to configure the options to read the Project Source.

The options to be configured are:

• Filter Source: This dropdown filters the type of shared sources you will be able to view and choose in the Shared Source options. Options are:

  • All: Shows all shared sources.

  • Excel Source: Shows only Excel sources.

  • Delimited Source: Shows only delimited sources.

  • Dataprep Source: Shows only Dataprep sources.

  • Database Table Source: Shows only database table sources.

  • Report Model Source: Shows only report model sources.

• Shared Source: This dropdown shows the shared sources in the project (after filtering has been applied) that you can read.

• Dataset Name: This is the name given to the dataset. You can configure this to be able to use the dataset separately elsewhere. The dataset name is auto filled and defaults to the name of the selected shared source. However, this name can be changed as needed.

1. Click Apply to apply the changes or Cancel to discard them.

2. Once you click Apply, the dataset will now be visible in Astera Dataprep, and further data processing can be applied to it.

Option 3: Dataprep Grid Method

1. Open the Data Source Browser and navigate to Project Sources and expand the accordion. Here you will see all the relevant supported shared sources that you can read from.

1. Drag and drop the desired source onto the Dataprep canvas. A 2x2 matrix will appear. Drop the source onto the Read option within the matrix.

1. Click Apply to apply the changes or Cancel to discard them.

2. Once you click Apply, the source will be loaded into the Dataprep Grid, and you can begin working with it.

This concludes the document on reading a Project Source in Astera Dataprep.