BigQuery

Ktx is an open-source executable context layer designed to improve data agent reliability by addressing SQL accuracy issues. It combines Markdown wiki pages for business context and YAML files for queryable definitions, supporting warehouses like BigQuery and Snowflake. The tool aims to resolve common errors like stale data references and incorrect join logic.

A data scientist needs Ethereum and Solana data for a research project and is looking for an easy way to get the data into BigQuery. The scientist wants to avoid spending time on infrastructure and is willing to pay for the data. The goal is to obtain standard tabular data such as transactions, transfers, and balance updates.

A data science enthusiast is seeking affordable historical trade data for Pump.fun and PumpSwap, specifically looking for decoded trade instructions and post-graduation trades. The individual has tried various sources, including BigQuery and public RPCs, but found them to be expensive or rate-limited. They are now reaching out to the community for help.

The Solana Foundation has launched Pay.sh in collaboration with Google Cloud, allowing agents to discover and pay for APIs using stablecoins on Solana. This partnership enables machine-native commerce without accounts or subscriptions. Developers can access a unified marketplace of API endpoints from Google Cloud and community APIs.

The user seeks a scalable solution to load 2+ years of Solana SPL and SOL transfer data into Snowflake or BigQuery for compliance analytics. Current methods like GraphQL pagination are inefficient, and running a Solana archive node is deemed too resource-intensive. The user is inquiring about vendors that provide historical transfer data as partitioned Parquet files via S3.

Rocky is a Rust-based SQL engine control plane for warehouse pipelines, offering features like branches, replay, column-level lineage, and governance. It integrates with Databricks, Snowflake, and BigQuery, emphasizing compile-time types, cost attribution, and schema-grounded AI. The tool is open-source under Apache 2.0.