sqlp

SQL

Catalog JSON Use

{
  "database": "shop",
  "objects": [
    {"schema": "sales", "name": "orders", "kind": "table", "columns": [
      {"name": "id", "type": "bigint"}, {"name": "customer_id", "type": "bigint"},
      {"name": "created_at", "type": "timestamp"}, {"name": "status", "type": "text"}]},
    {"schema": "sales", "name": "order_items", "kind": "table", "columns": [
      {"name": "order_id", "type": "bigint"}, {"name": "product_id", "type": "bigint"},
      {"name": "quantity", "type": "integer"}]},
    {"name": "products", "kind": "table", "columns": [
      {"name": "id", "type": "bigint"}, {"name": "name", "type": "text"},
      {"name": "price", "type": "numeric(10,2)"}]},
    {"schema": "crm", "name": "customers", "kind": "table", "columns": [
      {"name": "id", "type": "bigint"}, {"name": "name", "type": "text"},
      {"name": "country", "type": "text"}, {"name": "deleted_at", "type": "timestamp"}]},
    {"schema": "crm", "name": "active_customers", "kind": "view", "columns": [
      {"name": "id"}, {"name": "name"}, {"name": "country"}],
     "definition": "SELECT id, name, country FROM crm.customers WHERE deleted_at IS NULL"},
    {"schema": "support", "name": "tickets", "kind": "table", "columns": [
      {"name": "id", "type": "bigint"}, {"name": "customer_id", "type": "bigint"},
      {"name": "opened_at", "type": "timestamp"}]}
  ]
}

Expand views through their definitions

Names as the database stores them. kind: table, view, materialized_view or foreign_table. definition: a view's query. database and schema fill in full names. Your edits are kept in this browser.

Dialect Action or Ctrl+Enter