{"id":17767,"date":"2025-08-19T15:19:06","date_gmt":"2025-08-19T12:19:06","guid":{"rendered":"https:\/\/spatialworld.fi\/?page_id=17767"},"modified":"2025-11-06T10:05:07","modified_gmt":"2025-11-06T08:05:07","slug":"fme-blog-duckdb-llm-reporting","status":"publish","type":"page","link":"https:\/\/spatialworld.fi\/fi\/fme-blog-duckdb-llm-reporting\/","title":{"rendered":"kysymys-sql-raportti-fme-duckdb"},"content":{"rendered":"[vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text css=”” text_direction=”default”]\n

Vastaa mihin tahansa kysymykseen mist\u00e4 tahansa aineistosta FME:n, DuckDB:n ja OpenAI:n avulla.<\/h1>\n[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][image_with_animation image_url=”17854″ image_size=”full” max_width=”100%” max_width_mobile=”default” animation_type=”entrance” animation=”None” animation_movement_type=”transform_y” hover_animation=”none” alignment=”center” border_radius=”none” box_shadow=”none” image_loading=”default”][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text css=”” text_direction=”default”]\n

Johdanto<\/h1>\n

Tavoite: <\/strong>N\u00e4ytt\u00e4\u00e4 vaiheittain, miten hy\u00f6dynnet\u00e4\u00e4n FME:n joustavuutta ja orkestrointia, DuckDB:t\u00e4 ja LLM:i\u00e4 vastaamaan kysymyksiin aineistosta.<\/p>\n

L\u00e4hestymistapa:<\/strong> Yhdist\u00e4mme FME:n vankan ingestoinnin, DuckDB:n nopean SQL+metadata-k\u00e4sittelyn ja kolme LLM-roolia (Planner, SQL Generator ja Analyst) tuottamaan kyselyt ja render\u00f6im\u00e4\u00e4n HTML-raportin.<\/p>\n

Mit\u00e4 saat:<\/strong> Uudelleenk\u00e4ytett\u00e4v\u00e4 FME-ty\u00f6tila, joka muuntaa mink\u00e4 tahansa taulukkomuotoisen sy\u00f6tteen Parquet-muotoon, poimii skeeman\/tiivistelm\u00e4n\/otoksen, suunnittelee kysymykset, ajaa SQL:t ja tuottaa markdownista HTML-analyysin.<\/p>\n

Aineisto:<\/strong><\/p>\n

Excel-tiedosto (suomenkieliset otsikot), jossa on p\u00e4ivitt\u00e4iset py\u00f6r\u00e4ilij\u00e4m\u00e4\u00e4r\u00e4t sensoripaikoittain Helsingiss\u00e4.<\/a><\/p>\n

Mallipohja:<\/strong><\/p>\n

https:\/\/hub.safe.com\/publishers\/antoine\/templates\/llm_sql_report_demo<\/p>\n

Esimerkkikysymys:<\/strong><\/p>\n

Miss\u00e4 on eniten py\u00f6r\u00e4ilij\u00f6it\u00e4? Milloin se tapahtuu?<\/p>\n

P\u00e4\u00e4vaiheet ovat:<\/strong><\/p>\n

    \n
  1. Muunna mik\u00e4 tahansa tiedosto v\u00e4liaikaiseksi Parquetiksi FME:ll\u00e4<\/li>\n
  2. Suorita yksinkertainen analyysi Parquet-tiedostolle DuckDB:ll\u00e4 saadaksesi metatiedot<\/li>\n
  3. Pyyd\u00e4 LLM:\u00e4\u00e4, jolle on sy\u00f6tetty metatiedot, tuottamaan formalisoituja kysymyksi\u00e4 ja SQL-kyselyj\u00e4, joilla kysymykseen voidaan vastata<\/li>\n
  4. Pyyd\u00e4 toista, kevyemp\u00e4\u00e4 LLM:\u00e4\u00e4 generoimaan SQL-kyselyt ensimm\u00e4isen mallin yksinkertaisempien\/muodollisempien kysymysten pohjalta<\/li>\n
  5. Aja kaikki SQL-kyselyt DuckDB:ll\u00e4 koko v\u00e4liaikaisessa taulussa<\/li>\n
  6. LLM analysoi SQL-vastaukset suhteessa alkuper\u00e4iseen teht\u00e4v\u00e4\u00e4n<\/li>\n
  7. FME ja LLM tuottavat yhdess\u00e4 HTML-raportin, joka vastaa kokonaiskysymyksiin<\/li>\n<\/ol>\n[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text css=”” text_direction=”default”]\n

    1. Muunna mik\u00e4 tahansa tiedosto Parquetiksi<\/span><\/h1>\n[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][image_with_animation image_url=”17855″ image_size=”full” max_width=”100%” max_width_mobile=”default” animation_type=”entrance” animation=”None” animation_movement_type=”transform_y” hover_animation=”none” alignment=”center” border_radius=”none” box_shadow=”none” image_loading=”default”][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text css=”” text_direction=”default”]FME on eritt\u00e4in tehokas ty\u00f6kalu, joka pystyy k\u00e4sittelem\u00e4\u00e4n satoja formaatteja sis\u00e4iseen muotoonsa. T\u00e4ss\u00e4 sy\u00f6tteen\u00e4 on (hieman erikoinen) suomenkielinen Excel. Muunnamme sen dynaamisesti Parquet-muotoon:<\/p>\n