Download the PHP package jfbiswajit/php-bigquery without Composer
On this page you can find all versions of the php package jfbiswajit/php-bigquery. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download jfbiswajit/php-bigquery
More information about jfbiswajit/php-bigquery
Files in jfbiswajit/php-bigquery
Package php-bigquery
Short Description PHP BigQuery for Laravel is a seamless integration package that allows you to harness the power of Google BigQuery in your Laravel applications effortlessly. With a zero-configuration setup, plug and play this library to perform high-speed querying and advanced analytics on large datasets. It comes with easy-to-use Laravel facades and service providers, making interaction with BigQuery a breeze. Leverage the capabilities of Google Cloud BigQuery within your Laravel projects with this user-friendly and powerful package.
License MIT
Informations about the package php-bigquery
PHP BigQuery Package for Laravel
Description
PHP BigQuery is a Laravel package that provides seamless integration with Google BigQuery using the google/cloud-bigquery
library. This package allows you to interact with BigQuery effortlessly and perform various operations on datasets and tables.
Installation
To get started with PHP BigQuery in your Laravel project, follow these steps:
-
Install the package via Composer:
- Generate a service account key for your Google Cloud project. Follow the steps below to create and download the key in JSON format:
Generate Service Key
-
Go to the Google Cloud Console by visiting https://console.cloud.google.com/ and sign in with your Google account.
-
Select the project where your BigQuery data is located from the project selector at the top of the page.
-
In the left-hand menu, click on "IAM & Admin," and then select "Service Accounts" from the sub-menu.
-
Click on the "CREATE SERVICE ACCOUNT" button to create a new service account.
-
Enter a name and description for the service account. Leave the "Service account ID" field as it is, as it will be automatically generated.
-
In the "Role" dropdown, select the appropriate role that grants the service account the necessary permissions to access your BigQuery data. For example, you can choose the "BigQuery User" role for read access to datasets and tables.
-
Click on the "CREATE" button to create the service account.
-
Locate the newly created service account on the "Service Accounts" page. Click on the three dots (vertical ellipsis) to the right of the service account's entry, and then click on "Create key."
-
Choose the "JSON" key type and click on the "CREATE" button. This will download a JSON file containing the service account key to your computer.
- Move the downloaded JSON key file to a secure location in your Laravel project. A common practice is to store it in the "storage" directory with the name "bigquery-credentials.json," but you can choose any suitable location. Just ensure that the file is not publicly accessible on your web server to keep your credentials secure.
Finding Project ID
To find your Google Cloud Project ID, follow these steps:
-
Go to the Google Cloud Console by visiting https://console.cloud.google.com/ and sign in with your Google account.
-
If you are not already in the project, use the project selector at the top of the page to select the project where your BigQuery data is located.
-
After selecting the correct project, you will see the project name displayed in the top-left corner of the Cloud Console.
-
Click on the project name (or the project ID, if it's shown next to the name) in the top-left corner. This will open the project details page.
- On the project details page, you will find the "Project info" section. The "Project ID" will be listed there.
The Project ID is a unique identifier for your Google Cloud project and is used for various purposes, including accessing APIs, managing resources, and setting up credentials like we discussed for BigQuery.
Configuration
Once you have obtained the service account key and the Project ID, you can set the following environment variables in your Laravel project's .env
file:
Usage
With PHP BigQuery integrated into your Laravel project, you can use the package to interact with Google BigQuery and perform various data operations. The package provides an easy-to-use facade to access the functionalities.
For detailed usage and available methods, please refer to the package documentation.
Contribution
Your contributions to this project are highly appreciated. If you encounter any bugs, have feature requests, or want to contribute to the codebase, feel free to submit a pull request or open an issue on GitHub.
License
This package is open-source software licensed under the MIT license.
Author
- Name: Biswajit Biswas
- Email: [email protected]
Thank you for choosing PHP BigQuery for Laravel! We hope this package simplifies your BigQuery integration and data management tasks. If you have any questions or need assistance, please don't hesitate to reach out to the author or the community for support. Happy coding!