Can we create snow pipe for association

Question

ex. The JSON format for snow pipe is as follows:

{
 {
   id:      1, 
   title:   xyz, 
   body:    pqs, 
   table_B: [
              {
                id:       1, 
                comment:  "ptr"
              },
              {
                id:       1, 
                comment:  "LMN"
              }
            ]
 }
}

How do I store this attribute to two different tables on Snowflake using snow pipe:

Snowflake Table A

id | title | body |
-------------------
1. | XYZ.  | PQS. |
-------------------

Snowflake Table B

id | comment | a_id |
---------------------
1. | ptr     | 1    |
---------------------
2. | LMN.    | 1    |
---------------------