:wave: Hello, team! I would like to add additional...
# all-things-deployment
t
👋 Hello, team! I would like to add additional SQL Alchemy Dialect for Vertica - to be able to work with QuickStart Image and define automatic ingestion. I can do it from CLI command line, but I would like to have it in GUI. Is there a way to do so without rebuilding image:I did
# python3 -m pip install 'acryl-datahub[sql-profiles]'
# python3 -m pip install 'acryl-datahub[sqlalchemy]'
# python3 -m pip install sqlalchemy-vertica-python
And manage to execute the ingestion of object into Vertica. However it is not working in GUI - error is that Vertica-Python module cannot be found. Is there a way to add this module without rebuilding the docker image? 1> I woudl also like to execute SQL Profiling for SQL alchemy - but when I add profile.enable = True - I am gettig error. Any suggestions? Thanks
h
1. To add a new vertica connector, you need to (a) Implement a new source similar to postgres source (b) update entry_points with a new entry for
vertica
similar to this and (c) update the source's package dependencies(sqlalchemy-vertica-python) similar to this. 2. What exactly is the error that you are running into when you enable profiling?