---
title: 'Extract JSON objects as String columns'
excerpt: "You can now extract nested JSON objects in NDJSON Data Sources, the new PostgreSQL Table Function is available in all AWS regions, new limits apply to Build & Pro plans, plus fixes!"
date: '2024-08-09'
---

# Extract nested JSON objects as String columns

Say you have the following JSON object, with `additional_string_data` being a nested JSON object:

```json
{
  "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:

```tb
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](https://www.tinybird.co/blog-posts/postgresql-table-function-announcement) to learn more!

```sql
%
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 12, 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, reach out to us to discuss your options at [support@tinybird.co](mailto:support@tinybird.co).

You can read the [limits docs](/forward/pricing/limits) to check all platform limits.

## Bug fixes and improvements

- New `tb_env` input parameter in [CI/CD reference templates](https://github.com/tinybirdco/ci/releases/tag/v4.1.0) and updated documentation on [how to run CI/CD over staging and production workspaces](/classic/work-with-data/organize-your-work/staging-and-production-workspaces).
- Added `alter` event type in [tinybird.datasource_ops_log](/forward/monitoring/service-datasources#tinybird-datasources-ops-log) Service Data Source for tracking [Data Sources API > Alter endpoint](/api-reference/datasource-api#post--v0-datasources-(.+)-alter) 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](/classic/work-with-data/strategies/deduplication-strategies#use-the-replacingmergetree-engine) 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.