Connection-Based Data Layers

Connection-based data layers represent tables and views from your external data sources. They provide a convenient way to catalog and reference the data available through your database connections.

Importing from a data source

To create data layers from a connected data source:

1. Navigate to the Data Layers section
2. Select the option to import from a data source
3. Browse the available catalogs, schemas, and tables
4. Select the tables you want to import
5. The selected tables appear as data layers with their schema information

You can import multiple tables at once to quickly populate your data layer catalog.

Schema information

Each connected data layer automatically includes the schema from the source table:

• Column names - the fields available in the table
• Data types - the type of each column (string, integer, float, date, geometry, etc.)

This schema information helps you understand the structure of the data before writing workflow queries.

Live data reference

Connected data layers point to live data in your external database. They do not store a copy of the data - when a workflow queries a connected data layer, it reads directly from the source database. This means:

• Data is always current when queried
• No synchronization or refresh is needed for the data layer itself
• Query performance depends on your data source's capacity