Time series zoom reset and other improvements

We've made some improvements to the Time series chart in the Tinybird UI. Now, when you zoom in on a chart, you can reset the zoom by clicking the Zoom reset button next to the granularity selector. This lets you quickly see what is happening in a certain period, zooming in on whatever you need, and then quickly go back to the original view.

We've also improved the general interaction with filters and granularity selectors, making the general user experience more intuitive.

Tinybird Forward - Weekly update

Here's a selection of the weekly updates we post in the #forward channel:

  • We’ve added the tb secret command, which allows you to set secrets in your project that you can use in datafiles.
  • Use tb open to open your workspace in Tinybird Cloud. You can also specify your env using --cloud/--build and pass a specific workspace using the --workspace flag.
  • Tokens with permissions over resources are now tracked and updated in deployments. When you create a deployment using the CLI, tb will output how tokens will be modified alongside all other resources.
  • Added the --user-token global option to all commands, similar to how --token or --host behave. Use it to pass your user token to your tb commands.

Read the blog post and browse the docs to learn more.

S3 connector: Sync now changes

We've adjusted how the Sync now feature works in the new version of the S3 Connector.

Until now, triggering the Sync now for an S3 data source made it perform a complete sync from scratch, which might could result in duplicated records unless the data source was truncated first.

Now, instead of running a complete backfill, the connector just append new files created or updated in the bucket that match the specified file path expression, since the last run, incrementally.

So, in summary, this is how the S3 Connector run modes work:

  • @on-demand: Run the initial backfill. You can always trigger this process manually. Tinybird will detect new and modified files in the bucket that match the filepath expression since the last successful run, and append them.
  • @auto: Besides the initial backfill, Tinybird detects new files uploaded to the bucket, upserts included.

The main difference is whether the incremental append is done automatically or you prefer to trigger it manually.

Deprecating the BigQuery connector

We're announcing the deprecation of the BigQuery connector. Starting March 7th, 2025, you will no longer be able to create new managed BigQuery data sources and connections in Tinybird.

On March 31st, 2025 all existing BigQuery data sources will be unlinked, keeping the records they have in that moment as static data.

Moving forward, the recommended way to ingest data from BigQuery into Tinybird is by using Google Cloud Storage. See Ingest data from BigQuery using Google Cloud Storage to set up this integration. If you have any questions or need assistance, feel free to reach out to us.

Logs explorer template

Build your own real-time logs explorer using Tinybird! Use the logs explorer template to bootstrap a multi-tenant, user-facing logs explorer for any software project. Fork it and make it your own!

Logs explorer template

Improvements

  • Added a new modal to add multiple scopes for a token. You can add multiple pipes and data sources to a token at once, select them all, and add SQL filters only when one READ scope is selected.
  • Added new shortcut to open the spotlight search with Cmd/Ctrl + S and removed the old S command, as it was interfering with the new Time Series shortcuts.

Bug fixed

  • Fixed an error in the Job overview screen when filtering queue jobs.
  • Fixed a bug that prevented indexes from being shown in the UI.
  • Fixed an issue where, if you downloaded or did a tb pull after creating a new data source with INDEXES using a custom schema in the UI, the resulting .datasource file did not contain the INDEXES setting.