FileMood

Download [ WebToolTip.com ] Udemy - dbt Core from Scratch - Build Your First Project in 2 Hours

WebToolTip com Udemy dbt Core from Scratch Build Your First Project in Hours

Name

[ WebToolTip.com ] Udemy - dbt Core from Scratch - Build Your First Project in 2 Hours

  DOWNLOAD Copy Link

Trouble downloading? see How To

Total Size

1.1 GB

Total Files

1433

Last Seen

2025-06-29 00:36

Hash

08C2CE9A87937E3A716C3B5351CBDAF1D5CE1C4D

/

Get Bonus Downloads Here.url

0.2 KB

/.../1 - Introduction to dbt Core/

1 -ELT vs ETL.mp4

13.5 MB

2 -What is dbt.mp4

10.9 MB

/.../2 - Configuration of dbt Core/

1 -Database setup.mp4

20.4 MB

1 -dbt_core.sql

1.6 KB

2 -Installation of dbt Core (Windows).mp4

24.9 MB

3 -Installation of dbt Core (Linux).mp4

39.3 MB

4 -dbt profiles.yaml setup.mp4

24.6 MB

/3 - Sources/

1 -Sources basics.mp4

40.7 MB

2 -Sources freshness.mp4

43.2 MB

3 -Tests.mp4

35.8 MB

4 -Custom tests.mp4

47.6 MB

/3 - Sources/project1/

README.md

0.6 KB

dbt_project.yml

1.3 KB

gitignore

0.0 KB

/3 - Sources/project1/analyses/

gitkeep

0.0 KB

/3 - Sources/project1/logs/

dbt.log

64.5 KB

/3 - Sources/project1/macros/

gitkeep

0.0 KB

/3 - Sources/project1/models/sources/

raw.yaml

1.5 KB

/3 - Sources/project1/models/staging/

stg_customers.sql

0.0 KB

/3 - Sources/project1/seeds/

gitkeep

0.0 KB

/3 - Sources/project1/snapshots/

gitkeep

0.0 KB

/3 - Sources/project1/target/compiled/project1/models/sources/raw.yaml/

source_is_even_raw_orders_total_amount.sql

0.3 KB

source_not_null_raw_orders_order_date.sql

0.1 KB

source_not_null_raw_orders_order_id.sql

0.1 KB

source_not_null_raw_orders_total_amount.sql

0.1 KB

source_positive_total_amount_raw_orders_total_amount.sql

0.1 KB

source_relationships_raw_order_20a3ab8fc27f8de59c11a94c3886f5ab.sql

0.4 KB

source_relationships_raw_order_d914e0a060128c231aa0a0ab369a6585.sql

0.4 KB

source_t1_raw_orders_total_amount.sql

0.1 KB

source_unique_raw_orders_order_id.sql

0.2 KB

/3 - Sources/project1/target/compiled/project1/models/staging/

stg_customers.sql

0.0 KB

/3 - Sources/project1/target/compiled/project1/tests/custom/

positive_total_amount.sql

0.2 KB

/3 - Sources/project1/target/

graph.gpickle

7.8 KB

graph_summary.json

0.8 KB

manifest.json

425.1 KB

partial_parse.msgpack

430.4 KB

run_results.json

5.3 KB

semantic_manifest.json

0.2 KB

sources.json

1.0 KB

/3 - Sources/project1/target/run/project1/models/sources/raw.yaml/

source_is_even_raw_orders_total_amount.sql

0.4 KB

source_not_null_raw_orders_order_date.sql

0.3 KB

source_not_null_raw_orders_order_id.sql

0.3 KB

source_not_null_raw_orders_total_amount.sql

0.3 KB

source_positive_total_amount_raw_orders_total_amount.sql

0.2 KB

source_relationships_raw_order_20a3ab8fc27f8de59c11a94c3886f5ab.sql

0.5 KB

source_relationships_raw_order_d914e0a060128c231aa0a0ab369a6585.sql

0.5 KB

source_t1_raw_orders_total_amount.sql

0.2 KB

source_unique_raw_orders_order_id.sql

0.4 KB

/3 - Sources/project1/target/run/project1/models/staging/

stg_customers.sql

0.1 KB

/3 - Sources/project1/target/run/project1/tests/custom/

positive_total_amount.sql

0.2 KB

/3 - Sources/project1/target/run/project1/tests/

positive_total_amount.sql

0.2 KB

t1.sql

0.2 KB

/3 - Sources/project1/tests/generic/

positive_total_amount.sql

0.1 KB

/3 - Sources/project1/tests/

gitkeep

0.0 KB

/4 - Models/

1 -Models basics.mp4

88.3 MB

2 -Models YAML.mp4

38.6 MB

3 -Models references.mp4

85.7 MB

4 -Models targets.mp4

119.4 MB

5 -Models materialization.mp4

41.6 MB

6 -Incrematal models.mp4

92.1 MB

/4 - Models/project1/

README.md

0.6 KB

dbt_project.yml

1.4 KB

gitignore

0.0 KB

/4 - Models/project1/analyses/

gitkeep

0.0 KB

/4 - Models/project1/logs/

dbt.log

3.2 MB

/4 - Models/project1/macros/

generate_schema_name.sql

0.2 KB

gitkeep

0.0 KB

/4 - Models/project1/models/intermediate/

int_customer_orders.sql

0.7 KB

/4 - Models/project1/models/intermidate/

int_customer_orders.sql

0.5 KB

/4 - Models/project1/models/marts/sales/

customer_orders.sql

0.4 KB

/4 - Models/project1/models/sources/

raw.yaml

1.9 KB

/4 - Models/project1/models/staging/

stg_customers.sql

0.2 KB

stg_orders.sql

0.2 KB

/4 - Models/project1/models/staging/stg_customers/

stg_customers.sql

0.2 KB

stg_customers.yaml

0.7 KB

/4 - Models/project1/models/staging/stg_orders/

stg_orders.sql

0.2 KB

stg_orders.yaml

0.7 KB

/4 - Models/project1/seeds/

gitkeep

0.0 KB

/4 - Models/project1/snapshots/

gitkeep

0.0 KB

/4 - Models/project1/target/

catalog.json

4.7 KB

graph.gpickle

30.7 KB

graph_summary.json

3.1 KB

index.html

1.5 MB

manifest.json

476.4 KB

partial_parse.msgpack

470.8 KB

run_results.json

5.4 KB

semantic_manifest.json

0.2 KB

sources.json

1.0 KB

/4 - Models/project1/target/compiled/project1/models/intermediate/

int_customer_orders.sql

0.6 KB

/4 - Models/project1/target/compiled/project1/models/intermidate/

int_customer_orders.sql

0.6 KB

/4 - Models/project1/target/compiled/project1/models/marts/sales/

customer_orders.sql

0.4 KB

/4 - Models/project1/target/compiled/project1/models/sources/raw.yaml/

source_not_null_raw_customers_customer_id.sql

0.1 KB

source_not_null_raw_customers_email.sql

0.1 KB

source_not_null_raw_customers_first_name.sql

0.1 KB

source_not_null_raw_customers_last_name.sql

0.1 KB

source_not_null_raw_customers_loaded_at.sql

0.1 KB

source_not_null_raw_orders_customer_id.sql

0.1 KB

source_not_null_raw_orders_loaded_at.sql

0.1 KB

source_not_null_raw_orders_order_date.sql

0.1 KB

source_not_null_raw_orders_order_id.sql

0.1 KB

source_not_null_raw_orders_total_amount.sql

0.1 KB

source_positive_total_amount_raw_orders_total_amount.sql

0.1 KB

source_unique_raw_customers_customer_id.sql

0.2 KB

source_unique_raw_customers_email.sql

0.2 KB

source_unique_raw_orders_order_id.sql

0.2 KB

/4 - Models/project1/target/compiled/project1/models/staging/

stg_customers.sql

0.2 KB

stg_orders.sql

0.2 KB

/4 - Models/project1/target/compiled/project1/models/staging/stg_customers/

stg_customers.sql

0.2 KB

/.../stg_customers.yaml/

not_null_stg_customers_customer_id.sql

0.1 KB

not_null_stg_customers_email.sql

0.1 KB

not_null_stg_customers_first_name.sql

0.1 KB

not_null_stg_customers_last_name.sql

0.1 KB

unique_stg_customers_customer_id.sql

0.2 KB

unique_stg_customers_email.sql

0.2 KB

/.../stg_orders.yaml/

not_null_stg_orders_customer_id.sql

0.1 KB

not_null_stg_orders_order_date.sql

0.1 KB

not_null_stg_orders_order_id.sql

0.1 KB

not_null_stg_orders_total_amount.sql

0.1 KB

positive_total_amount_stg_orders_total_amount.sql

0.1 KB

unique_stg_orders_order_id.sql

0.2 KB

/4 - Models/project1/target/compiled/project1/models/staging/stg_orders/

stg_orders.sql

0.2 KB

/.../stg_orders.yaml/

not_null_stg_orders_customer_id.sql

0.1 KB

not_null_stg_orders_order_date.sql

0.1 KB

not_null_stg_orders_order_id.sql

0.1 KB

not_null_stg_orders_total_amount.sql

0.1 KB

positive_total_amount_stg_orders_total_amount.sql

0.1 KB

unique_stg_orders_order_id.sql

0.2 KB

/4 - Models/project1/target/run/project1/models/intermediate/

int_customer_orders.sql

0.6 KB

/4 - Models/project1/target/run/project1/models/intermidate/

int_customer_orders.sql

0.7 KB

/4 - Models/project1/target/run/project1/models/marts/sales/

customer_orders.sql

0.5 KB

/4 - Models/project1/target/run/project1/models/sources/raw.yaml/

source_not_null_raw_customers_customer_id.sql

0.3 KB

source_not_null_raw_customers_email.sql

0.3 KB

source_not_null_raw_customers_first_name.sql

0.3 KB

source_not_null_raw_customers_last_name.sql

0.3 KB

source_not_null_raw_customers_loaded_at.sql

0.3 KB

source_not_null_raw_orders_customer_id.sql

0.3 KB

source_not_null_raw_orders_loaded_at.sql

0.3 KB

source_not_null_raw_orders_order_date.sql

0.3 KB

source_not_null_raw_orders_order_id.sql

0.3 KB

