How to install BigQuery in PostgreSQL

Why How to install BigQuery in PostgreSQL is important

-- 1. Install extension
CREATE EXTENSION IF NOT EXISTS bigquery_fdw;

-- 2. Link to the BigQuery ecommerce dataset
CREATE SERVER gcp_bigquery
  FOREIGN DATA WRAPPER bigquery_fdw
  OPTIONS (
    project 'galaxy-shop',
    dataset 'ecommerce'
  );

-- 3. Authenticate with a service-account key
CREATE USER MAPPING FOR CURRENT_USER
  SERVER gcp_bigquery
  OPTIONS (
    service_account '/var/secrets/galaxy-bq.json'
  );

-- 4. Import the BigQuery Orders table
IMPORT FOREIGN SCHEMA ecommerce
  LIMIT TO (Orders)
  FROM SERVER gcp_bigquery
  INTO public;

-- 5. Join BigQuery Orders with local Customers table
SELECT c.name,
       o.order_date,
       o.total_amount
FROM Customers c
JOIN Orders o ON o.customer_id = c.id
WHERE o.order_date >= CURRENT_DATE - INTERVAL '30 days';

CREATE EXTENSION IF NOT EXISTS bigquery_fdw [WITH VERSION version] [CASCADE];

-- Example full workflow
CREATE SERVER gcp_bigquery
  FOREIGN DATA WRAPPER bigquery_fdw
  OPTIONS (
    project 'my-gcp-project',
    dataset 'ecommerce'
  );

CREATE USER MAPPING FOR CURRENT_USER
  SERVER gcp_bigquery
  OPTIONS (
    service_account '/var/secrets/bq-sa-key.json'
  );

IMPORT FOREIGN SCHEMA orders
  FROM SERVER gcp_bigquery
  INTO public;