René's URL Explorer Experiment


Title: GitHub - sixcodes/dbt-utils: Utility functions for dbt projects.

Open Graph Title: GitHub - sixcodes/dbt-utils: Utility functions for dbt projects.

X Title: GitHub - sixcodes/dbt-utils: Utility functions for dbt projects.

Description: Utility functions for dbt projects. Contribute to sixcodes/dbt-utils development by creating an account on GitHub.

Open Graph Description: Utility functions for dbt projects. Contribute to sixcodes/dbt-utils development by creating an account on GitHub.

X Description: Utility functions for dbt projects. Contribute to sixcodes/dbt-utils development by creating an account on GitHub.

Opengraph URL: https://github.com/sixcodes/dbt-utils

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern/:user_id/:repository
route-controllerfiles
route-actiondisambiguate
fetch-noncev2:cdc2112c-4e9d-6f98-c403-97acb7943e50
current-catalog-service-hashf3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id9C2A:94696:5E93C2:785020:697F76EF
html-safe-nonce58d8313b929dbaf1d7b709cc7f26a07756b2f25b1c4e338d86062d64cc0fd9fb
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5QzJBOjk0Njk2OjVFOTNDMjo3ODUwMjA6Njk3Rjc2RUYiLCJ2aXNpdG9yX2lkIjoiODc3NDAzMjgwMDYzNTM4NTU4MyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac4e0ec48640e24086b6940d7dbb04dee0b43a03766fa48a7cd4f758a3d1d1ad25
hovercard-subject-tagrepository:1077122015
github-keyboard-shortcutsrepository,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location//
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/sixcodes/dbt-utils
twitter:imagehttps://opengraph.githubassets.com/5497479151536ff46d24e0a9fc5cf77d3bb4d6ed3d36522530b7c8883d5bfb2a/sixcodes/dbt-utils
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/5497479151536ff46d24e0a9fc5cf77d3bb4d6ed3d36522530b7c8883d5bfb2a/sixcodes/dbt-utils
og:image:altUtility functions for dbt projects. Contribute to sixcodes/dbt-utils development by creating an account on GitHub.
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None60279d4097367e16897439d16d6bbe4180663db828c666eeed2656988ffe59f6
turbo-cache-controlno-preview
go-importgithub.com/sixcodes/dbt-utils git https://github.com/sixcodes/dbt-utils.git
octolytics-dimension-user_id1518668
octolytics-dimension-user_loginsixcodes
octolytics-dimension-repository_id1077122015
octolytics-dimension-repository_nwosixcodes/dbt-utils
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forktrue
octolytics-dimension-repository_parent_id97406952
octolytics-dimension-repository_parent_nwodbt-labs/dbt-utils
octolytics-dimension-repository_network_root_id97406952
octolytics-dimension-repository_network_root_nwodbt-labs/dbt-utils
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release7c85641c598ad130c74f7bcc27f58575cac69551
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#start-of-content
https://patch-diff.githubusercontent.com/
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsixcodes%2Fdbt-utils
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsixcodes%2Fdbt-utils
Sign up https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=sixcodes%2Fdbt-utils
Reloadhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils
Reloadhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils
Reloadhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils
sixcodes https://patch-diff.githubusercontent.com/sixcodes
dbt-utilshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils
dbt-labs/dbt-utilshttps://patch-diff.githubusercontent.com/dbt-labs/dbt-utils
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fsixcodes%2Fdbt-utils
Fork 0 https://patch-diff.githubusercontent.com/login?return_to=%2Fsixcodes%2Fdbt-utils
Star 0 https://patch-diff.githubusercontent.com/login?return_to=%2Fsixcodes%2Fdbt-utils
hub.getdbt.com/dbt-labs/dbt_utils/latest/https://hub.getdbt.com/dbt-labs/dbt_utils/latest/
Apache-2.0 license https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/LICENSE
0 stars https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/stargazers
600 forks https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/forks
Branches https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/branches
Tags https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tags
Activity https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/activity
Star https://patch-diff.githubusercontent.com/login?return_to=%2Fsixcodes%2Fdbt-utils
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fsixcodes%2Fdbt-utils
Code https://patch-diff.githubusercontent.com/sixcodes/dbt-utils
Pull requests 0 https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/pulls
Actions https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/actions
Security 0 https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/security
Insights https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/pulse
Code https://patch-diff.githubusercontent.com/sixcodes/dbt-utils
Pull requests https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/pulls
Actions https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/actions
Security https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/security
Insights https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/pulse
Brancheshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/branches
Tagshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tags
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/branches
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tags
799 Commitshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/commits/main/
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/commits/main/
.circlecihttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tree/main/.circleci
.circlecihttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tree/main/.circleci
.githubhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tree/main/.github
.githubhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tree/main/.github
docs/decisionshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tree/main/docs/decisions
docs/decisionshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tree/main/docs/decisions
integration_testshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tree/main/integration_tests
integration_testshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tree/main/integration_tests
macroshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tree/main/macros
macroshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tree/main/macros
.gitignorehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/.gitignore
.gitignorehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/.gitignore
CHANGELOG.mdhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/CHANGELOG.md
CHANGELOG.mdhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/CHANGELOG.md
CONTRIBUTING.mdhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/CONTRIBUTING.md
CONTRIBUTING.mdhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/CONTRIBUTING.md
LICENSEhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/LICENSE
LICENSEhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/LICENSE
Makefilehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/Makefile
Makefilehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/Makefile
README.mdhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/README.md
README.mdhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/README.md
RELEASE.mdhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/RELEASE.md
RELEASE.mdhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/RELEASE.md
dbt_project.ymlhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/dbt_project.yml
dbt_project.ymlhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/dbt_project.yml
dev-requirements.txthttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/dev-requirements.txt
dev-requirements.txthttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/dev-requirements.txt
docker-compose.ymlhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/docker-compose.yml
docker-compose.ymlhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/docker-compose.yml
pytest.inihttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/pytest.ini
pytest.inihttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/pytest.ini
run_functional_test.shhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/run_functional_test.sh
run_functional_test.shhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/run_functional_test.sh
run_test.shhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/run_test.sh
run_test.shhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/run_test.sh
supported_adapters.envhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/supported_adapters.env
supported_adapters.envhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/supported_adapters.env
tox.inihttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/tox.ini
tox.inihttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/tox.ini
READMEhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils
Contributinghttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils
Licensehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils
dbthttps://github.com/dbt-labs/dbt
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#installation-instructions
dbt Hubhttps://hub.getdbt.com/dbt-labs/dbt_utils/latest/
read the docshttps://docs.getdbt.com/docs/package-management
Installation Instructionshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#installation-instructions
Generic Testshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#generic-tests
equal_rowcount (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#equal_rowcount-source
fewer_rows_than (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#fewer_rows_than-source
equality (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#equality-source
expression_is_true (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#expression_is_true-source
recency (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#recency-source
at_least_one (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#at_least_one-source
not_constant (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#not_constant-source
not_empty_string (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#not_empty_string-source
cardinality_equality (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#cardinality_equality-source
not_null_proportion (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#not_null_proportion-source
not_accepted_values (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#not_accepted_values-source
relationships_where (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#relationships_where-source
mutually_exclusive_ranges (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#mutually_exclusive_ranges-source
sequential_values (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#sequential_values-source
unique_combination_of_columns (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#unique_combination_of_columns-source
accepted_range (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#accepted_range-source
Grouping in testshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#grouping-in-tests
Macroshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#macros
Introspective macroshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#introspective-macros
get_column_values (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_column_values-source
get_filtered_columns_in_relation (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_filtered_columns_in_relation-source
get_relations_by_pattern (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_relations_by_pattern-source
get_relations_by_prefix (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_relations_by_prefix-source
get_query_results_as_dict (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_query_results_as_dict-source
get_single_value (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_single_value-source
SQL generatorshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#sql-generators
date_spine (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#date_spine-source
deduplicate (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#deduplicate-source
haversine_distance (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#haversine_distance-source
group_by (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#group_by-source
star (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#star-source
union_relations (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#union_relations-source
generate_series (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#generate_series-source
generate_surrogate_key (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#generate_surrogate_key-source
safe_add (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#safe_add-source
safe_divide (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#safe_divide-source
safe_subtract (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#safe_subtract-source
pivot (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#pivot-source
unpivot (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#unpivot-source
width_bucket (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#width_bucket-source
Web macroshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#web-macros
get_url_parameter (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_url_parameter-source
get_url_host (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_url_host-source
get_url_path (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_url_path-source
Cross-database macroshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#cross-database-macros
Jinja Helpershttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#jinja-helpers
pretty_time (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#pretty_time-source
pretty_log_format (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#pretty_log_format-source
log_info (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#log_info-source
slugify (source)https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#slugify-source
Materializationshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#materializations
insert_by_periodhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#insert_by_period
Reporting bugs and contributing codehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#reporting-bugs-and-contributing-code
Dispatch macroshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#dispatch-macros
Getting started with dbthttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#getting-started-with-dbt
Code of Conducthttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#code-of-conduct
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#generic-tests
see informationhttps://docs.getdbt.com/reference/global-configs/behavior-changes#generic-test-arguments-property
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/equal_rowcount.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#equal_rowcount-source
Grouping in testshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#grouping-in-tests
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/fewer_rows_than.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#fewer_rows_than-source
Grouping in testshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#grouping-in-tests
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/equality.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#equality-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/expression_is_true.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#expression_is_true-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/recency.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#recency-source
Grouping in testshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#grouping-in-tests
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/at_least_one.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#at_least_one-source
Grouping in testshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#grouping-in-tests
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/not_constant.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#not_constant-source
Grouping in testshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#grouping-in-tests
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/not_empty_string.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#not_empty_string-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/cardinality_equality.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#cardinality_equality-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/not_null_proportion.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#not_null_proportion-source
Grouping in testshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#grouping-in-tests
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/not_accepted_values.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#not_accepted_values-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/relationships_where.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#relationships_where-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/mutually_exclusive_ranges.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#mutually_exclusive_ranges-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/sequential_values.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#sequential_values-source
Grouping in testshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#grouping-in-tests
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/unique_combination_of_columns.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#unique_combination_of_columns-source
surrogate_keyhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#generate_surrogate_key-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/generic_tests/accepted_range.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#accepted_range-source
a where argumenthttps://docs.getdbt.com/reference/resource-configs/where
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#grouping-in-tests
equal_rowcounthttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#equal_rowcount-source
fewer_rows_thanhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#fewer_rows_than-source
recencyhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#recency-source
at_least_onehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#at_least_one-source
not_constanthttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#not_constant-source
sequential_valueshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#sequential_values-source
not_null_proportionhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils#not_null_proportion-source
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#macros
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#introspective-macros
statement blockshttps://docs.getdbt.com/reference/dbt-jinja-functions/statement-blocks
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/get_column_values.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_column_values-source
relationhttps://docs.getdbt.com/docs/writing-code-in-dbt/class-reference/#relation
Relationhttps://docs.getdbt.com/reference/dbt-classes#relation
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/get_filtered_columns_in_relation.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_filtered_columns_in_relation-source
relationhttps://docs.getdbt.com/docs/writing-code-in-dbt/class-reference/#relation
adapter.get_columns_in_relation macrohttps://docs.getdbt.com/reference/dbt-jinja-functions/adapter#get_columns_in_relation
Relationhttps://docs.getdbt.com/reference/dbt-classes#relation
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/get_relations_by_pattern.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_relations_by_pattern-source
Relationshttps://docs.getdbt.com/docs/writing-code-in-dbt/class-reference/#relation
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/get_relations_by_prefix.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_relations_by_prefix-source
Relationshttps://docs.getdbt.com/docs/writing-code-in-dbt/class-reference/#relation
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/get_query_results_as_dict.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_query_results_as_dict-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/get_single_value.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_single_value-source
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#sql-generators
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/date_spine.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#date_spine-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/deduplicate.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#deduplicate-source
Relationhttps://docs.getdbt.com/reference/dbt-classes#relation
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/haversine_distance.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#haversine_distance-source
haversine distancehttps://en.wikipedia.org/wiki/Haversine_formula
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/groupby.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#group_by-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/star.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#star-source
Relationhttps://docs.getdbt.com/reference/dbt-classes#relation
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/union.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#union_relations-source
Relationshttps://docs.getdbt.com/docs/writing-code-in-dbt/class-reference/#relation
Relationshttps://docs.getdbt.com/docs/writing-code-in-dbt/class-reference/#relation
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/generate_series.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#generate_series-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/generate_surrogate_key.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#generate_surrogate_key-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/safe_add.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#safe_add-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/safe_divide.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#safe_divide-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/safe_subtract.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#safe_subtract-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/pivot.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#pivot-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/unpivot.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#unpivot-source
melthttp://pandas.pydata.org/pandas-docs/stable/generated/pandas.melt.html
Relationhttps://docs.getdbt.com/docs/writing-code-in-dbt/class-reference/#relation
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/sql/width_bucket.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#width_bucket-source
documentationhttps://docs.snowflake.net/manuals/sql-reference/functions/width_bucket.html
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#web-macros
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/web/get_url_parameter.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_url_parameter-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/web/get_url_host.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_url_host-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/web/get_url_path.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#get_url_path-source
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#cross-database-macros
https://docs.getdbt.com/reference/dbt-jinja-functions/cross-database-macroshttps://docs.getdbt.com/reference/dbt-jinja-functions/cross-database-macros
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#jinja-helpers
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/jinja_helpers/pretty_time.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#pretty_time-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/jinja_helpers/pretty_log_format.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#pretty_log_format-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/jinja_helpers/log_info.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#log_info-source
sourcehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/blob/main/macros/jinja_helpers/slugify.sql
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#slugify-source
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#materializations
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#insert_by_period
experimental features repositoryhttps://github.com/dbt-labs/dbt-labs-experimental-features/tree/main/insert_by_period
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#reporting-bugs-and-contributing-code
an issuehttps://github.com/dbt-labs/dbt-utils/issues/new
Contributing Guidehttps://github.com/dbt-labs/dbt-utils/blob/main/CONTRIBUTING.md
most PRs require an approved issue firsthttps://docs.getdbt.com/community/resources/oss-expectations#pull-requests
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#dispatch-macros
adapter pluginshttps://docs.getdbt.com/docs/available-adapters
adapter.dispatch()https://docs.getdbt.com/reference/dbt-jinja-functions/adapter#dispatch
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#getting-started-with-dbt
What is dbthttps://docs.getdbt.com/docs/introduction
dbt viewpointhttps://docs.getdbt.com/docs/about/viewpoint
Installationhttps://docs.getdbt.com/docs/get-started/getting-started/overview
chathttps://www.getdbt.com/community/
https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#code-of-conduct
PyPA Code of Conducthttps://www.pypa.io/en/latest/code-of-conduct/
hub.getdbt.com/dbt-labs/dbt_utils/latest/https://hub.getdbt.com/dbt-labs/dbt_utils/latest/
Readme https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#readme-ov-file
Apache-2.0 license https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#Apache-2.0-1-ov-file
Contributing https://patch-diff.githubusercontent.com/sixcodes/dbt-utils#contributing-ov-file
Please reload this pagehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils
Activityhttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/activity
Custom propertieshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/custom-properties
0 starshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/stargazers
0 watchinghttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/watchers
0 forkshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/forks
Report repository https://patch-diff.githubusercontent.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Fsixcodes%2Fdbt-utils&report=sixcodes+%28user%29
Releaseshttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils/releases
76 tags https://patch-diff.githubusercontent.com/sixcodes/dbt-utils/tags
Packages 0https://patch-diff.githubusercontent.com/orgs/sixcodes/packages?repo_name=dbt-utils
Please reload this pagehttps://patch-diff.githubusercontent.com/sixcodes/dbt-utils
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.