_id name use_case type definition dictionary normalization sample expected unification enriched indicators node_json 1 meta_indicators_by_type appuiscommuns "" 0 0 0 0 0 0 0 1 "{""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""}}" 2 appuiscommuns_supportaerien__definition appuiscommuns supportaerien 1 0 0 0 0 0 0 0 "{""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""}}" 3 osm_powersupports__supportaerien__expected_stg appuiscommuns "" 0 0 0 0 1 0 0 0 "{""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""}}" 4 appuiscommuns_supportaerien__example_stg appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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""}}" 5 l_appuisaeriens_materiau appuiscommuns "" 0 1 0 0 0 0 0 0 "{""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}}" 6 l_appuisaeriens_naturetraverse appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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}}" 7 l_appuisaeriens_equipements appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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}}" 8 osmgeodatamine_powersupports_extract appuiscommuns "" 0 0 0 1 0 0 0 0 "{""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}}" 9 l_appuisaeriens_precision appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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}}" 10 appuiscommuns_supportaerien__example appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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}}" 11 l_appuisaeriens_materiau__osmgeodatamine appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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}}" 12 l_appuisaeriens_composition appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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}}" 13 l_pointaccueil_nature__mapping appuiscommuns "" 0 1 0 0 0 0 0 0 "{""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}}" 14 birdz_extract appuiscommuns "" 0 0 0 1 0 0 0 0 "{""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}}" 15 l_pointaccueil_nature appuiscommuns "" 0 1 0 0 0 0 0 0 "{""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}}" 16 l_appuisaeriens_resistance appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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}}" 17 l_appuisaeriens_structure appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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}}" 18 osm_powersupports__supportaerien__expected appuiscommuns "" 0 0 0 0 1 0 0 0 "{""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}}" 19 megalis_exemple appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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}}" 20 fdr_appuiscommuns-on-run-start-0 appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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""}}" 21 georef-france-commune.csv appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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""}}" 22 apcom_supportaerien__duplicate_geometry appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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""}}" 23 apcom_supportaerien__fdrcommune appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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""}}" 24 appuiscommuns__supportaerien_indicators_commune_ot appuiscommuns "" 0 0 0 0 0 0 0 1 "{""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\"")""}}" 25 appuiscommuns__supportaerien_indicators_commune appuiscommuns "" 0 0 0 0 0 0 0 1 "{""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""}}" 26 appuiscommuns__supportaerien_indicators_region_ot appuiscommuns "" 0 0 0 0 0 0 0 1 "{""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\"")""}}" 27 appuiscommuns__supportaerien_indicators_region appuiscommuns "" 0 0 0 0 0 0 0 1 "{""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""}}" 28 appuiscommuns_supportaerien_enriched appuiscommuns supportaerien 0 0 0 0 0 0 1 0 "{""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""}}" 29 appuiscommuns_supportaerien_linked appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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""}}" 30 appuiscommuns_supportaerien appuiscommuns supportaerien 0 0 0 0 0 1 0 0 "{""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""}}" 31 profiledbt_source_appuiscommuns_over_time appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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""}}" 32 profiledbt_source_appuiscommuns appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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""}}" 33 osm_powsupp__appuiscommuns_supportaerien appuiscommuns supportaerien 0 0 1 0 0 0 0 0 "{""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""}}" 34 osm_powsupp__apcom_supportaerien_translated appuiscommuns "" 0 0 0 0 0 0 0 0 "{""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""}}" 35 meta_indicators appuiscommuns "" 0 0 0 0 0 0 0 1 "{""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""}}"