+2I have noticed some views used for data sources (Parquet Files) get delivered without any row data once they land in our ADLS gen2 storage. CUSTOMER_ORDER, PURCHASE_ORDER for example. Other views work absolutely fine - seems to be hit or miss. Does anyone have any idea why that would be the case? I copy the query used by the data pump job into a quick report, and it returns data just fine.
Is there a specific account running the job that I can check/update its permissions?
Best answer by kieranb
+3Hi Kieranb,
The data pump is using the ifsinfo account. If the account does not have ‘select grants’, then an error will be logged in the logs. I have not seen this behavior before. Are there no errors logged? Can you try to load only a couple of columns from that data source, to see if it’s maybe an issue with some type of data being written?
+2Thanks Edgar. No errors logged (image attached). It marks them as successful. I tried to load only a few columns (even just one) and its the same result.
+2
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
