Hello Team, I am trying to do data profiling on a ...
# troubleshoot
s
Hello Team, I am trying to do data profiling on a Vertica Table. If I enable profiling in my recipe, the ingestion via cli gives error as such:
Copy code
File "C:\Users\xxxxx\AppData\Local\Programs\Python\Python39\lib\site-packages\datahub\ingestion\source\sql\vertica.py", line 1014, in loop_profiler_requests
    for projection in inspector.get_projection_names(schema):  # type: ignore
AttributeError: 'PGInspector' object has no attribute 'get_projection_names'
With little bit of debugging i was able to figure out that the inspector being used is sqlalchemy.dialects.postgresql.base.PGInspector and this inspector infact doesn't have function get_projection_names. Question : is it the correct function being used in loop_profiler_requests call and in general did anybody have success with profiling Vertica ?
👀 1
✅ 1
a
Hi @salmon-psychiatrist-4013, there’s currently a PR in flight for Vertica integration here: https://github.com/datahub-project/datahub/pull/7010
I’d keep track there, as it’s the state of the art for Vertica right now!
s
thanks a lot @astonishing-answer-96712. I will keep a look on the said PR.