How to set a default value to a non-nullable column in Database query component- advanced mode select query

Matillion ETL
1

I'm using a database query component and I'd like to mark a few columns which are non-nullable as say N/A or NA ( a default value) in my target table in Snowflake. What should my query look like?

2

Hi @VVeda​,

I might be missing something here but it sounds like you have 1 or more non-nullable columns in the target Snowflake table and for 1 or more of those columns you want to supply something like "N/A" as the value. This should be straightforward by specifying the value in the SELECT statement. As SQL example could be:

SELECT some_col1 as col1, some_col2 as col2, 'N/A' as col3

FROM your_source_table

The idea is that you are always returning N/A for every row returned by the source table for that particular column. I hope I understood your question this helps.

Thanks,

Bryan

3

Thanks Bryan, yes, that is what I did and it did work. I was overthinking and was trying to use a Calculator component. But, as you said, I included the "NA" in my select query and it worked. Thanks for taking the time. It took a few attempts for me to figure out this solution, but glad it worked. Thanks for your response anyways, truly appreciate it.