Create a function that generates SQL for a table definition that can be run in BigQuery

blockchain-etl / ethereum-etl-airflow

Airflow DAGs for exporting, loading, and parsing the Ethereum blockchain data. How to get any Ethereum smart contract into BigQuery https://towardsdatascience.com/how-to-get-any-ethereum-smart-contract-into-bigquery-in-8-mins-bab5db1fdeee

MIT License

409 stars 194 forks source link

Create a function that generates SQL for a table definition that can be run in BigQuery #369

Open medvedev1088 opened 2 years ago

medvedev1088 commented 2 years ago

This will allow validating complex table definitions like these https://github.com/blockchain-etl/ethereum-etl-airflow/commit/ba6235d93c575e9d1958cd1d9c81da00f13cac29 in BigQuery, before a PR is created

sfsf9797 commented 2 years ago

Happy to take on this issue, could you elaborate a bit more on the solution, or can point me to some resources that I can refer to. thanks 🙏