Get PrettyWhale.ai running in under 2 minutes

​

Prerequisites

• A PrettyWhale.ai account (If you’re not sure, please contact your company administrator or our sales team)
• A data sample file : a sample in JSON or CSV format containing field names and values from the dataset you want to ingest
• An access to VS Code
• An internet connection

​

Generate Your First Pipeline

1

Install PrettyWhale.ai extension

Search for the PrettyWhale.ai extension in the VS Code Extensions section (left panel) and install it.

2

Sign in

Once the extension is installed, click “Sign in,” and you’ll be redirected to the login page in your browser. If it’s your first connection, use the link you received by email to set your passwordOnce you’re signed in, you can go back to the extension, you’ll land on your pipeline dashboard where all your projects are listed.

3

Import your sample file

Click New flow from the panel. You’ll be asked to upload your sample data file from your VS Code folder. For the moment, PrettyWhale.ai accepts JSON and CSV formats.Select your file, choose the first setting option and click Start analysis:Here is an example of a valid JSON sample file if you want to test the solution: sample.zipYou don’t need to define a schema ahead, PrettyWhale.ai infers everything it needs from the sample content.

The sample file can not exceed 50k max.

4

Review the Data discovery and select your fields

PrettyWhale.ai immediately begins analyzing the structure, detecting field names, data types, value distributions and potential anomalies:It displays a field-level breakdown of your sample file. For each detected field you’ll see:

• Inferred data type
• Example values drawn from your sample

You’ll also see a summary of the issues found and improvements needed to ensure the quality of the data. Then, you can check or uncheck each field to control what is included in your pipeline scope. Fields you exclude won’t appear in the generated ingestion code, tests, or schema, keeping your output clean and focused on what you actually need.

5

Review and configure transformations

PrettyWhale.ai model suggests a set of transformations for each field you’ve selected:You can accept any suggestion as-is, modify it or remove it:Common suggestions include normalizing date formats, trimming leading and trailing whitespace from strings, standardizing text casing, and validating patterns like email addresses or phone numbers.Once you’re satisfied with the transformation configuration, click Next to proceed to the Output Generation step.

6

Output Generation

This final step allows you to choose the target output format for the data. Once you have made your selection, you can let the model generate your pipeline:You will receive regular updates on the progress of the generation:Once generated, the pipeline folder is created in your current VS Code folder and you have access to the files to review them and run the code: 

At the end of the generation cycle, the pipeline is executed on our infrastructure before it is packaged. It runs on the sample you provided and the tests are also executed. Thus, what lands in your repository has already been executed.