== 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_d32a29baf677439284c158c33191df03`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [_CODE_INSEE#366675, _DEPARTEMENT_CODE#366676, _DEPARTEMENT_NOM#366677, _EPCI_CODE#366678, _EPCI_NOM#366679, _NOM#366680, _REGION_CODE#366681, _REGION_NOM#366682], false
(4) View
Arguments: `ATMO_COMMUNE_264109169`, true
(5) SubqueryAlias
Arguments: ATMO_COMMUNE_264109169
(6) Project
Arguments: [_CODE_INSEE#366675 AS ATMO_COMMUNE_264109__CODE_INSEE#366699, _DEPARTEMENT_CODE#366676 AS ATMO_COMMUNE_264109__DEPARTEMENT_CODE#366700, _DEPARTEMENT_NOM#366677 AS ATMO_COMMUNE_264109__DEPARTEMENT_NOM#366701, _EPCI_CODE#366678 AS ATMO_COMMUNE_264109__EPCI_CODE#366702, _EPCI_NOM#366679 AS ATMO_COMMUNE_264109__EPCI_NOM#366703, _NOM#366680 AS ATMO_COMMUNE_264109__NOM#366704, _REGION_CODE#366681 AS ATMO_COMMUNE_264109__REGION_CODE#366705, _REGION_NOM#366682 AS ATMO_COMMUNE_264109__REGION_NOM#366706]
(7) Project
Arguments: [cast(ATMO_COMMUNE_264109__CODE_INSEE#366699 as string) AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#366723, cast(ATMO_COMMUNE_264109__DEPARTEMENT_CODE#366700 as string) AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#366724, cast(ATMO_COMMUNE_264109__DEPARTEMENT_NOM#366701 as string) AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#366725, cast(ATMO_COMMUNE_264109__EPCI_CODE#366702 as string) AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#366726, cast(ATMO_COMMUNE_264109__EPCI_NOM#366703 as string) AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#366727, cast(ATMO_COMMUNE_264109__NOM#366704 as string) AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#366728, cast(ATMO_COMMUNE_264109__REGION_CODE#366705 as string) AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#366729, cast(ATMO_COMMUNE_264109__REGION_NOM#366706 as string) AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#366730]
(8) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#366723 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#366739, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#366724 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#366740, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#366725 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#366741, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#366726 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#366742, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#366727 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#366743, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#366728 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#366744, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#366729 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#366745, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#366730 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#366746]
(9) Filter
Arguments: (COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#366739 <=> cast(38397 as string))
(10) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#366739 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#366755, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#366740 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#366756, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#366741 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#366757, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#366742 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#366758, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#366743 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#366759, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#366744 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#366760, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#366745 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#366761, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#366746 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#366762]
(11) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#366755 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#366771, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#366756 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#366772, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#366757 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#366773, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#366758 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#366774, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#366759 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#366775, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#366760 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#366776, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#366761 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#366777, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#366762 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#366778]
(12) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#366771, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#366772, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#366773, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#366774, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#366775, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#366776, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#366777, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#366778, http_get(str_join(array(cast(https://api.atmo-aura.fr/api/v1/communes/ as string), COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#366771, cast(/indices/atmo?api_token=df1f9022ccb116228552b54b45d14f70&date_calcul=now as string)), cast( as string))) AS COL_85A4A615_EB20_46BE_8D82_57672471139A#366787]
(13) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#366771 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#366797, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#366772 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#366798, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#366773 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#366799, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#366774 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#366800, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#366775 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#366801, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#366776 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#366802, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#366777 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#366803, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#366778 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#366804, COL_85A4A615_EB20_46BE_8D82_57672471139A#366787 AS COL_85A4A615_EB20_46BE_8D82_57672471139A#366805]
(14) View
Arguments: `ATMO_POLLUANT_264118169`, true
(15) SubqueryAlias
Arguments: ATMO_POLLUANT_264118169
(16) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#366797, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#366798, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#366799, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#366800, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#366801, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#366802, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#366803, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#366804, COL_85A4A615_EB20_46BE_8D82_57672471139A#366805]