In this Articlearticle
| Table of Contents | ||||
|---|---|---|---|---|
|
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 AccountAccounts with this database. That way you do not need to configure the database name explicitly in the ELT Snaps that use this account.
...
The Schema Name field is mandatory in ELT Select, /wiki/spaces/DRWIP/pages/1285849103 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.
...