README.md

Google Cloud BigQuery: BigQuery SQL Repository

Project Summary

This project contains SQL scripts for creating and managing BigQuery tables, views, and other objects. It is intended to be used as a repository for storing and sharing SQL code across multiple projects.

Development Stack

Cloud Stack (GCP)

• Cloud IAM: Identity and Access Management (IAM) service provided by GCP for managing user access to cloud resources.
• BigQuery: Fully managed, serverless data warehouse provided by GCP for storing and analyzing large datasets.

Continuous Integration and Continuous Deployment (CI/CD, DevOps)

Contributing

See the following docs:

• Contributing Guide
• Code Of Conduct

Project Highlights:

• Modular Architecture: Separation of SQL files and execution scripts for easier maintenance and updates.

• Automated SQL Execution: GitHub Actions workflows to automatically execute SQL scripts on BigQuery based on defined triggers.

• Configuration Management: Use of environment variables and configuration files for managing execution parameters and credentials.

• CI/CD Pipelines: Automated build, test, and deployment processes using GitHub Actions to keep SQL scripts up-to-date.

• Comprehensive Documentation: Detailed documentation including installation instructions, usage examples, and troubleshooting guides.