ClickHouse logo
  • English
  • Japanese
  • Products
    • ClickHouse CloudClickHouse Cloud
      The best way to use ClickHouse.
      Available on AWS, GCP, and Azure.
    • ClickHouse BYOCBring Your Own Cloud
      A fully managed ClickHouse Cloud service,
      deployed in your own AWS account.
    • ClickHouseClickHouse
      Spin up a database with open-
      source ClickHouse.
    • chDBView 100+ integrations
    View 100+ integrations ->->
  • Use cases
    • Real-time analytics
    • Machine learning and GenAI
    • Data warehousing
    • Observability
    • All use cases
    All use cases ->->
  • Docs
  • Resources
    • User stories
    • Blog
    • Events
    • News
    • Learning and certification
    • Comparisons
      • BigQuery
      • PostgreSQL
      • Redshift
      • Snowflake
    • Videos
    • Demos
  • Pricing
  • Contact us
  • English
  • Japanese
41.3kSign in

Videos / ClickHouse

A function that runs queries in an infinite loop

Mark Needham Product Marketing Engineer

In this video, we will learn about the loop function, which runs queries in an infinite loop. It sounds strange, but is useful!

https://clickhouse.com/docs/en/sql-reference/table-functions/loop

Recent videos

YouTube Video: y9biAm_FkqwYouTube Video: y9biAm_Fkqw
ClickHouse

The ClickHouse MCP Server

Mark Needham

YouTube Video: mJCo_wszNicYouTube Video: mJCo_wszNic
ClickHouse

The ClickHouse monitoring dashboard

Mark Needham, Product Marketing Engineer

YouTube Video: 4w7zWG7NoSYYouTube Video: 4w7zWG7NoSY
ClickHouse

ClickHouse v25.1 Release Webinar

Alexey Milovidov, Mark Needham

Follow us
X imageBluesky imageSlack image
GitHub imageTelegram imageMeetup image
Rss image

Products

  • ClickHouse Cloud
  • ClickHouse
  • Bring Your Own Cloud
  • ClickHouse Government
  • ClickHouse Keeper
  • ClickPipes
  • Integrations
  • chDB
  • Trust center
  • Pricing

Resources

  • Documentation
  • Training
  • Support
  • Benchmarks
  • Use cases
  • Videos
  • Demos
  • Real-time data warehouse
  • Open House videos

Company

  • Blog
  • Our story
  • Careers
  • Contact us
  • Events
  • News
  • Media

Join our community

  • GitHub
  • Slack
  • LinkedIn
  • X
  • Bluesky
  • Telegram
  • Meetup

Comparisons

  • BigQuery
  • PostgreSQL
  • Redshift
  • Snowflake
  • Partners

  • AWS
  • Azure
ClickHouse logo
Stay informed on feature releases, product roadmap, support, and cloud offerings!
Loading form...
© 2025 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.
TrademarkPrivacySecurityLegalCookie policy