Hi How do I connect assets from Fivetran with DBT Both of th

Question

Hi How do I connect assets from Fivetran with DBT Both of them do not get loaded with asset The examples I see in the docs were not really clear for me I tried something like this <https medium com starschema blog dagster airbyte dbt how software defigned assets change the way we orchestrate ac70bb29d640|https medium com starschema blog dagster airbyte dbt how software defigned assets change the way we orchestrate ac70bb29d640> But the api for fivetran seems to work differently Can someone give me an example and explain it like I m 5 Do I have to connect each table one by one or is there an automatic way that finds the connection between each of the tables in Bigquery DBT and Fivetran

Benedikt Buchert · Answer

For my understanding the key prefix need to match for dbt and fivetran for that asset Is there a way I can change the key prefix coming from fivetran I only see an option to change the prefix I don t see an option to replace it I want to replace google ads 123 coming from the connector name to google ads

Benedikt Buchert · Answer

Screenshot 2023 01 25 at 01 26 13 png

Benedikt Buchert · Answer

Screenshot 2023 01 25 at 01 27 46 png

Benedikt Buchert · Answer

Found the solution ```def connector to asset key fn item name config = google ads 123 google ads linkedin 123 linkedin path = item name split path 0 = config path 0 return AssetKey path=path ``` Anf then ```fivetran assets = load assets from fivetran instance fivetran=fivetran instance key prefix= dbt source connector to asset key fn=connector to asset key fn ```

Nicolas May · Answer

If you only had one schema say `google ads` another approach might be something like this ```connectors to include = my conn fivetran assets = load assets from fivetran instance fivetran instance connector filter=lambda meta meta name in connectors to include connector to asset key fn=lambda table AssetKey path=table split 1 key prefix= dbt source google ads ```