Add Create table SQL field to bulk flows

Comments: 1

• 30 Aug, '21
  Olena Sherbinin Admin

  Added to all bulk load flows: snowflake, redshift, greenplum, bigquery, azure synapse, bulk copy
  
  JavaScript only. Example:
  
  importPackage(com.toolsverse.util);
  
  value = Utils.findAndReplace(sql, 'smallint', 'bigint', true);
  
  Available variables:
  
  sql - automatically generated create table SQL
  table - the actual table name in create table, for example abc
  nameAndPrefix - the table name with prefix added by the flow, for example IF EXISTS abc

  Like