> ## Documentation Index
> Fetch the complete documentation index at: https://docs.stigg.io/llms.txt
> Use this file to discover all available pages before exploring further.

# MotherDuck

## Overview

Stigg's integration with MotherDuck allows you to export your product catalog, customer, and subscription data directly to your MotherDuck database for custom reporting and analysis.

<Note>
  Stigg's native data export integrations are included in the Scale plan, and are also available as an optional add-on to the Growth plan. See Stigg's pricing for more details.
</Note>

<Card title="View the full entity schema" icon="sitemap" href="./schema">
  See every table and column exported to your destination, organized by entity group.
</Card>

## Setting up the integration

### Prerequisites

You'll need a MotherDuck account and a database — either an existing one or a new one you create during setup.

<Steps>
  <Step title="Create a database">
    If you don't already have a MotherDuck database you want to use, log in to MotherDuck, click the plus icon next to **Attached Databases**, and enter a name for the new database. Skip this step if you already have one prepared.
  </Step>

  <Step title="Create an access token">
    In MotherDuck, open the navigation dropdown and select **Settings**, then click **Create token**.

    Name the token descriptively and set a token lifetime — a longer lifetime means you won't need to update it as often. Make sure **Token Type** is set to **Read/Write Token**, then click **Generate**.

    Copy the token from the pop-up and store it securely.
  </Step>

  <Step title="Connect Stigg with MotherDuck">
    In [Stigg](https://app.stigg.io/), navigate to **Integrations > Apps > MotherDuck**.

    Enter the following information in the connection form:

    | Field        | Description                                                                                                         |
    | ------------ | ------------------------------------------------------------------------------------------------------------------- |
    | Database     | The name of your MotherDuck database                                                                                |
    | Schema name  | The schema Stigg will sync tables into. It's created automatically on first sync — you don't need to pre-create it. |
    | Access token | The Read/Write access token generated above                                                                         |

    Click **Test & connect**.
  </Step>

  <Step title="Select entities to export">
    After entering your connection details, expand the **Entities to export** section to choose which entity groups to include in the sync. All groups are selected by default.

    See [Exported entities](./overview#exported-entities) for a description of each group.
  </Step>
</Steps>


## Related topics

- [Exported entities](/documentation/importing-and-exporting-data/export/overview#exported-entities.md)
- [Sync process, schedule, manual sync, and sync history](/documentation/importing-and-exporting-data/export/overview#sync-process.md)