Rivery Metadata
  • 1 Minute to read
  • Dark
    Light
  • PDF

Rivery Metadata

  • Dark
    Light
  • PDF

Article Summary

Rivery Metadata

Currently only available in Source to Target Rivers.

Rivery supports custom metadata that describes the data origin.
Rivery metadata currently includes:

NameTypeDescriptionDefault
_rivery_last_updateDatetimeThe time the columns was last updated or inserted (Note: At time of the insert to DB statement)Yes
_rivery_run_idStringThe run ID that updated the columns or inserted itYes
_rivery_river_idStringThe River ID that the column originated fromYes
_rivery_river_nameStringThe River name that the column originated from (Note: The name at the time of the run)No
_rivery_env_idStringThe River environment ID that the column originated fromNo
_rivery_env_nameStringThe River environment name that the column originated fromNo
Note

Rivery Metadata cannot include the following characters:
' ` " /
If the variable value contains one of those, please replace it.

How to use Rivery Metadata

Source to Target Rivers include the following metadata columns in each Output Table by default:

_rivery_last_update
_rivery_run_id
_rivery_river_id

Please Note
  • Currently available for 'Predefined Reports' supported API sources and 'Multi-Table' supported Database sources.
    Any Database could be the Target.
  • Logic Rivers currently do not support this feature.

To enable this feature, navigate to the Target tab and set the "Add Rivery Metadata" toggle to true (under Additional Options).

image.png

Metadata Syntax:

In each of the corresponding databases, the following statement will be executed for the '_rivery_last_update' expression:

NameStatementType
Google Big QueryCURRENT_TIMESTAMP()TIMESTAMP
Amazon RedshiftGETDATE()TIMESTAMP
Snowflakecurrent_timestamp()TIMESTAMP
Azure SynapseCURRENT_TIMESTAMPTIMESTAMP
Databrickscurrent_timestamp()TIMESTAMP
Postgresnow()TIMESTAMP

in Custom Expressions:

Rivery Metadata can also be used in custom expressions for Target mapping. When creating a river, simply go to the schema tab and enter any of the supported expressions, followed by any valid name.

image.png

As a result, the following metadata will be added to the Target table:

image.png


Was this article helpful?