Hi all, I made a connection using EL (Extract and Load) process using Airbyte, and store the result into dataset "A" in BigQuery. then I used DBT to Transformation process to modify the tables, and I want to store the result from DBT to another dataset ("B") into BigQuery. is it possible if I Used transformation without schema config from dbt? because I want to store the table from Transformation process into different dataset name in BigQuery? maybe can I use --profile config customize?

Hey if this usecase in itself is possible can you can take of this in custom dbt?

if I use custom dbt, can I generate new parameter of config dbt? i will try to

generate_schema_name

.yml in dbt macros.

Hi @Samsudin Samsudin, this is something you can achieve with custom transformation. We have a guide here on how to set this up.