Acquire data from tables entity and relation in BigQuery project transporter-demo-388303, import into Ultipa graphset shareholding:
1. Generate sample configuration file
./ultipa-importer --sample
2. Modify configuration file
# Configure data source type
mode: bigQuery
bigQuery:
# string of project id on BigQuery
projectID: "transporter-demo-388303"
# the json file that stores KEY of Service Account used to access the project on BigQuery
cert: "./transporter-demo-388303-fe9e5800c1b8.json"
# Configure Ultipa server
server:
# Ultipa server, use comma ',' to separate multiple server nodes of cluster
host: "192.168.2.149:60075"
username: "admin"
password: "abcd1234"
# Graphset name, or use graphset 'default' by default
graphset: "shareholding"
# The directory of the SSL certificate when both Ultipa server and client-end are in SSL mode
crt: ""
# Configure node data
nodeConfig:
- schema: "human"
sql: "select id, name from entity where type = 1"
properties:
- name: id
type: _id
- name: name
type: string
- schema: "firm"
sql: "select id, name from entity where type = 3"
properties:
- name: id
type: _id
- name: name
type: string
# Configure edge data
edgeConfig:
- schema: "hold"
sql: "select from, to, shareInt from relation where type = 'holding'"
properties:
- name: from
type: _from
- name: to
type: _to
- name: shareInt
type: int32
new_name: share
# Configure global settings
settings:
batchSize: 10000
importMode: insert
# auto-create graph, schema, and properties if not existent
yes: true
3. Execute import
./ultipa-importer --config ./import.sample.bigQuery.yml
projectID
: Create BigQuery project in Google Cloud and acquire project IDcert
: Create Service Account with BigQuery Admin privilege and generate KEY in JSON format