ores.sql.populate.methodology
Table of Contents
Dataset methodologies ({{#methodologies}}: name, description, steps, url) documenting how each dataset was produced.
See the Template variable reference for the complete list of available variables and their semantics.
1. Template
The full template source. Edit here and re-tangle with
compass build --direct tangle_codegen_templates to regenerate
library/templates/sql_methodology_populate.mustache.
{{! GENERATED FILE — tangled from projects/ores.codegen/library/templates/sql_populate.org. Edit the org source. }}
{{! Template to generate SQL with enhanced GPL v3 license and methodology data }}
{{{sql_license}}}
/*
* AUTO-GENERATED FILE - DO NOT EDIT MANUALLY
* Template: sql_methodology_populate.mustache
* To modify, update the template and regenerate.
*/
-- =============================================================================
-- Data Quality {{model_name}} Methodologies
-- =============================================================================
\echo '--- Data Quality {{model_name}} Methodologies ---'
{{#methodologies}}
select ores_dq_methodologies_upsert_fn(ores_utility_system_tenant_id_fn(),
'{{name}}',
'{{description}}',
'{{url}}',
'{{{steps}}}'
);
{{/methodologies}}
-- =============================================================================
-- Summary
-- =============================================================================
\echo ''
\echo '--- Summary ---'
select 'Data Quality Total Methodologies' as entity, count(*) as count
from ores_dq_methodologies_tbl where valid_to = ores_utility_infinity_timestamp_fn()
order by entity;
2. See also
- Parent facet: ores.sql.populate
- Template variable reference