TL;DR

anecdotes uses Snowflake to store its customers’ data. Each customer has a corresponding database that contains several tables that hold its compliance-related data, collected for customers.

Our CI/CD runs on GitHub Actions, and it contains workflows that assume an empty customer database. For example, we have a customer onboarding workflow, which needs to start with an empty database.

We created a GitHub action that lets us execute SQL queries in our databases, based on Snowflake’s Python connector package.

Recap

What we’re going to cover:

• Overview about creating GitHub actions
• Snowflake’s connector Python library, a short description
• Asynchronous database querying and using…