[GCP] How to set up BigQuery

Purpose
BigQuery is Enterprise Data Warehouse and it can process SQL query very rapidly.
In this article, let me explain how to set up BigQuery.
How to set up BigQuery
Firstly, click BigQuery in the GCP management console.
You can see explorer of BigQuery.
Let’s set dataset by clicking Create dataset button.

Input Dataset ID and select Data location.
Then, click CREATE DATASET.

You can see that your dataset is created successfully.
Next, click Open button in your dataset setting.

Your dataset setting is appeared.
And click “+” button.

Next let’s create table for your analysis.
In this case, data prepared as  CSV file is selected and click Create table.

Data in CSV file is imported successfully !!

You can analyze data by executing SQL.
Click QUERY button.

Input SQL as you like and click RUN button.

You can see the result of SQL execution successfully !!

That’s all for this topic. If you think this article is beneficial for me, I would be glad if you click below icon for my motivation.
ブログランキング・にほんブログ村へ

コメント