Hi,
I am attempting to transform the data in the Dataprep tool. I import datasets from BigQuery using BigQuery External connection. After completing all the recipe steps when I run the output, it fails. I opened the ticket with the Trifacta team but got no solution.
Here you can find the issue detail discussed with the Trifacta support team
https://community.trifacta.com/s/question/0D5Do00000OE9dDKAT/getting-error-while-running-the-output-...
https://alteryx.my.site.com/CustomerCasePortal/s/customercases?id=5003n00002fApaTAAS
Error Message :
2023-04-03T13:48:16.604Z: Workflow failed. Causes: S05:PTableLoadTransformBigQuery/BigQueryIO.TypedRead/Read(BigQueryQuerySource)+PTableLoadTransformBigQuery/BigQueryIO.TypedRead/PassThroughThenCleanup/ParMultiDo(Identity)+PTableLoadTransformBigQuery/MapElements/Map+PTableLoadTransformBigQuery/ParDo(CaptureRowCount)+PMapTransform/ParDo(MapFunction)+PMapTransform2/ParDo(MapFunction)+PMapTransform3/ParDo(MapFunction)+PMapTransform4/ParDo(MapFunction)+PMapTransform6/ParDo(MapFunction)+PMapTransform7/ParDo(MapFunction)+PAggregateTransform/Combine.globally(Composed)/WithKeys/AddKeys/Map+PMapTransform8/ParDo(MapFunction)+PAggregateTransform/Combine.globally(Composed)/Combine.perKey(Composed)/GroupByKey+PAggregateTransform/Combine.globally(Composed)/Combine.perKey(Composed)/Combine.GroupedValues/Partial+PAggregateTransform/Combine.globally(Composed)/Combine.perKey(Composed)/GroupByKey/Reify+PMapTransform9/ParDo(MapFunction)+PProfileTransform/CategoricalProfileTransform/ParDo(GetColumnValues)+PProfileTransform/PAggregateTransform/Combine.globally(Composed)/WithKeys/AddKeys/Map+PProfileTransform/CategoricalProfileTransform/Count.PerElement/Init/Map+PProfileTransform/CategoricalProfileTransform/Count.PerElement/Combine.perKey(Count)/GroupByKey+PProfileTransform/CategoricalProfileTransform/Count.PerElement/Combine.perKey(Count)/Combine.GroupedValues/Partial+PProfileTransform/CategoricalProfileTransform/Count.PerElement/Combine.perKey(Count)/GroupByKey/Reify+PProfileTransform/CategoricalProfileTransform/Count.PerElement/Combine.perKey(Count)/GroupByKey/Write+PProfileTransform/PAggregateTransform/Combine.globally(Composed)/Combine.perKey(Composed)/GroupByKey+PProfileTransform/PAggregateTransform/Combine.globally(Composed)/Combine.perKey(Composed)/Combine.GroupedValues/Partial+PProfileTransform/PAggregateTransform/Combine.globally(Composed)/Combine.perKey(Composed)/GroupByKey/Reify+PProfileTransform/PAggregateTransform/Combine.globally(Composed)/Combine.perKey(Composed)/GroupByKey/Write+PAggregateTransform/Combine.globally(Composed)/Combine.perKey(Composed)/GroupByKey/Write+PTableLoadTransformBigQuery/BigQueryIO.TypedRead/PassThroughThenCleanup/View.AsIterable/ParDo(ToIsmRecordForGlobalWindow)+PMapTransform5/ParDo(MapFunction)+PTableStoreTransformGCS/ParDo(CaptureRowCount)+PTableStoreTransformGCS/MapElements/Map+PTableStoreTransformGCS/TextIO.Write/WriteFiles/RewindowIntoGlobal/Window.Assign+PTableStoreTransformGCS/TextIO.Write/WriteFiles/WriteUnshardedBundlesToTempFiles/WriteUnshardedBundles+PTableStoreTransformGCS/TextIO.Write/WriteFiles/GatherTempFileResults/View.AsList/ParDo(ToIsmRecordForGlobalWindow)+PTableStoreTransformGCS/TextIO.Write/WriteFiles/WriteUnshardedBundlesToTempFiles/GroupUnwritten/Reify+PTableStoreTransformGCS/TextIO.Write/WriteFiles/WriteUnshardedBundlesToTempFiles/GroupUnwritten/Write failed., Internal Issue (562678cc9a33ec20): 63963027:24514
DataFlow Job Id:
2023-04-03_06_45_56-9435447789971286171
LinkedIn
Twitter
