* Update GitHub Actions workflow for dbt integration tests
- Renamed the workflow to 'dbt_run_integration_test' for clarity.
- Removed the scheduled cron job to simplify the workflow.
- Updated the job to use a template from FlipsideCrypto for better maintainability.
- Adjusted the command to run integration tests using a selector.
- Enhanced environment handling based on the branch context.
* Update GitHub Actions workflow for dbt integration tests
- Renamed the workflow to 'integration test' for clarity.
- Added support for manual dispatch with environment input.
- Implemented scheduled runs for both hosted and production environments.
- Enhanced job configurations to streamline environment handling and command execution.
- Updated commands to run specific integration tests for better accuracy.
* Update dbt integration test workflow to enhance environment handling
- Modified the warehouse selection logic to include 'workflow_prod' as a valid condition for using 'DBT_CLOUD'.
- Updated the environment assignment to correctly map 'workflow_prod' to 'prod' and 'workflow_dev' to 'dev', improving clarity and functionality in the workflow.
* Update dbt integration test workflow to refine environment conditions
- Adjusted the warehouse selection logic to include 'workflow_dev' alongside 'workflow_prod' for using 'DBT_CLOUD'.
- Enhanced the environment assignment to ensure accurate mapping for 'workflow_dev' and 'workflow_prod', improving the workflow's clarity and functionality.
- Removed the unused external access SQL file to streamline the project structure.
- Updated the S3 express external access integration macro by eliminating unnecessary schema usage.
- Adjusted dependencies in the utils SQL file to reflect the removal of the external access integration.
* Update GitHub Actions workflow to reduce thread count and add extensive API integration documentation
- Changed thread count from 24 to 5 in GitHub Actions workflows for improved performance.
- Added comprehensive README files for various API integrations including Alchemy, NBA All Day, API Layer, Binance, and more.
- Introduced new UDFs and UDTFs for Groq and Slack API integrations, enhancing functionality and usability.
- Implemented tests for new UDFs and UDTFs to ensure reliability and correctness.
- Updated existing UDF definitions and added new tests for enhanced coverage and robustness.
* Refactor Slack UDFs to use webhook secret names and improve error handling
- Updated UDF definitions to replace WEBHOOK_URL and BOT_TOKEN with WEBHOOK_SECRET_NAME for enhanced security.
- Improved error messages for required parameters in the SQL logic.
- Standardized comments for clarity and consistency across UDFs.
- Ensured proper handling of user context for accessing secrets in the vault.
* update test
* fix test
* update slack
* remove test
* fix tests
* fix
* fix test args
* fix
* add .gitignore
* Add Slack Notification Macros and Enhance UDFs
- Introduced a new dbt macro for sending Slack notifications from GitHub Actions with AI-powered failure analysis.
- Added comprehensive README documentation for the new macro, detailing setup, configuration options, and usage examples.
- Implemented a SQL macro to handle Slack message formatting and sending, including support for AI analysis and threading.
- Updated existing UDFs to utilize webhook secret names for improved security and added detailed comments for clarity.
- Enhanced error handling and logging within the macros to ensure robust operation and easier debugging.
* update slack alerts
* update
* remove groq
* Enhance Slack Alert Macros with AI Analysis Features
- Updated README documentation to clarify AI provider options and added new parameters for model selection and custom prompts.
- Modified SQL macros to support the new `model_name` and `ai_prompt` parameters for improved AI analysis capabilities.
- Adjusted UDF signatures and comments to reflect the changes in AI provider functionality and requirements.
- Improved test cases to validate the new features and ensure robust performance of the Slack alert macros.
* update slack_alert
* change secret path to data_platform
* add backward compatibility for udf_api_v2
* revert to Object return type
* update type
* add udf_api_batched
* add makefile & max_batch_rows to dbt vars
* update dev endpoint | add udf_api_batched to _live
* add udf_api_batched to live
* add update inner macros to account for max_batch_rows
* fix pointer to livequery_dev
* add udf_api_batched tests
- Introduced multiple test cases for GET and POST methods, including batch JSON-RPC requests for Solana and Ethereum.
- Ensured assertions validate response status codes and data structure integrity.
- Enhanced coverage for API interactions to improve reliability and robustness of the deployment core.
