Deprecated Job Option

This notification concerns jobs writing to data lake tables that include the CREATE_TABLE_IF_MISSING job option.

Dear Upsolver Users,

In an effort to streamline functionality and enhance user experience, we are announcing the deprecation of the CREATE_TABLE_IF_MISSING job option specifically when copying into data lake tables.

This change will take effect two weeks from today.

Affected Target: Data lake tables.

Unaffected Targets: Snowflake and PostgreSQL.

Impact: The CREATE_TABLE_IF_MISSING option will not have any effect when copying into data lake tables. However, it will continue to function as expected when copying into Snowflake and PostgreSQL.

Timeline: The deprecation will be enforced starting December 12, 2023. After this period, attempts to use CREATE_TABLE_IF_MISSING when copying into data lake tables will result in an error.

We recommend reviewing and updating your existing workflows to accommodate this change. If you have any questions or need assistance, please don't hesitate to reach out to our support team.

Thank you for your understanding as we work to improve Upsolver.