Snowflake as Target

General Parameters

  • database – The only appropriate value is target
  • dbtype – The appropriate value is snowflake
  • generatesql – This parameter to identify if database objects are to be created (0 - value, default), or the only SQL script creating the objects to be generated (1 value).

Database Connectivity

  • account – Snowflake Account name
  • region – Snowflake Region name
  • warehouse – Warehouse name
  • dbname – Database name to be connected to
  • user – Database User name
  • password – Database User password

Note – Account name and Region can be easily taken from the Snowflake URL:

Account name and Region