JSON to BigQuery

🚀A few clicks to have your JSON array data from website URL to your BigQuery database

BEFORE

URL with JSON array

🪄AFTER

Table in BigQuery

How to put JSON's data to BigQuery by URL

🚀 Dear Business Leaders,

In today's business landscape, data isn't just a component; it’s the foundation upon which we build our decisions and strategies. It’s the compass that guides us through the operational maze.

The question:

But how do we interpret this data accurately? How do we make it not just numbers and charts, but actionable intelligence that drives results?

The solution

With our revolutionary Cooltables add-on, the answer to your problems is as easy as 1-2-3.

1️⃣ Send your important information housed in JSON to Google BigQuery, handoff is done here.

How?

A) get the URL to your .JSON data file:

https://your-link-to-json-file.json

1

Enter a URL that points to data in a JSON array format.

2

Set BigQuery endpoints:

database
project
set table name

3. Load!

Finally, click the button:

Load my Data to BigQuery

Detailed Instruction

1. Click on the direct link to the Cooltables add-on installation screen.

2. Confirm the installation by clicking on 'Install'.

3. Open the Google sheet where you intend to use the add-on.

4. Click 'Extensions' at the top menu, navigate to 'Cooltables', and then click on 'Show Sidebar'.

5. In the open sidebar, navigate to the 'Add Task' tab.

6. Select 'JSON to BigQuery'.

7. Enter the URL of your JSON file and the details of your Google BigQuery destination, then click 'Run'.

After the task runs successfully, the data from the JSON file will be loaded into your BigQuery. Remember to check the 'Home' tab in the Cooltables add-on for the list of your tasks. You can rename, re-run tasks, and see task statistics.