== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- 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: `ATMO_POLLUANT_264118174`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [_CODE_INSEE#263833, _DEPARTEMENT_CODE#263834, _DEPARTEMENT_NOM#263835, _EPCI_CODE#263836, _EPCI_NOM#263837, _NOM#263838, _REGION_CODE#263839, _REGION_NOM#263840], false
(4) View
Arguments: `ATMO_COMMUNE_264109174`, true
(5) SubqueryAlias
Arguments: ATMO_COMMUNE_264109174
(6) Project
Arguments: [_CODE_INSEE#263833 AS ATMO_COMMUNE_264109__CODE_INSEE#263857, _DEPARTEMENT_CODE#263834 AS ATMO_COMMUNE_264109__DEPARTEMENT_CODE#263858, _DEPARTEMENT_NOM#263835 AS ATMO_COMMUNE_264109__DEPARTEMENT_NOM#263859, _EPCI_CODE#263836 AS ATMO_COMMUNE_264109__EPCI_CODE#263860, _EPCI_NOM#263837 AS ATMO_COMMUNE_264109__EPCI_NOM#263861, _NOM#263838 AS ATMO_COMMUNE_264109__NOM#263862, _REGION_CODE#263839 AS ATMO_COMMUNE_264109__REGION_CODE#263863, _REGION_NOM#263840 AS ATMO_COMMUNE_264109__REGION_NOM#263864]
(7) Project
Arguments: [cast(ATMO_COMMUNE_264109__CODE_INSEE#263857 as string) AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#263881, cast(ATMO_COMMUNE_264109__DEPARTEMENT_CODE#263858 as string) AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#263882, cast(ATMO_COMMUNE_264109__DEPARTEMENT_NOM#263859 as string) AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#263883, cast(ATMO_COMMUNE_264109__EPCI_CODE#263860 as string) AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#263884, cast(ATMO_COMMUNE_264109__EPCI_NOM#263861 as string) AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#263885, cast(ATMO_COMMUNE_264109__NOM#263862 as string) AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#263886, cast(ATMO_COMMUNE_264109__REGION_CODE#263863 as string) AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#263887, cast(ATMO_COMMUNE_264109__REGION_NOM#263864 as string) AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#263888]
(8) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#263881 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#263897, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#263882 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#263898, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#263883 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#263899, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#263884 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#263900, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#263885 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#263901, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#263886 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#263902, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#263887 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#263903, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#263888 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#263904]
(9) Filter
Arguments: (COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#263897 <=> cast(38397 as string))
(10) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#263897 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#263913, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#263898 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#263914, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#263899 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#263915, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#263900 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#263916, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#263901 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#263917, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#263902 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#263918, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#263903 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#263919, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#263904 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#263920]
(11) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#263913 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#263929, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#263914 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#263930, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#263915 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#263931, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#263916 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#263932, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#263917 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#263933, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#263918 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#263934, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#263919 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#263935, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#263920 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#263936]
(12) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#263929, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#263930, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#263931, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#263932, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#263933, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#263934, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#263935, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#263936, http_get(str_join(array(cast(https://api.atmo-aura.fr/api/v1/communes/ as string), COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#263929, cast(/indices/atmo?api_token=df1f9022ccb116228552b54b45d14f70&date_calcul=now as string)), cast( as string))) AS COL_85A4A615_EB20_46BE_8D82_57672471139A#263945]
(13) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#263929 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#263955, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#263930 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#263956, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#263931 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#263957, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#263932 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#263958, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#263933 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#263959, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#263934 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#263960, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#263935 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#263961, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#263936 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#263962, COL_85A4A615_EB20_46BE_8D82_57672471139A#263945 AS COL_85A4A615_EB20_46BE_8D82_57672471139A#263963]