Redshift Schema

materialized

The materialized block describes a materialized view in a database schema.

materialized "name" {
  schema = schema.public
  column "total" {
    null = true
    type = numeric
  }
  ...
}

Attributes

Name	Required	Value
as	true	string
auto_refresh	false	bool
comment	false	string
depends_on	false	List of object references
schema	true	Object reference to schema

Blocks

materialized.column

materialized.column attributes

Name	Required	Value
comment	false	string
null	false	bool
type	true	Column type can be one of: Schema type Raw expression defined with sql("expr")

materialized.column constraints

Constraint	Value
Required	false
Require Name	true
Repeatable	false
Allow unknown blocks	false
Allow unknown attributes	false

materialized.distribution

materialized.distribution attributes

Name	Required	Value
column	false	Object reference
style	false	enum (EVEN, ALL, KEY)

materialized.distribution constraints

Constraint	Value
Required	false
Require Name	false
Repeatable	false
Allow unknown blocks	false
Allow unknown attributes	false

materialized.sort

materialized.sort attributes

Name	Required	Value
columns	false	List of object reference to column
style	false	enum (COMPOUND)

materialized.sort constraints

Constraint	Value
Required	false
Require Name	false
Repeatable	false
Allow unknown blocks	false
Allow unknown attributes	false

Constraints

Constraint	Value
Required	false
Require Name	true
Allow Qualifier	true
Repeatable	false
Allow unknown blocks	false
Allow unknown attributes	false

schema

The schema block describes a database schema.

schema "public" {
  ...
}

Attributes

Name	Required	Value
comment	false	string
name	false	string

Constraints

Constraint	Value
Required	false
Require Name	true
Allow Qualifier	false
Repeatable	false
Allow unknown blocks	false
Allow unknown attributes	false

table

The table block describes a table in a database schema.

table "users" {
  schema = schema.public
  column "id" {
    type = int
  }
  ...
}

Attributes

Name	Required	Value
comment	false	string
schema	true	Object reference to schema

Blocks

table.column

table.column attributes

Name	Required	Value
comment	false	string
default	false	Column default value can be one of: bool string number Raw expression defined with sql("expr")
encode	false	enum (RAW, AZ64, BYTEDICT, DELTA, DELTA32K, LZO, MOSTLY8, MOSTLY16, MOSTLY32, RUNLENGTH, TEXT255, TEXT32K, ZSTD)
null	false	bool
type	true	Column type can be one of: Schema type Raw expression defined with sql("expr")

table.column constraints

Constraint	Value
Required	false
Require Name	true
Repeatable	false
Allow unknown blocks	false
Allow unknown attributes	false

table.distribution

table.distribution attributes

Name	Required	Value
column	false	Object reference
style	false	enum (EVEN, KEY, ALL, AUTO)

table.distribution constraints

Constraint	Value
Required	false
Require Name	false
Repeatable	false
Allow unknown blocks	false
Allow unknown attributes	false

table.sort

table.sort attributes

Name	Required	Value
columns	false	List of object reference to column
style	false	enum (AUTO, COMPOUND, INTERLEAVED)

table.sort constraints

Constraint	Value
Required	false
Require Name	false
Repeatable	false
Allow unknown blocks	false
Allow unknown attributes	false

Constraints

Constraint	Value
Required	false
Require Name	true
Allow Qualifier	true
Repeatable	false
Allow unknown blocks	false
Allow unknown attributes	false

view

The view block describes a view in a database schema.

view "clean_users" {
  schema = schema.public
  column "id" {
    type = int
  }
  ...
}

Attributes

Name	Required	Value
as	true	string
comment	false	string
depends_on	false	List of object references
schema	true	Object reference to schema

Blocks

view.column

view.column attributes

Name	Required	Value
comment	false	string
null	false	bool
type	true	Column type can be one of: Schema type Raw expression defined with sql("expr")

view.column constraints

Constraint	Value
Required	false
Require Name	true
Repeatable	false
Allow unknown blocks	false
Allow unknown attributes	false

Constraints

Constraint	Value
Required	false
Require Name	true
Allow Qualifier	true
Repeatable	false
Allow unknown blocks	false
Allow unknown attributes	false