PHPackages                             valdiney/google-bigquery-service - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [API Development](/categories/api)
4. /
5. valdiney/google-bigquery-service

ActiveClass[API Development](/categories/api)

valdiney/google-bigquery-service
================================

This Service is used to abstrain the use of the BigQuery from Google using php language.

0.0.1(6y ago)031MITPHPPHP >=7.0.0

Since Aug 16Pushed 6y ago1 watchersCompare

[ Source](https://github.com/valdiney/GoogleBigQueryService)[ Packagist](https://packagist.org/packages/valdiney/google-bigquery-service)[ RSS](/packages/valdiney-google-bigquery-service/feed)WikiDiscussions master Synced 2w ago

READMEChangelogDependencies (2)Versions (1)Used By (1)

GoogleBigQueryService
=====================

[](#googlebigqueryservice)

This Service is used to abstrain the use of the BigQuery from Google using php language

### Dependencis

[](#dependencis)

To use this Service you should first install the offial library from Google and our google-bigquery-service:

```
$ composer require google/cloud-bigquery
$ composer require valdiney/google-bigquery-service
```

### Inicial usage

[](#inicial-usage)

To start, you should firts create a dataset and a table:

```
require_once 'vendor/autoload.php';

# Instanciating the object to be used in the our application
# You should pass the path and name of your json file with yours credensials downloaded from google acount
$bigQuery = new GoogleBigQueryService\BigQueryService("AlarmaAe-b01ab0a3aa4c.json");

# Struturing the schema of the table.
$schema = [
	[
	  "name" => "name",
	  "type" => "string"
	],
	[
	    "name" => "age",
	    "type" => "integer"
	]
];

# Creating the dataset and the table
$bigQuery->createSchema("datasetName", "tableName", $schema);
```

### Insert data

[](#insert-data)

after creating the dataset and the table, we ready to insert data:

```
require_once 'vendor/autoload.php';

# Instanciating the object to be used in the our application
$bigQuery = new GoogleBigQueryService\BigQueryService("AlarmaAe-b01ab0a3aa4c.json");

# The name of dataset
$bigQuery->setDatasetId("datasetName");

# The name of table
$bigQuery->setTable("tableName");

# Inserting data in our table. You shoul pass an associative array to the insert method
$bigQuery->insert(["name" => "Nicolas tesla", "age" => 87]);
```

### Selecting data from our table

[](#selecting-data-from-our-table)

To select data is very simple. You just need pass your SQL query to the query method.
 You need pass the especial string "{table} " between the SQL query. This especial string will be repleced into the class in a format that the BigQuery understand!:

```
require_once 'vendor/autoload.php';

# Instanciating the object to be used in the our application
$bigQuery = new GoogleBigQueryService\BigQueryService("AlarmaAe-b01ab0a3aa4c.json");

# The name of dataset
$bigQuery->setDatasetId("datasetName");

# The name of table
$bigQuery->setTable("tableName");

# Your SQL query
$collections = $bigQuery->query("SELECT * FROM {table}");

foreach ($collections as $data) {
    echo "Name: " .$data["name"] . "";
    echo "Age:  " .$data["age"]  . "";
}
```

###  Health Score

20

—

LowBetter than 13% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity3

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity42

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Unknown

Total

1

Last Release

2509d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/3947490?v=4)[Valdiney França](/maintainers/valdiney)[@valdiney](https://github.com/valdiney)

---

Top Contributors

[![valdiney](https://avatars.githubusercontent.com/u/3947490?v=4)](https://github.com/valdiney "valdiney (30 commits)")

---

Tags

bigqueryGoogleBigQuery

### Embed Badge

![Health badge](/badges/valdiney-google-bigquery-service/health.svg)

```
[![Health](https://phpackages.com/badges/valdiney-google-bigquery-service/health.svg)](https://phpackages.com/packages/valdiney-google-bigquery-service)
```

###  Alternatives

[hubspot/api-client

Hubspot API client

24015.5M18](/packages/hubspot-api-client)[pocketmine/bedrock-protocol

An implementation of the Minecraft: Bedrock Edition protocol in PHP

172437.8k11](/packages/pocketmine-bedrock-protocol)[botman/driver-telegram

Telegram driver for BotMan

94452.6k6](/packages/botman-driver-telegram)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)