Overwrite vs append data on Google Sheets

Introduction

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.

Overwrite

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.

Castodia overwrite feature on Google Sheets
Overwite data with Castodia on Google Sheets

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.

Castodia smart overwrite feature on Google Sheets
Smart Overwrite keeps columns to the right intact for formulas

Append

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.

Castodia append feature on Google Sheets
Append data with Castodia on Google Sheets

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.

Book demoStart free trial

Try Castodia free for 14 days, no credit card required.