Actian Avalanche component release notes

This page lists the main features added to the Actian Avalanche Component.

Changelog

DI-6411: Integration VectorWise template: the insertion of rows in the target table fails when preceded by an update.

DI-5747: The Actian Avalanche component is now available.
DI-6083: The templates have been updated to use the MODIFY…TO COMBINE statement instead of the deprecated CALL VECTORWISE […] COMBINE statement.
DI-6210: The Load BigQuery to Avalanche template now supports using the copy vwload command as an alternative to external tables.

DI-6565: The COPY VWLOAD Strict Nulls parameter has been added to the LOAD BigQuery to Avalanche template. When selected, this parameter makes a distinction between null values and empty values in BigQuery CSV files.

DI-6412: The default value of the Null Value Replacement parameter in the LOAD BigQuery to Avalanche template is null. Due to this, the COPY VWLOAD command fails for date fields.
DI-6436: Existing GCS files from a previous failed extraction job are not deleted when the job is executed again causing data issues like duplicates or invalid data.
DI-6437: The joinPart, groupByPart and havingPart clauses are missing from the SELECT BigQuery source statement.

DI-6565: The COPY VWLOAD Strict Nulls parameter has been added to the LOAD BigQuery to Avalanche template. When selected, this parameter makes a distinction between null values and empty values in BigQuery CSV files.

DI-6412: The default value of the Null Value Replacement parameter in the LOAD BigQuery to Avalanche template is null. Due to this, the COPY VWLOAD command fails for date fields.
DI-6436: Existing GCS files from a previous failed extraction job are not deleted when the job is executed again causing data issues like duplicates or invalid data.
DI-6437: The joinPart, groupByPart and havingPart clauses are missing from the SELECT BigQuery source statement.

DI-6340: The Copy VWLOAD Error Limit and Copy VWLOAD Quote options have been added to the LOAD BigQuery to Avalanche template.
DI-6242: The Copy VWLOAD Error Limit and Copy VWLOAD Quote options have been added to the LOAD RDBMS to Avalanche template.

DI-6322: Avalanche load templates ignore the storage folder and write files in the bucket’s root folder. Morever when the mapping is executed, the clean step fails to delete the temporary files.
DI-6321: In mappings, Avalanche load templates fail to use the alias of the source datastore, thus generating an incorrect query for exporting data.

DI-6210: Template - Load BigQuery to Avalanche: Support using copy vwload command as an alternative to external tables.
DI-6083: Update the templates to use the MODIFY…TO COMBINE statement instead of CALL VECTORWISE […] COMBINE which is deprecated.