Chapter 10. Organizing Stored Procedures
Determine how the data is added to storages and organize stored procedures for deployment scenarios.
You can add the data to storages in one of the following ways:
From analytical tables or directly from Parquet files using stored procedures.
This is the easiest and most reliable way, since it allows for transactional data and metadata updates.
Using SQL scripts and custom stored procedures.
It is recommended to use this way only for the use cases that cannot be implemented using stored procedures.
Important
If this way is used, responsibility for correct metadata registration and integrity is not guaranteed.
Postgres Pro operations, temporary tables, and custom data conversion scripts can be used for implementing complex initial data processing within stored procedures.