The Castodia Database Connector provides two options before running a query: overwrite and append. Each option will refresh your data differently, depending on what you're trying to accomplish. In this article, we'll walk through the differences of the two.
The overwrite function is a smart overwrite, meaning that it will not overwrite the entire spreadsheet. It will only remove the existing columns pulled from the database and and upload the new set of data. Let's take a deeper look.
Our first run through indicates a limit of five entries. On column G, we've added a formula to show the sum of rental_rates, $20.95.
Our second run through indicates a new limit of ten entries.
When you run with the overwrite option selected, only the columns indicated in new the query are replaced, or "overwritten". Correspondingly, the sum of rental_rates, $37.90, is also updated. This way, the user can keep formulas in the rightmost columns that gets pulled from the database, without having those overwritten for no reason.
Now, let's use the append option and see how that affects the dataset. To access the feature, click on the drop-down menu beside the "run" button.
Our third run through will indicate a new limit of five entries. After running the query, you can see that five additional entries have been loaded onto the existing data. The sum of rental_rates has increased to $58.85 as a result of the additional data.
And that's it!
Click here to check out how to get started with Castodia (https://castodia.com/getting-started), and please feel free to reach out to us if you have any further inquiries.