Shopify Query authentication guide🔗

Use this guide to acquire credentials for authorizing the Shopify Query component in Matillion ETL. This process involves creating an app in the Shopify Dev Dashboard. Refer to your Shopify administrator for more information.

The Shopify Query connector uses a Shop URL and the Secret from the Shopify Dev Dashboard Credentials section for authentication. The Secret is entered in the Password property.
You need an active MyShopify shop to source data from.
While connector properties may differ between cloud data warehouses, the authentication process remains the same.

Obtain Shopify credentials🔗

Refer to Create apps using the Dev Dashboard on the Shopify documentation site to create an app and obtain your credentials.

Configure the Shopify Query component🔗

Navigate to your Shopify Query component in Matillion ETL.
In the Shop URL dialog, paste your organization's Shopify Shop URL and click OK.
Click the three dots ... next to the Password property.
In the Password dialog, click Manage to create a new password entry in Manage Passwords. Then select your entry from the Use Password Manager drop-down and click OK.

The connector should now be authenticated. If it isn't, verify that the Shop URL and Password properties were entered correctly.