Hi team, I’m trying to ingest a Redshift cluster &...
# troubleshoot
p
Hi team, I’m trying to ingest a Redshift cluster & facing the following error:
Copy code
error was '
           '(psycopg2.errors.FeatureNotSupported) Specified types or functions (one per INFO message) not supported on Redshift tables.
From some investigation we did, the recommendation is to install
psycopg2
package Not sure it’s relevant here, because I’m only configuring my YAML to ingest the data I’m able to connect the cluster from my local prompt Pls. advise…. cc: @modern-garden-35830 @icy-controller-68116
📖 1
🔍 1
l
Hey there 👋 I'm The DataHub Community Support bot. I'm here to help make sure the community can best support you with your request. Let's double check a few things first: ✅ There's a lot of good information on our docs site: www.datahubproject.io/docs, Have you searched there for a solution? ✅ button ✅ It's not uncommon that someone has run into your exact problem before in the community. Have you searched Slack for similar issues? ✅ button Did you find a solution to your issue? ❌ Sorry you weren't able to find a solution. I'm sending you some tips on info you can provide to help the community troubleshoot. Whenever you feel your issue is solved, please react ✅ to your original message to let us know!
p
• DH version(CLI):
0.10.1.2
&
0.10.2
• Deployment method: helm charts • Logs - I prefer to share in private • Ingestion recipe:
Copy code
source:
    type: redshift
    config:
        host_port: 'xxxxx:xxxx'
        database: xxxxx
        username: xxxxx
        password: 'xxxxxxxx'
        include_tables: true
        include_views: true
        options:
            connect_args:
                sslmode: prefer
                sslrootcert: null
        profiling:
            enabled: true
            max_workers: 3
            profile_table_level_only: false
            include_field_sample_values: false
I see in the docs that
scheme
default value is redshift + psycopg2
d
hmm, interesting, please, can you share the logs with me? I wonder where it failed.