source_not_null_raw_orders_total_amount.sql

0.3 KB

source_positive_total_amount_raw_orders_total_amount.sql

0.2 KB

source_unique_raw_customers_customer_id.sql

0.4 KB

source_unique_raw_customers_email.sql

0.3 KB

source_unique_raw_orders_order_id.sql

0.4 KB

/4 - Models/project1/target/run/project1/models/staging/

stg_customers.sql

0.3 KB

stg_orders.sql

0.3 KB

/4 - Models/project1/target/run/project1/models/staging/stg_customers/

stg_customers.sql

0.3 KB

/.../stg_customers.yaml/

not_null_stg_customers_customer_id.sql

0.3 KB

not_null_stg_customers_email.sql

0.3 KB

not_null_stg_customers_first_name.sql

0.3 KB

not_null_stg_customers_last_name.sql

0.3 KB

unique_stg_customers_customer_id.sql

0.4 KB

unique_stg_customers_email.sql

0.4 KB

/.../stg_orders.yaml/

not_null_stg_orders_customer_id.sql

0.3 KB

not_null_stg_orders_order_date.sql

0.3 KB

not_null_stg_orders_order_id.sql

0.3 KB

not_null_stg_orders_total_amount.sql

0.3 KB

positive_total_amount_stg_orders_total_amount.sql

0.2 KB

unique_stg_orders_order_id.sql

0.4 KB

/4 - Models/project1/target/run/project1/models/staging/stg_orders/

stg_orders.sql

0.3 KB

/.../stg_orders.yaml/

not_null_stg_orders_customer_id.sql

0.3 KB

not_null_stg_orders_order_date.sql

0.3 KB

not_null_stg_orders_order_id.sql

0.3 KB

not_null_stg_orders_total_amount.sql

0.3 KB

positive_total_amount_stg_orders_total_amount.sql

0.2 KB

unique_stg_orders_order_id.sql

0.4 KB

/4 - Models/project1/tests/generic/

positive_total_amount.sql

0.1 KB

/4 - Models/project1/tests/

gitkeep

0.0 KB

/4 - Models/project1/vscode/

settings.json

0.0 KB

/5 - Macros/

1 -Macros basics.mp4

69.5 MB

2 -Macros inside file.mp4

86.3 MB

2 -dbt Compilation Error ‘None’ has no attribute ‘table’.url

0.1 KB

3 -Macros dbt deps.mp4

41.1 MB

/5 - Macros/project1/

README.md

0.6 KB

dbt_project.yml

1.4 KB

gitignore

0.0 KB

package-lock.yml

0.3 KB

packages.yml

0.2 KB

/5 - Macros/project1/analyses/

gitkeep

0.0 KB

/5 - Macros/project1/dbt_packages/codegen/

CHANGELOG.md

14.2 KB

CONTRIBUTING.md

6.2 KB

LICENSE

11.4 KB

Makefile

0.8 KB

README.md

13.0 KB

RELEASE.md

1.0 KB

dbt_project.yml

0.2 KB

docker-compose.yml

0.1 KB

gitignore

0.1 KB

packages.yml

0.1 KB

run_test.sh

0.3 KB

supported_adapters.env

0.1 KB

tox.ini

2.8 KB

/5 - Macros/project1/dbt_packages/codegen/bash_scripts/

base_model_creation.sh

0.2 KB

/5 - Macros/project1/dbt_packages/codegen/circleci/

config.yml

4.9 KB

/5 - Macros/project1/dbt_packages/codegen/github/

CODEOWNERS

0.0 KB

pull_request_template.md

0.7 KB

/5 - Macros/project1/dbt_packages/codegen/github/ISSUE_TEMPLATE/

bug_report.md

1.4 KB

feature_request.md

0.8 KB

/5 - Macros/project1/dbt_packages/codegen/github/workflows/

ci.yml

1.8 KB

stale.yml

0.8 KB

triage-labels.yml

0.9 KB

/5 - Macros/project1/dbt_packages/codegen/integration_tests/

README.md

9.6 KB

dbt_project.yml

0.6 KB

package-lock.yml

0.1 KB

packages.yml

0.0 KB

profiles.yml

1.7 KB

/5 - Macros/project1/dbt_packages/codegen/integration_tests/env/

bigquery.env

0.1 KB

postgres.env

0.2 KB

redshift.env

0.1 KB

snowflake.env

0.1 KB

/5 - Macros/project1/dbt_packages/codegen/integration_tests/macros/

assert_equal.sql

0.5 KB

integer_type_value.sql

0.2 KB

text_type_value.sql

0.2 KB

/5 - Macros/project1/dbt_packages/codegen/integration_tests/macros/operations/

create_source_table.sql

1.2 KB

/5 - Macros/project1/dbt_packages/codegen/integration_tests/models/

child_model.sql

0.0 KB

model_data_a.sql

0.1 KB

model_from_source.sql

0.1 KB

model_struct.sql

0.5 KB

model_without_any_ctes.sql

0.2 KB

model_without_import_ctes.sql

1.5 KB

schema.yml

0.1 KB

source.yml

0.4 KB

/5 - Macros/project1/dbt_packages/codegen/integration_tests/seeds/

data__Case_Sensitive.csv

0.0 KB

data__a_relation.csv

0.0 KB

data__b_relation.csv

0.0 KB

data__campaign_analytics.csv

0.1 KB

/5 - Macros/project1/dbt_packages/codegen/integration_tests/tests/

test_generate_base_models.sql

0.6 KB

test_generate_base_models_all_args.sql

0.8 KB

test_generate_base_models_case_sensitive.sql

0.7 KB

test_generate_base_models_leading.sql

0.6 KB

test_generate_model_import_ctes.sql

3.7 KB

test_generate_model_import_ctes_leading.sql

3.7 KB

test_generate_model_import_ctes_no_ctes.sql

0.6 KB

test_generate_model_struct_yaml.sql

1.4 KB

test_generate_model_yaml.sql

0.5 KB

test_generate_model_yaml_multiple_models.sql

0.6 KB

test_generate_model_yaml_upstream_descriptions.sql

0.5 KB

test_generate_model_yaml_upstream_source_descriptions.sql

0.5 KB

test_generate_source.sql

0.4 KB

test_generate_source_all_args.sql

2.0 KB

test_generate_source_case_sensitive.sql

1.0 KB

test_generate_source_exclude.sql

0.5 KB

test_generate_source_include_database_property.sql

0.5 KB

test_generate_source_include_schema_property.sql

0.5 KB

test_generate_source_some_tables.sql

0.7 KB

test_generate_source_table_descriptions.sql

0.6 KB

test_generate_source_table_name.sql

0.5 KB

test_generate_source_table_pattern.sql

0.4 KB

test_helper_get_models.sql

0.5 KB

/5 - Macros/project1/dbt_packages/codegen/macros/

create_base_models.sql

0.7 KB

generate_base_model.sql

1.5 KB

generate_model_import_ctes.sql

14.5 KB

generate_model_yaml.sql

2.8 KB

generate_source.sql

3.6 KB

/5 - Macros/project1/dbt_packages/codegen/macros/helpers/

helpers.sql

3.6 KB

/5 - Macros/project1/dbt_packages/codegen/macros/vendored/dbt_core/

format_column.sql

0.2 KB

/5 - Macros/project1/dbt_packages/dbt_date/

CHANGELOG.md

5.2 KB

LICENSE

11.4 KB

README.md

20.8 KB

dbt_project.yml

0.3 KB

gitignore

0.1 KB

packages.yml

0.0 KB

/5 - Macros/project1/dbt_packages/dbt_date/circleci/

config.yml

5.3 KB

/5 - Macros/project1/dbt_packages/dbt_date/github/

FUNDING.yml

0.1 KB

/5 - Macros/project1/dbt_packages/dbt_date/github/ISSUE_TEMPLATE/

bug_report.md

0.7 KB

/5 - Macros/project1/dbt_packages/dbt_date/integration_tests/ci/

profiles.yml

1.6 KB

/5 - Macros/project1/dbt_packages/dbt_date/integration_tests/

dbt_project.yml

0.7 KB

docker-compose.yml

0.8 KB

docker-start.sh

0.0 KB

docker-stop.sh

0.1 KB

packages.yml

0.0 KB

test.sh

0.2 KB

/5 - Macros/project1/dbt_packages/dbt_date/integration_tests/docker/

hive-site.xml

1.6 KB

spark-defaults.conf

0.4 KB

/5 - Macros/project1/dbt_packages/dbt_date/integration_tests/docker/trino/catalog/

memory.properties

0.1 KB

/5 - Macros/project1/dbt_packages/dbt_date/integration_tests/macros/

expression_is_true.sql

0.7 KB

get_custom_schema.sql

0.3 KB

get_test_dates.sql

6.8 KB

/5 - Macros/project1/dbt_packages/dbt_date/integration_tests/models/

dates.sql

0.1 KB

dim_date.sql

0.5 KB

dim_date_fiscal.sql

0.2 KB

dim_hour.sql

0.2 KB

dim_week.sql

0.2 KB

test_dates.sql

0.1 KB

test_dates.yml

4.2 KB

/5 - Macros/project1/dbt_packages/dbt_date/macros/_utils/

date_spine.sql

1.6 KB

generate_series.sql

1.2 KB

modules_datetime.sql

0.5 KB

/5 - Macros/project1/dbt_packages/dbt_date/macros/calendar_date/

convert_timezone.sql

1.7 KB

date_part.sql

0.5 KB

day_name.sql

1.6 KB

day_of_month.sql

0.2 KB

day_of_week.sql

2.7 KB

day_of_year.sql

0.6 KB

from_unixtimestamp.sql

3.0 KB

iso_week_end.sql

0.5 KB

iso_week_of_year.sql

1.1 KB

iso_week_start.sql

0.9 KB

last_month.sql

0.1 KB

last_month_name.sql

0.1 KB

last_month_number.sql

0.1 KB

last_week.sql

0.1 KB

month_name.sql

1.2 KB

n_days_ago.sql

0.2 KB

n_days_away.sql

0.1 KB

n_months_ago.sql

0.2 KB

n_months_away.sql

0.2 KB

n_weeks_ago.sql

0.2 KB

n_weeks_away.sql

0.2 KB

next_month.sql

0.1 KB

next_month_name.sql

0.1 KB

