{"repo":"fivetran/dbt_fivetran_utils","free":true,"listed":false,"github":"https://github.com/fivetran/dbt_fivetran_utils","clone":"git clone https://github.com/fivetran/dbt_fivetran_utils.git","description":"Helper utils for our packages","language":"Shell","stars":33,"topics":["dbt","fivetran","utils"],"license":null,"category":"data-pipelines","readme_excerpt":"Fivetran Utilities for dbt ## ⚠️ Warning! ⚠️ You are viewing a deprecated branch, which is no longer maintained and not recommended for use. This branch remains the default branch to prevent breaking changes to any existing dbt projects that use this package. To view the current release branch, please refer to the release list. This package includes macros that are used in Fivetran's dbt packages. Macros get utils namespaces (source) This macro allows for namespacing macros throughout a dbt project. The macro currently consists of two namespaces: - dbt utils - fivetran utils ---- add pass through columns (source) This macro creates the proper name, datatype, and aliasing for user defined pass through column variable. This macro allows for pass through variables to be more dynamic and allow users to alias custom fields they are bringing in. This macro is typically used within staging models of a fivetran dbt source package to pass through user defined custom fields. Usage: Args: base columns (required): The name of the variable where the base columns are contained. This is typically columns . pass through var (required): The variable which contains the user defined pass through fields. ---- array agg (source) This macro allows for cross database field aggregation. The macro contains the database specific field aggregation function for BigQuery, Snowflake, Redshift, and Postgres. By default a comma , is used as a delimiter in the aggregation. Usage: Args: field to agg (required","default_branch":null,"files":null,"tree":[],"storefront":"/r/fivetran","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/fivetran/dbt_fivetran_utils/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}