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;
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 |
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 |
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.