Extract nested JSON objects as String columns¶

Say you have a JSON object like below, with additional_string_data being a nested JSON object:

{
  "client_id": "33333",
  "client_name": "John Doe",
  "additional_string_data": {
    "field_1": "1",
    "field_2": "A"
  }
}

You can now extract the nested JSON object as a String column in your Data Source schema using a JSONPath in the schema, like this:

SCHEMA >
    `client_id` String `json:$.client_id`,
    `client_name` String `json:$.client_name`,
    `additional_string_data` String `json:$.additional_string_data`,

PostgreSQL Table Function available in all AWS regions¶

The PostgreSQL Table Function is now available in all AWS regions. Read the announcement to learn more!

%
SELECT *
FROM 
  postgresql(
    'awesome_postgres.supabase.com:5432',
    'database',
    'table',
    {{tb_secret('pg_username')}},
    {{tb_secret('pg_password')}},
  )
  -- WHERE ... (apply an optional push down filter!)

New API Endpoint limits for Build & Professional plans¶

From 2024-08-12 (August 12th, 2024), all new Workspaces on Build and Professional plans will have a limit of 20 queries per second. This limit doesn't apply to Teams or Enterprise plans. If you are on a Build or Professional plan and are scaling beyond this limit, please reach out to us to discuss your options at support@tinybird.co.

You can read the limits docs to check all platform limits.

Bug fixes and improvements¶

• New tb_env input parameter in CI/CD reference templates and updated documentation on how to run CI/CD over staging and production workspaces.
• Added alter event type in tinybird.datasource_ops_log Service Data Source for tracking Data Sources API > Alter endpoint operations.
• Added a tooltip in the UI when querying a ReplacingMergeTree without using the FINAL on the query to inform the user that they might be getting wrong results. There is a link included in the tooltip to our docs with a deeper explanation about how to query that type of Data Source correctly.
• Added support to POST requests on the "Export csv" feature to handle big queries properly.