DBT
boolean_flag
/*
if upper(<value>) is 'Y' or 'YES' or 1:
return TRUE
else:
return FALSE
*/
{% macro boolean_flag(column_name) %}
case when upper({{ column_name }}) in ('Y','YES') or to_char({{ column_name }}) = '1' then TRUE else...
project_setup
{% macro project_setup() %}
{% set sql %}
CREATE TABLE IF NOT EXISTS {{ target.database }}."EDW_TRANSIENT"."POSITION_AUX" as (
select
NULL...
platform_logging
{% macro job_logging_insert_update(arg_status) %}
{% if arg_status == 'In Progress' %}
{% set sql %}
insert into {{ target.database }}.LOGGING.PLATFORM_LOGS
(
BATCH_RUN_ID
,BATCH_NAME
...
generate_schema_name
{% macro generate_schema_name(custom_schema_name, node) -%}
{%- set default_schema = target.schema -%}
{%- if custom_schema_name is none -%}
{{ default_schema }}
{%- else -%}
...
drop-seed-tables
{% macro drop_seed_table(dbname, tablename) %}
{% set sql -%}
use database "{{ dbname.upper() }}";
use schema "EDW_TRANSIENT";
drop table if exists "{{ tablename.upper() }}";
{%- endset %}
{{ dbt_utils.log_info("drop seed...
clone_prod_to_test
{% macro clone_prod_to_test(createordrop, dbname, testrole) %}
{% set testdb -%}
"{{ dbname.upper() }}"
{%- endset %}
{% if createordrop == 'create' %}
{% set sql -%}
create database if not exists...
batch_last_run_date
{% macro batch_last_run_date() %}
{% set sql %}
select max(job_start_time)::varchar as Last_Batch_Start_Time from {{ target.database }}.LOGGING.PLATFORM_LOGS
where batch_name='master_batch'
and...