Hope you have already created your Data Cloud Org and also downloaded the Customer's details and Sales details from previous posts.
Now it's time to ingest that data in our Data Cloud Org. So, first login in your Data Cloud Org and go to App Launcher and search for "Data Cloud" App.
It will open the "Data Cloud" App and you will get multiple data cloud related Tabs like belwo screen but in this post we will concentrate on "Data Streams" and "Data Lake Objects" Tabs.
Now our aim is to ingest data from external sources to this data cloud Org and here as we need to load data from direct excel files, so we don't need to connect with any ORG and we will directly ingest data from excel to the Data Cloud by Data Stream's File Upload options. What is this? - let's do some paractical to get more idea on this.
Click on the "Data Stream" Tab and it will open the Data Stream List View.
Now, click on the "New" button to create the new Data Stream.
It will open the below screen and select the "File Upload" icon and then click on "Next" button.
Now it will open the file selection screen as below,
Click on the "Upload Files" button and then select your "OfflineSalesDetails" file that you have downloaded for customers' offline sales data.
System will load the file and open the below screen. In the below screen you could see that System set default Dala Lake Object Label and API. So, it is always better to update the name based on your need. Update it as mentioned in the below screen and on left side you could find the Category selection option and as we are going to create individual profile, so select here "Profile" option.
Next we need to select the Primary Key (PK) - but if you noticed our data in OfflineSalesDetails sheet then you will found there is no unique value to set as PK. We have "Cstomer Id" but we can't able to use it as PK as multiple records with same "Cstomer Id". So, how we can get the PK?
Here we have to Create a Formula Field to make PK.
Save it and then select this custom formula field as PK.
Now click on the "Supported Fields" Tab and verify the data type.
In this POC every thing looks good, so click on the "Next" button. Select the Data Space. In this POC, we don't have any extra Data Space ccreated, so we will set the OOB "default" data space.
Click on "Deploy".
After deploy, it will redirect to below screen.
It will take some time and after some time it will show status as "Success" and details will be display in "Refresh History". We can also noticed total records ingested = 5.
Same way create another data stream to ingest "OfflineCustomerDetails" data. Here we will use "Customer Id" as a PK as there is no dupicate id on records and also update Email fied type as "email".
After deploy it will take some time and after some time it will show status as "Success" and it will load 3 records.
Next Step: Now our next step will be checking the data of Data Stream, Data Lake Objects.
