Connection to Google BigQuery
If you're working with data in Jedox and need to pull information from Google's BigQuery, you're in the right place! In this guide, we'll walk you through how to set up the REST connector in Jedox, authenticate using Google tokens, and pull data from BigQuery.
Why Big Query Uses a Modified JSON Format
Before we dive into the steps, it's good to know why BigQuery uses a slightly different version of JSON. BigQuery expects newline-delimited JSON (NDJSON), where each JSON object is on a separate line. This makes it easier to process large datasets efficiently. If you're preparing data for loading , make sure it's in this format.
For example:
{"id": 1, "name": "Alice"}
{"id": 2, "name": "Bob"}
This is why we can't just use standard JSON where everything is wrapped in one big array.
Step 1: Get Your Google Token for Authentication
To connect Jedox to BigQuery, you need to authenticate using a Google token. Here's how to get it:
Go to the Google Cloud Console https://console.cloud.google.com/.
Navigate...
