Projects
I needed to get the test data from my local database uploaded to BigQuery using the data pipeline tool, but ran into continued trouble getting the cash management service running locally to generate test data. I ended up manually inserting records into the local database, which was time-consuming. I am still waiting on the platform team to review and merge my infrastructure access PR, though it is not urgent.
I discussed public documentation for the Cash Movement Report endpoint with the Insights team and need input from Samy and Laurence on their reservations. I also discovered that the user_id column in the cash_movement table does not have a foreign key constraint to the users table. We should look into adding that constraint to ensure data integrity.
Thomas from Insights left more good feedback on my data pipeline PR, suggesting changes to align it with what we will need for production.
Investigations
I will get to the offline mode cost analysis after finishing the foundational work for the Cash Movement Report.
Journal
With the acceleration of AI tool integration at the company and the apparent need for better documentation and onboarding, I think we could benefit from a workflow that generates documentation for our internal tools as part of the development cycle. This could involve integrating AI tools to produce initial drafts from code comments, commit messages, and other sources. Starting with a pilot in areas where documentation is most lacking or outdated would be a good way to evaluate effectiveness.
Getting a haircut this Friday.