Skip to content

Storage

Phillip Wong edited this page Nov 30, 2017 · 3 revisions

Storage

keboola_storage_bucket

A storage bucket is an organisational grouping of storage tables.

Example Usage


resource "keboola_storage_bucket" "northwind" {
  name              = "northwind"
  stage             = "in"
  backend           = "snowflake"
}

Argument Reference

  • name - (Required) The name for this storage bucket.
  • stage - (Required) The stage that the storage tables are used in (in | out | sys).
  • backend - (Optional) The backend which the tables in this bucket will be using (snowflake | mysql | redshift).
  • description - (Optional) A description for this bucket. Can include markdown.

Attributes Reference

  • id - The ID for the created storage bucket, in the Keboola format of {in|out|sys}.c-{name}

keboola_storage_table

An individual storage table.

Example Usage


resource "keboola_storage_table" "employees" {
  bucket_id         = "in.c-northwind"
  name              = "employees"
  columns           = [
    "EMPLOYEE_ID",
    "FIRST_NAME",
    "LAST_NAME",
    "TITLE"
  ]
  primary_key       = [
    "EMPLOYEE_ID"
  ]
  indexed_columns   = [
    "EMPLOYEE_ID"
  ]
}

Argument Reference

  • bucket_id - (Required) The ID for the bucket that contains this storage table.
  • name - (Required) The name for this storage table.
  • columns - (Optional) A list of names for the columns contained in this storage table.
  • primary_key - (Optional) A list of the columns that together form the primary key for this storage table.
  • indexed_columns - (Optional) A list of the columns which will be indexed in this storage table.
  • delimiter - (Optional) The delimiting character used to determine where column data starts and ends.
  • enclosure - (Optional) The character used to mark enclosed data. I.e. where a string value begins and ends.

Attributes Reference

  • id - The ID for this storage table, in the Keboola format of {bucket_id}.{name}.