One more thing to say: If you’re using the same code in different environments, you can make two apps (your “development app” and your “production app”), and use Git on your machine to pull code from one and push to the other. That way, you have separate environments with separate data tables.
(Note: Beware that this will break App Secrets. By design, an App Secret created in one app cannot be accessed by another app. However, you can access your dependencies’ App Secrets, so if you want secrets that are available in both environments, put them in a dependency they both share.)