Hi,
Has anyone managed extract data from mongodb and loaded into bigquery or postgres?
I always get an schema error: Empty schema specified for the load job. Please specify a schema that describes the data being loaded.\n']
This is from my catalog.json file
"tap_stream_id": "access_providers-gr_notifications",
"schema": {
"type": "object"
}
},
{
"table_name": "charges_with_grsync",
"stream": "charges_with_grsync",
"metadata": [
{
"breadcrumb": [],
"metadata": {
"table-key-properties": [
"_id"
],
"database-name": "access_providers",
"row-count": 134266,
"selected": true,
"replication-method": "FULL_TABLE",
"is-view": false,
"valid-replication-keys": [
"_id",
"status",
"providerid"
]
}
}
],
Will I have to specify the full schema or what should I do next to load the data?