Repository files navigation

This demo is part of a larger Flat Data project created byGitHub OCTO. Read more about the projecthere.

This repository uses aFlat Data Action to query a SQL database with flight data and downloads the data as a CSV file every day at 6am UTC. A SQL connection string has to be added to the GitHub repository as a secret.

Inside.github/workflows/flat.yaml:

-name:Fetch datauses:githubocto/flat@v3with:sql_connstring:${{ secrets.CONNSTRING }}# a SQL database connection string fetched as a GitHub secretsql_queryfile:query.sql# a file with the SQL querydownloaded_filename:sql-data.csv# should be a csv or json

MIT