Data Resource - Target Data URI

Data Resource - Target Data URI

About

A target uri is a uri that defines one or more target resources for data transfer operations.

Howto

Syntax

pattern[@connection]

where:

  • connection is the name of a connection
  • pattern is an expression that define the name of the target. This pattern can include the captured characters from the data selector glob expression.

In the pattern, you can reference a globbing matched wildcard from a data source selector using the $x syntax where x indicates the index of a glob pattern. ie

  • $0 defines the whole expression (ie the source name)
  • $1 defines the first matched wildcard
  • $2 defines the second matched wildcard
  • and so on until $9.

Example

Reusing the name of the source in the target

The below target data uri

[email protected]

will define the target resource

  • located in the sqlite connection
  • and a name that is composed of
    • the prefix new_
    • and the name of the data source ($0)

Example: if the source table name is time, the target table name would be new_time

Using a part of source name in the target

With the below data selector

D?*@sqlite

and the below target data uri

[email protected]
  • if the source table name were D_TIME, D_CUSTOMERS,
  • the target table names would be TIME, CUSTOMERS

File system

  • In a shell such as powsershell, the $ character should be quoted.
tabli data copy '*/[email protected]' '/boot/[email protected]'
Powered by ComboStrap