postgresql to bigquery. tables with jsonb column. ...
# ask-community-for-troubleshooting
m
postgresql to bigquery. tables with jsonb column. tried both bigquery and bigquery typed struct connector and in both instances the jsonb column is serialized as a string in the destination, do I have to do anything special here to get jsonb to go to a struct at destination?
u
You can use BigQuery denormalized to generate native data types in your destination. If you want to continue with the connector you need to create a custom transformation using dbt