next_month_number.sql

0.1 KB

next_week.sql

0.1 KB

now.sql

0.1 KB

periods_since.sql

0.1 KB

round_timestamp.sql

0.1 KB

to_unixtimestamp.sql

0.7 KB

today.sql

0.1 KB

tomorrow.sql

0.1 KB

week_end.sql

0.6 KB

week_of_year.sql

0.7 KB

week_start.sql

0.9 KB

yesterday.sql

0.1 KB

/5 - Macros/project1/dbt_packages/dbt_date/macros/fiscal_date/

get_fiscal_periods.sql

2.0 KB

get_fiscal_year_dates.sql

3.0 KB

/5 - Macros/project1/dbt_packages/dbt_date/macros/

get_base_dates.sql

2.4 KB

get_date_dimension.sql

6.9 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/

CHANGELOG.md

15.0 KB

LICENSE

11.4 KB

README.md

48.7 KB

dbt_project.yml

0.4 KB

editorconfig

0.2 KB

gitignore

0.1 KB

packages.yml

0.1 KB

regen_docs.sh

0.3 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/circleci/

config.yml

5.4 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/data/

gitkeep

0.0 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/docs/

catalog.json

10.5 KB

index.html

1.5 MB

manifest.json

1.2 MB

run_results.json

76.5 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/github/

FUNDING.yml

0.1 KB

pull_request_template.md

0.4 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/github/ISSUE_TEMPLATE/

bug_report.md

0.7 KB

feature_request.md

0.6 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/integration_tests/ci/

profiles.yml

1.7 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/integration_tests/

dbt_project.yml

0.9 KB

docker-compose.yml

0.8 KB

docker-start.sh

0.0 KB

docker-stop.sh

0.1 KB

packages.yml

0.0 KB

sqlfluff

0.6 KB

sqlfluffignore

0.0 KB

test.sh

0.2 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/integration_tests/docker/

hive-site.xml

1.6 KB

spark-defaults.conf

0.5 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/integration_tests/macros/

get_custom_schema.sql

0.3 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/integration_tests/models/schema_tests/

data_test.sql

1.4 KB

data_test_factored.sql

0.1 KB

data_text.sql

0.5 KB

schema.yml

29.0 KB

series_10.sql

0.0 KB

series_4.sql

0.0 KB

timeseries_base.sql

0.1 KB

timeseries_data.sql

0.6 KB

timeseries_data_extended.sql

0.6 KB

timeseries_data_grouped.sql

0.8 KB

timeseries_hourly.sql

0.3 KB

timeseries_hourly_data_extended.sql

0.6 KB

window_function_test.sql

0.9 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/macros/

gitkeep

0.0 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/macros/math/

log_natural.sql

0.4 KB

median.sql

0.1 KB

percentile_cont.sql

0.8 KB

rand.sql

0.5 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/macros/regex/

regexp_instr.sql

5.1 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/macros/schema_tests/_generalized/

_ignore_row_if_expression.sql

0.8 KB

_truth_expression.sql

0.2 KB

equal_expression.sql

4.1 KB

expression_between.sql

1.7 KB

expression_is_true.sql

1.7 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/macros/schema_tests/aggregate_functions/

expect_column_distinct_count_to_be_greater_than.sql

0.8 KB

expect_column_distinct_count_to_be_less_than.sql

0.8 KB

expect_column_distinct_count_to_equal.sql

0.7 KB

expect_column_distinct_count_to_equal_other_table.sql

1.0 KB

expect_column_distinct_values_to_be_in_set.sql

1.2 KB

expect_column_distinct_values_to_contain_set.sql

1.2 KB

expect_column_distinct_values_to_equal_set.sql

1.2 KB

expect_column_max_to_be_between.sql

1.0 KB

expect_column_mean_to_be_between.sql

1.0 KB

expect_column_median_to_be_between.sql

1.0 KB

expect_column_min_to_be_between.sql

1.0 KB

expect_column_most_common_value_to_be_in_set.sql

2.9 KB

expect_column_proportion_of_unique_values_to_be_between.sql

1.1 KB

expect_column_quantile_values_to_be_between.sql

1.2 KB

expect_column_stdev_to_be_between.sql

2.1 KB

expect_column_sum_to_be_between.sql

1.0 KB

expect_column_unique_value_count_to_be_between.sql

1.1 KB

/.../column_values_basic/

expect_column_values_to_be_between.sql

0.9 KB

expect_column_values_to_be_decreasing.sql

1.6 KB

expect_column_values_to_be_in_set.sql

1.1 KB

expect_column_values_to_be_in_type_list.sql

1.0 KB

expect_column_values_to_be_increasing.sql

1.7 KB

expect_column_values_to_be_null.sql

0.5 KB

expect_column_values_to_be_of_type.sql

0.2 KB

expect_column_values_to_be_unique.sql

0.2 KB

expect_column_values_to_have_consistent_casing.sql

0.9 KB

expect_column_values_to_not_be_in_set.sql

1.0 KB

expect_column_values_to_not_be_null.sql

0.5 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/macros/schema_tests/distributional/

expect_column_values_to_be_within_n_moving_stdevs.sql

5.3 KB

expect_column_values_to_be_within_n_stdevs.sql

1.5 KB

expect_row_values_to_have_data_for_every_n_datepart.sql

5.2 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/macros/schema_tests/multi-column/

expect_column_pair_values_A_to_be_greater_than_B.sql

0.9 KB

expect_column_pair_values_to_be_equal.sql

0.8 KB

expect_column_pair_values_to_be_in_set.sql

1.2 KB

expect_compound_columns_to_be_unique.sql

1.7 KB

expect_multicolumn_sum_to_equal.sql

1.0 KB

expect_select_column_values_to_be_unique_within_record.sql

2.5 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/macros/schema_tests/string_matching/

_get_like_pattern_expression.sql

0.2 KB

expect_column_value_lengths_to_be_between.sql

1.0 KB

expect_column_value_lengths_to_equal.sql

0.7 KB

expect_column_values_to_match_like_pattern.sql

0.7 KB

expect_column_values_to_match_like_pattern_list.sql

1.0 KB

expect_column_values_to_match_regex.sql

0.8 KB

expect_column_values_to_match_regex_list.sql

1.1 KB

expect_column_values_to_not_match_like_pattern.sql

0.7 KB

expect_column_values_to_not_match_like_pattern_list.sql

1.0 KB

expect_column_values_to_not_match_regex.sql

0.8 KB

expect_column_values_to_not_match_regex_list.sql

1.1 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/macros/schema_tests/table_shape/

_get_column_list.sql

0.3 KB

_list_intersect.sql

0.3 KB

expect_column_to_exist.sql

1.1 KB

expect_grouped_row_values_to_have_recent_data.sql

3.4 KB

expect_row_values_to_have_recent_data.sql

1.8 KB

expect_table_aggregation_to_equal_other_table.sql

1.1 KB

expect_table_column_count_to_be_between.sql

1.0 KB

expect_table_column_count_to_equal.sql

0.4 KB

expect_table_column_count_to_equal_other_table.sql

0.5 KB

expect_table_columns_to_contain_set.sql

1.1 KB

expect_table_columns_to_match_ordered_list.sql

1.4 KB

expect_table_columns_to_match_set.sql

1.2 KB

expect_table_columns_to_not_contain_set.sql

1.1 KB

expect_table_row_count_to_be_between.sql

1.6 KB

expect_table_row_count_to_equal.sql

1.1 KB

expect_table_row_count_to_equal_other_table.sql

1.9 KB

expect_table_row_count_to_equal_other_table_times_factor.sql

2.2 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/macros/utils/

datatypes.sql

1.2 KB

groupby.sql

0.3 KB

md5.sql

0.3 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/static/

dbt-expectations-logo.png

1.6 KB

dbt-expectations-logo.svg

8.0 KB

expectations.gif

3.2 MB

gitkeep

0.0 KB

/5 - Macros/project1/dbt_packages/dbt_expectations/tests/

gitkeep

0.0 KB

/5 - Macros/project1/dbt_packages/dbt_utils/

CHANGELOG.md

39.3 KB

CONTRIBUTING.md

7.3 KB

LICENSE

11.3 KB

Makefile

0.7 KB

README.md

50.5 KB

RELEASE.md

1.6 KB

dbt_project.yml

0.2 KB

dev-requirements.txt

0.5 KB

docker-compose.yml

0.1 KB

gitignore

0.3 KB

pytest.ini

0.2 KB

run_functional_test.sh

0.1 KB

run_test.sh

0.4 KB

supported_adapters.env

0.1 KB

tox.ini

2.2 KB

/5 - Macros/project1/dbt_packages/dbt_utils/circleci/

config.yml

3.7 KB

/5 - Macros/project1/dbt_packages/dbt_utils/docs/decisions/

README.md

0.6 KB

adr-0000-documenting-architecture-decisions.md

5.5 KB

adr-0001-decision-record-format.md

2.5 KB

adr-0002-cross-database-utils.md

6.9 KB

/5 - Macros/project1/dbt_packages/dbt_utils/github/

CODEOWNERS

0.0 KB

pull_request_template.md

0.9 KB

/5 - Macros/project1/dbt_packages/dbt_utils/github/ISSUE_TEMPLATE/

bug_report.md

1.4 KB

dbt_minor_release.md

1.2 KB

feature_request.md

0.8 KB

utils_minor_release.md

2.0 KB

/5 - Macros/project1/dbt_packages/dbt_utils/github/workflows/

ci.yml

5.8 KB

create-table-of-contents.yml

0.8 KB

stale.yml

0.8 KB

triage-labels.yml

0.9 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/

README.md

4.1 KB

dbt_project.yml

1.9 KB

gitignore

0.1 KB

package-lock.yml

0.1 KB

packages.yml

0.0 KB

profiles.yml

1.7 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/data/datetime/

data_date_spine.csv

0.1 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/data/etc/

data_people.csv

8.1 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/data/geo/

data_haversine_km.csv

0.1 KB

data_haversine_mi.csv

0.1 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/data/

gitkeep

0.0 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/data/schema_tests/

data_cardinality_equality_a.csv

0.0 KB

data_cardinality_equality_b.csv

0.0 KB

data_not_null_proportion.csv

0.1 KB

data_test_accepted_range.csv

0.0 KB

data_test_at_least_one.csv

