Data Apps Design: “Continued: Also, pay attention to how a model is built with dbt_utils.…”

Data Apps Design @data_apps · 2.08K subscribers

Post #141 408 Dec 9, 2021, 13:11 UTC

Data Apps Design Let’s examine some integrations I currently use UNLOADing customer/partner/chauffeur labels to S3 bucket files Let’s say we want to exchange some data with other teams be it Backend, Financial Service, Frontend. You may also treat it as publishing data for…

Continued:

Also, pay attention to how a model is built with dbt_utils.unpivot macro:

{{ dbt_utils.unpivot(
  relation=ref('dim_chauffeurs_labels'),
  cast_to='varchar',
  exclude=['actual_dt', 'chauffeur_id'],
  field_name='label',
  value_name='value'
) }}

A list of attributes unloaded could be expanded or narrowed without actual code changes. Schema is ['actual_dt', 'chauffeur_id', 'label', 'value']

Open in Telegram All posts from @data_apps