AlloyDB for PostgreSQL
AlloyDB for PostgreSQL is a fully-managed, PostgreSQL-compatible database for demanding transactional workloads.
Sources
Sources represent your different data sources that a tool can interact with.
A Source represents a data sources that a tool can interact with. You can define
Sources as a map in the sources section of your tools.yaml file. Typically,
a source configuration will contain any information needed to connect with and
interact with the database.
Tip
Use environment variable replacement with the format ${ENV_NAME} instead of hardcoding your secrets into the configuration file.
sources:
my-cloud-sql-source:
kind: cloud-sql-postgres
project: my-project-id
region: us-central1
instance: my-instance-name
database: my_db
user: ${USER_NAME}
password: ${PASSWORD}
In implementation, each source is a different connection pool or client that used to connect to the database and execute the tool.
Available Sources
BigQuery
BigQuery is Google Cloud’s fully managed, petabyte-scale, and cost-effective analytics data warehouse that lets you run analytics over vast amounts of data in near real time. With BigQuery, there’s no infrastructure to set up or manage, letting you focus on finding meaningful insights using GoogleSQL and taking advantage of flexible pricing models across on-demand and flat-rate options.
Bigtable
Bigtable is a low-latency NoSQL database service for machine learning, operational analytics, and user-facing operations. It’s a wide-column, key-value store that can scale to billions of rows and thousands of columns. With Bigtable, you can replicate your data to regions across the world for high availability and data resiliency.
Cloud SQL for MySQL
Cloud SQL for MySQL is a fully-managed database service for MySQL.
Cloud SQL for PostgreSQL
Cloud SQL for PostgreSQL is a fully-managed database service for Postgres.
Cloud SQL for SQL Server
Cloud SQL for SQL Server is a fully-managed database service for SQL Server.
Dgraph
Dgraph is fully open-source, built-for-scale graph database for Gen AI workloads
HTTP
The HTTP source enables the Toolbox to retrieve data from a remote server using HTTP requests.
MySQL
MySQL is a relational database management system that stores and manages data.
Neo4j
Neo4j is a powerful, open source graph database system
PostgreSQL
PostgreSQL is a powerful, open source object-relational database.
Spanner
Spanner is a fully managed database service from Google Cloud that combines relational, key-value, graph, and search capabilities.
SQL Server
SQL Server is a relational database management system (RDBMS).
SQLite
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.