0.0 KB

data_test_equal_rowcount.csv

0.0 KB

data_test_equality_a.csv

0.0 KB

data_test_equality_b.csv

0.0 KB

data_test_equality_floats_a.csv

0.5 KB

data_test_equality_floats_b.csv

0.5 KB

data_test_equality_floats_columns_a.csv

0.5 KB

data_test_equality_floats_columns_b.csv

0.5 KB

data_test_expression_is_true.csv

0.0 KB

data_test_fewer_rows_than_table_1.csv

0.0 KB

data_test_fewer_rows_than_table_2.csv

0.0 KB

data_test_mutually_exclusive_ranges_no_gaps.csv

0.0 KB

data_test_mutually_exclusive_ranges_with_gaps.csv

0.1 KB

data_test_mutually_exclusive_ranges_with_gaps_zero_length.csv

0.2 KB

data_test_not_accepted_values.csv

0.0 KB

data_test_not_constant.csv

0.0 KB

data_test_relationships_where_table_1.csv

0.0 KB

data_test_relationships_where_table_2.csv

0.0 KB

data_test_sequential_timestamps.csv

0.1 KB

data_test_sequential_values.csv

0.0 KB

data_unique_combination_of_columns.csv

0.2 KB

schema.yml

0.5 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/data/sql/

data_deduplicate.csv

0.1 KB

data_deduplicate_expected.csv

0.0 KB

data_events_20180101.csv

0.0 KB

data_events_20180102.csv

0.0 KB

data_events_20180103.csv

0.0 KB

data_filtered_columns_in_relation.csv

0.0 KB

data_filtered_columns_in_relation_expected.csv

0.0 KB

data_generate_series.csv

0.0 KB

data_generate_surrogate_key.csv

0.4 KB

data_get_column_values.csv

0.0 KB

data_get_column_values_dropped.csv

0.0 KB

data_get_column_values_where.csv

0.1 KB

data_get_column_values_where_expected.csv

0.0 KB

data_get_query_results_as_dict.csv

0.0 KB

data_get_single_value.csv

0.1 KB

data_nullcheck_table.csv

0.0 KB

data_pivot.csv

0.0 KB

data_pivot_expected.csv

0.0 KB

data_pivot_expected_apostrophe.csv

0.0 KB

data_safe_add.csv

0.1 KB

data_safe_divide.csv

0.1 KB

data_safe_divide_denominator_expressions.csv

0.1 KB

data_safe_divide_numerator_expressions.csv

0.1 KB

data_safe_subtract.csv

0.1 KB

data_star.csv

0.0 KB

data_star_aggregate.csv

0.1 KB

data_star_aggregate_expected.csv

0.1 KB

data_star_expected.csv

0.0 KB

data_star_prefix_suffix_expected.csv

0.1 KB

data_star_quote_identifiers.csv

0.0 KB

data_union_events_expected.csv

0.1 KB

data_union_exclude_expected.csv

0.1 KB

data_union_expected.csv

0.1 KB

data_union_table_1.csv

0.1 KB

data_union_table_2.csv

0.1 KB

data_unpivot.csv

0.2 KB

data_unpivot_bool.csv

0.1 KB

data_unpivot_bool_expected.csv

0.3 KB

data_unpivot_expected.csv

0.2 KB

data_unpivot_original_api_expected.csv

0.3 KB

data_unpivot_quote.csv

0.2 KB

data_unpivot_quote_expected.csv

0.2 KB

data_width_bucket.csv

0.4 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/data/web/

data_url_host.csv

0.4 KB

data_url_path.csv

0.5 KB

data_urls.csv

0.2 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/env/

bigquery.env

0.1 KB

postgres.env

0.2 KB

redshift.env

0.1 KB

snowflake.env

0.2 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/macros/

assert_equal_values.sql

0.5 KB

gitkeep

0.0 KB

limit_zero.sql

0.2 KB

tests.sql

0.2 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/models/datetime/

schema.yml

0.1 KB

test_date_spine.sql

0.8 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/models/generic_tests/

equality_less_columns.sql

0.1 KB

recency_time_excluded.sql

0.2 KB

recency_time_included.sql

0.1 KB

schema.yml

7.7 KB

test_equal_column_subset.sql

0.1 KB

test_equal_rowcount.sql

0.1 KB

test_fewer_rows_than.sql

0.1 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/models/geo/

schema.yml

0.3 KB

test_haversine_distance_km.sql

0.5 KB

test_haversine_distance_mi.sql

0.9 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/models/sql/

schema.yml

6.7 KB

test_deduplicate.sql

0.3 KB

test_generate_series.sql

0.4 KB

test_generate_surrogate_key.sql

0.3 KB

test_get_column_values.sql

0.7 KB

test_get_column_values_where.sql

0.3 KB

test_get_filtered_columns_in_relation.sql

0.4 KB

test_get_relations_by_pattern.sql

0.4 KB

test_get_relations_by_prefix_and_union.sql

0.3 KB

test_get_single_value.sql

1.3 KB

test_get_single_value_default.sql

1.1 KB

test_groupby.sql

0.3 KB

test_not_empty_string_failing.sql

0.7 KB

test_not_empty_string_passing.sql

0.8 KB

test_nullcheck_table.sql

0.6 KB

test_pivot.sql

0.4 KB

test_pivot_apostrophe.sql

0.4 KB

test_safe_add.sql

0.2 KB

test_safe_divide.sql

0.8 KB

test_safe_subtract.sql

0.2 KB

test_star.sql

0.2 KB

test_star_aggregate.sql

0.4 KB

test_star_no_columns.sql

0.3 KB

test_star_prefix_suffix.sql

0.3 KB

test_star_quote_identifiers.sql

0.4 KB

test_star_uppercase.sql

0.2 KB

test_union.sql

0.1 KB

test_union_base.sql

0.1 KB

test_union_exclude_base_lowercase.sql

0.2 KB

test_union_exclude_base_uppercase.sql

0.2 KB

test_union_exclude_lowercase.sql

0.2 KB

test_union_exclude_uppercase.sql

0.2 KB

test_union_no_source_column.sql

0.1 KB

test_union_where.sql

0.1 KB

test_union_where_base.sql

0.1 KB

test_unpivot.sql

0.8 KB

test_unpivot_bool.sql

0.8 KB

test_unpivot_quote.sql

0.3 KB

test_width_bucket.sql

0.2 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/models/web/

schema.yml

0.4 KB

test_url_host.sql

0.2 KB

test_url_path.sql

0.2 KB

test_urls.sql

0.3 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/tests/

assert_get_query_results_as_dict_objects_equal.sql

2.5 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/tests/generic/

expect_table_columns_to_match_set.sql

1.9 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/tests/jinja_helpers/

assert_pretty_output_msg_is_string.sql

0.2 KB

assert_pretty_time_is_string.sql

0.2 KB

test_slugify.sql

0.4 KB

/5 - Macros/project1/dbt_packages/dbt_utils/integration_tests/tests/sql/

test_get_column_values_use_default.sql

1.0 KB

test_get_single_value_multiple_rows.sql

0.5 KB

/5 - Macros/project1/dbt_packages/dbt_utils/macros/generic_tests/

accepted_range.sql

1.1 KB

at_least_one.sql

1.3 KB

cardinality_equality.sql

0.9 KB

equal_rowcount.sql

2.1 KB

equality.sql

6.1 KB

expression_is_true.sql

0.5 KB

fewer_rows_than.sql

2.4 KB

mutually_exclusive_ranges.sql

3.6 KB

not_accepted_values.sql

0.8 KB

not_constant.sql

0.8 KB

not_empty_string.sql

0.7 KB

not_null_proportion.sql

1.1 KB

recency.sql

1.2 KB

relationships_where.sql

1.0 KB

sequential_values.sql

1.3 KB

unique_combination_of_columns.sql

1.1 KB

/5 - Macros/project1/dbt_packages/dbt_utils/macros/jinja_helpers/

_is_ephemeral.sql

0.7 KB

_is_relation.sql

0.3 KB

log_info.sql

0.2 KB

pretty_log_format.sql

0.3 KB

pretty_time.sql

0.3 KB

slugify.sql

0.5 KB

/5 - Macros/project1/dbt_packages/dbt_utils/macros/sql/

date_spine.sql

1.6 KB

deduplicate.sql

3.0 KB

generate_series.sql

1.2 KB

generate_surrogate_key.sql

0.8 KB

get_column_values.sql

2.3 KB

get_filtered_columns_in_relation.sql

1.0 KB

get_query_results_as_dict.sql

0.8 KB

get_relations_by_pattern.sql

1.2 KB

get_relations_by_prefix.sql

1.1 KB

get_single_value.sql

0.9 KB

get_table_types_sql.sql

1.1 KB

get_tables_by_pattern_sql.sql

3.3 KB

get_tables_by_prefix_sql.sql

0.5 KB

groupby.sql

0.3 KB

haversine_distance.sql

1.9 KB

nullcheck.sql

0.4 KB

nullcheck_table.sql

0.4 KB

pivot.sql

2.5 KB

safe_add.sql

0.7 KB

safe_divide.sql

0.3 KB

safe_subtract.sql

0.7 KB

star.sql

1.9 KB

surrogate_key.sql

0.8 KB

union.sql

4.5 KB

unpivot.sql

2.7 KB

width_bucket.sql

1.1 KB

/5 - Macros/project1/dbt_packages/dbt_utils/macros/web/

get_url_host.sql

0.6 KB

get_url_parameter.sql

0.4 KB

get_url_path.sql

0.8 KB

/5 - Macros/project1/logs/

dbt.log

6.0 MB

/5 - Macros/project1/macros/

categorize_orders.sql

0.4 KB

full_name.sql

0.2 KB

generate_schema_name.sql

0.2 KB

gitkeep

0.0 KB

/5 - Macros/project1/models/intermediate/

int_customer_orders.sql

0.7 KB

/5 - Macros/project1/models/marts/sales/

customer_orders.sql

0.4 KB

/5 - Macros/project1/models/sources/

raw.yaml

2.0 KB

/5 - Macros/project1/models/staging/

2023_models.sql

0.1 KB

macro_categorize_orders_test.sql

0.2 KB

macro_full_name_test.sql

0.1 KB

macro_sum_by_category.sql

0.5 KB

