I am using Airbyte to sync data (issues) from Jira to Postgres. I can see whole json being synced in a single column

_airbyte_data

. 1. Is there any way to map fields to columns (not a single column) in table? 2. Is there any way to map only a few fields to columns in table? (i.e skip a few fields). I can only check the whole endpoint, not individual fields.

Hey have you explored custom DBT ?

Nope. Can’t we map these fields before data is being stored in the database by using this or another UI?

Hey we don't have a way to do that. I suggest you to use Custom DBT for this.

Understood, thanks for the response. I’ll look into custom DBT.