Hi team!
We have an integration process where We use Airbyte's Hubspot connector as source and Snowflake as destination.
We need to rename some tables after the data is loaded.
What would be the best course of action to do this?
I initially thought of using dbt (triggered by custom transformation option of Airbyte), but we're having some issues with it,
and i'm not sure i should keep trying with this or if there's a better way of solving this.
we need to run this as an automated command every time Airbyte finishes the connection
ALTER TABLE t1 RENAME TO t2;