/5 - Macros/project1/models/staging/stg_customers/

stg_customers.sql

0.2 KB

stg_customers.yaml

0.8 KB

/5 - Macros/project1/models/staging/stg_orders/

stg_orders.sql

0.2 KB

stg_orders.yaml

0.8 KB

/5 - Macros/project1/seeds/

gitkeep

0.0 KB

/5 - Macros/project1/snapshots/

gitkeep

0.0 KB

/5 - Macros/project1/target/

catalog.json

4.7 KB

graph.gpickle

39.6 KB

graph_summary.json

3.9 KB

index.html

1.5 MB

manifest.json

963.7 KB

partial_parse.msgpack

1.0 MB

run_results.json

1.9 KB

semantic_manifest.json

0.2 KB

/5 - Macros/project1/target/compiled/project1/models/intermediate/

int_customer_orders.sql

0.6 KB

/5 - Macros/project1/target/compiled/project1/models/intermidate/

int_customer_orders.sql

0.6 KB

/5 - Macros/project1/target/compiled/project1/models/marts/sales/

customer_orders.sql

0.4 KB

/5 - Macros/project1/target/compiled/project1/models/sources/raw.yaml/

source_accepted_values_raw_ord_ba8f29a51f72cdc502f1fef1733a2cd5.sql

0.3 KB

source_not_null_raw_customers_customer_id.sql

0.1 KB

source_not_null_raw_customers_email.sql

0.1 KB

source_not_null_raw_customers_first_name.sql

0.1 KB

source_not_null_raw_customers_last_name.sql

0.1 KB

source_not_null_raw_customers_loaded_at.sql

0.1 KB

source_not_null_raw_orders_customer_id.sql

0.1 KB

source_not_null_raw_orders_loaded_at.sql

0.1 KB

source_not_null_raw_orders_order_date.sql

0.1 KB

source_not_null_raw_orders_order_id.sql

0.1 KB

source_not_null_raw_orders_total_amount.sql

0.1 KB

source_positive_total_amount_raw_orders_total_amount.sql

0.1 KB

source_unique_raw_customers_customer_id.sql

0.2 KB

source_unique_raw_customers_email.sql

0.2 KB

source_unique_raw_orders_order_id.sql

0.2 KB

/5 - Macros/project1/target/compiled/project1/models/staging/

2023_days.sql

1.5 KB

2023_models.sql

1.5 KB

macro_categorize_orders_test.sql

0.3 KB

macro_full_name_test.sql

0.1 KB

macro_sum_by_category.sql

0.5 KB

macro_sum_by_category_test.sql

0.5 KB

test.sql

0.1 KB

/5 - Macros/project1/target/compiled/project1/models/staging/stg_customers/

stg_customers.sql

0.2 KB

/.../stg_customers.yaml/

dbt_expectations_expect_column_5903be949d744dfb544e9242795ad0e6.sql

0.4 KB

not_null_stg_customers_customer_id.sql

0.1 KB

not_null_stg_customers_email.sql

0.1 KB

not_null_stg_customers_first_name.sql

0.1 KB

not_null_stg_customers_last_name.sql

0.1 KB

unique_stg_customers_customer_id.sql

0.2 KB

unique_stg_customers_email.sql

0.2 KB

/5 - Macros/project1/target/compiled/project1/models/staging/stg_orders/

stg_orders.sql

0.2 KB

/.../stg_orders.yaml/

accepted_values_stg_orders_3d30f5dc672ada0d5f5c3ceb89fd3a5e.sql

0.3 KB

not_null_stg_orders_customer_id.sql

0.1 KB

not_null_stg_orders_order_date.sql

0.1 KB

not_null_stg_orders_order_id.sql

0.1 KB

not_null_stg_orders_total_amount.sql

0.1 KB

positive_total_amount_stg_orders_total_amount.sql

0.1 KB

unique_stg_orders_order_id.sql

0.2 KB

/5 - Macros/project1/target/run/project1/models/intermediate/

int_customer_orders.sql

0.6 KB

/5 - Macros/project1/target/run/project1/models/intermidate/

int_customer_orders.sql

0.7 KB

/5 - Macros/project1/target/run/project1/models/marts/sales/

customer_orders.sql

0.5 KB

/5 - Macros/project1/target/run/project1/models/sources/raw.yaml/

source_accepted_values_raw_ord_ba8f29a51f72cdc502f1fef1733a2cd5.sql

0.5 KB

source_not_null_raw_customers_customer_id.sql

0.3 KB

source_not_null_raw_customers_email.sql

0.3 KB

source_not_null_raw_customers_first_name.sql

0.3 KB

source_not_null_raw_customers_last_name.sql

0.3 KB

source_not_null_raw_customers_loaded_at.sql

0.3 KB

source_not_null_raw_orders_customer_id.sql

0.3 KB

source_not_null_raw_orders_loaded_at.sql

0.3 KB

source_not_null_raw_orders_order_date.sql

0.3 KB

source_not_null_raw_orders_order_id.sql

0.3 KB

source_not_null_raw_orders_total_amount.sql

0.3 KB

source_positive_total_amount_raw_orders_total_amount.sql

0.2 KB

source_unique_raw_customers_customer_id.sql

0.4 KB

source_unique_raw_customers_email.sql

0.3 KB

source_unique_raw_orders_order_id.sql

0.4 KB

/5 - Macros/project1/target/run/project1/models/staging/

2023_days.sql

1.6 KB

2023_models.sql

1.6 KB

macro_categorize_orders_test.sql

0.4 KB

macro_full_name_test.sql

0.2 KB

macro_sum_by_category.sql

0.6 KB

macro_sum_by_category_test.sql

0.6 KB

test.sql

0.2 KB

/5 - Macros/project1/target/run/project1/models/staging/stg_customers/

stg_customers.sql

0.3 KB

/.../stg_customers.yaml/

dbt_expectations_expect_column_5903be949d744dfb544e9242795ad0e6.sql

0.6 KB

not_null_stg_customers_customer_id.sql

0.3 KB

not_null_stg_customers_email.sql

0.3 KB

not_null_stg_customers_first_name.sql

0.3 KB

not_null_stg_customers_last_name.sql

0.3 KB

unique_stg_customers_customer_id.sql

0.4 KB

unique_stg_customers_email.sql

0.4 KB

/5 - Macros/project1/target/run/project1/models/staging/stg_orders/

stg_orders.sql

0.3 KB

/.../stg_orders.yaml/

accepted_values_stg_orders_3d30f5dc672ada0d5f5c3ceb89fd3a5e.sql

0.5 KB

not_null_stg_orders_customer_id.sql

0.3 KB

not_null_stg_orders_order_date.sql

0.3 KB

not_null_stg_orders_order_id.sql

0.3 KB

not_null_stg_orders_total_amount.sql

0.3 KB

positive_total_amount_stg_orders_total_amount.sql

0.2 KB

unique_stg_orders_order_id.sql

0.4 KB

/5 - Macros/project1/tests/generic/

positive_total_amount.sql

0.1 KB

/5 - Macros/project1/tests/

gitkeep

0.0 KB

/5 - Macros/project1/vscode/

settings.json

0.0 KB

/.../6 - Seeds and docs/

1 -Seeds.mp4

38.3 MB

2 -Generating Docs.mp4

45.4 MB

/.../6 - Seeds and docs/project1/

README.md

0.6 KB

dbt_project.yml

1.5 KB

gitignore

0.0 KB

package-lock.yml

0.3 KB

packages.yml

0.2 KB

/.../6 - Seeds and docs/project1/analyses/

gitkeep

0.0 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/

CHANGELOG.md

14.2 KB

CONTRIBUTING.md

6.2 KB

LICENSE

11.4 KB

Makefile

0.8 KB

README.md

13.0 KB

RELEASE.md

1.0 KB

dbt_project.yml

0.2 KB

docker-compose.yml

0.1 KB

gitignore

0.1 KB

packages.yml

0.1 KB

run_test.sh

0.3 KB

supported_adapters.env

0.1 KB

tox.ini

2.8 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/bash_scripts/

base_model_creation.sh

0.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/circleci/

config.yml

4.9 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/github/

CODEOWNERS

0.0 KB

pull_request_template.md

0.7 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/github/ISSUE_TEMPLATE/

bug_report.md

1.4 KB

feature_request.md

0.8 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/github/workflows/

ci.yml

1.8 KB

stale.yml

0.8 KB

triage-labels.yml

0.9 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/integration_tests/

README.md

9.6 KB

dbt_project.yml

0.6 KB

package-lock.yml

0.1 KB

packages.yml

0.0 KB

profiles.yml

1.7 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/integration_tests/env/

bigquery.env

0.1 KB

postgres.env

0.2 KB

redshift.env

0.1 KB

snowflake.env

0.1 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/integration_tests/macros/

assert_equal.sql

0.5 KB

integer_type_value.sql

0.2 KB

text_type_value.sql

0.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/integration_tests/macros/operations/

create_source_table.sql

1.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/integration_tests/models/

child_model.sql

0.0 KB

model_data_a.sql

0.1 KB

model_from_source.sql

0.1 KB

model_struct.sql

0.5 KB

model_without_any_ctes.sql

0.2 KB

model_without_import_ctes.sql

1.5 KB

schema.yml

0.1 KB

source.yml

0.4 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/integration_tests/seeds/

data__Case_Sensitive.csv

0.0 KB

data__a_relation.csv

0.0 KB

data__b_relation.csv

0.0 KB

data__campaign_analytics.csv

0.1 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/integration_tests/tests/

test_generate_base_models.sql

0.6 KB

test_generate_base_models_all_args.sql

0.8 KB

test_generate_base_models_case_sensitive.sql

0.7 KB

test_generate_base_models_leading.sql

0.6 KB

test_generate_model_import_ctes.sql

3.7 KB

test_generate_model_import_ctes_leading.sql

3.7 KB

test_generate_model_import_ctes_no_ctes.sql

0.6 KB

test_generate_model_struct_yaml.sql

1.4 KB

test_generate_model_yaml.sql

0.5 KB

test_generate_model_yaml_multiple_models.sql

0.6 KB

test_generate_model_yaml_upstream_descriptions.sql

0.5 KB

test_generate_model_yaml_upstream_source_descriptions.sql

0.5 KB

test_generate_source.sql

0.4 KB

