dbt materialized config

gh_labels:
  bug:
    description: Bugfixes in codebase when something is not working.
    colour: 'd73a4a'
  feature:
    description: New enhancements and features.
    colour: '1B6659'
  documentation:
    description: Improvements or additions to docs.
    colour: '0075ca'
  release:
    description: Indicates a new release.
    colour: '108a51'
  config:
    description: Configuration and meta-infrastructural changes.
    colour: '8ed92e'
  refactor:
    description: Code refactoring.
    colour: 'D0EFCD'
  question:
    description: Further information requested.
    colour: 'd876e3'
  data:
    description: Issues pertaining to data or data preparations.
    colour: 'FAA631'
  tests:
    description: Issues related to tests.
    colour: 'e4e669'

name: Generate CHANGELOG.md
on:
  repository_dispatch:
  workflow_dispatch:
  push:
    branches:
      - main
      - master
jobs:
  changelog:
    name: Generate changelog
    runs-on: ubuntu-latest
    steps:
      - name: Checkout
        uses: actions/checkout@v2
        with:
          fetch-depth: 0
          token: ${{ secrets.GITHUB_TOKEN }}

      - name: Generate a changelog
        uses: orhun/git-cliff-action@v1
        id: git-cliff
        with:
          config: ./cliff.toml
          args: --verbose
        env:
          OUTPUT: ./CHANGELOG.md

      - name: Print the changelog
        run: cat "${{ steps.git-cliff.outputs.changelog }}"

      - name: Commit and Push Changes
        uses: actions-js/push@master
        with:
          github_token: ${{ secrets.GITHUB_TOKEN }}

{
  "binary": "/mnt/c/users/jimmy/appdata/local/Microsoft/WindowsApps/MicrosoftEdge.exe",
  "provider": "bing",
  "customProviders": [
    {
      "name": "gmail",
      "url": "https://inbox.google.com/search/%s",
      "tags": [
        "email",
        "google",
        "mycontent"
      ]
    },
    {
      "name": "gdrive",
      "url": "https://drive.google.com/drive/u/0/search?q=%s",
      "tags": [
        "mycontent",
        "cloud"
      ]
    },
    {
      "name": "edgesettings",
      "url": "edge://settings/?search=%s",
      "tags": [
        "microsoft",
        "edge",
        "settings",
        "config"
      ]
    },
    {
      "name": "edgehist",
      "url": "edge://history/all?q=%s",
      "tags": [
        "edge",
        "mycontent"
      ]
    },
    {
      "name": "msoft",
      "url": "https://docs.microsoft.com/en-us/search/?terms=%s",
      "tags": [
        "microsoft",
        "dev",
        "docs",
        "windows"
      ]
    },
    {
      "name": "gh",
      "url": "https://github.com/search?q=%s",
      "tags": [
        "github",
        "dev"
      ]
    },
    {
      "name": "ghr",
      "url": "https://github.com/search?q=%s+language:r",
      "tags": [
        "github",
        "r",
        "dev"
      ]
    },
    {
      "name": "ghpwsh",
      "url": "https://github.com/search?q=%s+language:powershell",
      "tags": [
        "github",
        "powershell",
        "dev",
        "windows"
      ]
    },
    {
      "name": "myrepos",
      "url": "https://github.com/search?q=%s+user:jimbrig",
      "tags": [
        "github",
        "dev",
        "mycontent"
      ]
    },
    {
      "name": "rseek",
      "url": "http://rseek.org/?q=%s",
      "tags": [
        "r",
        "dev"
      ]
    },
    {
      "name": "choco",
      "url": "https://community.chocolatey.org/packages?q=%s",
      "tags": [
        "windows",
        "config",
        "packages",
        "software",
        "dev"
      ]
    },
    {
      "name": "metacran",
      "url": "https://r-pkg.org/search.html?q=%s",
      "tags": [
        "r",
        "dev",
        "docs"
      ]
    },
    {
      "name": "psgallery",
      "url": "https://www.powershellgallery.com/packages?q=%s",
      "tags": [
        "windows",
        "software",
        "packages",
        "config",
        "dev"
      ]
    },
    {
      "name": "obsidian",
      "url": "https://forum.obsidian.md/search?q=%s",
      "tags": [
        "dev",
        "docs",
        "obsidian",
        "forum"
      ]
    },
    {
      "name": "devto",
      "url": "https://dev.to/search?q=%s",
      "tags": [
        "dev",
        "forum"
      ]
    },
    {
      "name": "devdocs",
      "url": "https://devdocs.io/#q=%s",
      "tags": [
        "dev",
        "docs"
      ]
    },
    {
      "name": "hashnode",
      "url": "https://hashnode.com/search?q=%s",
      "tags": [
        "dev",
        "forum"
      ]
    },
    {
      "name": "rsite",
      "url": "http://finzi.psych.upenn.edu/cgi-bin/namazu.cgi?query=%s&max=100&result=normal&sort=score&idxname=functions&idxname=views",
      "tags": [
        "r",
        "dev"
      ]
    },
    {
      "name": "rproj",
      "url": "https://www.google.com/search?q=%s&domains=r-project.org&sitesearch=r-project.org&btnG=Google+Search",
      "tags": [
        "r",
        "dev"
      ]
    },
    {
      "name": "rdrr",
      "url": "https://rdrr.io/search?q=%s",
      "tags": [
        "r",
        "docs"
      ]
    },
    {
      "name": "gistr",
      "url": "https://gist.github.com/search?q=%s+language:r&ref=searchresults",
      "tags": [
        "r",
        "github",
        "dev"
      ]
    },
    {
      "name": "fa",
      "url": "https://fontawesome.com/icons?d=gallery&q=%s",
      "tags": [
        "dev",
        "design"
      ]
    },
    {
      "name": "pypi",
      "url": "https://pypi.org/search/?q=%s",
      "tags": [
        "dev",
        "python"
      ]
    }
  ]
}

