INLINE DATATYPE

Agile Data Engine supports column level inline datatype definition if the logical datatype is defined to require such. Column level inline datatype is defined in the INLINE DATATYPE attribute property.

See also:

Attributes

Usage

PROPERTY

INLINE DATATYPE: full definition of the datatype inline

Warning

Inline datatype change will force entity recreation WITHOUT DATA.

Examples

Setting column inline datatype in Google BigQuery

Set ARRAY STRUCT for column taxi_details in table S_TAXI_ZONE:

PROPERTY

INLINE DATATYPE:
ARRAY<STRUCT<key STRING, value STRING>>

Resulting DDL generated by Agile Data Engine:

SQL

CREATE TABLE rdv.S_TAXI_ZONE (
  ...,
  taxi_details ARRAY<STRUCT<key STRING, value STRING>>
);

Setting column inline datatype in PostgreSQL

Set custom id for the table CONTENT:

PROPERTY

INLINE DATATYPE:
INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY

Resulting DDL generated by Agile Data Engine:

SQL

CREATE TABLE rdv.CONTENT (
  id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY NULL
  ,...
);