Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: HVR should support postgreSQL data types like text array _text natively.

Answered
Saurav Chugh User

HVR should support PostgreSQL data types like text array _text natively without the need to define a custom capture/Integrate expression. Currently, HVR capture/refresh job fails for these data types. These data types(_varchar, _text) are very basic/common data types of PostgreSQL and they should be supported in-built by the software.

Please see HVR support ticket#312367 for more details.

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Mark Van de Wiel User

    Hi Saurav,

    I'll discuss this with the team if this is something we can take on some time in calendar year 2026.

    In the meantime - as I suspect support will have told you - you can use the extended data type support to pass through the data.

    How would you expect the data to be represented in Databricks?

    Thanks,
    Mark.

  • Edwin Fivetranner

      Hi Saurav,

    I was reviewing this feature request and planning to work with the team to assess native support for PostgreSQL array types like _text and _varchar in HVR.

    To help us design the right solution: how would you expect these array values to be represented on the Databricks side? For example, as a native Databricks array/struct type, a JSON string, or another format?

    In the meantime, the extended data type support Mark mentioned remains the available workaround or engineering solution. Doesn't that work for you?

    Best,Edwin