sungchun12

{"lastUpload":"2019-07-08T21:42:32.794Z","extensionVersion":"v3.3.1"}

sungchun12

--Run this command in your terminal: dbt run-operation drop_dbt_cloud_pull_request_schemas
--Write this as a file in your dbt project directory: macros/drop_dbt_cloud_pull_request_schemas.sql
--Original Source: https://github.com/randypitcherii/hashmap_randy_pitcher_workspace/blob/master/dbt/macros/cleanup/drop_old_relations.sql
{% macro drop_dbt_cloud_pull_request_schemas() %}

  {% set cleanup_query %}

      -- CTE to query the snowflake information schema to get all the tables and views in scope for cleanup
      WITH 
      

sungchun12

{% macro clone_prod_to_target(from) %}

    {% set sql -%}
        create schema if not exists {{ target.database }}.{{ target.schema }} clone {{ from }};
    {%- endset %}

    {{ dbt_utils.log_info("Cloning schema " ~ from ~ " into target schema.") }}

    {% do run_query(sql) %}

sungchun12

-- force a dependency
-- depends_on: analytics.dbt_demo_account_sung.fct_orders


select * 
from -- Need this here, since the actual ref is nested within loops/conditions:
    -- depends on: analytics.dbt_demo_account_sung.dbt_metrics_default_calendar
    (with source_query as (

    select

sungchun12

/*
    Welcome to your first dbt model!
    Did you know that you can also configure models directly within SQL files?
    This will override configurations stated in dbt_project.yml
    Try changing "table" to "view" below
*/

sungchun12

{{
  config(
    materialized = "table_with_constraints"
  )
}}

select 
  1 as id, 
  'blue' as color, 
  cast('2019-01-01' as date) as date_day

sungchun12

from faker import Faker
import pandas as pd

fake = Faker()

def create_rows_faker(num=1):
    output = [{"name":fake.name(),
                   "address":fake.address(),
                   "name":fake.name(),
                   "email":fake.email(),

sungchun12

{% macro clone_from_to(from, to) %}

    {% set sql -%}
        create schema if not exists {{ target.database }}.{{ to }} clone {{ from }};
    {%- endset %}

    {{ dbt_utils.log_info("Cloning tables/views from schema [" ~ from ~ "] into target schema [" ~ to ~ "]") }}

    {% do run_query(sql) %}

sungchun12

version: 2

models:
  - name: constraints_example
    config:
      constraints_enabled: true
    columns:
      - name: id
        column_type: integer
        description: I want to describe this one, but I don't want to list all the columns

sungchun12

FROM quay.io/astronomer/astro-runtime:7.6.0

# Install python packages
RUN pip install -r requirements.txt

# Switch to root user for installing git
USER root

# Install git
RUN apt-get update && apt-get install -y git