test_generate_source_all_args.sql

2.0 KB

test_generate_source_case_sensitive.sql

1.0 KB

test_generate_source_exclude.sql

0.5 KB

test_generate_source_include_database_property.sql

0.5 KB

test_generate_source_include_schema_property.sql

0.5 KB

test_generate_source_some_tables.sql

0.7 KB

test_generate_source_table_descriptions.sql

0.6 KB

test_generate_source_table_name.sql

0.5 KB

test_generate_source_table_pattern.sql

0.4 KB

test_helper_get_models.sql

0.5 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/macros/

create_base_models.sql

0.7 KB

generate_base_model.sql

1.5 KB

generate_model_import_ctes.sql

14.5 KB

generate_model_yaml.sql

2.8 KB

generate_source.sql

3.6 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/macros/helpers/

helpers.sql

3.6 KB

/.../6 - Seeds and docs/project1/dbt_packages/codegen/macros/vendored/dbt_core/

format_column.sql

0.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/

CHANGELOG.md

5.2 KB

LICENSE

11.4 KB

README.md

20.8 KB

dbt_project.yml

0.3 KB

gitignore

0.1 KB

packages.yml

0.0 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/circleci/

config.yml

5.3 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/github/

FUNDING.yml

0.1 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/github/ISSUE_TEMPLATE/

bug_report.md

0.7 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/integration_tests/ci/

profiles.yml

1.6 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/integration_tests/

dbt_project.yml

0.7 KB

docker-compose.yml

0.8 KB

docker-start.sh

0.0 KB

docker-stop.sh

0.1 KB

packages.yml

0.0 KB

test.sh

0.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/integration_tests/docker/

hive-site.xml

1.6 KB

spark-defaults.conf

0.4 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/integration_tests/docker/trino/catalog/

memory.properties

0.1 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/integration_tests/macros/

expression_is_true.sql

0.7 KB

get_custom_schema.sql

0.3 KB

get_test_dates.sql

6.8 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/integration_tests/models/

dates.sql

0.1 KB

dim_date.sql

0.5 KB

dim_date_fiscal.sql

0.2 KB

dim_hour.sql

0.2 KB

dim_week.sql

0.2 KB

test_dates.sql

0.1 KB

test_dates.yml

4.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/macros/_utils/

date_spine.sql

1.6 KB

generate_series.sql

1.2 KB

modules_datetime.sql

0.5 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/macros/calendar_date/

convert_timezone.sql

1.7 KB

date_part.sql

0.5 KB

day_name.sql

1.6 KB

day_of_month.sql

0.2 KB

day_of_week.sql

2.7 KB

day_of_year.sql

0.6 KB

from_unixtimestamp.sql

3.0 KB

iso_week_end.sql

0.5 KB

iso_week_of_year.sql

1.1 KB

iso_week_start.sql

0.9 KB

last_month.sql

0.1 KB

last_month_name.sql

0.1 KB

last_month_number.sql

0.1 KB

last_week.sql

0.1 KB

month_name.sql

1.2 KB

n_days_ago.sql

0.2 KB

n_days_away.sql

0.1 KB

n_months_ago.sql

0.2 KB

n_months_away.sql

0.2 KB

n_weeks_ago.sql

0.2 KB

n_weeks_away.sql

0.2 KB

next_month.sql

0.1 KB

next_month_name.sql

0.1 KB

next_month_number.sql

0.1 KB

next_week.sql

0.1 KB

now.sql

0.1 KB

periods_since.sql

0.1 KB

round_timestamp.sql

0.1 KB

to_unixtimestamp.sql

0.7 KB

today.sql

0.1 KB

tomorrow.sql

0.1 KB

week_end.sql

0.6 KB

week_of_year.sql

0.7 KB

week_start.sql

0.9 KB

yesterday.sql

0.1 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/macros/fiscal_date/

get_fiscal_periods.sql

2.0 KB

get_fiscal_year_dates.sql

3.0 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_date/macros/

get_base_dates.sql

2.4 KB

get_date_dimension.sql

6.9 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/

CHANGELOG.md

15.0 KB

LICENSE

11.4 KB

README.md

48.7 KB

dbt_project.yml

0.4 KB

editorconfig

0.2 KB

gitignore

0.1 KB

packages.yml

0.1 KB

regen_docs.sh

0.3 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/circleci/

config.yml

5.4 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/data/

gitkeep

0.0 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/docs/

catalog.json

10.5 KB

index.html

1.5 MB

manifest.json

1.2 MB

run_results.json

76.5 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/github/

FUNDING.yml

0.1 KB

pull_request_template.md

0.4 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/github/ISSUE_TEMPLATE/

bug_report.md

0.7 KB

feature_request.md

0.6 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/integration_tests/ci/

profiles.yml

1.7 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/integration_tests/

dbt_project.yml

0.9 KB

docker-compose.yml

0.8 KB

docker-start.sh

0.0 KB

docker-stop.sh

0.1 KB

packages.yml

0.0 KB

sqlfluff

0.6 KB

sqlfluffignore

0.0 KB

test.sh

0.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/integration_tests/docker/

hive-site.xml

1.6 KB

spark-defaults.conf

0.5 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/integration_tests/macros/

get_custom_schema.sql

0.3 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/integration_tests/models/schema_tests/

data_test.sql

1.4 KB

data_test_factored.sql

0.1 KB

data_text.sql

0.5 KB

schema.yml

29.0 KB

series_10.sql

0.0 KB

series_4.sql

0.0 KB

timeseries_base.sql

0.1 KB

timeseries_data.sql

0.6 KB

timeseries_data_extended.sql

0.6 KB

timeseries_data_grouped.sql

0.8 KB

timeseries_hourly.sql

0.3 KB

timeseries_hourly_data_extended.sql

0.6 KB

window_function_test.sql

0.9 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/macros/

gitkeep

0.0 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/macros/math/

log_natural.sql

0.4 KB

median.sql

0.1 KB

percentile_cont.sql

0.8 KB

rand.sql

0.5 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/macros/regex/

regexp_instr.sql

5.1 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/macros/schema_tests/_generalized/

_ignore_row_if_expression.sql

0.8 KB

_truth_expression.sql

0.2 KB

equal_expression.sql

4.1 KB

expression_between.sql

1.7 KB

expression_is_true.sql

1.7 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/macros/schema_tests/aggregate_functions/

expect_column_distinct_count_to_be_greater_than.sql

0.8 KB

expect_column_distinct_count_to_be_less_than.sql

0.8 KB

expect_column_distinct_count_to_equal.sql

0.7 KB

expect_column_distinct_count_to_equal_other_table.sql

1.0 KB

expect_column_distinct_values_to_be_in_set.sql

1.2 KB

expect_column_distinct_values_to_contain_set.sql

1.2 KB

expect_column_distinct_values_to_equal_set.sql

1.2 KB

expect_column_max_to_be_between.sql

1.0 KB

expect_column_mean_to_be_between.sql

1.0 KB

expect_column_median_to_be_between.sql

1.0 KB

expect_column_min_to_be_between.sql

1.0 KB

expect_column_most_common_value_to_be_in_set.sql

2.9 KB

expect_column_proportion_of_unique_values_to_be_between.sql

1.1 KB

expect_column_quantile_values_to_be_between.sql

1.2 KB

expect_column_stdev_to_be_between.sql

2.1 KB

expect_column_sum_to_be_between.sql

1.0 KB

expect_column_unique_value_count_to_be_between.sql

1.1 KB

/.../column_values_basic/

expect_column_values_to_be_between.sql

0.9 KB

expect_column_values_to_be_decreasing.sql

1.6 KB

expect_column_values_to_be_in_set.sql

1.1 KB

expect_column_values_to_be_in_type_list.sql

1.0 KB

expect_column_values_to_be_increasing.sql

1.7 KB

expect_column_values_to_be_null.sql

0.5 KB

expect_column_values_to_be_of_type.sql

0.2 KB

expect_column_values_to_be_unique.sql

0.2 KB

expect_column_values_to_have_consistent_casing.sql

0.9 KB

expect_column_values_to_not_be_in_set.sql

1.0 KB

expect_column_values_to_not_be_null.sql

0.5 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/macros/schema_tests/distributional/

expect_column_values_to_be_within_n_moving_stdevs.sql

5.3 KB

expect_column_values_to_be_within_n_stdevs.sql

1.5 KB

expect_row_values_to_have_data_for_every_n_datepart.sql

5.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/macros/schema_tests/multi-column/

expect_column_pair_values_A_to_be_greater_than_B.sql

0.9 KB

expect_column_pair_values_to_be_equal.sql

0.8 KB

expect_column_pair_values_to_be_in_set.sql

1.2 KB

expect_compound_columns_to_be_unique.sql

1.7 KB

expect_multicolumn_sum_to_equal.sql

1.0 KB

expect_select_column_values_to_be_unique_within_record.sql

2.5 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/macros/schema_tests/string_matching/

_get_like_pattern_expression.sql

0.2 KB

expect_column_value_lengths_to_be_between.sql

1.0 KB

expect_column_value_lengths_to_equal.sql

0.7 KB

expect_column_values_to_match_like_pattern.sql

0.7 KB

expect_column_values_to_match_like_pattern_list.sql

1.0 KB

expect_column_values_to_match_regex.sql

0.8 KB

expect_column_values_to_match_regex_list.sql

1.1 KB

expect_column_values_to_not_match_like_pattern.sql

0.7 KB

expect_column_values_to_not_match_like_pattern_list.sql

1.0 KB

expect_column_values_to_not_match_regex.sql

0.8 KB

expect_column_values_to_not_match_regex_list.sql

1.1 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/macros/schema_tests/table_shape/

_get_column_list.sql

0.3 KB

_list_intersect.sql

0.3 KB

expect_column_to_exist.sql

1.1 KB

expect_grouped_row_values_to_have_recent_data.sql

3.4 KB

expect_row_values_to_have_recent_data.sql

1.8 KB

expect_table_aggregation_to_equal_other_table.sql

1.1 KB

expect_table_column_count_to_be_between.sql

1.0 KB

expect_table_column_count_to_equal.sql

0.4 KB

expect_table_column_count_to_equal_other_table.sql

0.5 KB

expect_table_columns_to_contain_set.sql

1.1 KB

expect_table_columns_to_match_ordered_list.sql

