Athena iceberg tables have trailing slash in s3 path

[romanperesypkin]

dlt version

0.4.8

Describe the problem

Athena code to create table_prefix for iceberg table has trailing slash which leads to a path like s3://*/_dlt_version//metadata.

Here is the query DLT generates to create _dlt_version.

CREATE TABLE `bronze_facebook`.`_dlt_version`
(
    `version` bigint,
    `engine_version` bigint,
    `inserted_at` timestamp,
    `schema_name` string,
    `version_hash` string,
    `schema` string
)
LOCATION 's3://data-bronze-bucket/facebook/bronze_facebook/_dlt_version/'
TBLPROPERTIES ('table_type'='ICEBERG', 'format'='parquet');

That tiny slash at the end of _dlt_version causes all the problems when DLT tries to write any data to the table

Expected behavior

DLT removes trailing slash for Athena iceberg tables

Steps to reproduce

Just create simple source with resource which writes to Athena

Operating system

Linux

Runtime environment

Airflow

Python version

3.11

dlt data source

No response

dlt destination

AWS Athena / Glue Catalog

Other deployment details

No response

Additional information

No response

[romanperesypkin]

Seems like we have either to add a 'simple' fix to remove trailing slash directly to create statement or update path_utils.get_table_prefix_layout function to be smart enough