== 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_917c51965fc24cf09c474f0db16a48a4`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [_CODE_INSEE#120668, _DEPARTEMENT_CODE#120669, _DEPARTEMENT_NOM#120670, _EPCI_CODE#120671, _EPCI_NOM#120672, _NOM#120673, _REGION_CODE#120674, _REGION_NOM#120675], false
(4) View
Arguments: `ATMO_COMMUNE_264109169`, true
(5) SubqueryAlias
Arguments: ATMO_COMMUNE_264109169
(6) Project
Arguments: [_CODE_INSEE#120668 AS ATMO_COMMUNE_264109__CODE_INSEE#120692, _DEPARTEMENT_CODE#120669 AS ATMO_COMMUNE_264109__DEPARTEMENT_CODE#120693, _DEPARTEMENT_NOM#120670 AS ATMO_COMMUNE_264109__DEPARTEMENT_NOM#120694, _EPCI_CODE#120671 AS ATMO_COMMUNE_264109__EPCI_CODE#120695, _EPCI_NOM#120672 AS ATMO_COMMUNE_264109__EPCI_NOM#120696, _NOM#120673 AS ATMO_COMMUNE_264109__NOM#120697, _REGION_CODE#120674 AS ATMO_COMMUNE_264109__REGION_CODE#120698, _REGION_NOM#120675 AS ATMO_COMMUNE_264109__REGION_NOM#120699]
(7) Project
Arguments: [cast(ATMO_COMMUNE_264109__CODE_INSEE#120692 as string) AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#120716, cast(ATMO_COMMUNE_264109__DEPARTEMENT_CODE#120693 as string) AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#120717, cast(ATMO_COMMUNE_264109__DEPARTEMENT_NOM#120694 as string) AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#120718, cast(ATMO_COMMUNE_264109__EPCI_CODE#120695 as string) AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#120719, cast(ATMO_COMMUNE_264109__EPCI_NOM#120696 as string) AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#120720, cast(ATMO_COMMUNE_264109__NOM#120697 as string) AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#120721, cast(ATMO_COMMUNE_264109__REGION_CODE#120698 as string) AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#120722, cast(ATMO_COMMUNE_264109__REGION_NOM#120699 as string) AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#120723]
(8) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#120716 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#120732, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#120717 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#120733, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#120718 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#120734, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#120719 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#120735, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#120720 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#120736, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#120721 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#120737, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#120722 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#120738, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#120723 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#120739]
(9) Filter
Arguments: (COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#120732 <=> cast(38397 as string))
(10) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#120732 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#120748, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#120733 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#120749, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#120734 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#120750, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#120735 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#120751, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#120736 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#120752, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#120737 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#120753, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#120738 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#120754, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#120739 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#120755]
(11) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#120748 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#120764, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#120749 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#120765, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#120750 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#120766, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#120751 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#120767, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#120752 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#120768, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#120753 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#120769, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#120754 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#120770, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#120755 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#120771]
(12) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#120764, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#120765, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#120766, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#120767, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#120768, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#120769, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#120770, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#120771, http_get(str_join(array(cast(https://api.atmo-aura.fr/api/v1/communes/ as string), COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#120764, cast(/indices/atmo?api_token=df1f9022ccb116228552b54b45d14f70&date_calcul=now as string)), cast( as string))) AS COL_85A4A615_EB20_46BE_8D82_57672471139A#120780]
(13) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#120764 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#120790, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#120765 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#120791, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#120766 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#120792, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#120767 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#120793, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#120768 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#120794, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#120769 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#120795, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#120770 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#120796, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#120771 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#120797, COL_85A4A615_EB20_46BE_8D82_57672471139A#120780 AS COL_85A4A615_EB20_46BE_8D82_57672471139A#120798]
(14) View
Arguments: `ATMO_POLLUANT_264118169`, true
(15) SubqueryAlias
Arguments: ATMO_POLLUANT_264118169
(16) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#120790, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#120791, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#120792, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#120793, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#120794, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#120795, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#120796, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#120797, COL_85A4A615_EB20_46BE_8D82_57672471139A#120798]