Data Ingestion

2 min

Data Ingestion for the most part remains the same for AJOCO. The following Sources are supported for use with Orchestrated campaigns:

Type	Source
Cloud Storage	Amazon S3
	Google Cloud Storage
	SFTP

Cloud Data Warehouses	Snowflake
	Google BigQuery
	Data Landing Zone
	Azure Databricks

File-Based Uploads	Local File Upload

Configure a Data Flow

Go to Sources under Connections from the Navigation.

In the catalog: Search for Local File Upload

Click Add Data

Click the toggle under Change data Capture

Select the dataset you created

Click Next

Drag and Drop bookings file. Click Next. Click Finish.

You can either download the file or copy the contents and save it in a note pad (notepad++, notes, textEdit, etc) with the extension .csv.

SAMPLE_BOOKINGS_DATA.csv

bookingNumber,version,emailAddress,firstName,lastName,productLine,productName,bookingDate,departureDate,fromPort,shipCode,cabinCategory,sailingSeason,preExtension,postExtension,extPreName,extPostName,insuranceIndicator,airType,airTicketed,airIndicator,numShoreExcursions,numOfDays,packageCode,officeCode,marketCode
VRV000500,1,[email protected],Sarah,Williams,River,Imperial Jewels of China,2025-09-04,2025-11-07,Barcelona,AGR,Standard,2025,,,,,N,,N,Y,9,12,AGR251107,VAU,EUR
VRV000501,1,[email protected],Sarah,Williams,River,Romantic Danube,2025-09-22,2026-01-21,Basel,AGR,Deluxe Suite,2026,,,,,N,,N,Y,1,13,AGR260121,CRU,DOU
VRV000502,1,[email protected],Sarah,Williams,River,Charms of the Rhine,2025-09-13,2025-10-30,Copenhagen,DLL,Deluxe Suite,2025,BUD,,Budapest Pre-Extension,,Y,D,Y,N,7,15,DLL251030,CRU,EUR

Congratulations, you have completed this lab!