Defining columns with spaces

[simonp92]

Is your feature request related to a problem? Please describe. Is there a way to define columns including spaces in the name? I see that the Object identifiers in SnowDDL slightly differ from the ones defined in Snowflake, and SnowDDL does not seem to allow for spaces in column names by using quotes around identifiers.

The problem I have is that some of my source systems have columns including spaces, and to be able to easily set up a COPY INTO flow to populate the raw layer, I want to model my raw tables with the same column names as they have in the source system. In snowflake this is possible by doing

CREATE TABLE EXAMPLE ( "MY COLUMN" NUMBER(38,0) )

Is there a way to do this currently using SnowDDL?

Describe the solution you'd like I would like to be able to define table columns with names including spaces, or if this there is another way to solve this using SnowDDL some hints on how to appraoch this

Describe alternatives you've considered If it is not possible to use spaces, then some column mapping will have to be done during the source data load.

Additional context

Here is the link to the Snowflake identifier requirements: https://docs.snowflake.com/en/sql-reference/identifiers-syntax Here is the link to SnowDDL identifier requirements: https://docs.snowddl.com/guides/object-identifiers