datakiln.metadata.unpivot module

Unpivot metadata.

class datakiln.metadata.unpivot.UnpivotColumnMeta(unpivot, regex=None, order=1000, **kwargs)[source]

Bases: ColumnMeta

Metadata for columns that are unpivoting targets.

value(column)[source]

Value for the column to be unpivoted.

Parameters:

column (dict) – Name of the column to be unpivoted.

Returns:

Unpivot value.

Return type:

str

class datakiln.metadata.unpivot.UnpivotValueMeta(unpivot, columns, **kwargs)[source]

Bases: ColumnMeta

Metadata for columns that will store unpivoted values.

class datakiln.metadata.unpivot.UnpivotMeta(alias, target_columns, target_values, **kwargs)[source]

Bases: object

Metadata for unpivoting columns.

columns()[source]

Unpivot columns.

Returns:

Pivot columns.

Return type:

list[ColumnMeta]

values()[source]

SQL with VALUES to use in LATERAL JOIN.

Returns:

Values.

Return type:

list[str]

lateral()[source]

Returns the LATERAL JOIN to unpivot a table.

Returns:

LATERAL JOIN expression.

Return type:

list[str]