== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (16)
+- SubqueryAlias (15)
+- View (14)
+- Project (13)
+- Project (12)
+- Project (11)
+- Project (10)
+- Filter (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- SubqueryAlias (5)
+- View (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `tmp_ad0c08bd155c4a709f2f27535462eaeb`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [_CODE_INSEE#256032, _DEPARTEMENT_CODE#256033, _DEPARTEMENT_NOM#256034, _EPCI_CODE#256035, _EPCI_NOM#256036, _NOM#256037, _REGION_CODE#256038, _REGION_NOM#256039], false
(4) View
Arguments: `ATMO_COMMUNE_264109170`, true
(5) SubqueryAlias
Arguments: ATMO_COMMUNE_264109170
(6) Project
Arguments: [_CODE_INSEE#256032 AS ATMO_COMMUNE_264109__CODE_INSEE#256056, _DEPARTEMENT_CODE#256033 AS ATMO_COMMUNE_264109__DEPARTEMENT_CODE#256057, _DEPARTEMENT_NOM#256034 AS ATMO_COMMUNE_264109__DEPARTEMENT_NOM#256058, _EPCI_CODE#256035 AS ATMO_COMMUNE_264109__EPCI_CODE#256059, _EPCI_NOM#256036 AS ATMO_COMMUNE_264109__EPCI_NOM#256060, _NOM#256037 AS ATMO_COMMUNE_264109__NOM#256061, _REGION_CODE#256038 AS ATMO_COMMUNE_264109__REGION_CODE#256062, _REGION_NOM#256039 AS ATMO_COMMUNE_264109__REGION_NOM#256063]
(7) Project
Arguments: [cast(ATMO_COMMUNE_264109__CODE_INSEE#256056 as string) AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#256080, cast(ATMO_COMMUNE_264109__DEPARTEMENT_CODE#256057 as string) AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#256081, cast(ATMO_COMMUNE_264109__DEPARTEMENT_NOM#256058 as string) AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#256082, cast(ATMO_COMMUNE_264109__EPCI_CODE#256059 as string) AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#256083, cast(ATMO_COMMUNE_264109__EPCI_NOM#256060 as string) AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#256084, cast(ATMO_COMMUNE_264109__NOM#256061 as string) AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#256085, cast(ATMO_COMMUNE_264109__REGION_CODE#256062 as string) AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#256086, cast(ATMO_COMMUNE_264109__REGION_NOM#256063 as string) AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#256087]
(8) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#256080 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#256096, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#256081 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#256097, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#256082 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#256098, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#256083 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#256099, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#256084 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#256100, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#256085 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#256101, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#256086 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#256102, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#256087 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#256103]
(9) Filter
Arguments: (COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#256096 <=> cast(38397 as string))
(10) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#256096 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#256112, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#256097 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#256113, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#256098 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#256114, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#256099 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#256115, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#256100 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#256116, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#256101 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#256117, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#256102 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#256118, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#256103 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#256119]
(11) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#256112 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#256128, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#256113 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#256129, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#256114 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#256130, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#256115 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#256131, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#256116 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#256132, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#256117 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#256133, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#256118 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#256134, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#256119 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#256135]
(12) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#256128, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#256129, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#256130, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#256131, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#256132, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#256133, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#256134, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#256135, http_get(str_join(array(cast(https://api.atmo-aura.fr/api/v1/communes/ as string), COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#256128, cast(/indices/atmo?api_token=df1f9022ccb116228552b54b45d14f70&date_calcul=now as string)), cast( as string))) AS COL_85A4A615_EB20_46BE_8D82_57672471139A#256144]
(13) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#256128 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#256154, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#256129 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#256155, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#256130 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#256156, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#256131 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#256157, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#256132 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#256158, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#256133 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#256159, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#256134 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#256160, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#256135 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#256161, COL_85A4A615_EB20_46BE_8D82_57672471139A#256144 AS COL_85A4A615_EB20_46BE_8D82_57672471139A#256162]
(14) View
Arguments: `ATMO_POLLUANT_264118170`, true
(15) SubqueryAlias
Arguments: ATMO_POLLUANT_264118170
(16) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#256154, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#256155, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#256156, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#256157, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#256158, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#256159, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#256160, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#256161, COL_85A4A615_EB20_46BE_8D82_57672471139A#256162]