When i create a delta table using athena i use:
CREATE EXTERNAL TABLE
silver_amazon.fba_inventory_planning_data
LOCATION 's3://silver-dev/amazon/get_fba_inventory_planning_data/'
TBLPROPERTIES ('table_type' = 'DELTA')
and it fills the schema. But when i use terraform like this:
resource "aws_glue_catalog_table" "silver_amazon_table_get_fba_inventory_planning_data" {
name = "fba_inventory_planning_data"
database_name = aws_glue_catalog_database.silver_db_silver_amazon.name
table_type = "EXTERNAL_TABLE"
parameters = {
"table_type" = "DELTA"
}
storage_descriptor {
location = "s3://${var.s3_silver_bucket_prefix}-${var.execution_env}/amazon/get_fba_inventory_planning_data"
}
}
the schema is empty. Is it necessary to define the schema even if in athena i don’t need to?