Scenario: You are managing a dataset that stores customer information and purchase records for an e-commerce platform. This dataset contains data on customers, their orders, and their purchase history. You need to create a list to analyze this data more effectively, and you have the following options for data ingestion:

1. Reload:
   • Imagine you have a parent query that retrieves customer data, including their contact information and order history. You want to keep this list up-to-date as new orders and customer information are added. By selecting the "Reload" option, you can effectively refresh the list.
   • When you choose to reload, Infoveave will truncate the existing data in your list and replace it with the most recent data from the parent query. This ensures that your list always reflects the latest customer details and order information. This option is particularly useful when your source data is frequently updated, and you want to maintain a real-time or near-real-time view of your customers and their orders.
2. Insert:
   • Suppose you want to enhance your list by adding new columns, such as a "Total Purchase Amount" column, which calculates the sum of purchases for each customer. By selecting the "Insert" option, you can accomplish this without altering the original parent query.
   • With the "Insert" option, you create a sub-query that calculates the "Total Purchase Amount" and inserts it into the list as a new column. This sub-query acts independently, allowing you to enrich your list with additional data without modifying the way your core customer data is retrieved. It provides the flexibility to customize your list with calculated fields or data from related sources while keeping your parent query structure intact.
3. Upsert:
   • Now, consider a situation where you need to update specific information within your list. For instance, some customers have changed their addresses, and you want to ensure your list reflects these corrections without re-fetching all the customer data. With the "Upsert" option, you can achieve this.
   • By selecting "Upsert," you can define a sub-query that contains the corrected customer addresses. Additionally, you specify a key column to identify which customer records need updating. Infoveave will then manage the insertion and updating of data in your list, ensuring that the customer records with modified addresses are updated while preserving the rest of the data. This approach streamlines the process of keeping your list accurate without altering the structure of your parent query.

In summary, these data ingestion options in Infoveave's list feature offer you precise control over how you manage and maintain your datasets. Whether it's keeping your data current with a full reload, enhancing your list with new calculated columns, or selectively updating records with an upsert, you can choose the method that best aligns with your specific data needs, all while preserving the integrity of your parent query.