dbschema 0.1.4

Define database schema's as HCL files, and generate idempotent SQL migrations
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

# Materialized View

Defines a materialized view that stores query results.

```hcl
materialized "user_counts" {
  schema    = "public"
  with_data = true
  sql = <<-SQL
    SELECT 1 as id
  SQL
}
```

## Attributes
- `name` (label): view name.
- `schema` (string, optional): schema for the view. Defaults to `public`.
- `with_data` (bool, optional): include `WITH DATA` (default) or `WITH NO DATA`.
- `sql` (string): SELECT statement defining the view.
- `comment` (string, optional): documentation comment.

## Examples

```hcl
materialized "daily_signups" {
  sql = <<-SQL
    SELECT date_trunc('day', created_at) AS day, count(*) AS signups
    FROM users
    GROUP BY 1
  SQL
}
```