class_docstr: This handler handles connection and execution of the Vertica statements.
class_docstr_tok: ["This","handler","handles","connection","and","execution","of","the","Vertica","statements","."]
docstr: Get a list with all of the tabels in VERTICA
docstr_tok: ["Get","a","list","with","all","of","the","tabels","in","VERTICA"]
code: def get_tables(self) -> Response:
      """
      Get a list with all of the tabels in VERTICA
      """
      q = f"""SELECT 
          TABLE_NAME,
          TABLE_SCHEMA
          from v_catalog.tables 
          WHERE table_schema='{self.schema_name}' 
          order by
          table_name;"""
  
      return self.native_query(q)
  
imports: from collections import OrderedDict
  from typing import Optional
  import pandas
  import vertica_python
  from mindsdb_sql import parse_sql
  from mindsdb_sql.render.sqlalchemy_render import SqlalchemyRender
  from mindsdb_sql.parser.ast.base import ASTNode
  from mindsdb.utilities import log
  from mindsdb.integrations.libs.base import DatabaseHandler
  from mindsdb.integrations.libs.response import HandlerStatusResponse, HandlerResponse, RESPONSE_TYPE
  from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE
  from sqla_vertica_python.vertica_python import VerticaDialect
label_desc: Use image node_id 7 for calling the VerticaHandler obj's underlying member method code with example usage: obj.get_tables() and returns: self