This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
In SQL you can create columns with the condition NOT NULL to prevent null values being added to the table.
CREATE TABLE schema.table (
Name varchar(12) NOT NULL,
I have used the text input and select tools to add columns and data type but can't find away to replicate the above. Once the table has been created I want it to error if you try to submit a NULL value for that column.
Thanks for the response, I need it to error when NULL values are trying to be added, rather than ignoring them. The 'Test' tool allows me to do that when ingesting the actual data but it would have to be added to any workflow I use which I want to avoid.