CREATE TABLE AS SELECT - EMIT CHANGES vs. dont emit changes

[lucasprograms]

The examples in the CREATE TABLE AS SELECT docs all include EMIT CHANGES, but there is not any detail on what that means in this context.

In my local testing, they seem to capture the same data. Since a table is a persistent query regardless, it’s unclear to me what difference EMIT CHANGES makes.

What are the differences between a table that is defined as
CREATE TABLE AS SELECT ... EMIT CHANGES;
vs
CREATE TABLE AS SELECT ...;

Thank you!

[mjsax]

EMIT CHANGES is an optional clause for CTAS and CSAS statement.

[lucasprograms]

@mjsax thank you for the reply. Does that mean that it does not have an effect in CSAS/CTAS?

[mjsax]

Right. For CSAS/CTAS both queries with and without EMIT CHANGES clause are exactly the same.