> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.blab.co/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Dynamic Content: External Collections

External collections can serve as a collection allowing you to create Dynamic Pages (see [Dynamic Content: Dynamic Pages](https://intercom.help/book-like-a-boss/en/articles/10386157-dynamic-content-dynamic-pages)) as well as enhance regular pages. Using a collection on a regular page is similar to how *Connected Data* is used with the site's Business Info (see [Dynamic Content: Collections for Regular Pages](https://intercom.help/book-like-a-boss/en/articles/10378984-dynamic-content-collections-for-regular-pages)). For more information on *Connected Data* with Business Info, see [Dynamic Content: Business Info, Text, and Images](https://intercom.help/book-like-a-boss/en/articles/10379001-dynamic-content-business-info-text-and-images).

# Limitations and Specifications per Collection Type

|  | Internal Collections | Google Sheets | Airtable | External |
| ---- |
| Collection Number per Site | 100NoteLegacy Pro and Team plans are limited to 1 | 100 | 100 | 100 |
| A single collection's data | N/A | 20MB | 20MB | 20MB |
| Rows | 500NoteLegacy Pro and Team plans are limited to 10 | N/A | N/A | N/A |
| Fields (columns) | 50 | 100 | 100 | 100 |
| Collection name character limit | 50 | 50 | 50 | 50 |
| Field name character limit | 50 | 50 | 50 | 50 |
| Page item URL character limit | 350 | 350 | 350 | 350 |
| Text field character limit | 5000 | N/A | N/A | N/A |
| Inner collection Rows | Not supported | Not supported | Supported | N/A |
| Image Collection | Supported | N/A | N/A | N/A |
| Update data | Site/content library publish | Automatically | Automatically every hour | Automatically |

# Connect to an External Database

To connect to an external database:

1. In the left panel, click **Content**, and then click **Collections**.
2. Click **+ New Collection**, and select **External Database**.
3. Type the **Endpoint URL** and click **Fetch collection**.
4. Click **Continue**.
5. Type a name for the collection.
6. Select the correct data type for each field in the collection.
7. *(Optional)* Add additional fields.
8. Click **Continue**.
9. Import the collection.

**Note**

You can use multi-language content from a single external collection using the API.