class_docstr: This handler handles connection and execution of the FaunaDB statements.
class_docstr_tok: ["This","handler","handles","connection","and","execution","of","the","FaunaDB","statements","."]
docstr: Get the list of collections in the FaunaDB database.
docstr_tok: ["Get","the","list","of","collections","in","the","FaunaDB","database","."]
code: def get_tables(self) -> Response:
      """
      Get the list of collections in the FaunaDB database.
      """
      try:
          result = self._client.query(q.paginate(q.collections()))
          collections = []
          for collection in result["data"]:
              collections.append(collection.id())
          return Response(
              resp_type=RESPONSE_TYPE.TABLE,
              data_frame=pd.DataFrame(
                  collections,
                  columns=["table_name"],
              ),
          )
      except Exception as e:
          logger.error(f"Error getting tables from FaunaDB: {e}")
          return Response(
              resp_type=RESPONSE_TYPE.ERROR,
              error_message=f"Error getting tables from FaunaDB: {e}",
          )
  
imports: import json
  import pandas
  from collections import OrderedDict
  from typing import List
  from faunadb import query
  from faunadb.client import FaunaClient
  from mindsdb_sql import Select, Insert, CreateTable, Delete
  from mindsdb_sql.parser.ast.select.star import Star
  from mindsdb_sql.parser.ast.base import ASTNode
  from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE
  from mindsdb.integrations.libs.response import RESPONSE_TYPE, HandlerResponse, HandlerStatusResponse
  from mindsdb.integrations.libs.base import DatabaseHandler
  from mindsdb.utilities import log
label_desc: Use image node_id 13 for calling the FaunaDBHandler obj's underlying member method code with example usage: obj.get_tables() and returns: Response, Response