Problem with Shopify data connection

Ask the Community
1

I want to integrate my company’s Shopify online store data into AIP. After setting the Shopify plugin in the Data connection app, my sync fails. See error below

Job failed:
Failed during job run

java.lang.RuntimeException: java.lang.Throwable: SQL query must not be blank.
	at com.palantir.magritte.extract2.ExtractRunnable.run(ExtractRunnable.java:102)
	at com.palantir.magritte.cloud.runner.extract.CloudExtractResolver.lambda$resolve$4(CloudExtractResolver.java:131)

I can preview my Shopify data with the “explore source” tab so I am 99% sure my access token is being used successfully.

Any help would be greatly appreciated!

2

What did you set as your egress policy? This is usually the issue with failed data connections. The specific error “SQL Query must not be blank” seems to suggest the Data Connection is not properly querying that database.