dbt schema.yml generator query using the information_schema of the generated tables for BigQuery

bigquery_schema_generator.sql

WITH
  columns AS (
  SELECT
    "      " || "- name: " || column_name || "\n" ||
    "      " || '  description: "' || column_name || '"' AS column_statement,
    table_name
  FROM
    `rj-smtr.veiculo`.INFORMATION_SCHEMA.COLUMNS ),
  tables AS (
  SELECT
    table_name,
    "  - name: " || table_name || "\n" || 
    '    description: "' || table_name || '"\n' || 
    "    columns:\n" || STRING_AGG(column_statement, "\n") AS yml_file
  FROM
    columns
  GROUP BY
    table_name
  ORDER BY
    table_name )
SELECT
  "version: 2\n" || 
  "\n" || 
  "models:\n" || 
  STRING_AGG(yml_file, "\n") AS yml_file
FROM
  tables