text: def datatype_to_bq(datatype):
      """
      Simple attempt to do some basic datatypes.
      Fallback to String for unknowns and then you can fix it later in bigquery.
      """
      if "DATETIME" in datatype:
          return "DATETIME"
      if "DATE" in datatype:
          return "DATE"
      if "INT" in datatype:
          return "INTEGER"
      if "FLOAT" in datatype or "DOUBLE" in datatype or "DECIMAL" in datatype:
          return "FLOAT"
      return "STRING"
  