class_docstr: This handler handles connection and execution of the Cloud Spanner statements.
class_docstr_tok: ["This","handler","handles","connection","and","execution","of","the","Cloud","Spanner","statements","."]
docstr: Get a list of all the tables in the database.
  
  Returns:
      Response: Names of the tables in the database.
docstr_tok: ["Get","a","list","of","all","the","tables","in","the","database",".","Returns",":","Response",":","Names","of","the","tables","in","the","database","."]
code: def get_tables(self) -> Response:
      """Get a list of all the tables in the database.
  
      Returns:
          Response: Names of the tables in the database.
      """
  
      query = """
              SELECT
                t.table_name
              FROM
                information_schema.tables AS t
              WHERE
                t.table_schema = ''
          """
      result = self.native_query(query)
      df = result.data_frame
      result.data_frame = df.rename(
          columns={df.columns[0]: "table_name"}
      )
      return result
  
imports: import json
  from collections import OrderedDict
  from google.oauth2 import service_account
  from google.cloud import spanner_dbapi
  from google.cloud.spanner_dbapi import Connection
  from google.cloud.sqlalchemy_spanner import SpannerDialect
  import pandas
  from mindsdb_sql import parse_sql
  from mindsdb_sql.parser.ast.base import ASTNode
  from mindsdb_sql.parser.ast import CreateTable, Function
  from mindsdb_sql.render.sqlalchemy_render import SqlalchemyRender
  from mindsdb.integrations.libs.base import DatabaseHandler
  from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE
  from mindsdb.integrations.libs.response import RESPONSE_TYPE
  from mindsdb.integrations.libs.response import HandlerResponse
  from mindsdb.integrations.libs.response import HandlerStatusResponse
  from mindsdb.utilities import log
label_desc: Use image node_id 8 for calling the CloudSpannerHandler obj's underlying member method code with example usage: obj.get_tables() and returns: result