dbt archive creates lower case maintenance columns on Snowflake

[clausherther]

Looks like the query to create archive tables for Snowflake is quoted and uses lower case names for the maintenance columns:

create table if not exists archive.my_table_archived (
    
    "MY_COL1" character varying(16777216),
  
    "MY_COL2" character varying(16777216),
  
    "MY_DATE_COL" DATE,
  
    "valid_from" TIMESTAMP,
  
    "valid_to" TIMESTAMP,
  
    "scd_id" character varying(255),
  
    "dbt_updated_at" TIMESTAMP
  
  );

This causes problems when querying the archived tables without using quoted column names:

select * from archive.my_table_archived
where valid_from>='2018-12-03'

[42000][904] SQL compilation error: error line 2 at position 6 invalid identifier 'VALID_FROM'

[clausherther]

FYI, quoting is off in the config:

quoting:
    identifier: false
    schema: false

[drewbanin]

Thanks for the report @clausherther - this is prioritized for our Wilt Chamberlain release. See #251 for more information on the proposed approach