dbt-utils:dbt 项目的实用函数
这个包包含可以在 dbt 项目中（重新）使用的宏。
安装说明
检查以获取最新的安装说明，或以获取有关安装软件包的更多信息。
内容
互斥范围
unique_combination_of_columns
宏
内省宏：
get_column_values
get_relations_by_pattern
get_relations_by_prefix
get_query_results_as_dict
SQL 生成器
日期_脊椎
半正弦距离
通过...分组
星星
union_relations
生成系列
surrogate_key
安全添加
枢
转轴
网页宏
获取网址参数
get_url_host
get_url_path
跨数据库宏：
当前_时间戳
添加日期
日期差异
split_part
最后一天
width_bucket
记录器
漂亮时间
漂亮日志格式
日志信息
文件下载
资源详情
[{"title":"（ 212 个子文件 137KB ） dbt-utils:dbt 项目的实用函数","children":[{"title":"CODEOWNERS <span style='color:#111;'> 16B </span>","children":null,"spread":false},{"title":"data_people.csv <span style='color:#111;'> 7.88KB </span>","children":null,"spread":false},{"title":"data_datediff.csv <span style='color:#111;'> 572B </span>","children":null,"spread":false},{"title":"data_url_path.csv <span style='color:#111;'> 484B </span>","children":null,"spread":false},{"title":"data_width_bucket.csv <span style='color:#111;'> 399B </span>","children":null,"spread":false},{"title":"data_surrogate_key.csv <span style='color:#111;'> 353B </span>","children":null,"spread":false},{"title":"data_unpivot_bool_expected.csv <span style='color:#111;'> 300B </span>","children":null,"spread":false},{"title":"data_unpivot_original_api_expected.csv <span style='color:#111;'> 298B </span>","children":null,"spread":false},{"title":"data_url_host.csv <span style='color:#111;'> 270B </span>","children":null,"spread":false},{"title":"data_unpivot_expected.csv <span style='color:#111;'> 246B </span>","children":null,"spread":false},{"title":"data_dateadd.csv <span style='color:#111;'> 238B </span>","children":null,"spread":false},{"title":"data_test_mutually_exclusive_ranges_with_gaps_zero_length.csv <span style='color:#111;'> 179B </span>","children":null,"spread":false},{"title":"data_unique_combination_of_columns.csv <span style='color:#111;'> 162B </span>","children":null,"spread":false},{"title":"data_hash.csv <span style='color:#111;'> 156B </span>","children":null,"spread":false},{"title":"data_unpivot.csv <span style='color:#111;'> 152B </span>","children":null,"spread":false},{"title":"data_urls.csv <span style='color:#111;'> 152B </span>","children":null,"spread":false},{"title":"data_unpivot_bool.csv <span style='color:#111;'> 149B </span>","children":null,"spread":false},{"title":"data_insert_by_period.csv <span style='color:#111;'> 131B </span>","children":null,"spread":false},{"title":"data_test_mutually_exclusive_ranges_with_gaps.csv <span style='color:#111;'> 122B </span>","children":null,"spread":false},{"title":"data_last_day.csv <span style='color:#111;'> 119B </span>","children":null,"spread":false},{"title":"data_date_spine.csv <span style='color:#111;'> 107B </span>","children":null,"spread":false},{"title":"data_union_expected.csv <span style='color:#111;'> 102B </span>","children":null,"spread":false},{"title":"data_right.csv <span style='color:#111;'> 94B </span>","children":null,"spread":false},{"title":"data_replace.csv <span style='color:#111;'> 93B </span>","children":null,"spread":false},{"title":"data_position.csv <span style='color:#111;'> 92B </span>","children":null,"spread":false},{"title":"data_test_sequential_timestamps.csv <span style='color:#111;'> 81B </span>","children":null,"spread":false},{"title":"data_split_part.csv <span style='color:#111;'> 76B </span>","children":null,"spread":false},{"title":"data_haversine_km.csv <span style='color:#111;'> 73B </span>","children":null,"spread":false},{"title":"data_haversine_mi.csv <span style='color:#111;'> 73B </span>","children":null,"spread":false},{"title":"data_length.csv <span style='color:#111;'> 71B </span>","children":null,"spread":false},{"title":"data_date_trunc.csv <span style='color:#111;'> 66B </span>","children":null,"spread":false},{"title":"data_union_events_expected.csv <span style='color:#111;'> 59B </span>","children":null,"spread":false},{"title":"data_safe_add.csv <span style='color:#111;'> 59B </span>","children":null,"spread":false},{"title":"data_union_table_2.csv <span style='color:#111;'> 54B </span>","children":null,"spread":false},{"title":"data_union_table_1.csv <span style='color:#111;'> 52B </span>","children":null,"spread":false},{"title":"data_test_not_accepted_values.csv <span style='color:#111;'> 48B </span>","children":null,"spread":false},{"title":"data_nullcheck_table.csv <span style='color:#111;'> 46B </span>","children":null,"spread":false},{"title":"data_concat.csv <span style='color:#111;'> 43B </span>","children":null,"spread":false},{"title":"data_get_query_results_as_dict.csv <span style='color:#111;'> 42B </span>","children":null,"spread":false},{"title":"data_star.csv <span style='color:#111;'> 42B </span>","children":null,"spread":false},{"title":"data_test_not_null_where.csv <span style='color:#111;'> 42B </span>","children":null,"spread":false},{"title":"data_test_unique_where.csv <span style='color:#111;'> 41B </span>","children":null,"spread":false},{"title":"data_generate_series.csv <span style='color:#111;'> 38B </span>","children":null,"spread":false},{"title":"data_cardinality_equality_b.csv <span style='color:#111;'> 36B </span>","children":null,"spread":false},{"title":"data_test_mutually_exclusive_ranges_no_gaps.csv <span style='color:#111;'> 36B </span>","children":null,"spread":false},{"title":"data_safe_cast.csv <span style='color:#111;'> 31B </span>","children":null,"spread":false},{"title":"data_pivot.csv <span style='color:#111;'> 30B </span>","children":null,"spread":false},{"title":"data_events_20180101.csv <span style='color:#111;'> 29B </span>","children":null,"spread":false},{"title":"data_events_20180102.csv <span style='color:#111;'> 29B </span>","children":null,"spread":false},{"title":"data_events_20180103.csv <span style='color:#111;'> 29B </span>","children":null,"spread":false},{"title":"data_get_column_values.csv <span style='color:#111;'> 28B </span>","children":null,"spread":false},{"title":"data_star_expected.csv <span style='color:#111;'> 28B </span>","children":null,"spread":false},{"title":"data_test_expression_is_true.csv <span style='color:#111;'> 28B </span>","children":null,"spread":false},{"title":"data_test_sequential_values.csv <span style='color:#111;'> 28B </span>","children":null,"spread":false},{"title":"data_pivot_expected.csv <span style='color:#111;'> 26B </span>","children":null,"spread":false},{"title":"data_cardinality_equality_a.csv <span style='color:#111;'> 15B </span>","children":null,"spread":false},{"title":"data_test_fewer_rows_than_table_2.csv <span style='color:#111;'> 14B </span>","children":null,"spread":false},{"title":"data_test_equal_rowcount.csv <span style='color:#111;'> 12B </span>","children":null,"spread":false},{"title":"data_test_fewer_rows_than_table_1.csv <span style='color:#111;'> 12B </span>","children":null,"spread":false},{"title":"data_test_not_constant.csv <span style='color:#111;'> 12B </span>","children":null,"spread":false},{"title":"data_test_relationships_where_table_2.csv <span style='color:#111;'> 9B </span>","children":null,"spread":false},{"title":"data_test_relationships_where_table_1.csv <span style='color:#111;'> 9B </span>","children":null,"spread":false},{"title":"data_test_at_least_one.csv <span style='color:#111;'> 8B </span>","children":null,"spread":false},{"title":"data_test_accepted_range.csv <span style='color:#111;'> 8B </span>","children":null,"spread":false},{"title":"data_cast_bool_to_text <span style='color:#111;'> 29B </span>","children":null,"spread":false},{"title":"snowflake.env <span style='color:#111;'> 149B </span>","children":null,"spread":false},{"title":"postgres.env <span style='color:#111;'> 95B </span>","children":null,"spread":false},{"title":"redshift.env <span style='color:#111;'> 89B </span>","children":null,"spread":false},{"title":"bigquery.env <span style='color:#111;'> 24B </span>","children":null,"spread":false},{"title":".gitignore <span style='color:#111;'> 33B </span>","children":null,"spread":false},{"title":".gitignore <span style='color:#111;'> 28B </span>","children":null,"spread":false},{"title":".gitkeep <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":".gitkeep <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"LICENSE <span style='color:#111;'> 11.09KB </span>","children":null,"spread":false},{"title":"Makefile <span style='color:#111;'> 316B </span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'> 38.87KB </span>","children":null,"spread":false},{"title":"CHANGELOG.md <span style='color:#111;'> 10.13KB </span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'> 2.05KB </span>","children":null,"spread":false},{"title":"utils_minor_release.md <span style='color:#111;'> 1.99KB </span>","children":null,"spread":false},{"title":"RELEASE.md <span style='color:#111;'> 1.80KB </span>","children":null,"spread":false},{"title":"bug_report.md <span style='color:#111;'> 1.32KB </span>","children":null,"spread":false},{"title":"dbt_minor_release.md <span style='color:#111;'> 1.22KB </span>","children":null,"spread":false},{"title":"pull_request_template.md <span style='color:#111;'> 1011B </span>","children":null,"spread":false},{"title":"feature_request.md <span style='color:#111;'> 813B </span>","children":null,"spread":false},{"title":"dbt-logo.png <span style='color:#111;'> 17.95KB </span>","children":null,"spread":false},{"title":"run_test.sh <span style='color:#111;'> 691B </span>","children":null,"spread":false},{"title":"insert_by_period_materialization.sql <span style='color:#111;'> 7.62KB </span>","children":null,"spread":false},{"title":"mutually_exclusive_ranges.sql <span style='color:#111;'> 3.47KB </span>","children":null,"spread":false},{"title":"union.sql <span style='color:#111;'> 3.16KB </span>","children":null,"spread":false},{"title":"datediff.sql <span style='color:#111;'> 3.13KB </span>","children":null,"spread":false},{"title":"unpivot.sql <span style='color:#111;'> 3.08KB </span>","children":null,"spread":false},{"title":"pivot.sql <span style='color:#111;'> 2.43KB </span>","children":null,"spread":false},{"title":"assert_get_query_results_as_dict_objects_equal.sql <span style='color:#111;'> 2.43KB </span>","children":null,"spread":false},{"title":"get_tables_by_pattern_sql.sql <span style='color:#111;'> 2.42KB </span>","children":null,"spread":false},{"title":"test_datediff.sql <span style='color:#111;'> 2.25KB </span>","children":null,"spread":false},{"title":"datatypes.sql <span style='color:#111;'> 1.92KB </span>","children":null,"spread":false},{"title":"haversine_distance.sql <span style='color:#111;'> 1.82KB </span>","children":null,"spread":false},{"title":"get_column_values.sql <span style='color:#111;'> 1.80KB </span>","children":null,"spread":false},{"title":"width_bucket.sql <span style='color:#111;'> 1.80KB </span>","children":null,"spread":false},{"title":"equality.sql <span style='color:#111;'> 1.72KB </span>","children":null,"spread":false},{"title":"......","children":null,"spread":false},{"title":"<span style='color:steelblue;'>文件过多，未全部展示</span>","children":null,"spread":false}],"spread":true}]
评论信息
其他资源
- ALINX.ZYNQ7010开发板用户手册
- Verilog实现PHY芯片读写功能MDIO接口工程文件
- 点云边缘提取MATLAB
- mfc数据库图书管理系统
- 注意细节！让你的软著申请少走弯路
- C++广义表的创建、输出、取表头、取表尾、广义表深度
- Easy Python Decompiler v1.3.2
- CRC32 MATLAB代码
- 某校园园区网络规划与实施
- PMP第六版工具技术合集（最终版）.pdf-其它文档类资源
- 2020综艺市场网播表现.pdf
- kafka-clients-2.5.0.jar
- Docker实战文档.pdf
- Python-subpixel利用Tensorflow的一个子像素卷积神经网络
- 有说明有代码：投票器的原理和设计(33页)
- 应用数理统计(第二版) 研究生教学用书 ppt 课件
- 小程序实现搜索功能
- Javascript动态网页（实例版）
- PLECS STATCOM
- 虾米音乐批量收藏歌单歌曲(接口已更改,请勿下载)
免责申明
【只为小站】的资源来自网友分享，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论 【只为小站】 经营者是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明