== 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_fc21381d35584c17ada91ebcfcbd5b8a`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [_CODE_INSEE#126801, _DEPARTEMENT_CODE#126802, _DEPARTEMENT_NOM#126803, _EPCI_CODE#126804, _EPCI_NOM#126805, _NOM#126806, _REGION_CODE#126807, _REGION_NOM#126808], false
(4) View
Arguments: `ATMO_COMMUNE_264109174`, true
(5) SubqueryAlias
Arguments: ATMO_COMMUNE_264109174
(6) Project
Arguments: [_CODE_INSEE#126801 AS ATMO_COMMUNE_264109__CODE_INSEE#126825, _DEPARTEMENT_CODE#126802 AS ATMO_COMMUNE_264109__DEPARTEMENT_CODE#126826, _DEPARTEMENT_NOM#126803 AS ATMO_COMMUNE_264109__DEPARTEMENT_NOM#126827, _EPCI_CODE#126804 AS ATMO_COMMUNE_264109__EPCI_CODE#126828, _EPCI_NOM#126805 AS ATMO_COMMUNE_264109__EPCI_NOM#126829, _NOM#126806 AS ATMO_COMMUNE_264109__NOM#126830, _REGION_CODE#126807 AS ATMO_COMMUNE_264109__REGION_CODE#126831, _REGION_NOM#126808 AS ATMO_COMMUNE_264109__REGION_NOM#126832]
(7) Project
Arguments: [cast(ATMO_COMMUNE_264109__CODE_INSEE#126825 as string) AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#126849, cast(ATMO_COMMUNE_264109__DEPARTEMENT_CODE#126826 as string) AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#126850, cast(ATMO_COMMUNE_264109__DEPARTEMENT_NOM#126827 as string) AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#126851, cast(ATMO_COMMUNE_264109__EPCI_CODE#126828 as string) AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#126852, cast(ATMO_COMMUNE_264109__EPCI_NOM#126829 as string) AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#126853, cast(ATMO_COMMUNE_264109__NOM#126830 as string) AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#126854, cast(ATMO_COMMUNE_264109__REGION_CODE#126831 as string) AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#126855, cast(ATMO_COMMUNE_264109__REGION_NOM#126832 as string) AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#126856]
(8) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#126849 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#126865, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#126850 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#126866, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#126851 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#126867, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#126852 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#126868, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#126853 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#126869, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#126854 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#126870, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#126855 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#126871, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#126856 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#126872]
(9) Filter
Arguments: (COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#126865 <=> cast(38397 as string))
(10) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#126865 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#126881, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#126866 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#126882, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#126867 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#126883, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#126868 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#126884, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#126869 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#126885, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#126870 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#126886, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#126871 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#126887, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#126872 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#126888]
(11) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#126881 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#126897, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#126882 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#126898, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#126883 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#126899, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#126884 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#126900, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#126885 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#126901, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#126886 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#126902, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#126887 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#126903, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#126888 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#126904]
(12) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#126897, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#126898, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#126899, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#126900, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#126901, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#126902, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#126903, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#126904, http_get(str_join(array(cast(https://api.atmo-aura.fr/api/v1/communes/ as string), COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#126897, cast(/indices/atmo?api_token=df1f9022ccb116228552b54b45d14f70&date_calcul=now as string)), cast( as string))) AS COL_85A4A615_EB20_46BE_8D82_57672471139A#126913]
(13) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#126897 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#126923, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#126898 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#126924, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#126899 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#126925, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#126900 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#126926, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#126901 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#126927, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#126902 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#126928, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#126903 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#126929, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#126904 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#126930, COL_85A4A615_EB20_46BE_8D82_57672471139A#126913 AS COL_85A4A615_EB20_46BE_8D82_57672471139A#126931]
(14) View
Arguments: `ATMO_POLLUANT_264118174`, true
(15) SubqueryAlias
Arguments: ATMO_POLLUANT_264118174
(16) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#126923, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#126924, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#126925, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#126926, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#126927, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#126928, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#126929, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#126930, COL_85A4A615_EB20_46BE_8D82_57672471139A#126931]