Good morning,
We upgraded to 6675 version and are now testing a deployment to snowflake.
The tables based on full load mappings deploy well (with our without simple mode)
When deploying tables who are based on an incremental ODX tabel we recieve an error on the syntax of the usp clean procedure TimeXtender wants to create in Snowflake.
The script TimeXtender creates starts with:
CREATE PROCEDURE "HIST_ETL"."usp_ReaturnTM_DimRentableUnitCommercial_Clean"
:DWBATCHNR INT
WITH RECOMPILE
Snowflake doesn’t expect the : and returns:
Syntax error: unexpected ':'. (line 2)
Is this a known issue and if not, I hope it can be added to the wishlist with TimeXtender features that need to be made available against Snowflake storage.
