关于“使用 Knowledge Catalog 进行数据质量评估”的评价

Чорновус І. · 已于 over 1 year前审核

Siddhartha D. · 已于 over 1 year前审核

Swathi S. · 已于 over 1 year前审核

Emilio P. · 已于 over 1 year前审核

Swathi S. · 已于 over 1 year前审核

WITH zero_record AS ( SELECT 'VALID_CUSTOMER' AS rule_binding_id, ), data AS ( SELECT *, 'VALID_CUSTOMER' AS rule_binding_id, FROM `qwiklabs-gcp-03-4c641d5a96a0.customers.contact_info` d WHERE True ), last_mod AS ( SELECT project_id || '.' || dataset_id || '.' || table_id AS _internal_table_id, TIMESTAMP_MILLIS(last_modified_time) AS last_modified FROM `qwiklabs-gcp-03-4c641d5a96a0.customers.__TABLES__` ), validation_results AS (SELECT 'VALID_CUSTOMER' AS rule_binding_id, 'NOT_NULL' AS _internal_rule_id, 'qwiklabs-gcp-03-4c641d5a96a0.customers.contact_info' AS _internal_table_id, 'id' AS _internal_column_id, data.id AS _internal_column_value, 'COMPLETENESS' AS _internal_dimension, CASE WHEN id IS NOT NULL THEN TRUE ELSE FALSE END AS _internal_simple_rule_row_is_valid, TRUE AS _internal_skip_null_count, CAST(NULL AS INT64) AS complex_rule_validation_errors_count, CAST(NULL AS BOOLEAN) AS _internal_complex_rule_validation_success_flag, FROM zero_record LEFT JOIN data ON zero_record.rule_binding_id = data.rule_binding_id ), all_validation_results AS ( SELECT '653caabd-7542-4568-8e7e-18a03248d86e' as _dq_validation_invocation_id, r.rule_binding_id AS _dq_validation_rule_binding_id, r._internal_rule_id AS _dq_validation_rule_id, r._internal_column_id AS _dq_validation_column_id, r._internal_column_value AS _dq_validation_column_value, CAST(r._internal_dimension AS STRING) AS _dq_validation_dimension, r._internal_simple_rule_row_is_valid AS _dq_validation_simple_rule_row_is_valid, r.complex_rule_validation_errors_count AS _dq_validation_complex_rule_validation_errors_count, r._internal_complex_rule_validation_success_flag AS _dq_validation_complex_rule_validation_success_flag, FROM validation_results r ) SELECT * FROM all_validation_results WHERE _dq_validation_simple_rule_row_is_valid is False OR _dq_validation_complex_rule_validation_success_flag is False ORDER BY _dq_validation_rule_id

Tiến Dũng Đ. · 已于 over 1 year前审核

Annisa Q. · 已于 over 1 year前审核

last step would not complete - I ran that query may times

Trent M. · 已于 over 1 year前审核

Antonio G. · 已于 over 1 year前审核

Marina Esther C. · 已于 over 1 year前审核

T A. · 已于 over 1 year前审核

Mahulima M. · 已于 over 1 year前审核

Santhra M. · 已于 over 1 year前审核

Priya G. · 已于 over 1 year前审核

Swathi S. · 已于 over 1 year前审核

hamza j. · 已于 over 1 year前审核

Sathish M. · 已于 over 1 year前审核

Kristian B. · 已于 over 1 year前审核

Sonali R. · 已于 over 1 year前审核

Parthasarathy R. · 已于 over 1 year前审核

Atul G. · 已于 over 1 year前审核

Gabriel G. · 已于 over 1 year前审核

SOUMYA RANJAN P. · 已于 over 1 year前审核

Siddhant S. · 已于 over 1 year前审核

Ramkumar J. · 已于 over 1 year前审核