title: Glue Virtual View (terraform created) not appearing in Athena
body: <p>I am trying to use Terraform <code>aws_glue_catalog_table</code> to create a Virtual_View , which I understand, should appear in Athena as a View.</p>
  
  <p>So far my code seems to create a catalog table in Glue, but nothing appears in the Athena Views inventory.</p>
  
  <p>It is hard to know exactly which part is the issue.
  I have tried comparing the generated glue table to an existing one, manually created but of the same specification, but no differences appear in the info shown - but the 'originaltext' part is hard to compare being encoded.</p>
  
  <p>Have tried removing the ser_de_info section, but doesn't seem to make any difference.</p>
  
  <p>Grateful for any hints here !</p>
  
  <p><em>Really not sure why TF doesn't just allow us to submit a simple SQL DDL statement to create these, as this glue method is just too convoluted to make practical sense - declaring columns twice in 2 different formats , encoding script - both just bad</em></p>
  
  <pre><code>resource "aws_glue_catalog_table" "aws_gluetable_getresources_vw" {
      name = "getresources_vw" 
      database_name = "mydatabase" 
      table_type = "VIRTUAL _VIEW"
  
      view_original_text = "/* Presto View: ${base64encode(file("${path.module}/originaltexts/getresources.txt"))} */"
      view_expanded_text = "/* Presto View */" 
  
      parameters = {
          presto_view = "true"
          comment = "Presto View"
      }
  
      storage_descriptor { 
          ser_de_info {
              name = " " 
              serialization_library = " " 
          } 
  
          columns {
              name = "key" 
              type = "string"
          }
          columns {
              name = "value" 
              type = "string"
          }
          columns {
              name = "resourcearn" 
              type = "string"
          }
          columns {
              name = "tags" 
              type = "array&lt;struct&lt;key:string,value:string&gt;&gt;"
          }
           .... more
          }
      }
  }
  </code></pre>
  
  <p><strong>getresources.txt</strong></p>
  
  <pre><code>{
      "catalog":"awsdatacatalog",
      "schema":"mydatabase",
      "columns":[
          {"name":"key","type":"varchar"},
          {"name":"value","type":"varchar"},
          {"name":"resourcearn","type":"varchar"},
          {"name":"tags","type":"array(row(key varchar,value varchar))"},
          {"name":"arn1","type":"varchar"},
          {"name":"arn2","type":"varchar"},
          {"name":"arn3","type":"varchar"},
          {"name":"arn4","type":"varchar"}
      ],
      "originalSql":"SELECT  g.tag.key, g.tag.value, t.resource.resourcearn, t.resource.tags, split_part(t.resource.resourcearn, ':', 1) arn1, split_part(t.resource.resourcearn, ':', 2) arn2, split_part(t.resource.resourcearn, ':', 3) arn3, split_part(t.resource.resourcearn, ':', 6) arn4 FROM  ((ap_ath_meta_use_sbx.getresources h CROSS JOIN UNNEST(h.resourcetagmappinglist) t (resource)) CROSS JOIN UNNEST(t.resource.tags) g (tag))"
  }
  </code></pre>