u/Calm_mind_21

So I am a fresher data engineer working on a migration project where we are migrating from EXASOL to big query.

we have to convert the lua scripts/information to equivalent stored procedure.

Loading strategy: historical+ incremental.

I am facing issues in doing proper RCA on the mismatched columns that are coming in big query during sit testing.

Some of the scripts are very large and have many dependent tables .

can someone please give me some guidance on how to do proper RCA so I can make my table sit pass .

So I am a fresher data engineer working on a migration project where we are migrating from EXASOL to big query.

we have to convert the lua scripts/information to equivalent stored procedure.

Loading strategy: historical+ incremental.

I am facing issues in doing proper RCA on the mismatched columns that are coming in big query during sit testing.

Some of the scripts are very large and have many dependent tables .

can someone please give me some guidance on how to do proper RCA so I can make my table sit pass .

So I am a fresher data engineer working on a migration project where we are migrating from EXASOL to big query.

we have to convert the lua scripts/information to equivalent stored procedure.

Loading strategy: historical+ incremental.

I am facing issues in doing proper RCA on the mismatched columns that are coming in big query during sit testing.

Some of the scripts are very large and have many dependent tables .

can someone please give me some guidance on how to do proper RCA so I can make my table sit pass .