Hi, after stream error, Airbyte is not removing tmp table. Is this destination connector issue or Airbyte engine itself?

Yes, this is current limitation of the product. There is a Github issue for this feature: https://github.com/airbytehq/airbyte/issues/7011