by_schema.sql

{% macro bigquery__get_catalog(information_schema, schemas) -%}

    {%- if (schemas | length) == 0 -%}
        {# Hopefully nothing cares about the columns we return when there are no rows #}
        {%- set query = "select 1 as id limit 0" -%}

    {%- else -%}
        {%- set query -%}
            with
                table_shards as (
                    {{ _bigquery__get_table_shards_sql(information_schema) }}
                    where (
                        {%- for schema in schemas -%}
                            upper(tables.dataset_id) = upper('{{ schema }}')
                            {%- if not loop.last %} or {% endif -%}
                        {%- endfor -%}
                    )
                ),
                tables as ({{ _bigquery__get_tables_sql() }}),
                table_stats as ({{ _bigquery__get_table_stats_sql() }}),

                columns as ({{ _bigquery__get_columns_sql(information_schema) }}),
                column_stats as ({{ _bigquery__get_column_stats_sql() }})

            {{ _bigquery__get_extended_catalog_sql() }}
        {%- endset -%}

    {%- endif -%}

    {{ return(run_query(query)) }}

{%- endmacro %}