1.4 KB

expect_table_columns_to_match_set.sql

1.2 KB

expect_table_columns_to_not_contain_set.sql

1.1 KB

expect_table_row_count_to_be_between.sql

1.6 KB

expect_table_row_count_to_equal.sql

1.1 KB

expect_table_row_count_to_equal_other_table.sql

1.9 KB

expect_table_row_count_to_equal_other_table_times_factor.sql

2.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/macros/utils/

datatypes.sql

1.2 KB

groupby.sql

0.3 KB

md5.sql

0.3 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/static/

dbt-expectations-logo.png

1.6 KB

dbt-expectations-logo.svg

8.0 KB

expectations.gif

3.2 MB

gitkeep

0.0 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_expectations/tests/

gitkeep

0.0 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/

CHANGELOG.md

39.3 KB

CONTRIBUTING.md

7.3 KB

LICENSE

11.3 KB

Makefile

0.7 KB

README.md

50.5 KB

RELEASE.md

1.6 KB

dbt_project.yml

0.2 KB

dev-requirements.txt

0.5 KB

docker-compose.yml

0.1 KB

gitignore

0.3 KB

pytest.ini

0.2 KB

run_functional_test.sh

0.1 KB

run_test.sh

0.4 KB

supported_adapters.env

0.1 KB

tox.ini

2.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/circleci/

config.yml

3.7 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/docs/decisions/

README.md

0.6 KB

adr-0000-documenting-architecture-decisions.md

5.5 KB

adr-0001-decision-record-format.md

2.5 KB

adr-0002-cross-database-utils.md

6.9 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/github/

CODEOWNERS

0.0 KB

pull_request_template.md

0.9 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/github/ISSUE_TEMPLATE/

bug_report.md

1.4 KB

dbt_minor_release.md

1.2 KB

feature_request.md

0.8 KB

utils_minor_release.md

2.0 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/github/workflows/

ci.yml

5.8 KB

create-table-of-contents.yml

0.8 KB

stale.yml

0.8 KB

triage-labels.yml

0.9 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/

README.md

4.1 KB

dbt_project.yml

1.9 KB

gitignore

0.1 KB

package-lock.yml

0.1 KB

packages.yml

0.0 KB

profiles.yml

1.7 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/data/datetime/

data_date_spine.csv

0.1 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/data/etc/

data_people.csv

8.1 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/data/geo/

data_haversine_km.csv

0.1 KB

data_haversine_mi.csv

0.1 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/data/

gitkeep

0.0 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/data/schema_tests/

data_cardinality_equality_a.csv

0.0 KB

data_cardinality_equality_b.csv

0.0 KB

data_not_null_proportion.csv

0.1 KB

data_test_accepted_range.csv

0.0 KB

data_test_at_least_one.csv

0.0 KB

data_test_equal_rowcount.csv

0.0 KB

data_test_equality_a.csv

0.0 KB

data_test_equality_b.csv

0.0 KB

data_test_equality_floats_a.csv

0.5 KB

data_test_equality_floats_b.csv

0.5 KB

data_test_equality_floats_columns_a.csv

0.5 KB

data_test_equality_floats_columns_b.csv

0.5 KB

data_test_expression_is_true.csv

0.0 KB

data_test_fewer_rows_than_table_1.csv

0.0 KB

data_test_fewer_rows_than_table_2.csv

0.0 KB

data_test_mutually_exclusive_ranges_no_gaps.csv

0.0 KB

data_test_mutually_exclusive_ranges_with_gaps.csv

0.1 KB

data_test_mutually_exclusive_ranges_with_gaps_zero_length.csv

0.2 KB

data_test_not_accepted_values.csv

0.0 KB

data_test_not_constant.csv

0.0 KB

data_test_relationships_where_table_1.csv

0.0 KB

data_test_relationships_where_table_2.csv

0.0 KB

data_test_sequential_timestamps.csv

0.1 KB

data_test_sequential_values.csv

0.0 KB

data_unique_combination_of_columns.csv

0.2 KB

schema.yml

0.5 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/data/sql/

data_deduplicate.csv

0.1 KB

data_deduplicate_expected.csv

0.0 KB

data_events_20180101.csv

0.0 KB

data_events_20180102.csv

0.0 KB

data_events_20180103.csv

0.0 KB

data_filtered_columns_in_relation.csv

0.0 KB

data_filtered_columns_in_relation_expected.csv

0.0 KB

data_generate_series.csv

0.0 KB

data_generate_surrogate_key.csv

0.4 KB

data_get_column_values.csv

0.0 KB

data_get_column_values_dropped.csv

0.0 KB

data_get_column_values_where.csv

0.1 KB

data_get_column_values_where_expected.csv

0.0 KB

data_get_query_results_as_dict.csv

0.0 KB

data_get_single_value.csv

0.1 KB

data_nullcheck_table.csv

0.0 KB

data_pivot.csv

0.0 KB

data_pivot_expected.csv

0.0 KB

data_pivot_expected_apostrophe.csv

0.0 KB

data_safe_add.csv

0.1 KB

data_safe_divide.csv

0.1 KB

data_safe_divide_denominator_expressions.csv

0.1 KB

data_safe_divide_numerator_expressions.csv

0.1 KB

data_safe_subtract.csv

0.1 KB

data_star.csv

0.0 KB

data_star_aggregate.csv

0.1 KB

data_star_aggregate_expected.csv

0.1 KB

data_star_expected.csv

0.0 KB

data_star_prefix_suffix_expected.csv

0.1 KB

data_star_quote_identifiers.csv

0.0 KB

data_union_events_expected.csv

0.1 KB

data_union_exclude_expected.csv

0.1 KB

data_union_expected.csv

0.1 KB

data_union_table_1.csv

0.1 KB

data_union_table_2.csv

0.1 KB

data_unpivot.csv

0.2 KB

data_unpivot_bool.csv

0.1 KB

data_unpivot_bool_expected.csv

0.3 KB

data_unpivot_expected.csv

0.2 KB

data_unpivot_original_api_expected.csv

0.3 KB

data_unpivot_quote.csv

0.2 KB

data_unpivot_quote_expected.csv

0.2 KB

data_width_bucket.csv

0.4 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/data/web/

data_url_host.csv

0.4 KB

data_url_path.csv

0.5 KB

data_urls.csv

0.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/env/

bigquery.env

0.1 KB

postgres.env

0.2 KB

redshift.env

0.1 KB

snowflake.env

0.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/macros/

assert_equal_values.sql

0.5 KB

gitkeep

0.0 KB

limit_zero.sql

0.2 KB

tests.sql

0.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/models/datetime/

schema.yml

0.1 KB

test_date_spine.sql

0.8 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/models/generic_tests/

equality_less_columns.sql

0.1 KB

recency_time_excluded.sql

0.2 KB

recency_time_included.sql

0.1 KB

schema.yml

7.7 KB

test_equal_column_subset.sql

0.1 KB

test_equal_rowcount.sql

0.1 KB

test_fewer_rows_than.sql

0.1 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/models/geo/

schema.yml

0.3 KB

test_haversine_distance_km.sql

0.5 KB

test_haversine_distance_mi.sql

0.9 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/models/sql/

schema.yml

6.7 KB

test_deduplicate.sql

0.3 KB

test_generate_series.sql

0.4 KB

test_generate_surrogate_key.sql

0.3 KB

test_get_column_values.sql

0.7 KB

test_get_column_values_where.sql

0.3 KB

test_get_filtered_columns_in_relation.sql

0.4 KB

test_get_relations_by_pattern.sql

0.4 KB

test_get_relations_by_prefix_and_union.sql

0.3 KB

test_get_single_value.sql

1.3 KB

test_get_single_value_default.sql

1.1 KB

test_groupby.sql

0.3 KB

test_not_empty_string_failing.sql

0.7 KB

test_not_empty_string_passing.sql

0.8 KB

test_nullcheck_table.sql

0.6 KB

test_pivot.sql

0.4 KB

test_pivot_apostrophe.sql

0.4 KB

test_safe_add.sql

0.2 KB

test_safe_divide.sql

0.8 KB

test_safe_subtract.sql

0.2 KB

test_star.sql

0.2 KB

test_star_aggregate.sql

0.4 KB

test_star_no_columns.sql

0.3 KB

test_star_prefix_suffix.sql

0.3 KB

test_star_quote_identifiers.sql

0.4 KB

test_star_uppercase.sql

0.2 KB

test_union.sql

0.1 KB

test_union_base.sql

0.1 KB

test_union_exclude_base_lowercase.sql

0.2 KB

test_union_exclude_base_uppercase.sql

0.2 KB

test_union_exclude_lowercase.sql

0.2 KB

test_union_exclude_uppercase.sql

0.2 KB

test_union_no_source_column.sql

0.1 KB

test_union_where.sql

0.1 KB

test_union_where_base.sql

0.1 KB

test_unpivot.sql

0.8 KB

test_unpivot_bool.sql

0.8 KB

test_unpivot_quote.sql

0.3 KB

test_width_bucket.sql

0.2 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/models/web/

schema.yml

0.4 KB

test_url_host.sql

0.2 KB

test_url_path.sql

0.2 KB

test_urls.sql

0.3 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/tests/

assert_get_query_results_as_dict_objects_equal.sql

2.5 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/tests/generic/

expect_table_columns_to_match_set.sql

1.9 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/tests/jinja_helpers/

assert_pretty_output_msg_is_string.sql

0.2 KB

assert_pretty_time_is_string.sql

0.2 KB

test_slugify.sql

0.4 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/integration_tests/tests/sql/

test_get_column_values_use_default.sql

1.0 KB

test_get_single_value_multiple_rows.sql

0.5 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/macros/generic_tests/

accepted_range.sql

1.1 KB

at_least_one.sql

1.3 KB

cardinality_equality.sql

0.9 KB

equal_rowcount.sql

2.1 KB

equality.sql

6.1 KB

expression_is_true.sql

0.5 KB

fewer_rows_than.sql

2.4 KB

mutually_exclusive_ranges.sql

3.6 KB

not_accepted_values.sql

0.8 KB

not_constant.sql

0.8 KB

not_empty_string.sql

0.7 KB

not_null_proportion.sql

1.1 KB

recency.sql

1.2 KB

relationships_where.sql

1.0 KB

