generate_schema_yml.sql

{% macro generate_base_test(relation, primary_key=none) %}

{% set cols = adapter.get_columns_in_table(relation) %}

version: 2

models:
    - name: {{relation.name}}
      description: "Data from {{relation.schema}}.{{relation.table}}."
      columns:
          {% for col in cols %}
          - name: {{ col.name }}
            description: {% if col.name == primary_key -%}
                "The primary key for this model"
            {%- else -%}
                "TODO"
            {%- endif %}
            {% if col.name == primary_key -%}
            tests:
              - unique
              - not_null
            {%- else -%}
            tests: []
            {%- endif %}
        {% endfor %}
{% endmacro %}