LDW 2.3.17 released: More Snowflake improvements, new Braze and Impact connectors

There are again several Snowflake-related improvements in this release. We disabled the regular keep-alive queries ("SELECT 0"), and improved the performance for writing files to the Azure Blob Storage stage with a multithreaded upload mode.

Significant work was also invested in reworking internal data type mapping. The results will not be directly visible, but eliminate potential data type mismatches of materialized tables during upgrades.

New connectors have been added for Braze and Impact platforms.

Connectors

• SQL-300 (New Feature) Braze connector: create a Braze connector
• SQL-4 (New Feature) Impact connector: create Impact connector
• SQL-306 (Improvement) Facebook connector: modify marketing procedures to not depend on business_management scope
• SQL-124 (Improvement) Microsoft Advertising (Bing Ads) connector: rename redirectUri property for compatibility
• SQL-44 (Improvement) SISTRIX connector: add "country" parameter to Domain and Keyword procedures
• DVCORE-7127 (Improvement) Snowflake: disable keep-alive queries by default
• DVCORE-6782 (Improvement) Snowflake: implement streaming modification of Azure Blob Storage upload mode
• DVCORE-6397 Snowflake: some error messages refer to Redshift limitations instead of Snowflake ones
• DVCORE-7111 Redshift: native calls that cannot run inside a transaction block fail
• DVCORE-7098 BigQuery: table and column descriptions are not imported
• DVCORE-7080 BigQuery: ClientId and ClientSecret properties specified in a connection are not used
• DVCORE-7097 SAP: data is not returned for columns with dots in names
• DVCORE-6881 SQL Server: NUMERIC(4,0) native data type is incorrectly mapped to Data Virtuality SHORT
• DVCORE-6543 PostgreSQL: BLOB columns become VARBINARY upon data source refresh
• DVCORE-7079 Web Service connector: the expirationTimeMilliseconds property is missing in the CLI template

DV Studio

• DVCORE-7123: Remove 'port' field from Snowflake data source wizard
• DVCORE-7062: the description of backup jobs is not updated on refreshing the Jobs tab
• DVCORE-7030: the 'Default connection' does not apply if the 'Save password' checkbox is not set
• DVCORE-7023: 'Edit procedure' creates an incorrect script for some multiline comments
• DVCORE-6236: 'Edit job' on jobs tab fails with an error if the list of data sources is not up-to-date
• DVCORE-5978: pressing 'Apply' in CSV query builder resets 'Limit Rows' field to a wrong value
• DVCORE-3901: modification status of a file loaded into the SQL editor is incorrect after undo operations

Backend

• DVCORE-7086 (Improvement) Implement dynamic type mapping for materialized tables
• DVCORE-7085 (Improvement) Add native data type, precision, scale and length information to SYS.Columns where possible
• DVCORE-7016 (Improvement) Create a translator property to control table names case
• DVCORE-7124: SELECT DISTINCT may produce incorrect result under specific conditions
• DVCORE-7102: Disconnecting JDBC clients can cause a Hibernate error in some cases
• DVCORE-6998: The second run of a CopyOverSQL job fails for DELETE and TRUNCATE clean up methods if useFullSchemaName is set to true
• DVCORE-5888: Numeric data types mapping is inconsistent for various data sources
• DVCORE-5081: CopyOver jobs fail if the target table name begins with an underscore