Parameters Store

Parameters Store is used to create parameters which can be used in Amorphic ETL Jobs like environment variables.

Create Parameter

You can create new parameter in Amorphic by using the “New Parameter” button in the parameters store listing page.

There are 3 types of parameters:
  • String
  • String List
  • Secure String
There are 2 scopes for parameters
  • Global: Visible to all users and can be used by any user.
  • Private: Visible to only created user and can be used only by the created user.

String

String type parameter is a parameter with key value pair like a general variable. Below are the attributes required to create parameter with ‘String’ type:

  • Parameter Key: Name of the parameter
  • Description: Description of the parameter
  • Parameter Type: Type of the parameter. In this case, String
  • Parameter Value: Value of the parameter. For example, abc
  • Parameter Scope: Scope of the parameter like Global or Private.
Create parameter string

String List

String List type parameter is a parameter with key values pair where one key contains list of values separated by comma. Below are the attributes required to create parameter with ‘String List’ type:

  • Parameter Key: Name of the parameter
  • Description: Description of the parameter
  • Parameter Type: Type of the parameter. In this case, String List
  • Parameter Value: Values for the parameter. In this case, values should be separated by comma (,) For example, abc,string,list,values
  • Parameter Scope: Scope of the parameter like Global or Private.
Create parameter string list

Secure String

Secure String type parameter is a parameter with key value pair where value is securely stored. Below are the attributes required to create parameter with ‘Secure String’ type:

  • Parameter Key: Name of the parameter
  • Description: Description of the parameter
  • Parameter Type: Type of the parameter. In this case, Secure String
  • Parameter Value: Value of the parameter. For example, abc
  • Parameter Scope: Scope of the parameter like Global or Private.
Create parameter secure string

View Parameter

To view the details of a parameter, click the View Details (eye) button of the respective parameter.

All the following parameter details should be displayed with their respective values:
  • Parameter Key
  • Description
  • Parameter Type
  • Parameter Value
  • Parameter Scope
  • Created By
  • Last Modified By
View parameter

Update Parameter

To update a parameter, click the Update parameter (pencil) button of the respective parameter.

Description and Parameter Value of a parameter can be changed.

Update parameter

Delete Parameter

While deleting a parameter, a point to be noted that once the parameter is deleted then all the resources which are using this parameter will be affected. If you want to continue, Please make sure you remove this parameter from all resources.

To delete a parameter, click the Delete parameter (trash can) button of the respective parameter.

Delete parameter

Default System Parameters

Amorphic also provides default system parameters which can be used in the ELT jobs. For example below image shows DLZ bucket name, ETL bucket name etc. which can be used in ELT glue jobs.

Default system parameters