Test queries with branching
Create a Neon branch to test queries before running them in production
In the previous data recovery example, you ran a
DELETE query on the
elements table to remove duplicates, but the problematic query deleted most of your data.
DELETE queries are potentially destructive, it is recommended that you test them before running them on your production database. You can do this in Neon by creating a test branch.
Create a test branch
Navigate to the Branches page and click the New Branch button to create a new branch. Name the branch
This time, create the branch from
Head, which creates a branch with the most up-to-date state of your database. Specify the recovery branch you created previously as the parent branch.
Run your query
Navigate to the SQL Editor, select the test branch, and run your new
Next, run the following query to verify that the query ran as intended:
You should find that the query successfully removed duplicates from the
elements table. You can now safely apply the query to your production branch, and the test branch can be deleted.
Congratulations. You have completed the Neon tutorial. Here is a recap of what was covered:
- You learned how to set up a Neon project.
- You learned how to create a table and insert data using the Neon SQL Editor.
- You learned how to explore data using the Tables feature in the Neon Console.
- You learned about Neon's database branching feature and how you can use it to recover lost data.
- You learned how to use a branch to test a potentially destructive query before running it in production.