Looking for an equivalent GoogleCloud tool that can query a compressed CSV prior to decompression. Currently we use Athena for this, but are looking to transition to GoogleCloud. Is there an equivalent tool to Athena's querying of a compressed CSV, within GCP?
You can query compressed CSV files in BigQuery. But, before executing the query, you should ingest the compressed CSV into BigQuery. You can ingest the compressed data from many sources like Google Cloud Storage, local files, Google Cloud Bigtable and Google Drive.
Please let me know if this solution meets your requirements.