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.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.
View the full entity schema
See every table and column exported to your destination, organized by entity group.
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.1
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.
2
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.
3
Connect Stigg with MotherDuck
In Stigg, navigate to Integrations > Apps > MotherDuck.Enter the following information in the connection form:
Click Test & connect.
4
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 for a description of each group.