← Back to Changelog

August 9, 2024

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 does not 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