== 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_a6dbc7bf314443daa137c72091e93090`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [_CODE_INSEE#474450, _DEPARTEMENT_CODE#474451, _DEPARTEMENT_NOM#474452, _EPCI_CODE#474453, _EPCI_NOM#474454, _NOM#474455, _REGION_CODE#474456, _REGION_NOM#474457], false
(4) View
Arguments: `ATMO_COMMUNE_26410991`, true
(5) SubqueryAlias
Arguments: ATMO_COMMUNE_26410991
(6) Project
Arguments: [_CODE_INSEE#474450 AS ATMO_COMMUNE_264109__CODE_INSEE#474474, _DEPARTEMENT_CODE#474451 AS ATMO_COMMUNE_264109__DEPARTEMENT_CODE#474475, _DEPARTEMENT_NOM#474452 AS ATMO_COMMUNE_264109__DEPARTEMENT_NOM#474476, _EPCI_CODE#474453 AS ATMO_COMMUNE_264109__EPCI_CODE#474477, _EPCI_NOM#474454 AS ATMO_COMMUNE_264109__EPCI_NOM#474478, _NOM#474455 AS ATMO_COMMUNE_264109__NOM#474479, _REGION_CODE#474456 AS ATMO_COMMUNE_264109__REGION_CODE#474480, _REGION_NOM#474457 AS ATMO_COMMUNE_264109__REGION_NOM#474481]
(7) Project
Arguments: [cast(ATMO_COMMUNE_264109__CODE_INSEE#474474 as string) AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#474498, cast(ATMO_COMMUNE_264109__DEPARTEMENT_CODE#474475 as string) AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#474499, cast(ATMO_COMMUNE_264109__DEPARTEMENT_NOM#474476 as string) AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#474500, cast(ATMO_COMMUNE_264109__EPCI_CODE#474477 as string) AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#474501, cast(ATMO_COMMUNE_264109__EPCI_NOM#474478 as string) AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#474502, cast(ATMO_COMMUNE_264109__NOM#474479 as string) AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#474503, cast(ATMO_COMMUNE_264109__REGION_CODE#474480 as string) AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#474504, cast(ATMO_COMMUNE_264109__REGION_NOM#474481 as string) AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#474505]
(8) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#474498 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#474514, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#474499 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#474515, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#474500 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#474516, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#474501 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#474517, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#474502 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#474518, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#474503 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#474519, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#474504 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#474520, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#474505 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#474521]
(9) Filter
Arguments: (COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#474514 <=> cast(38397 as string))
(10) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#474514 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#474530, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#474515 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#474531, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#474516 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#474532, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#474517 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#474533, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#474518 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#474534, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#474519 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#474535, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#474520 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#474536, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#474521 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#474537]
(11) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#474530 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#474546, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#474531 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#474547, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#474532 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#474548, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#474533 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#474549, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#474534 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#474550, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#474535 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#474551, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#474536 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#474552, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#474537 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#474553]
(12) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#474546, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#474547, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#474548, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#474549, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#474550, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#474551, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#474552, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#474553, http_get(str_join(array(cast(https://api.atmo-aura.fr/api/v1/communes/ as string), COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#474546, cast(/indices/atmo?api_token=df1f9022ccb116228552b54b45d14f70&date_calcul=now as string)), cast( as string))) AS COL_85A4A615_EB20_46BE_8D82_57672471139A#474562]
(13) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#474546 AS COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#474572, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#474547 AS COL_071908B2_A72F_41E5_9859_D2361AD3B69B#474573, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#474548 AS COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#474574, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#474549 AS COL_80C60058_9D63_4D50_B3EB_16A93C96824F#474575, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#474550 AS COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#474576, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#474551 AS COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#474577, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#474552 AS COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#474578, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#474553 AS COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#474579, COL_85A4A615_EB20_46BE_8D82_57672471139A#474562 AS COL_85A4A615_EB20_46BE_8D82_57672471139A#474580]
(14) View
Arguments: `ATMO_POLLUANT_26411891`, true
(15) SubqueryAlias
Arguments: ATMO_POLLUANT_26411891
(16) Project
Arguments: [COL_F33AF086_2CB5_4A8D_A094_D99AD523F52C#474572, COL_071908B2_A72F_41E5_9859_D2361AD3B69B#474573, COL_BC874229_6C31_418F_972B_EF3B4BA87A5E#474574, COL_80C60058_9D63_4D50_B3EB_16A93C96824F#474575, COL_7518EB9B_0AEE_4316_B3B7_6CF0A3CB49D4#474576, COL_E0717366_7AC0_4731_B1C4_DA6958FC7429#474577, COL_DC4485D0_956F_44C7_B50B_663AF3F881EA#474578, COL_5CA90C34_5AD3_4BB7_8F98_6B778EA70CD6#474579, COL_85A4A615_EB20_46BE_8D82_57672471139A#474580]