Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

BigQuery Data transfer from B to A Datastore

Extract data from Project B (Apigee org B) and load or insert into project A (Apigee org A ) with Big query is it possible and how 

curl --location 'https://apigee.googleapis.com/v1/organizations/apigee-nonprod/environments/default-{env}/analytics/e...' \
--header 'Content-type: application/json' \
--header 'Authorization: Bearer ******' \
--data '{
"name": "Export query results to BigQuery",
"description": "BQ Export Job",
"dateRange": {
"start": "2025-01-21",
"end": "2025-01-22"
},
"outputFormat": "csv",
"csvDelimiter": ",",
"datastoreName": "Stage_Datastore"
}'

0 2 142
2 REPLIES 2

Hey @Saidivya, we’ve seen that your question hasn’t gotten a response yet. We’ll keep checking in on this thread and encourage other members to share their thoughts.

Yes you can do an analytics export to bigquery in one project (or also to cloud storage), but there's no way to ingest that export into another apigee org in another project. The exported data can be used with external BI tools or for archival purposes.. What are you trying to do exactly?