How to add Glue Table with struct type column using Terraform?

Question

I am enabling Athena to query on Cloudtrail s3 logs using Terraform. To do this, I need to create database and tables in Glue Catalog. I am following this link.

In Terraform I am using aws_glue_catalog_table resource. How can I define columns with type struct and Array in terraform file?

I tried defining below ways but did not work.

  resource "aws_glue_catalog_database" "cloud_logs" {
    name = "trail_logs_db"
  }

  resource "aws_glue_catalog_table" "cloud_table" {
    name          = "trail_logs"
    database_name = "${aws_glue_catalog_database.cloud_logs.name}"

    table_type = "EXTERNAL_TABLE"

    parameters = {
      EXTERNAL = "TRUE"
    }

    storage_descriptor {
      location      = "s3://<BUCKET NAME>/AWSLogs/<AWS ACCOUNT ID>/"
      input_format  = "com.amazon.emr.cloudtrail.CloudTrailInputFormat"
      output_format = "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"

      ser_de_info {
        name                  = "trail-logs"
        serialization_library = "com.amazon.emr.hive.serde.CloudTrailSerde"

        parameters {
          serialization.format = 1
        }
      }

      columns = [
        {
          name = "useridentity"
          type = "struct<type:string,
                 principalid:string,
                 arn:string,
                 accountid:string,
                 invokedby:string,
                 accesskeyid:string,
                 userName:string,>"
          comment = ""
        },
        {
          name    = "resources"
          type    = "array<STRUCT<ARN:string,
                    accountId:string,
                    type:string>>"
          comment = ""
        },
      ]
    }
  }

WHen I run terraform init It throws below error: Error: Error parsing test.tf: At 33:27: illegal char

Can you share an [mcve] of your Terraform code and also explain more clearly what you mean by "did not work"? Did it error? If so edit your question to include the full error output. If it did something you were not expecting explain the result of the Terraform code and what you wanted instead. — ydaetskcoR, Jul 22 '19 at 09:44

Neelesh Gurjar · Answer 1 · 2019-07-22T10:31:25.743

1

Found workaround, It does not look good though.

It works when I format it in one line.

  {
     name = "useridentity"
     type = "struct<type:string, principalid:string, arn:string, accountid:string,  invokedby:string, accesskeyid:string, userName:string,>"
      comment = ""
  },
  {
     name    = "resources"
     type    = "array<STRUCT<ARN:string, accountId:string, type:string>>"
     comment = ""
  },

edited Jul 22 '19 at 10:31

answered Jul 22 '19 at 10:26

Neelesh Gurjar

65
1
10

for me the multiline version doesn't work at all. only in a single line, does it accept the resources... – Meike Sep 02 '22 at 13:17
also, for me the type string my not contain any capital letters or spaces. – Meike Sep 29 '22 at 11:27

score 1 · Answer 2 · answered Jul 22 '19 at 19:03

What you want is a heredoc:

    {
          name = "useridentity"
          type = <<- EOT
                 struct<type:string,
                 principalid:string,
                 arn:string,
                 accountid:string,
                 invokedby:string,
                 accesskeyid:string,
                 userName:string,>
                 EOT
          comment = ""
        },
        {
          name    = "resources"
          type    = <<- EOT
                    array<STRUCT<ARN:string,
                    accountId:string,
                    type:string>>
                    EOT
          comment = ""
        },

Thanks @Robert. I tried but it is showing in change in resource.. Expected way --> "array>" Actual ==> "array>\n" — Neelesh Gurjar, Jul 23 '19 at 14:42

How to add Glue Table with struct type column using Terraform?

2 Answers2