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

Community

Connector Improvement: Add HVR support for views in Redshift connector as a source

Yuliya Zakharenko User

Currently, we are unable to bring data from Redshift views. We have a need to fully refresh data from Redshift database tables and views. We can refresh data from tables, but the checkbox for show views is missing. When we used hvradapt command to search for the view, we got an error show_views is not supported for location. 

S:\>hvradapt -V -mV_VIEWNAME-larcdv2_chpw prd_hvrhub arcdver2_sql
hvradapt: Fivetran HVR 6.1.0/68 (windows-x64-64bit)
hvradapt: F_JR1767: Argument 'show_views' is not supported for location 'arcdv2_chpw' with class 'redshift'.

Thank you, 

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Mark Van de Wiel User

    Hi Yuliya,

    Thank you for your suggestion.

    We will introduce support for retrieving view definitions from a Redshift database in version 6.2.5/8, planned to be released in July.

    Hope this helps.
    Mark.