Pub Sub direct to Big Query using Subscription for nested schema

[sijohnmathew]

Hello Community,

Is it possible to use the Pub Sub Bigquery Subscription to insert data to BigQuery nested Schema like the one below

[
    {
        "name": "id",
        "type": "STRING",
        "mode": "NULLABLE"
    },
    {
        "name": "first_name",
        "type": "STRING",
        "mode": "NULLABLE"
    },
    {
        "name": "last_name",
        "type": "STRING",
        "mode": "NULLABLE"
    },
    {
        "name": "dob",
        "type": "DATE",
        "mode": "NULLABLE"
    },
    {
        "name": "addresses",
        "type": "RECORD",
        "mode": "REPEATED",
        "fields": [
            {
                "name": "status",
                "type": "STRING",
                "mode": "NULLABLE"
            },
            {
                "name": "address",
                "type": "STRING",
                "mode": "NULLABLE"
            },
            {
                "name": "city",
                "type": "STRING",
                "mode": "NULLABLE"
            },
            {
                "name": "state",
                "type": "STRING",
                "mode": "NULLABLE"
            },
            {
                "name": "zip",
                "type": "STRING",
                "mode": "NULLABLE"
            },
            {
                "name": "numberOfYears",
                "type": "STRING",
                "mode": "NULLABLE"
            }
        ]
    }
]

[Eduardo_Ortiz]

Yes, you can send Pub/Sub to insert data into BigQuery using subscriptions, Pub/Sub sends your data as a JSON and BigQuery receives it and pushes it into the table you are using whitin Pub/Sub, you can read more information regarding the use of Pub/Sub subscriptions into BigQuery on the documentation I’m sharing with you, as it explains what you need to do before you make use of this feature and the limitations it has.