diepvries.link module

A link.

class diepvries.link.Link(schema, name, fields, *_args, **_kwargs)

Bases: DataVaultTable

A link.

property loading_order: int

Get loading order (links are the second tables to be loaded).

Returns:

Table loading order.

property parent_hub_names: List[str]

Get the list of parent hub names.

Returns:

Parent hub names.

property sql_load_statement: str

Get the SQL query to populate current link.

All needed placeholders are calculated, in order to match template SQL (check template_sql.hub_link_dml.sql).

Returns:

SQL query to load target link.

property sql_placeholders: Dict[str, str]

Link specific SQL placeholders.

These placeholders are used to format the Link loading query.

The results are joined with the results from super().sql_placeholders(), as all placeholders calculated in Table (parent class) are applicable in a Link.

Returns:

Link specific SQL placeholders.