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 Configuring ELT Database Accounts 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.
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.