Hi, I’m having trouble with the syntax to alias a property using

stream_maps

+

meltano.yml

. What is the correct way to alias a property?

you are trying to rename the existing column

Contract Date

as

contract_date

?

you are trying to rename the existing column

Contract Date

as

contract_date

?

Yes

I wonder if this would work:

```#meltano.yml

plugins:

extractors:

- name: tap-custom

config:

stream_maps:

sales:

contract_date: "record['Contract Date']"```

The above syntax worked, thanks Matt!

maybe it should be this, to drop the field with the old name too?

I added

"Contract Date": null

but the property still appeared in the output 🤔

@joseph_lozano can you try

__else__: __NULL__

?

That works, thanks Edgar!

#meltano.yml
plugins:
  extractors:
  - name: tap-custom
    config:
      stream_maps:
        sales:
          contract_date: "record['Contract Date']"
          __else__: __NULL__

Hey folks! Taking from here, with a similar example (sending to channel to help bump up). What if I still wanted to hide the

record['Contract Date']

column in the previous example, without using

else

?

Hey @felippe_felisola_caso, is

Contract Date: __NULL__

what you need?

That’s right! And that doesn’t work due to the space (or other special characters, in my case). But, actually, what I really want like Joseph is to change a column’s name. I’m assuming that the canon way of doing that is the one here in the thread: • Creating a new one with the contents of the previous • Hiding the previous

And that doesn’t work

Have you tried wrapping the column name in quotes:

plugins:
  extractors:
  - name: tap-custom
    config:
      stream_maps:
        sales:
          contract_date: "record['Contract Date']"
          "Contract Date": __NULL__

That actually worked! I probably missed that one out in the several trials between variations of

null

,

__NULL__

and

record[]

Thanks a lot, Edgar 😃