search

MeltanoLabs / meltano-map-transform

A map transformer which implements the `Stream Maps` capability from Meltano's tap and target SDK: https://sdk.meltano.com/
Apache License 2.0
16 stars 15 forks source link

Renaming a column #252

Open miko866 opened 2 months ago

miko866 commented 2 months ago

Hi, I need to rename column index to [index] in MSSQL because it is a keyword. Unfortunately I didn’t find a example or syntax how this would be possible. Could someone help me?

edgarrmondragon commented 2 months ago

Hi @miko866, you could try something like

stream_maps:
  # Apply these transforms to the stream called 'customers'
  my_stream:
    # drop the original field
    index: __NULL__
    # alias
    index_field: index