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.
- 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.
See the following docs:
-
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.