Environment
Action Environment sets an operating system environment variable for the Fivetran HVR process which connects to the affected location. It also affects an agent called for this location.
If this action is defined on a specific table, then it affects the entire job including data from other tables for that location.
Parameters
This section describes the parameters available for action Environment.
Following are the two tabs/ways, which you can use for defining action parameters in this dialog:
- Regular: Allows you to define the required parameters by using the UI elements like checkbox and text field.
- Text: Allows you to define the required parameters by specifying them in the text field. You can also copy-paste the action definitions from HVR documentation, emails, or demo notes.
| Parameter | Argument | Description |
|---|---|---|
| Name | env_var | Name of the environment variable. |
| Value | path | Value of the environment variable. |
| Context | ctx | Ignore action unless Refresh or Comparecontextctx is enabled. The value must be the name of the context (a lowercase identifier). It can also be specified as !ctx, which means that the action is effective unless context ctx is enabled. One or more contexts can be enabled for hvrcompare or hvrrefresh (on the command line with option –Cctx). |
Examples
| Variable | Description |
|---|---|
HVR_LOG_RELEASE_DIRPostgreSQL | Specifies alternative directory for reading DBMS backup log files. The value points to an alternative location where HVR can find the backups of the transaction files (alternative to where the database dictionary indicates they are). This variable is similar to the location property Archive_Log_Path. PostgreSQL needs this for locating the archive files. |
| HVR_SORT_BYTE_LIMIT | Amount of memory to use before sorting large data volumes in temporary files. The default limit is 512Mb. |
| HVR_SORT_ROW_LIMIT | Number of rows to keep in memory before sorting large amounts of data using temporary files. The default limit is 10M. |