Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Create/Replace Table Component

Hi,

how can I set columns nullable or not not nullable using Create Table component? Or what is the best way to set columns nullable or not nullable using Matillion?

Thank you!

Br,

Paula

2 Community Answers

Matillion Agent  

Paul Johnson —

Hi Paula,

The Create Table component does not currently support not null constraints. The best way to achieve this is to use the DDL SQL Script component.

I will raise this as a feature request as I agree it would be handy in the Create Table metadata screen.

Regards,
Paul


Matillion Agent  

Paul Johnson —

Hi Paula,
I thought I would come back to you and say that this feature is now in the product as of version 1.34 as a direct result of your suggestion!

Thank you for helping improve our product.
Regards,
Paul

Post Your Community Answer

To add an answer please login