The output of the query is only the fields name

Hi there,

I have installed sqlalchemy-vertica vertica_python, and I am using it in the JupyterNotebook with sql magic function %sql.

The connection is successfully made and the query runs but the result is empty, I see only the column names.

%sql vertica+vertica_python://victorc:****@host/dbname
result = %sql SELECT * FROM table_name LIMIT 10

The result is only the fields name.

I am wondering if it is due to ipython-sql or sqlalchemy_vertica libraries ?
Any thoughts will be appreciated.

Python version: 3.7

Thanks,
Victor