dbt-utils:dbt 项目的实用函数

上传者: 42107165 | 上传时间: 2024-07-18 09:30:11 | 文件大小: 137KB | 文件类型: ZIP
这个包包含可以在 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}]

评论信息

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明