NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
* '''Postgres Password:''' password of the above user - in case of doubt, leave the default (''password'').
|-
| align="left" | '''3 - Post Processing SQL Scripts(optional)''' | align="left" | descIn this optional field it is possible to provide the full path and name to a '''validated SQL file'''. Whatever is specified inside that file will be executed on the staging area database after its generation. This can be valuable in several use cases, for example:* If a staging area with only a subset of the IMSMA data should be generated (in this case the SQL file would include DELETE statements)* If sensitive data (e.g. victim names and addresses) should not be transferred to the staging area (in this case the SQL file would include UPDATE statements to set all the victim names and addresses to NULL)* If data has to be pre-computed for reporting purposes* If additional database views are necessary, also for reporting and analysis purposes
|-
| align="left" | '''4 - Additional Options'''