dbt-data-reliability/macros/utils/table_operations/get_relation_max_length.sql at e6072fa92eb2de1b0f3bfe273d17a4663c53c61b · elementary-data/dbt-data-reliability · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
{# We create tables and some databases limit the length of table names #}
{% macro get_relation_max_name_length() %}
    {{ return(adapter.dispatch("get_relation_max_name_length", "elementary")()) }}
{% endmacro %}

{% macro default__get_relation_max_name_length(temporary, relation, sql_query) %}
    {{ return(none) }}
{% endmacro %}

{% macro snowflake__get_relation_max_name_length(temporary, relation, sql_query) %}
    {{ return(255) }}
{% endmacro %}

{% macro redshift__get_relation_max_name_length(temporary, relation, sql_query) %}
    {{ return(125) }}
{% endmacro %}

{% macro postgres__get_relation_max_name_length(temporary, relation, sql_query) %}
    {{ return(63) }}
{% endmacro %}

{% macro spark__get_relation_max_name_length(temporary, relation, sql_query) %}
    {{ return(127) }}
{% endmacro %}

{% macro fabricspark__get_relation_max_name_length(temporary, relation, sql_query) %}
    {{
        return(
            elementary.spark__get_relation_max_name_length(
                temporary, relation, sql_query
            )
        )
    }}
{% endmacro %}

{% macro athena__get_relation_max_name_length(temporary, relation, sql_query) %}
    {{ return(255) }}
{% endmacro %}

{% macro trino__get_relation_max_name_length(temporary, relation, sql_query) %}
    {{ return(128) }}
{% endmacro %}

{% macro clickhouse__get_relation_max_name_length(temporary, relation, sql_query) %}
    {{ return(128) }}
{% endmacro %}

{% macro dremio__get_relation_max_name_length(temporary, relation, sql_query) %}
    {{ return(128) }}
{% endmacro %}

{% macro vertica__get_relation_max_name_length(temporary, relation, sql_query) %}
    {{ return(128) }}
{% endmacro %}

{% macro fabric__get_relation_max_name_length(temporary, relation, sql_query) %}
    {# SQL Server / Fabric limits identifiers to 128 chars.  dbt-sqlserver
       may prefix the schema name onto the table identifier when creating
       relations, so we must reserve room for the full schema + separator.
       Typical CI schema is ~60 chars; 128 - 60 - 1 = 67.  We use 60 to
       leave headroom for longer schemas and __dbt_tmp_vw suffixes. #}
    {{ return(60) }}
{% endmacro %}