Troubleshoot the Shopify connector
This feature is in Beta. To use it, a workspace admin must turn on Lakeflow Connect for Shopify from the Previews page. See Manage Databricks previews.
This page describes common errors you might encounter with the managed Shopify connector and how to resolve them.
For general troubleshooting guidance that applies to all managed ingestion pipelines, see Troubleshoot managed ingestion pipelines.
Pipeline fails to authenticate
Cause: Shopify returned an HTTP 401, 402, or 403 response. This usually means one of the following: the Client ID or Client Secret isn't valid, the Shopify app isn't installed on the store, or the store subdomain is incorrect.
Solution:
- Verify that the Store Subdomain, Client ID, and Client Secret in the Unity Catalog connection match the app in your Shopify Dev Dashboard.
- Confirm that the app is installed on the store you want to ingest from.
To retrieve the credentials again, see Configure authentication to Shopify.
App is missing required access scopes
Error message:
Please check that your shopify app has access to the required scopes. See https://shopify.dev/docs/api/usage/access-scopes for more details.
Cause: The Shopify app doesn't have the access scopes that the tables you ingest require.
Solution:
Add the required access scopes to the app version in the Shopify Dev Dashboard, then reinstall the app. For the scopes each table requires, see Required access scopes.
Bulk export could not be created
Error message:
Shopify bulk query could not be created: <error details>
Cause: Shopify rejected the bulk export request that the collection_product and inventory_level tables use. Shopify runs one bulk export per store at a time, so a concurrent export can block a new one.
Solution:
Wait for any other bulk export on the store to finish, then rerun the pipeline. If the error persists, confirm that the app has the access scopes for the affected tables. See Required access scopes.
Shopify API rate limit exceeded
Cause: Shopify returned an HTTP 429 response, or a THROTTLED GraphQL error, because the connector reached the store's API rate limit. Shopify rate limits the GraphQL Admin API by query cost, and the limit depends on your Shopify plan. See the Shopify rate limits reference.
Solution:
The connector waits and retries automatically. If this happens repeatedly, reduce the pipeline's schedule frequency or the number of concurrent pipelines that share the same Shopify store.