{"help": "https://ckan.francedatareseau.fr/fr/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "b7da96b3-869d-43a5-8673-d0f2cee61642", "total_estimation_threshold": null, "records": [{"_id":1,"name":"meta_indicators_by_type","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":1,"node_json":"{\"alias\": \"meta_indicators_by_type\", \"build_path\": null, \"checksum\": {\"checksum\": \"e40d7d9c3128fdd6d4279fa119026355a253348d7c773d9772ccaa174ce15119\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"table\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647361957.4646513, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": [\"model.fdr_appuiscommuns.meta_indicators\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"meta_indicators_by_type\"], \"meta\": {}, \"name\": \"meta_indicators_by_type\", \"original_file_path\": \"models/meta_indicators_by_type.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"meta_indicators_by_type.sql\", \"raw_sql\": \"{#\\n | selectattr(\\\"resource_type\\\", \\\"equalto\\\", \\\"model\\\")\\n \\n , \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"definition\\\") | join() | replace(\\\"definition\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"dictionary\\\") | join() | replace(\\\"dictionary\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"normalization\\\") | join() | replace(\\\"normalization\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"sample\\\") | join() | replace(\\\"sample\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"expected\\\") | join() | replace(\\\"expected\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"unification\\\") | join() | replace(\\\"unification\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"enriched\\\") | join() | replace(\\\"enriched\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"indicators\\\") | join() | replace(\\\"indicators\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\n is_definition, is_dictionary,\\n is_normalization/*transformation*/, is_sample/*extract*/, /*is_test unittest*/is_expected,\\n is_unification, is_enriched,\\n is_indicators/*agg by*/,\\n \\n , is_definition, is_dictionary,\\n is_normalization/*transformation*/, is_sample/*extract*/, /*is_test unittest*/is_expected,\\n is_unification, is_enriched,\\n is_indicators,\\n#}\\n\\n-- depends_on: {{ ref(\\u0027meta_indicators\\u0027) }}\\n{% if execute %}\\n{% set tags = [\\\"definition\\\", \\\"dictionary\\\", \\\"normalization\\\", \\\"sample\\\", \\\"expected\\\", \\\"unification\\\", \\\"enriched\\\", \\\"indicators\\\"] %}\\n{% set use_case = \\u0027appuiscommuns\\u0027 %}\\nwith grouped as (\\n select\\n use_case, type,\\n {% for tag in tags %}\\n sum({{ tag }}) as {{ tag }}\\n {% if not loop.last %}\\n ,\\n {% endif %}\\n {% endfor %}\\n \\n from {{ ref(\\u0027meta_indicators\\u0027) }} group by use_case, type\\n)\\n\\nselect * from grouped\\n{% endif %}\\n\\n/*\\n Example output\\n---------------------------------------------------------------\\n...\\n*/\", \"refs\": [[\"meta_indicators\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.meta_indicators_by_type\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"table\"}}"},{"_id":2,"name":"appuiscommuns_supportaerien__definition","use_case":"appuiscommuns","type":"supportaerien","definition":1,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"appuiscommuns_supportaerien__definition\", \"build_path\": null, \"checksum\": {\"checksum\": \"187b2ea9da718679b83585c4ab27afe5d9ded7e6715d73e2200dba5023cb1816\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"table\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647361957.578713, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [\"macro.dbt_utils.star\"], \"nodes\": [\"model.fdr_appuiscommuns.appuiscommuns_supportaerien__example_stg\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien__example_stg\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"source\", \"appuiscommuns_supportaerien__definition\"], \"meta\": {}, \"name\": \"appuiscommuns_supportaerien__definition\", \"original_file_path\": \"models/source/appuiscommuns_supportaerien__definition.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"source/appuiscommuns_supportaerien__definition.sql\", \"raw_sql\": \"{#\\nDefinition / interface\\n- with the proper column types (thanks to _example_stg),\\n- but without any data (to allow to use to define columns in sql ex. as first in union)\\n\\nMaterialized as table because of these uses.\\n#}\\n\\n{% set containerUrl = \\u0027http://\\u0027 + \\u0027datalake.francedatareseau.fr\\u0027 %}\\n{% set typeUrlPrefix = containerUrl + \\u0027/dc/type/\\u0027 %}\\n{% set type = \\u0027appuiscommuns_supportaerien_osmgeodatamine_powersupports_extract\\u0027 %} -- sp\\u00e9cifique \\u00e0 la source ; _2021 ? from this file ? prefix:typeName ?\\n{% set type = \\u0027appuiscommuns_supportaerien\\u0027 %} -- _2021 ? from this file ? prefix:typeName ?\\n{% set ns = \\u0027supportaerien.appuiscommuns.francedatareseau.fr\\u0027 %} -- ?\\n{% set typeName = \\u0027SupportAerien\\u0027 %}\\n{% set sourcePrefix = \\u0027osmpowersupports\\u0027 %} -- ?\\n{% set prefix = \\u0027appuiscommunssupp\\u0027 %} -- ?\\n{% set sourceFieldPrefix = sourcePrefix + \\u0027:\\u0027 %}\\n{% set sourceFieldPrefix = sourcePrefix + \\u0027__\\u0027 %}\\n{% set fieldPrefix = prefix + \\u0027:\\u0027 %}\\n{% set fieldPrefix = prefix + \\u0027__\\u0027 %}\\n{% set idUrlPrefix = typeUrlPrefix + type + \\u0027/\\u0027 %}\\n\\n{{\\n config(\\n materialized=\\\"table\\\"\\n )\\n}}\\n\\nselect\\n {{ dbt_utils.star(ref(\\u0027appuiscommuns_supportaerien__example_stg\\u0027)) }}\\n \\n from {{ ref(\\u0027appuiscommuns_supportaerien__example_stg\\u0027) }} -- TODO raw_\\n limit 0\", \"refs\": [[\"appuiscommuns_supportaerien__example_stg\"], [\"appuiscommuns_supportaerien__example_stg\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.appuiscommuns_supportaerien__definition\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"table\"}}"},{"_id":3,"name":"osm_powersupports__supportaerien__expected_stg","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":1,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"osm_powersupports__supportaerien__expected_stg\", \"build_path\": null, \"checksum\": {\"checksum\": \"83bbfb2ff987521a91d1a50e202c6d0f4239ce031504ab5403597848d71c261e\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"view\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": [\"expected\", \"test\"]}, \"created_at\": 1647361957.8381214, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [\"macro.dbt_utils.star\"], \"nodes\": [\"seed.fdr_appuiscommuns.osm_powersupports__supportaerien__expected\", \"seed.fdr_appuiscommuns.osm_powersupports__supportaerien__expected\"]}, \"description\": \"test unitaire en --target test de transformation (normalisation) : attendu pr\\u00e9par\\u00e9 portant la d\\u00e9finition du test unitaire et permettant de la d\\u00e9sactiver\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"source\", \"osm_powersupports__supportaerien__expected_stg\"], \"meta\": {}, \"name\": \"osm_powersupports__supportaerien__expected_stg\", \"original_file_path\": \"models/source/osm_powersupports__supportaerien__expected_stg.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": \"fdr_appuiscommuns://models/appuiscommuns_schema.yml\", \"path\": \"source/osm_powersupports__supportaerien__expected_stg.sql\", \"raw_sql\": \"{#\\nParsing de l\\u0027attendu _expected du test unitaire de normalization\\n#}\\n\\n{% set containerUrl = \\u0027http://\\u0027 + \\u0027datalake.francedatareseau.fr\\u0027 %}\\n{% set typeUrlPrefix = containerUrl + \\u0027/dc/type/\\u0027 %}\\n{% set type = \\u0027appuiscommuns_supportaerien_osmgeodatamine_powersupports_extract\\u0027 %} -- sp\\u00e9cifique \\u00e0 la source ; _2021 ? from this file ? prefix:typeName ?\\n{% set type = \\u0027appuiscommuns_supportaerien\\u0027 %} -- _2021 ? from this file ? prefix:typeName ?\\n{% set ns = \\u0027supportaerien.appuiscommuns.francedatareseau.fr\\u0027 %} -- ?\\n{% set typeName = \\u0027SupportAerien\\u0027 %}\\n{% set sourcePrefix = \\u0027osmpowersupports\\u0027 %} -- ?\\n{% set prefix = \\u0027appuiscommunssupp\\u0027 %} -- ?\\n{% set sourceFieldPrefix = sourcePrefix + \\u0027:\\u0027 %}\\n{% set sourceFieldPrefix = sourcePrefix + \\u0027__\\u0027 %}\\n{% set fieldPrefix = prefix + \\u0027:\\u0027 %}\\n{% set fieldPrefix = prefix + \\u0027__\\u0027 %}\\n{% set idUrlPrefix = typeUrlPrefix + type + \\u0027/\\u0027 %}\\n\\n{# __expected and NOT __definition else also asks for the fields not provided by this source #}\\nselect\\n {{ dbt_utils.star(ref(\\u0027osm_powersupports__supportaerien__expected\\u0027),\\n except=[fieldPrefix + \\u0027Id\\u0027, \\u0027geometry\\u0027]) }},\\n \\\"{{ fieldPrefix }}Id\\\"::uuid as \\\"{{ fieldPrefix }}Id\\\",\\n ST_GeomFROMText(geometry, 4326) as geometry -- NOT ::geometry else not the same (srid ?? only visible in binary ::text form : ) therefore except does not work\\n -- 0101000000197B8A77DBE0E33F18C25725ECC34740 expected\\n -- 0101000020E6100000197B8A77DBE0E33F18C25725ECC34740 actual\\n -- TODO rm :\\n ----\\u0027\\\"datastore\\\".\\\"appuiscommuns\\\".\\\"osmgeodatamine_powsupp__appuiscommuns_supportaerien\\\"\\u0027 as _dbt_source_relation,\\n --appuiscommunssupp__fdrcommune__insee_id as appuiscommunssupp__commune_insee_id,\\n ----appuiscommunssupp__fdrcommune__insee_id as fdrcommune__insee_id\\n --appuiscommunssupp__fdrcommune__nom as appuiscommunssupp__commune_nom\\n \\n from {{ ref(\\u0027osm_powersupports__supportaerien__expected\\u0027) }} -- TODO raw_\", \"refs\": [[\"osm_powersupports__supportaerien__expected\"], [\"osm_powersupports__supportaerien__expected\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [\"expected\", \"test\"], \"unique_id\": \"model.fdr_appuiscommuns.osm_powersupports__supportaerien__expected_stg\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"view\"}}"},{"_id":4,"name":"appuiscommuns_supportaerien__example_stg","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"appuiscommuns_supportaerien__example_stg\", \"build_path\": null, \"checksum\": {\"checksum\": \"d1eb0f085b2288e2127ec40e987f3e4fcd0f7731df4c2b883aca22c4fa125f7f\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"view\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647361957.603345, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [\"macro.dbt_utils.star\"], \"nodes\": [\"seed.fdr_appuiscommuns.appuiscommuns_supportaerien__example\", \"seed.fdr_appuiscommuns.appuiscommuns_supportaerien__example\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"source\", \"appuiscommuns_supportaerien__example_stg\"], \"meta\": {}, \"name\": \"appuiscommuns_supportaerien__example_stg\", \"original_file_path\": \"models/source/appuiscommuns_supportaerien__example_stg.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"source/appuiscommuns_supportaerien__example_stg.sql\", \"raw_sql\": \"{#\\nParsing of a priori (made-up), covering examples of the definition / interface.\\nExamples have to be **as representative** of all possible data as possible because they are also the basis of the definition.\\nFor instance, for a commune INSEE id field, they should also include a non-integer value such as 2A035 (Belv\\u00e9d\\u00e8re-Campomoro).\\nMethodology :\\n1. copy the first line(s) from the specification document\\n2. add line(s) to contain further values for until they are covering for all columns\\n3. NB. examples specific to each source type are provided in _source_example along their implementation (for which they are covering)\\n\\n#}\\n\\n{% set containerUrl = \\u0027http://\\u0027 + \\u0027datalake.francedatareseau.fr\\u0027 %}\\n{% set typeUrlPrefix = containerUrl + \\u0027/dc/type/\\u0027 %}\\n{% set type = \\u0027appuiscommuns_supportaerien_osmgeodatamine_powersupports_extract\\u0027 %} -- sp\\u00e9cifique \\u00e0 la source ; _2021 ? from this file ? prefix:typeName ?\\n{% set type = \\u0027appuiscommuns_supportaerien\\u0027 %} -- _2021 ? from this file ? prefix:typeName ?\\n{% set ns = \\u0027supportaerien.appuiscommuns.francedatareseau.fr\\u0027 %} -- ?\\n{% set typeName = \\u0027SupportAerien\\u0027 %}\\n{% set sourcePrefix = \\u0027osmpowersupports\\u0027 %} -- ?\\n{% set prefix = \\u0027appuiscommunssupp\\u0027 %} -- ?\\n{% set sourceFieldPrefix = sourcePrefix + \\u0027:\\u0027 %}\\n{% set sourceFieldPrefix = sourcePrefix + \\u0027__\\u0027 %}\\n{% set fieldPrefix = prefix + \\u0027:\\u0027 %}\\n{% set fieldPrefix = prefix + \\u0027__\\u0027 %}\\n{% set idUrlPrefix = typeUrlPrefix + type + \\u0027/\\u0027 %}\\n\\nselect\\n {{ dbt_utils.star(ref(\\u0027appuiscommuns_supportaerien__example\\u0027),\\n except=[fieldPrefix + \\u0027Id\\u0027, \\u0027geometry\\u0027]) }},\\n \\\"{{ fieldPrefix }}Id\\\"::uuid as \\\"{{ fieldPrefix }}Id\\\",\\n ST_GeomFROMText(geometry, 4326) as geometry -- NOT ::geometry else not the same (srid ?? only visible in binary ::text form : ) therefore except does not work\\n -- 0101000000197B8A77DBE0E33F18C25725ECC34740 expected\\n -- 0101000020E6100000197B8A77DBE0E33F18C25725ECC34740 actual\\n -- TODO rm :\\n ----\\u0027\\\"datastore\\\".\\\"appuiscommuns\\\".\\\"osmgeodatamine_powsupp__appuiscommuns_supportaerien\\\"\\u0027 as _dbt_source_relation,\\n --appuiscommunssupp__fdrcommune__insee_id as appuiscommunssupp__commune_insee_id,\\n ----appuiscommunssupp__fdrcommune__insee_id as fdrcommune__insee_id\\n --appuiscommunssupp__fdrcommune__nom as appuiscommunssupp__commune_nom\\n \\n from {{ ref(\\u0027appuiscommuns_supportaerien__example\\u0027) }} -- TODO raw_\", \"refs\": [[\"appuiscommuns_supportaerien__example\"], [\"appuiscommuns_supportaerien__example\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.appuiscommuns_supportaerien__example_stg\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"view\"}}"},{"_id":5,"name":"l_appuisaeriens_materiau","use_case":"appuiscommuns","type":"","definition":0,"dictionary":1,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"l_appuisaeriens_materiau\", \"build_path\": null, \"checksum\": {\"checksum\": \"da865a60c0efb54991a7e6a7def2c53d72eebdbefd7007c8e3a27c3712a5e19b\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": [\"dictionary\"]}, \"created_at\": 1647361957.9725263, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"liste de valeurs possibles pour le champ\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"l_appuisaeriens_materiau\"], \"meta\": {}, \"name\": \"l_appuisaeriens_materiau\", \"original_file_path\": \"seeds/l_appuisaeriens_materiau.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": \"fdr_appuiscommuns://models/appuiscommuns_schema.yml\", \"path\": \"l_appuisaeriens_materiau.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [\"dictionary\"], \"unique_id\": \"seed.fdr_appuiscommuns.l_appuisaeriens_materiau\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":6,"name":"l_appuisaeriens_naturetraverse","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"l_appuisaeriens_naturetraverse\", \"build_path\": null, \"checksum\": {\"checksum\": \"3ac213f3a9fb82985ee26e08f83fde187c839d6c0c0552412a3d5493d7198f99\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647361957.7606583, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"l_appuisaeriens_naturetraverse\"], \"meta\": {}, \"name\": \"l_appuisaeriens_naturetraverse\", \"original_file_path\": \"seeds/l_appuisaeriens_naturetraverse.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"l_appuisaeriens_naturetraverse.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"seed.fdr_appuiscommuns.l_appuisaeriens_naturetraverse\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":7,"name":"l_appuisaeriens_equipements","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"l_appuisaeriens_equipements\", \"build_path\": null, \"checksum\": {\"checksum\": \"491809a512cdb0c12989f1a962e51de8645e8bb076756013daa17f17bd225700\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647361957.762394, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"l_appuisaeriens_equipements\"], \"meta\": {}, \"name\": \"l_appuisaeriens_equipements\", \"original_file_path\": \"seeds/l_appuisaeriens_equipements.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"l_appuisaeriens_equipements.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"seed.fdr_appuiscommuns.l_appuisaeriens_equipements\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":8,"name":"osmgeodatamine_powersupports_extract","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":1,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"osmgeodatamine_powersupports_extract\", \"build_path\": null, \"checksum\": {\"checksum\": \"b9965dba85982aca58a48584e15599b72995d9f02dc95f627d9a5ea31c62907e\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {\"com_insee\": \"text\"}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": [\"sample\", \"extract\"]}, \"created_at\": 1647361957.968055, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"extrait repr\\u00e9sentatif des donn\\u00e9es de la source (type) osmgeodatamine_powersupports\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"osmgeodatamine_powersupports_extract\"], \"meta\": {}, \"name\": \"osmgeodatamine_powersupports_extract\", \"original_file_path\": \"seeds/osmgeodatamine_powersupports_extract.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": \"fdr_appuiscommuns://models/appuiscommuns_schema.yml\", \"path\": \"osmgeodatamine_powersupports_extract.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [\"sample\", \"extract\"], \"unique_id\": \"seed.fdr_appuiscommuns.osmgeodatamine_powersupports_extract\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":9,"name":"l_appuisaeriens_precision","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"l_appuisaeriens_precision\", \"build_path\": null, \"checksum\": {\"checksum\": \"34a0103c319ada48cfbcfafbdc4acf8c60df282961f241259521beb35b8f0228\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647361957.7657506, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"l_appuisaeriens_precision\"], \"meta\": {}, \"name\": \"l_appuisaeriens_precision\", \"original_file_path\": \"seeds/l_appuisaeriens_precision.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"l_appuisaeriens_precision.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"seed.fdr_appuiscommuns.l_appuisaeriens_precision\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":10,"name":"appuiscommuns_supportaerien__example","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"appuiscommuns_supportaerien__example\", \"build_path\": null, \"checksum\": {\"checksum\": \"7dfabe053c6732cb08d4e351fbae9544393d8e27dea9537391b7fab9a177de6b\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {\"type\": \"supportaerien\"}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": [\"example\"]}, \"created_at\": 1647361957.9654348, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"Parsing of a priori (made-up), covering examples of the definition / interface. Examples have to be **as representative** of all possible data as possible because they are also the basis of the definition. For instance, for a commune INSEE id field, they should also include a non-integer value such as 2A035 (Belv\\u00e9d\\u00e8re-Campomoro). Methodology : 1. copy the first line(s) from the specification document (pour l\\u0027instant copi\\u00e9 manuellement depuis le Gitbook, \\u00e0 terme pourrait g\\u00e9n\\u00e9rer ce dernier voire un m\\u00e9tamod\\u00e8le guidant l\\u0027outillage) 2. add line(s) to contain further values for until they are covering for all columns 3. NB. examples specific to each source type are provided in _source_example along their implementation (for which they are covering)\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"appuiscommuns_supportaerien__example\"], \"meta\": {}, \"name\": \"appuiscommuns_supportaerien__example\", \"original_file_path\": \"seeds/appuiscommuns_supportaerien__example.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": \"fdr_appuiscommuns://models/appuiscommuns_schema.yml\", \"path\": \"appuiscommuns_supportaerien__example.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [\"example\"], \"unique_id\": \"seed.fdr_appuiscommuns.appuiscommuns_supportaerien__example\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":11,"name":"l_appuisaeriens_materiau__osmgeodatamine","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"l_appuisaeriens_materiau__osmgeodatamine\", \"build_path\": null, \"checksum\": {\"checksum\": \"160e34d2a13e37a362a5aa9de8d9ed3805d3a42c0332c6de87f184f7926e20e4\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": [\"link\", \"mapping\"]}, \"created_at\": 1647361957.978695, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"table de traduction / r\\u00e9conciliation de la liste de valeurs depuis la source (jeu / org) osmgeodatamine\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"l_appuisaeriens_materiau__osmgeodatamine\"], \"meta\": {}, \"name\": \"l_appuisaeriens_materiau__osmgeodatamine\", \"original_file_path\": \"seeds/l_appuisaeriens_materiau__osmgeodatamine.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": \"fdr_appuiscommuns://models/appuiscommuns_schema.yml\", \"path\": \"l_appuisaeriens_materiau__osmgeodatamine.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [\"link\", \"mapping\"], \"unique_id\": \"seed.fdr_appuiscommuns.l_appuisaeriens_materiau__osmgeodatamine\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":12,"name":"l_appuisaeriens_composition","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"l_appuisaeriens_composition\", \"build_path\": null, \"checksum\": {\"checksum\": \"0b59aee6cf91dd90c130eb907ef4d2c541527b8d3b3d038855a125de7443a042\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647361957.770355, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"l_appuisaeriens_composition\"], \"meta\": {}, \"name\": \"l_appuisaeriens_composition\", \"original_file_path\": \"seeds/l_appuisaeriens_composition.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"l_appuisaeriens_composition.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"seed.fdr_appuiscommuns.l_appuisaeriens_composition\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":13,"name":"l_pointaccueil_nature__mapping","use_case":"appuiscommuns","type":"","definition":0,"dictionary":1,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"l_pointaccueil_nature__mapping\", \"build_path\": null, \"checksum\": {\"checksum\": \"231fbd3b889fcbd72a3ab6f0cd3775ff5e7f78a400dd590c36ee55cd86459705\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": [\"dictionary\", \"mapping\"]}, \"created_at\": 1647361957.9765265, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"table de traduction / r\\u00e9conciliation de la liste de valeurs depuis la source (jeu / org)\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"l_pointaccueil_nature__mapping\"], \"meta\": {}, \"name\": \"l_pointaccueil_nature__mapping\", \"original_file_path\": \"seeds/l_pointaccueil_nature__mapping.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": \"fdr_appuiscommuns://models/appuiscommuns_schema.yml\", \"path\": \"l_pointaccueil_nature__mapping.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [\"dictionary\", \"mapping\"], \"unique_id\": \"seed.fdr_appuiscommuns.l_pointaccueil_nature__mapping\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":14,"name":"birdz_extract","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":1,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"birdz_extract\", \"build_path\": null, \"checksum\": {\"checksum\": \"3510751c181ba43f2b5955c2206a20233d77a47106e9d8fabc2d42f7dce72807\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {\"PDR_NUM,C,254\": \"text\"}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": [\"sample\", \"example\"]}, \"created_at\": 1647361957.9808867, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"extrait repr\\u00e9sentatif des donn\\u00e9es de la source (type) birdz\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"birdz_extract\"], \"meta\": {}, \"name\": \"birdz_extract\", \"original_file_path\": \"seeds/birdz_extract.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": \"fdr_appuiscommuns://models/appuiscommuns_schema.yml\", \"path\": \"birdz_extract.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [\"sample\", \"example\"], \"unique_id\": \"seed.fdr_appuiscommuns.birdz_extract\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":15,"name":"l_pointaccueil_nature","use_case":"appuiscommuns","type":"","definition":0,"dictionary":1,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"l_pointaccueil_nature\", \"build_path\": null, \"checksum\": {\"checksum\": \"da865a60c0efb54991a7e6a7def2c53d72eebdbefd7007c8e3a27c3712a5e19b\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": [\"dictionary\"]}, \"created_at\": 1647361957.9742048, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"l_pointaccueil_nature\"], \"meta\": {}, \"name\": \"l_pointaccueil_nature\", \"original_file_path\": \"seeds/l_pointaccueil_nature.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": \"fdr_appuiscommuns://models/appuiscommuns_schema.yml\", \"path\": \"l_pointaccueil_nature.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [\"dictionary\"], \"unique_id\": \"seed.fdr_appuiscommuns.l_pointaccueil_nature\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":16,"name":"l_appuisaeriens_resistance","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"l_appuisaeriens_resistance\", \"build_path\": null, \"checksum\": {\"checksum\": \"2da0651fcadbb7fd69742d3dcd8da8c70a6a83083f3b955937154dcc826ceadb\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647361957.777147, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"l_appuisaeriens_resistance\"], \"meta\": {}, \"name\": \"l_appuisaeriens_resistance\", \"original_file_path\": \"seeds/l_appuisaeriens_resistance.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"l_appuisaeriens_resistance.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"seed.fdr_appuiscommuns.l_appuisaeriens_resistance\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":17,"name":"l_appuisaeriens_structure","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"l_appuisaeriens_structure\", \"build_path\": null, \"checksum\": {\"checksum\": \"35f1ea419f66faeda27caa0c6a4f5ccda9b67f034e8f5be4be82e31f3cbd53bf\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647361957.778727, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"l_appuisaeriens_structure\"], \"meta\": {}, \"name\": \"l_appuisaeriens_structure\", \"original_file_path\": \"seeds/l_appuisaeriens_structure.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"l_appuisaeriens_structure.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"seed.fdr_appuiscommuns.l_appuisaeriens_structure\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":18,"name":"osm_powersupports__supportaerien__expected","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":1,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"osm_powersupports__supportaerien__expected\", \"build_path\": null, \"checksum\": {\"checksum\": \"096fe3b7dc0aa2e740c5e42b573975cbd158c844f989b8aa128f2a23e7801c3a\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {\"appuiscommunssupp__commune__insee_id\": \"text\", \"appuiscommunssupp__fdrcommune__insee_id\": \"text\", \"fdrcommune__insee_id\": \"text\"}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": [\"unittest\", \"expected\"]}, \"created_at\": 1647361957.9709113, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"attendu de la normalisation\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"osm_powersupports__supportaerien__expected\"], \"meta\": {}, \"name\": \"osm_powersupports__supportaerien__expected\", \"original_file_path\": \"seeds/osm_powersupports__supportaerien__expected.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": \"fdr_appuiscommuns://models/appuiscommuns_schema.yml\", \"path\": \"osm_powersupports__supportaerien__expected.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [\"unittest\", \"expected\"], \"unique_id\": \"seed.fdr_appuiscommuns.osm_powersupports__supportaerien__expected\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":19,"name":"megalis_exemple","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"megalis_exemple\", \"build_path\": null, \"checksum\": {\"checksum\": \"2b9a98a966565ab0b1a7e95a540ecfeddd757122c6fb0663d9f78c0561a70899\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"fdr_appuiscommuns\": null, \"full_refresh\": null, \"materialized\": \"seed\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quote_columns\": null, \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647361957.7823915, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"megalis_exemple\"], \"meta\": {}, \"name\": \"megalis_exemple\", \"original_file_path\": \"seeds/megalis_exemple.csv\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"megalis_exemple.csv\", \"raw_sql\": \"\", \"refs\": [], \"resource_type\": \"seed\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"seed.fdr_appuiscommuns.megalis_exemple\", \"unrendered_config\": {\"fdr_appuiscommuns\": null}}"},{"_id":20,"name":"fdr_appuiscommuns-on-run-start-0","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"fdr_appuiscommuns-on-run-start-0\", \"build_path\": null, \"checksum\": {\"checksum\": \"1af5c70603f438919e14bd3097eb3121c656b29ed9e5904a3e9fe2c6af3b2d73\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"table\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647361957.7932832, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [\"macro.fdr_appuiscommuns.create_udfs\"], \"nodes\": []}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"hooks\", \"fdr_appuiscommuns-on-run-start-0\"], \"index\": 0, \"meta\": {}, \"name\": \"fdr_appuiscommuns-on-run-start-0\", \"original_file_path\": \"./dbt_project.yml\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"hooks/fdr_appuiscommuns-on-run-start-0.sql\", \"raw_sql\": \"{{create_udfs()}}\", \"refs\": [], \"resource_type\": \"operation\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [\"on-run-start\"], \"unique_id\": \"operation.fdr_appuiscommuns.fdr_appuiscommuns-on-run-start-0\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"table\"}}"},{"_id":21,"name":"georef-france-commune.csv","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"georef-france-commune.csv\", \"build_path\": null, \"checksum\": {\"checksum\": \"3a22509a17d41f3c6a3e617f7dad0d105552b7ecc7e4dc7bca64aea807b253f7\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"indexes\": [{\"columns\": [\"geo_shape\"], \"type\": \"gist\"}], \"materialized\": \"table\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647367090.2202067, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [\"macro.dbt_utils.star\"], \"nodes\": [\"source.fdr_appuiscommuns.france-data-reseau.georef-france-commune.csv\", \"source.fdr_appuiscommuns.france-data-reseau.georef-france-commune.csv\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"france-data-reseau\", \"georef-france-commune.csv\"], \"meta\": {}, \"name\": \"georef-france-commune.csv\", \"original_file_path\": \"models/france-data-reseau/georef-france-commune.csv.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"france-data-reseau/georef-france-commune.csv.sql\", \"raw_sql\": \"{{\\n config(\\n materialized=\\\"table\\\",\\n indexes=[{\\u0027columns\\u0027: [\\u0027geo_shape\\u0027], \\u0027type\\u0027: \\u0027gist\\u0027},]\\n )\\n}}\\n\\nselect\\n {{ dbt_utils.star(source(\\u0027france-data-reseau\\u0027, \\u0027georef-france-commune.csv\\u0027), except=[\\n \\\"geo_point_2d\\\",\\n \\\"geo_shape\\\"]) }},\\n ST_PointFromText(\\u0027POINT(\\u0027 || replace(c.geo_point_2d, \\u0027,\\u0027, \\u0027 \\u0027) || \\u0027)\\u0027, 4326) as geo_point_2d,\\n ST_GeomFROMText(ST_AsText(ST_GeomFromGeoJSON(c.geo_shape)), 4326) as geo_shape\\nfrom {{ source(\\u0027france-data-reseau\\u0027, \\u0027georef-france-commune.csv\\u0027) }} c\", \"refs\": [], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [[\"france-data-reseau\", \"georef-france-commune.csv\"], [\"france-data-reseau\", \"georef-france-commune.csv\"]], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.georef-france-commune.csv\", \"unrendered_config\": {\"exploitation\": null, \"indexes\": [{\"columns\": [\"geo_shape\"], \"type\": \"gist\"}], \"materialized\": \"table\"}}"},{"_id":22,"name":"apcom_supportaerien__duplicate_geometry","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"apcom_supportaerien__duplicate_geometry\", \"build_path\": null, \"checksum\": {\"checksum\": \"7bc43d06a1051da52949bde7e94ef43c7b004a5ee19e1781c8dea7b91c3c802e\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"table\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647960445.4618902, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [\"macro.fdr_appuiscommuns.apcom_supportaerien_translation__duplicate_geometry\"], \"nodes\": [\"source.fdr_appuiscommuns.france-data-reseau.georef-france-commune.csv\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien\", \"model.fdr_appuiscommuns.georef-france-commune.csv\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"apcom_supportaerien__duplicate_geometry\"], \"meta\": {}, \"name\": \"apcom_supportaerien__duplicate_geometry\", \"original_file_path\": \"models/apcom_supportaerien__duplicate_geometry.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"apcom_supportaerien__duplicate_geometry.sql\", \"raw_sql\": \"{#\\n2 phase dedup - phase 1\\n\\nor osm_powsupp__apcom_supportaerien_translated\\n#}\\n\\n{{\\n config(\\n materialized=\\\"table\\\"\\n )\\n}}\\n\\n{{ apcom_supportaerien_translation__duplicate_geometry(\\u0027appuiscommuns_supportaerien\\u0027) }}\", \"refs\": [[\"appuiscommuns_supportaerien\"], [\"georef-france-commune.csv\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [[\"france-data-reseau\", \"georef-france-commune.csv\"]], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.apcom_supportaerien__duplicate_geometry\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"table\"}}"},{"_id":23,"name":"apcom_supportaerien__fdrcommune","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"apcom_supportaerien__fdrcommune\", \"build_path\": null, \"checksum\": {\"checksum\": \"7bc43d06a1051da52949bde7e94ef43c7b004a5ee19e1781c8dea7b91c3c802e\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"table\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647960445.483515, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [\"macro.fdr_appuiscommuns.apcom_supportaerien_translation__duplicate_geometry\"], \"nodes\": [\"source.fdr_appuiscommuns.france-data-reseau.georef-france-commune.csv\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien\", \"model.fdr_appuiscommuns.georef-france-commune.csv\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"apcom_supportaerien__fdrcommune\"], \"meta\": {}, \"name\": \"apcom_supportaerien__fdrcommune\", \"original_file_path\": \"models/apcom_supportaerien__fdrcommune.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"apcom_supportaerien__fdrcommune.sql\", \"raw_sql\": \"{#\\n2 phase dedup - phase 1\\n\\nor osm_powsupp__apcom_supportaerien_translated\\n#}\\n\\n{{\\n config(\\n materialized=\\\"table\\\"\\n )\\n}}\\n\\n{{ apcom_supportaerien_translation__duplicate_geometry(\\u0027appuiscommuns_supportaerien\\u0027) }}\", \"refs\": [[\"appuiscommuns_supportaerien\"], [\"georef-france-commune.csv\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [[\"france-data-reseau\", \"georef-france-commune.csv\"]], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.apcom_supportaerien__fdrcommune\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"table\"}}"},{"_id":24,"name":"appuiscommuns__supportaerien_indicators_commune_ot","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":1,"node_json":"{\"alias\": \"appuiscommuns__supportaerien_indicators_commune_ot\", \"build_path\": null, \"checksum\": {\"checksum\": \"37097abc3d5bed070c9e2f7933fd926d18b1621d829f0c1b7acd32758899a9fc\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"incremental\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": [], \"unique_key\": \"concat(profiled_week, \\\"appuiscommunssupp__fdrcommune__insee_id\\\")\"}, \"created_at\": 1647960445.4891992, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": [\"model.fdr_appuiscommuns.appuiscommuns__supportaerien_indicators_commune\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"exploitation\", \"appuiscommuns__supportaerien_indicators_commune_ot\"], \"meta\": {}, \"name\": \"appuiscommuns__supportaerien_indicators_commune_ot\", \"original_file_path\": \"models/exploitation/appuiscommuns__supportaerien_indicators_commune_ot.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"exploitation/appuiscommuns__supportaerien_indicators_commune_ot.sql\", \"raw_sql\": \"{# \\nExample de profilage incr\\u00e9mental au fil du temps des donn\\u00e9es d\\u0027une source par le profiler de DBT Hub.\\nSi activ\\u00e9 (typiquement de mani\\u00e8re planifi\\u00e9e : chaque semaine...) :\\n- pas de if is_incremental() where profiled_at \\u003e (select max(updated_at) from {{ this }}),\\ndonc toutes les lignes (autant d\\u0027indicateurs) sont recalcul\\u00e9e A CHAQUE FOIS\\ndonc id\\u00e9alement ne l\\u0027ex\\u00e9cuter que de mani\\u00e8re planifi\\u00e9e (chaque semaine...)\\n- ou alors mettre une unique_key (p\\u00e9riode ex. semaine / mois du current_timestamp), sinon en append only i.e. aucune n\\u0027est mise \\u00e0 jour.\\n#}\\n\\n{% set prefix = \\u0027appuiscommunssupp\\u0027 %} -- ?\\n{% set fieldPrefix = prefix + \\u0027__\\u0027 %}\\n\\n{{\\n config(\\n enabled=var(\\\"enableProfiling\\\", false) | as_bool,\\n materialized=\\\"incremental\\\",\\n unique_key=\\u0027concat(profiled_week, \\\"\\u0027 + fieldPrefix + \\u0027fdrcommune__insee_id\\\")\\u0027\\n )\\n}}\\n\\nselect\\n concat(substr(\\\"updated_at\\\"::text, 1, 4), EXTRACT(\\u0027week\\u0027 FROM \\\"updated_at\\\")) as \\\"profiled_week\\\", -- \\u0027202221\\u0027\\n *\\nfrom {{ ref(\\\"appuiscommuns__supportaerien_indicators_commune\\\") }}\", \"refs\": [[\"appuiscommuns__supportaerien_indicators_commune\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.appuiscommuns__supportaerien_indicators_commune_ot\", \"unrendered_config\": {\"enabled\": true, \"exploitation\": null, \"materialized\": \"incremental\", \"unique_key\": \"concat(profiled_week, \\\"appuiscommunssupp__fdrcommune__insee_id\\\")\"}}"},{"_id":25,"name":"appuiscommuns__supportaerien_indicators_commune","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":1,"node_json":"{\"alias\": \"appuiscommuns__supportaerien_indicators_commune\", \"build_path\": null, \"checksum\": {\"checksum\": \"683dd19870c0361b6fa4fa073c737cc8c3a20d31697ef7b3f89a702164316331\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"table\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647960445.496041, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [\"macro.dbt_utils.get_column_values\", \"macro.dbt_utils.pivot\"], \"nodes\": [\"model.fdr_appuiscommuns.appuiscommuns_supportaerien_enriched\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien_enriched\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien_enriched\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien_enriched\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien_enriched\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"exploitation\", \"appuiscommuns__supportaerien_indicators_commune\"], \"meta\": {}, \"name\": \"appuiscommuns__supportaerien_indicators_commune\", \"original_file_path\": \"models/exploitation/appuiscommuns__supportaerien_indicators_commune.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"exploitation/appuiscommuns__supportaerien_indicators_commune.sql\", \"raw_sql\": \"{#\\nExample d\\u0027exploitation - calcul d\\u0027indicateurs agr\\u00e9g\\u00e9s classiques, par commune :\\n- min et max, de numeric\\n- ensemble des valeurs rencontr\\u00e9es (dans une commune donc), pour une valeur de dictionnaire\\n#}\\n\\n{% set containerUrl = \\u0027http://\\u0027 + \\u0027datalake.francedatareseau.fr\\u0027 %}\\n{% set typeUrlPrefix = containerUrl + \\u0027/dc/type/\\u0027 %}\\n{% set type = \\u0027eaupotable_canalisation\\u0027 %} -- _2021 ? from this file ? prefix:typeName ?\\n{% set typeInd = \\u0027eaupotable_canalisation__indicators\\u0027 %}\\n{% set typeName = \\u0027Canalisation\\u0027 %}\\n{% set typeNameInd = \\u0027CanalisationIndicator\\u0027 %}\\n{% set prefix = \\u0027appuiscommunssupp\\u0027 %} -- ?\\n{% set prefixInd = \\u0027appuiscommunssuppind\\u0027 %} -- ?\\n{#% set fieldPrefix = prefix + \\u0027:\\u0027 %#}\\n{% set fieldPrefix = prefix + \\u0027__\\u0027 %}\\n{#% set fieldPrefixInd = prefixInd + \\u0027__\\u0027 %#}\\n{% set fieldPrefixInd = prefixInd + \\u0027__\\u0027 %}\\n{% set idUrlPrefix = typeUrlPrefix + type + \\u0027/\\u0027 %}\\n\\nselect\\n count(*) as \\\"{{ fieldPrefixInd }}count\\\",\\n \\\"{{ fieldPrefix }}fdrcommune__insee_id\\\",\\n MIN(\\\"com_name\\\") as com_name,\\n MIN(\\\"reg_code\\\") as reg_code,\\n MIN(\\\"reg_name\\\") as reg_name,\\n array_agg(distinct \\\"{{ fieldPrefix }}TypePhysique\\\") as \\\"{{ fieldPrefixInd }}TypePhysique__set\\\",\\n {{ dbt_utils.pivot(\\u0027\\\"\\u0027 + fieldPrefix + \\u0027TypePhysique\\\"\\u0027, dbt_utils.get_column_values(ref(\\u0027appuiscommuns_supportaerien_enriched\\u0027),\\n \\u0027\\\"\\u0027 + fieldPrefix + \\u0027TypePhysique\\\"\\u0027), prefix=fieldPrefix + \\u0027TypePhysique__\\u0027) }},\\n array_agg(distinct \\\"{{ fieldPrefix }}Nature\\\") as \\\"{{ fieldPrefixInd }}Nature__set\\\",\\n {{ dbt_utils.pivot(\\u0027\\\"\\u0027 + fieldPrefix + \\u0027Nature\\\"\\u0027, dbt_utils.get_column_values(ref(\\u0027appuiscommuns_supportaerien_enriched\\u0027),\\n \\u0027\\\"\\u0027 + fieldPrefix + \\u0027Nature\\\"\\u0027), prefix=fieldPrefix + \\u0027Nature__\\u0027) }},\\n array_agg(distinct \\\"{{ fieldPrefix }}Gestionnaire\\\") as \\\"{{ fieldPrefixInd }}Gestionnaire__set\\\",\\n {{ dbt_utils.pivot(\\u0027\\\"\\u0027 + fieldPrefix + \\u0027Gestionnaire\\\"\\u0027, dbt_utils.get_column_values(ref(\\u0027appuiscommuns_supportaerien_enriched\\u0027),\\n \\u0027\\\"\\u0027 + fieldPrefix + \\u0027Gestionnaire\\\"\\u0027), prefix=fieldPrefix + \\u0027Gestionnaire__\\u0027) }},\\n array_agg(distinct \\\"{{ fieldPrefix }}Materiau\\\") as \\\"{{ fieldPrefixInd }}Materiau__set\\\", -- TODO distinct\\n {{ dbt_utils.pivot(\\u0027\\\"\\u0027 + fieldPrefix + \\u0027Materiau\\\"\\u0027, dbt_utils.get_column_values(ref(\\u0027appuiscommuns_supportaerien_enriched\\u0027),\\n \\u0027\\\"\\u0027 + fieldPrefix + \\u0027Materiau\\\"\\u0027), prefix=fieldPrefix + \\u0027Materiau__\\u0027) }},\\n MIN(\\\"{{ fieldPrefix }}HauteurAppui\\\") as \\\"{{ fieldPrefixInd }}HauteurAppui__min\\\",\\n MAX(\\\"{{ fieldPrefix }}HauteurAppui\\\") as \\\"{{ fieldPrefixInd }}HauteurAppui__max\\\",\\n AVG(\\\"{{ fieldPrefix }}HauteurAppui\\\") as \\\"{{ fieldPrefixInd }}HauteurAppui__avg\\\",\\n count(*) / MIN(\\\"Population\\\") as \\\"{{ fieldPrefixInd }}count_per_inhabitant\\\",\\n current_timestamp as updated_at\\n \\n from {{ ref(\\u0027appuiscommuns_supportaerien_enriched\\u0027) }}\\n group by \\\"{{ fieldPrefix }}fdrcommune__insee_id\\\"\", \"refs\": [[\"appuiscommuns_supportaerien_enriched\"], [\"appuiscommuns_supportaerien_enriched\"], [\"appuiscommuns_supportaerien_enriched\"], [\"appuiscommuns_supportaerien_enriched\"], [\"appuiscommuns_supportaerien_enriched\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.appuiscommuns__supportaerien_indicators_commune\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"table\"}}"},{"_id":26,"name":"appuiscommuns__supportaerien_indicators_region_ot","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":1,"node_json":"{\"alias\": \"appuiscommuns__supportaerien_indicators_region_ot\", \"build_path\": null, \"checksum\": {\"checksum\": \"d6b55e5e087c92aab529135ce61f2f687df30f7cf8e0c12b46454df31fdfaab7\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"incremental\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": [], \"unique_key\": \"concat(\\\"profiled_week\\\", \\\"reg_code\\\")\"}, \"created_at\": 1647960445.5297072, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": [\"model.fdr_appuiscommuns.appuiscommuns__supportaerien_indicators_region\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"exploitation\", \"appuiscommuns__supportaerien_indicators_region_ot\"], \"meta\": {}, \"name\": \"appuiscommuns__supportaerien_indicators_region_ot\", \"original_file_path\": \"models/exploitation/appuiscommuns__supportaerien_indicators_region_ot.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"exploitation/appuiscommuns__supportaerien_indicators_region_ot.sql\", \"raw_sql\": \"{# \\nExample de profilage incr\\u00e9mental au fil du temps des donn\\u00e9es d\\u0027une source par le profiler de DBT Hub :\\n#}\\n\\n{% set prefix = \\u0027appuiscommunssupp\\u0027 %} -- ?\\n{% set fieldPrefix = prefix + \\u0027__\\u0027 %}\\n\\n{# inlined profiled_week else delete fails in incremental phase 1 #}\\n{{\\n config(\\n enabled=var(\\\"enableProfiling\\\", false) | as_bool,\\n materialized=\\\"incremental\\\",\\n unique_key=\\u0027concat(\\\"profiled_week\\\", \\\"reg_code\\\")\\u0027\\n )\\n}}\\n\\nselect\\n concat(substr(\\\"updated_at\\\"::text, 1, 4), EXTRACT(\\u0027week\\u0027 FROM \\\"updated_at\\\")) as \\\"profiled_week\\\", -- \\u0027202221\\u0027\\n *\\nfrom {{ ref(\\\"appuiscommuns__supportaerien_indicators_region\\\") }}\", \"refs\": [[\"appuiscommuns__supportaerien_indicators_region\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.appuiscommuns__supportaerien_indicators_region_ot\", \"unrendered_config\": {\"enabled\": true, \"exploitation\": null, \"materialized\": \"incremental\", \"unique_key\": \"concat(\\\"profiled_week\\\", \\\"reg_code\\\")\"}}"},{"_id":27,"name":"appuiscommuns__supportaerien_indicators_region","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":1,"node_json":"{\"alias\": \"appuiscommuns__supportaerien_indicators_region\", \"build_path\": null, \"checksum\": {\"checksum\": \"45e6325f981de6e7afc86d5e4ef889892b6cf1880d3569e885eaab2c2872b261\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"table\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647960445.536461, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [\"macro.dbt_utils.get_column_values\", \"macro.dbt_utils.pivot\"], \"nodes\": [\"model.fdr_appuiscommuns.appuiscommuns_supportaerien_enriched\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien_enriched\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien_enriched\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien_enriched\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien_enriched\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"exploitation\", \"appuiscommuns__supportaerien_indicators_region\"], \"meta\": {}, \"name\": \"appuiscommuns__supportaerien_indicators_region\", \"original_file_path\": \"models/exploitation/appuiscommuns__supportaerien_indicators_region.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"exploitation/appuiscommuns__supportaerien_indicators_region.sql\", \"raw_sql\": \"{#\\nExample d\\u0027exploitation - calcul d\\u0027indicateurs agr\\u00e9g\\u00e9s classiques, par commune :\\n- min et max, de numeric\\n- ensemble des valeurs rencontr\\u00e9es (dans une commune donc), pour une valeur de dictionnaire\\n#}\\n\\n{% set containerUrl = \\u0027http://\\u0027 + \\u0027datalake.francedatareseau.fr\\u0027 %}\\n{% set typeUrlPrefix = containerUrl + \\u0027/dc/type/\\u0027 %}\\n{% set type = \\u0027eaupotable_canalisation\\u0027 %} -- _2021 ? from this file ? prefix:typeName ?\\n{% set typeInd = \\u0027eaupotable_canalisation__indicators\\u0027 %}\\n{% set typeName = \\u0027Canalisation\\u0027 %}\\n{% set typeNameInd = \\u0027CanalisationIndicator\\u0027 %}\\n{% set prefix = \\u0027appuiscommunssupp\\u0027 %} -- ?\\n{% set prefixInd = \\u0027appuiscommunssuppind\\u0027 %} -- ?\\n{#% set fieldPrefix = prefix + \\u0027:\\u0027 %#}\\n{% set fieldPrefix = prefix + \\u0027__\\u0027 %}\\n{#% set fieldPrefixInd = prefixInd + \\u0027__\\u0027 %#}\\n{% set fieldPrefixInd = prefixInd + \\u0027__\\u0027 %}\\n{% set idUrlPrefix = typeUrlPrefix + type + \\u0027/\\u0027 %}\\n\\nselect\\n count(*) as \\\"{{ fieldPrefixInd }}count\\\",\\n MIN(\\\"{{ fieldPrefix }}fdrcommune__insee_id\\\") as \\\"{{ fieldPrefix }}fdrcommune__insee_id\\\",\\n reg_code,\\n MIN(\\\"reg_name\\\") as reg_name,\\n array_agg(distinct \\\"{{ fieldPrefix }}TypePhysique\\\") as \\\"{{ fieldPrefixInd }}TypePhysique__set\\\",\\n {{ dbt_utils.pivot(\\u0027\\\"\\u0027 + fieldPrefix + \\u0027TypePhysique\\\"\\u0027, dbt_utils.get_column_values(ref(\\u0027appuiscommuns_supportaerien_enriched\\u0027),\\n \\u0027\\\"\\u0027 + fieldPrefix + \\u0027TypePhysique\\\"\\u0027), prefix=fieldPrefix + \\u0027TypePhysique__\\u0027) }},\\n array_agg(distinct \\\"{{ fieldPrefix }}Nature\\\") as \\\"{{ fieldPrefixInd }}Nature__set\\\",\\n {{ dbt_utils.pivot(\\u0027\\\"\\u0027 + fieldPrefix + \\u0027Nature\\\"\\u0027, dbt_utils.get_column_values(ref(\\u0027appuiscommuns_supportaerien_enriched\\u0027),\\n \\u0027\\\"\\u0027 + fieldPrefix + \\u0027Nature\\\"\\u0027), prefix=fieldPrefix + \\u0027Nature__\\u0027) }},\\n array_agg(distinct \\\"{{ fieldPrefix }}Gestionnaire\\\") as \\\"{{ fieldPrefixInd }}Gestionnaire__set\\\",\\n {{ dbt_utils.pivot(\\u0027\\\"\\u0027 + fieldPrefix + \\u0027Gestionnaire\\\"\\u0027, dbt_utils.get_column_values(ref(\\u0027appuiscommuns_supportaerien_enriched\\u0027),\\n \\u0027\\\"\\u0027 + fieldPrefix + \\u0027Gestionnaire\\\"\\u0027), prefix=fieldPrefix + \\u0027Gestionnaire__\\u0027) }},\\n array_agg(distinct \\\"{{ fieldPrefix }}Materiau\\\") as \\\"{{ fieldPrefixInd }}Materiau__set\\\", -- TODO distinct\\n {{ dbt_utils.pivot(\\u0027\\\"\\u0027 + fieldPrefix + \\u0027Materiau\\\"\\u0027, dbt_utils.get_column_values(ref(\\u0027appuiscommuns_supportaerien_enriched\\u0027),\\n \\u0027\\\"\\u0027 + fieldPrefix + \\u0027Materiau\\\"\\u0027), prefix=fieldPrefix + \\u0027Materiau__\\u0027) }},\\n MIN(\\\"{{ fieldPrefix }}HauteurAppui\\\") as \\\"{{ fieldPrefixInd }}HauteurAppui__min\\\",\\n MAX(\\\"{{ fieldPrefix }}HauteurAppui\\\") as \\\"{{ fieldPrefixInd }}HauteurAppui__max\\\",\\n AVG(\\\"{{ fieldPrefix }}HauteurAppui\\\") as \\\"{{ fieldPrefixInd }}HauteurAppui__avg\\\",\\n current_timestamp as updated_at\\n \\n from {{ ref(\\u0027appuiscommuns_supportaerien_enriched\\u0027) }}\\n group by \\\"reg_code\\\"\", \"refs\": [[\"appuiscommuns_supportaerien_enriched\"], [\"appuiscommuns_supportaerien_enriched\"], [\"appuiscommuns_supportaerien_enriched\"], [\"appuiscommuns_supportaerien_enriched\"], [\"appuiscommuns_supportaerien_enriched\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.appuiscommuns__supportaerien_indicators_region\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"table\"}}"},{"_id":28,"name":"appuiscommuns_supportaerien_enriched","use_case":"appuiscommuns","type":"supportaerien","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":1,"indicators":0,"node_json":"{\"alias\": \"appuiscommuns_supportaerien_enriched\", \"build_path\": null, \"checksum\": {\"checksum\": \"0fec6c5c81c951b1561b223a739ae4deb0ae7d2496f1cad7a931aebe8f8e40a9\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"view\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647960445.5530221, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [\"macro.dbt_utils.star\"], \"nodes\": [\"source.fdr_appuiscommuns.france-data-reseau.georef-france-commune.csv\", \"source.fdr_appuiscommuns.france-data-reseau.INSEE communes donn\\u00e9es d\\u00e9mographiques\", \"source.fdr_appuiscommuns.france-data-reseau.georef-france-commune.csv\", \"source.fdr_appuiscommuns.france-data-reseau.georef-france-commune.csv\", \"source.fdr_appuiscommuns.france-data-reseau.INSEE communes donn\\u00e9es d\\u00e9mographiques\", \"source.fdr_appuiscommuns.france-data-reseau.INSEE communes donn\\u00e9es d\\u00e9mographiques\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien__definition\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"appuiscommuns_supportaerien_enriched\"], \"meta\": {}, \"name\": \"appuiscommuns_supportaerien_enriched\", \"original_file_path\": \"models/appuiscommuns_supportaerien_enriched.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"appuiscommuns_supportaerien_enriched.sql\", \"raw_sql\": \"{#\\nEnrichissement (par les communes) des donn\\u00e9es normalis\\u00e9es de toutes les sources de type appuiscommuns.supportaerien.\\n\\n- on ne garde que les champs officiels\\n#}\\n\\n{% set containerUrl = \\u0027http://\\u0027 + \\u0027datalake.francedatareseau.fr\\u0027 %}\\n{% set typeUrlPrefix = containerUrl + \\u0027/dc/type/\\u0027 %}\\n{% set type = \\u0027appuiscommuns_supportaerien\\u0027 %} -- _2021 ? from this file ? prefix:typeName ?\\n{% set typeName = \\u0027Canalisation\\u0027 %}\\n{% set prefix = \\u0027appuiscommunssupp\\u0027 %} -- ?\\n{% set fieldPrefix = prefix + \\u0027:\\u0027 %}\\n{% set fieldPrefix = prefix + \\u0027__\\u0027 %}\\n{% set idUrlPrefix = typeUrlPrefix + type + \\u0027/\\u0027 %}\\n\\n{{\\n config(\\n materialized=\\\"view\\\"\\n )\\n}}\\n\\nwith unioned as (\\n{#\\nAlternative : implicit SELECT * or=dbt_utils.star(my_model_definition_relation) or all fields explicitly...\\n#}\\nselect\\n {{ dbt_utils.star(ref(\\u0027appuiscommuns_supportaerien__definition\\u0027)) }},\\n {{ dbt_utils.star(source(\\u0027france-data-reseau\\u0027, \\u0027georef-france-commune.csv\\u0027), except=[\\u0027_id\\u0027, \\u0027_full_text\\u0027]) }}, -- _id is most probably added by CKAN to all imports\\n {{ dbt_utils.star(source(\\u0027france-data-reseau\\u0027, \\u0027INSEE communes donn\\u00e9es d\\u00e9mographiques\\u0027), except=[\\u0027_id\\u0027, \\u0027_full_text\\u0027]) }} -- _id is most probably added by CKAN to all imports\\n from {{ ref(\\u0027appuiscommuns_supportaerien\\u0027) }}\\n CROSS JOIN unnest({{ ref(\\u0027appuiscommuns_supportaerien\\u0027) }}.\\\"fdrcommune__insee_id__arr\\\") supp(\\\"fdrcommune__insee_id__arr_u\\\")\\n left join {{ source(\\u0027france-data-reseau\\u0027, \\u0027georef-france-commune.csv\\u0027) }} -- LEFT join sinon seulement les lignes qui ont une valeur !! TODO indicateur count pour le v\\u00e9rifier\\n on supp.\\\"fdrcommune__insee_id__arr_u\\\" = {{ source(\\u0027france-data-reseau\\u0027, \\u0027georef-france-commune.csv\\u0027) }}.com_code\\n left join {{ source(\\u0027france-data-reseau\\u0027, \\u0027INSEE communes donn\\u00e9es d\\u00e9mographiques\\u0027) }} -- LEFT join sinon seulement les lignes qui ont une valeur !! TODO indicateur count pour le v\\u00e9rifier\\n on {{ ref(\\u0027appuiscommuns_supportaerien\\u0027) }}.\\\"fdrcommune__insee_id\\\" = {{ source(\\u0027france-data-reseau\\u0027, \\u0027INSEE communes donn\\u00e9es d\\u00e9mographiques\\u0027) }}.\\\"CODGEO\\\"\\n)\\nselect * from unioned\", \"refs\": [[\"appuiscommuns_supportaerien__definition\"], [\"appuiscommuns_supportaerien\"], [\"appuiscommuns_supportaerien\"], [\"appuiscommuns_supportaerien\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [[\"france-data-reseau\", \"georef-france-commune.csv\"], [\"france-data-reseau\", \"INSEE communes donn\\u00e9es d\\u00e9mographiques\"], [\"france-data-reseau\", \"georef-france-commune.csv\"], [\"france-data-reseau\", \"georef-france-commune.csv\"], [\"france-data-reseau\", \"INSEE communes donn\\u00e9es d\\u00e9mographiques\"], [\"france-data-reseau\", \"INSEE communes donn\\u00e9es d\\u00e9mographiques\"]], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.appuiscommuns_supportaerien_enriched\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"view\"}}"},{"_id":29,"name":"appuiscommuns_supportaerien_linked","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"appuiscommuns_supportaerien_linked\", \"build_path\": null, \"checksum\": {\"checksum\": \"4a1f76e342aed69c9b2309f08f49f7aeeba271b45afdb433bcf5c99621cbc819\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"table\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647960445.5786817, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [\"macro.fdr_appuiscommuns.dedupe\"], \"nodes\": [\"model.fdr_appuiscommuns.appuiscommuns_supportaerien\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"appuiscommuns_supportaerien_linked\"], \"meta\": {}, \"name\": \"appuiscommuns_supportaerien_linked\", \"original_file_path\": \"models/appuiscommuns_supportaerien_linked.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"appuiscommuns_supportaerien_linked.sql\", \"raw_sql\": \"{#\\nEnrichissement (par les communes) des donn\\u00e9es normalis\\u00e9es de toutes les sources de type appuiscommuns.supportaerien.\\n\\n- on ne garde que les champs officiels\\n#}\\n\\n{% set containerUrl = \\u0027http://\\u0027 + \\u0027datalake.francedatareseau.fr\\u0027 %}\\n{% set typeUrlPrefix = containerUrl + \\u0027/dc/type/\\u0027 %}\\n{% set type = \\u0027appuiscommuns_supportaerien\\u0027 %} -- _2021 ? from this file ? prefix:typeName ?\\n{% set typeName = \\u0027Canalisation\\u0027 %}\\n{% set prefix = \\u0027appuiscommunssupp\\u0027 %} -- ?\\n{% set fieldPrefix = prefix + \\u0027:\\u0027 %}\\n{% set fieldPrefix = prefix + \\u0027__\\u0027 %}\\n{% set idUrlPrefix = typeUrlPrefix + type + \\u0027/\\u0027 %}\\n\\nwith unioned as (\\n select * from {{ ref(\\\"appuiscommuns_supportaerien\\\") }}\\n),\\nlinked as (\\n {{ dedupe(\\u0027unioned\\u0027, id_fields=[\\u0027\\\"appuiscommunssupp__src_id\\\"\\u0027]) }}\\n)\\nselect * from linked\", \"refs\": [[\"appuiscommuns_supportaerien\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.appuiscommuns_supportaerien_linked\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"table\"}}"},{"_id":30,"name":"appuiscommuns_supportaerien","use_case":"appuiscommuns","type":"supportaerien","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":1,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"appuiscommuns_supportaerien\", \"build_path\": null, \"checksum\": {\"checksum\": \"a5518ee868f458e882526366ba611e22b94b0dda7b34dbffcec7daa49fef7f02\", \"name\": \"sha256\"}, \"columns\": {\"\\\"appuiscommunssupp__CodeExterne\\\"\": {\"data_type\": null, \"description\": \"\", \"meta\": {}, \"name\": \"\\\"appuiscommunssupp__CodeExterne\\\"\", \"quote\": null, \"tags\": []}, \"\\\"appuiscommunssupp__HauteurAppui\\\"\": {\"data_type\": null, \"description\": \"\", \"meta\": {}, \"name\": \"\\\"appuiscommunssupp__HauteurAppui\\\"\", \"quote\": null, \"tags\": []}, \"\\\"appuiscommunssupp__Id\\\"\": {\"data_type\": null, \"description\": \"id (uuid)\", \"meta\": {}, \"name\": \"\\\"appuiscommunssupp__Id\\\"\", \"quote\": null, \"tags\": [\"id\", \"unique\", \"uuid\"]}, \"\\\"appuiscommunssupp__Materiau\\\"\": {\"data_type\": null, \"description\": \"\", \"meta\": {}, \"name\": \"\\\"appuiscommunssupp__Materiau\\\"\", \"quote\": null, \"tags\": [\"l_appuisaeriens_materiau\"]}, \"\\\"appuiscommunssupp__Nature\\\"\": {\"data_type\": null, \"description\": \"\", \"meta\": {}, \"name\": \"\\\"appuiscommunssupp__Nature\\\"\", \"quote\": null, \"tags\": [\"l_pointaccueil_nature\"]}, \"appuiscommunssupp__fdrcommune__insee_id\": {\"data_type\": null, \"description\": \"\", \"meta\": {}, \"name\": \"appuiscommunssupp__fdrcommune__insee_id\", \"quote\": null, \"tags\": [\"fdrcommune__insee_id\"]}, \"appuiscommunssupp__src_id\": {\"data_type\": null, \"description\": \"id de la donn\\u00e9e sp\\u00e9cifique \\u00e0 la source\", \"meta\": {}, \"name\": \"appuiscommunssupp__src_id\", \"quote\": null, \"tags\": [\"id\", \"unique\"]}, \"appuiscommunssupp__src_name\": {\"data_type\": null, \"description\": \"le nom de la source (\\\"table lineage\\\", DBT peut aussi le rajouter)\", \"meta\": {}, \"name\": \"appuiscommunssupp__src_name\", \"quote\": null, \"tags\": []}, \"geometry\": {\"data_type\": null, \"description\": \"\", \"meta\": {}, \"name\": \"geometry\", \"quote\": null, \"tags\": []}}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"table\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": [\"unification\"]}, \"created_at\": 1647960445.6901255, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [\"macro.dbt_utils.union_relations\", \"macro.fdr_appuiscommuns.apcom_supportaerien_translation__link_geometry_fdrcommune\"], \"nodes\": [\"source.fdr_appuiscommuns.france-data-reseau.georef-france-commune.csv\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien__definition\", \"model.fdr_appuiscommuns.osm_powsupp__appuiscommuns_supportaerien\", \"model.fdr_appuiscommuns.appuiscommuns_supportaerien__definition\", \"model.fdr_appuiscommuns.georef-france-commune.csv\"]}, \"description\": \"l\\u0027union des supportaerien des toutes les sources\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"appuiscommuns_supportaerien\"], \"meta\": {}, \"name\": \"appuiscommuns_supportaerien\", \"original_file_path\": \"models/appuiscommuns_supportaerien.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": \"fdr_appuiscommuns://models/appuiscommuns_schema.yml\", \"path\": \"appuiscommuns_supportaerien.sql\", \"raw_sql\": \"{#\\nUnification des donn\\u00e9es normalis\\u00e9es de toutes les sources de type appuiscommuns.supportaerien\\n#}\\n\\n{% set containerUrl = \\u0027http://\\u0027 + \\u0027datalake.francedatareseau.fr\\u0027 %}\\n{% set typeUrlPrefix = containerUrl + \\u0027/dc/type/\\u0027 %}\\n{% set type = \\u0027appuiscommuns_supportaerien\\u0027 %} -- _2021 ? from this file ? prefix:typeName ?\\n{% set typeName = \\u0027SupportAerien\\u0027 %}\\n{% set prefix = \\u0027appuiscommunssupp\\u0027 %} -- ?\\n{% set fieldPrefix = prefix + \\u0027:\\u0027 %}\\n{% set fieldPrefix = prefix + \\u0027__\\u0027 %}\\n{% set idUrlPrefix = typeUrlPrefix + type + \\u0027/\\u0027 %}\\n\\n{#\\nUnion using dbt_utils helper :\\n- _definition (with 0 data lines) as the first unioned relation adds even fields missing in all normalizations, with the right type,\\nif they are provided in the official type definition\\n- include=dbt_utils.star(_definition) excludes source-specific fields\\n- column_override={\\\"geometry\\\": \\\"geometry\\\"} is required else syntax error : cast(\\\"geometry\\\" as USER-DEFINED) as \\\"geo...\\nsee https://github.com/dbt-labs/dbt-utils#union_relations-source\\n- source_column_name=\\\"_dbt_source_relation\\\"\\n- \\n\\nis a table only if has reconciliation\\n include=dbt_utils.star(ref(\\u0027appuiscommuns_supportaerien__definition\\u0027)),\\n#}\\n\\n{{\\n config(\\n materialized=\\\"table\\\"\\n )\\n}}\\n\\n\\nwith all1 as (\\n\\n{{ dbt_utils.union_relations(relations=[\\n ref(\\u0027appuiscommuns_supportaerien__definition\\u0027),\\n ref(\\u0027osm_powsupp__appuiscommuns_supportaerien\\u0027)],\\n column_override={\\\"geometry\\\": \\\"geometry\\\"})\\n}}\\n\\n{#\\n14s without commune_linked\\n), geometry_deduped as (\\n -- geometry deduplication :\\n -- deduplication could \\n -- FOR MORE PERFORMANCE, REQUIRES PRIMARY KEY ON ID AND A TABLE SO NOT ON SOURCE\\n -- OK : 44s rather than 0,44 if on 1m lines rather than the 200 lines, even on translation view (or source view)\\n {{ dedupe(\\u0027all1\\u0027, id_fields=[\\u0027\\\"geometry\\\"\\u0027]) }}\\n \\n#}\\n{# NO rather n-n relaationship\\nway too long anyway\\n#}\\n), commune_linked as (\\n -- reconciliation :\\n -- NB. reconciliation to communes requires a geometry field, so can\\u0027t be done on the source (and is more efficient being in a table)\\n -- moreover, commune is not necessary for other translation handlings (dedup...). And doing it after translation allows to do it all in one go.\\n {%- set fields = adapter.get_columns_in_relation(ref(\\u0027appuiscommuns_supportaerien__definition\\u0027)) | map(attribute=\\\"name\\\") | list -%}-- BEWARE without | list it stays a generator that can only be iterated once\\n {#% set cols = dbt_utils.star(sourceModel, except=[\\n fieldPrefix + \\\"fdrcommune__insee_id\\\",\\n fieldPrefix + \\\"commune__insee_id\\\",\\n \\\"fdrcommune__insee_id\\\"]).split(\\u0027,\\u0027) %#}\\n {{ apcom_supportaerien_translation__link_geometry_fdrcommune(\\\"all1\\\", id_field=\\\"appuiscommunssupp__Id\\\", fields=fields) }}\\n)\\n\\nselect * from commune_linked\\n\\n\\n{#\\nAlternative : explicit SELECT * or all fields explicitly UNION...\\nwith source as (\\n\\n select\\n \\\"{{ fieldPrefix }}src_name\\\",\\n --\\\"{{ fieldPrefix }}src_index\\\",\\n \\\"{{ fieldPrefix }}src_id\\\",\\n \\\"{{ fieldPrefix }}Id\\\",\\n geometry, -- OU prefix ? forme ??\\n --\\\"{{ sourceFieldPrefix }}utility\\\", -- power\\n --\\\"{{ sourceFieldPrefix }}nature\\\", -- pole, tower TODO dict conv\\n \\\"{{ fieldPrefix }}TypePhysique\\\", -- vu que toujours pole ou tower (ou CASE WHEN ?)\\n \\\"{{ fieldPrefix }}Nature\\\", -- \\u0027POTEAU BOIS\\u0027\\n \\\"{{ fieldPrefix }}Gestionnaire\\\",\\n \\\"{{ fieldPrefix }}Materiau\\\", -- TODO dict conv\\n \\\"{{ fieldPrefix }}HauteurAppui\\\", -- TODO Hauteur ! hauteur ? __m ??\\n \\\"{{ fieldPrefix }}CodeExterne\\\", -- 101, 87, 37081ER073...\\n --\\\"{{ sourceFieldPrefix }}line_attachment\\\", -- suspension, pin, anchor... MAIS QUE CompositionAppui (plein), StructureAppui (moise)\\n --\\\"{{ sourceFieldPrefix }}line_management\\\", -- split, branch, cross... MAIS QUE CompositionAppui (plein), StructureAppui (moise)\\n --\\\"{{ sourceFieldPrefix }}transition\\\", -- yes\\n \\\"{{ fieldPrefix }}fdrcommune__insee_id\\\",\\n \\\"{{ fieldPrefix }}fdrcommune__nom\\\"\\n \\n from {{ ref(\\u0027sample__appuiscommuns_extract_supportaerien\\u0027) }}\\n \\n --UNION...\\n\\n)\\n\\nselect * from source\\n#}\", \"refs\": [[\"appuiscommuns_supportaerien__definition\"], [\"osm_powsupp__appuiscommuns_supportaerien\"], [\"appuiscommuns_supportaerien__definition\"], [\"georef-france-commune.csv\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [[\"france-data-reseau\", \"georef-france-commune.csv\"]], \"tags\": [\"unification\"], \"unique_id\": \"model.fdr_appuiscommuns.appuiscommuns_supportaerien\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"table\"}}"},{"_id":31,"name":"profiledbt_source_appuiscommuns_over_time","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"profiledbt_source_appuiscommuns_over_time\", \"build_path\": null, \"checksum\": {\"checksum\": \"a22604ec516345614cebfa55ac76e0e9227accd872f7205856b435a309932bd5\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"incremental\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": [], \"unique_key\": \"profiled_week\"}, \"created_at\": 1647960445.6236863, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": [\"model.fdr_appuiscommuns.profiledbt_source_appuiscommuns\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"source\", \"profiledbt_source_appuiscommuns_over_time\"], \"meta\": {}, \"name\": \"profiledbt_source_appuiscommuns_over_time\", \"original_file_path\": \"models/source/profiledbt_source_appuiscommuns_over_time.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"source/profiledbt_source_appuiscommuns_over_time.sql\", \"raw_sql\": \"{# \\nExample de profilage incr\\u00e9mental au fil du temps des donn\\u00e9es d\\u0027une source par le profiler de DBT Hub.\\nWhen enabled :\\n- only the last run of each period (ex. **week** for _otw) will be kept, to avoid accumulating too much data, because of unique_key=\\\"profiled_week\\\"\\n(without, all runs would be kept, so ideally it should only be executed in a scheduled manner ex. once a week).\\n- TODO additionally, another _new model could compute only on new lines in this period, AT THE CONDITION normalization itself would be incremental\\nAND add udpated_at, using if is_incremental() where udpated_at \\u003e (select max(udpated_at) from {{ this }}),\\n- but in both cases, since there is no updated_at provided BY the source, it can\\u0027t be rebuilt and state must be kept, which requires\\ndata migration if code (resp. profiling indicators, normalization) changes\\n#}\\n\\n{{\\n config(\\n enabled=var(\\\"enableProfiling\\\", false) | as_bool,\\n materialized=\\\"incremental\\\",\\n unique_key=\\\"profiled_week\\\"\\n )\\n}}\\n\\nselect\\n concat(substr(current_timestamp::text, 1, 4), EXTRACT(\\u0027week\\u0027 FROM current_timestamp)) as \\\"profiled_week\\\", -- \\u0027202221\\u0027 ; using current_timestamp because profiled_at is varchar\\n *\\nfrom {{ ref(\\\"profiledbt_source_appuiscommuns\\\") }}\", \"refs\": [[\"profiledbt_source_appuiscommuns\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.profiledbt_source_appuiscommuns_over_time\", \"unrendered_config\": {\"enabled\": true, \"exploitation\": null, \"materialized\": \"incremental\", \"unique_key\": \"profiled_week\"}}"},{"_id":32,"name":"profiledbt_source_appuiscommuns","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"profiledbt_source_appuiscommuns\", \"build_path\": null, \"checksum\": {\"checksum\": \"fafe243d012805db1060e27099a07b848a6c61908d44a71ccdb58b522134abc8\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"view\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647960445.629846, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": [\"model.fdr_appuiscommuns.osm_powsupp__appuiscommuns_supportaerien\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"source\", \"profiledbt_source_appuiscommuns\"], \"meta\": {}, \"name\": \"profiledbt_source_appuiscommuns\", \"original_file_path\": \"models/source/profiledbt_source_appuiscommuns.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"source/profiledbt_source_appuiscommuns.sql\", \"raw_sql\": \"{#\\nExample de profilage des donn\\u00e9es d\\u0027une source par le profiler de DBT Hub :\\n\\nOn _specific so that it gives insight even on wrong values (ex. commune INSEE id = \\\"ko\\\") NOOOO\\n#}\\n\\n-- depends_on: {{ ref(\\u0027osm_powsupp__appuiscommuns_supportaerien\\u0027) }}\\n{% if execute %}\\n {{ dbt_profiler.get_profile(relation=ref(\\u0027osm_powsupp__appuiscommuns_supportaerien\\u0027)) }}\\n{% endif %}\", \"refs\": [[\"osm_powsupp__appuiscommuns_supportaerien\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.profiledbt_source_appuiscommuns\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"view\"}}"},{"_id":33,"name":"osm_powsupp__appuiscommuns_supportaerien","use_case":"appuiscommuns","type":"supportaerien","definition":0,"dictionary":0,"normalization":1,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"osm_powsupp__appuiscommuns_supportaerien\", \"build_path\": null, \"checksum\": {\"checksum\": \"0a2453156e740f87072074f7d18dff01345621c499e018f36bf15f8426bdcae6\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"indexes\": [{\"columns\": [\"\\\"appuiscommunssupp__Id\\\"\"]}, {\"columns\": [\"geometry\"], \"type\": \"gist\"}], \"materialized\": \"table\", \"meta\": {\"type\": \"supportaerien\"}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": [\"normalization\", \"transformation\"]}, \"created_at\": 1647960445.6830337, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": [\"model.fdr_appuiscommuns.osm_powsupp__apcom_supportaerien_translated\"]}, \"description\": \"la normalisation en supportaerien de la source ...extract...\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"source\", \"osm_powsupp__appuiscommuns_supportaerien\"], \"meta\": {}, \"name\": \"osm_powsupp__appuiscommuns_supportaerien\", \"original_file_path\": \"models/source/osm_powsupp__appuiscommuns_supportaerien.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": \"fdr_appuiscommuns://models/appuiscommuns_schema.yml\", \"path\": \"source/osm_powsupp__appuiscommuns_supportaerien.sql\", \"raw_sql\": \"{#\\nNormalisation vers le mod\\u00e8le de donn\\u00e9es du cas d\\u0027usage \\\"appuiscommuns\\\" des donn\\u00e9es de type canalisation de la source \\\"osmgeodatamine_powersupports\\\"\\nPartie g\\u00e9n\\u00e9rique\\n\\nis a table only if has reconciliation\\n69s with its own indexes (23s without)\\n#}\\n\\n{{\\n config(\\n materialized=\\\"table\\\",\\n indexes=[{\\u0027columns\\u0027: [\\u0027\\\"appuiscommunssupp__Id\\\"\\u0027]}, \\n {\\u0027columns\\u0027: [\\u0027geometry\\u0027], \\u0027type\\u0027: \\u0027gist\\u0027},]\\n )\\n}}\\n\\nwith reconciled as (\\n\\nselect * from {{ ref(\\\"osm_powsupp__apcom_supportaerien_translated\\\") }}\\n{# NO else ARRAY fields that can\\u0027t be added (cast(null as ARRAY) syntax error in _definition when unioning in support_aerien later\\n{{ apcom_supportaerien_translated__reconciled(\\\"osm_powsupp__apcom_supportaerien_translated\\\") }}\\n#}\\n\\n{#\\n), commune_linked as (\\n -- reconciliation :\\n -- rather doing it after translation, because allows to do it all in one go,\\n -- moreover, commune is not necessary for other translation processings (dedup...).\\n -- NB. couldn\\u0027t be done earlier because reconciliation to communes requires a geometry field, so can\\u0027t be done on the source which hasn\\u0027t it (and is more efficient being in a table)\\n {%- set fields = adapter.get_columns_in_relation(ref(\\u0027osm_powsupp__apcom_supportaerien_translated\\u0027)) | map(attribute=\\\"column\\\") | list -%}-- BEWARE without | list it stays a generator that can only be iterated once\\n {#% set cols = dbt_utils.star(sourceModel, except=[fieldPrefix + \\\"fdrcommune__insee_id\\\",\\n fieldPrefix + \\\"commune__insee_id\\\", \\\"fdrcommune__insee_id\\\"]).split(\\u0027,\\u0027) %}\\n {{ apcom_supportaerien_translation__link_geometry_fdrcommune(\\\"all\\\", id_field=\\\"appuiscommunssupp__Id\\\", fields=fields) }#+}\\n#}\\n)\\n\\nselect * from reconciled\\n\\n{# TODO 2 phase dedup :\\nselect * from {{ apcom_supportaerien_translated__reconciled(\\\"osm_powsupp__apcom_supportaerien_translation\\\") }} translation\\nwhere translation.\\\"{{ fieldPrefix }}Id\\\" not in (select \\\"{{ fieldPrefix }}Id\\\" from {{ ref(\\\"apcom_supportaerien_translation__link_geometry_fdrcommune\\\") }})\\n\\nunion\\n\\nselect translation.* from {{ apcom_supportaerien_translated__reconciled(\\\"osm_powsupp__apcom_supportaerien_translation\\\") }} translation\\njoin {{ ref(\\\"apcom_supportaerien_translation__link_geometry_fdrcommune\\\") }} link on translation.\\\"{{ fieldPrefix }}Id\\\" = link.\\\"{{ fieldPrefix }}Id\\\" -- NOT left join\\n#}\", \"refs\": [[\"osm_powsupp__apcom_supportaerien_translated\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [\"normalization\", \"transformation\"], \"unique_id\": \"model.fdr_appuiscommuns.osm_powsupp__appuiscommuns_supportaerien\", \"unrendered_config\": {\"exploitation\": null, \"indexes\": [{\"columns\": [\"\\\"appuiscommunssupp__Id\\\"\"]}, {\"columns\": [\"geometry\"], \"type\": \"gist\"}], \"materialized\": \"table\"}}"},{"_id":34,"name":"osm_powsupp__apcom_supportaerien_translated","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":0,"node_json":"{\"alias\": \"osm_powsupp__apcom_supportaerien_translated\", \"build_path\": null, \"checksum\": {\"checksum\": \"c2ba66f3debedd34504625527d26b7da1ab1143cb3d908e9ff29a0caa0179466\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"table\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647960445.64139, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [\"macro.fdr_appuiscommuns.source_or_test_ref\", \"macro.fdr_appuiscommuns.osm_powsupp__apcom_supportaerien_specific\", \"macro.fdr_appuiscommuns.dedupe\", \"macro.fdr_appuiscommuns.apcom_supportaerien_translation__computed\"], \"nodes\": [\"seed.fdr_appuiscommuns.l_appuisaeriens_materiau__osmgeodatamine\", \"seed.fdr_appuiscommuns.l_appuisaeriens_materiau__osmgeodatamine\", \"seed.fdr_appuiscommuns.l_appuisaeriens_materiau__osmgeodatamine\", \"seed.fdr_appuiscommuns.l_pointaccueil_nature__mapping\", \"seed.fdr_appuiscommuns.l_pointaccueil_nature__mapping\", \"seed.fdr_appuiscommuns.l_pointaccueil_nature__mapping\"]}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"source\", \"osm_powsupp__apcom_supportaerien_translated\"], \"meta\": {}, \"name\": \"osm_powsupp__apcom_supportaerien_translated\", \"original_file_path\": \"models/source/osm_powsupp__apcom_supportaerien_translated.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"source/osm_powsupp__apcom_supportaerien_translated.sql\", \"raw_sql\": \"{#\\nNormalisation vers le mod\\u00e8le de donn\\u00e9es du cas d\\u0027usage \\\"appuiscommuns\\\" des donn\\u00e9es de type canalisation de la source \\\"osmgeodatamine_powersupports\\\"\\nPartie sp\\u00e9cifique \\u00e0 la source\\n\\nmake it a table IF needed for further processing before \\n#}\\n\\n{{\\n config(\\n materialized=\\\"table\\\"\\n )\\n}}\\n\\n{% set fieldPrefix = \\\"appuiscommunssupp__\\\" %}\\n\\n{% set sourceModel = source_or_test_ref(\\u0027appuiscommuns\\u0027, \\u0027osmgeodatamine_powersupports\\u0027) %}\\n\\nwith translation_specific as (\\n {{ osm_powsupp__apcom_supportaerien_specific(sourceModel) }}\\n \\n), id_deduped as (\\n -- id deduplication :\\n -- OR LATER ON normalized id\\n -- FOR MORE PERFORMANCE, REQUIRES PRIMARY KEY ON ID AND A TABLE SO NOT ON SOURCE\\n -- OK : 44s rather than 0,44 if on 1m lines rather than the 200 lines, even on translation view (or source view)\\n {#{ dedupe(\\u0027\\\"\\u0027 + this.schema + \\u0027\\\".\\\"osmgeodatamine_powersupports\\\"\\u0027, id_fields=[\\u0027\\\"osm_id\\\"\\u0027]) }#}\\n {{ dedupe(\\u0027translation_specific\\u0027, id_fields=[\\u0027\\\"appuiscommunssupp__src_id\\\"\\u0027]) }}\\n \\n), geometry_deduped as (\\n {#{ dedupe(\\u0027\\\"\\u0027 + this.schema + \\u0027\\\".\\\"osmgeodatamine_powersupports\\\"\\u0027, id_fields=[\\u0027\\\"osm_id\\\"\\u0027]) }#}\\n {{ dedupe(\\u0027translation_specific\\u0027, id_fields=[\\u0027\\\"geometry\\\"\\u0027]) }}\\n \\n), computed as (\\n {{ apcom_supportaerien_translation__computed(\\\"geometry_deduped\\\") }}\\n)\\n\\n-- NB. reconciliation to communes requires a geometry field, so can\\u0027t be done on the source (and is more efficient being in a table)\\n-- moreover, commune is not necessary for other translation handlings (dedup...). And doing it after translation allows to do it all in one go.\\n\\nselect * from computed\", \"refs\": [[\"l_appuisaeriens_materiau__osmgeodatamine\"], [\"l_appuisaeriens_materiau__osmgeodatamine\"], [\"l_appuisaeriens_materiau__osmgeodatamine\"], [\"l_pointaccueil_nature__mapping\"], [\"l_pointaccueil_nature__mapping\"], [\"l_pointaccueil_nature__mapping\"]], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.osm_powsupp__apcom_supportaerien_translated\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"table\"}}"},{"_id":35,"name":"meta_indicators","use_case":"appuiscommuns","type":"","definition":0,"dictionary":0,"normalization":0,"sample":0,"expected":0,"unification":0,"enriched":0,"indicators":1,"node_json":"{\"alias\": \"meta_indicators\", \"build_path\": null, \"checksum\": {\"checksum\": \"059f8e9cf2c883c3b41a0d95b914162a7b5c10053ffe082ef36bec79bac87143\", \"name\": \"sha256\"}, \"columns\": {}, \"compiled_path\": null, \"config\": {\"alias\": null, \"column_types\": {}, \"database\": null, \"enabled\": true, \"exploitation\": null, \"full_refresh\": null, \"materialized\": \"table\", \"meta\": {}, \"on_schema_change\": \"ignore\", \"persist_docs\": {}, \"post-hook\": [], \"pre-hook\": [], \"quoting\": {}, \"schema\": null, \"tags\": []}, \"created_at\": 1647961117.673971, \"database\": \"datastore\", \"deferred\": false, \"depends_on\": {\"macros\": [], \"nodes\": []}, \"description\": \"\", \"docs\": {\"show\": true}, \"fqn\": [\"fdr_appuiscommuns\", \"meta_indicators\"], \"meta\": {}, \"name\": \"meta_indicators\", \"original_file_path\": \"models/meta_indicators.sql\", \"package_name\": \"fdr_appuiscommuns\", \"patch_path\": null, \"path\": \"meta_indicators.sql\", \"raw_sql\": \"{#\\n | selectattr(\\\"resource_type\\\", \\\"equalto\\\", \\\"model\\\")\\n \\n , \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"definition\\\") | join() | replace(\\\"definition\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"dictionary\\\") | join() | replace(\\\"dictionary\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"normalization\\\") | join() | replace(\\\"normalization\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"sample\\\") | join() | replace(\\\"sample\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"expected\\\") | join() | replace(\\\"expected\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"unification\\\") | join() | replace(\\\"unification\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"enriched\\\") | join() | replace(\\\"enriched\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\u0027{{ node.tags | select(\\\"equalto\\\", \\\"indicators\\\") | join() | replace(\\\"indicators\\\", \\\"1\\\") | default(\\\"0\\\", true) }}\\u0027::integer,\\n \\n is_definition, is_dictionary,\\n is_normalization/*transformation*/, is_sample/*extract*/, /*is_test unittest*/is_expected,\\n is_unification, is_enriched,\\n is_indicators/*agg by*/,\\n \\n , is_definition, is_dictionary,\\n is_normalization/*transformation*/, is_sample/*extract*/, /*is_test unittest*/is_expected,\\n is_unification, is_enriched,\\n is_indicators,\\n#}\\n\\n{% if execute %}\\n{% set tags = [\\\"definition\\\", \\\"dictionary\\\", \\\"normalization\\\", \\\"sample\\\", \\\"expected\\\", \\\"unification\\\", \\\"enriched\\\", \\\"indicators\\\"] %}\\n{% set use_case = \\u0027appuiscommuns\\u0027 %}\\nwith nodes as (\\n\\n select * from (values\\n {% for node in graph.nodes.values() | selectattr(\\\"schema\\\", \\\"equalto\\\", this.schema) %}\\n (\\n \\u0027{{ node.name }}\\u0027, \\u0027{{ use_case }}\\u0027,\\n {% for tag in tags %}\\n {% if modules.re.match(\\\".+_\\\" + tag + \\\".*\\\", node.name) %}\\n 1,\\n {% else %}\\n {{ node.tags | select(\\\"equalto\\\", tag) | join() | replace(tag, \\\"1\\\") | default(\\\"0\\\", true) }},\\n {% endif %}\\n {% endfor %}\\n \\u0027{{ node | tojson() | replace(\\\"\\u0027\\\", \\\"\\u0027\\u0027\\\") }}\\u0027::json\\n )\\n {% if not loop.last %}\\n ,\\n {% endif %}\\n {% endfor %}\\n ) x (name, use_case,\\n {% for tag in tags %}\\n {{ tag }},\\n {% endfor %}\\n node_json)\\n), typed as (\\n select\\n name, use_case,\\n case \\\"definition\\\" = 1 or \\\"normalization\\\" = 1 or \\\"sample\\\" = 1 or \\\"expected\\\" = 1 or \\\"unification\\\" = 1 or \\\"enriched\\\" = 1 when TRUE then (regexp_match(name, \\u0027{{ use_case }}_([^_]*)\\u0027))[1] else NULL end as type,\\n {% for tag in tags %}\\n {{ tag }},\\n {% endfor %}\\n node_json\\n \\n from nodes\\n)\\n\\nselect * from typed\\n{% endif %}\\n\\n/*\\n Example output\\n---------------------------------------------------------------\\n...\\n*/\", \"refs\": [], \"resource_type\": \"model\", \"root_path\": \"/home/mdutoo/dev/ozwillo/workspace/fdr_appuiscommuns\", \"schema\": \"appuiscommuns_test\", \"sources\": [], \"tags\": [], \"unique_id\": \"model.fdr_appuiscommuns.meta_indicators\", \"unrendered_config\": {\"exploitation\": null, \"materialized\": \"table\"}}"}], "fields": [{"id": "_id", "type": "int"}, {"id": "name", "type": "text"}, {"id": "use_case", "type": "text"}, {"id": "type", "type": "text"}, {"id": "definition", "type": "numeric"}, {"id": "dictionary", "type": "numeric"}, {"id": "normalization", "type": "numeric"}, {"id": "sample", "type": "numeric"}, {"id": "expected", "type": "numeric"}, {"id": "unification", "type": "numeric"}, {"id": "enriched", "type": "numeric"}, {"id": "indicators", "type": "numeric"}, {"id": "node_json", "type": "text"}], "_links": {"start": "/api/3/action/datastore_search?resource_id=b7da96b3-869d-43a5-8673-d0f2cee61642", "next": "/api/3/action/datastore_search?resource_id=b7da96b3-869d-43a5-8673-d0f2cee61642&offset=100"}, "total": 35, "total_was_estimated": false}}