class_docstr: This handler handles connection and exectuin of Google BigQuery statements
docstr: Get a list with all of the tabels in BigQuery
docstr_tok: ["Get","a","list","with","all","of","the","tabels","in","BigQuery"]
code: def get_tables(self) -> Response:
      """
      Get a list with all of the tabels in BigQuery
      """
      q = f"SELECT table_name, table_type, FROM \
               `{self.connection_data['project_id']}.{self.connection_data['dataset']}.INFORMATION_SCHEMA.TABLES`"
      result = self.native_query(q)
      return result
  
imports: import os
  import json
  from collections import OrderedDict
  from google.cloud import bigquery
  from google.oauth2 import service_account
  from sqlalchemy_bigquery.base import BigQueryDialect
  from mindsdb_sql.parser.ast.base import ASTNode
  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 HandlerStatusResponse, HandlerResponse, RESPONSE_TYPE
  from mindsdb.utilities import log
label_desc: Use image node_id 8 for calling the BigQueryHandler obj's underlying member method code with example usage: obj.get_tables() and returns: result