-- for table
{{
  config(
  	materialized="table" 
  )
}}

-- for view
{{
  config(
  	materialized="view" 
  )
}}

-- for ephemeral
{{
  config(
  	materialized="ephemeral"
  )
}}

-- for incremental
{{
  config(
  	materialized="incremental"
  )
}}

;MainWP Requriement - cURL timeout
default_socket_timeout = 300
;END MainWP Requriement

{{ 
	config(
    	materialized="incremental",
    	unique_key="page_view_id" 			-- This line is the key to replace duplicates
    )
}}

with events as (
  
	select * from {{ source('schema', 'table') }}
	{% if is_incremental() %}
    	where collector_tstamp >= ( select dateadd('day', -3, max(max_collector_tstamp)) from {{ 		this }}
    {% endif %}
    
)

dbt run		--Materialize models
dbt snapshot	--Run models in snapshot folder only
dbt deps	--Run and install dependencies
dbt run-operation required_tests	--Run tests defined in dbt_project.yml

{% snapshot mock_orders %}

{% set new_schema = target.schema + '_snapshot' %}

{{
    config(
        target_database='analytics',
        target_schema=new_schema,
        unique_key='order_id',

        strategy='timestamp',
        updated_at='updated_at'
    )
}}

select * from analytics.{{ target.schema }}.mock_orders

{% endsnapshot %}

version: 2

sources:
  - name: jaffle_shop
    description: a clone of a Postgres application database
    database: raw
    tables:
      - name: customers
        description: the raw customer data
        columns: 
          - name: id
            description: primary key of raw customer data
            tests: 
              - unique
              - not_null
      - name: orders
        description: the raw orders data
        columns: 
          - name: id
            description: primary key of raw orders data
            tests: 
              - unique
              - not_null
  

select
	<column>
from <table>
group by 1
having count(*) > 1

models:
  advanced_testing:
    # checks for every model under models directory should have unique and not_null test
    +required_tests: {"unique.*|not_null": 2}
    # checks for 'exclude' directory models should have unique and not_null test
    exclude:
      +required_tests: {"unique.*|not_null": 2}
	# checks for 'marts' directory models should have relationship test
    marts:
      +required_tests: {'relationship.*': 1}

{% macro generate_schema_name(custom_name, node) -%}

	{%- set default_schema = target.schema -%}
    {%- if custom_name is none -%}
    	
    	{{ default_schema }}
     
    {%- else -%}
    	
    	{{ default_schema }}_{{ custom_schema_name | trim }}
     
    {%- endif -%}

{%- endmacro -%}
    	

<div class="fixed-action-btn show-mobile-only">
  <a class="btn-floating btn-large light-green" title="Back to Top" onclick="scrolltoTop()" id="scrollBtn">
    <i class="material-icons">keyboard_arrow_up</i>
  </a>
</div>

<script>
  // When the user scrolls down 100px from the top of the document, show the button
  window.onscroll = function () { scrollFunction() };

  function scrollFunction() {
    if (document.body.scrollTop > 100 || document.documentElement.scrollTop > 100) {
      document.getElementById("scrollBtn").style.display = "inline-block";
    } else {
      document.getElementById("scrollBtn").style.display = "none";
    }
  }

  // When the user clicks on the button, scroll to the top of the document
  function scrolltoTop() {
    document.body.scrollTop = 0; // For Safari
    document.documentElement.scrollTop = 0; // For Chrome, Firefox, IE and Opera
  }
</script>