To create a schema on an external database:
Click the New button above the list of data schemas and choose Access external data.
Enter a name and a description for the schema and select the external account which will enable connection to the database. This enables access to the list of tables available in the external base. Choose the table which contains the data to be collected.
Click OK to confirm. Adobe Campaign automatically detects the structure of the selected table and generates the logical schema. Please note that Adobe Campaign does not generate links.
Click Save to confirm creation.
With Snowflake, a primary key is mandatory.
The indexes are created automatically when mapping a table (standard or FDA mapping).