Resetting ETL Checkpoint for User Data¶
Use the steps below to reset the ETL checkpoint for user data in Alation Analytics V2 after updating Alation to:
2022.1.4 (or a later patch release of 2022.1 if 2022.1.4 is skipped)
2021.4.10 (or a later patch release of 2021.4 if 2021.4.10 is skipped)
These steps require SSH access to the Alation server.
Alation provides a script for resetting the user ETL checkpoint. Download the Zip file with the script from Alation Community: Reset ETL checkpoint for users in Alation Analytics V2 (requires login to Community).
Extract the script file reset_checkpoint_for_user.py.
Copy the script file to the Alation server. Initially, you can place it into the /tmp directory on the host.
Use SSH to connect to the Alation server.
Copy the reset_checkpoint_for_user.py file to the /tmp directory inside the Alation chroot. For example, if you have it in the /tmp directory on the host, then copy it to the /tmp directory at /opt/alation/alation/data2/tmp/.
sudo cp /tmp/reset_checkpoint_for_user.py /opt/alation/alation/data2/tmp/
Enter the Alation shell:
sudo /etc/init.d/alation shell
Change user to
sudo su alation
Copy the reset_checkpoint_for_user.py file to /opt/alation/django/alation_analytics_v2/one_off_scripts/.
cp /data2/tmp/reset_checkpoint_for_user.py /opt/alation/django/alation_analytics_v2/one_off_scripts/
Navigate to the one_off_scripts directory:
Run the script:
Exit from the Alation shell:
Go to the Alation Analytics V2 Settings page in the Alation user interface and run the ETL.