PlanetScale integration
Your models, in PlanetScale.
A built-in ingestr destination: load modelled tables into PlanetScale.
name: out.planetscale
type: ingestr
parameters:
source_connection: postgres
source_table: analytics.daily_revenue
destination: planetscale$ bruin run assets/out/planetscale.asset.yml
- extract · postgres analytics.daily_revenue
- load · PlanetScalereplace
Delivered to PlanetScale.
How it connects
Connected in three steps.
PlanetScale is a managed MySQL-compatible database built on Vitess. ingestr supports PlanetScale as both a source and destination through its dedicated psmysql:// scheme. PlanetScale change data capture is also supported, through PlanetScale's hosted psdbconnect API.
- 01
Add a PlanetScale connection.
- 02
Point an ingestion asset at PlanetScale as its destination.
- 03
Bruin loads it on your schedule and checks every load.
Connection parameters
- user
- the user name to connect to the database
- password
- the password for the user
- host
- the PlanetScale database host
- port
- the MySQL protocol port, usually 3306
- database
- the PlanetScale database name (keyspace)
The platform
Part of the Bruin platform.
Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.
01 · Move
02 · Model & govern
03 · Use
Frequently asked
Questions about PlanetScale.
Does Bruin have a built-in PlanetScale integration?
Yes. Built-in ingestr destination.
How fresh is the data?
As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.
Do we need Bruin Cloud?
No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.
Ready to connect PlanetScale?
$100 in credits and 50 AI tasks. No credit card.
A demo walks through your own data.