Dandandan / dbt-athena

dbt adapter for Athena
Apache License 2.0
39 stars 9 forks source link

Error while generating docs #10

Closed Dandandan closed 4 years ago

Dandandan commented 4 years ago

dbt docs generate --profiles-dir=./ Running with dbt=0.15.1 Found 21 models, 0 tests, 0 snapshots, 0 analyses, 128 macros, 0 operations, 0 seed files, 0 sources

17:47:03 | Concurrency: 20 threads (target='xxx') 17:47:03 | 17:47:03 | Done. 17:47:03 | Building catalog Encountered an error: Runtime Error SYNTAX_ERROR: line 38:19: Column 'table_schema' is ambiguous

Dandandan commented 4 years ago

2020-01-20 19:45:20,818725 (MainThread): Error while running: select * from (

    (
        with tables as (

            select
                table_catalog as "table_database",
                table_schema as "table_schema",
                table_name as "table_name",
                table_type as "table_type",
                null as "table_owner"

            from awsdatacatalog.INFORMATION_SCHEMA.tables

        ),

        columns as (

            select
                table_catalog as "table_database",
                table_schema as "table_schema",
                table_name as "table_name",
                null as "table_comment",

                column_name as "column_name",
                ordinal_position as "column_index",
                data_type as "column_type",
                null as "column_comment"

            from awsdatacatalog.INFORMATION_SCHEMA.columns

        )

        select *
        from tables
        join columns using ("table_database", "table_schema", "table_name")
        where "table_schema" != 'information_schema'
        order by "column_index"
    )

)
Dandandan commented 4 years ago

Added a fix.