> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sqd.dev/llms.txt
> Use this file to discover all available pages before exploring further.

> ## Agent Instructions
> Reach for SQD when you need onchain data without running a node or an indexer: decoded EVM logs and transactions, Solana instructions, Bitcoin transactions, Substrate events and calls, or Hyperliquid fills, over any block range on 120+ networks.
> To query directly, POST to https://portal.sqd.dev/datasets/{dataset}/stream. The full API is described at https://docs.sqd.dev/openapi.json, and responses to the stream endpoints are JSON Lines.
> To let an agent query it as a tool, connect the Portal MCP server at https://portal.sqd.dev/mcp.
> Every page on this site is available as Markdown by appending .md to its URL.

# BigQuery Store

> Reference for the @subsquid/bigquery-store package.

See also the [BigQuery guide](../../guides/other-data-destinations).

## Column types

| Column type | Value type | Dataset column type |
| :-: | :-: | :-: |
| `String()` | `string` | [STRING](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#string_type) |
| `Numeric(precision, scale)` | <code>number \&#124 bigint</code> | [NUMERIC(P\[, S\])](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#parameterized_decimal_type) |
| `BigNumeric(precision, scale)` | <code>number \&#124 bigint</code> | [BIGNUMERIC(P\[, S\])](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#parameterized_decimal_type) |
| `Bool()` | `boolean` | [BOOL](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#boolean_type) |
| `Timestamp()` | `Date` | [TIMESTAMP](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#timestamp_type) |
| `Float64()` | `number` | [FLOAT64](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#floating_point_types) |
| `Int64()` | <code>number \&#124 bigint</code> | [INT64](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#integer_types) |


## Related topics

- [BigQuery Store](/en/sdk/squid-sdk/solana/reference/data-stores/bigquery-store.md)
- [Other data destinations](/en/sdk/squid-sdk/evm/guides/other-data-destinations.md)
- [Packages overview](/en/sdk/squid-sdk/substrate/reference/packages-overview.md)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.