Best Practices for Using the ELT Snap Pack

In this article

Accounts

Create ELT Accounts in SnapLogic Designer

We recommend that you create ELT accounts directly through the ELT Snaps in SnapLogic Designer since the account configuration is dynamic and the fields change based upon your data source/target. The dynamic fields may not always render correctly when creating accounts in SnapLogic Manager.

Configure the ELT Database Account with the Most-frequently Accessed Database

ELT Snaps use the database provided in the account settings when a database name is not provided in the Snap. If there is a database that you access frequently, then configure the ELT Database Account with this database. That way you do not need to configure the database name explicitly in the ELT Snaps that use this account.

Snaps/Pipeline Design

Follow the Nomenclature in Database, Schema, or Table Names

Always follow the case specifications when manually entering the database, schema, or table names in the ELT Snaps such as ELT Select. For example, if the database name is in lower case, use the same case in the Snap configuration as well. 

Use Snap Suggestions for Schema and Table Names

We recommend that you use the Snap's suggestion button when entering schema and table names to avoid capitalization-related errors that may be encountered if those names are entered using the wrong capitalization manually.

The Snap suggests tables that already exist. Therefore, you cannot use Snap suggestions when creating a new object/table. We recommend that you enter the table's name manually using the standard identifier convention.

Use Standard Identifier Convention for Creating Objects

Always use the standard identifier convention for creating objects in the database. See Names and Identifiers for Redshift and Identifier Requirements for Snowflake.

Use the Correct Schema Name

The Schema Name field is mandatory in ELT Select, ELT Load, ELT Merge Into, and ELT Insert Select. However, you can still enter the schema name in the table name field using the format <schema_name>.<table_name>. When doing so, ensure that the schema name matches the one you provide in the Schema Name field. Else, the Snap fails with undefined errors.