Prepare your data

This feature is experimental and not ready for use in production. It is only available as part of an Early Access Program, and can go under breaking changes until general availability.

There are a couple of strict requirements for your data to satisfy. This might require a data preparation step on BigQuery side.

The requirements are as follows;

  • Each record that will be mapped to a node, regardless of their source table, requires a globally unique identifier to be specified.

  • Each record that will be mapped to a relationship requires the source and target node identifiers assigned by the previous step.

For our example data, we should have our tables structured similar to the following;

Table 1. User Table
id username name age up_votes node_id

1

john.rowland

John Paul Rowland

25

120

1001

2

brandy.bird

Brandy Bird

42

1

1002

3

tilly

Tilly Symonds

20

0

1003

Table 2. Question Table
id text user_id created view_count node_id user_node_id

1

what is the best city to live in?

2

2023-06-05T23:30:00

5

1004

1002

2

what is the weather like in Malmo in July?

1

2023-05-14T12:20:05

1

1005

1001

Table 3. Answer Table
id text question_id user_id created node_id question_node_id user_node_id

1

London

1

1

2023-06-05T23:35:00

1006

1004

1001

2

New York

1

3

2023-06-06T08:20:05

1007

1004

1003

3

weather is usually nice with winds.

2

2

2023-05-15T14:56:00

1008

1005

1002

Ensure that your data satisfies the above conditions before proceeding with mapping.