---
title: "Changelog: New API endpoints pages for easier integration, upgraded version of ClickHouse® and more"
excerpt: "Building real-time data apps/products gets faster everyday with Tinybird: a new way to publish and consume API endpoints, Tinybird running on the latest version of ClickHouse® and a wealth of other small but critical enhancements. That, plus a beta release of our most powerful tool yet"
authors: "Jorge Sancha"
categories: "Product updates"
createdOn: "2023-09-25 00:00:00"
publishedOn: "2020-09-18 00:00:00"
updatedOn: "2025-04-24 00:00:00"
status: "published"
---

<p>Building real-time data apps &amp; products gets faster everyday with Tinybird: a new way to publish and consume API endpoints, Tinybird running on the latest version of ClickHouse® and a wealth of other small but critical enhancements.</p><p>That, plus a lot of progress on a yet unreleased project, is what we’ve been up to lately.</p><h2 id="what%E2%80%99s-new"><strong>What’s new?</strong></h2><h3 id="analytics-api-endpoints">Analytics API endpoints</h3><p>Publishing API endpoints in Tinybird couldn’t be easier: bring your data, write your SQL and click on “<em>Publish</em>”.</p><p>But what happens <em>after</em> you click “<em>Publish</em>”?</p><p>Well, you now get our new and automatically generated endpoint page. Ready to share for developers to integrate. With documentation, params and OpenAPI 3.0 compliant specs.</p><p>And the internal version has usage logs and stats: that way you have all the control over how your API endpoints are performing and being used.</p><p>Check out the video below on how to build an API Endpoint out of a large CSV file:</p><figure class="kg-card kg-embed-card"><iframe allowfullscreen="true" frameborder="0" scrolling="no" src="https://www.youtube.com/embed/or6DLJbDi14" title="API Endpoint from CSV File with Tinybird.co"></iframe></figure><p>Want to know more? Here’s the release <a href="https://blog.tinybird.co/2020/08/11/badass-api-endpoint/">blog post</a> and an integration example of the endpoints page for a <a href="https://api.tinybird.co/endpoint/t_7d62fddaf3f945a09a252db2fe9bf414?token=p.eyJ1IjogIjdmOTIwMmMzLWM1ZjctNDU4Ni1hZDUxLTdmYzUzNTRlMTk5YSIsICJpZCI6ICI2N2NkMzU1OC0wYzYzLTQ3NTUtOGZkYS1iYjRhOGZkMWNkMWYifQ.LjwENzRsA2KcVTxybmTo_AR7Y9nnM18FLXssuTrEW-4">COVID-19 API</a>.</p><h3 id="the-latest-stable-version-of-clickhouse">The latest stable version of ClickHouse®</h3><p>Tinybird uses <strong>ClickHouse®</strong> under the covers. You can take advantage of all its mighty analytical capabilities, but we don’t want you to worry about the complexities of managing, maintaining and scaling up an analytical database.</p><p>In that spirit, we recently upgraded to the latest stable version of Clickhouse (20.7.2.30).</p><p>But <strong>what does upgrading ClickHouse® mean to you</strong>? There are a bunch of improvements in the last version, to name a few:</p><ul><li>Performance improvements AKA. <strong>even faster queries!</strong> (<em>up to 2x in some cases</em>), thanks to a new architecture in the query execution system.</li><li>A bunch of new and optimized <strong>geospatial and JSON operators</strong>.</li><li>Lots of enhancements and <strong>bug fixes</strong> (including some of them coming from us 😊): Support for <code>ILIKE</code>, <code>EXPLAIN</code> queries, better integration with S3 and more.</li></ul><figure class="kg-card kg-image-card"><img src="https://tinybird-blog.ghost.io/content/images/2023/09/6253d9c7da7839396cb652e6_clickhouse-version-20-11.png" class="kg-image" alt="ClickHouse® version" loading="lazy" width="1200" height="400" srcset="https://tinybird-blog.ghost.io/content/images/size/w600/2023/09/6253d9c7da7839396cb652e6_clickhouse-version-20-11.png 600w, https://tinybird-blog.ghost.io/content/images/size/w1000/2023/09/6253d9c7da7839396cb652e6_clickhouse-version-20-11.png 1000w, https://tinybird-blog.ghost.io/content/images/2023/09/6253d9c7da7839396cb652e6_clickhouse-version-20-11.png 1200w" sizes="(min-width: 720px) 720px"></figure><h3 id="a-beta-release-of-our-most-powerful-tool-yet">A beta release of our most powerful tool yet</h3><p>As developers and data engineers, we often work collaboratively on data projects. And when we do, we like to use certain things that make us more productive: our text editors of choice, the command line, collaborating over a source code repository and so on.</p><p>You and your team will soon be able to do all of that with Tinybird. All of it thanks to our new Command Line Interface we lovingly call <em>tb</em>.</p><p>It is still in beta, but we and some of our customers are already using it full time. Take a sneak peek at <a href="https://docs.tinybird.co/cli.html">tb’s CLI documentation</a> if you want to get a sense of how it works.</p><h2 id="enhancements"><strong>Enhancements</strong></h2><h3 id="a-better-import-experience">A Better import experience</h3><p>We have improved the reliability of our <a href="https://docs.tinybird.co/api-reference/datasource-api.html">ingestion API</a>. While we summarized most of the enhancements in <a href="https://blog.tinybird.co/2020/08/19/ingestion-improvements/">this blog post</a>, we keep enhancing our Import API, so for instance, we now support CSV files with new lines and our header and type guesser are way more reliable.</p><p>Still having problems importing a datasource for the first time? You can now <a href="https://docs.tinybird.co/api-reference/datasource-api.html#id21">disable type guessing</a> and do the transformations on the fly with pipes and materialized views.</p><figure class="kg-card kg-image-card"><img src="https://tinybird-blog.ghost.io/content/images/2023/09/62567c6441a6f8442da6e5fb_enable-type-guessing-11.png" class="kg-image" alt="Enable type guessing" loading="lazy" width="1200" height="400" srcset="https://tinybird-blog.ghost.io/content/images/size/w600/2023/09/62567c6441a6f8442da6e5fb_enable-type-guessing-11.png 600w, https://tinybird-blog.ghost.io/content/images/size/w1000/2023/09/62567c6441a6f8442da6e5fb_enable-type-guessing-11.png 1000w, https://tinybird-blog.ghost.io/content/images/2023/09/62567c6441a6f8442da6e5fb_enable-type-guessing-11.png 1200w" sizes="(min-width: 720px) 720px"></figure><h4 id="a-more-user-friendly-and-efficient-dashboard">A more user-friendly and efficient dashboard</h4><p>A few months ago we released a <a href="https://blog.tinybird.co/2020/05/07/new-dashboard/">new dashboard</a> to operate with your data and APIs in Tinybird.</p><p>And we continue making it <strong>faster and simpler</strong>. We’ve added literally a B-U-N-C-H of improvements, but find below just some of them:</p><ul><li>A cleaner dashboard: clear out all recent items</li></ul><figure class="kg-card kg-image-card"><img src="https://tinybird-blog.ghost.io/content/images/2023/09/62567c64bdde467dfc19f6af_clear-recent-items-11.png" class="kg-image" alt="Clear recent items" loading="lazy" width="1200" height="400" srcset="https://tinybird-blog.ghost.io/content/images/size/w600/2023/09/62567c64bdde467dfc19f6af_clear-recent-items-11.png 600w, https://tinybird-blog.ghost.io/content/images/size/w1000/2023/09/62567c64bdde467dfc19f6af_clear-recent-items-11.png 1000w, https://tinybird-blog.ghost.io/content/images/2023/09/62567c64bdde467dfc19f6af_clear-recent-items-11.png 1200w" sizes="(min-width: 720px) 720px"></figure><ul><li>More visibility? Collapse the sidebar from a button in the bottom left corner</li><li>Higher productivity with better autocomplete hints</li></ul><figure class="kg-card kg-image-card"><img src="https://tinybird-blog.ghost.io/content/images/2023/09/62567c64cefdecebc922a025_autocomplete-7.gif" class="kg-image" alt="Autocomplete hints" loading="lazy" width="1200" height="400" srcset="https://tinybird-blog.ghost.io/content/images/size/w600/2023/09/62567c64cefdecebc922a025_autocomplete-7.gif 600w, https://tinybird-blog.ghost.io/content/images/size/w1000/2023/09/62567c64cefdecebc922a025_autocomplete-7.gif 1000w, https://tinybird-blog.ghost.io/content/images/2023/09/62567c64cefdecebc922a025_autocomplete-7.gif 1200w" sizes="(min-width: 720px) 720px"></figure><ul><li>All your nodes up to date with node previews directly from the pipe definition</li><li>Faster integration with new code snippets and results preview</li></ul><figure class="kg-card kg-image-card"><img src="https://tinybird-blog.ghost.io/content/images/2023/09/62567c64016f390309aec532_api-endpoint-code-snippets-11.png" class="kg-image" alt="API endpoints code snippets" loading="lazy" width="1200" height="400" srcset="https://tinybird-blog.ghost.io/content/images/size/w600/2023/09/62567c64016f390309aec532_api-endpoint-code-snippets-11.png 600w, https://tinybird-blog.ghost.io/content/images/size/w1000/2023/09/62567c64016f390309aec532_api-endpoint-code-snippets-11.png 1000w, https://tinybird-blog.ghost.io/content/images/2023/09/62567c64016f390309aec532_api-endpoint-code-snippets-11.png 1200w" sizes="(min-width: 720px) 720px"></figure><ul><li>A cleaner workspace with the ability to <a href="https://docs.tinybird.co/api-reference/datasource-api.html#post--v0-datasources-(.+)-truncate">truncate quarantine tables</a></li><li>Always up to date datasource and pipes: now the dashboard makes less parallel requests avoiding blocking the browser network threads</li></ul><h2 id="bug-fixes"><strong>Bug fixes</strong></h2><p>There have been several bug fixes as well. Here are three of them:</p><ul><li>Several fixes in the schema parsing of datasources, to support <code>DEFAULT</code>, <code>CASTS</code> and other symbols.</li><li>Replace with condition and populate now work with data sources that use the <code>Join</code> engine.</li><li>And we fixed the <code>spotlight</code>! Have you tried typing <code>s</code> in the UI?</li></ul><p>Want to be up-to-date with new bug fixes? Keep an eye on our <a href="https://www.tinybird.co/docs/changelog" rel="noreferrer">changelog</a>, which we update on every deploy to production.</p><p>Most of these new features, enhancements and bug fixes are based on the continuous feedback we receive from you, our users, so please keep it coming!</p><p>What are your main challenges when dealing with large quantities of data? <a href="https://www.tinybird.co/survey">Request access to Tinybird</a> and get started with real-time analytics right away.</p><p>‍</p>