sequential_values.sql

1.3 KB

unique_combination_of_columns.sql

1.1 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/macros/jinja_helpers/

_is_ephemeral.sql

0.7 KB

_is_relation.sql

0.3 KB

log_info.sql

0.2 KB

pretty_log_format.sql

0.3 KB

pretty_time.sql

0.3 KB

slugify.sql

0.5 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/macros/sql/

date_spine.sql

1.6 KB

deduplicate.sql

3.0 KB

generate_series.sql

1.2 KB

generate_surrogate_key.sql

0.8 KB

get_column_values.sql

2.3 KB

get_filtered_columns_in_relation.sql

1.0 KB

get_query_results_as_dict.sql

0.8 KB

get_relations_by_pattern.sql

1.2 KB

get_relations_by_prefix.sql

1.1 KB

get_single_value.sql

0.9 KB

get_table_types_sql.sql

1.1 KB

get_tables_by_pattern_sql.sql

3.3 KB

get_tables_by_prefix_sql.sql

0.5 KB

groupby.sql

0.3 KB

haversine_distance.sql

1.9 KB

nullcheck.sql

0.4 KB

nullcheck_table.sql

0.4 KB

pivot.sql

2.5 KB

safe_add.sql

0.7 KB

safe_divide.sql

0.3 KB

safe_subtract.sql

0.7 KB

star.sql

1.9 KB

surrogate_key.sql

0.8 KB

union.sql

4.5 KB

unpivot.sql

2.7 KB

width_bucket.sql

1.1 KB

/.../6 - Seeds and docs/project1/dbt_packages/dbt_utils/macros/web/

get_url_host.sql

0.6 KB

get_url_parameter.sql

0.4 KB

get_url_path.sql

0.8 KB

/.../6 - Seeds and docs/project1/logs/

dbt.log

6.3 MB

/.../6 - Seeds and docs/project1/macros/

categorize_orders.sql

0.4 KB

full_name.sql

0.2 KB

generate_schema_name.sql

0.2 KB

gitkeep

0.0 KB

/.../6 - Seeds and docs/project1/models/intermediate/

int_customer_orders.sql

0.7 KB

/.../6 - Seeds and docs/project1/models/marts/sales/

customer_orders.sql

0.4 KB

/.../6 - Seeds and docs/project1/models/sources/

raw.yaml

2.0 KB

/.../6 - Seeds and docs/project1/models/staging/

2023_models.sql

0.1 KB

macro_categorize_orders_test.sql

0.2 KB

macro_full_name_test.sql

0.1 KB

macro_sum_by_category.sql

0.5 KB

/.../6 - Seeds and docs/project1/models/staging/stg_customers/

stg_customers.sql

0.2 KB

stg_customers.yaml

0.8 KB

/.../6 - Seeds and docs/project1/models/staging/stg_orders/

stg_orders.sql

0.2 KB

stg_orders.yaml

0.8 KB

/.../6 - Seeds and docs/project1/seeds/

gitkeep

0.0 KB

products.csv

0.1 KB

products2.csv

0.1 KB

/.../6 - Seeds and docs/project1/snapshots/

gitkeep

0.0 KB

/.../6 - Seeds and docs/project1/target/

catalog.json

4.7 KB

graph.gpickle

40.9 KB

graph_summary.json

4.0 KB

index.html

1.5 MB

manifest.json

966.8 KB

partial_parse.msgpack

1.0 MB

run_results.json

2.7 KB

semantic_manifest.json

0.2 KB

/.../6 - Seeds and docs/project1/target/compiled/project1/models/intermediate/

int_customer_orders.sql

0.6 KB

/.../6 - Seeds and docs/project1/target/compiled/project1/models/intermidate/

int_customer_orders.sql

0.6 KB

/.../6 - Seeds and docs/project1/target/compiled/project1/models/marts/sales/

customer_orders.sql

0.4 KB

/.../6 - Seeds and docs/project1/target/compiled/project1/models/sources/raw.yaml/

source_accepted_values_raw_ord_ba8f29a51f72cdc502f1fef1733a2cd5.sql

0.3 KB

source_not_null_raw_customers_customer_id.sql

0.1 KB

source_not_null_raw_customers_email.sql

0.1 KB

source_not_null_raw_customers_first_name.sql

0.1 KB

source_not_null_raw_customers_last_name.sql

0.1 KB

source_not_null_raw_customers_loaded_at.sql

0.1 KB

source_not_null_raw_orders_customer_id.sql

0.1 KB

source_not_null_raw_orders_loaded_at.sql

0.1 KB

source_not_null_raw_orders_order_date.sql

0.1 KB

source_not_null_raw_orders_order_id.sql

0.1 KB

source_not_null_raw_orders_total_amount.sql

0.1 KB

source_positive_total_amount_raw_orders_total_amount.sql

0.1 KB

source_unique_raw_customers_customer_id.sql

0.2 KB

source_unique_raw_customers_email.sql

0.2 KB

source_unique_raw_orders_order_id.sql

0.2 KB

/.../6 - Seeds and docs/project1/target/compiled/project1/models/staging/

2023_days.sql

1.5 KB

2023_models.sql

1.5 KB

macro_categorize_orders_test.sql

0.3 KB

macro_full_name_test.sql

0.1 KB

macro_sum_by_category.sql

0.5 KB

macro_sum_by_category_test.sql

0.5 KB

test.sql

0.1 KB

/.../6 - Seeds and docs/project1/target/compiled/project1/models/staging/stg_customers/

stg_customers.sql

0.2 KB

/.../stg_customers.yaml/

dbt_expectations_expect_column_5903be949d744dfb544e9242795ad0e6.sql

0.4 KB

not_null_stg_customers_customer_id.sql

0.1 KB

not_null_stg_customers_email.sql

0.1 KB

not_null_stg_customers_first_name.sql

0.1 KB

not_null_stg_customers_last_name.sql

0.1 KB

unique_stg_customers_customer_id.sql

0.2 KB

unique_stg_customers_email.sql

0.2 KB

/.../6 - Seeds and docs/project1/target/compiled/project1/models/staging/stg_orders/

stg_orders.sql

0.2 KB

/.../stg_orders.yaml/

accepted_values_stg_orders_3d30f5dc672ada0d5f5c3ceb89fd3a5e.sql

0.3 KB

not_null_stg_orders_customer_id.sql

0.1 KB

not_null_stg_orders_order_date.sql

0.1 KB

not_null_stg_orders_order_id.sql

0.1 KB

not_null_stg_orders_total_amount.sql

0.1 KB

positive_total_amount_stg_orders_total_amount.sql

0.1 KB

unique_stg_orders_order_id.sql

0.2 KB

/.../6 - Seeds and docs/project1/target/run/project1/models/intermediate/

int_customer_orders.sql

0.6 KB

/.../6 - Seeds and docs/project1/target/run/project1/models/intermidate/

int_customer_orders.sql

0.7 KB

/.../6 - Seeds and docs/project1/target/run/project1/models/marts/sales/

customer_orders.sql

0.5 KB

/.../6 - Seeds and docs/project1/target/run/project1/models/sources/raw.yaml/

source_accepted_values_raw_ord_ba8f29a51f72cdc502f1fef1733a2cd5.sql

0.5 KB

source_not_null_raw_customers_customer_id.sql

0.3 KB

source_not_null_raw_customers_email.sql

0.3 KB

source_not_null_raw_customers_first_name.sql

0.3 KB

source_not_null_raw_customers_last_name.sql

0.3 KB

source_not_null_raw_customers_loaded_at.sql

0.3 KB

source_not_null_raw_orders_customer_id.sql

0.3 KB

source_not_null_raw_orders_loaded_at.sql

0.3 KB

source_not_null_raw_orders_order_date.sql

0.3 KB

source_not_null_raw_orders_order_id.sql

0.3 KB

source_not_null_raw_orders_total_amount.sql

0.3 KB

source_positive_total_amount_raw_orders_total_amount.sql

0.2 KB

source_unique_raw_customers_customer_id.sql

0.4 KB

source_unique_raw_customers_email.sql

0.3 KB

source_unique_raw_orders_order_id.sql

0.4 KB

/.../6 - Seeds and docs/project1/target/run/project1/models/staging/

2023_days.sql

1.6 KB

2023_models.sql

1.6 KB

macro_categorize_orders_test.sql

0.4 KB

macro_full_name_test.sql

0.2 KB

macro_sum_by_category.sql

0.6 KB

macro_sum_by_category_test.sql

0.6 KB

test.sql

0.2 KB

/.../6 - Seeds and docs/project1/target/run/project1/models/staging/stg_customers/

stg_customers.sql

0.3 KB

/.../stg_customers.yaml/

dbt_expectations_expect_column_5903be949d744dfb544e9242795ad0e6.sql

0.6 KB

not_null_stg_customers_customer_id.sql

0.3 KB

not_null_stg_customers_email.sql

0.3 KB

not_null_stg_customers_first_name.sql

0.3 KB

not_null_stg_customers_last_name.sql

0.3 KB

unique_stg_customers_customer_id.sql

0.4 KB

unique_stg_customers_email.sql

0.4 KB

/.../6 - Seeds and docs/project1/target/run/project1/models/staging/stg_orders/

stg_orders.sql

0.3 KB

/.../stg_orders.yaml/

accepted_values_stg_orders_3d30f5dc672ada0d5f5c3ceb89fd3a5e.sql

0.5 KB

not_null_stg_orders_customer_id.sql

0.3 KB

not_null_stg_orders_order_date.sql

0.3 KB

not_null_stg_orders_order_id.sql

0.3 KB

not_null_stg_orders_total_amount.sql

0.3 KB

positive_total_amount_stg_orders_total_amount.sql

0.2 KB

unique_stg_orders_order_id.sql

0.4 KB

/.../6 - Seeds and docs/project1/target/run/project1/seeds/

products.csv

0.3 KB

products2.csv

0.3 KB

/.../6 - Seeds and docs/project1/tests/generic/

positive_total_amount.sql

0.1 KB

/.../6 - Seeds and docs/project1/tests/

gitkeep

0.0 KB

/.../6 - Seeds and docs/project1/vscode/

settings.json

0.0 KB

/~Get Your Files Here !/

Bonus Resources.txt

0.1 KB

 

Total files 1433


Copyright © 2025 FileMood.com