Cloud Spanner, interleaved tables and all
Instances, databases and interleaved tables in the tree, grid edits as mutations, query plans and profiles, and query, transaction and lock statistics from SPANNER_SYS.
- Cloud Spanner (GoogleSQL)
- Cloud Spanner (PostgreSQL dialect)
What you get for Google Cloud Spanner
Schema as Spanner sees it
Interleaved tables with their parent and ON DELETE action, interleaved indexes, views, change streams and sequences, with DDL from getDatabaseDdl.
Edits as mutations
Grid edits become update, insert and delete mutations with a check that the key still matches one row.
Plans and profiles
Explain uses query mode PLAN and Explain Analyze PROFILE, with full scans flagged.
Insights
Query, transaction and lock statistics and the oldest active queries from SPANNER_SYS, with Cancel query.
And everything every connection gets
Each database keeps its own tools, and shares one workspace with the others.
- Projects with Development, Staging and Production environments, enforced on every write
- Logs & analytics: the server's log, slow operations by shape and live metrics
- An AI assistant that writes and fixes this family's queries, with your own key
- Read-only connections, typed confirmations and a local audit log
- Saved queries as files in a folder you can put in Git
- Notebooks and charts on live results
Features to look at next
Also in analytics and warehouses: ClickHouse, Snowflake, Google BigQuery.
Your next query deserves a better IDE.
Create a free account, download MotionQL, and paste your Pro key. You'll be querying in under two minutes.