3 ms·
While the points are true for manual CREATE OR REPLACE, same could be said of any ad-hoc editing stuff in production by hand. 1, 4 - can be achieved with tools
by VTimofeenko 4y ago
While the points are true for manual CREATE OR REPLACE, same could be said of any ad-hoc editing stuff in production by hand.
1, 4 - can be achieved with tools such as DBT
2, 3 - certain databases come with proper Python environment with various tooling around that
- skyde 4y agowhile i admit it’s doable if using traditional SQL database it’s sadly not possible with newsql and noSQL databases. Also in my last 30 year working for different industries, it’s extremely rare that DBA write unit test or a proper deploy system to automatically rollback if anything break while changing database schema or stored procedure. the best DBA i have met use Liquibase or something similar to treat database code like app code. But this is the exception not the norm.